Potential Main Page Featured Pictures (GA/FA/FAC/Former FA/FARC/GAN)

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 ( # Used in a page where
  img.il_from IN ( # The page is a GA/FA
    SELECT c2.cl_from
    FROM categorylinks c2
    WHERE c2.cl_to IN ( 'Good_articles', 'Featured_articles' )
  )
  OR img.il_from IN ( # Or the page title matches a talk page
    SELECT pg2.page_id
	FROM page pg2
    WHERE pg2.page_namespace = 0
    AND pg2.page_title IN ( # Where the talk page is in FAC, former FA, FARC, GAN
      SELECT pg3.page_title
      FROM page pg3
      WHERE pg3.page_namespace = 1
      AND pg3.page_id IN (
        SELECT c3.cl_from
        FROM categorylinks c3
        WHERE c3.cl_to IN ( 'Wikipedia_featured_article_candidates', 'Wikipedia_former_featured_articles',
                        'Wikipedia_featured_article_review_candidates', 'Good_article_nominees' )
      )
    )
  )
)
LIMIT 500
SQL

Checking query status...
