Last modified: 2014-01-03 16:06:33 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-161. Summary: Generate a list of Images which have multiple images in thier history. Issue type: Task - A task that needs to be done. Priority: Trivial Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Alexander Farlie <wiki@gfarlie.demon.co.uk> Date: Mon, 03 Oct 2011 11:37:36 ------------------------------------------------------------------------------- On English Wikipedia, (en.wikipedia.org) it would be nice to generate a list of image names for which multiple images exist in the history. This list could then be used by a bot, to help ensure the media files concerned are 'split'.
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Thu, 06 Oct 2011 21:05:27 ------------------------------------------------------------------------------- I don't know what exactly you planned to do with the data, but please notice that probably most are just different versions of one image :/ SQL: SELECT DISTINCT /* SLOW_OK */ img_name FROM image INNER JOIN oldimage ON oi_name = img_name WHERE oi_deleted = 0; Result: http://toolserver.org/~hoo/dbq/dbq-161.txt (plain text) I did the same excluding images with the same width and height just to get at least some noise out of the data: SQL: SELECT DISTINCT /* SLOW_OK */ img_name FROM image INNER JOIN oldimage ON oi_name = img_name WHERE oi_deleted = 0 AND oi_width != img_width AND oi_height != img_height; Result: http://toolserver.org/~hoo/dbq/dbq-161_2.txt (plain text)
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