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 ('218','315','436','437','443','509','562','564','576','601','675','676','1555','1558','1562','1615','1616','1617','1618','1619','1620','1700','1701','1725','2499','3067','3068','3074','3076','3078','3079','3080','3382','3383','3385','3388','3389','3390','3394','3600','3616','6138','6139','6140','6141','6371','7344','8059','8060','8061','8062','8138','8139','8140','8141','10026','10029','10030','10035','10036','10222','10320','10370','10572','10596','10597','10598','10843','10844','10951','10953','10955','11096','11097','11235','11364','11365','11366','11372','11373','11374','11381','11383','11384','11490','11491','11492','11493','11494','11778','11887','13786','13812','13813','14440','14444','14716','14717','14720','14788','14905','14908','14909','14925','14926','15032','15033','15045','15046','15047','15123','15134','15135','15136','15232','15267','15268','15284','15654','15690','15692','15868','15869','16139','16485','16487','16488','17189','17190','17203','17204','17205','17252','17254','17268','17269','17270','17272','17273','17274','17360','17368','17378','17388','17445','17464','17486','17488','17514','17522','17532','17620','17747','17751','17765','17770','17789','17810','17816','17872','17874','17875','17897','17917','17918','17920','17970','17971','17989','17990','18093','18240','18287','18342') ) 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,1682,657,1227,1333,1231,1228,486,1229,537,0) , g.store_sort asc LIMIT 0,16 搜索商品 - 我的五金商城-MRO工业品一站式购销服务平台！

您好, 游客登录注册

福州市

切换城市

去购物车结算

0

所有类目

劳保、安防、标识

紧固件

工具、量具和刃具

建筑五金、装饰材料

机械部件及相关产品

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

公用设施相关产品

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

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

泵、阀、管及管路附件

焊接材料与设备

橡胶制品系列

五金生活馆

特卖品

滞销产品

推广商品

商品筛选

(共51个商品)

点击查看更多

仅显示特卖品

1/4上一页下一页

弹簧垫圈镀锌

￥295.7402

新昌兴贸易有限公司

GB97 4级平垫镀兰

￥59.1192

福建泰恒天翔实业有限公司

揭阳镀锌平垫

￥397.6000

福州喜力德标准紧固件有限公司

揭阳镀锌加大平垫

￥336.0000

福州喜力德标准紧固件有限公司

测试——方垫

￥9.0900

测试店铺

GB93 8级弹垫发黑上海哈迪威

￥108.8640

福建泰恒天翔实业有限公司

GB93 4级弹垫镀彩上海哈迪威

￥65.5200

福建泰恒天翔实业有限公司

GB93-76弹簧垫圈新星牌镀彩

￥257.8400

福州喜力德标准紧固件有限公司

GB93-76弹簧垫圈新星牌 /箫峰牌发黑

￥274.6590

福州喜力德标准紧固件有限公司

GB93-76弹簧垫圈新星牌镀彩

￥1140.7200

我的五金网福州分拣中心

GB93-76弹簧垫圈新星牌蓝白锌

￥1140.7200

我的五金网福州分拣中心

GB93-76弹簧垫圈新星牌中誉牌发黑

￥999.6000

我的五金网福州分拣中心

超凡牌镀锌加大平垫

￥312.0000

超凡膨胀螺栓

超凡牌镀锌平垫

￥249.0000

超凡膨胀螺栓

超凡牌镀锌四方垫

￥312.0000

超凡膨胀螺栓

GB1230 平垫圈金力牌（散装）

￥0.1950

南昌赣固实业有限责任公司

共51个 1 2 3 4 下一页

合作伙伴：

会员服务广告服务商务合作服务条款法律申明隐私保护意见反馈帮助中心网站地图联系我们

Copyright © 2014-2015 All Rights Reserved

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

浙公网安备 33021102000534号