Last modified: 2014-01-03 16:02:45 UTC
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.
------------------------------------------------------------------------------- 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