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 ('161616','161621','161627','162570','162571','162572','162573','162574','162575','162576','162577','162578','162579','162580','162581','162582','162583','162584','162585','162586','162587','162588','162589','164504','165401','166183','166188','166189','166191','166193','166668','168919','169253','169259','170052','170054','170279','170930','170966','170970','172998','173447','173457','174795') ) ORDER BY genre asc,g.add_time desc LIMIT 0,16
Wrong File: \eccore\model\mysql.php[526] 哎呦！不小心出问题了！请稍后再试吧！ 工厂认证请联系张经理：18037100507
>> 返回上一页