DBQ-213 Users who uploaded files in Category:WLM_2013_United_States_unreviewed
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 4:14 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-213.
Summary: Users who uploaded files in Category:WLM_2013_United_States_unreviewed
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <hoo@online.de>

From: Mono <monomium@gmail.com>

Date: Wed, 20 Nov 2013 23:09:42

I need a list of users who uploaded images in http://commons.wikimedia.org/wiki/Category:WLM_2013_United_States_unreviewed ASAP. There are over 10,000 files in that category. I only need their usernames, preferably in .txt format with one per line like this:

User:Mono
User:Mono1
User:Mono2

If you can exclude duplicates, that would be great. (We are using this to contact people who participated in Wiki Loves Monuments in the US and tell them about the results and hopefully retain them as contributors).

Version: unspecified
Severity: major

Details

Reference: bz59496

Event Timeline

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

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

• bzimport set Reference to bz59496.

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

From: Hoo man <hoo@online.de>

Date: Wed, 20 Nov 2013 23:24:40

SQL:

SELECT DISTINCT CONCAT( 'User:', img_user_text ) FROM categorylinks INNER JOIN page ON cl_from = page_id INNER JOIN image ON img_name = page_title WHERE cl_to = 'WLM_2013_United_States_unreviewed'

Result:
http://tools.wmflabs.org/hoo/dbq/dbq-213.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: usermono@outlook.com, hoo@online.de

DBQ-213 Users who uploaded files in Category:WLM_2013_United_States_unreviewedClosed, ResolvedPublicActions