select r.id route_id, COUNT(o.id) outlet_count
from route r
join outlet o on o.route_id = r.id
where r.id = ?
group by r.id;