commons duplicated files

SQL

USE commonswiki_p;
SELECT concat("File:",p1.page_title), concat("File:",p2.page_title), im1.img_sha1
FROM page p1
join image im1 on p1.page_title = im1.img_name
join page p2 on p1.page_namespace = 6 and p2.page_namespace = 6 and p1.page_title != p2.page_title
join image im2 on p2.page_title = im2.img_name
#LEFT JOIN globalimagelinks on gil_to = img_name
WHERE /*gil_wiki is null*/ im1.img_sha1 = im2.img_sha1 and p1.page_title not in p2.page_title
/*
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...
