Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Wizmut
.
Long SDs, extra words, multiple clauses, unnecessary SDs
Toggle Highlighting
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) >= 55 # 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 '%species of%' # extra words # AND pp.pp_value LIKE '%\[\[%' # non-functional brackets in SD ###CLEAR### # 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 'An %' # starting with definite article; also check A, The # AND pp.pp_value LIKE '%\.' # ending in a dot # AND pp.pp_value LIKE '% ' # ending in a space # AND pp.pp_value LIKE '%with%' # with lots of extra words # AND pp.pp_value LIKE '%list article%' # redundant ###CLEAR### # AND pp.pp_value LIKE '%Overview%' # redundant # AND pp.pp_value LIKE '%United States%' # US # AND page_is_redirect = 1 # most redirect SDs not needed ORDER BY CHAR_LENGTH(pp.pp_value) DESC LIMIT 2000
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
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...