Untitled query #34398

SQL

use enwiki_p;
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_user 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_user, rev_timestamp, rev_id, rev_page from revision_userindex where rev_user = 13023703 and rev_timestamp <= 20180101000000) a
            join
            (select rev_user, max(rev_timestamp) as mts from revision_userindex where rev_user = 13023703 and rev_timestamp <= 20180101000000)  b
            on a.rev_user = b.rev_user
            ) uhist
            where ts > date_sub(mts, interval 84 day)
            limit 50) revs
join page
on rev_page = page_id;
SQL

Checking query status...
