WP_Query orderby not working with meta_value_num and menu_order

Found an answer to this.

Somehow WordPress’ own orderby isn’t fully functional when trying to order by multiple values.

I solved this by changing WP_Query to SQL Query, and including second DESC after _postmeta.meta_value+0

SELECT XXX_posts.* FROM XXX_posts
INNER JOIN XXX_postmeta ON (XXX_posts.ID = XXX_postmeta.post_id)
WHERE 1=1 AND XXX_posts.post_type="sidebar_element" AND (XXX_posts.post_status="publish") AND (XXX_postmeta.meta_key = 'sidebar_element_meta_alignment' )
GROUP BY XXX_posts.ID
ORDER BY XXX_postmeta.meta_value+0 DESC,XXX_posts.menu_order DESC

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. How do I reorder (pop and push) items from WP_Query?
  4. Reverse chronology of post listing
  5. Automatic value for custom fields for posts
  6. How do I correctly set up a WP-Query to only show upcoming event-posts?
  7. Query Posts With Over 1000 Views
  8. How to order posts by meta_value and title
  9. Query Posts by Custom Field
  10. how to get post order by post id wp_query?
  11. Create a list of posts with topic headdings
  12. Need to know custom code to display random and most viewed posts in wordpress posts and pages
  13. WP_Query custom field pass the post id
  14. Override WordPress core post-template.php block template
  15. query posts with selected post ids first
  16. How to get value of a selected option from select tag and use it in WP_query to filter posts?
  17. How do I display posts ordered by a date custom field?
  18. Random order of the 5 most popular posts
  19. My custom query is displaying random posts in random order
  20. Creating Ordered Query using Meta_key
  21. Get query result according to merged array
  22. WP Query between posts custom fields [duplicate]
  23. Order posts by separate menu order for different sub-categories
  24. Order by ‘s’ using WP_Query()
  25. Image inside the content is replaced with featured image from my older post
  26. How to protect pages with double authentication: password + email (in custom field)
  27. Adding additional data to WP_Post object
  28. How set featured posts using checkbox in post edit screen?
  29. WP_Query: Why is sticky post not first item in loop?
  30. Convert custom fields to post categories
  31. Query posts from current year
  32. Most viewed post for the last 2 days using WP_Query
  33. Adding Post Counts to Menu (Nav) Programmatically?
  34. This AJAX Code Doesn’t Work – Looking for elegant solution
  35. How to add posts to wp_query result?
  36. Posts for next month
  37. Order post by year DESC and month ASC
  38. Replace Main Query With Custom Query
  39. Populating a page with content from post custom fields
  40. Hide Post comments when displayed via WP_Query
  41. Autoremove empty custom fields
  42. Group posts by year in loop
  43. Change Order of Admin Posts Depending on Meta
  44. wp query with dynamic taxonomies and terms?
  45. Blogroll – Different layout for first post
  46. How do I use `posts_distinct` correctly?
  47. Loop through all product posts?
  48. How to find what index page a post is on?
  49. Get Posts that are in the current month or later
  50. WP Query to Get Array of Slugs
  51. is there a way to show the the post title after the image?
  52. How to display Common posts from specific Tag & Category with Shortcode
  53. How to filter my search in post if contains a word in title, content or excerpt?
  54. How to return another post than requested
  55. Is there a way to notify specific users when new posts are published to specific pages?
  56. Random ajax load only works with posts_per_page set to -1
  57. MySql query to get posts with all meta and terms
  58. Query posts and return XML
  59. List authors with the last post title and order by last post date
  60. WordPress query_posts by tag doesn’t work anymore(?)
  61. Ignore latest two posts
  62. Print out last 3 blogposts
  63. How can I add a box to edit Order on a regular post?
  64. How to group only VISIBLE posts? [closed]
  65. Shortcode with ‘year’ parameter
  66. On what hook can I get the queried object’s final state?
  67. Add two custom fields as a default to the “new post” page.
  68. how to handle the loop using filling bootstrap grid structure?
  69. Get all custom posts with a certain taxonomy
  70. Link to date_query results in WordPress
  71. When WP_Query only returns 1 post, how do I automatically redirect to that post?
  72. Limiting post list by taxonomy
  73. How to display WP Query filters?
  74. Finding a post’s slug
  75. Order posts by date
  76. Will multiple category descriptions effect my search engine optimization?
  77. Post picker custom field on page
  78. Display Parent-Child Posts in specific order by comparing IDs in array
  79. Function is printing twice – any suggestions?
  80. SEARCH QUERIES – REVERSE OUTPUT
  81. How to use two query result together in one loop
  82. show loop id post , only first id can read
  83. filter posts based on menu_order
  84. Change archive results based on GET request
  85. Wp_query loop is not working as it should
  86. Show all posts from the tags without having to set all of them
  87. Is there a global page/post/product/anything ID?
  88. Auto populate custom fields by post date
  89. ACF Relationship – Get Parent’s Post Object
  90. wp query custom orderby not custom field
  91. Order Custom Field by Price
  92. Calling specific page with wp query
  93. Update Post with Modified Data
  94. The next_posts_link() works only with original $wp_query
  95. wp_query select if have comments
  96. Limit amount of pages shown in pagination within wp_query
  97. How to make a local “scroll to ID” on post?
  98. Custom Admin Post Column change order
  99. post loop with different design depending on post
  100. Sort wp_query of two post types using meta datefield for one and date for the other – possible?