Time : 15:28:24
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 ad.*,p.NAME from advertisementbooking ad inner join partydetail p on p.PARTYID=ad.PARTY where ADVERTISEMENTBOOKINGID=

Time : 11:44:10
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 : 11:43:53
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 : 10:35:57
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 'or (ss.fromDate!='' and ss.toDate is null))
  and ss.ISCANCEL is null and ab.ISI' at line 8
Raw SQL : select  p.PARTYCODE, p.NAME,co.ADD1,co.ADD2,co.ADD3,co.PINCODE,co.PHONE,cscc.NAME as cityname,cscd.NAME as districtname,cscc.CODE,cscs.shortname
,cscs.NAME as statename,cscco.NAME as countryname,
cp.NAME as cpname,cp.MOBILENO  from partydetail p   inner join subscription ss on ss.PARTY=p.PARTYID inner join advertisementbooking ab on ab.PARTY=p.PARTYID inner join suborders so on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID   inner join subscription sssp on sssp.PARTY=p.PARTYID  left outer join contact co on p.PARTYID=co.PARTY
left outer join contactperson cp on cp.PARTY=p.PARTYID
left outer join countrystatecity cscc on cscc.COUNTRYSTATECITYID=co.CITY
left outer join countrystatecity cscd on cscd.COUNTRYSTATECITYID=co.DISTRICT
left outer join countrystatecity cscs on cscs.COUNTRYSTATECITYID=co.STATE
left outer join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY   where 1=1  and (ss.renewalEditions>= or (ss.fromDate!='' and ss.toDate is null))
  and ss.ISCANCEL is null and ab.ISITCANCEL is null and so.MAGZINEEDITIONS=  and sssp.CUSTOMERNATURE=14  and co.addresstype=350  group by p.PARTYID order by cscc.CODE asc

Time : 10:32:55
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 'or (ss.fromDate!='' and ss.toDate is null))
  and ss.ISCANCEL is null and ab.ISI' at line 8
Raw SQL : select  p.PARTYCODE, p.NAME,co.ADD1,co.ADD2,co.ADD3,co.PINCODE,co.PHONE,cscc.NAME as cityname,cscd.NAME as districtname,cscc.CODE,cscs.shortname
,cscs.NAME as statename,cscco.NAME as countryname,
cp.NAME as cpname,cp.MOBILENO  from partydetail p   inner join subscription ss on ss.PARTY=p.PARTYID inner join advertisementbooking ab on ab.PARTY=p.PARTYID inner join suborders so on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID   inner join subscription sssp on sssp.PARTY=p.PARTYID  left outer join contact co on p.PARTYID=co.PARTY
left outer join contactperson cp on cp.PARTY=p.PARTYID
left outer join countrystatecity cscc on cscc.COUNTRYSTATECITYID=co.CITY
left outer join countrystatecity cscd on cscd.COUNTRYSTATECITYID=co.DISTRICT
left outer join countrystatecity cscs on cscs.COUNTRYSTATECITYID=co.STATE
left outer join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY   where 1=1  and (ss.renewalEditions>= or (ss.fromDate!='' and ss.toDate is null))
  and ss.ISCANCEL is null and ab.ISITCANCEL is null and so.MAGZINEEDITIONS=  and sssp.CUSTOMERNATURE=8  and co.addresstype=350  group by p.PARTYID order by cscc.CODE asc

Time : 08:23:40
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=