我想获得所有具有特定分类法术语a和特定分类法术语B的帖子。
以下是我正在运行的查询:
SELECT wp_posts.ID, wp_posts.post_title
FROM wp_posts
INNER JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id
INNER JOIN wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
INNER JOIN wp_terms ON wp_term_taxonomy.term_id = wp_terms.term_id
WHERE (wp_term_taxonomy.taxonomy = \'category\' AND wp_terms.slug in (\'uncategorized\'))
AND (wp_term_taxonomy.taxonomy = \'post_tag\' AND wp_terms.slug in (\'red\'))
ORDER BY ID DESC
尽管查询了具有“未分类”类别和“红色”标记的帖子的DB/WP安装,但仍返回0个结果