Error description: 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 Band Asc, YEAR(FromDate) Desc' at line 1 SQL: SELECT RecordID, Band, Date_Format(FromDate,'%d/%m/%Y') as FromDate, Date_Format(ToDate,'%d/%m/%Y') as ToDate, CONCAT('£', Rate) as Rate from SubscriptionRate where Band = order by Band Asc, YEAR(FromDate) Desc