Potential main page featured pictures (2)

SQL

SELECT img.il_from AS pageID, img.il_to AS image FROM imagelinks img
WHERE img.il_to IN ( # Image hasn't been featured
  SELECT pg1.page_title
  FROM page pg1
  WHERE pg1.page_namespace = 6
  AND pg1.page_id IN (
    SELECT c1.cl_from
    FROM categorylinks c1
    WHERE c1.cl_to = 'Featured_pictures_that_have_not_appeared_on_the_Main_Page'
  )
)
AND img.il_from NOT IN ( # The page is not a stub
  SELECT c2.cl_from
  FROM categorylinks c2
  WHERE c2.cl_to = 'All_stub_articles'
)
AND img.il_from IN (
  SELECT pg2.page_id
  FROM page pg2
  WHERE pg2.page_namespace = 0
)
LIMIT 100

SQL

Checking query status...