WP Query with multiple post types ordered by custom meta date then published date

It is unlikely that you will achieve this as stated. WordPress has no concept of post subsets in a query, it only understands it as single set as results.

If you don’t need pagination you could just retrieve the set unsorted and re–sort it with PHP code. If you do need the pagination this would probably be extremely inconvenient and require massive custom SQL.

PS avoid query_posts(), it’s outdated and harmful.

Related Posts:

  1. Sort Order for a Custom Query in a Post Type Archive Not Working
  2. Select All in Parent Category, Group by Child Category?
  3. WP_Query -> sort results by relevance (= most tags / taxonomy terms in common)
  4. WP_Query post at custom position
  5. query order by date on custom type: wrong order
  6. Re-order posts in query after
  7. How to query different post types in specific order?
  8. Combining sorted and random CPT
  9. Previous/Next Link by Meta Value in CPT
  10. Wp_query: sort by PHP variable
  11. How to do WP_Query with two meta fields with orderby clause
  12. Order Custom Post Type by Custom Field Value
  13. Change sort order when using ‘orderby’ => ‘type’
  14. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  15. WP_Query of custom post type sorted by meta_key has unexpected results
  16. WP_Query not resetting after wp_reset_postdata
  17. Post ordering not working with custom field
  18. Displaying Portfolio Filter by Category Order (alphabetically)
  19. Display Parent-Child Posts in specific order by comparing IDs in array
  20. How can I sort the results of a REST API response by the title of a connected custom post type?
  21. Order posts alphabetically with numbers but some of the posts has numbers in the title
  22. SEARCH QUERIES – REVERSE OUTPUT
  23. Wp Query sort order from custom MetaBox
  24. Orderby modified only for specific post types
  25. Custom post order when using OR relation
  26. 404 on Pages for Custom Post Type & Query_Posts
  27. WP_query orderby not working after WP4.0 update [closed]
  28. Query order by meta value force specific tag first
  29. Order Wp Query by earliest of 3 dates meta query
  30. Get Posts in a Custom Post Type category
  31. Displaying Posts Related to Other Posts by a Taxonomy Term?
  32. How to query for posts (in hierarchical custom post type) that have children?
  33. Combine tax_query and meta_query in WP_Query
  34. Should unaltered default loop/query return a list of custom posts belonging to a custom taxonomy?
  35. WP_Query pagination using only numbers instead of /page/1 on URL
  36. Query for posts in 2 taxonomies
  37. Display custom post types with custom date field value (before today) & order by custom date field
  38. Parent / Child formatting in a list of post of a custom post type
  39. How do I create an archive page for standard posts?
  40. Multiple post type queries (with specific arguments for each)
  41. Custom Post Type Loop within Shortcode
  42. How do I make a custom taxonomy for a CPT appear inbetween title and editor boxes?
  43. How to add post_type=value when editing that post type in the WordPress admin?
  44. Display CPT posts based on specific taxonomy
  45. showing custom post types of a certain category only
  46. Filtering WP_Query Dynamically on the Front-End
  47. Why get_posts() not returning only selected category posts from Custom Post Type?
  48. Custom taxonomies relationship
  49. Prioritize posts in query by meta keys?
  50. WP_Query orderby and tax_query
  51. Configuring a meta query with multiple post types that have the same relationship on a single page
  52. Different Ways to Query Custom Post Types?
  53. Possible to filter custom post type with multiple meta data?
  54. Loop increase number
  55. Custom filter for main search: how to exclude specific post_type from search results
  56. Inefficient Query Confusion
  57. find custom post type post by searching its custom field with my string
  58. wordpress lists similar type of posts in a custom post type
  59. FacetWP paging custom wp_query
  60. Custom post type and custom taxonomy 404 on page 2
  61. Cannot get custom posts by category
  62. Shortcode with WP_Query more than once on one page
  63. list posts of two post types in a single template
  64. How do I list a custom field and custom taxonomies for each result in a loop?
  65. Find Posts based on Child Post value
  66. Change search query in wordpress custom post type
  67. Sort custom posts by date and then by taxonomy
  68. Query custom post type that has a serialized relational advanced custom field value
  69. build child and anchestor three from post parent
  70. How can I query and sort custom-post type using WP_Query
  71. Custom query result empty on page 2
  72. How select query is generated in a Custom Post Type?
  73. WordPress doesn’t respect Page slug in custom post type url pagination. Keeps getting removed
  74. Output all terms slugs for a loop filter
  75. Post Query , breaks layout if a post is deleted
  76. Not able to get my custom search result using meta_query and tax_query together?
  77. Multiple WordPress Sites, Same Database but Filtered Content
  78. Custom Field as Custom Post type element class
  79. Display posts on parent post if author coincides
  80. WordPress query in which condition uses custom field
  81. How to get Current week and current date record wp query
  82. Error in WP Query. If variable is empty it is displaying previous post value
  83. Custom Post Type shows pagination (w/404) or posts_per_page query, but not both
  84. Help ordering custom query by Title, Ascending
  85. WP_Query for CPT with filter by another WP_Query
  86. Is it possible to add query parameters on the archive page?
  87. How to display custom post type ordered by a custom field date
  88. WP_Query and two custom fields returns no posts
  89. Ordering custom post type by custom field without a title
  90. Storing/querying custom date data
  91. Query Posts From Multiple Post Types
  92. Custom Post-type not returning the right child_of
  93. Create custom post order (with custom post type meta)
  94. Posts 2 Posts: query connected — orderby problem
  95. How do I hide single category post on my post page
  96. Get images only from a certain post type
  97. querying to custom field over ACF REST API
  98. Quering array of post types & pagination. Articles are repeating sometimes on different pages
  99. How can I show posts with the same tag?
  100. Load posts via AJAX without draft status