Changeset 11749 for trunk/wp-admin/includes/dashboard.php

Timestamp:

07/30/2009 01:39:34 PM (15 years ago)

Author:

azaozz

Message:

Trash status updates for posts, pages, comments and attachments, props caesarsgrunt, see #4529

File:

• trunk/wp-admin/includes/dashboard.php (modified) (1 diff)

trunk/wp-admin/includes/dashboard.php

@@ -481 +481 @@
     $start = 0;
 
-    while ( count( $comments ) < 5 && $possible = $wpdb->get_results( "SELECT * FROM $wpdb->comments ORDER BY comment_date_gmt DESC LIMIT $start, 50" ) ) {
+    while ( count( $comments ) < 5 && $possible = $wpdb->get_results( "SELECT * FROM $wpdb->comments c LEFT JOIN $wpdb->posts p ON c.comment_post_ID = p.ID WHERE p.post_status != 'trash' ORDER BY c.comment_date_gmt DESC LIMIT $start, 50" ) ) {
 
         foreach ( $possible as $comment ) {