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

_______________________________________________
Commons-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/commons-l

Reply via email to