[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:
------------------------------------------+-------------------------

Comment (by Ben_W):

 Hi Dion,

 I have just tested this on a fresh installation of 4.2.4,  you are right,
 the query turns out to be fine:

 [request] => SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE
 1=1  AND wp_posts.ID IN (22153,23663,23360,23652) AND wp_posts.post_type
 IN ('post', 'video', 'ad_panel', 'instagram') AND (wp_posts.post_status =
 'publish' OR wp_posts.post_status = 'private')  ORDER BY FIELD(
 wp_posts.ID, 22153,23663,23360,23652 ) LIMIT 0, 16

 My apologies. going hunting for the rogue plugin now. Cheers

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