(obsolete) number of touched articles by user in time interval

SQL

#USE commonswiki_p;
#USE wikidatawiki_p;
#dewiki_p
#29. September bis 1. Oktober 
set @from_timestamp:=20230929220000; # from
set @to_timestamp:=20231001220000; # to
set @from_timestamp:=20231105080500; # from
set @to_timestamp:=20231105080900; # to
#set @to_timestamp:=20230929220500; # to

select * /*actor.actor_user */
from actor
where actor.actor_name = "Z thomas";

#describe actor;
describe revision;
describe comment;

set @aid:=8589;
set @auser:=283815;

SELECT /* SLOW_OK */ page.page_namespace, page.page_title, actor.actor_name, comment.comment_text
    FROM revision, page, actor, comment
    #WHERE actor.actor_name in ("Z thomas", "Geolina163", "Stefan Fadinger", "MB-one", "Fyrtaarn", "Cookroach", "Ailura", "GPSLeo", "Rainer Halama", "Jasnaah", "Maclemo")
    WHERE actor.actor_name in ("Herzi Pinki")
        and actor.actor_id = revision.rev_actor 
        and revision.rev_page = page.page_id
        and revision.rev_timestamp >= @from_timestamp 
        and revision.rev_timestamp <= @to_timestamp
        and revision.rev_comment_id = comment.comment_id
        #AND comment.comment_text REGEXP "(\\[\\[Property:(P18|P5775|P5252|P8592|P3311|P3451|P9721|P11832|P11702|P10544|P9906|P8517|P4291|P1801|P1766|P1442|P154)\\]\\]|Merged Item)"
        #AND comment.comment_text LIKE "%Merged Item%"
    #GROUP BY revision.rev_page, actor.actor_name
    limit 100
    ;
SQL

Checking query status...
