Rotlink-Begriffsklärungen

SQL

use dewiki_p;
SELECT p1.page_title AS "Artikel", tl_title as "Baustein", 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 IN ("Begriffsklärungshinweis", "Dieser_Artikel")
   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...
