Moderated Comments are showing up in the Recent Comments list in the Dashboard

[jesuit]

Comments that have been held for moderation are showing up in teh recent comments list on teh dashboard. This can be confusing. The query should be updated to check for comment_approved = '1'

[jesuit]

Here is an example of the updated query:

<?php
if ( $comments = $wpdb->get_results("SELECT comment_author, comment_author_url, comment_ID, comment_post_ID FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 5") ) :
?>

Trivial really, just confusing.