USE metawiki_p;#enwiki_p;

SELECT p.page_id FROM page p

INNER JOIN (image e JOIN commonswiki_p.image c ON c.img_sha1 = e.img_sha1) ON e.img_name = p.page_title

#LEFT JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to IN ('All_Wikipedia_files_with_a_different_name_on_Wikimedia_Commons',

#                                        'All_Wikipedia_files_with_the_same_name_on_Wikimedia_Commons',

#                                        'Wikipedia_files_on_Wikimedia_Commons_for_which_a_local_copy_has_been_requested_to_be_kept')

WHERE p.page_namespace = 6

#AND c.cl_from IS NULL

#AND e.img_name != c.img_name #better start with files available under different names as they become more difficult to find if later overwritten

#LIMIT 10