SQL Error [1064]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY COALESCE(productClass2ManyToMany.classID1,999),
p' at line 8
Offending SQL:
SELECT
productClass2.*,
productClass2ManyToMany.*
FROM productClass2ManyToMany
LEFT JOIN productClass2
ON productClass2ManyToMany.classID2 = productClass2.id
WHERE
ORDER BY COALESCE(productClass2ManyToMany.classID1,999),
productClass2ManyToMany.classID1 ASC,
COALESCE(productClass2ManyToMany.sort,999),
productClass2ManyToMany.sort ASC,
productClass2ManyToMany.addDate DESC,
productClass2ManyToMany.id DESC