消息MySQL Query Error
SQLSELECT g.goods_id, g.goods_name, g.goods_name_style, eg.exchange_integral, eg.goods_priceg.goods_brief, g.goods_thumb, goods_img, b.brand_name FROM `weshop`.`ecs_exchange_goods` AS eg LEFT JOIN `weshop`.`ecs_goods` AS g ON g.goods_id = eg.goods_id LEFT JOIN `weshop`.`ecs_brand` AS b ON b.brand_id = g.brand_id WHERE eg.is_exchange = 1 AND g.is_delete = 0 AND eg.is_hot = 1 AND (g.cat_id IN ('0','637','4','614','145','157','439','158','583','144','447','451','610','6','443','510','511','571','555','551','589','308','543','541','330','332','333','460','459','432','435','433','309','401','471','427','337','339','478','480','559','479','482','481','311','458','402','442','429','544','641','417','412','368','534','535','540','499','607','513','486','461','553','444','464','457','538','445','450','449','469','354','448','528','350','8','515','382','463','462','434','590','509','609','524','372','374','638','387','388','633','634','472','473','474','484','549','476','477','533','530','536','552','483','485','611','500','507','475','514','364','585','587','586','588','366','404','405','403','367','579','424','406','647','653','656','652','649','655','648','657','651','654','650','617','620','630','642','631','618','632','635','487','606','591','529','526','488','569','489','639','640','414','508','557','504','506','505','644','621','623','626','624','628','622','625','627','629','516','517','376') OR g.goods_id IN ('288','294','296','304','305','308','321','329','333','334','335','338','339','340','343','344','348','352','354','355','356','358','360','363','364','366','367','376','382','471','485','486','563','564','1022','1023','1042','2038','2516','2592','2624','2851','3165','3233','4171') ) ORDER BY RAND() LIMIT 5
错误Unknown column 'eg.goods_priceg.goods_brief' in 'field list'
代码1054