SELECT ir.`insert_id` , ir.`route_id` , i.`insert_name` , i.`total_distribution`
FROM `insert_route` ir
LEFT JOIN `inserts` i ON "i.id = ir.insert_id"
WHERE ir.insert_id =10
LIMIT 0 , 30