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.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##

fork query

edited mar 28 19

created mar 28 19 Glorfindel