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 ('154','201','202','203','204','205','334','666','667','669','677','761','777','778','779','780','783','784','786','787','848','918','1810','1811','1924','1925','1926','1927','1928','1929','1930','1934','1935','1936','1937','1938','1940','1941','1942','1944','1945','1946','1947','1948','1949','1950','1951','1952','1953','1954','1955','1956','1957','1958','1963','1964','1966','1969','2010','2073','2744','2745','2746','3182','3185','3186','6171','6172','6173','6299','6301','6377','7199','7200','7201','8142','8143','8148','8149','8150','8151','9748','9749','9750','10010','10073','10247','10263','10264','10423','10595','10752','10753','10830','10831','11084','11085','11086','11087','11092','11259','11314','11315','11318','11321','11323','11324','11326','11328','11332','11467','11640','13183','13184','14935','14939','14940','14941','14946','15022','15023','15115','15116','15121','15122','15305','15315','15682','15683','15977','15978','15979','15980','16012','16013','16134','16154','16155','16218','16219','17253','17429','17555','17569','17582','17583','17585','17590','17591','17610','17612','17663','17664','17665','17666','17667','17966','18007','18043','18052','18116','18123','18132','18230','18260','18343') ) 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,2347,1026,1027,996,1022,997,541,1505,486,0) , g.store_sort asc LIMIT 0,16 搜索商品 - 我的五金商城-MRO工业品一站式购销服务平台！
首页 所有分类

所有类目

劳保、安防、标识

紧固件

工具、量具和刃具

建筑五金、装饰材料

机械部件及相关产品

金属丝、钉、有色金属材料

公用设施相关产品

存储包装、物流搬运、清洁

润滑器、密封件、起重器材附件及机床附件

泵、阀、管及管路附件

焊接材料与设备

橡胶制品系列

五金生活馆

特卖品

推广商品

镀锌牙条 蓝白锌 兄弟牌
￥130.2000
福州喜力德标准紧固件有限公司
本色牙条 兄弟牌
￥94.7400
福州喜力德标准紧固件有限公司
镀锌牙条 蓝白锌 兄弟牌 天宝牌
￥113.7780
我的五金网福州分拣中心
本色牙条 兄弟牌 天宝牌
￥102.3120
我的五金网福州分拣中心
兄弟牌 国标8.8级牙条 淬黑
￥130.8622
福州喜力德标准紧固件有限公司
兄弟牌 中碳钢发黑牙条 45钢35钢无淬火
￥128.4479
福州喜力德标准紧固件有限公司
兄弟牌 国标8.8级牙条 淬黑
￥140.4000
我的五金网福州分拣中心
兄弟牌 中碳钢发黑牙条 45钢35钢无淬火
￥144.4800
我的五金网福州分拣中心
天宝8.8级丝杆牙条
￥143.0000
利民标准件
天宝镀锌丝杆牙条
￥117.0000
利民标准件
浙江晋悦丝杆牙条
￥149.5000
利民标准件
35CrMO 丝杆 全螺纹 宁波
￥294.0000
福州喜力德标准紧固件有限公司
牙条 发黑 元立牌
￥81.6376
我的五金超市
牙条 本色 元立牌
￥30.1240
我的五金超市
镀锌牙条 兄弟牌 （整件）
￥140.0000
福州喜力德标准紧固件有限公司
接头
￥0.1540
福州喜力德标准紧固件有限公司
共44个 1 2 3 下一页
合作伙伴：
会员服务 广告服务 商务合作 服务条款 法律申明 隐私保护 意见反馈 帮助中心 网站地图 联系我们

Copyright © 2014-2015 All Rights Reserved

我的五金网 宁波紧联德供应链管理有限公司 版权所有 ICP许可证编号:浙ICP备17000445号-1

浙公网安备 33021102000534号