Time : 11:04:22
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 '['PARTYID']' at line 1
Raw SQL : select csc.NAME as cityname from contact co inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY where co.PARTY=Array['PARTYID']

Time : 09:45:17
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'COLOR' in 'order clause'
Raw SQL : select count(advertisementbooking.ADVERTISEMENTBOOKINGID) as totalnew_parties from advertisementbooking,suborders,(select PARTYID,NAME from partydetail) as aspartydetail where advertisementbooking.ADVERTISEMENTBOOKINGID=suborders.ADVERTISEBOOKINGID and advertisementbooking.PARTY=aspartydetail.PARTYID and (ISCANCEL=0 || ISCANCEL IS NULL)  and suborders.MAGZINEEDITIONS=150 order by COLOR desc

Time : 09:42:13
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'COLOR' in 'order clause'
Raw SQL : select count(advertisementbooking.ADVERTISEMENTBOOKINGID) as totalnew_parties from advertisementbooking,suborders,(select PARTYID,NAME from partydetail) as aspartydetail where advertisementbooking.ADVERTISEMENTBOOKINGID=suborders.ADVERTISEBOOKINGID and advertisementbooking.PARTY=aspartydetail.PARTYID and (ISCANCEL=0 || ISCANCEL IS NULL)  and suborders.MAGZINEEDITIONS=150 order by COLOR desc