Anzahl Kategorien

SQL

SELECT page_title
  FROM revision, comment, templatelinks AS NDt, link_target AS NDl, templatelinks AS PDt, link_target AS PDl,
       page LEFT JOIN externallinks
              ON el_from = page_id
             AND el_to_domain_index = 'https://info.d-nb.'
             AND el_to_path LIKE '/gnd/%' WHERE page_namespace = 0
   AND page_id = rev_page
   AND rev_comment_id = comment_id
   AND comment_text = 'GND vorhanden'
   AND el_from IS NULL
   AND NDt.tl_from = page_id
   AND NDt.tl_target_id = NDl.id
   AND NDl.lt_title = 'Normdaten'
   AND NDl.lt_namespace = 10
   AND PDt.tl_from = page_id
   AND PDt.tl_target_id = PDl.id
   AND PDl.lt_title = 'Personendaten'
   AND PDl.lt_namespace = 10
SQL

Checking query status...
