Time : 09:03:09
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.partyid' in 'field list'
Raw SQL : select distinct p.NAME,p.PARTYCODE,c.ADD1,c.ADD2,c.ADD3,concat(ifnull(c.add2,''),' ',ifnull(c.add3,'')) add2,csc.CODE,csc.NAME cityname,country.NAME countryname,cstate.NAME statename,cstate.shortname,district.NAME districtname,country.name country,c.PINCODE,concat(c.STDCODE,c.PHONE) PHONE,person.NAME cpname,ifnull(person.mobile_number,c.mobile) MOBILENO ,min(person.id),p.partyid, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting  from partydetail p 
 inner join subscription sub on sub.PARTY = p.id 
 inner join magzinedetail m on ifnull(sub.MAGZINENAME,1) = m.MAGZINEDETAILID
 inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL
 left outer join p_contactperson person on person.party_id = p.id 
left outer join p_dealsin dl on dl.party_id=p.id
left outer join p_master ms on ms.id=person.greeting 
left outer join p_master mspg on mspg.id=p.GREETING
inner join p_contact c on p.id = c.PARTY left outer join countrystatecity csc on  c.CITY = csc.COUNTRYSTATECITYID left outer join countrystatecity cstate on  c.state =cstate.countrystatecityid  left outer join countrystatecity district on  csc.PARENTID  = district.COUNTRYSTATECITYID left outer join countrystatecity country ON cstate.PARENTID =country.COUNTRYSTATECITYID    where 1=1   and dl.DEALSIN=0  and p.businesstype=0  and p.source=0  and c.STATE=0  and c.DISTRICT=0  and c.CITY=0  and c.addresstype=350
   
and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 297
and sub.fromDate <= me.DATEOFEDITIONS and ifnull(sub.toDate,me.DATEOFEDITIONS) >= me.DATEOFEDITIONS
and  (iscontinue = 1 or ifnull(sub.isEom,me.isEom) = me.isEom)


   and sub.mgznpostbyid=0  and sub.CUSTOMERNATURE=0 group by  p.partyid  order by cstate.CODE,district.CODE,csc.CODE asc

Time : 09:01:13
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'person.CONTACTPERSONID' in 'field list'
Raw SQL : select distinct p.NAME,p.PARTYCODE,c.ADD1,c.ADD2,c.ADD3,concat(ifnull(c.add2,''),' ',ifnull(c.add3,'')) add2,csc.CODE,csc.NAME cityname,country.NAME countryname,cstate.NAME statename,cstate.shortname,district.NAME districtname,country.name country,c.PINCODE,concat(c.STDCODE,c.PHONE) PHONE,person.NAME cpname,ifnull(person.mobile_number,c.mobile) MOBILENO ,min(person.CONTACTPERSONID),p.partyid, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting  from partydetail p 
 inner join subscription sub on sub.PARTY = p.id 
 inner join magzinedetail m on ifnull(sub.MAGZINENAME,1) = m.MAGZINEDETAILID
 inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL
 left outer join p_contactperson person on person.party_id = p.id 
left outer join p_dealsin dl on dl.party_id=p.id
left outer join p_master ms on ms.id=person.greeting 
left outer join p_master mspg on mspg.id=p.GREETING
inner join p_contact c on p.id = c.PARTY left outer join countrystatecity csc on  c.CITY = csc.COUNTRYSTATECITYID left outer join countrystatecity cstate on  c.state =cstate.countrystatecityid  left outer join countrystatecity district on  csc.PARENTID  = district.COUNTRYSTATECITYID left outer join countrystatecity country ON cstate.PARENTID =country.COUNTRYSTATECITYID    where 1=1   and dl.DEALSIN=0  and p.businesstype=0  and p.source=0  and c.STATE=0  and c.DISTRICT=0  and c.CITY=0  and c.addresstype=350
   
and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 297
and sub.fromDate <= me.DATEOFEDITIONS and ifnull(sub.toDate,me.DATEOFEDITIONS) >= me.DATEOFEDITIONS
and  (iscontinue = 1 or ifnull(sub.isEom,me.isEom) = me.isEom)


   and sub.mgznpostbyid=0  and sub.CUSTOMERNATURE=0 group by  p.partyid  order by cstate.CODE,district.CODE,csc.CODE asc

