0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

select top 10 U.Id, U.DisplayName, count(P.Id) as Answers
from Users as U
 inner join Posts as P
  on P.OwnerUserId = U.Id
   and P.PostTypeId = 2  -- Answers only
where U.Id = 16766
group by U.Id, U.DisplayName
order by Answers desc

fork query

edited mar 16

created mar 16 anonymous