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 /* SLOW_OK */
    page.page_namespace, 
    page.page_title, 
    actor.actor_name, 
    comment.comment_text
FROM revision
JOIN page ON revision.rev_page = page.page_id
JOIN actor ON actor.actor_id = revision.rev_actor
JOIN comment ON revision.rev_comment_id = comment.comment_id
WHERE actor.actor_name in ("Herzi Pinki")
    AND revision.rev_timestamp >= @from_timestamp 
    AND revision.rev_timestamp <= @to_timestamp
    AND (
        comment.comment_text REGEXP '(Merged Item|\\[\\[Property:(P18|P5775|P5252|P8592|P3311|P3451|P9721|P11832|P11702|P10544|P9906|P8517|P4291|P1801|P1766|P1442|P154)\\]\\])'
    )
LIMIT 100;
SQL

Checking query status...
