Anzahl Kategorien

SQL

SELECT page_title, el_to_path, comment_text, actor_name, REGEXP_REPLACE(rev_timestamp, '\(....\)\(..\)\(..\)\(..\)\(..\)\(..\).*$', '\\1-\\2-\\3 \\4:\\5:\\6') AS timestamp
  FROM revision, comment, templatelinks AS NDt, linktarget AS NDl, templatelinks AS PDt, linktarget AS PDl, actor,
       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'
        OR comment_text LIKE '%GND ist jetzt aber da'
       )
   #AND el_from IS NULL
   AND NDt.tl_from = page_id
   AND NDt.tl_target_id = NDl.lt_id
   AND NDl.lt_title = 'Normdaten'
   AND NDl.lt_namespace = 10
   AND PDt.tl_from = page_id
   AND PDt.tl_target_id = PDl.lt_id
   AND PDl.lt_title = 'Personendaten'
   AND PDl.lt_namespace = 10
   AND rev_actor = actor_id
 ORDER BY rev_timestamp DESC
SQL

Checking query status...
