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) >= 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 '%\;%' # semi-colon to preface a lot of words AND pp.pp_value LIKE '%list article%' # lists don't need an SD # AND pp.pp_value LIKE '%United States of America%' # US # AND pp.pp_value LIKE '%Overview%' # sign of redundant SD # AND pp.pp_value LIKE '%with%' # with lots of extra words # AND page_is_redirect = 1 # SD on redirects usually unnecessary ORDER BY CHAR_LENGTH(pp.pp_value) DESC LIMIT 1000
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...