Untitled query #39675

SQL

USE dewiki_p;
SELECT p0.page_title, CONCAT(SUBSTRING_INDEX(p0.page_title, '_(', 1), '_(Begriffsklärung)')
  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 (LOWER(p1.page_title) = LOWER(SUBSTRING_INDEX(p0.page_title, '_(', 1))
                           OR LOWER(p1.page_title = LOWER(CONCAT(SUBSTRING_INDEX(p0.page_title, '_(', 1), '_(Begriffsklärung)'))
                          )
                      AND tl_from = p1.page_id
                      AND tl_title = 'Begriffsklärung'
                  )
LIMIT 100;
SQL

Checking query status...
