Time : 13:13:03 SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'EMAIL' in where clause is ambiguous Raw SQL : select count(a.PARTYID) as totalnew_contact from partydetail a,(select distinct partydetail.PARTYID from partydetail,contact,productmapping where NAME!='' and NAME is not NULL and CITY in (1385) and chennalid in(5,16) and productid in(46) and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID =productmapping.partyid and LOWER(EMAIL) like :EMAIL) as b where a.PARTYID = b.PARTYID Time : 10:53:22 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID= Time : 10:32:52 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID= Time : 10:05:04 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID= Time : 09:15:49 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select productid,productName,category from product where category= Time : 06:46:47 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select productid,productName,category from product where category= Time : 06:46:32 SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1 Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=