Wikimedia Bugzilla is closed!

This issue was converted from https://jira.toolserver.org/browse/REPORTS-59.
Summary: Create a query: list of Wiki loves Monuments uploaders
Issue type: New Feature - A new feature of the product, which has yet to be developed.
Priority: Minor
Status: Closed
Assignee: Merlijn van Deen <valhallasw@arctus.nl>

-------------------------------------------------------------------------------
From: Merlijn van Deen <valhallasw@arctus.nl>
Date: Fri, 03 Sep 2010 20:50:32
-------------------------------------------------------------------------------

Port http://toolserver.org/~multichill/temp/queries/erfgoed/wlm_uploaders.sql to tsreports. Example output is at http://toolserver.org/~multichill/temp/queries/erfgoed/wlm_uploaders.txt. Query is as follows:

/* Make a list of WLM uploaders */  
connect commonswiki_p commonswiki-p.db;  
SELECT CONCAT('*[[User:', img_user_text,'|', img_user_text, ']] - ', COUNT(img_user_text)) FROM image  
JOIN page ON img_name=page_title  
JOIN categorylinks ON page_id=cl_from  
WHERE  
page_namespace=6 AND   
page_is_redirect=0 AND  
cl_to='Images_from_Wiki_Loves_Monuments'  
GROUP BY img_user_text  
ORDER BY COUNT(img_user_text) DESC;