0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for biology researchers, academics, and students

SELECT 
  rt.id AS [rt id],
  rt.ReviewTaskTypeId AS [rt ReviewTaskTypeId],
  rt.CreationDate AS [rt CreationDate],
  rt.DeletionDate AS [rt dDate],
  rt.ReviewTaskStateId AS [rt rtStateId],
  rt.PostId AS [rt PostId]
  
FROM PostHistory h
RIGHT OUTER JOIN ReviewTasks rt ON rt.PostId = h.Id
RIGHT OUTER JOIN ReviewTaskResults rtr ON rtr.Id = rt.CompletedByReviewTaskId
INNER JOIN Posts p ON p.Id = h.PostId
--RIGHT JOIN ReviewTaskResults rtr ON rtr.Id = rt.CompletedByReviewTaskId


WHERE rt.ReviewTaskTypeId IN (##types?4,12##)  
  AND (rt.CreationDate >= '##startDate?2005-01-01##') 
  AND (rt.CreationDate <= '##endDate?2030-12-31##')
  
ORDER BY h.Id DESC

fork query

edited nov 4 Blindspots

created sep 27 14 jon.doe14699