tgr@fluorine:~$ zcat /a/mw-log/archive/api.log-20160119.gz | head -n 1000000 | grep action=login | grep -Po 'lgname=\S+' | cut -c 8- | sort | uniq -c | sort -rn
78 netmapper
14 CommonsDelinker
10 nasirkhanBot
8 TaxonBot
8 HakanIST
6 L%C3%AA%20L%E1%BB%A3i%20(bot)
6 HangsnaBot2
6 Citation_bot
5 dadebarzan
4 Painforpretty
4 MauroBot
4 Cyberbot%20I
2 W2Bot
2 VeblenBot
2 tilman.krummeck
2 tilmankrummeck
2 tilmank
2 Theo%27s%20Little%20Bot
2 Sky%20Harbor
2 rowis
2 RMCD%20bot
2 Nicole%20Kay
2 nickykenny43@gmail.com
2 Neutron63zf
2 Liangent-bot
2 jhonf_lm
2 jembot
2 InceptionBot
2 Hadfadkar
2 FlickreviewR%202
2 CorenSearchBot
2 BeriBot
2 BeneBot*
2 Beitragszahlen
2 Amalthea%20(bot)
1 ListeriaBot
tgr@fluorine:~$ tail /a/mw-log/api.log -n 1000000 | grep action=login | grep -Po 'lgname=\S+' | cut -c 8- | sort | uniq -c | sort -rn
12329 SDBot
6062 UKBot
3028 Community%20Tech%20bot
3013 FlickreviewR%202
3003 DanmicholoBot
2942 CatWatchBot
2913 SteinsplitterBot
388 %D0%91%D0%BE%D1%82%D1%87%D0%BE
299 BOTzilla
202 Mathbot
76 jembot
74 netmapper
26 yking1988
22 -jem-
18 EmausBot
16 CommonsDelinker
8 Yessica%20Font%20Calero
8 nasirkhanBot
7 HangsnaBot2
6 L%C3%AA%20L%E1%BB%A3i%20(bot)
6 KrBot
6 GiftBot
4 TaxonBot
4 MusikBot
4 LivingBot
4 %E7%B9%81%E8%8A%B1%E4%BC%BC%E9%94%A60000
4 Bas%20cheerthai
4 as_tong2@hotmail.com
2 yunparty
2 Yking1988
2 W2Bot
2 Theo%27s%20Little%20Bot
2 Shahira
2 RickVicious_BTS
2 Not%20registered%20username
2 mraviravi
2 Liangent-bot
2 Joe%27s%20Null%20Bot
2 %D0%90%D0%BD%D0%BD%D0%B0%20%D0%92%D0%B0%D1%80%D0%B3%D0%B0
2 CorenSearchBot
2 Citation_bot
2 carlitos%20hernando
2 BeneBot*
2 AngelReese117
2 Amalthea%20(bot)
1 Ijonbot