mysql> select ip, remotehost, hellohost, outcome, plugin from connlog where ip <> '127.0.0.1' order by time desc limit 50; +-----------------+--------------------------------------------------+--------------------------------------------------+---------+------------------------+ | ip | remotehost | hellohost | outcome | plugin | +-----------------+--------------------------------------------------+--------------------------------------------------+---------+------------------------+ | 204.9.177.18 | livejournal.com | livejournal.com | queue | NULL | | 87.90.179.109 | i05v-87-90-179-109.d4.club-internet.fr | NULL | deny | check_earlytalker | | 84.55.144.247 | Unknown | [84.55.144.247] | deny | no_residential_zombies | | 76.100.225.155 | c-76-100-225-155.hsd1.md.comcast.net | c-76-100-225-155.hsd1.md.comcast.net | deny | no_residential_zombies | | 88.74.0.186 | dslb-088-074-000-186.pools.arcor-ip.net | dslb-088-074-000-186.pools.arcor-ip.net | deny | no_residential_zombies | | 217.85.237.81 | pD955ED51.dip.t-dialin.net | pD955ED51.dip.t-dialin.net | deny | no_residential_zombies | | 65.33.42.183 | 183.42.33.65.cfl.res.rr.com | 183.42.33.65.cfl.res.rr.com | deny | no_residential_zombies | | 71.6.138.5 | whenews.com | whenews.com | deny | dnsbl | | 216.218.163.68 | rydia.net | mail.rydia.net | queue | NULL | | 82.42.29.1 | 82-42-29-1.cable.ubr02.knor.blueyonder.co.uk | 82-42-29-1.cable.ubr02.knor.blueyonder.co.uk | deny | no_residential_zombies | | 200.121.44.138 | client-200.121.44.138.speedy.net.pe | client-200.121.44.138.speedy.net.pe | deny | no_residential_zombies | | 65.33.42.183 | 183.42.33.65.cfl.res.rr.com | 183.42.33.65.cfl.res.rr.com | deny | no_residential_zombies | | 68.58.108.131 | c-68-58-108-131.hsd1.in.comcast.net | tujjodj | deny | no_residential_zombies | | 87.90.179.109 | i05v-87-90-179-109.d4.club-internet.fr | NULL | deny | check_earlytalker | | 81.154.148.241 | host81-154-148-241.range81-154.btcentralplus.com | host81-154-148-241.range81-154.btcentralplus.com | deny | no_residential_zombies | | 216.199.78.234 | 216-199-78-234.atl.fdn.com | librebingogiochi.com | deny | no_residential_zombies | | 84.98.206.218 | 218.206.98-84.rev.gaoland.net | 99.103.71-86.rev.gaoland.net | deny | no_residential_zombies | | 65.28.157.135 | cpe-65-28-157-135.bak.res.rr.com | larcellu-912849.bak.rr.com | deny | no_residential_zombies | | 204.9.177.18 | livejournal.com | livejournal.com | deny | spamassassin | | 82.45.185.97 | 82-45-185-97.cable.ubr01.chel.blueyonder.co.uk | [82.45.185.97] | deny | no_residential_zombies | | 204.9.177.18 | livejournal.com | livejournal.com | queue | NULL | | 204.9.177.18 | livejournal.com | livejournal.com | queue | NULL | | 204.9.178.72 | sixapart-corp-nat.sixapart.com | smtp.sixapart.com | queue | NULL | | 207.144.76.211 | Unknown | [207.144.76.211] | deny | no_residential_zombies | | 69.25.74.45 | mx1.myoutlookonline.com | mX1.myoutlookoNline.com | queue | NULL | | 210.92.196.17 | panocean.co.kr | panocean.co.kr | deny | danga_rcpt_ok | | 222.156.64.178 | KH222-156-64-178.adsl.dynamic.apol.com.tw | KH222-156-64-178.adsl.dynamic.apol.com.tw | deny | no_residential_zombies | | 128.36.229.215 | bugs.haskell.org | www.haskell.org | queue | NULL | | 84.56.113.198 | dslb-084-056-113-198.pools.arcor-ip.net | shentel.net | deny | no_residential_zombies | | 72.189.64.195 | 195.64.189.72.cfl.res.rr.com | qaulcomm.com | deny | no_residential_zombies | | 72.189.64.195 | 195.64.189.72.cfl.res.rr.com | parker.com | deny | no_residential_zombies | | 72.189.64.195 | 195.64.189.72.cfl.res.rr.com | parker.com | deny | no_residential_zombies | | 72.189.64.195 | 195.64.189.72.cfl.res.rr.com | naviu.net | deny | no_residential_zombies | | 91.197.34.243 | buycurrent.com | buycurrent.com | queue | NULL | | 72.189.64.195 | 195.64.189.72.cfl.res.rr.com | honeywell.com | deny | no_residential_zombies | | 72.189.64.195 | 195.64.189.72.cfl.res.rr.com | kraft.com | deny | no_residential_zombies | | 189.179.129.154 | dsl-189-179-129-154.prod-infinitum.com.mx | dsl-189-179-129-154.prod-infinitum.com.mx | deny | no_residential_zombies | | 24.175.188.97 | cpe-24-175-188-97.stx.res.rr.com | border.net | deny | no_residential_zombies | | 78.56.100.93 | 78-56-100-93.ip.zebra.lt | panalpina.com | deny | no_residential_zombies | | 75.131.161.195 | 75-131-161-195.dhcp.spbg.sc.charter.com | 75-131-161-195.dhcp.spbg.sc.charter.com | deny | no_residential_zombies | | 221.130.55.20 | Unknown | 207.7.148.197 | deny | no_residential_zombies | | 204.9.177.18 | livejournal.com | livejournal.com | queue | NULL | | 81.190.121.194 | host-81-190-121-194.gdynia.mm.pl | gap.com | deny | no_residential_zombies | | 89.83.113.218 | d04m-89-83-113-218.d4.club-internet.fr | NULL | NULL | NULL | | 201.17.41.7 | c9112907.rjo.virtua.com.br | c9112907.rjo.virtua.com.br | deny | no_residential_zombies | | 124.120.110.148 | ppp-124.120.110.148.revip2.asianet.co.th | ppp-revipop003268.asianet.co.th | deny | no_residential_zombies | | 189.144.11.85 | dsl-189-144-11-85.prod-infinitum.com.mx | dsl-189-144-11-85.prod-infinitum.com.mx | deny | no_residential_zombies | | 69.25.74.51 | mx1.MyOutlookOnline.com | mX1.myoutlookonLine.com | queue | NULL | | 63.123.133.17 | mail.voipngt.com | pop3-den-vvr1.onvoip.net | queue | NULL | | 201.95.47.232 | 201-95-47-232.dsl.telesp.net.br | 201-95-90-247.dsl.telesp.net.br | deny | no_residential_zombies | +-----------------+--------------------------------------------------+--------------------------------------------------+---------+------------------------+ 50 rows in set (0.00 sec)