[massive] Articles with 2 edits from a set of bots + users

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,4114,4379,7440,7699,12135,54357,79723,89955,95806,139384, 178,191,488,1115,2031,2579,2905,2710,2819,3968,4138,5679,5715,5891,5947,5982,6022,6049,6165,6134,6160,6167,6170,6259,6342,6383,6401,6478,6540,7027,7129,7211,7558,7817,7956,8013,8129,8148,8339,8501,8153,9327,8432,8546,9400,9441,9492,9533,9541,9569,10130,10319,10615,10828,10881,11526,11842,12031,12266,12475,12477,12793,13153,13217,13332,13527,13555,13974,14717,14745,14794,15855,15910,15961,16280,18380,18402,18497,19071,19147,20531,20649,20638,22448,31777,33439,42809,122330,132129)
    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,4379,7440,7699,12135,54357,79723,89955,95806,139384, 178,191,488,1115,2031,2579,2905,2710,2819,3968,4138,5679,5715,5891,5947,5982,6022,6049,6165,6134,6160,6167,6170,6259,6342,6383,6401,6478,6540,7027,7129,7211,7558,7817,7956,8013,8129,8148,8339,8501,8153,9327,8432,8546,9400,9441,9492,9533,9541,9569,10130,10319,10615,10828,10881,11526,11842,12031,12266,12475,12477,12793,13153,13217,13332,13527,13555,13974,14717,14745,14794,15855,15910,15961,16280,18380,18402,18497,19071,19147,20531,20649,20638,22448,31777,33439,42809,122330,132129)
    and
        r.rev_parent_id = 0
)
AND p.page_is_new = 0
AND u.rev_actor in (40,4114,4379,7440,7699,12135,54357,79723,89955,95806,139384, 178,191,488,1115,2031,2579,2905,2710,2819,3968,4138,5679,5715,5891,5947,5982,6022,6049,6165,6134,6160,6167,6170,6259,6342,6383,6401,6478,6540,7027,7129,7211,7558,7817,7956,8013,8129,8148,8339,8501,8153,9327,8432,8546,9400,9441,9492,9533,9541,9569,10130,10319,10615,10828,10881,11526,11842,12031,12266,12475,12477,12793,13153,13217,13332,13527,13555,13974,14717,14745,14794,15855,15910,15961,16280,18380,18402,18497,19071,19147,20531,20649,20638,22448,31777,33439,42809,122330,132129)
ORDER BY
    rev_timestamp desc;
SQL

Checking query status...
