쿼리문 질문 드립니다. 채택완료

$write_table = $g5['write_prefix'] . $bo_table;

$sum_count = "0";

$sql = "

    select a.mb_id, a.wr_50, b.mb_name, 

        group_concat(wr_12 separator '||') wr_12a, 

        group_concat(wr_13 separator '||') wr_13a, 

        group_concat(wr_14 separator '||') wr_14a, 

        count(*) as cnt , sum(a.wr_23) as tot

      from {$write_table} 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 '%{$stx10}%'

";

    $result = sql_query($sql,true);

    while ($row = sql_fetch_array($result)) {

    $list_nameb = explode('||',$row['wr_12a']);

    $list_nameb = array_diff($list_nameb, array('제품선택'));

    $numb = array_count_values($list_nameb);

    $sum_count ++

?></p>

<p>

<?php foreach( $numb as $key => $value ){ ?>

    <tr>

        <td><?php echo $key; ?></td>

        <td><?php echo $value?> 개</td>

    </tr>

<?php } }?></p>

<p>