[wp-trac] Re: [WordPress Trac] #7457: Sticky Posts

[WordPress Trac]

#7457: Sticky Posts
----------------------------------+-----------------------------------------
 Reporter:  ryan                  |        Owner:  anonymous
     Type:  defect                |       Status:  new      
 Priority:  normal                |    Milestone:  2.7      
Component:  General               |      Version:           
 Severity:  normal                |   Resolution:           
 Keywords:  sticky posts blessed  |  
----------------------------------+-----------------------------------------
Comment (by ryan):

 {{{
 SELECT SQL_CALC_FOUND_ROWS wp_trunk_posts.* FROM wp_trunk_posts WHERE 1=1
 AND
  wp_trunk_posts.post_type = 'post' AND (wp_trunk_posts.post_status =
 'publish') ORDER BY
  wp_trunk_posts.post_date DESC LIMIT 0, 10
 }}}

 I get "Using where" with that.  Adding menu_order to the mix brings on
 filesort.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/7457#comment:12>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software