Users with multiple First Post reviews

0

Please login or register to vote for this query.

(click on this box to dismiss)

Unix and Linux

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results