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 's-Festival' AND DATE_FORMAT(e1.datefrom, '%Y/%m/%d') BETW' at line 7