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 
#JOIN globalimagelinks on gil_to = img_name
#   join page on image.img_name = page.page_title and page.page_namespace = 6
   join categorylinks on page.page_id=cl_from 
WHERE cl_to in ("Personal_images", "User_page_images")#like "Media_needing_categories%"
#and (gil_page_namespace_id = 2 or gil_page_namespace_id = 3)
 and page_namespace = 6 AND page_is_redirect = 0
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
SQL

Checking query status...
