Time : 08:00:42 SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION parijakz_livecom.2and does not exist Raw SQL : select distinct p.NAME, p.PARTYCODE,c.ADD1,c.ADD2,c.ADD3,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.id, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting from partydetail p 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 left outer 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 left outer join ( select sub.PARTY partyid from partydetail p inner join subscription sub on sub.PARTY = p.id inner join magzinedetail m on m.MAGZINEDETAILID = ifnull(sub.MAGZINENAME,1) inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL where 1=1 and sub.mgznpostbyid=2and ((if(sub.isContinue=0, day(sub.fromDate)='15', ''))=1 or sub.isContinue=1) and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 305 and (('2023-12-15 00:00:00' between sub.fromDate AND sub.toDate) or (sub.fromDate!='' and sub.toDate is null)) and sub.ISCANCEL is null group by sub.SUBSCRIPTIONID ) a on p.id = a.partyid left outer join ( select ad.PARTY partyid from magzinedetail m inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL inner join suborders s on s.MAGZINEEDITIONS = me.MAGZINEEDITIONSID inner join advertisementbooking ad on ad.ADVERTISEMENTBOOKINGID = s.ADVERTISEBOOKINGID where 1=1 and ad.mgznpostbyid=2 and s.ISCANCEL is null and s.MAGZINEEDITIONS= '305' group by ad.party ) ad on ad.partyid = p.id where 1=1 and c.addresstype=350 and ifnull(a.partyid,ifnull(ad.partyid,0)) != 0 and c.addresstype=350 group by p.id order by cstate.CODE,district.CODE,csc.CODE asc Time : 07:16:31 SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION parijakz_livecom.2and does not exist Raw SQL : select distinct p.NAME, p.PARTYCODE,c.ADD1,c.ADD2,c.ADD3,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.id, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting from partydetail p 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 left outer 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 left outer join ( select sub.PARTY partyid from partydetail p inner join subscription sub on sub.PARTY = p.id inner join magzinedetail m on m.MAGZINEDETAILID = ifnull(sub.MAGZINENAME,1) inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL where 1=1 and sub.mgznpostbyid=2and ((if(sub.isContinue=0, day(sub.fromDate)='15', ''))=1 or sub.isContinue=1) and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 305 and (('2023-12-15 00:00:00' between sub.fromDate AND sub.toDate) or (sub.fromDate!='' and sub.toDate is null)) and sub.ISCANCEL is null group by sub.SUBSCRIPTIONID ) a on p.id = a.partyid left outer join ( select ad.PARTY partyid from magzinedetail m inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL inner join suborders s on s.MAGZINEEDITIONS = me.MAGZINEEDITIONSID inner join advertisementbooking ad on ad.ADVERTISEMENTBOOKINGID = s.ADVERTISEBOOKINGID where 1=1 and ad.mgznpostbyid=2 and s.ISCANCEL is null and s.MAGZINEEDITIONS= '305' group by ad.party ) ad on ad.partyid = p.id where 1=1 and c.addresstype=350 and ifnull(a.partyid,ifnull(ad.partyid,0)) != 0 and c.addresstype=350 group by p.id order by cstate.CODE,district.CODE,csc.CODE asc Time : 07:13:07 SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION parijakz_livecom.2and does not exist Raw SQL : select distinct p.NAME, p.PARTYCODE,c.ADD1,c.ADD2,c.ADD3,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.id, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting from partydetail p 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 left outer 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 left outer join ( select sub.PARTY partyid from partydetail p inner join subscription sub on sub.PARTY = p.id inner join magzinedetail m on m.MAGZINEDETAILID = ifnull(sub.MAGZINENAME,1) inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL where 1=1 and sub.mgznpostbyid=2and ((if(sub.isContinue=0, day(sub.fromDate)='15', ''))=1 or sub.isContinue=1) and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 305 and (('2023-12-15 00:00:00' between sub.fromDate AND sub.toDate) or (sub.fromDate!='' and sub.toDate is null)) and sub.ISCANCEL is null group by sub.SUBSCRIPTIONID ) a on p.id = a.partyid left outer join ( select ad.PARTY partyid from magzinedetail m inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL inner join suborders s on s.MAGZINEEDITIONS = me.MAGZINEEDITIONSID inner join advertisementbooking ad on ad.ADVERTISEMENTBOOKINGID = s.ADVERTISEBOOKINGID where 1=1 and ad.mgznpostbyid=2 and s.ISCANCEL is null and s.MAGZINEEDITIONS= '305' group by ad.party ) ad on ad.partyid = p.id where 1=1 and c.addresstype=350 and ifnull(a.partyid,ifnull(ad.partyid,0)) != 0 and c.addresstype=350 group by p.id order by cstate.CODE,district.CODE,csc.CODE asc Time : 07:12:37 SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION parijakz_livecom.2and does not exist Raw SQL : select distinct p.NAME, p.PARTYCODE,c.ADD1,c.ADD2,c.ADD3,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.id, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting from partydetail p 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 left outer 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 left outer join ( select sub.PARTY partyid from partydetail p inner join subscription sub on sub.PARTY = p.id inner join magzinedetail m on m.MAGZINEDETAILID = ifnull(sub.MAGZINENAME,1) inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL where 1=1 and sub.mgznpostbyid=2and ((if(sub.isContinue=0, day(sub.fromDate)='15', ''))=1 or sub.isContinue=1) and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 305 and (('2023-12-15 00:00:00' between sub.fromDate AND sub.toDate) or (sub.fromDate!='' and sub.toDate is null)) and sub.ISCANCEL is null group by sub.SUBSCRIPTIONID ) a on p.id = a.partyid left outer join ( select ad.PARTY partyid from magzinedetail m inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL inner join suborders s on s.MAGZINEEDITIONS = me.MAGZINEEDITIONSID inner join advertisementbooking ad on ad.ADVERTISEMENTBOOKINGID = s.ADVERTISEBOOKINGID where 1=1 and ad.mgznpostbyid=2 and s.ISCANCEL is null and s.MAGZINEEDITIONS= '305' group by ad.party ) ad on ad.partyid = p.id where 1=1 and c.addresstype=350 and ifnull(a.partyid,ifnull(ad.partyid,0)) != 0 and c.addresstype=350 group by p.id order by cstate.CODE,district.CODE,csc.CODE asc Time : 07:11:28 SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION parijakz_livecom.2and does not exist Raw SQL : select distinct p.NAME, p.PARTYCODE,c.ADD1,c.ADD2,c.ADD3,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.id, ms.VALUE as cpgreeting,mspg.VALUE as partygreeting from partydetail p 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 left outer 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 left outer join ( select sub.PARTY partyid from partydetail p inner join subscription sub on sub.PARTY = p.id inner join magzinedetail m on m.MAGZINEDETAILID = ifnull(sub.MAGZINENAME,1) inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL where 1=1 and sub.mgznpostbyid=2and ((if(sub.isContinue=0, day(sub.fromDate)='15', ''))=1 or sub.isContinue=1) and ifnull(iscancel,0) =0 and me.MAGZINEEDITIONSID = 305 and (('2023-12-15 00:00:00' between sub.fromDate AND sub.toDate) or (sub.fromDate!='' and sub.toDate is null)) and sub.ISCANCEL is null group by sub.SUBSCRIPTIONID ) a on p.id = a.partyid left outer join ( select ad.PARTY partyid from magzinedetail m inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL inner join suborders s on s.MAGZINEEDITIONS = me.MAGZINEEDITIONSID inner join advertisementbooking ad on ad.ADVERTISEMENTBOOKINGID = s.ADVERTISEBOOKINGID where 1=1 and ad.mgznpostbyid=2 and s.ISCANCEL is null and s.MAGZINEEDITIONS= '305' group by ad.party ) ad on ad.partyid = p.id where 1=1 and c.addresstype=350 and ifnull(a.partyid,ifnull(ad.partyid,0)) != 0 and c.addresstype=350 group by p.id order by cstate.CODE,district.CODE,csc.CODE asc