Untitled query #66207

SQL

SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') AS "Artikel", page_is_redirect AS "Weiterleitung"
  FROM page, templatelinks
 WHERE page_namespace = 0
   AND page_title rlike ".*[A-Z]\\.[A-Z]\\._.*"
   AND tl_from = page_id
   AND tl_title = 'Personendaten'
   AND tl_namespace = 10
UNION
SELECT CONCAT('[[', REPLACE(R.page_title, '_', ' '), ']]') AS "Artikel", R.page_is_redirect AS "Weiterleitung"
  FROM page AS R, page as P, redirect, templatelinks
 WHERE R.page_namespace = 0
   AND R.page_is_redirect = 1
   AND R.page_title rlike ".*[A-Z]\\.[A-Z]\\._.*"
   AND R.page_id = rd_from
   AND rd_title = P.page_title
   AND rd_namespace = P.page_namespace
   AND P.page_namespace = 0
   AND tl_from = P.page_id
   AND tl_title = 'Personendaten'
   AND tl_namespace = 10
SQL

Checking query status...
