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. The next_posts_link() works only with original $wp_query
  27. Different post sort order within different categories
  28. WP_Query: Why is sticky post not first item in loop?
  29. Query *only* sticky posts
  30. Skipping first 3 posts in wp query
  31. meta_box or custom_field as a second tinymce post-instance?
  32. Set number of article per number of page
  33. Get only modified posts
  34. Create A Metabox For A Custom Field
  35. How to choose a sort order (for posts) per category? (ideally when creating a new category)
  36. Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
  37. Sanitizing `wp_editor();` Values for Database, Edit, and Display
  38. Hide Post comments when displayed via WP_Query
  39. orderby=meta_value_num creates duplicate posts
  40. Custom fields on a virtual page
  41. posts_per_page doesnt work
  42. Get a custom field of all posts on current blog page
  43. Display posts in alphabetical order for a particular category
  44. How can I get a post field value using javascript?
  45. Improving WP_Query for performance when random posts are ordered
  46. Why won’t my taxonomy query show up?
  47. WP_Query with ajax handler returns the same posts
  48. Hiding Draft Post In Admin
  49. How to verify wp user password by sql query in wp? [closed]
  50. Sort WP posts by span value
  51. Automatically add custom fields value to wordpress post
  52. How to filter my search in post if contains a word in title, content or excerpt?
  53. How to sort posts inside categories
  54. Lost draft under all posts and drafts
  55. Get user categories with most posts in it
  56. Random ajax load only works with posts_per_page set to -1
  57. Query posts and return XML
  58. List authors with the last post title and order by last post date
  59. Hooking into the post editing screen for an existing page only
  60. Adding a blog archive with pagination using WP_Query
  61. How to get Tags with specific post id
  62. WordPress query_posts by tag doesn’t work anymore(?)
  63. Ignore latest two posts
  64. Print out last 3 blogposts
  65. How can I add a box to edit Order on a regular post?
  66. How to group only VISIBLE posts? [closed]
  67. Shortcode with ‘year’ parameter
  68. On what hook can I get the queried object’s final state?
  69. Add two custom fields as a default to the “new post” page.
  70. Get all custom posts with a certain taxonomy
  71. Link to date_query results in WordPress
  72. Query function not executed between element [closed]
  73. When WP_Query only returns 1 post, how do I automatically redirect to that post?
  74. Limiting post list by taxonomy
  75. Will multiple category descriptions effect my search engine optimization?
  76. How Can I Always Display A Particular Post First Using WP_Query?
  77. Post picker custom field on page
  78. Function is printing twice – any suggestions?
  79. Order posts inside bootstrap card columns
  80. How to use two query result together in one loop
  81. show loop id post , only first id can read
  82. filter posts based on menu_order
  83. Change archive results based on GET request
  84. Wp_query loop is not working as it should
  85. Show all posts from the tags without having to set all of them
  86. Is there a global page/post/product/anything ID?
  87. Auto populate custom fields by post date
  88. ACF Relationship – Get Parent’s Post Object
  89. wp query custom orderby not custom field
  90. Order Custom Field by Price
  91. Calling specific page with wp query
  92. $args Orderby The number
  93. Retrieve latest post by multiple categories with ID
  94. The next_posts_link() works only with original $wp_query
  95. Limit amount of pages shown in pagination within wp_query
  96. How to make a local “scroll to ID” on post?
  97. Show Title/Date/Excerpt of first post & only Title for rest in Query [duplicate]
  98. Get posts after calculating meta key
  99. Custom Admin Post Column change order
  100. Get related posts matching most of the provided tags using WP_Query