Fork of Bad short descriptions by Wizmut
This query is marked as a draft This query has been published by 1ctinus.

SQL

AخA
 
# 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 pp.pp_value LIKE '%located in%' # extra word ### 1047 ####
    # AND pp.pp_value LIKE '%pecies of%' # extra words ### thousands ###
    # AND pp.pp_value LIKE '%\[\[%' # non-functional brackets in SD ### CLEAR ###
    # AND pp.pp_value LIKE '%\'\'%' # italic or bold marks ### 380 ###
    # AND pp.pp_value LIKE '%\;%' # semi-colon to preface a lot of words ### thousands ###
    # AND pp.pp_value LIKE 'A %' # starting with definite article; also check An, The ### thousands ###
    # AND pp.pp_value LIKE '%\.' # ending in a dot ### thousands ###
    # AND pp.pp_value LIKE '%with%' # with lots of extra words ### thousands ###
    # AND pp.pp_value LIKE '%list article%' # redundant ### CLEAR ###
    # AND pp.pp_value LIKE '%Overview%' # redundant ### 1679 ###
    # AND pp.pp_value LIKE '%United States%' # US ### thousands ###
    # AND page_is_redirect = 1 # most redirect SDs not needed ### 1361 ###
ORDER BY CHAR_LENGTH(pp.pp_value) DESC
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...