Untitled query #83580

SQL

WITH short_desc_pages AS (
    SELECT DISTINCT tl_from
    FROM templatelinks
    WHERE # tl_target_id = 137 # Short description
  		# AND tl_target_id <> 488667 # Auto short description
  		tl_target_id = 501 # 'Has short description'
),

tgsd AS (
	SELECT lt_id #,  lt_title, cl_to
	FROM templatelinks
	JOIN linktarget ON lt_id = tl_target_id
	JOIN page ON page_namespace = lt_namespace AND page_title = lt_title
	JOIN categorylinks ON cl_from = page_id
	WHERE tl_from = page_id
  		AND cl_to = 'Templates_that_generate_short_descriptions'
),

template_ids_generating_short_desc AS (
    SELECT DISTINCT tl_from
    FROM templatelinks
	WHERE tl_target_id IN (SELECT lt_id FROM tgsd)
),

pages_without_short_desc_template AS (
    SELECT tl_from
    FROM template_ids_generating_short_desc
    WHERE tl_from NOT IN (SELECT tl_from FROM short_desc_pages)
)

SELECT CONCAT('https://en.wikipedia.org/wiki/', page_title) AS 'Page'
FROM page
WHERE page_id IN (SELECT tl_from FROM pages_without_short_desc_template)
    AND page_namespace = 0
LIMIT 100
SQL

Checking query status...
