Usuária:Nemo bis/patrulhadores

SELECT
    count(*) AS counter,
    user_name,
    user_editcount,
    GROUP_CONCAT(DISTINCT ug_group SEPARATOR ", ")

FROM logging log

JOIN user us
  ON log.log_user = us.user_id

JOIN user_groups ug
  ON log.log_user = ug.ug_user

WHERE ug.ug_user NOT IN
  (SELECT DISTINCT user_groups.ug_user
   FROM user_groups
   WHERE ug_group = 'sysop'
   OR ug_group = 'rollbacker'
  )
AND log.log_type = 'patrol'
AND log.log_action = 'patrol'
AND ( log.log_params LIKE '%"6::auto";i:0%'
OR    log.log_params LIKE '%\n0' /* not autopatrolled */ )
AND log.log_timestamp > NOW() - INTERVAL 2 MONTH + 0
GROUP BY log.log_user

ORDER BY counter DESC
LIMIT 50;

Non rollbacker editar

2 months

counter user_name       user_editcount  GROUP_CONCAT(DISTINCT ug_group SEPARATOR ", ")
645     Geovani.s       3937    autoreviewer
411     Andreazevedo    7510    autoreviewer
306     MOC     3005    autoreviewer
146     Helder.wiki     12312   autoreviewer
42      Felipe P        63859   ipblock-exempt, autoreviewer
42      Bruno Ishiai    8531    autoreviewer, ipblock-exempt
38      Ezalvarenga     2678    autoreviewer
35      Miguelrangeljr  6124    autoreviewer
31      Lijealso        114448  eliminator
27      Fúlvio  1545    autoreviewer
22      Brandizzi       4100    autoreviewer
17      Everton137      2055    autoreviewer
15      Sylvio Sant     2213    autoreviewer
13      Econt   6421    autoreviewer
12      Fsantos222      2751    autoreviewer
12      Outis   1591    autoreviewer
12      Pedrohoneto     2151    autoreviewer
10      Gustavo gho     8296    autoreviewer
8       Fabsouza1       12639   autoreviewer
7       Conrado 4291    autoreviewer
7       Israelrocha     1197    autoreviewer
5       Lauro Chieza de Carvalho        3453    autoreviewer
4       Net Esportes    4282    autoreviewer
4       Gonçalo Veiga   15072   autoreviewer
4       W.SE    18319   autoreviewer
3       PatríciaR       25195   autoreviewer
3       Sampayu 1389    autoreviewer
3       KiraTHO 3857    autoreviewer
3       Onjacktallcuca  16874   autoreviewer
2       Roni1986        5314    autoreviewer
2       Diego Queiroz   1859    autoreviewer
2       Xico CLJ        795     autoreviewer
2       Imagens SM      2821    autoreviewer
2       Marcelo Henrique Bittencourt    1263    autoreviewer
2       Gabriel bier    4014    autoreviewer
1       Rui Silva       55133   autoreviewer
1       Thom    3410    autoreviewer
1       Eleefecosta     5545    autoreviewer
1       Gustavo Siqueira        17199   autoreviewer
1       Rush    19612   autoreviewer
1       EUDOXIO 5875    autoreviewer
1       Brunonar        1674    autoreviewer
1       OffsBlink       32961   autoreviewer
1       Solstag 592     autoreviewer
1       Danilo.mac      4920    autoreviewer
1       Wallus  836     autoreviewer
1       Giorgione62     2581    autoreviewer
1       Aflis   2460    autoreviewer
1       Dennylson Adam  3257    autoreviewer
1       Daniel Mietchen 176     autoreviewer

Rollbacker editar

