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
Wurgl
.
Toggle Highlighting
SQL
SELECT InclBKS.page_title AS "Inkludierte BKS", BKS.page_title AS "Inkludierende BKS" FROM page AS InclBKS, page_props AS InclPP, linktarget AS InclLT, templatelinks AS InclTL, # Included BKS linktarget AS PDLT, templatelinks AS PDTL, # Template Personendaten pagelinks AS IPP, linktarget AS IPLT, # inkludierte Personenseite pagelinks AS BKSPL, linktarget AS BKSLT, page AS BKS, # Including BKS page AS IP LEFT JOIN page AS BKSP ON IP.page_id = BKSP.page_id WHERE InclBKS.page_namespace = 0 AND InclBKS.page_id = InclPP.pp_page AND InclPP.pp_propname = 'disambiguation' AND InclLT.lt_title = InclBKS.page_title AND InclLT.lt_namespace = InclBKS.page_namespace AND InclLT.lt_id = InclTL.tl_target_id AND IPP.pl_from = InclBKS.page_id AND IPP.pl_target_id = IPLT.lt_id AND IPLT.lt_title = IP.page_title AND IPLT.lt_namespace = IP.page_namespace AND IP.page_namespace = 0 AND IP.page_id = PDTL.tl_from AND PDTL.tl_target_id = PDLT.lt_id AND PDLT.lt_title = 'Personendaten' AND PDLT.lt_namespace = 10 AND BKS.page_id = BKSPL.pl_from AND BKSPL.pl_target_id = BKSLT.lt_id AND BKSLT.lt_title = BKSP.page_title AND BKSLT.lt_namespace = BKSP.page_namespace AND BKSP.page_namespace = 0 AND BKS.page_id = InclTL.tl_from AND BKS.page_namespace = 0 AND BKSP.page_id IS NULL LIMIT 10
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...