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
.
Jeweils Weiterleitung Artikel, wo beide die Vorlage Personendaten haben und (mindestens) einer der beiden in der Kategorie Pseudonym steckt
Toggle Highlighting
SQL
SELECT WL.page_title, A.page_title FROM page AS WL, page AS A, redirect, templatelinks AS TWL, templatelinks AS TA, linktarget WHERE WL.page_namespace = 0 AND A.page_namespace = 0 AND rd_from = WL.page_id AND rd_title = A.page_title AND rd_namespace = 0 AND TWL.tl_from = WL.page_id AND TA.tl_from = A.page_id AND TWL.tl_target_id = lt_id AND TA.tl_target_id = lt_id AND lt_namespace = 10 AND lt_title = 'Personendaten' AND (EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = A.page_id AND cl_to LIKE "%Pseudonym%" ) OR EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = WL.page_id AND cl_to LIKE "%Pseudonym%" ) )
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...