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 pvh_property_descriptions,owner_master, pvh_city_master, pvh_state_master, pvh_property_master left join pvh_property_pictures on pp_property_id=pm_property_id and pp_display_order=1 where pm_city_id in (133.html;_single_family_homes) 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=pvh_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 'html;_single_family_homes) and cm_city_id=pm_city_id and sm_state_id=cm_state_' at line 1