Untitled query #39675

SQL

USE dewiki_p;
SELECT p0.page_title
  FROM page AS p0
 WHERE p0.page_namespace = 0
   AND p0.page_title LIKE "%_(%)"
   AND NOT EXISTS (SELECT 1
                     FROM templatelinks
                    WHERE tl_from = p0.page_id
                      AND tl_title = 'Begriffsklärung'
                  )
   AND NOT EXISTS (SELECT 1
                     FROM page as p1, templatelinks
                    WHERE p1.page_namespace = 0
                      AND (p1.page_title = SUBSTRING_INDEX(p0.page_title, '_(', 1)
                           OR p1.page_title = CONCAT(SUBSTRING_INDEX(p0.page_title, '_(', 1), '_(Begriffsklärung)')
                          )
                      AND tl_from = p1.page_id
                      AND tl_title = 'Begriffsklärung'
                  )
 LIMIT 10;
SQL

Checking query status...
