0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

SELECT p.OwnerUserId AS [User Link], COUNT(*)
  FROM ReviewTasks AS r
  INNER JOIN Posts AS p ON r.PostId = p.Id
  WHERE r.ReviewTaskTypeId = 4 -- First Post
    AND p.OwnerUserId != -1 -- Community (i.e. deleted users)
  GROUP BY p.OwnerUserId
  HAVING COUNT(*) > 1
  ORDER BY COUNT(*) DESC

fork query

edited mar 28 19

created mar 28 19 Glorfindel