Biografien - Quarry

SQL

USE dewiki_p;
SELECT COUNT(page_id) AS "Seiten mit Vorlage Personendaten aka Biografien", SUM(page_is_redirect = 0) AS "ohne Weiterleitungen"
  FROM page, templatelinks
 WHERE page_id = tl_from
   AND page_namespace = 0
   AND tl_title = 'Personendaten';
SELECT COUNT(page_id) AS "Kategorie Mann + Kategorie Frau"
  FROM page, templatelinks, categorylinks
 WHERE page_id = tl_from
   AND page_namespace = 0
   AND tl_title = 'Personendaten'
   AND cl_from = page_id
   AND ct_to = 'Mann'
   AND EXISTS ( SELECT 1
                  FROM categorylinks
                 WHERE cl_from = page_id
                   AND ct_to = 'Frau'
              )
SQL

Checking query status...
