Weiterleitung waz.de und mz.de

SQL

# https://de.wikipedia.org/w/index.php?title=Geiselnahme_von_Gladbeck&diff=prev&oldid=247121859
SELECT CONCAT('https://de.wikipedia.org/w/index.php?title=', page_title, '&diff=prev&oldid=', rev_id) AS 'Difflink',
       REGEXP_REPLACE(rev_timestamp, '^(....)(..)(..).*$', '\\3. \\2. \\1') AS 'Datum',
       comment_text AS 'Änderungskommentar'
  FROM page, revision, actor, comment
 WHERE page_namespace = 0
   AND page_id = rev_page
   AND rev_comment_id = comment_id
   AND comment_text like '% Weiterleitung%aufgelöst%'
   AND rev_actor = actor_id
   AND actor_name = 'APPERbot'
   AND rev_timestamp > '20240722000000'
 ORDER BY rev_timestamp DESC
SQL

Checking query status...
