[super massive] Articles with 1-6 edits from a set of bots + users

Fork of [massive] Articles with 6 edits from a set of bots + users by MJL
This query is marked as a draft This query has been published by MJL.
SQL

/* Users:
40 - AG
4114 - Fixer88
4379 - Cekli829
54357 - Mock wurzel soup
95806 - Lee Vilenski
12135 - Vanished
89955 - Minorax
79723 - MJL
139384 - James Salsman
7440 - Jimjom
7699 - Varlaam
Bots:
178 - EmausBot
191 - Chobot
488 - CommonsDelinker
1115 - Dexbot
2031 - YiFeiBot
2579 - JAnDbot
2905 - TohaomgBot
2710 - MediaWiki message delivery
2819 - MABot
3968 - KLBot2
4138 - Robbot
5679 - YurikBot
5715 - RobotJcb
5891 - Escarbot
5947 - Thijs!bot
5982 - MediaWiki default
6022 - TXiKiBoT
6049 - VolkovBot
6165 - PipepBot
6134 - Byrialbot
6160 - SieBot
6167 - BotMultichill
6170 - AlleborgoBot
6259 - Alexbot
6342 - MelancholieBot
6383 - タチコマ robot
6401 - SpBot
6478 - Zorrobot
6540 - CarsracBot
7027 - HerculeBot
7129 - Synthebot
7211 - DragonBot
7558 - Luckas-bot
7817 - LaaknorBot
7956 - ArthurBot
8013 - SilvonenBot
8129 - Idioma-bot
8148 - Nallimbot
8339 - Darkicebot
8501 - SassoBot
8153 - Xqbot
9327 - D'ohBot
8432 - BodhisattvaBot
8546 - Rubinbot
9400 - Louperibot
9441 - Obersachsebot
9492 - Jotterbot
9533 - TobeBot
9541 - FoxBot
9569 - DSisyphBot
10130 - KamikazeBot
10319 - Dinamik-bot
10615 - MastiBot
10828 - MystBot
10881 - Gerakibot
11526 - BOTijo
11842 - Amirobot
12031 - JhsBot
12266 - HRoestBot
12475 - Diego Grez Bot
12477 - JackieBot
12793 - RedBot
13153 - WikitanvirBot
13217 - Mjbmrbot
13332 - ZéroBot
13527 - TjBot
13555 - DixonDBot
13974 - Movses-bot
14717 - CocuBot
14745 - Ripchip Bot
14794 - MerlIwBot
15855 - PixelBot
15910 - Vagobot
15961 - AvocatoBot
16280 - HiW-Bot
18380 - DarafshBot
18402 - JYBot
18497 - MahdiBot
19071 - YFdyh-bot
19147 - Justincheng12345-bot
20531 - Legobot
20649 - SantoshBot
20638 - Makecat-bot
22448 - Addbot
31777 - Maintenance script
33439 - KasparBot
42809 - JJMC89 bot
122330 - RomaineBot
132129 - NadzikBOT
*/
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 p.page_namespace = 0
AND p.page_is_redirect = 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 u.rev_parent_id = 0
OR u.rev_parent_id IN (
    select distinct
        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
    or
        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 = 0
            or
                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
                    or
                        a.rev_parent_id in (
                          select distinct
                          o.rev_id
                          from
                          revision_userindex o
                          where
                          o.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
                          o.rev_parent_id = 0
                          or
                          o.rev_parent_id in (
                            select distinct
                            s.rev_id
                            from
                            revision_userindex s
                            where
                            s.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
                            s.rev_parent_id = 0
                          )
                          and o.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_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_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_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_namespace = 0
AND p.page_is_redirect = 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;
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...
