:(

MySQL Query Error
SQL: SELECT g.goods_id,g.goods_sn, g.goods_name,g.goods_number, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.promote_price, g.goods_type, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img, xl.sales_volume FROM ( SELECT * FROM ecs_goods WHERE goods_sn LIKE "BKL%" AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0 AND g.cat_id NOT IN (286,9,382,877,878,879,881,880,883) ORDER BY last_update DESC LIMIT 0, 30) AS g LEFT JOIN ecs_touch_goods AS xl ON g.goods_id=xl.goods_id LEFT JOIN ecs_member_price AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0'
错误详情: Unknown column 'g.cat_id' in 'where clause'
错误代码:1054