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.