Time : 08:58:09
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'person.MOBILENO' in 'field list'
Raw SQL : select distinct p.NAME,p.PARTYCODE,c.ADD1,c.ADD2,c.ADD3,concat(ifnull(c.add2,''),' ',ifnull(c.add3,'')) add2,csc.CODE,csc.NAME cityname,country.NAME countryname,cstate.NAME statename,cstate.shortname,district.NAME districtname,country.name country,c.PINCODE,concat(c.STDCODE,c.PHONE) PHONE,person.NAME cpname,ifnull(person.MOBILENO,c.mobile) MOBILENO ,min(person.CONTACTPERSONID),p.partyid, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting  from partydetail p 
 inner join subscription sub on sub.PARTY = p.id 
 inner join magzinedetail m on ifnull(sub.MAGZINENAME,1) = m.MAGZINEDETAILID
 inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL
 left outer join p_contactperson person on person.party_id = p.id 
left outer join p_dealsin dl on dl.party_id=p.id
left outer join p_master ms on ms.id=person.greeting 
left outer join p_master mspg on mspg.id=p.GREETING
inner join p_contact c on p.id = c.PARTY left outer join countrystatecity csc on  c.CITY = csc.COUNTRYSTATECITYID left outer join countrystatecity cstate on  c.state =cstate.countrystatecityid  left outer join countrystatecity district on  csc.PARENTID  = district.COUNTRYSTATECITYID left outer join countrystatecity country ON cstate.PARENTID =country.COUNTRYSTATECITYID    where 1=1   and dl.DEALSIN=0  and p.businesstype=0  and p.source=0  and c.STATE=0  and c.DISTRICT=0  and c.CITY=0  and c.addresstype=350
   
and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 297
and sub.fromDate <= me.DATEOFEDITIONS and ifnull(sub.toDate,me.DATEOFEDITIONS) >= me.DATEOFEDITIONS
and  (iscontinue = 1 or ifnull(sub.isEom,me.isEom) = me.isEom)


   and sub.mgznpostbyid=0  and sub.CUSTOMERNATURE=0 group by  p.partyid  order by cstate.CODE,district.CODE,csc.CODE asc

Time : 08:54:21
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 297
and sub.fromDate <= ...' at line 11
Raw SQL : select distinct p.NAME,p.PARTYCODE,c.ADD1,c.ADD2,c.ADD3,concat(ifnull(c.add2,''),' ',ifnull(c.add3,'')) add2,csc.CODE,csc.NAME cityname,country.NAME countryname,cstate.NAME statename,cstate.shortname,district.NAME districtname,country.name country,c.PINCODE,concat(c.STDCODE,c.PHONE) PHONE,person.NAME cpname,ifnull(person.MOBILENO,c.mobile) MOBILENO ,min(person.CONTACTPERSONID),p.partyid, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting  from partydetail p 
 inner join subscription sub on sub.PARTY = p.id 
 inner join magzinedetail m on ifnull(sub.MAGZINENAME,1) = m.MAGZINEDETAILID
 inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL
 left outer join p_contactperson person on person.party_id = p.id 
left outer join p_dealsin dl on dl.party_id=p.id
left outer join p_master ms on ms.id=person.greeting 
left outer join p_master mspg on mspg.id=p.GREETING
inner join p_contact c on p.id = c.PARTY left outer join countrystatecity csc on  c.CITY = csc.COUNTRYSTATECITYID left outer join countrystatecity cstate on  c.state =cstate.countrystatecityid  left outer join countrystatecity district on  csc.PARENTID  = district.COUNTRYSTATECITYID left outer join countrystatecity country ON cstate.PARENTID =country.COUNTRYSTATECITYID    where 1=1   and dl.DEALSIN=0  and p.businesstype=0  and p.source=0  and c.DISTRICT=0  and c.CITY=0  and c.addresstype=350STATE=0statename=
   
and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 297
and sub.fromDate <= me.DATEOFEDITIONS and ifnull(sub.toDate,me.DATEOFEDITIONS) >= me.DATEOFEDITIONS
and  (iscontinue = 1 or ifnull(sub.isEom,me.isEom) = me.isEom)


   and sub.mgznpostbyid=0  and sub.CUSTOMERNATURE=0 group by  p.partyid  order by cstate.CODE,district.CODE,csc.CODE asc

Time : 08:32:22
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'parijakz_livecom.master' doesn't exist
Raw SQL : select MASTERID,VALUE from master where MASTERTYPE=6

Time : 08:17:19
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'parijakz_livecom.master' doesn't exist
Raw SQL : select MASTERID,VALUE from master where MASTERTYPE=6