Time : 10:22:58
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 'order by NAME asc' at line 1
Raw SQL : select count(SUBSCRIPTIONID) as totalnew_parties  from partydetail as p,subscription as s,(select PARTY as prty,CITY,DISTRICT,STATE,COUNTRY,addresstype from contact) as c  where p.PARTYID=s.PARTY and s.PARTY=c.prty and c.addresstype=s.addresstype  and PARTYCODE=298+ order by NAME asc