Untitled query #5643

SQL

USE enwiki_p;
SELECT p.page_id FROM page p
LEFT JOIN image i ON i.img_name = p.page_title
LEFT JOIN templatelinks t ON t.tl_from = p.page_ID AND ((t.tl_namespace = 10 AND t.tl_title IN #Template namespace
  ('Featured_picture', 'DYKfile', 'Restricted_use', 'Featured_sound', 'Brazilian_selected_picture', 'Former_featured_picture', 'FSC',
  'Asian_Games_selected_picture', 'VPCold', 'Nanotech_selected', 'Picture_of_the_day', 'Former_featured_sound', 'Wikipedia-adnavbox',
  'FPCold', 'Fishportal', 'Thailandportal','SP_Massachusetts' 'SP_India_UP', 'Db-fpcfail', 'USMCportal','pp-template','protected image','badimage'))
  OR (t.tl_namespace = 100 AND t.tl_title IN ('Star/Selected_picture/template', 'Mathematics/Featured_picture_template'))) #Portal namespace
WHERE p.page_namespace = 6
AND p.page_is_redirect != 1
AND i.img_name IS NULL
AND t.tl_from IS NULL
SQL

Checking query status...
