DBQ-193 List of uncategorized files by WMF employees
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 4:11 PM

Description

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.")

Version: unspecified
Severity: major

Details

Reference: bz59476

Event Timeline

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

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

• bzimport set Reference to bz59476.

JiraBugConverter created this task.Jan 3 2014, 4:11 PM

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

DBQ-193 List of uncategorized files by WMF employeesClosed, ResolvedPublicActions