select f.facility_id, f.name as facility_name, (select count(room_id) from rr_rooms_enabled where facility_id = f.facility_id) as room_count, r.room_id, coalesce(r.name,'0') as room_name, r.capacity from rr_facilities_enabled f, rr_rooms_enabled r where f.facility_id = r.facility_id and f.package_id = :package_id order by f.name, r.name