Okay, I found the problem by debugging the query.
It was a generic LEFT JOIN added with the posts_join filter that has not alias the $wpdb->postmeta table which finally leads to the error.
So the sorting is working now without problems.
Related Posts:
- Custom query filter not working on woocommerce category page
- $query->query_var[‘post_type’] not set for pages
- Filter query posts by the count of metas for a meta key
- How to set back query var author_name after unset it?
- Change searched term
- pre_get_posts : ‘post__not_in’ doesn’t work with global variable
- How to change the amount of posts previewed on a page?
- How to reset usual $query on search page to push custom $wpdb query there?
- Merge CPT Taxonomy and Post Taxonomy in $query->set
- New custom post type entries are not sorted correctly in admin using pre_get_posts
- Limiting a filtered query
- Why the pre_get_posts hook can cause apache stopped working?
- excludeCat function reverses order of blog posts
- Run search query again without pagination gives no results?
- Set posts per page for parent category and it’s all children
- Filter multiple different main queries on custom pages
- Modify a query using both a text field and a true/false AFC field
- How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
- Admin Post List table Query filtering “WHERE” for custom post type
- Differences between wpdb->get_results() and wpdb->query()
- Is there a way of increasing the speed of this query?
- Using WordPress public query variables
- How to get link and title of next and previous post on single page
- wpdb get posts by taxonomy SQL
- How to List Events by Year and Month Using Advanced Custom Fields?
- Is there any difference between hooks posts_where with posts_join and posts_search performance wise?
- pre_get_posts with get_posts
- Get a user’s most recent post title
- Different Main Navigation per category
- Show recent products first but “sold out last” in query
- Show All Posts Insert Edit Link
- Get IDs of posts currently visible on archive
- Get posts by category with pure SQL query
- can’t get query to order posts by acf datepicker
- Custom query to get terms from post ids
- Help with wordpress custom query and advanced custom fields plugin
- WordPress query by category, sorted by custom field
- Mysql / WordPress killing my server with 80k users [closed]
- Query all posts and not repeat the same tag
- Deleting data from a custom table in WordPress
- How many queries are normal to execute on a WP site?
- How to optimize my query filtering out unwanted data?
- Remove posts from query for events whose start date has passed
- Insert static element only once in query archive
- How to run a mysql query when admin updates user role?
- Error when using setup_postdata()
- Query Posts By Post Publish Date, but sort by Custom Meta Key
- Getting post data from private page
- Missing posts in a query
- Alter a specific query on WordPress
- SQL query to select posts from multiple categories
- Protect sequence of pages with same password for each of two groups of users
- How is it possible to get top comment from all children?
- Select Query demand excesive resources [closed]
- Create Indexes for Slow Queries
- Query to get number of posts last week
- I want to create a filter for the query string is this possible?
- Exclude categories from the_category();
- How can i show all categories using wp query?
- All in One Calendar Plugin Custom Post Type Query [closed]
- Get Posts from Last 24 hours and Sort them via GD Star Rating
- Query returning same results even though the ID changes
- Why my query ‘REPLACE INTO…’ does not work?
- Restrict query to last day with posts
- Custom query object with Simple-Fields custom date field
- How to read the value of a WordPress $query associative array (hash) key
- Query posts based on previous query
- Waypoints + infinite scroll with custom query
- Customizing the_tags output?
- Querying with WP query using meta key price
- Re-sort get_posts query results
- How do I get all results from my query
- Taxonomy filter under Polylang
- How to create an overview of posts with the same tag?
- create a link to a random post within the current category
- Pagination not working on custom post types with rewrite slug
- `offset` WP_Query argument dont work via `pre_get_posts`
- JetEngine Query Builder – order by value from repeater
- Change pure SQL database query to WordPress post query?
- Filter orders by modify date
- How to add url parameter to every search query in SearchWp?
- How can I get posts by 2 meta keys, prioritising one of them?
- How to create a filter and add query params to all links
- SQL query to list all posts of specific post type with a specific set of associated postmeta values as a column
- implementing my wp_query using $wpdb class
- Category_in return empty
- WP search exclude last letter from string
- modifying main query to query for ranges e.g. from 1999 to 2016
- Querying users by meta value and getting a strange answer
- Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
- Sort loop with query in the link
- About WP’s save_post action
- $wpdb: how to use a query as a base for another query?
- Multilingual WordPress page – using URL to determine language?
- list or get meta_key where meta_value is ‘something’
- WP_Query with checkbox meta_query – WordPress [duplicate]
- How to display search query as formatted text?
- What is the best way to cache pages and queries in WordPress?
- Search query alteration not working for meta values
- Sorting a custom post type in pre_get_posts