Q&A for science fiction and fantasy enthusiasts
SELECT rt.ReviewTaskTypeId AS [rt TypeId], * FROM PostHistory h RIGHT OUTER JOIN ReviewTasks rt ON rt.PostId = h.Id --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.CreationDate