Page MenuHomePhabricator

DBQ-141 Query Requested on Behalf of Dragonfly6-7 (IRC Nick) on Wikimedia Commons
Closed, ResolvedPublic

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-141.
Summary: Query Requested on Behalf of Dragonfly6-7 (IRC Nick) on Wikimedia Commons
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <hoo@online.de>


From: Joe G. <jgazzarato@me.com>

Date: Sat, 04 Jun 2011 01:57:16

Please run a database query that will return the following results that were described in IRC message to myself.

<Dragonfly6-7> I'd like a list of all filenames on commons that have more than one image in their history.

If you require more information, please let me know by commenting on this ticket and will aquire this information for you.


Version: unspecified
Severity: major

Details

Reference
bz59398

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:28 AM
bzimport set Reference to bz59398.

From: Hoo man <hoo@online.de>

Date: Sat, 04 Jun 2011 14:32:05

SQL:

SELECT /* SLOW_OK */ page_title FROM logging INNER JOIN page ON page_namespace = log_namespace AND page.page_title = log_title WHERE log_type = 'upload' GROUP BY log_title HAVING COUNT(log_id) > 1;

Result:
http://toolserver.org/~hoo/dbq/dbq-141.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: hoo@online.de