Erro: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'.
------------------------------------
SELECT TOP 3 CID.cid_id, CID.cid_nome, CID.cid_uf, CID.cid_distritode, HTL.ht_id, HTL.ht_nome, (SELECT COUNT(*) FROM sys_hoteis_atrib WHERE hatr_atr_id = 54 AND hatr_ht_id = HTL.ht_id) AS adaptado, HTL.ht_end, HTL.ht_stt, HTL.ht_brr, HTL.ht_ctg, BOK.minrate, (SELECT TOP 1 img_file FROM sys_hoteis_img WHERE img_ht_id = ht_id ORDER BY img_ndx) AS img_file FROM sys_hoteis HTL INNER JOIN sys_cidades CID ON HTL.ht_cid_id = CID.cid_id LEFT OUTER JOIN sys_booking BOK ON HTL.ht_bok_cod = BOK.id WHERE HTL.ht_stt = 'A' AND HTL.ht_cid_id IN () ORDER BY NEWID()