Articles created with 2-3 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
    or
        r.rev_parent_id in (
            select distinct
                p.rev_id
            from
                revision_userindex p
            join page i ON i.page_id = p.rev_page
                where
                    p.rev_actor in (
                      select
                        c.actor_id
                      from
                        actor c
                      where
                        c.actor_name = 'AvicBot'
                      or
                        c.actor_name = 'AmaryllisGardener'
                      or
                        c.actor_name = 'タチコマ robot'
                      or
                        c.actor_name = 'TohaomgBot'
                      or
                        c.actor_name = 'NadzikBOT'
                      or
                        c.actor_name = 'KasparBot'
                      or
                        c.actor_name = 'JJMC89 bot'
                      or
                        c.actor_name = 'Escarbot'
                      or
                        c.actor_name = 'CommonsDelinker'
                    )
                and
                    i.page_namespace = 0
                and
                    i.page_is_redirect = 0
                and
                    p.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...
