Last 100 Maximally Unanimous Suggested Edit Reviews

0

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results