Untitled query #36629

SQL

use arwiki_p;
set @actorid = (select * from actor where actor_user = 1625017);

select user_id, rev_timestamp, rev_id, page_id, page_namespace from
            (select user_id, ts as rev_timestamp, rev_id, rev_page from
            (select a.rev_actor as user_id, timestamp(a.rev_timestamp) as ts, a.rev_id as rev_id, timestamp(b.mts) as mts, rev_page
            from
            (select rev_actor, rev_timestamp, rev_id, rev_page from revision_userindex where rev_actor = @actorid and rev_timestamp <= 20190604052608) a
            join
            (select rev_actor, max(rev_timestamp) as mts from revision_userindex where rev_actor = @actorid and rev_timestamp <= 20190604052608)  b
            on a.rev_actor = b.rev_actor
            ) uhist
            where ts > date_sub(mts, interval 84 day)
            limit 50) revs
            join page
            on rev_page = page_id;
SQL

Checking query status...
