Изменения

SELECT tp_tag1 FROM (SELECT DISTINCT t1.tag tp_tag1, t2.tag tp_tag2 FROM tag_image t1 LEFT JOIN tag_image t2 ON t2.ti_image=t1.ti_image AND t2.ti_tag!=t1.ti_tag) tag_pair LEFT JOIN tag_image h1 ON h1.ti_tag IN (tp_tag1, tp_tag2) LEFT JOIN tag_image n1 ON n1.ti_image=h1.ti_image AND n1.ti_tag != h1.ti_tag AND n1.ti_tag IN (tp_tag1, tp_tag2) WHERE n1.ti_tag IS NULL)</code-sql>