uncat imgs used in usrpgs

SQL

USE commonswiki_p;
SELECT page_title#img_name#, /*img_size, img_width, img_height, gil_wiki, GROUP_CONCAT(gil_page_title SEPARATOR " | ") as In_pages,*/ img_user_text
FROM page#image 
LEFT JOIN globalimagelinks on gil_to = page_title
LEFT JOIN imagelinks on il_to = page_title
#   join page on image.img_name = page.page_title and page_namespace = 6 AND page_is_redirect = 0 
   join categorylinks on page_id=cl_from 
WHERE cl_type="file" AND page_namespace=6 AND page_is_redirect = 0 
AND cl_to like "Media_needing_categories%"
and (gil_page_namespace_id = 2 or gil_page_namespace_id = 3 
     or il_from_namespace = 2 or il_from_namespace = 3)
/*
and (page_title not in (select distinct gil_to from globalimagelinks))
and page_title not in (select distinct il_to from imagelinks)*/
GROUP BY page_title
ORDER BY page_title
SQL

Checking query status...
