Remove Trackbacks and Pingbacks from Comments

Unfortunately, the default Recent Comments widget also includes trackbacks and pingbacks and the sight ain’t so lovely thus I had to add this hack to weed out the trackbacks and pingbacks.

Open your theme’s functions.php file and add the following code

if ( !$comments = wp_cache_get( 'recent_comments', 'widget' ) ) {
    $comments = $wpdb-&gt;get_results("SELECT $wpdb-&gt;comments.* FROM $wpdb-&gt;comments JOIN $wpdb-&gt;posts ON $wpdb-&gt;posts.ID = $wpdb-&gt;comments.comment_post_ID WHERE comment_approved = '1' AND post_status = 'publish' AND comment_type IN ('comment', '') ORDER BY comment_date_gmt <span style="color: #ff0000;">DESC LIMIT 15</span>");
    wp_cache_add( 'recent_comments', $comments, 'widget' );
}