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.cate_id_2 = '58' ORDER BY genre asc,g.add_time desc LIMIT 0,16
Wrong File: \eccore\model\mysql.php[526] 哎呦！不小心出問題了！請稍后再試吧！ 工廠認證請聯系張經理：18037100507
>> 返回上一頁