SELECT
g.title, g.cover, g.des, g.type, g.id as goods_id, g.des as goods_des, g.sales, g.sort_id, g.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
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;
error: 1146 , Table 'asd_haiwaiid0102.em_skus' doesn't exist