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 DISTINCT PP.page_title FROM pagelinks AS JPL, page AS J, pagelinks AS TPL, categorylinks, page AS PP LEFT JOIN (templatelinks, linktarget) ON PP.page_id = tl_from AND tl_target_id = lt_id AND lt_title = 'Personendaten' AND lt_namespace = 10 WHERE PP.page_namespace = 0 AND tl_from IS NULL AND JPL.pl_title = PP.page_title AND JPL.pl_namespace = PP.page_namespace AND J.page_id = JPL.pl_from AND J.page_title RLIKE "^[1-9][0-9]+$" AND J.page_namespace = 0 AND TPL.pl_title = PP.page_title AND TPL.pl_namespace = PP.page_namespace AND cl_from = TPL.pl_from AND cl_to = 'Tag' LIMIT 100
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...