DB ERROR QUERY ( SELECT distinct (p.property_id) as PROPERTYID, c.symbol AS currency, p.name as `NAME`, p.n_bedrooms as NBEDROOMS, p.n_sleeps as NSLEEPS, p.highlights as HIGHLIGHTS, p.area as AREA, p.description_title as DESCTITLE, pt.name as PROPERTYTYPE, lt.name as LOCATIONTYPE, aty.name as ACCOMODATIONTYPE FROM bul_property p LEFT JOIN bul_property_type pt ON p.property_type = pt.property_type_id LEFT JOIN bul_location_type lt ON p.location_type = lt.location_type_id LEFT JOIN bul_accomodation_type aty ON p.accomodation_type = aty.accomodation_type_id LEFT JOIN bul_rel_theme rel_th ON p.property_id = rel_th.property_id LEFT JOIN bul_rel_general rel_gen ON p.property_id = rel_gen.property_id LEFT JOIN bul_rel_entertainment rel_en ON p.property_id = rel_en.property_id LEFT JOIN bul_currency c ON c.currency_id=p.currency WHERE p.property_status<>3(p.name like '%ski%' or p.highlights like '%ski%' or p.kitchen like '%ski%' or p.living_room like '%ski%' or p.dining like '%ski%' or p.bathrooms like '%ski%' or p.bedrooms like '%ski%' or p.outside like '%ski%' or p.swim_pool like '%ski%' or p.suitability like '%ski%' or p.notes like '%ski%' or p.description like '%ski%' or p.description_title like '%ski%' or p.location like '%ski%' or p.airport like '%ski%' or p.beach like '%ski%' or p.motorway like '%ski%' or p.ferry like '%ski%' or p.rail like '%ski%' or pt.name like '%ski%' or lt.name like '%ski%' or aty.name like '%ski%') and ) -> 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 '(p.name like '%ski%' or p.highlights like '%ski%' or p.kitchen like '%ski%' or p' at line 1 Bulgarian Holiday Rentals - Self catering apartments & villas in Bulgaria for rental direct with the owners. - Search
