WordPress.org

Make WordPress Core

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


Ignore:
Timestamp:
05/25/2011 08:56:23 PM (7 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