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

SQL

USE commonswiki_p;
set @timestamp:=20230616220000; # registration time threshold for new users

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 COUNT(page.page_title) as page_count
    FROM actor, revision, page, user 
    WHERE page.page_id=categorylinks.cl_from
        AND @aid = revision.rev_actor
        AND image.img_name = page.page_title
        and revision.rev_page = page.page_id
        and user.user_id = @auser
    GROUP BY user 
    ORDER BY img_count DESC limit 300;

SQL

Checking query status...