List of articles with 6 edits and only a set of editors or bots

SQL

/* Users:
40 - AG
4114 - Fixer88
54357 - Mock wurzel soup
95806 - Lee Vilenski
12135 - Vanished
89955 - Minorax
Bots:
6383 - タチコマ robot
2905 - TohaomgBot
132129 - NadzikBOT
33439 - KasparBot
42809 - JJMC89 bot
5891 - Escarbot
488 - CommonsDelinker */
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 in (40,4114,54357,95806,12135,89955,6383,2905,132129,33439,42809,5891,488)
    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 in (40,4114,54357,95806,12135,89955,6383,2905,132129,33439,42809,5891,488)
    and
        r.rev_parent_id in (
            select distinct
                i.rev_id
            from
                revision_userindex i
            where
                i.rev_actor in (40,4114,54357,95806,12135,89955,6383,2905,132129,33439,42809,5891,488)
            and
                i.rev_parent_id in (
                    select distinct
                        a.rev_id
                    from
                        revision_userindex a
                    where
                        a.rev_actor in (40,4114,54357,95806,12135,89955,6383,2905,132129,33439,42809,5891,488)
                    and
                        a.rev_parent_id in (
                          select
                          o.rev_id
                          from
                          revision_userindex o
                          where
                          o.rev_actor in (40,4114,54357,95806,12135,89955,6383,2905,132129,33439,42809,5891,488)
                          and
                          o.rev_parent_id in (
                            select
                            s.rev_id
                            from
                            revision_userindex s
                            where
                            s.rev_actor in (40,4114,54357,95806,12135,89955,6383,2905,132129,33439,42809,5891,488)
                            and
                            s.rev_parent_id = 0
                          )
                        )
                    )
            )
)
AND p.page_is_new = 0
AND u.rev_actor in (40,4114,54357,95806,12135,89955,6383,2905,132129,33439,42809,5891,488)
ORDER BY
    rev_timestamp desc;
SQL

Checking query status...
