MySQL Error[1054]: Unknown column 'g.cate_id_' in 'where clause'
MySQL Query:select g.city,CASE WHEN t.tuan_price IS NULL THEN '' ELSE t.tuan_price END AS tuan_price, CASE WHEN t.`tuan_price2` IS NULL THEN '' ELSE t.`tuan_price2` END AS tuan_price2,
CASE WHEN t.`tuan_price3` IS NULL THEN '' ELSE t.`tuan_price3` END AS tuan_price3,CASE WHEN t.status IS NULL THEN '' ELSE t.`status` END AS tuan_status,CASE WHEN t.begin_time IS NULL THEN '' ELSE t.`begin_time` END AS tuan_begin_time,CASE WHEN t.end_time IS NULL THEN '' ELSE t.`end_time` END AS tuan_end_time,goods_name,g.use_nums,g.use_coupon,s.store_name,g.cate_name,g.city,g.price_type,ga.start_time,ga.end_time,ga.place,g.price,g.regions,g.market_price,g.goods_name,g.goods_id,g.default_image,gst.reservations,ga.`region_type`,ga.min_age,ga.max_age,g.fanxian from sh_goods g left join sh_top_crond tc on tc.`goods_id`=g.`goods_id` LEFT JOIN sh_goods_tuan t ON t.`goods_id`=g.`goods_id` left join sh_store s on s.store_id = g.store_id and s.state = 1 LEFT JOIN sh_member u ON u.user_id = g.store_id join sh_goods_activity ga on g.goods_id = ga.goods_id join sh_goods_statistics gst on gst.goods_id = g.goods_id where g.if_show = 1 AND g.closed = 0 AND (s.state=1 or g.property =1) AND g.cate_id_1 = 251 AND (g.cate_id_ = '398' or g.cate2_id='398' or g.cate3_id='398' ) and g.goods_id not in (231530,235394) and FROM_UNIXTIME(ga.`end_time`)>NOW() and g.shenhe=1 group by g.`goods_id` order by tc.`execute` DESC,field(g.`city`,1,257,380,444,513,549,559,564,565,593,608),ga.region_type,g.reasonable_value DESC,g.goods_sort_order ASC,g.last_update DESC limit 0,10
Wrong File: /eccore/model/mysql.php[500]
Error File: /eccore/model/mysql.php at 278 line. >> mysql_error_report
>> 返回上一页

哈哈儿童微信 哈哈儿童手机客户端