Error performing query: select distinct pm_property_id, pm_property_name, pm_sleeps, pm_bedrooms, pm_price_starts_from,pm_property_type_id, sm_state_name, cm_city_name, pd_description, pp_thumb_name,pp_file_name,om_email_address,pm_hotel_id from ovrw_property_descriptions,owner_master, ovrw_city_master, ovrw_state_master, ovrw_property_master left join ovrw_property_pictures on pp_property_id=pm_property_id and pp_display_order=1 where pm_city_id in () and cm_city_id=pm_city_id and sm_state_id=cm_state_id and pd_property_id=pm_property_id and owner_master.om_owner_id=ovrw_property_master.pm_owner_id and pm_status='A' and pm_payment_status='P' 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 ') and cm_city_id=pm_city_id and sm_state_id=cm_state_id and pd_property_id=pm_' at line 1