SELECT s.praise_rate,s.im_qq,s.im_ww,g.goods_id,g.store_sort, g.store_id, g.type, g.goods_name, g.cate_id, g.cate_name, g.brand, g.spec_qty, g.spec_name_1, g.spec_name_2,g.spec_name_3, g.if_show, g.closed, g.add_time, g.recommended, g.default_image, g.special, g.sort,g.store_sort, g.is_copy,g.delete_time,gs.spec_id, gs.spec_1, gs.spec_2, gs.spec_3, gs.yuanjia, gs.color_rgb, gs.price, gs.stock,gs.sku,gs.material, gs.pack,gs.inter_stock,gs.out_stock,gs.discount_x,gs.cost_x,gs.cost_z,gs.discount_z,gs.product_date,s.store_name, s.region_id, s.region_name, s.credit_value, s.sgrade, gp.pvs, gst.views, gst.sales, gst.comments FROM ecm_goods g LEFT JOIN ecm_goods_spec gs ON g.default_spec = gs.spec_id LEFT JOIN ecm_store s ON g.store_id = s.store_id LEFT JOIN ecm_goods_pvs gp ON g.goods_id=gp.goods_id LEFT JOIN ecm_goods_statistics gst ON g.goods_id = gst.goods_id LEFT JOIN `ecm_sbhh_goods` w ON g.goods_id = w.goods_id WHERE g.if_show = 1 AND g.closed = 0 AND g.is_delete=0 AND s.state != 0 AND s.state !=2 AND (g.goods_id IN ('794','795','796','797','798','811','812','813','814','816','817','818','819','822','823','825','836','843','845','853','854','1206','1211','1244','1245','1247','1326','1586','2110','2112','2155','2156','2157','2158','2159','2160','2172','2173','2175','2179','2185','2187','2189','2190','2191','2192','2193','2194','2195','2196','2198','2199','2200','2201','2203','2204','2205','2206','2208','2211','2212','2213','2214','2217','2218','2219','2226','2227','2275','2493','2494','2510','2515','2651','5632','5634','5635','5636','5638','5639','5641','5644','5645','5646','5648','5650','5651','5653','5655','5656','5657','5659','5660','5661','5663','5665','5667','5740','6602','6603','6604','6764','6765','6787','6828','6912','6913','6914','6915','6916','6917','6918','6919','6921','6922','6923','6924','6925','6926','6927','6928','6929','6931','6932','6937','8424','8429','8430','8432','8433','8434','8435','8436','8437','8438','8439','8440','8442','8443','8444','8445','8446','8447','8448','8449','8533','8573','8595','8596','8735','8739','8740','8741','9241','9282','9283','9285','9286','9287','9288','9289','9290','9291','9292','9293','9294','9295','9296','9297','9298','9299','9300','9301','9303','9304','9305','9306','10056','10059','12763','12802','12803','12811','12812','12875','12891','12892','12898','12899','12900','12903','12904','12905','12906','12909','12911','12912','12913','12914','12916','12917','12918','12919','12921','12922','12923','12924','12925','12926','12927','12928','12929','12930','12932','12933','12935','12936','12938','12939','12940','12941','12942','12943','13821','13822','13824','13825','13826','13827','13828','13829','13831','13832','13833','13834','13835','13836','13837','13838','13839','13840','13841','13842','13843','13844','13845','13846','13847','13848','13850','13851','13852','13853','13854','13855','13856','13857','13859','13860','13882','13883','13884','13885','13886','13887','13895','13896','13899','13935','13936','13937','13972','14011','14012','14013','14014','14015','14016','14017','14020','14021','14028','14033','14034','14036','14040','14045','14046','14085','14101','14102','14147','14148','14149','14150','14151','14224','14227','14228','14229','14230','14231','14232','14233','14234','14235','14236','14237','14238','14330','14334','14335','14336','14337','14338','14339') ) AND ( w.warehouse in (2) OR s.region_id in (510,511,512,513,514,515,516,517,518,519,360,361,362,363,366,403,404,405,406,407,408,409,410,411,412,413,414,416,417,418,419,420,424,426,431,436,439,441,442,444,448,453,454,456,467,476,511,512,513,514,517,518,519,520,521,522,523,524,525,530,545,555,562,570,572,573,581,589,598,606,611,633,646,687,691,692,702,795)) AND gs.spec_id IS NOT NULL AND s.store_id IS NOT NULL ORDER BY (case when special=3 then 1 ELSE 2 END) , FIELD(s.region_id,510,511,512,513,514,515,516,517,518,519,360,361,362,363,366,403,404,405,406,407,408,409,410,411,412,413,414,416,417,418,419,420,424,426,431,436,439,441,442,444,448,453,454,456,467,476,511,512,513,514,517,518,519,520,521,522,523,524,525,530,545,555,562,570,572,573,581,589,598,606,611,633,646,687,691,692,702,795) , FIELD(g.cate_id,2426,2429,1351,1352,2427,1411,1369,2424,1408,2425,1388,2423,1389,2428,1362,1353,1406,1361,1407,2421,1385,0) , g.store_sort asc LIMIT 0,16
搜索商品 - 我的五金商城-MRO工业品一站式购销服务平台！
