posts.ID) as spam_count, $wpdb->posts.ID, $wpdb->posts.post_title
FROM $wpdb->posts, $wpdb->comments
WHERE $wpdb->comments.comment_approved = 'spam' AND $wpdb->comments.comment_post_ID=$wpdb->posts.ID
GROUP BY $wpdb->posts.ID
ORDER BY spam_count DESC";
$spams = $wpdb->get_results( $sql );
?>
%05d : %s #\n", $spam->spam_count, $spam->post_title, get_permalink( $spam->ID) );
}
?>
See Spam Magnet Blog Posts