List of articles with 4 edits and only one editor

SQL

USE scowiki_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 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 = 40
    and
        e.page_namespace = 0
    and
        e.page_is_redirect = 0
)
AND u.rev_parent_id IN (
    select
        r.rev_id
    from 
        revision_userindex r
    where 
        r.rev_actor = 40
    and
        r.rev_parent_id in (
            select distinct
                i.rev_id
            from
                revision_userindex i
            where
                i.rev_actor = 40
            and
                i.rev_parent_id in (
                    select distinct
                        a.rev_id
                    from
                        revision_userindex a
                    where
                        a.rev_actor = 40
                    and
                        a.rev_parent_id = 0
                )
        )
AND p.page_is_new = 0
AND u.rev_actor = 40
ORDER BY
    rev_timestamp desc;
SQL

Checking query status...
