# code from user Uhai

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 pp_propname = 'wikibase-shortdesc'

    AND CHAR_LENGTH(pp.pp_value) >= 60 # long enough to be cut off

    AND pp.pp_value LIKE '%Species of flowering%' # extra words

ORDER BY CHAR_LENGTH(pp.pp_value) DESC

LIMIT 1000