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 ('234','247','262','269','270','272','273','274','277','1086','1094','1220','2469','2482','2483','2530','2531','2532','2533','2534','2542','2543','2545','2546','2557','2558','2559','2561','2563','2564','2565','2882','2883','2885','2886','3013','3015','3016','3018','3019','3020','3021','3025','3027','3028','3029','3546','3547','3548','3550','3551','3552','3553','3554','3555','3556','3557','3558','3559','3560','3562','3563','3564','3565','3566','3567','3568','3569','3570','3577','3578','3579','3580','3581','3582','4032','4033','4105','4106','4107','4108','4109','4110','4111','4112','4113','4114','4115','4199','4200','4201','4203','4205','4206','4207','4208','4209','4210','6285','6286','7662','7663','7665','7666','7669','7672','7677','7864','7865','7866','7867','7868','7882','7883','9499','10100','10101','10282','10283','10284','10289','10290','10291','10292','11049','11050','11051','11052','11053','11055','11056','11057','11059','11060','11061','11062','11064','11065','11066','11067','11068','11069','11100','12616','12617','12618','12619','12964','12965','12966','12967','12968','12969','12970','12971','12972','12973','12974','12976','12977','12978','12979','12980','12989','12990','12992','13036','13037','13436','13437','13438') ) 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,1382,1378,807,802,1308,705,805,803,4089,4091,4090,4092,0) , g.store_sort asc LIMIT 0,16 搜索商品 - 我的五金商城-MRO工业品一站式购销服务平台！
首页 所有分类

所有类目

劳保、安防、标识

紧固件

工具、量具和刃具

建筑五金、装饰材料

机械部件及相关产品

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

公用设施相关产品

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

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

泵、阀、管及管路附件

焊接材料与设备

橡胶制品系列

五金生活馆

特卖品

推广商品

点珠手套 劳保手套 点珠纱线手套
￥21.0000
我的五金超市
纱手套 700克足重
￥8.0000
我的五金超市
闽辉550克花纱手套
￥11.4000
我的五金超市
闽辉600克白纱手套
￥19.0000
我的五金超市
闽焰550克花纱手套
￥11.4000
我的五金超市
闽焰600G花纱手套
￥12.4000
我的五金超市
闽焰700G花纱手套
￥14.0000
我的五金超市
闽焰PVC半挂手套
￥24.0000
我的五金超市
黄色纱手套 劳保手套
￥18.7500
我的五金超市
白纱手套 漂白 800克 700克-巨轮
￥19.6000
我的五金超市
白纱手套 漂白 800克 700克-巨轮
￥10.8000
我的五金超市
纱手套 600克足重
￥7.0000
我的五金超市
劳保手套 花纱手套
￥8.0000
我的五金超市
纱手套 本白 劳保手套
￥6.0000
我的五金超市
波斯工具 高档乙炔管
￥219.9852
我的五金超市
波斯工具 高档氧气管
￥234.3492
我的五金超市
共43个 1 2 3 下一页
合作伙伴：
会员服务 广告服务 商务合作 服务条款 法律申明 隐私保护 意见反馈 帮助中心 网站地图 联系我们

Copyright © 2014-2015 All Rights Reserved

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

浙公网安备 33021102000534号