How to sort by post_date and meta_value_num?

You can actually use two filters to accomplish this.

Use posts_join for the joining of the meta table (unless you know it’s already included in your wp_query. And posts_orderby for the sorting.

Related Posts:

  1. No exposure on search engines
  2. Related posts with WP_Query
  3. Adding css tweak based on page template
  4. Renaming or Moving WP-Content Pros/Cons
  5. Carousel slider with WP_Query to show 3 posts on each slide
  6. how to use transient method?
  7. Displaying specific posts from query thumbnail outside div
  8. Query posts only shows 1
  9. Get users query makes the site loading time too big?
  10. how do i remove plusone js from WP? [closed]
  11. Fatal error with wp-livechat plugin
  12. WordPress query very slow on +/- 300k DB entries and 7 INNER JOIN
  13. How to create a loop inside WP_Query?
  14. Add banner after the third post [closed]
  15. Get author meta data with no published posts in author.php?
  16. Query for page content, and query for posts on the same page?
  17. Can’t seem to get an else statement correct? [closed]
  18. WP Query Obj: Set value to be unequal | Hide media by admin
  19. 294 Queries on Mainpage of WordPress
  20. WordPress pagination returns the same posts
  21. get_posts shows current post, not defined posts with args
  22. Weird query with get_posts and WP_Query
  23. Adding arguments to WooCommerce Product Loop using AJAX
  24. How to hook the pre_get_posts filter via ajax call
  25. WP_Query and DES sort for Custom Taxonomy based upon a meta field?
  26. Help with showing text when something is entered in my search bar
  27. Remove divs and spans from post content
  28. Get Related Posts by Tag if Tag is Empty Get Posts by Category
  29. How to write a query-function as a query-shortcode?
  30. orderby and order filter in get_posts or WP_query function in wordpress not working
  31. How to show featured post first, then separate loop for other posts
  32. How to order “top rated” results by date and meta key?
  33. error with $query->have_posts()
  34. Output ACF field dynamicaly within a taxonomy loop [closed]
  35. Main loop querying current template’s info only in custom category archive pages, not my posts
  36. Multiple Orderby is not working right
  37. Why does WP_Query not search for two ‘meta_query’ keys separated with OR?
  38. Getting posts via WP Query
  39. Print post data inside loop using theme content template
  40. shortcode with $atts with strange results
  41. Show linked products using wp query and woocommerce
  42. Where to find WP_Query class?
  43. Standard Loop – wp_query
  44. tax_query not working properly with get_posts
  45. Why wp_query return 1 row if i have 3 row pass in it
  46. Query custom post types by meta field in a term from custom taxonomy
  47. WP_Query with tax_query not working
  48. Edit WordPress loop, taxonomies, & filter
  49. Pagination with Custom Post Type not working on index.php: I get a 404
  50. how to add limit records in wordpress query
  51. query only direct child and sub-terms of a current term archive
  52. restrict posts per page
  53. WP_Query – meta fields numeric
  54. First post outside of loop, homepage only?
  55. How to query posts from single post format on Genesis framework
  56. How to write short code with if else to get page_id?
  57. the_excerpt() not working in custom archive
  58. Filter posts by category
  59. how to show only catergory titles on a page in wordpress
  60. Limit the number of posts via wpquery
  61. How can I filter a query by post id?
  62. Get posts by meta value except one post [closed]
  63. query_vars category_name only display one catgory out of multiple categories
  64. Incorrect posts displayed on category page
  65. Pagination on custom post type not working
  66. How can I echo out the user id in user meta?
  67. Can’t get LIKE to work with wp_query [closed]
  68. Get all user with both meta_value
  69. have_posts order by title descending
  70. How to handle wp_query?
  71. Hook to get the query result after listing posts
  72. Undefined variable [closed]
  73. How can I display sticky posts at first in wp_query?
  74. How do I split a large query with a semi-expensive function included into multiple smaller queries
  75. Elementor custom query
  76. Why does $post_id = $wp_query->get_queried_object_id(); return 0?
  77. Custom WP_query in Jnews theme returns thousands of posts
  78. WP Query – if there are no posts with certain tag query other ones
  79. How to know which editor published a post programmatically?
  80. How does ‘category__not_in’ differ to cat => ‘-1’?
  81. wp_query loop with compare operator simply not working, why?
  82. Custom Wp_query loop takes very long
  83. Get access to all terms associated to each post that the wp_query loop displays
  84. Pre_get_post on CPT archive page
  85. WP query based on two meta queries
  86. How to account for empty key values in wp_query?
  87. Get comment number by date range?
  88. WP_Query – order with usort by custom meta
  89. WordPress website links redirect to homepage
  90. Filtering product search results using tags
  91. WordPress Show 4 posts from 4 specific categories in a slider
  92. How to display posts from a specific term first then another posts from another terms using tax_query
  93. WP_Query by meta key not returning any posts
  94. How to replecate the _fields parameter in custom REST api endpoint
  95. Get posts that were most recently tagged
  96. How to retrieve _embed (etc) fields in get_posts custom query?
  97. how to fetch post_name from WP_Query using Group by a custom value field
  98. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  99. WordPress extremely slow when using get_posts with multiple meta_query relations
  100. How to display only top posts of parent categories in loop via WP_Query?