你可以写:
SELECT *
FROM wp_posts
JOIN wp_term_relationships
ON wp_term_relationships.object_id = wp_posts.ID
WHERE term_taxonomy_id = 80
AND wp_posts.id NOT IN
( SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id = 109
)
;