Time : 14:09:05 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 '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 PARTY=8142 and PARTYCODE= order by NAME asc Time : 11:46:28 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 '' at line 1 Raw SQL : select ISITCOMPLEMENTARY,NOOFISSUES from customernature where CUSTOMERNATUREID=