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 ('1318','1324','1339','1340','1341','1343','1345','1352','1356','1357','1358','1359','1360','1371','1375','1376','1378','1379','1380','1381','1384','1385','1386','1388','1390','1391','1394','1395','1396','1409','1412','1413','1456','1467','1482','1494','1500','1531','1534','1545','1547','1548','1550','1560','1568','1577','1584','1598','1610','1625','1629','1632','1633','1635','1636','1643','1644','1646','1648','1667','1671','1677','1678','1679','1680','1684','1686','1691','1692','1696','1709','1721','2250','2252','2256','2280','2281','2282','2284','2326','2332','2335','2342','2346','2348','2370','2379','2385','2449','2960','2961','2962','2963','5669','5710','5711','5713','5714','6933','6934','6935','6936','6945','6946','6947','6948','7098','7101','8413','8414','8415','8416','8425','8426','8427','8428','9256','9257','9258','9259','9280','9903','12569','12570','12571','12572','12818','12834','12835','12837','12838','12839','12840','12841','12842','12843','12868','12869','12870','12871','12882','12883','12884','13988','13989','14067','14068','14069','14070','14071','14072','14073','14074','14075','14076','14077','14078','14079','14080','14081','14082') ) 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,1477,1479,1481,1456,1486,1480,1483,1485,1488,2118,2119,2121) , g.store_sort asc LIMIT 0,16 搜索商品 - 我的五金商城-MRO工业品一站式购销服务平台！

您好, 游客登录注册

福州市

切换城市

去购物车结算

0

所有类目

劳保、安防、标识

紧固件

工具、量具和刃具

建筑五金、装饰材料

机械部件及相关产品

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

公用设施相关产品

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

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

泵、阀、管及管路附件

焊接材料与设备

橡胶制品系列

五金生活馆

特卖品

滞销产品

推广商品

商品筛选

(共60个商品)

点击查看更多

仅显示特卖品

1/4上一页下一页

世达重型管子钳

￥54.7560

我的五金超市

世达铝合金管子钳

￥104.1120

我的五金超市

世达伸缩式加力管子钳

￥289.4400

我的五金超市

科信牌专业级重型美式管钳

￥631.2000

我的五金超市

科信牌工业级美式管钳

￥1004.4400

我的五金超市

科信牌重型美式管钳

￥642.2000

我的五金超市

科信牌英式管钳

￥208.0000

我的五金超市

波斯工具重型管子钳（沾塑柄）

￥32.3136

我的五金超市

波斯工具鹰嘴管子钳

￥116.6400

我的五金超市

波斯工具快速管子钳

￥123.8328

我的五金超市

高档水泵钳

￥24.0000

福州凯盛机电设备有限公司

高档水泵钳

￥64.0000

我的五金超市

波斯工具多用水泵钳

￥60.0156

我的五金超市

波斯工具高档机磨水泵钳

￥53.5788

我的五金超市

波斯工具镍铁合金水泵钳

￥22.1400

我的五金超市

波斯工具快速调节水泵钳

￥79.3800

我的五金超市

共60个 1 2 3 4 下一页

合作伙伴：

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

Copyright © 2014-2015 All Rights Reserved

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

浙公网安备 33021102000534号