Help ordering Post loop by two meta values

If you’re using WordPress 4.2 or newer then you can do the following:

$args = array( 
    'post_type'       => 'events',
    'posts_per_page'  => 10,
    'meta_query'      => array(
        'relation'    => 'AND',
        'start_date_clause' => array(
            'key'     => 'start_date',
            'compare' => 'EXISTS',
        ),
        'ticket_status_order_clause' => array(
            'key'     => 'ticket_status_order',
            'compare' => 'EXISTS',
        ),
    ),
    'order_by' => array(
        'start_date_clause' => 'ASC',
        'ticket_status_order_clause' => 'ASC',
    )
);

You have to create a ticket_status_order because there’s no way to order by string from your available keys/values:

ASC: (I=Invite Only, S=Sold Out, Y=On Sale)
DESC: (Y=On Sale, S=Sold Out, I=Invite Only)

“Sold Out” always sit in the middle.

For more information about the query, take a look here:
Query improvements in WP 4.2: ‘orderby’ and ‘meta_query’

Related Posts:

  1. Sorting: custom query with orderby meta_value_num THEN by title
  2. Meta query with order by another custom field
  3. pre_get_posts order by not working
  4. Order ascending is ignored in meta query?
  5. Sorting search results with custom dropdown
  6. Sorting: custom query with orderby meta_value_num THEN by title
  7. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  8. WP_Query orderby post__in remains ineffective in the Loop [closed]
  9. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  10. How to get order of posts?
  11. Custom WP_Query order by post_meta and (author) user_meta
  12. Sorting Posts by custom field
  13. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  14. How to sort posts in admin by titles with dd.mm.yyyy format?
  15. Order WP Query posts by custom order calculated from post meta values
  16. pre_get_posts filter meta_query without conflicting existing meta_query
  17. Order Posts by meta value AND published date
  18. How to orderby meta_value_num with dollar ($) sign
  19. How do I sort posts with multiple pages
  20. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  21. Single meta_query query using OR instead of AND in request’s WHERE statement
  22. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  23. Using meta_query with multiple keys and compare values
  24. How to orderby multiple meta fields if some fields are empty
  25. Sort wordpress custom posts based on meta value
  26. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
  27. Understanding the orderby in WP_Query?
  28. meta_value_num not ordering all items
  29. How to filter a query by multiple meta keys and order by other meta keys
  30. WP Query – order posts by meta field first and then order the rest
  31. Advanced WP_Query with meta_query, orderby?
  32. Multiple meta_key ordering with pre_get_posts
  33. Child pages not affected by orderby
  34. orderby ignored by wp_query
  35. Sort posts using multiple custom fields and menu_order in single query?
  36. What’s wrong with this meta query? (order by meta key, then title, doesn’t work)
  37. Order (by ASC) posts with meta_key so posts without values are last
  38. How to sort store location by specific category order in WP store locations
  39. How to sort wordpress posts already selected by WP_QUERY
  40. meta_query is overriding default search
  41. WordPress Query custom ordering by temporary variable
  42. Meta query orderby meta_value_num sorting by role first
  43. WP_User_Query Orderby Not Working
  44. Order by value of Custom Field using url string
  45. WP Query with meta queries
  46. Pre get posts sort by meta key returns no results if meta key does not exist
  47. Order 2 meta_queries differently in WP_Query?
  48. Sorting with meta_query and multiple, optional meta keys
  49. WP Query. Ordering posts by another post types meta
  50. wp_query sorting – one specific meta_key value at last and then sort by create date
  51. Display three sequential posts on each page load, without repeating previous
  52. Best way to Order Post in Home without a plugin
  53. Using orderby with 2 meta keys
  54. Order posts by custom column using pre_get_posts
  55. query_posts with sorting on a custom datestamp
  56. Sort posts in dashboard using custom field; also include posts where field isn’t set
  57. Sort Posts with custom meta key by default which is currently set as optional
  58. Looking for a way to exclude frontpage and nav menu from query filter
  59. WP_Query with several meta_query-statements and order by meta_value
  60. How to put posts with some taxonomy on top of others in `pre_get_posts`
  61. meta_query with meta values as serialize arrays
  62. Using pre_get_posts with WP_Query
  63. How to Compare Two Meta Fields
  64. Getting attachments by meta value
  65. Changing Posts Per Page and offset with pre_get_posts
  66. “pre_get_posts” firing on every query
  67. WP_Query not working as expected for attachments and custom meta_query
  68. How to query ‘posts_per_page’ to display a different blog posts index template?
  69. How to use order RAND() on WordPress?
  70. Using pre_get_posts on a specific core/query block
  71. WP_Query with multiple meta fields filter?
  72. Display posts from only one post form in custom query and exclude in main query
  73. WP_Query orderby author__in
  74. Fetch Record based on meta key dates
  75. WP_Query with different postmeta filter for each categories
  76. Shouldn’t I be able to modify the main query by this filter?
  77. Debugging wp_query orderby for taxonomy
  78. Meta Query doesn’t works as espected
  79. Display posts with specific value first in query
  80. WP_Query with 4 post meta field arguments gives 500 internal server error
  81. Use have_posts() with array of post results retrieved by $wpdb->get_results
  82. Replace wp_query with wp_user_query
  83. ElasticPress is (aparently) messing with my search filters
  84. order posts by a secondary query that counts items
  85. Get unique post by meta value using wp_query
  86. WP_Query, ACF field and array
  87. Woocomerce – Order products by float attribute in archive pages
  88. Get posts meta_query by repater field
  89. Query 3 meta_key and orderby
  90. Using the same WP_Query for shop and widgets in WooCommerce shop
  91. Order posts by more than one variable (meta_key and publish date AND time)
  92. Create custom order sortby based on array of id
  93. meta_query not working with the_content()
  94. Get closest event where meta_key field is an array
  95. Set right order for query that returns posts based on two custom fields
  96. Meta_query weird behaviour
  97. WordPress extremely slow when using get_posts with multiple meta_query relations
  98. Use value from meta key array for use in WP_Query
  99. WP_Query sort by ACF date field (newest first) with blank dates first
  100. Sort by multiple columns using get_posts