---

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='2021/04/01'AND ed.idFormato = 'LIV' ORDER BY ed.tituloEdicao ASC, ed.idColeccao ASC, ed.numOrdem ASC, ed.numVolume ASC

---