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 ') AND date_format(p.validno_do, '%Y%m%d') > '20140418' order by Field(p.Id,) l' at line 6