0

Please login or register to vote for this query.

(click on this box to dismiss)

Does not count self-answers. Shows users with at least @MinAnswers answers.

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

(select u.id, u.displayname, count(p.posttypeid) as answ,count(p.AcceptedAnswerId) as goodansw from
posts as p
join users u on u.id=p.OwnerUserId
group by u.id, u.displayname)
--having p.posttypeid=2 and count(p.posttypeid>20))

fork query

edited nov 25 21 anonymous

created may 27 10 interjay