SELECT p_number, p_name as name, SUM(p_qty) as qty, p_price as price, SUM(op2_price) as op2_price, SUM((op2_price*commission)/100) as op2_orig_price, SUM(((p_price+op_price)*p_qty)-sale_price) as sum_price1, SUM((orig_price+op_price)*p_qty) as sum_price2 FROM mall_order_goods WHERE order_status!='Z' && order_status!='X' && order_status!='A' GROUP BY p_number ORDER BY qty DESC LIMIT 0,10