Pages with intentionally no short description that should maybe have one

SQL

SELECT CONCAT('https://en.wikipedia.org/wiki/', p.page_title) AS 'Page'
FROM page p
LEFT JOIN page_props pp ON p.page_id = pp.pp_page AND pp.pp_propname = 'wikibase-shortdesc'
WHERE p.page_namespace = 0
AND p.page_title NOT LIKE 'List_%'
AND p.page_title NOT LIKE '%_filmography'
AND p.page_title NOT LIKE '%_on_screen_and_stage'
AND p.page_title NOT LIKE '%_on_stage_and_screen'
AND p.page_id IN (
	SELECT cl_from
	FROM categorylinks
	WHERE cl_to = 'Articles_with_short_description'
)
AND pp.pp_value IS NULL

SQL

Checking query status...