Looking for long auto short descriptions

SQL

WITH pages_with_short_desc AS (
    SELECT CONCAT('https://en.wikipedia.org/wiki/', page_title) AS 'Page', 
  		   pp_value AS 'Short description', 
  		   CHAR_LENGTH(pp_value) AS 'Length'
    FROM page_props
	INNER JOIN page ON pp_page = page_id AND page_namespace = 0
	WHERE pp_propname = 'wikibase-shortdesc'
),

templates_generating_short_desc AS (
    SELECT lt_id AS 'Template ID',  lt_title AS 'Template Name', cl_to AS 'Template Category'
	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'
),

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/', p.page_title) AS 'Page', pp.pp_value AS 'Short description', CHAR_LENGTH(pp.pp_value) AS 'Length'
FROM page_props pp
INNER JOIN page p ON pp.pp_page = p.page_id AND p.page_namespace = 0
WHERE p.page_id IN (SELECT tl_from FROM pages_without_short_desc_template)
AND page_namespace = 0;
SQL

Checking query status...
