Trackback Spam Reporting

In the past two months I've received quite a bit of Trackback spam on my blog. Its interesting to see how many you get per month. This can be done with SQL:

SELECT 
     YEAR( `tbping_created_on` ) AS year, 
     MONTH( `tbping_created_on` ) AS month, 
     COUNT( * ) AS count
FROM 
     `mt_tbping`
WHERE 
     `tbping_blog_id` = 1
     AND `tbping_junk_status` < 0
GROUP BY 
     year,
     month
ORDER BY 
     1, 
     2