Review queue items invalidated on the same day a bounty started

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

SELECT TOP 20 *
  FROM ReviewTasks AS rt
  INNER JOIN Votes AS v
    ON rt.PostId = v.PostId
   AND v.VoteTypeId = 8 -- Bounty start
   AND rt.DeletionDate = CAST(v.CreationDate AS DATE)
  WHERE rt.ReviewTaskTypeId = 2 -- Close Votes

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results