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.