Q&A for computer enthusiasts and power users
select top 50 SuggestedEditId as [Suggested Edit Link], deciding.CreationDate from ReviewTaskResults as deciding inner join ReviewTasks on ReviewTasks.Id = ReviewTaskId where ReviewTaskResultTypeId = 19 -- reject and edit and not exists ( select * from ReviewTaskResults as minority where minority.ReviewTaskResultTypeId = 2 -- approve and minority.ReviewTaskId = deciding.ReviewTaskId) and (select count(*) from ReviewTaskResults as majority where majority.ReviewTaskResultTypeId = 3 -- reject and majority.ReviewTaskId = deciding.ReviewTaskId) = ##threshold:int?3## union select top 50 SuggestedEditId as [Suggested Edit Link], deciding.CreationDate from ReviewTaskResults as deciding inner join ReviewTasks on ReviewTasks.Id = ReviewTaskId where ReviewTaskResultTypeId = 5 -- (improve) edit and not exists ( select * from ReviewTaskResults as minority where minority.ReviewTaskResultTypeId = 3 -- reject and minority.ReviewTaskId = deciding.ReviewTaskId) and (select count(*) from ReviewTaskResults as majority where majority.ReviewTaskResultTypeId = 2 -- approve and majority.ReviewTaskId = deciding.ReviewTaskId) = ##threshold:int?3## and deciding.CreationDate >= dateadd(month, -3, getutcdate()) order by deciding.CreationDate desc