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 = pl_namespace
 WHERE pl_title like "%(Fussballspieler)"
   AND pl_from_namespace = 0
   AND pl_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 */

SQL

Checking query status...