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
.
nicht kategorisierte Weiterleitungen zu Orten in Oberösterreich
Toggle Highlighting
SQL
USE dewiki_p; SELECT CONCAT('[[', REPLACE(wl.page_title, '_', ' '), ']]') as Weiterleitung, CONCAT('[[', REPLACE(ziel_seite.page_title, '_', ' '), ']]') as Weiterleitungsziel, CONCAT('[[', REPLACE(ziel_kategorie.cl_to, '_', ' '), ']]') as Kategorie FROM page as wl LEFT JOIN categorylinks AS wl_kategorie ON wl_kategorie.cl_from = wl.page_id, redirect, categorylinks AS ziel_kategorie, page as ziel_seite WHERE wl_kategorie.cl_from IS NULL AND wl.page_namespace = 0 AND wl.page_is_redirect = 1 AND wl.page_id = rd_from AND rd_title = ziel_seite.page_title AND rd_namespace = ziel_seite.page_namespace AND ziel_seite.page_namespace = 0 AND ziel_seite.page_id = ziel_kategorie.cl_from AND ziel_kategorie.cl_to IN (SELECT page_title FROM page, categorylinks WHERE page.page_id = categorylinks.cl_from AND categorylinks.cl_to = 'Ort_in_Oberösterreich') ORDER BY Kategorie, Weiterleitungsziel
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...