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 ('523','2552','3544','3545','3573','4142','4143','4144','4145','5089','5890','5895','5907','5912','5913','5914','5915','5916','5917','5919','5920','5923','5926','5927','5933','5934','5935','5936','5937','5938','5939','5940','5941','5943','5944','5945','5970','5971','5972','5989','5990','5992','5993','5994','5995','5996','5997','5998','5999','6000','6001','6009','6020','6021','6022','6023','6034','6035','6087','6218','6222','6252','6284','7030','7130','7216','7295','7296','7297','7298','7299','7300','7301','7306','7307','7308','7309','7310','7311','7560','7561','7627','7628','7629','7630','7631','7632','7633','7634','7636','7637','7638','7644','7645','7646','7647','7685','9497','9498','9797','9820','9821','9829','9830','9831','9832','9843','9850','9919','10271','10272','10273','10274','10275','10276','10277','10287','10314','10315','10327','10373','10376','10379','10382','10405','10838','11045','11046','11082','11083','11780','11781','11782','11783','11784','11785','11786','11787','11788','11789','11790','11791','11792','11793','11794','11805','11806','11807','11832','11833','11834','11836','11837','11838','11839','11840','11841','11842','11843','11844','11845','11846','11847','11848','11849','11850','11851','11852','11853','11854','11855','11857','11858','12371','12373','12374','12375','12376','12377','12378','12379','12380','12381','12382','12383','12384','12385','12412','12422','12782','13713','13714','13715','15138','15139') ) 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,918,682,917,912,919,921,920,607,872,532) , g.store_sort asc LIMIT 96,16 搜索商品 - 我的五金商城-MRO工业品一站式购销服务平台！
首页 所有分类

所有类目

劳保、安防、标识

紧固件

工具、量具和刃具

建筑五金、装饰材料

机械部件及相关产品

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

公用设施相关产品

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

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

泵、阀、管及管路附件

焊接材料与设备

橡胶制品系列

五金生活馆

特卖品

推广商品

邦特 铝箔布胶带
￥8.3200
福州兴恒晟保温材料有限公司
邦特 铝箔胶带
￥4.1600
福州兴恒晟保温材料有限公司
邦特 橡塑胶带
￥3.6400
福州兴恒晟保温材料有限公司
邦特 铝箔布加胶带
￥603.2000
福州兴恒晟保温材料有限公司
邦特 铝箔布加胶带
￥1206.4000
我的五金超市
邦特 橡塑胶带
￥7.2800
我的五金超市
邦特 铝箔胶带
￥14.5000
我的五金超市
邦特 铝箔布胶带
￥20.8000
我的五金超市
邦特 铝箔布加胶带
￥603.2000
我的五金超市
普通美纹纸胶带-金广大
￥1.6900
我的五金超市
加厚美纹纸胶带-金广大
￥2.6000
我的五金超市
进口美纹纸 和纸美纹纸胶带 遮蔽胶纸 喷漆专用耐高...
￥1.9500
我的五金超市
红膜汽车海绵胶-金广大
￥3.1200
我的五金超市
耐高温阻焊胶带（金手指）-金广大
￥13.6500
我的五金超市
EVA海绵胶带-金广大
￥1.5600
我的五金超市
铝箔胶带-金广大
￥4.5500
我的五金超市
共141个 上一页 1 .. 5 6 7 8 9 下一页
合作伙伴：
会员服务 广告服务 商务合作 服务条款 法律申明 隐私保护 意见反馈 帮助中心 网站地图 联系我们

Copyright © 2014-2015 All Rights Reserved

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

浙公网安备 33021102000534号