Selecting all posts from the children of a particular parent taxonomy

I think you’re way overcomplicating this. Use get_terms to get all taxonomy terms that are a child of a particular term via the child_of argument, then use that array with a WP_Query tax query, no custom SQL queries necessary.

Related Posts:

  1. Using wp_query is it possible to orderby taxonomy?
  2. “tax_query” parameter not working with WP_Query
  3. How do I exclude a custom taxonomy from the post loop
  4. Custom Taxonomy and Tax_Query
  5. Using WordPress to make a “Product Search” type navigation drilldown
  6. Custom Taxonomy not working with posts_per_page in new WP_query (pagination problem)
  7. display posts with same taxonomy term
  8. Including all terms in wordpress tax_query
  9. How to get first post in a category of a custom taxonomy
  10. Display one post from each term in a custom taxonomy [closed]
  11. Using tax_query creates a 1 = 0 or 1 = 1 in $wp_query->request
  12. wp_options table value
  13. search query within custom taxonomy term, post title and meta field
  14. wp query with multiple taxonomy?
  15. wp_query orderby title and meta key value (WP3.1)
  16. On Taxonomy Template page, want to add Post_Type
  17. Page queried instead of a custom taxonomy
  18. Custom WP_Query breaks default behaviour of viewing right post associated with tax-term!
  19. The next_posts_link() show me a aditional page in blank
  20. Help with a query not working with custom taxonomy
  21. Adding session variable and/or cookie based on user-selected input
  22. Excluding a custom taxonomy term breaks wp_get_post_terms
  23. Advanced Tax Query
  24. What are terms and taxonomy, how they related to post and how these three are stored in database?
  25. why do drafts return as part of wp_query?
  26. Improving WP_Query performance for multiple taxonomies
  27. WP Query with custom taxonomy
  28. how to search in custom fields & custom taxonomy for custom search
  29. How to Query Database for posts with certain Taxonomy Term
  30. WP_Query on custom taxonomy works fine but fails if run through wp_ajax_
  31. Advanced Query Logic With Multiple Taxonomies
  32. How do I Use Multiple Loops with WP_Query?
  33. cannot get multiple loops using tax_query
  34. Display all posts for taxonomy term across multiple custom post types
  35. WP_Query orderby and tax_query
  36. Hiding taxonomies with no children WP_Query & tax_query
  37. Can I use OR relation for one item when calling tax_query from WP_Query and use AND for the rest?
  38. Set tax_query conditionally with new WP_Query
  39. querying posts by custom taxonomy terms right from a querystring based URL
  40. Query custom taxonomy by term id?
  41. When filtering query on custom taxonomy; main menu dissapears
  42. Exclude taxonomy term from all loops, but having it on widget
  43. Why can’t I use an array of term slugs in WP_Query?
  44. wp_query not resetting, last post hanging
  45. Using WP_Query and Query_post for the loop?
  46. Problem with wordpress pagination
  47. How to do a particular wp_query taxonomy search
  48. Different Taxonomy Values for Each Post
  49. How to get product order by two custom taxonomy in wordpress
  50. Wp_query…a type of term a different div
  51. check if a taxnomy queried in $wp_query?
  52. Taxonomy.php how to show post only in current taxonomy with wp_query?
  53. WP_Query tax_query – Show results if child has parent X
  54. Query custom taxonomy for category including children
  55. Proper way to create taxonomy queries
  56. how to use tax_query to apply both terms or one if one is empty
  57. Get current page term title to use in WP_Query
  58. passing moree than one value of slugs in taxonomy using variable
  59. Looking for suggestions on creating simple database (Help!!)
  60. How do you move custom fields to custom taxonomies using WP Queries
  61. WordPress hiding posts without content on custom taxonomy query. How to solve?
  62. Run next query based on first query’s term
  63. Get the original menu item name string instead of the label
  64. How to use tax_query other than by slug or id or solve custom taxonomy tags conflicts with pre-existing tags?
  65. Order posts with custom taxonomy array
  66. How to permanently delete a taxonomy
  67. Getting grandchildren of a post with a specified custom taxonomy?
  68. Taxonomy Parameters in WP Query to get posts from two different taxonomies
  69. Custom Taxonomy + JQuery Tabs
  70. Advanced AND tax_query in sidebar with 2 taxonomies
  71. How to query posts that are not related to any term of a taxonomy?
  72. Using wp_query is it possible to orderby taxonomy?
  73. How to limit posts to 1 from each term with tax_query?
  74. Loop posts without any taxonomy
  75. get_posts assigned to a specific custom taxonomy term, and not the term’s children
  76. How can I get only parent terms?
  77. get_terms does not return any results for my custom taxonomy?
  78. How to display warning on post editor when trying to add new term to custom taxonomy?
  79. How do you remove a Category-style (hierarchical) taxonomy metabox?
  80. Is there a way to import terms into WordPress?
  81. get_terms() doesn’t return empty terms even though hide_empty is false
  82. Custom metabox for menu administration page?
  83. Remove Custom Taxonomy Base
  84. Exclude current post when getting related post on custom post type and taxonomy
  85. Display Posts of a Category in Alphabetical Order (Custom Post Type)
  86. Populating dropdown menu with hierarchical taxonomies
  87. Specifying a size when displaying an image associated with a taxonomy through ACF
  88. Taxonomy Archive: Display only one post per term from separate custom taxonomy
  89. How can marge these loop code?
  90. Query custom post type by custom taxonomy (category slug)
  91. Display related products based on 2 specific product attributes values in WooCommerce
  92. Widget Logic use with Custom Taxonomy
  93. limit post by a taxonomy in the admin
  94. Custom Category Walker with Image, Fallback to Most Recent Post in Category Image
  95. Taxonomy archive template that shows posts from more than one taxonomy
  96. Drop-down filter doesn’t retrieve custom taxonomies
  97. Why is the category item count not updating after assigning a category?
  98. Add custom taxonomy for post using cron job
  99. How to show one post content in another post content which has same terms?
  100. How to update WordPress custom SQL Select query for custom taxonomies so that syntax is correct?