REPORTS-59 Create a query: list of Wiki loves Monuments uploaders
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Dec 28 2013, 1:23 PM

Description

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;

Version: unspecified
Severity: minor

Details

Reference: bz59022

Event Timeline

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

• bzimport added a project: Tool-tsreports.

• bzimport set Reference to bz59022.

JiraBugConverter created this task.Dec 28 2013, 1:23 PM

From: Merlijn van Deen <valhallasw@arctus.nl>

Date: Fri, 03 Sep 2010 21:01:08

Fixed in r10.

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: valhallasw@arctus.nl
CC list: valhallasw@arctus.nl

REPORTS-59 Create a query: list of Wiki loves Monuments uploadersClosed, ResolvedPublicActions