Last modified: 2014-01-03 15:49:38 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-87. Summary: Finding editors eligible for Autoreview privileges Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: mauro742 <mauro742@gmail.com> ------------------------------------------------------------------------------- From: Ryan Malloy <crypticc62@yahoo.com> Date: Fri, 05 Mar 2010 19:09:59 ------------------------------------------------------------------------------- Create a list of editors who are eligible for autoreview privileges: * Search to find all editors on en.wikipedia who have created 50+ non-redirect articles * If editor already has administrator or autoreview priviliges, remove from list * If last edit was made in 2009 or earlier, remove from list (optional)
------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Fri, 05 Mar 2010 19:50:54 ------------------------------------------------------------------------------- For reference: http://en.wikipedia.org/w/index.php?title=Wikipedia_talk:Database_reports&oldid=347958152#Candidates_for_Autoreview_privileges
------------------------------------------------------------------------------- From: mauro742 <mauro742@gmail.com> Date: Tue, 16 Mar 2010 21:51:12 ------------------------------------------------------------------------------- Results here: http://toolserver.org/~mauro742/DBQ/DBQ-87.txt Query: select r1.rev_user_text as user, count(*) as tot from page join revision as r1 on page_id=r1.rev_page where page_namespace=0 and page_is_redirect=0 and r1.rev_parent_id=0 and r1.rev_user <> 0 and not exists (select * from user_groups where ug_user=r1.rev_user and ug_group in ('sysop', 'autoreviewer') ) group by r1.rev_user, r1.rev_user_text having count(*) > 50 and exists( select * from revision as r2 where r2.rev_user = r1.rev_user and r2.rev_timestamp > '20091231235959') order by r1.rev_user_text;
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: crypticc62@yahoo.com, b@mzmcbride.com