SELECT
g.title, g.cover, g.des, g.type, g.id as goods_id, g.des as goods_des, COALESCE(sku_stats.total_sales, 0) as sales, g.sort_id, COALESCE(sku_stats.total_stock, 0) as stock,
g.index_top, g.sort_top, g.sort_num, g.station_id, g.create_time, g.is_on_shelf, g.delete_time, g.is_sku,
sku.goods_id as sku_goods_id, sku.sku, sku.guest_price, sku.market_price, sku.user_price, sku.cost_price, sku.stock as sku_stock,
mp.goods_id as mp_goods_id, mp.sku as mp_sku, mp.member_level as mp_level, mp.price as mp_price
FROM em_goods g
LEFT JOIN em_skus sku ON sku.goods_id = g.id
LEFT JOIN em_member_price mp ON mp.goods_id = g.id AND mp.sku = sku.sku
LEFT JOIN (
SELECT goods_id, SUM(sales) as total_sales, SUM(stock) as total_stock
FROM em_skus
GROUP BY goods_id
) sku_stats ON sku_stats.goods_id = g.id
WHERE g.is_on_shelf = 1 AND g.delete_time IS NULL and g.station_id=0
ORDER BY g.index_top DESC, g.sort_top DESC, g.sort_num DESC, g.id asc, sku.user_price asc;
error: 1146 , Table 'wwwazyuncom.em_skus' doesn't exist