SELECT od_id,
SUBSTRING_INDEX(od_addr1,' ',$len) as od_addr1,
mb_id,
od_name,
`$g4[yc4_order_table]`.on_uid,
sum(od_send_cost) as od_send_cost,
sum(od_receipt_bank) as od_receipt_bank,
sum(od_receipt_card) as od_receipt_card,
sum(od_receipt_point) as od_receipt_point,
sum(od_dc_amount) as od_dc_amount,
(sum(od_receipt_bank + od_receipt_card + od_receipt_point)) as receiptamount,
(sum(od_refund_amount + od_cancel_card)) as receiptcancel,
sum(orderamount) as orderamount,
sum(ordercancel) as ordercancel

from $g4[yc4_order_table]

LEFT JOIN (
SELECT on_uid,
sum(ct_amount * ct_qty) as orderamount,
sum(IF(ct_status = '취소' OR ct_status = '반품' OR ct_status = '품절', ct_amount * ct_qty, 0)) as ordercancel
FROM `$g4[yc4_cart_table]`
WHERE ct_status != '쇼핑'
GROUP BY on_uid
) as $g4[yc4_cart_table] ON `$g4[yc4_order_table]`.on_uid = `$g4[yc4_cart_table]`.on_uid

where SUBSTRING(od_time,1,10) = '$date'

GROUP BY SUBSTRING_INDEX(od_addr1,' ',$len)

order by od_addr1, od_id desc


영카트에서 지역 단위로 매출현황 합산 하는 건데요.
조인에 서브쿼리에... 남발했는데 이거 많이 느릴거 같아서요 ;ㅅ;

조언 부탁드립니다..