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 '= 0 and publish=1  and calendar.date >=  CURDATE()     order by calendar.date as' at line 2