commons duplicated files

SQL

USE commonswiki_p;/*
SELECT img_sha1, COUNT(*) AS occurs 
FROM image
GROUP BY img_sha1
HAVING occurs > 1*/
/*### concat("File:",im1.img_name), concat("File:",im2.img_name), 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
order by im1.img_name asc*/
 /*gil_wiki is null*/
SELECT CONCAT("*[[:File:", GROUP_CONCAT(img_name ORDER BY img_timestamp ASC SEPARATOR "]], [[:File:"), "]]") as Files, 
img_sha1
FROM image, page, categorylinks /*
where img_sha1 in (select img_sha1 FROM image, page, categorylinks */
   WHERE page.page_id=categorylinks.cl_from 
       AND image.img_name = page.page_title
       AND categorylinks.cl_to like "Media_needing_categories%"/*)*/
GROUP BY img_sha1
HAVING COUNT(img_sha1) > 1
#limit 10
#limit 1000
/*other queries
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...
