Potential main page featured pictures (2)

This query is marked as a draft This query has been published by DannyS712.

Used on non-stubs

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 NOT IN ( # The page is not a stub
    SELECT c2.cl_from
    FROM categorylinks c2
    WHERE c2.cl_to = 'All_stub_articles'
  )
)
LIMIT 100

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...