-- ## 23: Spammers IPs ## --

-- Displays the number of spam ticket tries and their corresponding IPs.

SELECT * FROM (SELECT ipnr AS ip,
                      COUNT(ipnr) AS count 
               FROM spamfilter_log
               WHERE karma < 0
               GROUP BY ipnr) as t
where t.count > 50