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
Uhai
.
WIP: LOTS of stuff to filter out
Toggle Highlighting
SQL
SELECT CONCAT('https://en.wikipedia.org/wiki/', p.page_title) AS 'Page' FROM page p LEFT JOIN page_props pp ON p.page_id = pp.pp_page AND pp.pp_propname = 'wikibase-shortdesc' WHERE p.page_namespace = 0 AND p.page_title NOT LIKE 'List_%' AND p.page_title NOT LIKE '%_filmography' AND p.page_title NOT LIKE '%_on_screen_and_stage' AND p.page_title NOT LIKE '%_on_stage_and_screen' AND p.page_title NOT LIKE 'Index_%' AND p.page_title NOT LIKE '%_discography' AND p.page_title NOT LIKE '%_bibliography' AND p.page_title NOT LIKE '%election%' AND p.page_title NOT LIKE '%\_in\_%' AND p.page_title NOT LIKE '%\_by\_%' AND p.page_title NOT LIKE '%\_of\_%' AND p.page_title NOT LIKE '%\_at\_%' AND p.page_title NOT LIKE '%\_for\_%' AND p.page_title NOT LIKE '%\_to\_%' AND p.page_id IN ( SELECT cl_from FROM categorylinks WHERE cl_to = 'Articles_with_short_description' ) AND pp.pp_value IS NULL
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...