Mine

insert into        margin_optimization_aggregate_cascade (                aggregate_id,                date,                hour,                state,                seller_id,                day_of_week,                attempted_margin,                leads_pinged,                leads_sold,                profit,                EPL        )(select        id,        date,        hour,        state,        seller_id,        day_of_week,        attempted_margin,        leads_pinged,        leads_sold,        profit,        EPLfrom        margin_optimization_aggregate)on duplicate key update        leads_pinged = (                select                        margin_optimization_aggregate.leads_pinged                from                        margin_optimization_aggregate,margin_optimization_aggregate_cascade                where                        margin_optimization_aggregate_cascade.aggregate_id      = margin_optimization_aggregate.id                        AND margin_optimization_aggregate_cascade.date      = margin_optimization_aggregate.date                        AND margin_optimization_aggregate_cascade.hour      = margin_optimization_aggregate.hour                        AND margin_optimization_aggregate_cascade.state         = margin_optimization_aggregate.state                        AND margin_optimization_aggregate_cascade.seller_id = margin_optimization_aggregate.seller_id                        AND margin_optimization_aggregate_cascade.day_of_week = margin_optimization_aggregate.day_of_week                        AND margin_optimization_aggregate_cascade.attempted_margin <= margin_optimization_aggregate.attempted_margin        ),        leads_sold = (                select                        sum(margin_optimization_aggregate.leads_sold)                from                        margin_optimization_aggregate,margin_optimization_aggregate_cascade                where                        margin_optimization_aggregate_cascade.date      = margin_optimization_aggregate.date                        AND margin_optimization_aggregate_cascade.hour      = margin_optimization_aggregate.hour                        AND margin_optimization_aggregate_cascade.state         = margin_optimization_aggregate.state                        AND margin_optimization_aggregate_cascade.seller_id = margin_optimization_aggregate.seller_id                        AND margin_optimization_aggregate_cascade.day_of_week = margin_optimization_aggregate.day_of_week                        AND margin_optimization_aggregate_cascade.attempted_margin <= margin_optimization_aggregate.attempted_margin        ),        profit = (                select                        sum(margin_optimization_aggregate.profit)                from                        margin_optimization_aggregate,margin_optimization_aggregate_cascade                where                        margin_optimization_aggregate_cascade.date      = margin_optimization_aggregate.date                        AND margin_optimization_aggregate_cascade.hour      = margin_optimization_aggregate.hour                        AND margin_optimization_aggregate_cascade.state         = margin_optimization_aggregate.state                        AND margin_optimization_aggregate_cascade.seller_id = margin_optimization_aggregate.seller_id                        AND margin_optimization_aggregate_cascade.day_of_week = margin_optimization_aggregate.day_of_week                        AND margin_optimization_aggregate_cascade.attempted_margin <= margin_optimization_aggregate.attempted_margin        ),        EPL = (                select                        sum(margin_optimization_aggregate.EPL)                from                        margin_optimization_aggregate,margin_optimization_aggregate_cascade                where                        margin_optimization_aggregate_cascade.date      = margin_optimization_aggregate.date                        AND margin_optimization_aggregate_cascade.hour      = margin_optimization_aggregate.hour                        AND margin_optimization_aggregate_cascade.state         = margin_optimization_aggregate.state                        AND margin_optimization_aggregate_cascade.seller_id = margin_optimization_aggregate.seller_id                        AND margin_optimization_aggregate_cascade.day_of_week = margin_optimization_aggregate.day_of_week                        AND margin_optimization_aggregate_cascade.attempted_margin <= margin_optimization_aggregate.attempted_margin        )