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 ('155','156','157','220','297','298','299','302','309','311','314','335','344','346','382','393','395','399','400','402','526','529','532','534','539','541','545','546','547','548','550','563','565','566','586','587','588','592','674','720','733','792','793','1207','1209','1330','1331','1458','1473','1477','1478','1649','1650','1759','1806','1979','1980','1981','1986','1988','1989','1999','2000','2001','2002','2003','2004','2005','2006','2009','2010','2011','2012','2013','2014','2076','2105','2106','2107','2129','2130','3030','3617','4912','4913','4916','4921','4923','6175','6176','6177','6235','6258','6272','6273','6372','7170','7171','7345','7346','7347','7348','7592','7593','7971','7972','7973','7974','8016','8017','8023','8024','8025','8044','8045','8046','8047','8304','8305','8306','8307','8308','8309','8310','8311','9995','9996','10032','10040','10041','10221','10281','10321','10343','10439','10571','10573','10667','10668','10669','10698','10722','10723','10724','10725','10738','10824','10829','10942','10944','10945','10948','10949','11000','11001','11077','11078','11081','11336','11338','11345','11348','11349','11350','11352','11358','11359','11360','11361','11362','11363','11435','11436','11437','11469','11471','11472','11488','11639','13018','13212','14441','14519','15055','15078','15079','15101','15102','15179','15180','15183','15185','15637','15638','15639','15650','15687','15794','15795','15876','15877','15888','15890','15904','15906','15913','15914','15935','15937','15939','16084','16383','16389','16408','16409','16410','16411','16412','16413','16414','16415','16416','16417','16418','16419','16420','16424','16432','16433','16434','16435','16436','16437','16438','16491','16600','16832','16834','17162','17281','17315','17316','17363','17369','17370','17389','17390','17391','17396','17397','17411','17440','17442','17443','17444','17446','17460','17461','17463','17472','17480','17481','17482','17520','17613','17614','17615','17616','17617','17618','17622','17623','17624','17625','17626','17655','17656','17657','17725','17804','17813','17814','17838','17873','17881','17888','17919','17967','17994','18079','18080','18092','18207','18208','18209','18242','18243','18244','18245') ) 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,541,1208,1207,1210,1209,1205,1204,1203,1202,1201,663,0) , g.store_sort asc LIMIT 80,16
搜索商品 - 我的五金商城-MRO工业品一站式购销服务平台！
