custom sorting media with multiple filters – error: not unique table/alias: wp_postmeta

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:

  1. Custom query filter not working on woocommerce category page
  2. $query->query_var[‘post_type’] not set for pages
  3. Filter query posts by the count of metas for a meta key
  4. How to set back query var author_name after unset it?
  5. Change searched term
  6. pre_get_posts : ‘post__not_in’ doesn’t work with global variable
  7. How to change the amount of posts previewed on a page?
  8. How to reset usual $query on search page to push custom $wpdb query there?
  9. Merge CPT Taxonomy and Post Taxonomy in $query->set
  10. New custom post type entries are not sorted correctly in admin using pre_get_posts
  11. Limiting a filtered query
  12. Why the pre_get_posts hook can cause apache stopped working?
  13. excludeCat function reverses order of blog posts
  14. Run search query again without pagination gives no results?
  15. Set posts per page for parent category and it’s all children
  16. Filter multiple different main queries on custom pages
  17. Modify a query using both a text field and a true/false AFC field
  18. How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
  19. Admin Post List table Query filtering “WHERE” for custom post type
  20. pre get posts not working with Tribe Events
  21. Custom query_var causes displaying posts archive on front page
  22. What is the most efficient way of implementing a favorite post system?
  23. Why does get_the_time(‘F j’) return November 30 for all posts?
  24. Query by one meta_key and sort by another (possibly NULL value)
  25. Query & Sort Comments by custom comment meta
  26. is_archive() doesn’t work on public query var archive pages?
  27. How to count get_users query?
  28. Possible to get posts from multiple meta keys/values in a single query?
  29. Difference between fragment caching and wp_cache
  30. How to display all posts with today’s same month and day only?
  31. Select User by Joining Multiple Meta Value Results
  32. Show featured image as background image from postQuery
  33. Using $wpdb->update but confused on the WHERE in and SET
  34. Include posts from feature category in pre_get_posts
  35. You have an error in your SQL syntax – Help with query
  36. Make one query for adding entries to database
  37. add_query_arg() and empty variables inside
  38. Query Strings and Woocommerce
  39. Style Post Differently In Query
  40. WordPress post type “event” query string fix?
  41. order one custom post type by modified time of another post type
  42. is_search called incorreclty
  43. Function to delete a post, it’s children and it’s grand children (half way there already)
  44. Nested loop : wich way/order?
  45. How to write: $wpdb->update having WHERE NOT value pair in the array
  46. Query posts according to specific post meta values
  47. wpdb COALESCE won’t work
  48. empty query breaks other queries
  49. Problem in exploding the_content to array
  50. Query does not return content
  51. What is wrong with my wp query, cant exclude the category that i want
  52. how to insert missing tags into the posts through mySQL?
  53. Parse query filter in wordpress and relation
  54. Modify date query by URL parameter using pre_get_posts and $_GET
  55. How to write update query in WordPress to expire transients
  56. Query Nickname rather than Display Name in custom Woocommerce plugin
  57. Get previous posts list
  58. how to replace old DW site with new WP site? [closed]
  59. WordPress SQL query to tag all posts containing a specific word on title
  60. Order terms by count – missing terms
  61. Querying Advanced Custom Fields
  62. How to rearrange a pool of posts joined using two queries?
  63. wpdb update multiple row?
  64. List WordPress Post and Related Attachments outside of a post page
  65. Can I include get_posts in this array?
  66. Custom query Custom-Post-Types creates error
  67. Formatting a date/time returned from a custom $wpdb query
  68. Rewrite rule for query params
  69. Cannot get sql request from Query object?
  70. WordPress query: merge meta key (number) values and sort
  71. Question about of query
  72. Is there any way to get all custom posts and all custom terms with it’s meta in few queries?
  73. Modify behaviour of “s” parameter in wp_query
  74. Pulling an ACF into a query
  75. How to make MySQL search queries with quotes
  76. Using cron for multiple queries
  77. Archive query not working correctly
  78. Custom MySQL Query for Post and Post Meta
  79. Displaying popular posts
  80. Exclude sticky posts from query
  81. How to have more post in a page than in your home page
  82. Find all posts via SQL beginning with A of type B
  83. learn to run wpdb class
  84. Display old posts if no future posts exist
  85. Access Tables with number prefix
  86. Can I use $query->set() (in a pre_get_posts() hook) with a custom taxonomy in WP 3?
  87. how to add a read more button to my blog page?
  88. How to query different categories on index?
  89. Print data from wordpress sql query
  90. How to add multiple values with add_query_arg?
  91. Query parsing only author ids
  92. 3 queries to update WordPress
  93. Ascending & descending posts on same page with IF statement
  94. Prevent executing query for wp_global_styles
  95. Meta Query compare with LIKE pulls similar post types: 55 and 155, and 1,155
  96. How to show sticky posts on all pages of the pagination, not just the first page?
  97. is it possible to get a list of URLs from post_content directly in a mysql query via phpadmin?
  98. Get URL parameters with rewrite rules
  99. is_search called incorrectly
  100. Trying to Add Paging to Single Post Page