# 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) >= 90

# 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 100