counter user_name       user_editcount  GROUP_CONCAT(DISTINCT ug_group SEPARATOR ", ")
27424   Baseador        10642   rollbacker, autoreviewer
2910    Angrense        38985   rollbacker, autoreviewer
1756    Cainamarques    4712    autoreviewer, rollbacker
1582    Matheus Faria   10395   rollbacker, eliminator
1310    Coltsfan        40326   autoreviewer, rollbacker
1218    DARIO SEVERI    7689    rollbacker, autoreviewer
1216    OTAVIO1981      21854   rollbacker, autoreviewer
1046    Reporter        15991   autoreviewer, rollbacker
872     Luan    32778   autoreviewer, rollbacker
708     WikiFer 3419    rollbacker, autoreviewer
561     Yanguas 263705  sysop
550     Gjpab   9130    autoreviewer, rollbacker
498     Gabriel Yuji    32550   sysop
488     Kenchikka       8593    autoreviewer, rollbacker
464     Zoldyick        49809   rollbacker, autoreviewer
406     GuilhermeYoung  9638    autoreviewer, rollbacker
360     Py4nf   11293   rollbacker, autoreviewer
360     Vitor Mazuco    158725  ipblock-exempt, rollbacker, autoreviewer
336     Jonas kam       46486   rollbacker, autoreviewer
288     JMGM    61135   autoreviewer, rollbacker
260     Iuri i10        8171    rollbacker, autoreviewer
218     Vanthorn        85941   autoreviewer, rollbacker
214     Raul Caarvalho  3238    autoreviewer, rollbacker
154     Bisbis  124322  rollbacker, autoreviewer
140     Stego   24235   rollbacker, autoreviewer
140     JohnR   6419    rollbacker, autoreviewer
140     Pablodiego15    9613    autoreviewer, rollbacker
130     MUSASHIJAPAN    988     rollbacker
116     Ajpvalente      8509    autoreviewer, rollbacker
100     Lgtrapp 11852   rollbacker, autoreviewer
100     AlchemistOfJoy  1277    autoreviewer, rollbacker
94      Richard Melo da Silva   18996   eliminator, rollbacker
92      Berganus        1911    rollbacker, autoreviewer
90      Leosls  93878   ipblock-exempt, rollbacker
74      GoEThe  40888   rollbacker, autoreviewer
70      Stuckkey        32401   autoreviewer, rollbacker
70      Polyethylen     30956   eliminator, rollbacker
64      Faduart 1084    autoreviewer, rollbacker
60      Pedrassani      11953   autoreviewer, rollbacker
59      Lord Mota       16520   sysop
58      Fulviusbsas     8963    rollbacker, autoreviewer
54      ZackTheJack     3914    autoreviewer, rollbacker
54      Bruno Meireles  17296   rollbacker, autoreviewer
52      Agiesbrecht     7637    rollbacker, autoreviewer
48      Dark-Y  1104    autoreviewer, rollbacker
46      Pdellani        5730    autoreviewer, rollbacker
46      WOtP    1817    rollbacker, autoreviewer
42      Mwaldeck        35822   rollbacker, autoreviewer
38      Stegop  85325   rollbacker, autoreviewer
36      Teles   50833   checkuser, bureaucrat, sysop, oversight
34      Fabiano Tatsch  120689  sysop
33      Tiago Abreu     16742   ipblock-exempt, rollbacker, eliminator
30      Prima.philosophia       5220    rollbacker, autoreviewer
28      Dédi's  36107   sysop
28      Joao4669        21227   rollbacker, autoreviewer
28      Marcos Elias de Oliveira Júnior 60573   sysop
26      Vitorvicentevalente     38863   eliminator, rollbacker
26      Crash Overclock 6682    autoreviewer, rollbacker
26      Rossi pena      8386    autoreviewer, rollbacker
25      Gean    48939   sysop
24      Acscosta        7910    eliminator, rollbacker
24      Jolielegal      4175    autoreviewer, rollbacker
21      Tetraktys       30305   rollbacker, ipblock-exempt, autoreviewer
16      Doutorgrillo    7846    rollbacker, autoreviewer
16      PauloEduardo    16715   eliminator, rollbacker
15      Francisco Leandro       73668   sysop
14      Ricvelozo       10252   autoreviewer, rollbacker
14      Léo Cebin       2874    rollbacker
14      Clarice Reis    11424   rollbacker, autoreviewer
14      Max51   1422    rollbacker, autoreviewer
13      Eric Duff       83615   sysop
12      Alexanderps     41049   sysop
12      LuizM   10201   rollbacker, eliminator
12      Gusta   4371    rollbacker, eliminator
11      Belanidia       36416   sysop
10      Tonelada        2240    rollbacker, autoreviewer
10      Carlos28        29475   autoreviewer, rollbacker
10      Polemaco        9489    rollbacker, autoreviewer
8       Rodrigolopes    9162    rollbacker, autoreviewer
8       PauloHenrique   16333   eliminator, rollbacker
7       Daimore 58400   sysop
7       José AF 20295   rollbacker
6       André Koehne    48104   autoreviewer, rollbacker
6       Viniciusmc      61232   autoreviewer, rollbacker
5       FSogumo 41195   sysop
5       HVL     46494   sysop
4       João Carvalho   110032  eliminator, rollbacker
4       Willy Weazley   16297   sysop
4       Mathonius       564     rollbacker, autoreviewer
4       Érico Júnior Wouters    54212   sysop, bureaucrat
4       PedR    12361   rollbacker, autoreviewer, ipblock-exempt, bureaucrat
3       Castelobranco   16477   sysop
3       Rjclaudio       87138   sysop
2       Juntas  24248   autoreviewer, rollbacker
2       Giro720 41888   autoreviewer, rollbacker
2       Joseolgon       31545   rollbacker, autoreviewer
2       Jo Lorib        37581   sysop
2       MachoCarioca    62632   autoreviewer, rollbacker
2       EuTuga  59151   sysop
2       Kaktus Kid      89472   autoreviewer, rollbacker
2       Chronus 61400   autoreviewer, rollbacker
2       RafaAzevedo     153286  autoreviewer, rollbacker
2       Ruy Pugliesi    47550   bureaucrat, sysop
2       Rafael Kenneth  9580    autoreviewer, rollbacker
2       Opraco  13099   sysop
2       Renato de carvalho ferreira     44401   rollbacker, autoreviewer
2       Holdfz  1698    rollbacker
1       Hermógenes Teixeira Pinto Filho 67787   sysop