按类别名称获取WooCommerce产品的MySQL查询

SELECT * FROM wp_posts WHERE post_type = 'product' AND post_status = 'publish';

SELECT * FROM wp_term_relationships AS rel
INNER JOIN wp_term_taxonomy AS tax ON tax.term_taxonomy_id = rel.term_taxonomy_id
INNER JOIN wp_terms AS term ON term.term_id = tax.term_id
INNER JOIN wp_posts AS prod ON prod.ID = rel.object_id
WHERE tax.taxonomy = 'product_cat' AND term.name = '产品类别名称' AND prod.post_status = 'publish' AND prod.post_type = 'product';

SELECT * FROM wp_term_relationships AS rel
INNER JOIN wp_term_taxonomy AS tax ON tax.term_taxonomy_id = rel.term_taxonomy_id
INNER JOIN wp_terms AS term ON term.term_id = tax.term_id
INNER JOIN wp_posts AS prod ON prod.ID = rel.object_id
WHERE tax.taxonomy = 'product_tag' AND term.name = '产品标签名称' AND prod.post_status = 'publish' AND prod.post_type = 'product';