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
.
Personen, welche im Nekrolog verlinkt sind, aber keine Kategorie:Gestorbe_xxxx haben Bekannte Falsch-Positive: Horst-Rüdiger_Jarck im Einzelnachweisen erwähnt
Toggle Highlighting
SQL
SELECT nekrolog.page_title AS "Nekrolog", person.page_title AS "Person" FROM page AS nekrolog, pagelinks AS nekpl, linktarget AS nektar, # Pagelink vom Nekrolog zur Person page AS person LEFT JOIN categorylinks ON person.page_id = cl_from AND cl_to LIKE 'Gestorben_%', templatelinks AS pdtl, linktarget AS pdtar # Person muss PD haben WHERE nekrolog.page_title LIKE "Nekrolog%" AND nekrolog.page_title NOT IN ('Nekrolog_(Tiere)', 'Nekrolog_(Totenverzeichnis)') AND nekrolog.page_namespace = 0 AND nekpl.pl_from = nekrolog.page_id AND nekpl.pl_target_id = nektar.lt_id AND nektar.lt_namespace = 0 AND person.page_title = nektar.lt_title AND person.page_namespace = nektar.lt_namespace AND person.page_id = pdtl.tl_from AND pdtl.tl_target_id = pdtar.lt_id AND pdtar.lt_title = 'Personendaten' AND pdtar.lt_namespace = 10 AND cl_from IS NULL; SELECT nekrolog.page_title AS "Nekrolog", wl.page_title AS "Weiterleitung", person.page_title AS "Person (via WL)" FROM page AS nekrolog, pagelinks AS nekpl, linktarget AS nektar, # Pagelink vom Nekrolog zur Person page AS wl LEFT JOIN (templatelinks AS wltl, linktarget AS wltar) ON wl.page_id = wltl.tl_from AND wltl.tl_target_id = wltar.lt_id AND wltar.lt_title = 'Personendaten' AND wltar.lt_namespace = 10, redirect, page AS person LEFT JOIN categorylinks ON person.page_id = cl_from AND cl_to LIKE 'Gestorben_%', templatelinks AS pdtl, linktarget AS pdtar # Person muss PD haben WHERE nekrolog.page_title LIKE "Nekrolog%" AND nekrolog.page_title NOT IN ('Nekrolog_(Tiere)', 'Nekrolog_(Totenverzeichnis)') AND nekrolog.page_namespace = 0 AND nekpl.pl_from = nekrolog.page_id AND nekpl.pl_target_id = nektar.lt_id AND nektar.lt_namespace = 0 AND wl.page_title = nektar.lt_title AND wl.page_namespace = nektar.lt_namespace AND wltl.tl_from IS NULL # Nur weiterleitungen ohne PD AND rd_from = wl.page_id AND rd_title = person.page_title AND rd_namespace = person.page_namespace AND person.page_id = pdtl.tl_from AND pdtl.tl_target_id = pdtar.lt_id AND pdtar.lt_title = 'Personendaten' AND pdtar.lt_namespace = 10 AND cl_from 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...