Get Tags specific to Category using WooCommerce plugin

Finally solve the problem:

t1.taxonomy = 'product_cat' AND p1.post_status="publish" AND terms1.term_id IN (".$args['categories'].") AND
t2.taxonomy = 'product_tag' AND p2.post_status="publish"

In the functions.php

t1.taxonomy = 'category' AND p1.post_status="publish" AND terms1.term_id IN (".$args['categories'].") AND t2.taxonomy = 'post_tag' AND p2.post_status="publish"

rename category to product_cat, and post_tag with product_tag.

Related Posts:

  1. List products from current category
  2. Is There a Difference Between Taxonomies and Categories?
  3. What is the difference between a “tag” and a “category”?
  4. WooCommerce: List All Categories
  5. Control term order on a per-post basis
  6. get all tags from category
  7. 404 Error On Category and Tags Pages
  8. Checklist of selected categories
  9. Rewrite URL with category and tag combined using WP_Rewrite
  10. How to tax query X number of posts related by tag first, then by category if not enough in tag-related
  11. Woocommerce product categories order [closed]
  12. Category and tag with same name
  13. In the tag archive – display count of posts for each category they belong to
  14. Automated adding of one tag to all the posts in a category
  15. Exclude most recent posts from specific category in wp_query()
  16. When using get_categories or similar, is it possible to filter results that contain certain Tags as well?
  17. WooCommerce – Display product child categories from specific parent
  18. Deleting All tags except categories Wp database
  19. Search by word, category, tag, author
  20. How to filter archives both by category and tag?
  21. Get tags specific category
  22. Woocommerce – Get product category 2nd level category
  23. Category archive page – loop through posts of certain tag (with pagination) – pre_get_posts
  24. Category vs Tag vs Table
  25. Help with multiple dropdown tags search
  26. Custom WP_Query for current category (in category.php)?
  27. Retrieve all posts within tag OR category?
  28. How to find the number of Tags a post has?
  29. How to not treat categories as tags in feeds
  30. How to customize tag and category post listings to show introductory content?
  31. Are Category or Tag Archive Pages Possible?
  32. Random post + categories + tags
  33. Search Posts / Pages with multiple options?
  34. How get permalink for the current category or tag?
  35. Display tags from specific category in select fields
  36. Offline WordPress Application
  37. Find out which user created a category or tag?
  38. RSS/XML of all Categories and/or Tags
  39. Show category images on single product page and product overview page
  40. woocommerce product category tabs [closed]
  41. How to make 2 tag feeds show up on 1 page?
  42. Different templates for different category tags
  43. Get link which associated with a specific category and tag
  44. How to get related tags based on a category?
  45. Needing a snippet for listing category specific tags
  46. How to list categories within tags?
  47. How to “group” (categorize) the Pages together?
  48. Is There a Difference Between Taxonomies and Categories?
  49. Use Tag input metabox style for Categories
  50. menu using category and tags
  51. WordPress “Categories to tags converter” not working. Pointing to import.php instead
  52. Custom SQL Query: Get all posts with category id and a concated list of tags on each post
  53. limit a list of tags to one category [closed]
  54. Have multiple category queries from the URL been fixed yet?
  55. Related Tags not in category
  56. Show button only for certain Woocommerce Product Categories
  57. scaleability of tags
  58. Is there a reason I cannot get the current category in a loop?
  59. How do I add a tag slug to a category URL to filter posts?
  60. Show the amount of posts in a tag in a specific category has
  61. Display all product tags associated with a specific product category
  62. How replace individual elements in the RSS feed with a single string
  63. Adding a H1 Tag to Post Tags automatically, but hide the tag? (Same for Category)
  64. Tags Instead of Category
  65. Conditional category & tag statement
  66. Include either name or slug in the include parameter using wp_list_categories?
  67. How can I filter posts by tag on the fly
  68. How to display product categories and number of sales on WooCommerce
  69. Filter categories/tags to display in multiple metaboxes for selection in back-end
  70. Editing Loop So It Targets Specific Tags?
  71. How can I include custom category and tag base in template files?
  72. Pretty URLs with Categories and Tags
  73. Autolinking keywords in text with tags
  74. Maintaining a separate posts page for certain categories and don’t show those on home page
  75. Are tags different than categories?
  76. Custom menu with categories and tags
  77. Show Posts via cat+cat in URL that are in both Categories doesn’t work
  78. Display all categories but only if they have posts in them that have a specific tag assigned
  79. Help to display the current categories and tags of a post
  80. Hide specific category tag on single post page
  81. Filtering posts in category by tag URL
  82. echo $category[0]-> cat_name; shows only one category name
  83. How to show entries related to main category
  84. When creating category, it creates automatically tag, or, when creating tag, it creates automatically category in same name
  85. Using heirarchial tags or Custom taxonomies
  86. Re-coding category-template.php to go to custom URL
  87. Category and tag urls return 404 error
  88. How to echo Tags and Categories as plain text
  89. Tag Menu items based on their categories
  90. Hide category name using mod_rewrite
  91. How to exclude category and post_tag taxonomy while displaying custom taxonomy?
  92. 404 error when i try to search by category or by tag
  93. A simple question regarding tags and categories
  94. Display related posts with same category or same tag return blank
  95. htaccess redirect for all categories converted to tags now showing 404
  96. Loops in category description
  97. How to create a category or tag available exclusively to the admins and not to the users?
  98. altering theme – content generated by PAGES not PORTFOLIO
  99. Search tag within category
  100. In my wordpress admin panel Suddenly The Category, tag and featured Image Option are not showing