DBQ-33 Salli contributions on it.wiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:36 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-33.
Summary: Salli contributions on it.wiki
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: (none)

From: Incola <diegmonti@gmail.com>

Date: Wed, 30 Jul 2008 09:26:20

On it.wiki we need a list of the contributions of a user that did a lot of copyviol, for manually check them.
I hope that isn't a problem. There is the query;

SELECT CONCAT( "#[[", title, "]] ([http://it.wikipedia.org/w/index.php?title=", title, "&action=history Cron] - ", number, ")" )
FROM (
SELECT page_title AS title, count( * ) AS number
FROM page
JOIN revision ON page_id = rev_page
WHERE page_namespace = '0'
AND rev_user_text LIKE "Salli"
GROUP BY page_title
) AS pages
ORDER BY number DESC ;

Version: unspecified
Severity: major

Details

Reference: bz59289

Event Timeline

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

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

• bzimport set Reference to bz59289.

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

From: Bryan Tong Minh <bryan@tools.wikimedia.de>

Date: Wed, 30 Jul 2008 10:29:03

Only one row in set:

#[[Reggio_di_Calabria]] (http://it.wikipedia.org/w/index.php?title=Reggio_di_Calabria&action=history Cron - 6364)

From: Incola <diegmonti@gmail.com>

Date: Wed, 30 Jul 2008 11:10:03

Sorry, the query wasn't correct. I've forgotten GROUP BY.
In fact this user has a lot of contributions. That is the correct query:

SELECT CONCAT( "#[[", title, "]] ([http://it.wikipedia.org/w/index.php?title=", title, "&action=history Cron] - ", number, ")" )
FROM (
SELECT page_title AS title, count( * ) AS number
FROM page
JOIN revision ON page_id = rev_page
WHERE page_namespace = '0'
AND rev_user_text LIKE "Salli"
GROUP BY page_title
) AS pages
ORDER BY number DESC ;

From: Pietrodn <powerpdn@gmail.com>

Date: Sat, 02 Aug 2008 14:45:48

Done. I posted the results on http://it.wikipedia.org/wiki/Utente:Incola/Edit_Salli

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: Bryan.TongMinh@Gmail.com, powerpdn@gmail.com

DBQ-33 Salli contributions on it.wikiClosed, ResolvedPublicActions