https://bugzilla.wikimedia.org/show_bug.cgi?id=59289
Web browser: ---
Bug ID: 59289
Summary: DBQ-33 Salli contributions on it.wiki
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: Unprioritized
Component: Database Queries
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
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 <diegmo...@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 ;
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
