Top 10 Responders

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

select top 10 U.id,
       U.DisplayName,
       count(1)
       from Users U
       inner join Posts p
         on p.OwnerUserId = U.id
         and p.PostTypeId = 2
       group by 
           U.id,
           U.DisplayName
       order by 3 desc;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results