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