---

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 WHERE dataUltActualizacao='2022/08/02'ORDER BY ed.tituloEdicao ASC, ed.idColeccao ASC, ed.numOrdem ASC, ed.numVolume ASC

---