Time : 03:39:50 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 ipaddress from p_customers where customerid= Time : 03:39:44 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 ipaddress from p_customers where customerid= Time : 03:39:37 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 ipaddress from p_customers where customerid= Time : 02:43:41 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 'master ms on ms.MASTERID=co.addresstype left outer master mgreeting on mgreeting' at line 4 Raw SQL : select p.NAME,cp.NAME as contactpersonname,co.MOBILE,co.MOBILENO,co.PHONE,cp.MOBILENO as CPMOBILENO,co.ADD1,co.ADD2,co.ADD3,co.PINCODE,ms.VALUE as addtype, csc.NAME as cityname, ssc.NAME as statename,cosc.NAME as countryname,dsc.NAME as districtname,mgreeting.value as greetingvalue from partydetail p inner join contact co on co.PARTY=p.PARTYID left outer join contactperson cp on cp.PARTY=p.PARTYID left outer master ms on ms.MASTERID=co.addresstype left outer master mgreeting on mgreeting.MASTERID=cp.greeting left outer countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY left outer join countrystatecity dsc on dsc.COUNTRYSTATECITYID=co.DISTRICT left outer countrystatecity ssc on ssc.COUNTRYSTATECITYID=co.STATE left outer countrystatecity cosc on cosc.COUNTRYSTATECITYID=co.COUNTRY where p.PARTYID=3224 and co.addresstype=350 and cp.type in (353,352) group by co.CONTACTID Time : 02:42:44 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 'master ms on ms.MASTERID=co.addresstype left outer master mgreeting on mgreeting' at line 4 Raw SQL : select p.NAME,cp.NAME as contactpersonname,co.MOBILE,co.MOBILENO,co.PHONE,cp.MOBILENO as CPMOBILENO,co.ADD1,co.ADD2,co.ADD3,co.PINCODE,ms.VALUE as addtype, csc.NAME as cityname, ssc.NAME as statename,cosc.NAME as countryname,dsc.NAME as districtname,mgreeting.value as greetingvalue from partydetail p inner join contact co on co.PARTY=p.PARTYID left outer join contactperson cp on cp.PARTY=p.PARTYID left outer master ms on ms.MASTERID=co.addresstype left outer master mgreeting on mgreeting.MASTERID=cp.greeting left outer countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY left outer join countrystatecity dsc on dsc.COUNTRYSTATECITYID=co.DISTRICT left outer countrystatecity ssc on ssc.COUNTRYSTATECITYID=co.STATE left outer countrystatecity cosc on cosc.COUNTRYSTATECITYID=co.COUNTRY where p.PARTYID=3224 and co.addresstype=350 and cp.type in (353,352) group by co.CONTACTID