 <b>MySQL server error report:Array
(
[0] => Array
(
[message] => MySQL Query Error
)
[1] => Array
(
[sql] => SELECT g.goods_id , g.promote_price , g.goods_name , g.market_price , g.shop_price , g.goods_brief , g.goods_thumb , g.goods_img , g.goods_gc , g.goods_ggy , g.goods_number , g.promote_start_date , g.activity_price1 , g.activity_price2 , g.describe1, g.describe2, g.promote_end_date, IFNULL(mp.user_price, g.shop_price) 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 , g.salesnum, g.goods_gc, g.zys, g.goods_ggy, g.q_time, g.goods_number , g.click_count, g.tax, g.tax1,g.vip_discount1,g.vip_discount2 FROM `gjmm`.`ecs_goods` AS g LEFT JOIN `gjmm`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' AND g.is_on_sale = 1 AND g.is_delete = 0 AND g.goods_number > 0 where is_on_sale=1 and is_alone_sale=1 and is_delete=0 and goods_id in(9044,3199,3200,3201,1954) order by field(goods_id,9044,3199,3200,3201,1954)
)
[2] => Array
(
[error] => Array
(
[0] => 23000
[1] => 1052
[2] => Column 'goods_id' in where clause is ambiguous
)
)
[3] => Array
(
[errno] => 23000
)
)