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

SQL

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

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

#describe actor;
#describe revision;

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

SELECT /* SLOW_OK */ page.page_namespace, page.page_title, actor.actor_name
    FROM revision, page, actor
    WHERE actor.actor_name in ("Z thomas", "Geolina163", "Stefan Fadinger",
                               "MB-one", "Fyrtaarn", "Cookroach", "Ailura",
                               "GPSLeo", "Rainer Halama", "Jasnaah")
        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
    GROUP BY revision.rev_page, actor.actor_name
    #limit 100
    ;
SQL

Checking query status...
