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 100 p.Id AS [Post Link], p.CreationDate, p.Score, v.CreationDate AS 'Bounty start'
  FROM ReviewTasks AS rt
  INNER JOIN Posts AS p
    ON rt.PostId = p.Id
  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 = ##ReviewTaskTypeId:int##
-- ReviewTaskTypeId: 2 = Close Votes, 3 = Low Quality Posts
  ORDER BY v.CreationDate DESC

Enter Parameters

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