UPDATE inserts i
SET total_distribution = (
SELECT SUM(r.distribution) as t_dist
FROM `insert_route` ir
LEFT JOIN `routes` r ON r.id = ir.route_id
WHERE ir.insert_id = i.insert_id
)