<table>
    <colgroup>
        <col width="50px">
        <col width="100px">
        <col width="60px">
        <col width="*">
        <col width="100px">
    </colgroup>
    <thead>
    <tr>
        <th>순위</th>
        <th>총판장</th>
        <th>고객수</th>
        <th>판매품목</th>
        <th>총 판매금액</th>
    </tr>
    </thead>
    <tbody>
    <?
    $write_table = $g5['write_prefix'] . $bo_table;
    $sum_count = "0";
    $sql = "
        select a.mb_id, b.mb_name, group_concat(wr_12 separator '||') wr_12, count(*) as cnt , sum(a.wr_31) as tot
          from g5_write_sell a
                   left outer join {$g5['member_table']} b on a.mb_id = b.mb_id
         where wr_29 between '{$stx1}' and '{$stx2}' and wr_50 like '%{$stx7}%'
         group by a.mb_id, b.mb_name ORDER BY tot DESC
    ";
    $result = sql_query($sql);
    while ($row = sql_fetch_array($result)) {
    $list_name = explode('||',$row['wr_12']);
    sort($list_name);  // 정렬
    $num = array_count_values($list_name);
    $sum_count ++
    ?>
    <tr>
        <td class="td_c"><?php echo $sum_count ?>위</td>
        <td class="td_c"><?php echo $row['mb_name'] ?></td>
        <td class="td_c"><?php echo $row['cnt'] ?> 명</td>
        <td class="td">
        <?php foreach( $num as $key => $value ){ ?>
        <?php echo $key; ?>(<?php echo $value?>),
        <?php } ?></td>
        <td class="td_r"><?php echo number_format($row['tot']) ?>원</td>
    </tr>
    <?php } ?>
</table>