This query is marked as a draft This query has been published by Wurgl.

SQL

AخA
 
use dewiki_p;
select CONCAT("[[", bkl.page_title, "]]") as Begriffsklaerung, d.page_title as Direktlink, v.page_title as Weiterleitung
  from page as bkl, page as d, page as v, redirect, pagelinks as vpl, pagelinks as dpl, templatelinks, categorylinks
 where rd_from = v.page_id
   and rd_namespace = v.page_namespace
   and v.page_is_redirect = 1
   and rd_title = d.page_title
   and rd_namespace = d.page_namespace
   and vpl.pl_title = v.page_title
   and vpl.pl_namespace = v.page_namespace
   and dpl.pl_title = d.page_title
   and dpl.pl_namespace = d.page_namespace
   and vpl.pl_from = dpl.pl_from
   and vpl.pl_from_namespace = 0
   and dpl.pl_from_namespace = 0
   and bkl.page_namespace = 0
   and vpl.pl_from = bkl.page_id
   and d.page_id = tl_from
   and tl_title = "Personendaten"
   and tl_namespace = 10
   and bkl.page_id = cl_from
   and cl_to in ("Begriffsklärung", "Familienname", "Männlicher_Vorname", "Weiblicher_Vorname")
 order by bkl.page_title
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...