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 1000 Users.DisplayName, Users.Reputation, count(*) 
from Posts inner join Users on Posts.OwnerUserId = Users.Id
where PostTypeId = 1 and Posts.CreationDate > '2019-01-01'
group by Users.DisplayName, Users.Reputation, OwnerUserId 
order by count(*) desc, Users.DisplayName, Users.Reputation;

fork query

created may 28 anonymous