How to query Posts from a custom post type which contains a custom taxonomy?

You have one or two issues here and possible future bugs that you might encounter

  • term in your tax_query should be terms

  • Be carefull with terms having dates as names and especially dates as slugs. This can cause issues and unexpected results if custom permalinks clash or if something falls into the template hierarchy for some reason.

  • Never use the name field in a tax_query. There is an issue with the sanitizing of the term name before the join clause is constucted for the SQL query in the WP_Tax_Query class. This is a known bug that will propably be there for many versions to come.

    I have explained the complete issue in this answer I have recently done, so feel free to go read the whole 9 yards. But in short, what basically happens is, WP_Tax_Query uses sanitize_title_for_query to sanitize the input from the name field in a tax_query. This function strips all whitespaces and special characters and also convert all capitals to lowercase. So a term name like My Term Name/2 gets converted to my-term_name2 which will fail as that term name does not exist.

    In short, as precaution, do not use the name field in a tax_query, rather use term_id or slug. If you do not know these values, then use get_term_by() to get the term ID or slug from the name and then pass that to the tax_query

  • You should also make sure that you can query posts from your custom taxonomy and custom post type publically. Make sure that have the correct values set when you register the post type and taxonomy

Related Posts:

  1. WP the_posts() on single-cars.php get category link
  2. Variable not working in WP_Query
  3. display posts of custom post type with custom taxonomy
  4. Sort ACF by custom taxonomy
  5. Exclude a category from WP_Query
  6. $wp_query->queried_object->ID throws warning: Undefined property
  7. Select All in Parent Category, Group by Child Category?
  8. get_query_var() not working in pre_get_posts
  9. query multiple taxonomies
  10. Custom permalinks – post type – hierarchical taxonomy’s
  11. Sorting a list of posts displayed under a list of associated terms (which should be sorted without initial articles)
  12. Sort the main query in subcategories/terms?
  13. Custom Taxonomy List links being re-written
  14. Want to filter only parent post in admin area
  15. Custom Taxonomy and tax_query Issue?
  16. Quickest way to get last or oldest post date – WP Query
  17. Custom post query by taxonomy
  18. Separate Posts and Custom Post Type in Custom Taxonomy archive template
  19. Making pages also serve as taxonomies? Or give full pages to taxonomies?
  20. Show Post Count of a Category
  21. Why does using WP_Query inside a shortcode in an elementor page cause the arguments for WP_Query to get malformed?
  22. How to filter the taxonomy terms based on another taxonomy term
  23. Show Two custom Post type and their posts on category page
  24. Fetch taxonomies by custom post type id array
  25. Group custom posts by custom taxonomy names
  26. How can i skip same post from taxonomy term?
  27. Query/list all terms and their custom post count
  28. Wrong request query on cpt and tax
  29. Get custom taxonomies from multiple posts
  30. Pagination for Custom Taxonomy Page [duplicate]
  31. Search / Filter posts on Title/Content OR Tags
  32. Custom loop with multiple taxonomy queries
  33. List custom taxonomy specific to one custom post type
  34. Custom taxonomy rewrite give pagination 404
  35. WP_Query inside foreach loop returning same value for all options when filtered using ajax
  36. What’s the WP way to load remaining custom posts?
  37. Several post types on WP Query by tag and taxonomy
  38. How to have this permalink structure: post_type/postname/custom_inner_page
  39. Advanced search form with filters for custom taxonomies
  40. Why is my WP_Query outputting my entries twice?
  41. How to display Related Posts based on number of taxonomy terms matched
  42. tax_query not working in template
  43. Custom Taxonomy Not Showing in Front-End When Outputting a Custom Post Type with WP_Query()
  44. WP_Query() with custom post type and taxonomy — get all terms?
  45. Creating two loops based on different logic
  46. WP_Query parameter conflict
  47. Query within a foreach within a query (queryception)
  48. How to show all taxonomies within custom post type loop
  49. Copy/Move selected taxonomy terms to another taxonomy for posts
  50. List all Custom Post Type posts excluding certain Taxnomy term
  51. Get posts by category name
  52. Query custom posts from custom taxonomy
  53. Making a form for user to add new custom post with custom taxonomies and custom fields
  54. Query Custom Post Type by Taxonomy
  55. Multiple custom post type queries causing wrong post types to be grabbed in taxonomy + single templates?
  56. Related “custom post type” using “custom taxonomy”
  57. Display Parent-Child Posts in specific order by comparing IDs in array
  58. custom post type and a “sticky” position taxonomy
  59. Display post count for a specific month
  60. What is the best way to structure posts for the same event happening in different years?
  61. wp_post_delete is deleting all offices
  62. SEARCH QUERIES – REVERSE OUTPUT
  63. WP_Query to display number of custom post type filtered (order by) taxonomy
  64. Live search by custom tag
  65. WP_Query based on ‘s’ and tax_queries
  66. I cannot display custom posts in custom taxonomy
  67. post type => ‘any’ not applied my custom queries
  68. Ajax load more inside custom post type taxonomy
  69. How can I get the last 5 element of this tax query?
  70. How to get the posts that my following users are liked?
  71. WP Query tax_query not returning posts
  72. Create a custom wp_query from a specific custom post type with specific taxonomy
  73. How to get all posts related to a taxonomy?
  74. The most recent post of custom taxonomy
  75. Problems with the WP_Query query for a Custom post type
  76. Display all Custom taxonomy terms and their relevant custom posts
  77. Query pulling all taxonomies, not one I am specifying
  78. CPT Efficient way to display posts from different categories with custom query
  79. How To Loop Through list with Custom Post Types
  80. Get archive of posts separated by taxonomies and subtaxonomies
  81. Query Pulling the same post twice
  82. Custom Post Status & Taxonomies
  83. WordPress custom post type
  84. Post Editor: display categories from current post type taxonomy only?
  85. Post data in separate divs with incrementing class using WP_Query
  86. Values inside a custom field to determine which category posts to display
  87. WP Query WordPress Post Type with the same Taxonomy name
  88. How to list groupings and keep pagination
  89. How to retrieve taxonomy terms of the current custom post?
  90. Change display wp post type to wp custom post type
  91. Dynamically change post_parent in every page load?
  92. Custom My account page and custom page for editing posts
  93. Listing all custom post types using a specific term on the said term’s template page, in groups
  94. How to Get The Taxonomy Term in Custom Post Type Loop Inside a Wp Query
  95. Get custom post type parent category
  96. display custom post type from register taxonomy
  97. Wp-theme Development
  98. Query custom post type and group by taxonomy
  99. How to develop Knowledge center in WordPress Website
  100. Dynamically count the number of custom post types associated to a custom taxonomy
tech