select m.* from hotels_rooms m
        where m.status=1 and
        m.hotels_id=800 and discountedprice=(select min(discountedprice) from hotels_rooms where status=1 and hotels_id=800) group by m.discountedprice