Last modified: 2014-01-03 16:14:39 UTC
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).
------------------------------------------------------------------------------- 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