Debugging wp_query orderby for taxonomy

You can’t pass SQL directly as query parameters. The only valid values for orderby are covered in the docs for WP_Query.

If you want to directly modify the SQL, you need to use the posts_* filters, in this case posts_orderby.

Related Posts:

  1. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  2. Order by summing multiple values
  3. Randomly select one of last 3 posts
  4. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  5. orderby in WP_query doesn’t works
  6. WP_Query with several meta_query-statements and order by meta_value
  7. WP_Query with “post_title LIKE ‘something%'”?
  8. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  9. Pagination with custom SQL query
  10. WP_Query orderby post__in remains ineffective in the Loop [closed]
  11. WP_Query orderby date not working
  12. Order by optional meta key?
  13. Sorting: custom query with orderby meta_value_num THEN by title
  14. Order by DESC, ASC in custom WP_Query
  15. WP_Query order by multiple meta keys & fields
  16. Whats the difference between post_limits and pre_get_posts?
  17. Using OR conditions in meta_query for query_posts argument
  18. Secondary Sort (fallback) for WP_Query
  19. Query Posts in a Predefined Order
  20. How to get order of posts?
  21. Order posts by ID in the given order
  22. Is it possible to wrap Geo Location search around WP_Query?
  23. Custom WP_Query order by post_meta and (author) user_meta
  24. Sorting posts by custom date fields (non standard date format)
  25. Is it possible to select against a post’s parent’s fields with WP_Query?
  26. How to order posts tag by tag?
  27. How do I order pages and categories by ID or name in the same query?
  28. Extending WP_Query — Optimise SQL query
  29. Identify which loop you are hooking into; primary or secondary?
  30. How to filter sql only for a specific post type
  31. WP_Query ordered by custom field that is a date string?
  32. How to make an activities stream mixing posts and comments?
  33. WP_Query sort by comment meta data
  34. SQL Statement generated by WP_Query not producing expected results
  35. What is an efficient way to query based on post_meta?
  36. Order posts by tags count?
  37. Merge 2 args in one WP_Query and order it by date
  38. Orderby = none not working [duplicate]
  39. SQL query equivalent to WP User Query
  40. WP_query ‘orderby=none’ Problem
  41. Order posts by date and then by custom field
  42. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  43. Revolution Slider Orderby Two Custom Fields
  44. Recommended way to drop a pending query (in pre_get_posts)?
  45. Order posts ascending with number in title
  46. how to retrieve specific product attribute value in an sql query?
  47. List taxonomy terms plus their latest post ordered by post date
  48. Order by the results of a function with WP_query
  49. How to order posts in wp_query by a meta_value of the corresponding author
  50. Order by menu structure
  51. WP_Query order by date in meta_value
  52. Filter WordPress posts by between parameter
  53. SQL User Query by Multiple Roles using PHP
  54. Advanced WP Query hogs the SQL server
  55. How to use order RAND() on WordPress?
  56. Show all parents and children in custom post type in right order
  57. SELECT * FROM $wpdb->posts WHERE ID > 160
  58. Ordering by meta_value AND date NOT WORKING with wp_query
  59. WP_Query orderby breaks when using AJAX?
  60. Order WP Query posts by custom order calculated from post meta values
  61. Custom Post order for homepage
  62. Meta query with order by another custom field
  63. Change default ordering of taxonomy terms – pre_get_terms
  64. WordPress WP_Query orderby being overwritten
  65. WP_Query Order by Specific Post ID First
  66. Order Posts by meta value AND published date
  67. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  68. How can I pick a single post from the latest 3?
  69. Wp query orderby ‘title’ doesn’t work
  70. Query post with meta_query where date is not in future
  71. How can I order Wp_Query hierarchically?
  72. WP User Query get all authors with last name starting with specific letter
  73. Select from wp_post and multiple meta_value from wp_postmeta
  74. How do I sort posts with multiple pages
  75. Sorting posts DESC based on the number of comments using WP_Query
  76. How to correctly pass values to wpdb->prepare()?
  77. Order WP_Query by multiple fields, subtracting them from one another
  78. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  79. pre_get_posts order by not working
  80. Sort users by “birthday” using WP_User_Query
  81. $wpdb select date range of posts
  82. How To Fix WP Query Returns Results But Shouldn’t?
  83. List of the years with posts presented
  84. (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
  85. Orderby ASC changes to DESC in WP_Query
  86. Order By table field comment_status in WordPress > 4.0
  87. Slow WP_Query for custom post type
  88. Complex WP_Query order request: DESC by day, but then ASC by time
  89. Complex WP SQL Query
  90. How to set multiple `orderby` in query argument?
  91. Query that loads a custom type AND posts whose ids are not inside those custom types custom fields
  92. WP_Query order result by date AND meta_value
  93. Optional Meta Query
  94. Order by title without taking into account ‘the’
  95. Sorting events by descending date, and ascending time if multiple events on a date
  96. WP_Query orderby author__in
  97. How to orderby multiple meta fields if some fields are empty
  98. Editing the default wordpress search
  99. Sort wordpress custom posts based on meta value
  100. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
File not found.