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. When to use WP_query(), query_posts() and pre_get_posts
  11. WP_Query with “post_title LIKE ‘something%'”?
  12. Should I use Pre Get Posts or WP_Query
  13. What is “main query”? [duplicate]
  14. Whats the difference between post_limits and pre_get_posts?
  15. How to add taxonomy filter on the query fly?
  16. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  17. How to uniquely identify queries?
  18. Order Search Results Page by meta_value If no Value Return Remaining Results
  19. pre_get_posts with get_posts
  20. RSS feed with specific keyword
  21. Multiple orderby parameters in pre_get_posts() action
  22. How to make an activities stream mixing posts and comments?
  23. Counting number of posts with Category B in Category A
  24. SQL query equivalent to WP User Query
  25. How to pass custom parameter to WP_Query for filtering in pre_get_posts
  26. Query with pre_get_posts to get pagination
  27. How do I search WordPress by different fields without a plugin?
  28. Single page theme that uses pages for the content
  29. WordPress custom search form with pre_get_posts not work
  30. order by multiple meta keys in pre_get_posts
  31. WP_Tax_Query with post_tag not working
  32. Advanced WP Query hogs the SQL server
  33. Using pre_get_posts on a specific core/query block
  34. When querying a combination of posts and other meta fields, is there a better solution than directly modifying the WHERE value?
  35. How to change posts order on Category and Tag archives?
  36. Query post with meta_query where date is not in future
  37. Query Custom Post Type Order By Taxonomy Field
  38. Shortcode to show thumbnail and link for 3 random posts
  39. Offset Page Loops and Pagination
  40. pre_get_posts order by not working
  41. Adding a parameter to the default query
  42. Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
  43. Taxonomy search/filter with multiple taxonomies and multiple taxonomy terms
  44. How To Fix WP Query Returns Results But Shouldn’t?
  45. List of the years with posts presented
  46. How to change main query based on post meta
  47. Display posts from only one post form in custom query and exclude in main query
  48. Optional Meta Query
  49. Sorting events by descending date, and ascending time if multiple events on a date
  50. Editing the default wordpress search
  51. How to extract specific post
  52. Woocommerce – Changing the order of the upsell products [closed]
  53. Changing sort order for presentation by Jetpack infinite scroll
  54. Filtering out child category posts from parent category archive not working
  55. Include data from custom table in WP_Query
  56. Woocommerce – exclude only older out-of-stock items
  57. Is it possible to query from external database? [duplicate]
  58. WP Query – order posts by meta field first and then order the rest
  59. Make a SQL query with wpdb in WordPress
  60. List of ways to access WordPress database?
  61. Getting rid of unwanted nonSQL syntax characters when debugging a query
  62. Query where ANDing slug values not working
  63. WP_Query – How to get all posts of specific days of week by custom field date?
  64. How to avoid filling up an array each time I run a WP_query?
  65. How to SQL query posts IDs by categories AND authors?
  66. tax_query in pre_get_posts
  67. Elementor posts custom query based on tag [closed]
  68. Exclude post with taxonomy and from the terms (taxonomy & tag) posts count
  69. `offset` WP_Query argument dont work via `pre_get_posts`
  70. Replace wp_query with wp_user_query
  71. SQL query injection with fifu image
  72. Make a products only viewable to a specific user ID in meta_query pre_get_posts
  73. pre_get_posts pagination not working
  74. WP Query – grouping posts by same meta key, adding together values from another key
  75. meta_query is overriding default search
  76. What is the equivalent WP_Query of a SQL Query?
  77. Translating WP query into to SQL query
  78. Filtering posts for unique titles, only the most recent
  79. Order posts by title and custom field value?
  80. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  81. How to search CPTs in draft using get_page_by_title()
  82. Limit default Search query to post_title
  83. Taxonomy Terms That Don’t Exist Display Results
  84. why doesn’t this pre_get_posts code work?
  85. pre_get_posts with WP_Query to prevent posts from specific tags
  86. What argument does my function need to echo get_results() query results
  87. Using the same WP_Query for shop and widgets in WooCommerce shop
  88. Custom taxonomy and query multi conditions
  89. Adding a Theme Customizer Control for Posts_Per_Page
  90. Order posts by custom column using pre_get_posts
  91. WP_Query on “property” in the options table
  92. Custom query to order by multiple taxonomies
  93. Custom WP_Query with SQL directives for getting posts by authors and terms
  94. orderby in WP_query doesn’t works
  95. Looking for a way to exclude frontpage and nav menu from query filter
  96. pre_get_posts redirecting
  97. Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
  98. Search query alteration not working for meta values
  99. How to put posts with some taxonomy on top of others in `pre_get_posts`
  100. How to make OR condition in WP_Query

Leave a Comment