Time : 09:21:01
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query
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 
 inner join subscription sub on sub.PARTY = p.PARTYID 
  left outer join magzinedetail m on m.MAGZINEDETAILID = sub.MAGZINENAME
  left outer join magzineeditions me on m.MAGZINEDETAILID = me.MAGZINEDETAIL  left outer join contactperson person on person.PARTY = p.PARTYID 
left outer join dealsin dl on dl.PARTY=p.PARTYID
inner 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    where 1=1   and c.addresstype=350 group by  p.partyid  order by cstate.CODE,district.CODE,csc.CODE asc