회원매출순위

영카트5에서

상품판매순위 페이지를 회원매출순위로 변경중입니다.

itemsellrank.php

$sql  = " select a.it_id,
                 b.*,
                 SUM(IF(ct_status = '쇼핑',ct_qty, 0)) as ct_status_1,
                 SUM(IF(ct_status = '주문',ct_qty, 0)) as ct_status_2,
                 SUM(IF(ct_status = '입금',ct_qty, 0)) as ct_status_3,
                 SUM(IF(ct_status = '준비',ct_qty, 0)) as ct_status_4,
                 SUM(IF(ct_status = '배송',ct_qty, 0)) as ct_status_5,
                 SUM(IF(ct_status = '완료',ct_qty, 0)) as ct_status_6,
                 SUM(IF(ct_status = '취소',ct_qty, 0)) as ct_status_7,
                 SUM(IF(ct_status = '반품',ct_qty, 0)) as ct_status_8,
                 SUM(IF(ct_status = '품절',ct_qty, 0)) as ct_status_9,
                 SUM(ct_qty) as ct_status_sum
            from {$g5['g5_shop_cart_table']} a, {$g5['g5_shop_item_table']} b ";
$sql .= " where a.it_id = b.it_id ";

위 소스코드를 변경중인데요...

3개의 공통으로 연결될 컬럼이 없어 data를 가져오지 못하고 있는데요..

테스트하고 있는 코드입니다

$sql  = " select c.mb_id as mb_id, b.ca_id as ca_id,
                 SUM(IF(ct_status = '쇼핑',ct_qty, 0)) as ct_status_1,
                 SUM(IF(ct_status = '주문',ct_qty, 0)) as ct_status_2,
                 SUM(IF(ct_status = '입금',ct_qty, 0)) as ct_status_3,
                 SUM(IF(ct_status = '준비',ct_qty, 0)) as ct_status_4,
                 SUM(IF(ct_status = '배송',ct_qty, 0)) as ct_status_5,
                 SUM(IF(ct_status = '완료',ct_qty, 0)) as ct_status_6,
                 SUM(IF(ct_status = '취소',ct_qty, 0)) as ct_status_7,
                 SUM(IF(ct_status = '반품',ct_qty, 0)) as ct_status_8,
                 SUM(IF(ct_status = '품절',ct_qty, 0)) as ct_status_9,
                 SUM(ct_qty) as ct_status_sum
            from {$g5['g5_shop_cart_table']} a, {$g5['g5_shop_order_table']} c, {$g5['g5_shop_item_table']} b ";

$sql .= " where a.it_id = b.it_id and c.mb_id = a.mb_id ";

영카트4에서 사용했던 회원매출코드입니다

$sql  = " select b.mb_id as mb_id, c.ca_id as ca_id,
                SUM(IF(ct_status = '쇼핑',ct_qty, 0)) as ct_status_1,
                SUM(IF(ct_status = '주문',ct_qty, 0)) as ct_status_2,
                SUM(IF(ct_status = '준비',ct_qty, 0)) as ct_status_3,
                SUM(IF(ct_status = '배송',ct_qty, 0)) as ct_status_4,
                SUM(IF(ct_status = '완료',ct_qty, 0)) as ct_status_5,
                SUM(IF(ct_status = '취소',ct_qty, 0)) as ct_status_6,
                SUM(IF(ct_status = '반품',ct_qty, 0)) as ct_status_7,
                SUM(IF(ct_status = '품절',ct_qty, 0)) as ct_status_8,
                SUM(ct_qty) as ct_status_sum
            from $g4[yc4_cart_table] a, $g4[yc4_order_table] b, $g4[yc4_item_table] c ";
$sql .= " where a.on_uid = b.on_uid and a.it_id = c.it_id ";

내공이 부족하여 삽질을 계속하고 있습니다만 잘안되는데요.

공통으로 연결할수 있는 컬럼이 있을까요?