---

SELECT t.id AS id, t.titulo, ot.id_tag FROM Tags t LEFT JOIN Obras_x_Tags ot ON ot.id_obra=307 AND t.id=ot.id_tag WHERE t.ativo=1 AND ot.id_obra=307 GROUP BY ot.id_tag ORDER BY t.titulo

---