commons duplicated files

SQL

USE commonswiki_p;
SELECT concat("File:",im1.img_name), concat("File:",im2.img_name), distinct im1.img_sha1
FROM image im1, image im2
where im1.img_name != im2.img_name and im1.img_sha1 = im2.img_sha1
#LEFT JOIN globalimagelinks on gil_to = img_name
 /*gil_wiki is null*/
order by im1.img_name asc
limit 1000
/*
and (p1.page_title like "%ş%" or p1.page_title like "%ș%"
or p1.page_title like "%ț%" or p1.page_title like "%ţ%" )*/
#GROUP BY p1.page_title;
/*
USE commonswiki_p;
SELECT concat("File:",page_title)
FROM page
join image on page_namespace = 6 and page_title = img_name
LEFT JOIN globalimagelinks on gil_to = img_name
WHERE gil_wiki is null and page_title like "%ş%" 
GROUP BY page_title;
*/
SQL

Checking query status...
