Doppelverlinkungen

SQL

use dewiki_p;
select bkl.page_title as Begriffsklaerung, s.page_title as Direktlink, t.page_title as Weiterleitung
  from page as bkl, page as s, page as t, redirect, pagelinks as tpl, pagelinks as spl, templatelinks, categorylinks
 where rd_from = t.page_id
   and rd_namespace = t.page_namespace
   and t.page_is_redirect = 1
   and rd_title = s.page_title
   and rd_namespace = s.page_namespace
   and tpl.pl_title = t.page_title
   and tpl.pl_namespace = t.page_namespace
   and spl.pl_title = s.page_title
   and spl.pl_namespace = s.page_namespace
   and tpl.pl_from = spl.pl_from
   and tpl.pl_from_namespace = 0
   and spl.pl_from_namespace = 0
   and bkl.page_namespace = 0
   and tpl.pl_from = bkl.page_id
   and s.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...
