plaha

SELECT post_id, GROUP_CONCAT(tag_id) as gr_tag FROM table GROUP BY post_id HAVING gr = '27,28,29'

В случае неупорядоченности — ORDER BY post_id, tag_id