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