Untitled query #60462

SQL

USE arwiki_p;
SELECT DISTINCT
    p.page_title AS "page_title",
    u.rev_timestamp as "rev_timestamp"
FROM
    revision_userindex u
JOIN page p ON p.page_id = u.rev_page
WHERE u.rev_parent_id IN (
    select distinct
        r.rev_id
    from 
        revision_userindex r
    where 
        r.rev_actor = 1008680
    and
        r.rev_parent_id in (
            select distinct
                i.rev_id
            from
                revision_userindex i
            where
                i.rev_actor = 1008680
            and
                i.rev_parent_id = 0
        )
)
AND p.page_latest in (
    select distinct
        v.rev_id
    from 
        revision_userindex v
    join page e ON e.page_id = v.rev_page
    where 
        v.rev_actor = 1008680
    and
        e.page_namespace = 0
    and
        e.page_is_redirect = 0
)
AND p.page_is_new = 0
ORDER BY
    rev_timestamp desc;
SQL

Checking query status...
