Ordering by meta_value AND date NOT WORKING with wp_query

You have to use the posts_orderby filter to do this at the mo, eg

function wpse159469_posts_orderby( $orderby, $query ) {
    return implode( ' DESC,', explode( ',', str_replace( array(' ASC', ' DESC' ), '', $orderby ) ) ) . ' DESC';
}

then around your query:

add_filter( 'posts_orderby', 'wpse159469_posts_orderby', 10, 2 );
$query = new WP_Query( array( // etc
remove_filter( 'posts_orderby', 'wpse159469_posts_orderby', 10 );

Related Posts:

  1. WP_Query orderby date not working
  2. Orderby ASC changes to DESC in WP_Query
  3. Complex WP_Query order request: DESC by day, but then ASC by time
  4. How to orderby multiple meta fields if some fields are empty
  5. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
  6. Order posts by more than one variable (meta_key and publish date AND time)
  7. Get post closest to today
  8. Order by meta values
  9. Get posts that were most recently tagged
  10. WP_Query sort by ACF date field (newest first) with blank dates first
  11. How to only display posts whose meta_value field is not empty?
  12. Order by optional meta key?
  13. Order by DESC, ASC in custom WP_Query
  14. WP_Query order by multiple meta keys & fields
  15. Secondary Sort (fallback) for WP_Query
  16. Query Posts in a Predefined Order
  17. How to get order of posts?
  18. Sort Order for a Custom Query in a Post Type Archive Not Working
  19. Get Recent Posts by Date in Multisite
  20. How do I order pages and categories by ID or name in the same query?
  21. Merge 2 args in one WP_Query and order it by date
  22. Order by custom field date with ASC order
  23. Revolution Slider Orderby Two Custom Fields
  24. Order posts ascending with number in title
  25. List taxonomy terms plus their latest post ordered by post date
  26. How can I hide posts that are over 2 years old
  27. Add a default meta_value to new posts
  28. Use meta_query to display events by date in custom field
  29. How to use Meta Value Compare in WP_Query For Max and Min numbers
  30. Meta query with order by another custom field
  31. meta_query works locally but not on live server
  32. How to show recent and upcoming birthdays using meta_query
  33. WordPress WP_Query orderby being overwritten
  34. WP_Query Order by Specific Post ID First
  35. Order Posts by meta value AND published date
  36. How can I pick a single post from the latest 3?
  37. How do I sort posts with multiple pages
  38. Order WP_Query by multiple fields, subtracting them from one another
  39. Complex date range with WP_Query and BETWEEN
  40. pre_get_posts order by not working
  41. Comparing dates in custom field
  42. How to display upcoming events by dat with Modern Events Calendar Lite
  43. WP_Query order result by date AND meta_value
  44. Order by title without taking into account ‘the’
  45. WP_Query orderby author__in
  46. Weird orderby => post__in issue
  47. Meta_query on same meta key, with diffrenct values
  48. How to extract specific post
  49. How to order posts by title after they have already been sorted by category
  50. Advanced ordering of query_posts
  51. meta_value_num not ordering all items
  52. Meta Query relation “AND” then set array accordingly
  53. Taxonomy and Date in same query?
  54. date_query seems to be ignored by wp_query
  55. WP Group posts by year(desc) > month(desc) > date(asc)
  56. WP Query – order posts by meta field first and then order the rest
  57. Advanced WP_Query with meta_query, orderby?
  58. Specify strict ‘order by’ in WordPress query
  59. Order is breaking wp_query
  60. Filtering posts by archive showing all years
  61. WP_Query with multiple orderby NOT working with ASC and DESC, what’s wrong?
  62. query post by author gender
  63. How order posts from category by date and comment count?
  64. Ordering posts by custom field and grouped by month
  65. Filtering by multiple conditions in the loop
  66. Limit loop to future events
  67. Show single posts date, in a page of posts
  68. Orderby two meta fields not working
  69. Added Date Filter To Popular Posts Query
  70. WP_Query order by multiple meta keys & fields
  71. Save queried result into database
  72. WP_Query multiple value not working
  73. Custom order of posts in wp_query and different taxonomies
  74. WordPress Query custom ordering by temporary variable
  75. Comparing Meta Field date in WPQuery using Meta_Query?
  76. Custom order revolution sliders post base slides as inserted in Specific Posts List field
  77. WP_User_Query Orderby Not Working
  78. How to get only present and past posts with post_date
  79. Order by meta date with a thousanth of a second defaults to post order
  80. Query Order By Number Variable From API
  81. How to get_comments() ordered by date and parent?
  82. Order 2 meta_queries differently in WP_Query?
  83. Gather same custom field values in one value in a select tag with wp_query
  84. Order & Orderby clause not working with custom query
  85. Best way to Order Post in Home without a plugin
  86. Query All Attachments and Order by Parent Publish Date
  87. how to query for meta_value have array
  88. Sorting Posts with meta value not working
  89. Order posts by custom column using pre_get_posts
  90. Add filter to Orderby Parameter using Array
  91. Order WP_Query results in order other than ASC or DESC
  92. Show sticky post before other WP_Query
  93. Custom query to order by multiple taxonomies
  94. Sorting: custom query with orderby meta_value_num THEN by title
  95. orderby in WP_query doesn’t works
  96. orderby and order filter in get_posts or WP_query function in wordpress not working
  97. Get posts by meta value except one post [closed]
  98. Why does wp_query only display the most recent post when using order ASC?
  99. How to put posts with some taxonomy on top of others in `pre_get_posts`
  100. new WP_Query with order args – no more distinction between categories