Untitled query #69969

SQL

SELECT img_name from image
INNER JOIN filearchive ON fa_name = img_name
#INNER JOIN oldimage ON oi_name = img_name
INNER JOIN page ON page_title = img_name AND page_namespace = 6

WHERE
    img_name IN
		(SELECT page_title
       		FROM page
       		INNER JOIN categorylinks ON cl_from = page_id
         	WHERE (cl_to = 'Copy_to_Wikimedia_Commons'
                   OR cl_to = 'Copy_to_Wikimedia_Commons_(bot-assessed)'
                   OR cl_to = 'Copy_to_Wikimedia_Commons_reviewed_by_a_human'
                  )
      	)
    AND img_name NOT IN 
    		(SELECT page_title
               FROM page
               INNER JOIN categorylinks ON cl_from = page_id
               WHERE cl_to = 'Copy_to_Wikimedia_Commons_with_hidden_file_revisions'
      		)
    #AND oi_deleted = 1
SQL

Checking query status...
