Bad short descriptions

SQL

# 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 '%film directed%' # extra word
    AND pp.pp_value LIKE '%located in%' # extra word
    # AND pp.pp_value LIKE '%\[\[%' # non-functional brackets in SD
    # AND pp.pp_value LIKE '%\'\'%' # italic or bold marks
    # AND pp.pp_value LIKE '%\;%' # semi-colon to preface a lot of words
    # AND pp.pp_value LIKE '%with%' # with lots of extra words
    # AND pp.pp_value LIKE '%list article%' # redundant
    # AND pp.pp_value LIKE '%species of flowering%' # flower
    # AND pp.pp_value LIKE '%Overview%' # redundant
    # AND pp.pp_value LIKE '%United States of America%' # US
    # AND page_is_redirect = 1 # most redirect SDs not needed
ORDER BY CHAR_LENGTH(pp.pp_value) DESC
LIMIT 1000
SQL

Checking query status...
