Order by two meta values – one is a number and the other is text

If the atsc_bod_listing_order meta is a number, then you should set the type argument to NUMERIC like so, so that the meta value is casted as a number which then gives you the correct numerical sorting:

'listing_order' => array(
    'key'     => 'atsc_bod_listing_order',
    'compare' => 'EXISTS',
    'type'    => 'NUMERIC',
),

Related Posts:

  1. Want to order by Meta Values (tweaking Post Order Widget)
  2. Problem with meta_value order after update
  3. Sort on meta value but include posts that don’t have one
  4. Using Orderby and meta_value_num to order numbers first then strings
  5. multiple orderby in pre_get_posts action
  6. Sort Order for a Custom Query in a Post Type Archive Not Working
  7. get_the_terms in descending alphabetical order
  8. next and previous post link ordered alphabetically
  9. Order posts by meta_value even if meta_key is not filled
  10. Order by first name
  11. How to alter query order direction using $query->set(‘order’, ‘ASC’); inside a pre_get_posts filter?
  12. Order by custom field date with ASC order
  13. the_tags() : display the tags by the order they are typed in in the backend, not alphabetically
  14. Sorting Attributes order when using get_the_terms
  15. How to order posts by meta value?
  16. How Do I Order Posts by Modified Date? [duplicate]
  17. Orderby Post Views
  18. How to order posts (woocommerce products) alphabetically but ignore certain words, eg ‘The’ and ‘An’
  19. Ordering by meta_value AND date NOT WORKING with wp_query
  20. How to order posts by alphabet with numbers at the end
  21. Best Plugin to Reorder Post Types
  22. Ordering system through WordPress
  23. Issue with multiple orderby values
  24. get_query_var returns wrong default value
  25. Use pre_get_posts to sort meta_key by an array of values
  26. Show first the posts from 1 specific tag
  27. AJAX pagination offset returns same post on adjacent pages
  28. Order posts by price
  29. All, published and pending order
  30. How to orderby multiple meta fields if some fields are empty
  31. get_adjacent_post() returning weird results
  32. Get_Users Orderby Page
  33. Sort order of next/prev sibling page
  34. Order char by post title
  35. Why does pre_get_posts() return “date” as the orderby parameter for every sortable column?
  36. next_post_link and previous_post_link order not working properly
  37. query pages by a childs publish date
  38. Custom order for Mysql array
  39. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  40. List most recently added posts (with a twist)
  41. Check post_date in pre_get_posts
  42. pre_get_posts shows posts in random order sometimes
  43. Featured-Content/Featured Posts With Random Order
  44. Orderby in Query Posts affected by operating system?
  45. Ordering posts by title containing numbers
  46. Stylesheet Enqueue Order and Best Practices
  47. Sortable Custom Columns not sorting correct
  48. wp_list_pages sort order by top nav menu order and child of
  49. How to display taxonomy terms the way they are hierarchical
  50. wp_list_categories() by alphabet? (ex. only category titles that start with “A”) [closed]
  51. How can I use ‘orderby’ => ‘meta_value_num’ to order by the numerical value even if the value starts with a word?
  52. Order by ASC, DESC, Title, Date from URL on custom page template post
  53. Offset posts with random order
  54. view subcategories order by id
  55. Sort query output on taxonomy term archive by post type using pre_get_posts
  56. ASC and DESC separately from orderby
  57. Order WP_Query by The Order of an Array in Tax_Query
  58. struggling to order by title
  59. Last post sorting get_categories
  60. Sort products by Sale price and stock status
  61. Sort by DESC works, ASC doesn’t?
  62. Shop sends Mail with order cancellation
  63. List of terms in alphabetical order under the respective initial letter and within columns
  64. update_post_meta saves data but does not show in Order backend
  65. Changing cache update rate
  66. how to complete order status automatically after paypal payment received
  67. Order management including recurring orders on woocommerce
  68. Orderby Title not working
  69. Sort loop by title doesn’t sort single digits like human would
  70. Using Orderby and meta_value to order natural/alphanumerical
  71. Loop random posts and display odd and even based on two alternating meta values?
  72. Sort posts by meta value with get method
  73. Order posts by more than one variable (meta_key and publish date AND time)
  74. How to order custom user list columns by datetime?
  75. Creating a post that contains a list of other posts like a table of contents
  76. Changing posts order on a page
  77. Ordering Subcategories
  78. How to order posts by parents?
  79. single post navigation order (NOT chronological)
  80. Random order of posts on each request
  81. Order by meta values
  82. How can I make have_posts() return posts ordered DESC by id?
  83. Add post order like page order
  84. Woocommerce Pre Orders view order link wrong [closed]
  85. How to make WordPress orderby work with post_excerpt column?
  86. Orderby with menu_order and title
  87. Sort wordpress posts by facebook likes [closed]
  88. Sorting by date not working?
  89. Is it possible to paginate posts correctly that are random ordered?
  90. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  91. Building a scalable WordPress favouriting plugin – one serialised meta value array or many meta records
  92. How to use order RAND() on WordPress?
  93. Custom Post Type order by modified date and custom meta field issue
  94. WP_Query orderby author__in
  95. Order is breaking wp_query
  96. Order get_terms by multiple meta_values
  97. WP_Query – sort the results by meta value custom attribute wocoomerce
  98. What’s wrong with this meta query? (order by meta key, then title, doesn’t work)
  99. How to search usermeta table
  100. Apply ordering args to newly merged queried
techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduseduedueduedueduseduseduedu