0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT r1.PostId AS [Post Link]
  FROM ReviewTasks AS r1
  INNER JOIN Posts AS a
    ON r1.PostId = a.Id
   AND r1.ReviewTaskTypeId = 4
   AND r1.CreationDate = CAST(a.CreationDate AS DATE)
  INNER JOIN ReviewTasks AS r2
    ON r2.PostId = a.ParentId
   AND r2.ReviewTaskTypeId = 4
  INNER JOIN Posts AS q
    ON r2.PostId = q.Id
   AND r2.CreationDate = CAST(q.CreationDate AS DATE)
   AND a.OwnerUserId = q.OwnerUserId

view current version

edited jul 1 20

created jul 1 20 Glorfindel