Last modified: 2014-01-03 16:11:59 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-193. Summary: List of uncategorized files by WMF employees Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Federico Leva <federicoleva@tiscali.it> Date: Thu, 30 Aug 2012 08:02:40 ------------------------------------------------------------------------------- I need a list of files uploaded by WMF employees without proper categories so that they can be easily categorized. Suggested way: take all the uploads on Commons by the attached usernames and select all the files which are in one of the subcategories of https://commons.wikimedia.org/wiki/Category:Media_needing_categories (Dummy assignment to myself because "assignee: The default assignee does NOT have ASSIGNABLE permission OR Unassigned issues are turned off.")
------------------------------------------------------------------------------- From: Federico Leva <federicoleva@tiscali.it> Date: Thu, 30 Aug 2012 08:03:15 ------------------------------------------------------------------------------- Username list
------------------------------------------------------------------------------- From: Liangent <liangent@gmail.com> Date: Sat, 15 Sep 2012 10:35:28 ------------------------------------------------------------------------------- What do the following two lines mean in staff2? :meta:user:Mdale :meta:user:Nikerabbit Are them ignorable in this task?
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Mon, 01 Oct 2012 23:43:26 ------------------------------------------------------------------------------- Please notice, that I changed the two user names Liangent asked about above. I've assumed all other names to be valid (this is case SENSITIVE). SQL: SELECT DISTINCT img_name FROM image INNER JOIN page ON page_title = img_name AND page_namespace = 6 INNER JOIN categorylinks ON cl_from = page_id WHERE img_user_text IN(/* ... */) AND cl_to LIKE 'All_media_needing_categories_as_of_%'; Result: http://toolserver.org/~hoo/dbq/dbq-193.txt
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: hoo@online.de CC list: federicoleva@tiscali.it, hoo@online.de, liangent@gmail.com