How many edits (and editors) would've been blocked if we rate-limited pending suggested edits?

0

Please login or register to vote for this query.

(click on this box to dismiss)

GIS

Q&A for cartographers, geographers and GIS professionals

declare @today as DateTime = (select max(CreationDate) from Posts);

select OwnerUserId [User Link], concat('query://503650?LookbackDays=##LookbackDays##&MaxPendingEdits=##MaxPendingEdits##&UserId=', OwnerUserId, '|', count(*)) "Edits that would have been rate-limited"
from 
(
  select Id, OwnerUserId
  from SuggestedEdits s1
  where CreationDate > @today-##LookbackDays?365##
  and (select count(*) from SuggestedEdits s2 
        where s2.OwnerUserId=s1.OwnerUserId 
        and s2.CreationDate < s1.CreationDate 
        and isnull(s2.ApprovalDate,s2.RejectionDate) > s1.CreationDate) > ##MaxPendingEdits?4##
 
) x
group by OwnerUserId
order by count(*) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results