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 ('64910','64912','64914','64916','64917','116486','116487','116488','116489','116490','116491','116492','116493','116494','116495','116496','116497','116498','116499','116500','116501','149207','149208','149209','149210','149211','149212','149213','149214','149215','149216','149217','149218','150424','150425','150426','150427','150428','150429','150430','150431','150432','150433','150434','150435','150436','150437','150438','150439','150440','150441','150442','150443','150444','150445','150446','150447','150448','150449','150450','150451','150452','150453','150454','150455','150456','150457','150458','150459','150460','150461','150462','150463','150464','150465','150466','151489','151491','151494','151496','151498','151499','151500','151501','151502','151503','151504','151505','151837','151838','151839','159581','159582','159583','159584','159585','159586','159587','159588','211899','211900','211901','211902','211903','320757') ) ORDER BY genre asc,g.add_time desc LIMIT 0,16
Wrong File: \eccore\model\mysql.php[526] 哎呦！不小心出問題了！請稍后再試吧！ 工廠認證請聯系張經理：15538273383
>> 返回上一頁