Time : 07:46:29
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 'PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-09-03 13:16:29' where SUBORDERSID=16428' at line 1
Raw SQL : update suborders set TARRIF='12',AMOUNT='1200',discount='58.00',discountamount='696.00',netamount='504.00',MAGZINEEDITIONS='156',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-09-03 13:16:29' where SUBORDERSID=16428

Time : 07:36:17
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 ')
  and ss.ISCANCEL is null   and ss.mgznpostbyid=1  and co.addresstype=350 grou' at line 10
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, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting  from partydetail p   inner join subscription ss on ss.PARTY=p.PARTYID  inner 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
inner join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY
left outer join master ms on ms.MASTERID=cp.greeting 
left outer join master mspg on mspg.MASTERID=p.GREETING   where 1=1   and ((ss.renewalEditions is null and ss.toDate is null) or (ss.fromDate!='' and ss.toDate is null) or ss.renewalEditions>=)
  and ss.ISCANCEL is null   and ss.mgznpostbyid=1  and co.addresstype=350 group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 07:36:15
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 ')
  and ss.ISCANCEL is null   and ss.mgznpostbyid=1  and co.addresstype=350 grou' at line 10
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, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting  from partydetail p   inner join subscription ss on ss.PARTY=p.PARTYID  inner 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
inner join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY
left outer join master ms on ms.MASTERID=cp.greeting 
left outer join master mspg on mspg.MASTERID=p.GREETING   where 1=1   and ((ss.renewalEditions is null and ss.toDate is null) or (ss.fromDate!='' and ss.toDate is null) or ss.renewalEditions>=)
  and ss.ISCANCEL is null   and ss.mgznpostbyid=1  and co.addresstype=350 group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 07:36:14
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 ')
  and ss.ISCANCEL is null   and ss.mgznpostbyid=1  and co.addresstype=350 grou' at line 10
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, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting  from partydetail p   inner join subscription ss on ss.PARTY=p.PARTYID  inner 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
inner join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY
left outer join master ms on ms.MASTERID=cp.greeting 
left outer join master mspg on mspg.MASTERID=p.GREETING   where 1=1   and ((ss.renewalEditions is null and ss.toDate is null) or (ss.fromDate!='' and ss.toDate is null) or ss.renewalEditions>=)
  and ss.ISCANCEL is null   and ss.mgznpostbyid=1  and co.addresstype=350 group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 07:35: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 'order by cscs.CODE,cscc.CODE asc' 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 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 co.addresstype=350  group by  order by cscs.CODE,cscc.CODE asc

Time : 07:34:36
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 ')
  and ss.ISCANCEL is null   and ss.mgznpostbyid=1  and co.addresstype=350 grou' at line 10
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, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting  from partydetail p   inner join subscription ss on ss.PARTY=p.PARTYID  inner 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
inner join countrystatecity cscco on cscco.COUNTRYSTATECITYID=co.COUNTRY
left outer join master ms on ms.MASTERID=cp.greeting 
left outer join master mspg on mspg.MASTERID=p.GREETING   where 1=1   and ((ss.renewalEditions is null and ss.toDate is null) or (ss.fromDate!='' and ss.toDate is null) or ss.renewalEditions>=)
  and ss.ISCANCEL is null   and ss.mgznpostbyid=1  and co.addresstype=350 group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 05:48:17
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:15:26
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 'PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-09-03 07:45:26' where SUBORDERSID=16428' at line 1
Raw SQL : update suborders set TARRIF='12',AMOUNT='1200',discount='58.00',discountamount='696.00',netamount='504.00',MAGZINEEDITIONS='156',ISPAGEFIX=,PAGENO=,DUMMYPAGENO=,UPDATEDDATE='2017-09-03 07:45:26' where SUBORDERSID=16428

Time : 02:08:56
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 ')
  and ss.ISCANCEL is null   and co.STATE=30  and co.addresstype=350 group by  ' 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 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 is null and ss.toDate is null) or (ss.fromDate!='' and ss.toDate is null) or ss.renewalEditions>=)
  and ss.ISCANCEL is null   and co.STATE=30  and co.addresstype=350 group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 02:08:34
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 ')
  and ss.ISCANCEL is null   and co.STATE=30  and co.addresstype=350 group by  ' 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 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 is null and ss.toDate is null) or (ss.fromDate!='' and ss.toDate is null) or ss.renewalEditions>=)
  and ss.ISCANCEL is null   and co.STATE=30  and co.addresstype=350 group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 01:59:35
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 ')
  and ss.ISCANCEL is null   and co.STATE=30  and co.addresstype=350 group by  ' 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 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 is null and ss.toDate is null) or (ss.fromDate!='' and ss.toDate is null) or ss.renewalEditions>=)
  and ss.ISCANCEL is null   and co.STATE=30  and co.addresstype=350 group by  p.PARTYID order by cscs.CODE,cscc.CODE asc