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:
- SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
- Order by summing multiple values
- Randomly select one of last 3 posts
- Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
- orderby in WP_query doesn’t works
- WP_Query with several meta_query-statements and order by meta_value
- WP_Query with “post_title LIKE ‘something%'”?
- Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
- Pagination with custom SQL query
- WP_Query orderby post__in remains ineffective in the Loop [closed]
- WP_Query orderby date not working
- Order by optional meta key?
- Sorting: custom query with orderby meta_value_num THEN by title
- Order by DESC, ASC in custom WP_Query
- WP_Query order by multiple meta keys & fields
- Whats the difference between post_limits and pre_get_posts?
- Using OR conditions in meta_query for query_posts argument
- Secondary Sort (fallback) for WP_Query
- Query Posts in a Predefined Order
- How to get order of posts?
- Order posts by ID in the given order
- Is it possible to wrap Geo Location search around WP_Query?
- Custom WP_Query order by post_meta and (author) user_meta
- Sorting posts by custom date fields (non standard date format)
- Is it possible to select against a post’s parent’s fields with WP_Query?
- How to order posts tag by tag?
- How do I order pages and categories by ID or name in the same query?
- Extending WP_Query — Optimise SQL query
- Identify which loop you are hooking into; primary or secondary?
- How to filter sql only for a specific post type
- WP_Query ordered by custom field that is a date string?
- How to make an activities stream mixing posts and comments?
- WP_Query sort by comment meta data
- SQL Statement generated by WP_Query not producing expected results
- What is an efficient way to query based on post_meta?
- Order posts by tags count?
- Merge 2 args in one WP_Query and order it by date
- Orderby = none not working [duplicate]
- SQL query equivalent to WP User Query
- WP_query ‘orderby=none’ Problem
- Order posts by date and then by custom field
- How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
- Revolution Slider Orderby Two Custom Fields
- Recommended way to drop a pending query (in pre_get_posts)?
- Order posts ascending with number in title
- how to retrieve specific product attribute value in an sql query?
- List taxonomy terms plus their latest post ordered by post date
- Order by the results of a function with WP_query
- How to order posts in wp_query by a meta_value of the corresponding author
- Order by menu structure
- WP_Query order by date in meta_value
- Filter WordPress posts by between parameter
- SQL User Query by Multiple Roles using PHP
- Advanced WP Query hogs the SQL server
- How to use order RAND() on WordPress?
- Show all parents and children in custom post type in right order
- SELECT * FROM $wpdb->posts WHERE ID > 160
- Ordering by meta_value AND date NOT WORKING with wp_query
- WP_Query orderby breaks when using AJAX?
- Order WP Query posts by custom order calculated from post meta values
- Custom Post order for homepage
- Meta query with order by another custom field
- Change default ordering of taxonomy terms – pre_get_terms
- WordPress WP_Query orderby being overwritten
- WP_Query Order by Specific Post ID First
- Order Posts by meta value AND published date
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- How can I pick a single post from the latest 3?
- Wp query orderby ‘title’ doesn’t work
- Query post with meta_query where date is not in future
- How can I order Wp_Query hierarchically?
- WP User Query get all authors with last name starting with specific letter
- Select from wp_post and multiple meta_value from wp_postmeta
- How do I sort posts with multiple pages
- Sorting posts DESC based on the number of comments using WP_Query
- How to correctly pass values to wpdb->prepare()?
- Order WP_Query by multiple fields, subtracting them from one another
- Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
- pre_get_posts order by not working
- Sort users by “birthday” using WP_User_Query
- $wpdb select date range of posts
- How To Fix WP Query Returns Results But Shouldn’t?
- List of the years with posts presented
- (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
- Orderby ASC changes to DESC in WP_Query
- Order By table field comment_status in WordPress > 4.0
- Slow WP_Query for custom post type
- Complex WP_Query order request: DESC by day, but then ASC by time
- Complex WP SQL Query
- How to set multiple `orderby` in query argument?
- Query that loads a custom type AND posts whose ids are not inside those custom types custom fields
- WP_Query order result by date AND meta_value
- Optional Meta Query
- Order by title without taking into account ‘the’
- Sorting events by descending date, and ascending time if multiple events on a date
- WP_Query orderby author__in
- How to orderby multiple meta fields if some fields are empty
- Editing the default wordpress search
- Sort wordpress custom posts based on meta value
- WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC