Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY instrumentchord.CT_ID' at line 1SELECT DISTINCT root.ROOT_ID, root.ROOT_NAME, chordtype.CT_ASCII, chordtype.CT_ASCII_ALT, instrumentchord.CT_ID, instrumentchord.IC_CHARTFILE FROM root INNER JOIN instrumentchord ON root.ROOT_NAME LIKE instrumentchord.ROOT_NAME INNER JOIN chordtype ON instrumentchord.CT_ID LIKE chordtype.CT_ID WHERE root.ROOT_ID = ORDER BY instrumentchord.CT_ID