Find by post_meta, then sort by post_meta, then sort by date (wp_posts)

Since version 4, you can order by multiple fields via an array:

'orderby' => array( 'meta_value_num' => 'ASC', 'date' => 'DESC' )

Related Posts:

  1. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  2. Order by summing multiple values
  3. Debugging wp_query orderby for taxonomy
  4. Randomly select one of last 3 posts
  5. orderby in WP_query doesn’t works
  6. WP_Query with several meta_query-statements and order by meta_value
  7. WP_Query with “post_title LIKE ‘something%'”?
  8. WP_Query orderby post__in remains ineffective in the Loop [closed]
  9. WP_Query orderby date not working
  10. Order by DESC, ASC in custom WP_Query
  11. WP_Query order by multiple meta keys & fields
  12. Secondary Sort (fallback) for WP_Query
  13. Query Posts in a Predefined Order
  14. How to get order of posts?
  15. Is it possible to wrap Geo Location search around WP_Query?
  16. Is it possible to select against a post’s parent’s fields with WP_Query?
  17. How do I order pages and categories by ID or name in the same query?
  18. WP_Query ordered by custom field that is a date string?
  19. How to make an activities stream mixing posts and comments?
  20. SQL Statement generated by WP_Query not producing expected results
  21. What is an efficient way to query based on post_meta?
  22. Merge 2 args in one WP_Query and order it by date
  23. SQL query equivalent to WP User Query
  24. Order posts ascending with number in title
  25. List taxonomy terms plus their latest post ordered by post date
  26. Advanced WP Query hogs the SQL server
  27. How to use order RAND() on WordPress?
  28. WordPress WP_Query orderby being overwritten
  29. WP_Query Order by Specific Post ID First
  30. Order Posts by meta value AND published date
  31. How can I pick a single post from the latest 3?
  32. Query post with meta_query where date is not in future
  33. How do I sort posts with multiple pages
  34. Order WP_Query by multiple fields, subtracting them from one another
  35. pre_get_posts order by not working
  36. How To Fix WP Query Returns Results But Shouldn’t?
  37. List of the years with posts presented
  38. Orderby ASC changes to DESC in WP_Query
  39. Complex WP SQL Query
  40. WP_Query order result by date AND meta_value
  41. Optional Meta Query
  42. Order by title without taking into account ‘the’
  43. Sorting events by descending date, and ascending time if multiple events on a date
  44. WP_Query orderby author__in
  45. Editing the default wordpress search
  46. Weird orderby => post__in issue
  47. How to extract specific post
  48. Woocommerce – Changing the order of the upsell products [closed]
  49. Changing sort order for presentation by Jetpack infinite scroll
  50. How to order posts by title after they have already been sorted by category
  51. Advanced ordering of query_posts
  52. meta_value_num not ordering all items
  53. Include data from custom table in WP_Query
  54. Is it possible to query from external database? [duplicate]
  55. WP Query – order posts by meta field first and then order the rest
  56. Make a SQL query with wpdb in WordPress
  57. Advanced WP_Query with meta_query, orderby?
  58. List of ways to access WordPress database?
  59. Specify strict ‘order by’ in WordPress query
  60. Getting rid of unwanted nonSQL syntax characters when debugging a query
  61. How I can change the condition or compare operator for WP_Query in pre_get_posts
  62. Order is breaking wp_query
  63. Query where ANDing slug values not working
  64. WP_Query with multiple orderby NOT working with ASC and DESC, what’s wrong?
  65. How order posts from category by date and comment count?
  66. Orderby two meta fields not working
  67. How to avoid filling up an array each time I run a WP_query?
  68. How to SQL query posts IDs by categories AND authors?
  69. SQL query injection with fifu image
  70. WP_Query order by multiple meta keys & fields
  71. WP Query – grouping posts by same meta key, adding together values from another key
  72. Custom order of posts in wp_query and different taxonomies
  73. What is the equivalent WP_Query of a SQL Query?
  74. WordPress Query custom ordering by temporary variable
  75. Custom order revolution sliders post base slides as inserted in Specific Posts List field
  76. WP_User_Query Orderby Not Working
  77. Order by meta date with a thousanth of a second defaults to post order
  78. Translating WP query into to SQL query
  79. Query Order By Number Variable From API
  80. How to get_comments() ordered by date and parent?
  81. Order 2 meta_queries differently in WP_Query?
  82. Filtering posts for unique titles, only the most recent
  83. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  84. How to search CPTs in draft using get_page_by_title()
  85. Order & Orderby clause not working with custom query
  86. What argument does my function need to echo get_results() query results
  87. Best way to Order Post in Home without a plugin
  88. Order Custom Field by Price
  89. Show sticky post before other WP_Query
  90. WP Query to order posts by multiple meta fields
  91. Custom query to order by multiple taxonomies
  92. Sorting: custom query with orderby meta_value_num THEN by title
  93. Order by multiple meta keys on wordpress
  94. Custom WP_Query with SQL directives for getting posts by authors and terms
  95. How to return value from sql and display it
  96. Order by meta values
  97. Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
  98. orderby and order filter in get_posts or WP_query function in wordpress not working
  99. How to put posts with some taxonomy on top of others in `pre_get_posts`
  100. WP_Query sort by ACF date field (newest first) with blank dates first