Changes between Initial Version and Version 1 of Ticket #17556, comment 8
- Timestamp:
- 05/25/2011 08:56:23 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #17556, comment 8
initial v1 2 2 3 3 {{{ 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 4 SELECT SQL_CALC_FOUND_ROWS wp31clean_posts.* 5 FROM wp31clean_posts 6 WHERE 1=1 AND 7 wp31clean_posts.post_type = 'attachment' 8 AND (wp31clean_posts.post_status = 'inherit') 9 ORDER BY wp31clean_posts.post_date DESC 10 LIMIT 0, 20 5 11 }}} 6 12 … … 8 14 9 15 {{{ 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 16 SELECT SQL_CALC_FOUND_ROWS wp_posts.* 17 FROM wp_posts 18 WHERE 1=1 AND 19 wp_posts.post_type = 'attachment' 20 ORDER BY wp_posts.post_date DESC 21 LIMIT 0, 20 11 22 }}} 12 23 13 24 The 3.1.4 query: 14 25 {{{ 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 26 SELECT SQL_CALC_FOUND_ROWS wp31clean_posts.* 27 FROM wp31clean_posts 28 WHERE 1=1 AND 29 wp31clean_posts.post_type = 'attachment' AND 30 (wp31clean_posts.post_status = 'inherit' 31 OR wp31clean_posts.post_status = 'private') 32 ORDER BY wp31clean_posts.post_date DESC 33 LIMIT 0, 20 16 34 }}} 17 35