Articles created by user with 2 edits of just that user or another

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 u.rev_parent_id IN (
    select distinct
        r.rev_id
    from 
        revision_userindex r
    where 
        r.rev_actor = 40
    and
        r.rev_parent_id = 0
)
AND p.page_latest in (
    select distinct
        r.rev_id
    from 
        revision_userindex r
    join page e ON e.page_id = r.rev_page
    where 
        r.rev_actor in (
            select
                a.actor_id
            from
                actor a
            where
                a.actor_name = 'MJL'
            or
                a.actor_name = 'Fixer88'
            or
                a.actor_name = 'Minorax'
            or
                a.actor_name = 'Bangalamania'
            or
                a.actor_name = 'Mondodi'
            or
                a.actor_name = 'Corsicanwarrah'
            or
                a.actor_name = 'Vanished user 24kwjf10h32h'
        )
    and
        e.page_namespace = 0
    and
        e.page_is_redirect = 0
    and
        r.rev_parent_id = u.rev_parent_id
)
AND p.page_is_new = 0
ORDER BY
    rev_timestamp desc;
SQL

Checking query status...
