(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 */ * # DISTINCT revision.rev_page # COUNT(revision.rev_page) as page_count
    FROM revision
    #WHERE # @aid = revision.rev_actor and
        #revision.rev_timestamp >= @from_timestamp and revision.rev_timestamp <= @totimestamp
    #GROUP BY revision.rev_page;
    limit 100;

SQL

Checking query status...