SQL查询INNER JOIN或LEFT JOIN希望从Wordpress中的特定类别中选择帖子，但不选择其他特定类别的帖子

SELECT posts.*
FROM posts
INNER JOIN term_relationships ON posts.ID = term_relationships.object_id
INNER JOIN term_taxonomy ON term_relationships.term_taxonomy_id = term_taxonomy.term_taxonomy_id
INNER JOIN terms ON term_taxonomy.term_id = terms.term_id
WHERE term_taxonomy.taxonomy = 'category'
AND terms.name = '特定类别'

SELECT posts.*
FROM posts
LEFT JOIN term_relationships ON posts.ID = term_relationships.object_id
LEFT JOIN term_taxonomy ON term_relationships.term_taxonomy_id = term_taxonomy.term_taxonomy_id
LEFT JOIN terms ON term_taxonomy.term_id = terms.term_id
WHERE term_taxonomy.taxonomy = 'category'
AND (terms.name = '特定类别' OR terms.name IS NULL)