[wp-trac] [WordPress Trac] #28012: orderby post__in interferes with menu_order

[WordPress Trac]

#28012: orderby post__in interferes with menu_order
------------------------------------------+-------------------------
 Reporter:  Matthias82                    |       Owner:
     Type:  defect (bug)                  |      Status:  closed
 Priority:  normal                        |   Milestone:
Component:  Query                         |     Version:  3.9
 Severity:  normal                        |  Resolution:  worksforme
 Keywords:  needs-patch needs-unit-tests  |     Focuses:
------------------------------------------+-------------------------
Changes (by McGuive7):

 * status:  reopened => closed
 * resolution:   => worksforme


Comment:

 I'm a fool! Was using order_by instead of orderby. You're welcome - derp.


 Replying to [comment:7 McGuive7]:
 > Hmmm, scratch that. I'm having the same issue. Here's my query:
 >
 >
 > {{{
 > $query_args = array(
 >       'posts_per_page'      => count( $post_in_array ),
 >       'post_type'           => 'campaign-spotlight',
 >       'order_by'            => 'post__in',
 >       'order'               => 'ASC',
 >       'post__in'            => $post_in_array,
 >       'ignore_sticky_posts' => true,
 > );
 >
 >
 > // Run query
 > $the_query = new WP_Query( $query_args );
 > }}}
 >
 > And here's what the SQL command ends up looking like:
 >
 > {{{
 > SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND
 wp_posts.ID IN (1973,1979,1976) AND wp_posts.post_type = 'campaign-
 spotlight' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status =
 'private')  ORDER BY wp_posts.post_date ASC LIMIT 0, 3
 > }}}
 >
 > No idea why it's still ordering by post date. Any help?
 >
 >
 > Replying to [comment:6 McGuive7]:
 > > I'm experiencing the same issue, however in my case I believe it's
 coming from a page/post ordering plugin that overrides the query order_by
 parameter. Might this be the case for any of y'all?

--
Ticket URL: <https://core.trac.wordpress.org/ticket/28012#comment:9>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform