commons duplicated files

SQL

USE commonswiki_p;
SELECT concat("File:",p1.page_title), concat("File:",p2.page_title)
FROM page p1
join page p2 on p1.img_sha1 = p2.img_sha1 and p1.page_title != p2.page_title
join image on p1.page_namespace = 6 and p1.page_title = img_name
LEFT JOIN globalimagelinks on gil_to = img_name
WHERE gil_wiki is null 
and (p1.page_title like "%ş%" or p1.page_title like "%ș%"
or p1.page_title like "%ț%" or p1.page_title like "%ţ%" )
GROUP BY img_name;
/*
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...
