Longest short description

SQL

# code from user Uhai
SELECT CONCAT('en.wikipedia.org/wiki/', p.page_title) AS 'Page', 
	   pp.pp_value AS 'Short description', 
       CHAR_LENGTH(pp.pp_value) AS 'Length'
       #(CHAR_LENGTH(pp.pp_value) + CHAR_LENGTH(p.page_title)) AS 'Length'
FROM page_props pp
INNER JOIN page p ON pp.pp_page = p.page_id AND p.page_namespace = 0
WHERE pp_propname = 'wikibase-shortdesc'
	AND CHAR_LENGTH(pp.pp_value) >= 100
ORDER BY CHAR_LENGTH(pp.pp_value) DESC
#	AND CHAR_LENGTH(pp.pp_value) >= 55
#	AND CHAR_LENGTH(pp.pp_value) + CHAR_LENGTH(p.page_title) >= 140
#ORDER BY (CHAR_LENGTH(pp.pp_value) + CHAR_LENGTH(p.page_title)) DESC
LIMIT 1000
SQL

Checking query status...
