[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 event_date desc,event_rank' at line 1 
 select *,Date_Format(event_date,'%d %b %Y') as spcl_event_date from event inner join category on category.category_id = event.category_id where 1=1 and event_is_enabled  and event.category_id= order by event_date desc,event_rank ]