---

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, exemplares AS ex WHERE ed.idEdicao=ex.idEdicao AND ex.estado='STK' AND ed.idFormato = 'RB' ORDER BY ed.tituloEdicao ASC, ed.idColeccao ASC, ed.numOrdem ASC, ed.numVolume ASC

---