USE enwiki_p;

SELECT p.page_id FROM page p

INNER JOIN image i ON p.page_title = i.img_name

LEFT JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = 'All_non-free_media'

LEFT JOIN templatelinks t ON t.tl_from = p.page_id AND t.tl_namespace = 10 AND t.tl_title IN ('Copy_to_Wikimedia_Commons', '!Copy_to_Wikimedia_Commons')

LEFT JOIN imagelinks il ON p.page_title = il.il_to

WHERE p.page_namespace = 6

AND c.cl_from IS NULL

AND t.tl_from IS NULL

AND il.il_from IS NULL