Orderby = none not working [duplicate]

Order by none doesn’t do what you think it does. If you don’t specify an order, then MySQL doesn’t guarantee any particular order and will simply get the posts in whatever order it has them. Since they were inserted in a particular order, then you’ll probably get them in that order.

Since you need the posts in a specific order (in your case, by post IDs with “99,4,5,2,8,55”), then mysql isn’t capable of that without a far more complex ORDERBY clause. Specifically, you’d have to use this with mySQL syntax:

ORDER BY FIELD($wpdb->posts.ID,99,4,5,2,8,55);

…and that’s not particularly easy to do with the WordPress query engine.

You could use the posts_orderby filter to do something like this, with code like this:

function reorder_posts($orderby) {
    global $wpdb;
    return "ORDER BY FIELD({$wpdb->posts}.ID,99,4,5,2,8,55)";
}
add_filter('posts_orderby', 'reorder_posts');

You’d want to add the filter before your query, then remove it after, so as not to change anything else.

But this is a hard-coded solution, and you’d probably be better off finding a more generic approach than fiddling with the queries. Storing your order in metadata and then selecting based on that and ordering based on meta_value_num is possible with the WP_Query system.

Edit: Note, this just got pushed into WordPress 3.5, so when that comes out, you’ll be able to use 'orderby'=>'post__in' (that’s a double underscore there) and it will use the value from the post__in for the ordering.

Ticket here: http://core.trac.wordpress.org/ticket/13729

Patch here: http://core.trac.wordpress.org/changeset/21776

Related Posts:

  1. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  2. WP_Query orderby post__in remains ineffective in the Loop [closed]
  3. WP_Query orderby date not working
  4. Sorting: custom query with orderby meta_value_num THEN by title
  5. Order by DESC, ASC in custom WP_Query
  6. Secondary Sort (fallback) for WP_Query
  7. Query Posts in a Predefined Order
  8. Custom WP_Query order by post_meta and (author) user_meta
  9. How to order posts tag by tag?
  10. How do I order pages and categories by ID or name in the same query?
  11. WP_Query ordered by custom field that is a date string?
  12. WP_Query sort by comment meta data
  13. Order posts by tags count?
  14. WP_query ‘orderby=none’ Problem
  15. Order posts by date and then by custom field
  16. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  17. Order by the results of a function with WP_query
  18. How to order posts in wp_query by a meta_value of the corresponding author
  19. Order by menu structure
  20. WP_Query order by date in meta_value
  21. How to use order RAND() on WordPress?
  22. Show all parents and children in custom post type in right order
  23. Ordering by meta_value AND date NOT WORKING with wp_query
  24. WP_Query orderby breaks when using AJAX?
  25. Order WP Query posts by custom order calculated from post meta values
  26. Meta query with order by another custom field
  27. Change default ordering of taxonomy terms – pre_get_terms
  28. How can I pick a single post from the latest 3?
  29. Wp query orderby ‘title’ doesn’t work
  30. How can I order Wp_Query hierarchically?
  31. How do I sort posts with multiple pages
  32. Order WP_Query by multiple fields, subtracting them from one another
  33. (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
  34. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  35. Order By table field comment_status in WordPress > 4.0
  36. Complex WP_Query order request: DESC by day, but then ASC by time
  37. How to set multiple `orderby` in query argument?
  38. WP_Query orderby author__in
  39. How to orderby multiple meta fields if some fields are empty
  40. Sort wordpress custom posts based on meta value
  41. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
  42. Order by summing multiple values
  43. Understanding the orderby in WP_Query?
  44. Order by empty custom field
  45. Help ordering Post loop by two meta values
  46. Order ascending is ignored in meta query?
  47. How to filter a query by multiple meta keys and order by other meta keys
  48. Multiple Orderby’s using random order WP_Query
  49. Debugging wp_query orderby for taxonomy
  50. WP Query – order posts by meta field first and then order the rest
  51. Ordering posts by an array
  52. Advanced WP_Query with meta_query, orderby?
  53. How to Order a list of taxonomies? orderby?
  54. Order is breaking wp_query
  55. WP_Query with multiple orderby NOT working with ASC and DESC, what’s wrong?
  56. Child pages not affected by orderby
  57. Filtering by multiple conditions in the loop
  58. Orderby two meta fields not working
  59. Sorting posts by Multiple custom fields in defined order
  60. Randomly select one of last 3 posts
  61. WP_Query orderby random do not repeat infinite scroll – one loop
  62. how to retrieve WP_Query without ordering by date [duplicate]
  63. orderby ignored by wp_query
  64. WP_Query orderby
  65. What’s wrong with this meta query? (order by meta key, then title, doesn’t work)
  66. How can I order a post query’s results based on the number of matching taxonomy terms?
  67. How to sort store location by specific category order in WP store locations
  68. How to sort wordpress posts already selected by WP_QUERY
  69. Custom WP Query order function possible?
  70. Custom order of posts in wp_query and different taxonomies
  71. WP_Query random ordering not working since 5.4
  72. WordPress Query custom ordering by temporary variable
  73. Meta query orderby meta_value_num sorting by role first
  74. Order by value of Custom Field using url string
  75. Order by meta date with a thousanth of a second defaults to post order
  76. WP Query with meta queries
  77. Order Element By Custom Field in WordPress
  78. How to get_comments() ordered by date and parent?
  79. Sorting with meta_query and multiple, optional meta keys
  80. WP Query. Ordering posts by another post types meta
  81. Best way to query posts and order by relevancy to query
  82. How to order posts, that have already been filtered by custom taxonomy, by their category names?
  83. wp_query sorting – one specific meta_key value at last and then sort by create date
  84. query_posts based on a meta_key
  85. Display three sequential posts on each page load, without repeating previous
  86. Order posts by more than one variable (meta_key and publish date AND time)
  87. Create custom order sortby based on array of id
  88. Sort by meta key within same day
  89. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  90. Order Custom Field by Price
  91. Using orderby with 2 meta keys
  92. Show sticky post before other WP_Query
  93. query_posts with sorting on a custom datestamp
  94. Order by multiple meta keys on wordpress
  95. WP_Query with several meta_query-statements and order by meta_value
  96. Get posts that were most recently tagged
  97. Why does wp_query only display the most recent post when using order ASC?
  98. How to put posts with some taxonomy on top of others in `pre_get_posts`
  99. WP_Query sort by ACF date field (newest first) with blank dates first
  100. new WP_Query with order args – no more distinction between categories

Leave a Comment