ΖΑΚΥΝΘΟΣ ΞΕΝΟΔΟΧΕΙΑ - Ξενοδοχεία Ζάκυνθος - ΑΜΟΥΔΙ

ΑΜΟΥΔΙ - ΞΕΝΟΔΟΧΕΙΑ ΖΑΚΥΝΘΟΣ - Ξενοδοχεία Ζάκυνθος

Could not retrieve the data because: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 'accommodation.active, AND accommodation.type LIKE '%hotels%' AN. The query was SELECT accommodation.id, accommodation.id_name, accommodation.name_gr, SUBSTRING_INDEX(accommodation.text_gr,' ',18) AS text_gr, accommodation.site_url, accommodation.site_only, accommodation.stars, accommodation.type, accommodation.new, accommodation.online_system, accommodation.bookingcom, accommodation.no_follow, accommodation.visible, accommodation.hits, accom_details.id, accom_details.id_locat, location.id_locat, location.location_gr FROM accommodation, accom_details, location WHERE accom_details.id=accommodation.id AND accom_details.id_locat=location.id_locat AND accommodation.visible='Y' AND accommodation.active='Y' accommodation.active, AND accommodation.type LIKE '%hotels%' AND location.location_en='Amoudi' ORDER BY hits ASC.