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 ('167','168','172','173','326','327','328','329','330','332','333','373','375','376','380','381','384','386','388','390','391','647','650','709','1361','1362','1363','1364','1365','1366','1367','1368','1369','1543','2078','3227','3228','3757','3758','3759','3760','3761','3762','3763','3764','3765','4926','4927','4930','4933','5250','5251','5252','6166','6167','6168','6169','6170','7302','7312','7313','7314','7315','7342','7975','7998','7999','8000','8001','8051','8052','8053','8054','8055','8075','8080','8081','8082','8083','10651','10652','10653','10654','10655','10656','10657','10658','10659','10660','10754','10969','10972','10975','10977','10984','11334','11335','11337','11339','11340','11341','11342','11343','11344','11346','11347','14092','14093','14094','14100','14443','14596','14884','14898','14901','14904','14906','14910','15048','15049','15050','15051','15052','15074','15322','15323','15324','15325','15326','15327','15328','15329','15330','15331','15396','15669','15671','15672','15675','15677','15678','15679','15680','15681','15689','15936','15938','15940','15941','15942','15952','15953','15954','15955','15956','15958','15959','15973','16473','16474','16475','16476','16477','16478','16479','16480','16481','16482','18249','18254') ) 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,540,992,991,990,792) , g.store_sort asc LIMIT 0,16 搜索商品 - 我的五金商城-MRO工业品一站式购销服务平台！

您好, 游客登录注册

福州市

切换城市

去购物车结算

0

所有类目

劳保、安防、标识

紧固件

工具、量具和刃具

建筑五金、装饰材料

机械部件及相关产品

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

公用设施相关产品

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

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

泵、阀、管及管路附件

焊接材料与设备

橡胶制品系列

五金生活馆

特卖品

滞销产品

推广商品

商品筛选

(共36个商品)

点击查看更多

仅显示特卖品

1/3上一页下一页

尼龙头六角法兰面自攻自钻螺钉镀彩振成牌灰白色尼...

￥454.0000

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

灰白色尼龙头六角法兰面自攻自钻螺钉镀彩振成牌

￥523.8000

我的五金网福州分拣中心

固帅国标钻尾自钻（按箱）

￥468.4400

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

固帅精装钻尾螺丝（按箱）

￥313.6000

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

固帅涂层钻尾5.5（按箱）

￥791.0000

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

固帅圆头十字钻尾（按箱）

￥621.6000

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

固帅圆头华司钻尾（按箱）

￥471.2400

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

M4.2 固帅沉头钻尾（箱装）

￥596.4000

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

M12 固帅精装钻尾螺丝（散装）

￥31.3600

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

十字槽盘头带介自钻自攻螺钉 PW带介大扁头自钻三光...

￥672.0000

建帝五金

GB15856.1-2002 十字槽盘头自钻自攻螺钉三光牌P圆...

￥775.2000

建帝五金

GB15856.2-2002 十字槽沉头自钻自攻螺钉三光牌平...

￥840.0000

建帝五金

六角法兰面自钻自攻螺钉三光自钻

￥408.0000

建帝五金

GB15856.4-2002 六角法兰面自钻自攻螺钉建帝牌国标...

￥432.0000

建帝五金

￥2.0000

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

十字槽盘头带介自钻自攻螺钉雷电

￥448.0000

源头好货厂家直销店

共36个 1 2 3 下一页

合作伙伴：

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

Copyright © 2014-2015 All Rights Reserved

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

浙公网安备 33021102000534号