Doppelverlinkungen

SQL

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
SQL

Checking query status...
