SELECT f.id, f.property_id, p.image_copy, f.title, p.title as property_title, p.property_code, f.description, left(p.short_description, 57) as short_description, p.bedrooms, f.link_url FROM featured_properties f left join featured_properties_to_web_sites w on w.featured_property_id = f.id left join properties p on f.property_id = p.id WHERE property_id != 0 AND f.location_id IN ($location) ORDER BY sort_order ASC LIMIT 3