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
Magnus Manske
.
Toggle Highlighting
SQL
connect wikidatawiki_p; SELECT DISTINCT page_title FROM page,pagelinks WHERE page_namespace=0 AND pl_from=page_id AND pl_namespace=0 AND pl_title='Q6581072' AND NOT EXISTS (SELECT * FROM pagelinks pl2 WHERE pl2.pl_from=page_id AND pl2.pl_namespace=120 AND pl2.pl_title IN ('P227','P268','P269','P270','P349','P353','P377','P458','P484','P502','P503','P506','P508','P587','P646','P671','P691','P731','P919','P920','P950','P951','P1005','P1014','P1051','P1149','P1189','P1207','P1294','P1296','P1362','P1375','P1385','P1453','P1471','P1645','P1670','P1695','P1755','P1760','P1769','P1807','P1900','P1928','P1987','P2004','P2026','P2106','P2158','P2163','P2179','P2249','P2263','P2347','P2355','P2357','P2367','P2372','P2397','P2426','P2457','P2464','P2477','P2479','P2480','P2581','P2612','P2620','P2671','P2689','P2742','P2748','P2751','P2752','P2759','P2760','P2812','P2863','P2866','P2867','P2874','P2924','P3021','P3040','P3064','P3065','P3074','P3083','P3088','P3102','P3105','P3106','P3123','P3130','P3133','P3183','P3201','P3208','P3221','P3222','P3235','P3240','P3241','P3243','P3246','P3265','P3267','P3285','P3289','P3308','P3322','P3328','P3347','P3348','P3365','P3370','P3381','P3390','P3398','P3400','P3420','P3479','P3545','P3552','P3553','P3579','P3583','P3591','P3710','P3720','P3724','P3743','P3763','P3790','P3794','P3795','P3798','P3811','P3827','P3832','P3847','P3854','P3859','P3885','P3895','P3905','P3911','P3916','P3917','P3941','P3943','P3962','P3964','P3973','P3984','P3986','P3998','P4003','P4051','P4073','P4104','P4106','P4125','P4160','P4166','P4167','P4180','P4201','P4204','P4223','P4228','P4255','P4272','P4293','P4294','P4297','P4304','P4305','P4306','P4307','P4308','P4309','P4310','P4311','P4336','P4384','P4389' ) LIMIT 1 );
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...