Non-list articles without short descriptions

Fork of Non-list articles without short descriptions by Certes

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

SQL

SELECT Pa.page_title
FROM templatelinks
JOIN page Pa ON Pa.page_namespace = 0 AND Pa.page_is_redirect = 0 AND Pa.page_id = tl_from
WHERE tl_namespace = 10 AND tl_title = "Infobox_person" AND tl_from_namespace = 0
AND NOT EXISTS (SELECT 1 FROM categorylinks 
                WHERE cl_from = Pa.page_id AND cl_to IN ("Articles_with_short_description", "All_disambiguation_pages"))
AND NOT EXISTS (SELECT 1 FROM page Pt, categorylinks WHERE Pt.page_title = Pa.page_title AND Pt.page_namespace = 1
                AND cl_from = Pt.page_id AND cl_to = "WikiProject_Lists_articles")
LIMIT 10

SQL

Checking query status...