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 ') AS spCountTotal FROM cbcrecords WHERE rConfirmed = 'Y' AND YEAR(rDate) = YE...' at line 1