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
CommanderWaterford
.
Toggle Highlighting
SQL
SELECT pg1.page_title FROM page AS pg1 JOIN templatelinks ON pg1.page_id = tl_from WHERE tl_namespace = 10 AND tl_title = 'BLP' AND pg1.page_namespace = 1 AND NOT EXISTS (SELECT 1 FROM page AS pg2 JOIN categorylinks ON pg2.page_id = cl_from WHERE pg1.page_title = pg2.page_title AND pg2.page_namespace = 0 AND cl_to = 'Living_people') AND NOT EXISTS (SELECT 1 FROM page AS pg3 JOIN categorylinks ON pg3.page_id = cl_from WHERE pg1.page_title = pg3.page_title AND pg3.page_namespace = 0 AND cl_to = 'Possibly_living_people') AND NOT EXISTS (SELECT 1 FROM page AS pg4 JOIN categorylinks ON pg4.page_id = cl_from WHERE pg1.page_title = pg4.page_title AND pg4.page_namespace = 0 AND cl_to = 'Human_name_disambiguation_pages') AND NOT EXISTS (SELECT 1 FROM page AS pg5 JOIN categorylinks ON pg5.page_id = cl_from WHERE pg1.page_title = pg5.page_title AND pg5.page_namespace = 0 AND cl_to = 'Disappeared_people') AND NOT EXISTS (SELECT 1 FROM page AS pg6 JOIN categorylinks ON pg6.page_id = cl_from WHERE pg1.page_title = pg6.page_title AND pg6.page_namespace = 1 AND cl_to = 'Musicians_work_group_articles') AND NOT EXISTS (SELECT 1 FROM page AS pg7 WHERE pg1.page_title = pg7.page_title AND pg7.page_namespace = 0 AND pg7.page_is_redirect = 1) AND EXISTS (SELECT 1 FROM page AS pg8 JOIN templatelinks ON pg8.page_id = tl_from WHERE tl_namespace = 10 AND tl_title = 'WPBiography' AND pg1.page_title = pg8.page_title AND pg8.page_namespace = 1) AND NOT EXISTS (SELECT 1 FROM page AS pg9 JOIN categorylinks ON pg9.page_id = cl_from WHERE pg1.page_title = pg9.page_title AND pg9.page_namespace = 0 AND cl_to LIKE 'Musical_groups%') AND NOT EXISTS (SELECT 1 FROM page AS pg10 JOIN categorylinks ON pg10.page_id = cl_from WHERE pg1.page_title = pg10.page_title AND pg10.page_namespace = 0 AND cl_to LIKE '%music_groups') 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...