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

</p>

<p><?php

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

$sum_count = "0";

$sql = "

    select a.mb_id, b.mb_name, group_concat(wr_32 separator '||') wr_32, 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}%'

     group by a.mb_id, b.mb_name ORDER BY tot DESC

";

$result = sql_query($sql, true);

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

    $counts_cash = array_sum(explode('||',str_replace(',', '', $row['wr_32'])));

    $tmp= sql_fetch( "select count(*) cnt from {$g5['member_table']} where mb_9='{$row['mb_id']}'") ;

    $sum_count ++;

?>

<tr>

    <td class="td_c"><?php echo $sum_count; ?>위</td>

    <td class="td_c"><?php echo $tmp['cnt']; ?> 명</td>

    <td class="td_c"><?php echo $row['cnt']; ?> 번</td>

    <td class="td_r"><?php echo number_format($counts_cash); ?>원</td>

<?php } ?></p>

<p>