Time : 16:15:06 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CITY' in 'order clause' Raw SQL : select count(PARTYID) as totalnew_parties from partydetail as p where NAME!='' and PARTYID in ( select PARTY from businesstype where BUSINESSTYPE=117) order by CITY desc