Untitled query #80606

SQL

set max_statement_time = 150;
set @rev_actors := (
  select GROUP_CONCAT(distinct rev_actor)
  from revision
  where rev_timestamp >= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 30 DAY), '%Y%m%d%H%i%s')
  and rev_page in (
    20571048, 1485927, 72713524, 70432805, 38596219,
    53122929, 53818243, 70172637, 60169501, 24839334,
    19160240, 70086646, 28661466, 64467707, 61020182,
    1168189, 45271353, 36581929, 11507151, 21127042,
    45382070, 57112635, 66515250, 62769696, 9636597,
    22314151, 37482492, 65362125, 59617242, 19657223,
    51207072, 61862956, 68777452, 64467696, 11049,
    4398946, 67565978, 33334134, 3121486, 52932839,
    5271467, 11250, 2950983, 39367087, 1234398,
    3142424, 1174133, 3728077, 715249, 4798997,
    11933508, 19160226, 71347797, 38449748, 60983910,
    73636705, 64496091, 35283448, 75059357, 72194040,
    72223288, 11791527, 58111258, 3812445, 1044538,
    2778679, 3931425, 6307095, 1071095, 28984,
    15116, 331715, 5596387, 9221970, 36138705,
    36615077, 16074597, 3910640, 1240677, 14017832,
    74155372, 11659670, 30623501, 448902, 48085960,
    1054768, 35678135, 60709550, 45163240, 2301860,
    66119642, 47144522, 1301373, 14338589, 1741728,
    63658573, 69486304, 48116360, 2934561, 50461635,
    250683, 61226268, 36447, 15496, 28637345, 2028981,
    10160542, 8966301, 28661137, 51254703, 7754377,
    45123052, 72504121, 7673602, 75156428, 48436475,
    33564869, 20702557, 26939721, 38655749, 42592508,
    42924474, 4573068, 24274818, 40880638, 74513310,
    63116433, 25370544, 50984578, 37100715, 2319623,
    1637405, 24630290, 28155691, 71300185, 64635534,
    511282, 51505266, 18485974, 51505067, 42134342,
    64987533, 48734261, 1877139, 61778781, 34315462,
    36356436, 7851344, 8623237, 35035011, 40533634,
    481786, 193225, 69744021, 18398764, 76052436,
    61063938, 36232577, 5646147, 157871, 6702022,
    629239, 45093506, 27041347, 76036028, 39321645,
    18637879, 44747195, 772540, 1075590, 3071193,
    3285435, 3285439, 24151504, 30364680, 2518495,
    46544583
  )
);
select * /* DATE_FORMAT(rc_uc.rc_timestamp, '%Y-%m-%d %H:%i:%s') as timestamp, rc_uc.rc_title */
from recentchanges_userindex
inner join actor_recentchanges on rc_actor = actor_id
inner join user on actor_user = user_id
where rc_type = 3
and rc_log_type = 'newusers'
and 3 in (
  select ct_tag_id
  from change_tag
  where rc_logid = ct_log_id
)
and user_editcount > 0
and rc_title regexp '^[A-Z0-9]*$'
and FIND_IN_SET(rc_actor, @rev_actors)
order by rc_timestamp desc;
SQL

Checking query status...
