Untitled query #83445

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'
FROM page_props pp
INNER JOIN page p ON pp.pp_page = p.page_id AND p.page_namespace = 0
INNER JOIN templatelinks ON p.page_id = tl_from
INNER JOIN linktarget ON tl_from = lt_id
WHERE pp_propname = 'wikibase-shortdesc'
    AND CHAR_LENGTH(pp.pp_value) >= 99
	AND tl_from_namespace = 10 
    AND lt_title = 'Infobox_television_episode'
ORDER BY CHAR_LENGTH(pp.pp_value) DESC
LIMIT 100
SQL

Checking query status...
