A Database Error Occurred

Error Number: 42000/102

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.

SELECT distinct ci.city_id, ci.city_name, CASE WHEN ci_th.city_name <> '' THEN ci_th.city_name ELSE ci.city_name END As city_nameTH FROM hotel ho LEFT JOIN city ci ON ho.city_id = ci.city_id LEFT JOIN city_th ci_th ON ci.city_id = ci_th.city_id WHERE ho.hotel_id in () and ci.country_id = 3 ORDER BY city_nameTH ASC

Filename: D:/wwwroot/hotelsthailand.com/services/secure/mtgsys/database/DB_driver.php

Line Number: 691