Time : 11:09:59
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:09: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 : 09:25:08
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ss.ISCANCEL' in 'where clause'
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 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 co.addresstype=350 and ss.ISCANCEL is null group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 09:23:11
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ss.ISCANCEL' in 'where clause'
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 and ss.ISCANCEL is null group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 09:19:26
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ss.ISCANCEL' in 'where clause'
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 and ss.ISCANCEL is null group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 09:17:29
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ISCANCEL' in 'where clause'
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 and ISCANCEL is null group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 09:16:16
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ISCANCEL' in 'where clause'
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 and ISCANCEL is null group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 09:15:34
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ISCANCEL' in 'where clause'
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 and ISCANCEL is null group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 09:13:57
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ISCANCEL' in 'where clause'
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 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 co.addresstype=350 and ISCANCEL is null group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 09:09:33
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ab.ISCANCEL' in 'where clause'
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 advertisementbooking ab on ab.PARTY=p.PARTYID left outer join suborders so on so.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID 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 ab.ISCANCEL is null and so.MAGZINEEDITIONS=151 and ab.mgznpostbyid=1  and co.addresstype=350 group by  p.PARTYID order by cscs.CODE,cscc.CODE asc

Time : 03:39:41
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ps' in 'where clause'
Raw SQL : select count(DISPATCHREGISTERID) as totalnew_parties from dispatchregister as ab,partydetail as p,(select PARTY as prty,CITY,addresstype from contact group by PARTY) as c where p.PARTYID=ab.FIRMNAME and p.PARTYID=c.prty  and docketNo=ps order by DISPATCHDATE DESC