LEFT JOIN (
    SELECT
        `SUM_TOTAL_WON`
    FROM `b_crm_deal_sum_stat`
    WHERE `STATUS` = `WON`
) AS `pewpew` ON `pewpew`.`OWNER_ID`=`d`.`ID`