Last modified: 2014-01-03 15:36:29 UTC
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 ;
------------------------------------------------------------------------------- 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
