Untitled query #5647

SQL

USE enwiki_p;
SELECT p.page_id,p.page_title FROM page p
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = 'All_free_media'
LEFT JOIN templatelinks t ON t.tl_from = p.page_id AND t.tl_namespace = 10 AND t.tl_title IN
  ('Convert_to_SVG_and_copy_to_Wikimedia_Commons', 'DYKfile', 'Db-meta',
   'Deletable_file','Copy_to_Wikimedia_Commons', 'Deleted_on_Commons', 'Do_not_move_to_Commons','KeepLocal','Keep_local','keep_local','keep local','Duplicate', 'Esoteric_file', 'Example_files', 'Ffd', 'File_at_CCI',
   'Former_featured_picture','Featured_sound', 'Information','Google_Art_Project', 'M-cropped', 'NFUR_not_needed', 'Non-free_media', 'Now_Commons', 'OTRS_pending', 'OTRS_received', 'Out_of_copyright_in',
   'Pp', 'Pp-template', 'Protected_generic_image_name', 'Protected_sister_project_logo', 'Puf', 'ShadowsCommons', 'Split_media',
   'Uploaded_from_Commons', 'Wikipedia-screenshot', 'Self','PD-self','GFDL-self','Multilicense_replacing_placeholder_new','FeaturedPicture','Featured_Picture')
WHERE t.tl_from IS NULL
AND p.page_namespace = 6
SQL

Checking query status...
