GNDName entfernt

SQL

SELECT count(*) As "Anzahl", substr(rev_timestamp, 1, 8) as "Datum"
  FROM page, revision, actor, comment
 WHERE rev_page = page_id
   AND page_namespace = 0
   AND rev_actor = actor_id
   AND actor_name = 'APPERbot'
   AND rev_comment_id = comment_id
   AND comment_text like '%GNDName nicht mehr notwendig%'
   AND rev_timestamp > '20210701000000'
 GROUP BY substr(rev_timestamp, 1, 8);

SELECT page_title, rev_timestamp, comment_text
  FROM page, revision, actor, comment
 WHERE rev_page = page_id
   AND page_namespace = 0
   AND rev_actor = actor_id
   AND actor_name = 'APPERbot'
   AND rev_comment_id = comment_id
   AND comment_text like '%GNDName nicht mehr notwendig%'
   AND rev_timestamp > '20210701000000'
 ORDER BY rev_timestamp DESC
SQL

Checking query status...
