Untitled query #31487

SQL

use dewiki_p;
SELECT CONCAT('[[', REPLACE(bkl.page_title, '_', ' '), ']]') AS Titel
  FROM page AS bkl, templatelinks
 WHERE bkl.page_namespace = 0
   AND tl_from = bkl.page_id
   AND tl_from_namespace = bkl.page_namespace
   AND tl_title = 'Begriffsklärung'
   AND tl_namespace = 10
   AND NOT EXISTS ( SELECT 1
                      FROM page as nichtPerson, pagelinks
                     WHERE bkl.page_id = pl_from
                       AND bkl.page_namespace = pl_from_namespace
                       AND pl_namespace = 0
                       AND pl_title = nichtPerson.page_title
                       AND pl_namespace = nichtPerson.page_namespace
                       AND NOT EXISTS ( SELECT 1 FROM categorylinks
                                         WHERE nichtPerson.page_namespace = 0
                                           AND nichtPerson.page_id = cl_from
                                           AND cl_to NOT IN ('Mann', 'Frau', 'Intersexueller', 'Transgender-Person', 'Geschlecht_unbekannt')
                                      )
                  )
LIMIT 10
SQL

Checking query status...
