---

ERRO SQL: Expression #1 of ORDER BY clause is not in SELECT list, references column 'alfarrabista.ed.tituloEdicao' which is not in SELECT list; this is incompatible with DISTINCT

SELECT distinct ed.idEdicao FROM edicoes AS ed, tematicas AS t WHERE ed.idTematica=t.idTematica AND ed.idTematica='36' ORDER BY ed.tituloEdicao ASC, ed.idColeccao ASC, ed.numOrdem ASC, ed.numVolume ASC

---