BKL-Seiten mit genau einem Rot- und einem Blaulink

SQL

USE dewiki_p;
SELECT source.page_title AS "Artikel", pl_title AS "ROTLINK", blaulink.page_title AS "möglicher ERSATZ"
  FROM page as source, page AS blaulink,
       pagelinks LEFT JOIN page as rotlink
                        ON rotlink.page_title = pl_title
                       AND rotlink.page_namespace = 0
 WHERE pl_title like "%(Fussballspieler)"
   AND pl_from_namespace = 0
   AND rotlink.page_id IS NULL
   AND blaulink.page_namespace = 0
   AND blaulink.page_title like CONCAT(SUBSTR(pl_title, 0, LENGTH(pl_title) - 1), ',%')
   AND source.page_id = pl_from
 LIMIT 10

SQL

Checking query status...