select s.*,
g.title, g.cover, g.des, g.type, g.id goods_id, g.des, g.sales,
sku.guest_price, sku.user_price,
mp.member_level mp_level, mp.price mp_price,
sum(st.quantity) stock_num
from em_sort s
right join em_goods g on s.sid=g.sort_id
left join em_stock st on g.id=st.goods_id
left join em_skus sku on sku.goods_id=g.id
left join em_member_price mp on mp.goods_id=g.id
where g.is_on_shelf=1 and g.delete_time is null
group by sku.sku, sku.goods_id, mp.member_level
order by taxis asc, s.sid asc, g.sort_num desc, g.sort_top desc, g.index_top desc
error: 1054 , Unknown column 'st.quantity' in 'field list'