这个不是很简单吗?select distinct t.object_id XXX_terms as t where t.term_taxonomy_id in ('67','69','72');distinct 去除重复的数据结果 就是一条 67 的数据了
SELECT * FROM TT A WHERE EXISTS(SELECT 1 FROM TT WHERE A.object_id=object_id AND term_taxonomy_id=67) AND EXISTS(SELECT 1 FROM TT WHERE A.object_id=object_id AND term_taxonomy_id=72) AND EXISTS(SELECT 1 FROM TT WHERE A.object_id=object_id AND term_taxonomy_id=69)
AND
EXISTS(SELECT 1 FROM TT WHERE A.object_id=object_id AND term_taxonomy_id=72)
AND
EXISTS(SELECT 1 FROM TT WHERE A.object_id=object_id AND term_taxonomy_id=69)