select r.room_id, r.name, r.enabled_p, (select count(reservation_id) from rr_reservations re where re.room_id = r.room_id) as reservation_count from rr_rooms r where facility_id = :facility_id order by enabled_p desc, name