0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

/*
last 7 days of activity.
If (rejects - (approvals / 3)) >= 5, you will be auto-banned.
*/

select count(rejectiondate) - (count(approvaldate) /3) [autoban >= 5] 
     , count(rejectiondate) [# Rejected]
     , count(approvaldate) [# Approved]
from suggestededits
where owneruserid = 13927534
and creationdate between dateadd(d,-7,getdate()) and getdate()

fork query

edited apr 2 23

created apr 2 23 rene