WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #14222, comment 11


Ignore:
Timestamp:
04/27/11 17:46:03 (3 years ago)
Author:
technosailor
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #14222, comment 11

    initial v1  
    77 
    88{{{ 
    9 `SELECT * FROM wp_comments c LEFT JOIN wp_posts p ON c.comment_post_ID = p.ID WHERE p.post_status != 'trash' ORDER BY c.comment_date_gmt DESC LIMIT 0, 50` 
     9SELECT * FROM wp_comments c LEFT JOIN wp_posts p ON c.comment_post_ID = p.ID WHERE p.post_status != 'trash' ORDER BY c.comment_date_gmt DESC LIMIT 0, 50; 
    1010}}} 
    1111 
     
    1313 
    1414{{{ 
    15 `SELECT * FROM wp_comments c LEFT JOIN wp_posts p ON c.comment_post_ID = p.ID WHERE p.post_status NOT IN ('trash') ORDER BY c.comment_date_gmt DESC LIMIT 0, 50` 
     15SELECT * FROM wp_comments c LEFT JOIN wp_posts p ON c.comment_post_ID = p.ID WHERE p.post_status NOT IN ('trash') ORDER BY c.comment_date_gmt DESC LIMIT 0, 50; 
    1616}}} 
    1717 
     
    1919 
    2020{{{ 
    21 `SELECT * FROM wp_comments c LEFT JOIN wp_posts p ON c.comment_post_ID = p.ID WHERE p.post_status NOT IN ('trash','spam') ORDER BY c.comment_date_gmt DESC LIMIT 0, 50` 
     21SELECT * FROM wp_comments c LEFT JOIN wp_posts p ON c.comment_post_ID = p.ID WHERE p.post_status NOT IN ('trash','spam') ORDER BY c.comment_date_gmt DESC LIMIT 0, 50; 
    2222}}} 
    2323