Time : 09:41:19
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 sub.ISCANCEL is null group by sub.SUBSCRIPTIONID
 ) a on p.PARTYID = a.p' at line 12
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 left outer join contactperson person on 
 person.PARTY = p.PARTYID 
 left outer join master ms on ms.MASTERID=person.greeting 
left outer join master mspg on mspg.MASTERID=p.GREETING
 left outer join contact c on p.PARTYID = 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 magzinedetail m inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL inner join subscription sub on
 sub.MAGZINENAME = m.MAGZINEDETAILID 
where 1=1 and 
 ((sub.renewalEditions is null and sub.toDate is null) or (sub.fromDate!='' and sub.toDate is null) or sub.renewalEditions>=  )
  and sub.ISCANCEL is null group by sub.SUBSCRIPTIONID
 ) a on p.PARTYID = 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 s.ISCANCEL is null and s.MAGZINEEDITIONS=  
group by ad.party

 ) ad on ad.partyid = p.PARTYID   where 1=1  and ifnull(a.partyid,ifnull(ad.partyid,0)) != 0 and c.addresstype=350 group by  p.partyid

Time : 09:37:04
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 sub.ISCANCEL is null group by sub.SUBSCRIPTIONID
 ) a on p.PARTYID = a.p' at line 12
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 left outer join contactperson person on 
 person.PARTY = p.PARTYID 
 left outer join master ms on ms.MASTERID=person.greeting 
left outer join master mspg on mspg.MASTERID=p.GREETING
 left outer join contact c on p.PARTYID = 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 magzinedetail m inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL inner join subscription sub on
 sub.MAGZINENAME = m.MAGZINEDETAILID 
where 1=1 and 
 ((sub.renewalEditions is null and sub.toDate is null) or (sub.fromDate!='' and sub.toDate is null) or sub.renewalEditions>=  )
  and sub.ISCANCEL is null group by sub.SUBSCRIPTIONID
 ) a on p.PARTYID = 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 s.ISCANCEL is null and s.MAGZINEEDITIONS=  
group by ad.party

 ) ad on ad.partyid = p.PARTYID   where 1=1  and ifnull(a.partyid,ifnull(ad.partyid,0)) != 0 and c.addresstype=350 group by  p.partyid

Time : 09:30:37
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 sub.ISCANCEL is null group by sub.SUBSCRIPTIONID
 ) a on p.PARTYID = a.p' at line 9
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 state,district.NAME districtname,country.name country,c.PINCODE,concat(c.STDCODE,c.PHONE) phoneno,person.NAME cpname,ifnull(person.MOBILENO,c.mobile) MOBILENO ,min(person.CONTACTPERSONID),p.partyid  from partydetail p left outer join contactperson person on 
 person.PARTY = p.PARTYID left outer join contact c on p.PARTYID = 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 magzinedetail m inner join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL inner join subscription sub on
 sub.MAGZINENAME = m.MAGZINEDETAILID 
where 1=1 and 
 ((sub.renewalEditions is null and sub.toDate is null) or (sub.fromDate!='' and sub.toDate is null) or sub.renewalEditions>=  )
  and sub.ISCANCEL is null group by sub.SUBSCRIPTIONID
 ) a on p.PARTYID = 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 s.ISCANCEL is null and s.MAGZINEEDITIONS=  
group by ad.party

 ) ad on ad.partyid = p.PARTYID   where 1=1  and ifnull(a.partyid,ifnull(ad.partyid,0)) != 0 and c.addresstype=350 group by  p.partyid