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