BKL-Seiten mit genau einem Rot- und einem Blaulink

SQL

USE dewiki_p;
SELECT p.page_title, COUNT(b.pl_from) AS bcnt, COUNT(r.pl_from) AS rcnt
  FROM page AS p, templatelinks, pagelinks AS b, page AS bp, pagelinks AS r LEFT JOIN page AS rp
                                                                                   ON r.pl_title = rp.page_title
                                                                                  AND r.pl_namespace = rp.page_namespace
 WHERE tl_from = p.page_id
   AND tl_from_namespace = 0
   AND tl_namespace = 10
   AND tl_title = "Begriffsklärung"
   AND b.pl_from = p.page_id
   AND b.pl_namespace = 0
   AND b.pl_title = bp.page_title
   AND b.pl_namespace = bp.page_namespace
   AND r.pl_from = p.page_id
   AND r.pl_namespace = 0
   AND rp.page_id IS NULL
 GROUP BY p.page_title
HAVING bcnt = 1
   AND rcnt > 0
SQL

Checking query status...
