Rotlink-Begriffsklärungen

SQL

use dewiki_p;
show VARIABLES WHERE Variable_name = 'hostname';
SELECT p1.page_title AS "Artikel", pl_title AS "BKL auf …"
  FROM templatelinks, page AS p1, pagelinks LEFT JOIN page AS p2 ON p2.page_title = pl_title
                                                 AND p2.page_namespace = pl_namespace
 WHERE tl_from = p1.page_id
   AND tl_from_namespace = 0
   AND tl_title = "Begriffsklärungshinweis"
   AND tl_namespace = 10
   AND pl_from_namespace = 0
   AND pl_namespace = 0
   AND p2.page_id IS NULL
   AND pl_title like "%_(Begriffsklärung)"
   AND p1.page_id = pl_from
SQL

Checking query status...
