|
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
SELECT b.*
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=20 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.confirm_hide_all NOT LIKE 'Y'
ORDER BY
b.price_from , hotel_name |