adm/shop_admin/orderlist에서

$sql_join = "inner join {$g5['member_table']} B on A.mb_id=B.mb_id ";

$sql_search .= " and B.mb_level>=5 ";

$sql_common = " from {$g5['g5_shop_order_table']} A $sql_join $sql_search ";

$sql  = " select A.*,

            (A.od_cart_coupon + A.od_coupon + A.od_send_coupon) as couponprice

           $sql_common          

           order by $sort1 $sort2

           limit $from_record, $rows ";

$result = sql_query($sql);