Looking for templates

SQL

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',
    lt.lt_title
FROM page_props pp
INNER JOIN page p ON pp.pp_page = p.page_id AND p.page_namespace = 0
INNER JOIN templatelinks tl ON p.page_id = tl.tl_target_id
INNER JOIN linktarget lt ON tl.tl_from = lt.lt_id
# INNER JOIN templatelinks tl ON lt.lt_id = tl.tl_target_id
WHERE pp_propname = 'wikibase-shortdesc'
    AND CHAR_LENGTH(pp.pp_value) >= 80
    AND lt_namespace = 10
    # AND lt.lt_title = "Short description"
ORDER BY CHAR_LENGTH(pp.pp_value) DESC
LIMIT 100
SQL

Checking query status...
