Using Orderby and meta_value_num to order numbers first then strings

The OrderBy argument can take more then one parameter so the solution was to change :

'orderby' => 'meta_value_num',

to:

'orderby' => 'meta_value meta_value_num',

Related Posts:

  1. Sort on meta value but include posts that don’t have one
  2. multiple orderby in pre_get_posts action
  3. get_the_terms in descending alphabetical order
  4. next and previous post link ordered alphabetically
  5. Order posts by meta_value even if meta_key is not filled
  6. Order by first name
  7. How to alter query order direction using $query->set(‘order’, ‘ASC’); inside a pre_get_posts filter?
  8. the_tags() : display the tags by the order they are typed in in the backend, not alphabetically
  9. Sorting Attributes order when using get_the_terms
  10. How to order posts by meta value?
  11. How Do I Order Posts by Modified Date? [duplicate]
  12. Orderby Post Views
  13. How to order posts (woocommerce products) alphabetically but ignore certain words, eg ‘The’ and ‘An’
  14. How to order posts by alphabet with numbers at the end
  15. Best Plugin to Reorder Post Types
  16. Ordering system through WordPress
  17. Issue with multiple orderby values
  18. get_query_var returns wrong default value
  19. Use pre_get_posts to sort meta_key by an array of values
  20. Show first the posts from 1 specific tag
  21. Order posts by price
  22. All, published and pending order
  23. get_adjacent_post() returning weird results
  24. Get_Users Orderby Page
  25. Sort order of next/prev sibling page
  26. Order char by post title
  27. Why does pre_get_posts() return “date” as the orderby parameter for every sortable column?
  28. next_post_link and previous_post_link order not working properly
  29. query pages by a childs publish date
  30. List most recently added posts (with a twist)
  31. Check post_date in pre_get_posts
  32. pre_get_posts shows posts in random order sometimes
  33. Featured-Content/Featured Posts With Random Order
  34. Orderby in Query Posts affected by operating system?
  35. Ordering posts by title containing numbers
  36. Stylesheet Enqueue Order and Best Practices
  37. wp_list_pages sort order by top nav menu order and child of
  38. How to display taxonomy terms the way they are hierarchical
  39. wp_list_categories() by alphabet? (ex. only category titles that start with “A”) [closed]
  40. Order by ASC, DESC, Title, Date from URL on custom page template post
  41. Offset posts with random order
  42. view subcategories order by id
  43. Sort query output on taxonomy term archive by post type using pre_get_posts
  44. ASC and DESC separately from orderby
  45. Order WP_Query by The Order of an Array in Tax_Query
  46. struggling to order by title
  47. Order by two meta values – one is a number and the other is text
  48. Last post sorting get_categories
  49. Sort by DESC works, ASC doesn’t?
  50. Shop sends Mail with order cancellation
  51. List of terms in alphabetical order under the respective initial letter and within columns
  52. update_post_meta saves data but does not show in Order backend
  53. Changing cache update rate
  54. how to complete order status automatically after paypal payment received
  55. Order management including recurring orders on woocommerce
  56. Orderby Title not working
  57. Sort loop by title doesn’t sort single digits like human would
  58. Sort posts by meta value with get method
  59. How to order custom user list columns by datetime?
  60. Creating a post that contains a list of other posts like a table of contents
  61. Want to order by Meta Values (tweaking Post Order Widget)
  62. Changing posts order on a page
  63. Ordering Subcategories
  64. How to order posts by parents?
  65. single post navigation order (NOT chronological)
  66. Problem with meta_value order after update
  67. Random order of posts on each request
  68. How can I make have_posts() return posts ordered DESC by id?
  69. Add post order like page order
  70. Woocommerce Pre Orders view order link wrong [closed]
  71. How to make WordPress orderby work with post_excerpt column?
  72. Orderby with menu_order and title
  73. Sort wordpress posts by facebook likes [closed]
  74. Sorting by date not working?
  75. order users with drag’n’drop?
  76. Order by nested named meta queries with ‘exists’ and ‘not exists’
  77. Display Custom Taxonomy Terns ordered by meta_value
  78. How to always display a specific post from the search result first
  79. How to choose a sort order (for posts) per category? (ideally when creating a new category)
  80. Filter query posts by the count of metas for a meta key
  81. How to use order RAND() on WordPress?
  82. orderby=meta_value_num creates duplicate posts
  83. How to order by blog ID in this multisite ‘List Blogs’ custom function
  84. Posts not showing in correct Alphabetical or ID order when using get_posts / orderby but only on production server
  85. WP_Query ordering numbers as letters
  86. Order wordpress taxonomy parent terms by their children count
  87. Rewrite and custom post type: order by custom field not working
  88. WP_Query orderby author__in
  89. Ordering Taxonomies / Changing term_id
  90. group posts by taxonomy terms
  91. Ascending Order is not Working in Custom Post Type Listining
  92. WP Query – order posts by meta field first and then order the rest
  93. Using abs() with custom field in orderby statement
  94. How to add product tag to order list
  95. Custom order of posts in wp_query and different taxonomies
  96. WordPress Query custom ordering by temporary variable
  97. How to override WooCommerce Order Item Meta with data from Cart?
  98. How to properly get popular Posts by multiple Values
  99. 404 on Pages for Custom Post Type & Query_Posts
  100. Auto Stock Update after Order cancel from Admin of Woocommerce?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)