WP_QUERY order posts by two combined meta_value dates

On post insert/update, set the post’s menu_order as the maximum of the numeric MMDD values of original_date and featured_date. Maybe set the menu order in the format 1MMDD to avoid a leading zero.

Then we can order the custom type posts by the menu order very fast with:

WP_Query( [ 
   'post_type' => 'custom_post_type', 
   'orderby'   => 'menu_order', 
   'order'     => 'DESC' 
] );

where menu_order is a int(11) column in the posts table.

If not all of the custom type posts have these custom dates, group them e.g. by a custom taxonomy, to use in your WP_Query. Maybe one could instead look for posts with non-zero menu order.

Related Posts:

  1. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  2. Wp_redirect and sending variables
  3. How do I get posts that have a thumbnail in WP_Query?
  4. Multiple WP_Query loops with Pagination
  5. how does $wpdb differ to WP_Query?
  6. WP_Query – filter or directly?
  7. WP_Query with checkbox meta_query
  8. IP address character limit
  9. What is the most efficient way of querying posts based on visits and date for current day?
  10. How can I save an array from a random post sequence for later use?
  11. Does WordPress generate an automatic page for post formats?
  12. Why is WP-Query spelled like it is?
  13. How to add custom query filters in WP_User_Query
  14. How to order category.php loop by ‘meta_value’?
  15. Searching user meta using WP_User_Query
  16. Which custom query am I in and how can I access its properties & methods?
  17. Pagination not working Search posts
  18. Does using a custom query_var create a security hole?
  19. How to sort posts in admin by titles with dd.mm.yyyy format?
  20. Why I can’t get old posts instead of recent with WP_Query?
  21. How get posts from a subcategory of a category by name?
  22. Date query not inclusive despite parameter being true
  23. WP_Query or get_posts?
  24. How to display the number of articles published per user
  25. How do you query wordpress posts using a math formula between multiple meta field values?
  26. Change default ordering of taxonomy terms – pre_get_terms
  27. Ordering Posts Type A by Custom Fields of related Post Type B
  28. Query Posts depends on custom field inside repeater field using acf
  29. Exclude old events from WP_Query with date saved in a `meta_key`
  30. WP_Query arguments to fetch custom post type posts which are in certain category?
  31. WP_Query loop within WP_Query loop
  32. current_post not working – give me -1 for every post
  33. How to fetch only media that was already attached to a post/page?
  34. (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
  35. WP_Query won’t retrieve raw HTML?
  36. Remove a specific category ID from related post
  37. Order posts by taxonomy count
  38. Query all published post AND attachment with specific mime type
  39. Any number in meta key (wp query)
  40. Custom Metabox data slow query on Admin init
  41. WP_QUERY to display woocommerce products whose author IS the logged in user
  42. Order by summing multiple values
  43. Understanding the orderby in WP_Query?
  44. Need Help For WPQuery
  45. When variable value have space between word, doesnt show any result WP_Query
  46. How to list custom fields as headers and list all pages sharing that custom field under it?
  47. Posts published last 10 minutes
  48. Make meta query treat meta_value as 1 or 0
  49. Getting additional columns from sql
  50. get all posts associated with a custom taxonomy
  51. WordPress query posts with multiple post_meta data
  52. Assign custom parameter to each post in query
  53. Exclude current post from an array of posts?
  54. complex get_posts() query to select child pages
  55. How to add $args to any running wp_query from function.php?
  56. How to remove only the latest sticky post from the loop
  57. Query posts using less than
  58. var_dump of WP_Query object is not empty, while .have_posts() return false
  59. How to view all posts of current day as default in admin
  60. How to show list of posts with custom field value (a date) that are coming soon
  61. Widget only in first post
  62. Using WHERE on a WP_Query
  63. WP_Query meta compare must include ALL array values
  64. How to sort queried pages by an array of page ids?
  65. How to query for a page, get data, then query for child pages of that page
  66. How can I change the term “Published” next to # of posts published on WordPress dashboard All Posts page?
  67. Multiple loops breaking side bar
  68. $post in wp_query?
  69. meta_query weird behaviour, static int will work, but not user data
  70. How can I return only IDs from the `posts` REST endpoint?
  71. search through “product title” using WP_Query?
  72. Excluding posts from search results page with meta query not working
  73. Counting instances of words in the results of a post query
  74. Query posts by post type, author and post meta
  75. WP_query pagination on frontpage
  76. WP Query by 4 different taxonomies
  77. Order by value of Custom Field using url string
  78. How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
  79. Is the ‘parse_query’ filter still valid to change filtered content on admin list view?
  80. I removed the “wp_rm_logs” table and am constantly getting this error
  81. How to set selected attribute on option after filter query?
  82. WP_Query returns empty if meta_query has more than 7 values
  83. query.php – multiple is_category functions
  84. Custom query with post_class filter using current_post not working
  85. Overwriting auto-appended NOT IN query in WP_Query
  86. posts_per_page not returning correct number of posts
  87. query_posts with sorting on a custom datestamp
  88. Conditionals in WP_Query
  89. Why WP_Query in functions.php is not working when get_posts works?
  90. Next / previous posts link doesn’t show up with Posts 2 Posts
  91. Loop the posts between two dates selected using jquery datepicker
  92. query by meta value then date and not empty meta value
  93. Issue with sorting by post date and custom post type
  94. Is it possible to use WP Query to orderby custom meta value and custom taxonomy?
  95. Display all custom meta field values from the database using ACF Repeater
  96. wordpress sorting using array merge by price in ascending order but price with 0 must be show last
  97. Remove divs and spans from post content
  98. Can’t get LIKE to work with wp_query [closed]
  99. Get all user with both meta_value
  100. Use meta query only 3 or more results?
tech