Looking for long auto short descriptions

SQL

WITH short_desc_pages AS (
    SELECT DISTINCT tl_from
    FROM templatelinks
    WHERE tl_target_id = 137
),

template_ids_generating_short_desc AS (
    SELECT DISTINCT tl_from
    FROM templatelinks
    WHERE tl_target_id IN (65131,93623)
),

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', 
pp_value AS 'Short description', 
CHAR_LENGTH(pp_value) AS 'Length',
pp_propname
FROM page_props
INNER JOIN page ON pp_page = page_id AND page_namespace = 0
WHERE page_id IN (SELECT tl_from FROM pages_without_short_desc_template)
	# AND pp_propname = 'wikibase-shortdesc'
	AND page_namespace = 0
SQL

Checking query status...
