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 '%city%' or p.highlights like '%city%' or p.kitchen like '%city%' or p.living_room like '%city%' or p.dining like '%city%' or p.bathrooms like '%city%' or p.bedrooms like '%city%' or p.outside like '%city%' or p.swim_pool like '%city%' or p.suitability like '%city%' or p.notes like '%city%' or p.description like '%city%' or p.description_title like '%city%' or p.location like '%city%' or p.airport like '%city%' or p.beach like '%city%' or p.motorway like '%city%' or p.ferry like '%city%' or p.rail like '%city%' or pt.name like '%city%' or lt.name like '%city%' or aty.name like '%city%') and (p.name like '%town%' or p.highlights like '%town%' or p.kitchen like '%town%' or p.living_room like '%town%' or p.dining like '%town%' or p.bathrooms like '%town%' or p.bedrooms like '%town%' or p.outside like '%town%' or p.swim_pool like '%town%' or p.suitability like '%town%' or p.notes like '%town%' or p.description like '%town%' or p.description_title like '%town%' or p.location like '%town%' or p.airport like '%town%' or p.beach like '%town%' or p.motorway like '%town%' or p.ferry like '%town%' or p.rail like '%town%' or pt.name like '%town%' or lt.name like '%town%' or aty.name like '%town%') and (p.name like '%apartment%' or p.highlights like '%apartment%' or p.kitchen like '%apartment%' or p.living_room like '%apartment%' or p.dining like '%apartment%' or p.bathrooms like '%apartment%' or p.bedrooms like '%apartment%' or p.outside like '%apartment%' or p.swim_pool like '%apartment%' or p.suitability like '%apartment%' or p.notes like '%apartment%' or p.description like '%apartment%' or p.description_title like '%apartment%' or p.location like '%apartment%' or p.airport like '%apartment%' or p.beach like '%apartment%' or p.motorway like '%apartment%' or p.ferry like '%apartment%' or p.rail like '%apartment%' or pt.name like '%apartment%' or lt.name like '%apartment%' or aty.name like '%apartment%') 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 '%city%' or p.highlights like '%city%' or p.kitchen like '%city%' o' at line 1 Bulgarian Holiday Rentals - Self catering apartments & villas in Bulgaria for rental direct with the owners. - Search
