select swagatham_rate_matrix_new.prop_id,swagatham_rate_matrix_new.roomtype_id from swagatham_rate_matrix_new, swagatham_agent_class where swagatham_rate_matrix_new.ag_class_id=swagatham_agent_class.ag_class_id and swagatham_agent_class.ag_class_name='BAR Rate' and swagatham_rate_matrix_new.planet_limited_offer=1 and swagatham_rate_matrix_new.planet_limited_offer_desc!='' and swagatham_rate_matrix_new.season_id IN () and swagatham_rate_matrix_new.single_occupancy_inr>0 and swagatham_rate_matrix_new.approved_by >0 and swagatham_rate_matrix_new.offer_status='active' order by swagatham_rate_matrix_new.offer_disp_orderYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and swagatham_rate_matrix_new.single_occupancy_inr>0 and sw' at line 6

Swagatam Tours Private Limited