unused personal images (commons)

SQL

USE commonswiki_p;
SELECT page_title
FROM categorylinks
JOIN page ON page_id=cl_from
LEFT JOIN       imagelinks ON  il_to=page_title
LEFT JOIN globalimagelinks ON gil_to=page_title
WHERE cl_type="file" AND page_namespace=6
AND cl_to IN ("Personal_images", "User page images")
AND gil_to IS NULL AND #il_to IS NULL
#/*(il_to IS NULL or 
                        il_from in (select page_id from page where page_title like "OgreBot/Uploads%" AND page_namespace=2)#)*/
group by page_title
having count(il_from) = 1

AخA
 
USE commonswiki_p;SELECT page_titleFROM categorylinksJOIN page ON page_id=cl_fromLEFT JOIN       imagelinks ON  il_to=page_titleLEFT JOIN globalimagelinks ON gil_to=page_titleWHERE cl_type="file" AND page_namespace=6AND cl_to IN ("Personal_images", "User page images")AND gil_to IS NULL AND #il_to IS NULL#/*(il_to IS NULL or                         il_from in (select page_id from page where page_title like "OgreBot/Uploads%" AND page_namespace=2)#)*/group by page_titlehaving count(il_from) = 1

SQL

Checking query status...