SELECT TOP 100 p.Id AS [Post Link], p.CreationDate, p.Sco...

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 ReviewTaskResults AS rtr
    ON rt.CompletedByReviewTaskId = rtr.Id
  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 v.CreationDate BETWEEN rt.CreationDate AND rtr.CreationDate
  WHERE rt.ReviewTaskTypeId = 3 -- Low Quality Posts
  ORDER BY v.CreationDate DESC

Enter Parameters

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