Articles created with 2 edits of just that user or bots

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 = 'AvicBot'
            or
                a.actor_name = 'AmaryllisGardener'
            or
                a.actor_name = 'タチコマ robot'
            or
                a.actor_name = 'TohaomgBot'
            or
                a.actor_name = 'NadzikBOT'
            or
                a.actor_name = 'KasparBot'
            or
                a.actor_name = 'JJMC89 bot'
            or
                a.actor_name = 'Escarbot'
            or
                a.actor_name = 'CommonsDelinker'
        )
    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...
