WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #17556, comment 8


Ignore:
Timestamp:
05/25/11 20:56:23 (3 years ago)
Author:
nacin
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #17556, comment 8

    initial v1  
    22 
    33{{{ 
    4 SELECT SQL_CALC_FOUND_ROWS wp31clean_posts.* FROM wp31clean_posts WHERE 1=1 AND wp31clean_posts.post_type = 'attachment' AND (wp31clean_posts.post_status = 'inherit') ORDER BY wp31clean_posts.post_date DESC LIMIT 0, 20 
     4SELECT SQL_CALC_FOUND_ROWS wp31clean_posts.* 
     5FROM wp31clean_posts 
     6WHERE 1=1 AND 
     7wp31clean_posts.post_type = 'attachment' 
     8AND (wp31clean_posts.post_status = 'inherit') 
     9ORDER BY wp31clean_posts.post_date DESC  
     10LIMIT 0, 20 
    511}}} 
    612 
     
    814 
    915{{{ 
    10  SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND  wp_posts.post_type = 'attachment'  ORDER BY wp_posts.post_date DESC  LIMIT 0, 20 
     16SELECT SQL_CALC_FOUND_ROWS  wp_posts.* 
     17FROM wp_posts 
     18WHERE 1=1  AND 
     19wp_posts.post_type = 'attachment' 
     20ORDER BY wp_posts.post_date DESC 
     21LIMIT 0, 20 
    1122}}} 
    1223 
    1324The 3.1.4 query: 
    1425{{{ 
    15 SELECT SQL_CALC_FOUND_ROWS wp31clean_posts.* FROM wp31clean_posts WHERE 1=1 AND wp31clean_posts.post_type = 'attachment' AND (wp31clean_posts.post_status = 'inherit' OR wp31clean_posts.post_status = 'private') ORDER BY wp31clean_posts.post_date DESC LIMIT 0, 20 
     26SELECT SQL_CALC_FOUND_ROWS wp31clean_posts.* 
     27FROM wp31clean_posts 
     28WHERE 1=1 AND 
     29wp31clean_posts.post_type = 'attachment' AND 
     30(wp31clean_posts.post_status = 'inherit' 
     31  OR wp31clean_posts.post_status = 'private') 
     32ORDER BY wp31clean_posts.post_date DESC 
     33LIMIT 0, 20 
    1634}}} 
    1735