Creating Ordered Query using Meta_key

I think the sort is either alphabetical or numerical. There is no API way to provide more elaborate sorting rules to the query and messing with SQL for it would be likely impractical.

Since you are retrieving complete set of posts (don’t have to worry about pagination) the easiest way would be:

  1. Request no sort from query.
  2. Re–sort $the_query->posts set of results with PHP code before starting the loop for output.

Related Posts:

  1. How can I sort posts by the date and a custom meta field?
  2. WP_Query sort by meta_value_num or date
  3. Update all posts automatically when using post_meta
  4. Better post meta efficiency?
  5. Change post format using custom field
  6. Sanitizing `wp_editor();` Values for Database, Edit, and Display
  7. What Is meta_id In wp_postmeta?
  8. Add custom field automatically (add_post_meta) with value based on number of words of article
  9. Automatic value for custom fields for posts
  10. WP_Query orderby not working with meta_value_num and menu_order
  11. is there a way to show the the post title after the image?
  12. How do I correctly set up a WP-Query to only show upcoming event-posts?
  13. Query Posts With Over 1000 Views
  14. Cannot retrieve a custom RSS field from posts
  15. Query Posts by Custom Field
  16. Customize rel=canonical tag for single blog post
  17. How to I retrieve the ID from the Posts page?
  18. if in category but only with post meta
  19. wp_query with ajax
  20. Saving Post Data in Another Database
  21. Add multiple meta keys to a post at once
  22. WP_Query custom field pass the post id
  23. saving/reading custom field value does not work – no value gets POSTed
  24. Override WordPress core post-template.php block template
  25. Post meta not working
  26. How do you update post date (year only) in a separate custom field?
  27. How to get value of a selected option from select tag and use it in WP_query to filter posts?
  28. Show posts between two Custom Fields date
  29. WP Query between posts custom fields [duplicate]
  30. Order posts by separate menu order for different sub-categories
  31. How enter custom post meta or custom field on box post list archive page?
  32. WP_query sort by custom meta_key “price”
  33. Image inside the content is replaced with featured image from my older post
  34. Trouble with serialized metadata
  35. Function is printing twice – any suggestions?
  36. Query on a repeater date (acf)
  37. Adding an option to post editor to show a site disclaimer or message
  38. Display/Filter post using if else statement
  39. How to sort WP_Post Object array by object field in php?
  40. Search results for ACF data
  41. Multisite how to display merged posts from two sites and sort by latest date?
  42. Saving canvas generated image when saving post causes 404 error
  43. Query prints posts without specific categories
  44. Private post caught in endless redirect loop
  45. Show posts from WP Custom Post Type selected from a field in a metabox
  46. How to retrieve all meta data directly from the $post object? Such as $post->related_topics?
  47. What is proper filter or hook action to add data to the $post object?
  48. Display specific posts based on an ID of another post
  49. Numbered Pagination Showing The Same Posts After Altering WP_Query
  50. Order by meta_key field in WordPress not meta_value field value
  51. a WordPress connected to 2 database
  52. How to display particular set of wordpress post on a webpage?
  53. Need to display a Jan 1st post as the site’s front page on Jan 1st, and Jan 2nd post as front page on Jan 2nd etc
  54. query posts with selected post ids first
  55. Change URL of previous posts and next posts link in WordPress
  56. Query against multiple locations within single custom post type post
  57. Custom meta fields not showing up in WP_Response Object via custom endpoint
  58. How to invoke a HTML custom button based on a HTML dropdownlist menu
  59. How to create page with post content in it?
  60. Blogposting Schema & Structured Data without plugin
  61. Order posts inside bootstrap card columns
  62. long-title posts do not want published
  63. Automatically select template based on query string for New Posts
  64. How to remove a post from results by ID after query?
  65. Using a meta_value or postdate to to query and orderby
  66. Exclude posts in home slider from sections
  67. Display Updated Date Instead of Published Date
  68. Is there a way to save different data when USER interacts with the same POST?
  69. Mix post date with post meta value using WP_Query
  70. How to use two query result together in one loop
  71. Add postmeta to all blog posts
  72. show loop id post , only first id can read
  73. When working with a post, almost all wp_postmeta are deleted
  74. WP_Query that targets all categories
  75. Counting Posts by Category
  76. Fill the exclude array() in get_posts()
  77. show image gallery in archives or category page
  78. Page with Category Returning 1
  79. The first post appears twice
  80. filter posts based on menu_order
  81. Bulk Post update_post_meta
  82. Re-order Category Meta-data
  83. Show 5 posts and than 3 posts offset with pagination
  84. Double loop output
  85. Change archive results based on GET request
  86. wp_query args with relation
  87. How to hide meta from search result only on pages?
  88. Ajaxify Post Sort
  89. How do I display posts ordered by a date custom field?
  90. Override wp_link_pages pagebreak with filter
  91. Get 5 most recent categories
  92. Loop through all posts showing duplicates
  93. Grab meta data before post is saved
  94. WP_Query extended with AJAX
  95. Manipulate query to show specific post
  96. Wp_query loop is not working as it should
  97. Get current user, change users post status to published
  98. Show all posts from the tags without having to set all of them
  99. How to fetch posts that are stored in the different table than the default table (wp_posts)?
  100. Meta key in wp_query bug?