Q&A about the site for people looking to bypass life's everyday problems with simple tricks
SELECT rt.id AS [rt id], rt.ReviewTaskTypeId AS [rt rtTypeId], rt.CreationDate AS [rt cDate], 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