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. Query multiple post types – Order by type and post title title
  31. How can I get the number of custom post type posts that have a specific attachment image set?
  32. How to use load more custom post type data normal or according to on click category tab In WP
  33. orderby rand is not working for a custom post types
  34. Sort CPT archive by order prevents sorting in admin
  35. Problem querying Custom post type by custom fields
  36. Orderby CPT custom fields not working
  37. Custom taxonomy rewrite give pagination 404
  38. WP_Query order by custom field, then randomly order some of results
  39. WP_Query inside foreach loop returning same value for all options when filtered using ajax
  40. Mixing 2 custom post types with posts output in specific pattern
  41. Custom post taxonomies as tax_query terms?
  42. creat filter with wp_query
  43. Troubles with acf/save_post and WP_Query
  44. A method for ordering mixed dates in search result loop (theory only, no actual code)
  45. Query custom post type with ACF Date
  46. Stuck in Order by more then one
  47. Display featured image from one CPT within another CPT query
  48. Custom WP Query on custom meta and sort by multiple meta keys value
  49. Show only one post on custom post type archive
  50. Woocommerce search pagination not working
  51. How to order WP_Query by parent for hierarchical Custom Post Type?
  52. Including metaboxes from custom post types in global search — continued
  53. WordPress loop: Show only a Custom Post Type Taxononmy TERM
  54. How can I made custom taxonomies relationship?
  55. Query Multiple Custom Posts by Custom Fields
  56. What’s the WP way to load remaining custom posts?
  57. Why is this query not working? (Standard posts + custom post type)
  58. How do you paginate a query grouped by month?
  59. Custom taxonomies relationship
  60. Get Posts by multiple custom fields is not working
  61. Custom post type ‘articles’ ignores posts_per_page, reserved post_type?
  62. Several post types on WP Query by tag and taxonomy
  63. WP Query with categories only shows one post and ignores the category
  64. Polylang non-default language ignores tags in WP_Query
  65. WordPress request fiter order by related post’s post_title
  66. How to order and group custom post type posts by year and month
  67. Custom Widget WP_Query problem
  68. Custom query at top of archive search page, arguments are overridden
  69. WP_Query custom post type query not showing the exact post type
  70. How to display post list inside post
  71. Pagination issue on category.php using custom post type query
  72. How to have this permalink structure: post_type/postname/custom_inner_page
  73. Problem: wp_query outputs all images on site
  74. Query Custom Post Type Taxonomy term with multiple parameters
  75. Sort entries by date mixing two post types
  76. Why is my category template ignoring post type?
  77. First custom field value (out of several) displayed twice after query
  78. wp_reset_postdata() and wp_reset_query() inside shortcode are not working to reset original page query
  79. Prioritize posts in query by meta keys?
  80. Get the taxonomy of a post hierarchically
  81. Display Woocommerce Orders for specific author [closed]
  82. Add Custom Post Type of specific Custom Taxonomy to regularly blog loop
  83. How to get all tags of a custom post type by id
  84. Filter Posts from the Main Query
  85. WP_Query orderby and tax_query
  86. Configuring a meta query with multiple post types that have the same relationship on a single page
  87. Different Ways to Query Custom Post Types?
  88. Ordering custom post type by multiple custom fields
  89. Order posts by 2 custom fields and if one custom field is zero orderby another custom field
  90. Pagination with custom query, custom search form, single and pages, ajax and no plugins
  91. Possible to filter custom post type with multiple meta data?
  92. can these 3 queries be re-written as 1 query?
  93. Advanced search form with filters for custom taxonomies
  94. Manage Columns : order by post_parent’s title
  95. Order by custom field meta_key date and then by custom file meta_key number
  96. How does order=asc effect a wp_query (its acting pretty weird in a loop)
  97. custom post type search by reference id
  98. pagination not working for category.php (custom post types in categories)
  99. Query based on custom fields start and end date
  100. Why is my WP_Query outputting my entries twice?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)