Am 04.12.2014 22:49, schrieb Daniel Kinzler:
select A.img_name, A.img_sha1, B.img_name from image
as A join image as B on
A.img_sha1 = B.img_sha1 and A.img_name < B.img_name;
Fwiw, i get 197495 results for that query (took about 4 minutes).
So about 200k images could be deleted, but all the categories and meta-info
should be merged, and any usages moved to one file...
-- daniel