DBQ-88 Editing patterns on [[Catholic Church]]
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:49 PM

Description

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.

Version: unspecified
Severity: trivial

Details

Reference: bz59340

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:24 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59340.

JiraBugConverter created this task.Jan 3 2014, 3:49 PM

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

DBQ-88 Editing patterns on [[Catholic Church]]Closed, ResolvedPublicActions