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

SQL

USE commonswiki_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 */ COUNT(revision.rev_page) as page_count, distinct page.page_title
    FROM revision, page
    WHERE @aid = 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;
    limit 100;

SQL

Checking query status...