select sum(a1.`num`) from `order_orderlistrow` as a1 INNER JOIN `order_orderlist` as a2 on a1.`order_orderlist_id` = a2.`id` where a1.`goods_good_id` =’54’ and a2.`state` <> ‘0’
- 周二. 3月 28th, 2023
select sum(a1.`num`) from `order_orderlistrow` as a1 INNER JOIN `order_orderlist` as a2 on a1.`order_orderlist_id` = a2.`id` where a1.`goods_good_id` =’54’ and a2.`state` <> ‘0’