Top/High-importance articles w/o images - Quarry

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

Non-redirect pages in the main namespace rated "Top" or "High" by any Wikiproject that have no images of any sort (not even those from templates like {{unreferenced}}).

For [[WP:VPM#How do we find articles that have no files?]] circa 2 July 2021.

SQL

SELECT page_title, pa_importance, pa_class, pap_project_title
FROM page
JOIN page_assessments ON pa_page_id = page_id
JOIN page_assessments_projects ON pap_project_id = pa_project_id
LEFT JOIN imagelinks on il_from = page_id
WHERE il_from IS NULL
  AND page_namespace = 0
  AND page_is_redirect = 0
  AND pa_importance IN ('Top', 'High')
ORDER BY pa_importance DESC, page_title ASC;

​x
 
SELECT page_title, pa_importance, pa_class, pap_project_titleFROM pageJOIN page_assessments ON pa_page_id = page_idJOIN page_assessments_projects ON pap_project_id = pa_project_idLEFT JOIN imagelinks on il_from = page_idWHERE il_from IS NULL  AND page_namespace = 0  AND page_is_redirect = 0  AND pa_importance IN ('Top', 'High')ORDER BY pa_importance DESC, page_title ASC;​

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.

Checking query status...