First Post reviews for a single user's posts

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.Id AS [Post Link], p.CreationDate, r.Id, r.CreationDate
  FROM ReviewTasks AS r
  INNER JOIN Posts AS p ON r.PostId = p.Id
  WHERE r.ReviewTaskTypeId = 4 -- First Post
    AND p.OwnerUserId = ##OwnerUserId:int##

Enter Parameters

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