SELECT *
FROM HT_ROOM
WHERE ht_mst_seq = :ht_mst_seq
AND day >= :check_in
AND day < :check_out
AND ht_room_seq = :ht_room_seq
AND ba_comp_seq = :channel_comp_seq