SQL Statement generated by WP_Query not producing expected results

It looks like this section:

AND (wptom_posts.post_status="publish" 
OR wptom_posts.post_author = 1 
AND wptom_posts.post_status="private")

is not tied in at all to the two different query conditions…

Perhaps the original code should be three conditions for part 1:

array( 
    'relation' => 'AND',
    array(  'taxonomy' => 'category',
            'field' => 'slug',
            'operator' => 'IN'),
    array( 'taxonomy' => 'post_tag',
            'field' => 'slug',
            'operator' => 'IN'),
    array( 'terms' => array('private') )
),

I am guessing a bit here without testing it, but that’s what I’d try.

Related Posts:

  1. Recommended way to drop a pending query (in pre_get_posts)?
  2. Formulate a url to show posts with both taxonomy terms
  3. Complex WP SQL Query
  4. Combining categories (Query posts with multiple taxonomy terms)
  5. Query most popular terms by taxonomy over 2 week period
  6. How I can change the condition or compare operator for WP_Query in pre_get_posts
  7. list all post who have mutual taxonomy as current taxonomy!
  8. Taxonomy archive, categorised by other taxonomy, not hiding empty taxonomies
  9. Combine Tax Archive and Meta_Query in WP_Query
  10. WP_Query on custom taxonomy -> Location and Activity
  11. When to use WP_query(), query_posts() and pre_get_posts
  12. WP_Query with “post_title LIKE ‘something%'”?
  13. Should I use Pre Get Posts or WP_Query
  14. Using pre_get_posts with WP_Query
  15. Pagination with custom SQL query
  16. WP_Query orderby post__in remains ineffective in the Loop [closed]
  17. What is “main query”? [duplicate]
  18. Whats the difference between post_limits and pre_get_posts?
  19. Reduce or prevent calling of update_meta_cache
  20. How to add taxonomy filter on the query fly?
  21. Using OR conditions in meta_query for query_posts argument
  22. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  23. How to uniquely identify queries?
  24. Is it possible to wrap Geo Location search around WP_Query?
  25. Order Search Results Page by meta_value If no Value Return Remaining Results
  26. pre_get_posts with get_posts
  27. How-to exclude terms from the main query the most performant way?
  28. Changing Posts Per Page and offset with pre_get_posts
  29. Is it possible to select against a post’s parent’s fields with WP_Query?
  30. Slow SQL_CALC_FOUND_ROWS Query
  31. Extending WP_Query — Optimise SQL query
  32. “pre_get_posts” firing on every query
  33. RSS feed with specific keyword
  34. How to filter sql only for a specific post type
  35. Using is_main_query to select custom post type on certain page
  36. WP_query taxonomy + get all posts with two terms from same taxonomy
  37. Multiple orderby parameters in pre_get_posts() action
  38. How to make an activities stream mixing posts and comments?
  39. Counting number of posts with Category B in Category A
  40. What is an efficient way to query based on post_meta?
  41. Custom archive page based on array of categories and tags
  42. SQL query equivalent to WP User Query
  43. Sorting Posts by custom field
  44. How to pass custom parameter to WP_Query for filtering in pre_get_posts
  45. Query with pre_get_posts to get pagination
  46. How do I search WordPress by different fields without a plugin?
  47. Single page theme that uses pages for the content
  48. how to retrieve specific product attribute value in an sql query?
  49. WordPress custom search form with pre_get_posts not work
  50. If orderby parameter using pre_get_posts is the same for multiple posts what fallback does the query use?
  51. Can not switch the queried post in pre_get_posts hook
  52. How to target the default Recent Posts and Recent Comments widgets with pre_get_posts?
  53. order by multiple meta keys in pre_get_posts
  54. How to sort posts in admin by titles with dd.mm.yyyy format?
  55. tax_query shows no results if nothing is selected
  56. WP_Tax_Query with post_tag not working
  57. Filter WordPress posts by between parameter
  58. Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
  59. Improving WP_Query performance for multiple taxonomies
  60. SQL User Query by Multiple Roles using PHP
  61. get complex results set according to category structure
  62. Advanced WP Query hogs the SQL server
  63. How to Modify Taxonomy Archive Page with Search Parameter?
  64. Using pre_get_posts on a specific core/query block
  65. SELECT * FROM $wpdb->posts WHERE ID > 160
  66. Searching through different categories on different pages code is not working
  67. How to display future posts – modified query still yields 404
  68. Get image of latest post from taxonomies/categories
  69. pre_get_posts filter meta_query without conflicting existing meta_query
  70. Including only current user’s posts in search
  71. When querying a combination of posts and other meta fields, is there a better solution than directly modifying the WHERE value?
  72. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  73. How to change posts order on Category and Tag archives?
  74. Query post with meta_query where date is not in future
  75. Query Custom Post Type Order By Taxonomy Field
  76. WP User Query get all authors with last name starting with specific letter
  77. Select from wp_post and multiple meta_value from wp_postmeta
  78. My Main Query Modification is Messing up my dynamic main – why?
  79. Shortcode to show thumbnail and link for 3 random posts
  80. Offset Page Loops and Pagination
  81. pre_get_posts Remove tax_query Completely
  82. How to correctly pass values to wpdb->prepare()?
  83. pre_get_posts order by not working
  84. Sort users by “birthday” using WP_User_Query
  85. Adding a parameter to the default query
  86. Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
  87. Taxonomy search/filter with multiple taxonomies and multiple taxonomy terms
  88. $wpdb select date range of posts
  89. Single meta_query query using OR instead of AND in request’s WHERE statement
  90. How To Fix WP Query Returns Results But Shouldn’t?
  91. How to choose between hooking into per_get_posts or into parse_query
  92. List of the years with posts presented
  93. Store sticky post’s ids in a transient
  94. How to change main query based on post meta
  95. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  96. Slow WP_Query for custom post type
  97. new WP_Query to get max price meta value not working
  98. Display posts from only one post form in custom query and exclude in main query
  99. Show Sticky Post at the top but do not show again in the loop?
  100. WP_Query, pre_get_posts and offset

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)