No se formular la sentencia mysql

[mblascog]

Lo he revertido, y parece funcionar. Gracias

Código MySQL:

SELECT MAX(s.datavenciment), c.client, t.concepte, e.estat, e.color FROM subtasques AS s
LEFT JOIN tasques AS t ON (s.idtasca = t.id)
LEFT JOIN clients AS c ON (t.idclient = c.id)
LEFT JOIN estat AS e ON (s.idestat = e.id)
GROUP BY s.idtasca DESC
ORDER BY c.client