This query is marked as a draft This query has been published by Wurgl.

SQL

AخA
 
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...