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.gre' 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=30 AND
b.hotel_type LIKE '%greeka%' AND
(
(b.price_from BETWEEN '0' AND '30euro') OR
(b.price_from>='0' AND b.price_from<='30euro') OR
(b.price_to BETWEEN '0' AND '30euro') OR
(b.price_to>='0' AND b.price_to<='30euro') OR
(b.price_from<='0' AND b.price_to>='30euro')
) 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