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 a.isDeleted=0 and a.isPublished=1 order by a.orderNo DESC, a.createdOn DESC ' at line 1