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