https://bugzilla.wikimedia.org/show_bug.cgi?id=59427
--- Comment #1 from Bugzilla Bug Importer (valhallasw)
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@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)
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
