https://bugzilla.wikimedia.org/show_bug.cgi?id=59022
Web browser: ---
Bug ID: 59022
Summary: REPORTS-59 Create a query: list of Wiki loves
Monuments uploaders
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: Unprioritized
Component: tsreports
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
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 <valhall...@arctus.nl>
-------------------------------------------------------------------------------
From: Merlijn van Deen <valhall...@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;
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
