Multiple meta_key ordering with pre_get_posts

This cannot be done via WP_Query, the orderby parameter can take multiple values, but those are telling it what to order by, aka date, time, title, etc These are the valid values

You can specify that it must order by post meta, but you can’t specify more than one post meta, because it uses the meta defined in the meta_key option, which does not take an array, and can only have a single value

To do this you will need to use raw SQL, and even then it may not be possible with a single query

On top of that, this query is extremely expensive and slow, doing this will make it even slower.

As an aside, switching _stock_status to use a taxonomy instead of post meta, would provide a big speed up on any queries that use it. Never store something in post meta if you need to search for it or list everything with that key/value pair. That’s what taxonomies are for.

Related Posts:

  1. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  2. Query WooCommerce orders where meta data does not exist
  3. Order by two meta keys
  4. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  5. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  6. WP Query – Get WooCommerce Products with variation that is in stock
  7. How to get user_id from wordpress database inside ajax function?
  8. pre_get_posts filter meta_query without conflicting existing meta_query
  9. Extending woocommerce admin product search
  10. pre_get_posts order by not working
  11. Single meta_query query using OR instead of AND in request’s WHERE statement
  12. Display posts from only one post form in custom query and exclude in main query
  13. Using meta_query with multiple keys and compare values
  14. Extend product search with meta in WooCommerce
  15. Help ordering Post loop by two meta values
  16. Order ascending is ignored in meta query?
  17. meta_query not working as expected
  18. New WP_Query calls Pre_get_posts filter twice
  19. Woocommerce – exclude only older out-of-stock items
  20. Sorting search results with custom dropdown
  21. $wp_query->found_posts not returning correct value
  22. Make a products only viewable to a specific user ID in meta_query pre_get_posts
  23. ElasticPress is (aparently) messing with my search filters
  24. Woocommerce Get Orders By Meta Value
  25. meta_query is overriding default search
  26. Pre get posts sort by meta key returns no results if meta key does not exist
  27. Woocomerce – Order products by float attribute in archive pages
  28. Using the same WP_Query for shop and widgets in WooCommerce shop
  29. Sort posts in dashboard using custom field; also include posts where field isn’t set
  30. Looking for a way to exclude frontpage and nav menu from query filter
  31. Variations as Single Products [closed]
  32. compare meta_query in get_posts arguments
  33. Display products from specific category in shop page
  34. How to uniquely identify queries?
  35. Query by meta_key and order by meta_value_num return orderby date
  36. Function to check if author has posted within the last x days
  37. Wp_query order by multiple custom fields?
  38. Single page theme that uses pages for the content
  39. Display featured products through custom loop in WooCommerce 3 [closed]
  40. Get product list of given category
  41. How to exclude products by tag from woocommerce shop page?
  42. Multiple meta queries but arrange by specific meta value order
  43. When querying a combination of posts and other meta fields, is there a better solution than directly modifying the WHERE value?
  44. Order Posts by meta value AND published date
  45. WooCommerce Only OnSale Products Loop Snippet [closed]
  46. What format does the meta_query TIME type require?
  47. Formulate a url to show posts with both taxonomy terms
  48. merge two query arguments into one WP_Query call
  49. Adding a parameter to the default query
  50. Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
  51. WP_Query filter and order by meta ordering by wrong joined table
  52. WP_Query last five posts, simply ordered by meta_value
  53. What is the random string I am seeing when I use get_query_var?
  54. meta_query in WP_Query value is not accepting array
  55. Changing sort order for presentation by Jetpack infinite scroll
  56. get posts by meta_key from inside key of post meta
  57. Help optimizing slow WP_Query with meta_query
  58. Filter and Order by Multiple Custom Meta Values
  59. Meta Query relation “AND” then set array accordingly
  60. 2 weeks ago from meta query meta value
  61. Query with meta_query and tax_query together not working properly
  62. Array as ‘key’ in WP_Query
  63. Is it possible to query a custom field where the value is between two fields?
  64. How to query woocommerce product by pricing? [closed]
  65. Filter posts by comparing custom meta value against postdate
  66. Searching for meta_key returns 0 posts
  67. meta_query fails to compare on values containing apostrophes
  68. How I can change the condition or compare operator for WP_Query in pre_get_posts
  69. Check if searched number is within the post meta value
  70. WP Query / Meta Query [duplicate]
  71. Query posts by searching for a string in a meta field
  72. Query multiple post types, but different order for each
  73. How to add date_query to meta_query array
  74. Order by the first array within a meta_query
  75. Output product category link from WP_Query
  76. Query ACF relationship field – Comparator IN – Value array
  77. Multiple nested meta queries
  78. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  79. How can I modify the query by adding to the existing query?
  80. Comparing Meta Field date in WPQuery using Meta_Query?
  81. Get categories within specific term
  82. Custom query for custom post type not getting correct post ID
  83. Filtering WP_Query based on wp_postmeta keys values
  84. Not able to fetch woocommerce variation sales products for particular category products
  85. Global page ID variable empty error
  86. Multiple meta_query not working
  87. compare for multiple meta values for same key in wp_query
  88. datetime picker, timestamps and meta queries
  89. WP_Query with meta_query won’t orderby
  90. meta_query only check if both value are set
  91. Save query in function for custom gallery
  92. Seach and categories not working when ignoring sticky posts in main loop
  93. What argument does my function need to echo get_results() query results
  94. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  95. Using custom field as ‘orderby’ value causing post grouping by publish date
  96. Creating Custom Query
  97. WP_Query by meta key not returning any posts
  98. How to get all post_id and meta_value using meta_key in wp_postmeta table
  99. WP Query – Show custom posts only if user contain some user meta
  100. How do I subquery with custom meta fields?