MySQL Error[1052]: Column 'genre' in order clause is ambiguous
MySQL Query:SELECT g.virtual_seles,s.add_time as store_open_time,g.goods_id, g.store_id, g.goods_name,s.store_name,gst.views, g.default_image, cg.cate_id FROM ecm_goods g LEFT JOIN ecm_store s ON g.store_id = s.store_id LEFT JOIN ecm_category_goods cg ON g.goods_id = cg.goods_id LEFT JOIN ecm_goods_statistics gst ON g.goods_id = gst.goods_id WHERE g.if_show = 1 AND g.closed = 0 AND s.state = 1 AND (g.goods_id IN ('177618','177619','177621','177623','177624','177625','177626','177627','177628','177629','184978','186190','223692','223693','223944','223945','223946','223952','225192','225194','225195','225701','225702','230671','230672','230673','231218','231219','231220','231221','231222','231224','267363','267366','267368','269684','269685','269686','269687','269688','269689','269690','269691','269692','269696','269697','272708','272710','272711','272712','272714','272715') ) ORDER BY genre asc,g.add_time desc LIMIT 0,16
Wrong File: \eccore\model\mysql.php[526] 哎呦！不小心出问题了！请稍后再试吧！ 工厂认证请联系张经理：18037100507
>> 返回上一页