WP_Query no posts with tax_query

Your query can be simplified to this:

$products = new WP_Query([
    'post_type' => 'post',
    'show_product_on_only_premium' => 'yes',
]);

echo var_dump($products->posts);

The culprit was likely the 'operator'=>'AND', the default value is IN, so changing your original query to use IN instead of AND would also work, as would removing the operator parameter as the default is also IN

Related Posts:

  1. Can I force WP_Query to return no results?
  2. Use the page slug in a WP_Query?
  3. Sorting: custom query with orderby meta_value_num THEN by title
  4. paginate_links() adds empty href to first page and previous link
  5. Using OR conditions in meta_query for query_posts argument
  6. Get array of posts from the current archive page loop
  7. Get posts by menu ID
  8. count posts from custom taxonomy terms by year
  9. How to grab metabox value in wp_query meta_query key
  10. Woocommerce query by price range and custom meta key
  11. Get posts with condition on comment meta value
  12. Stop all SQL_CALC_FOUND_ROWS wordpress queries
  13. Move posts to top of WP_Query if in certain Taxonomy?
  14. WP_query ‘orderby=none’ Problem
  15. Pagination not working on static page
  16. How can I create a WP_Query that returns posts where one meta_value
  17. ‘paged’ in wp_query doesn’t work
  18. Sorting meta_value as integer doesn’t work
  19. Display different number of posts from one category on the different pages
  20. How to display child posts in the parent category
  21. Get posts from the Main site to sub site – WordPress MultiSites Network
  22. Custom Field Query – Meta Value is Array
  23. Get array of current post term ID’s
  24. WP_Query for showing specific post by id
  25. Ordering by meta_value AND date NOT WORKING with wp_query
  26. Query by custom dates in UNIX Time
  27. Custom WP Query from meta_value stored as serialised array
  28. Implementing an OR statement to wordpress wp_query
  29. Get List of all the Authors
  30. How to check if a post “does not have term” in conditional statement?
  31. Query “Category A” + 1 post from “Category B” – how?
  32. Unexpected end of file
  33. WP_Query To call data from diffrent tables
  34. new WP_Query with author argument return no results
  35. Clean up WordPress code that repeats
  36. WP_Query: “post_parent” and “post_type” combination returning strange results
  37. Display Featured Post by Categories and Avoid duplicated posts
  38. How to use the query hook/filter?
  39. How to show optimized list of posts with all their attachment images
  40. Posts not showing per category after WP_Query?
  41. wp_query exclude word and category
  42. WP_query return more results than SQL query. post_count > found_posts
  43. How do I exclude the lowest level terms in a taxonomy?
  44. How can I query users by custom role?
  45. Pagination inside of a edit page
  46. Problem with is_tax in WP_Query loop
  47. Easy way to write complex queries in wordpress
  48. Error with function in functions.php?
  49. I am having problem sorting custom post type using WP_Query
  50. WP_Query and is_page_template() conditional
  51. Exclude recently updated post from custom WP_Query using multiple loops
  52. get_posts output always same post
  53. difference between querying database and using the loop
  54. How to do logical OR in terms in WP Query?
  55. Limit number of posts in loop
  56. Slow Query On Search
  57. Loop posts based on permalink term
  58. Child pages not affected by orderby
  59. Write WP Query that selects posts that are part of the same two categories
  60. Error in meta_query not get result
  61. Custom wp_query – I’m getting ‘all’ post, not the specific post in the query
  62. How to get current page nearest parent id?
  63. How to create Page templates for showing Blog posts in different layouts?
  64. wp Query Posts to display in Nivo Slider
  65. How to get only ONE category of “Portfolio” posts to display on main page rather than ALL categories?
  66. Determining what post is displayed out of total posts found
  67. Prioritising and Ordering Posts By Category Name Using A Custom Loop
  68. Strange behaviour of hierarchical taxonomy archive
  69. Is it normal that get_post() gets run 300 times and the content of those posts aren’t visible?
  70. meta_query – check for multiple meta values in key which holds an array of values
  71. How to sort wordpress posts already selected by WP_QUERY
  72. WordPress Sub Category Archive, Show Extra Empty Page Number in Pagination
  73. Searching for a specific month in a metadata saved as Timestamp (Wp_Query)
  74. Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
  75. SEARCH QUERY PLEASE HELP | call_user_func_array() expects parameter 1 to be a valid callback php
  76. Get posts having meta value between two numbers
  77. Merge wp-query and get_users
  78. WP_Query how to add a thumbnail to the first post from the last 5 posts?
  79. How order by works?
  80. taxquery taxonomy get terms
  81. Using modified ‘meta_key’ to set ‘orderby’ in WP_Query?
  82. Calling a function with WP_Query only ever brings the first result
  83. get last child post by wp_query
  84. WP_Query don’t working with fixed post_id and term_taxonomy
  85. Query posts in current category but not attachment format
  86. Create multiple sections for all categories and then queries all the posts for each of those categories
  87. Using orderby with 2 meta keys
  88. wp_query – Modify $query to include duplicate content
  89. Query to get all the posts of more than 2 meta_value having same meta_key?
  90. WP Query get posts by specific author IDs if one of several logged in authors
  91. Query specific number of posts for each post type in specific order
  92. Avoiding page loop
  93. Query Users by post count, last 30 days and display each users post count according to post type
  94. how do I exclude child categories from a wp_query?
  95. How to create a loop inside WP_Query?
  96. how to show only catergory titles on a page in wordpress
  97. WP Query – Show custom posts only if user contain some user meta
  98. How do I subquery with custom meta fields?
  99. Show number of posts AND number on current page (cannot make it work)
  100. Advanced Search – Is this possible?