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

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 in (40/*AG*/,4114/*Fixer88*/,54357/*mws*/,95806/*LV*/,12135/*Vanished*/,89955/*Minorax*/)
    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/*AG*/,4114/*Fixer88*/,54357/*mws*/,95806/*LV*/,12135/*Vanished*/,89955/*Minorax*/)
    and
        r.rev_parent_id in (
            select distinct
                i.rev_id
            from
                revision_userindex i
            where
                i.rev_actor in (40/*AG*/,4114/*Fixer88*/,54357/*mws*/,95806/*LV*/,12135/*Vanished*/,89955/*Minorax*/)
            and
                i.rev_parent_id in (
                    select distinct
                        a.rev_id
                    from
                        revision_userindex a
                    where
                        a.rev_actor in (40/*AG*/,4114/*Fixer88*/,54357/*mws*/,95806/*LV*/,12135/*Vanished*/,89955/*Minorax*/)
                    and
                        a.rev_parent_id in (
                          select
                          o.rev_id
                          from
                          revision_userindex o
                          where
                          o.rev_actor in (40/*AG*/,4114/*Fixer88*/,54357/*mws*/,95806/*LV*/,12135/*Vanished*/,89955/*Minorax*/)
                          and
                          o.rev_parent_id in (
                            select
                            s.rev_id
                            from
                            revision_userindex s
                            where
                            s.rev_actor in (40/*AG*/,4114/*Fixer88*/,54357/*mws*/,95806/*LV*/,12135/*Vanished*/,89955/*Minorax*/)
                            and
                            s.rev_parent_id = 0
                          )
                        )
                    )
            )
)
AND p.page_is_new = 0
AND u.rev_actor in (40/*AG*/,4114/*Fixer88*/,54357/*mws*/,95806/*LV*/,12135/*Vanished*/,89955/*Minorax*/)
ORDER BY
    rev_timestamp desc;
SQL

Checking query status...
