Online Booking:
|

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 'AND
a.hotel_id=b.hotel_id AND
b.greeka_site NOT LIKE '' AND
b.greeka' at line 6
SELECT b.hotel_id
FROM
hotel b ,
hotel_propertytype a
WHERE
a.type_id= AND
a.hotel_id=b.hotel_id AND
b.greeka_site NOT LIKE '' AND
b.greeka_site NOT LIKE 'BAN' AND
b.killed_english NOT LIKE 'Y' AND
b.published=1 AND
b.island_id=14 AND
b.hotel_type LIKE '%greeka%' AND
(
(b.price_from BETWEEN '31' AND '60') OR
(b.price_from>='31' AND b.price_from<='60') OR
(b.price_to BETWEEN '31' AND '60') OR
(b.price_to>='31' AND b.price_to<='60') OR
(b.price_from<='31' AND b.price_to>='60')
) AND
b.price_from NOT LIKE 0 AND b.price_to NOT LIKE 0 AND
b.confirm_hide_all NOT LIKE 'Y'
ORDER BY
b.price_from , hotel_name