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

Fork of List of articles with 4 edits and only one editor by MJL
This query is marked as a draft This query has been published by MJL.
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 v.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 in (
            select distinct
                i.rev_id
            from
                revision_userindex i
            where
                i.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
                i.rev_parent_id in (
                    select distinct
                        a.rev_id
                    from
                        revision_userindex a
                    where
                        a.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
                        a.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)
AND p.page_latest = u.rev_id
ORDER BY
    rev_timestamp desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
