Last modified: 2014-01-03 15:49:50 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-88. Summary: Editing patterns on [[Catholic Church]] Issue type: Task - A task that needs to be done. Priority: Trivial Status: Done Assignee: mauro742 <mauro742@gmail.com> ------------------------------------------------------------------------------- From: Garrett Fitzgerald <sarekofvulcan@gmail.com> Date: Mon, 15 Mar 2010 17:50:05 ------------------------------------------------------------------------------- I'm curious as to the editing patterns on en:Catholic Church relating to the recent blocks of NancyHeise and Xandar. What are the top 10 editors per week for the last 10 weeks, with edit counts? Thanks.
------------------------------------------------------------------------------- From: mauro742 <mauro742@gmail.com> Date: Tue, 16 Mar 2010 22:14:23 ------------------------------------------------------------------------------- Results here: http://toolserver.org/~mauro742/DBQ/DBQ-88.txt Query for a single week: select rev_user_text as user, count(*) as tot from page join revision on page_id = rev_page where page_namespace=0 and page_title = 'Catholic_Church' and rev_user <> 0 and year(rev_timestamp) = 2010 and week(rev_timestamp) = 1 group by rev_user, week(rev_timestamp) order by tot desc, user limit 10;
------------------------------------------------------------------------------- From: Garrett Fitzgerald <sarekofvulcan@gmail.com> Date: Wed, 17 Mar 2010 03:54:21 ------------------------------------------------------------------------------- That was interesting to see. Thanks!
------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Wed, 17 Mar 2010 06:56:22 ------------------------------------------------------------------------------- WikiSense can do this dynamically, for example.
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: gfitzger@nyx.net, b@mzmcbride.com