akismet plugin does not display all spam comments in 'Last 15 days' summary

[schuhfits]

in wp-plugins/akismet/akismet.php The 'COUNT(*) and GROUP BY' bits of this SQL query will cause Akismet to skip additional comments posted from the same IP address. While not necessarily a problem (it's probably spam anyways) this creates a disparity between the number of spam comments reported and the number of spam comments displayed in the summary.

Around line 244 in wp-plugins/akismet/akismet.php:

$comments = $wpdb->get_results("SELECT *, COUNT(*) AS ccount FROM $wpdb->comments WHERE comment_approved = 'spam' GROUP BY comment_author_IP ORDER BY comment_date DESC LIMIT 150");

Change to:

$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = 'spam' ORDER BY comment_date DESC LIMIT 150");

[markjaquith]

I think the current behavior is good because it "compresses" the view. Many posts by the same IP are probably spam... and it makes "skimming" the list much faster.

Reopen if you want to discuss further!