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 ('210','211','212','213','214','217','294','295','296','357','359','360','361','362','365','366','367','369','370','371','411','412','413','438','440','441','442','785','932','933','934','935','936','937','938','990','991','992','994','997','1645','1699','1702','1703','1719','1762','1763','1765','1770','1773','1788','1790','1792','1793','1796','1798','1800','2007','2692','3599','4150','4151','4152','4153','4154','4155','4156','4157','4158','4159','4767','4770','4777','4786','4787','4789','4790','4791','4793','4795','4796','5918','5921','5922','5924','5925','5928','5929','5932','6275','6276','6277','6278','6279','6280','6281','6282','6336','6337','6339','6340','6353','6355','7609','7750','7965','7966','7967','8063','8065','8066','8067','8068','8069','8070','8071','8365','9752','9753','9754','9755','9756','9757','9758','9759','9760','9761','9762','9763','9764','9765','9997','9998','9999','10000','10011','10033','10051','10055','10058','10068','10069','10070','10071','10072','10104','10252','10255','10256','10257','10258','10259','10260','10261','10262','10353','10358','10435','10436','10437','10440','10452','10574','10577','10699','10751','10812','10823','10867','10868','10871','10872','10873','10874','10875','10893','10894','10895','10896','10941','10943','10946','10947','10950','10952','10956','10960','10963','11080','11179','11181','11183','11184','11185','11186','11187','11192','11193','11194','11196','11197','11198','11199','11200','11201','11202','11203','11204','13464','13465','14448','14449','14450','14453','14454','14455','14456','14457','14458','14460','14461','14462','14464','14738','14739','14740','14741','14744','14748','14749','14772','14827','14849','14932','14933','15007','15008','15009','15010','15011','15012','15013','15035','15037','15038','15039','15040','15041','15043','15044','15099','15100','15125','15126','15127','15128','15132','15133','15140','15141','15142','15143','15174','15176','15187','15190','15192','15756','15774','15775','15777','15778','15779','15780','15782','15783','15889','15892','15963','15964','15965','15966','15967','15968','15969','15970','15971','15972','16101','16102','16103','16104','16105','16106','16108','16109','16110','16111','16112','16113','16114','16115','16116','16117','16119','16120','16125','16323','16324','16325','16326','16327','16328','16329','16330','16331','16333','16334','16335','16336','16337','16338','16339','16340','16341','16342','16343','16344','16345','16346','16347','16348','16349','16351','16352','16353','17193','17194','17195','17196','17197','17198','17199','17200','17201','17202','17207','17248','17258','17259','17260','17261','17262','17263','17264','17356','17357','17358','17364','17365','17366','17367','17375','17418','17419','17420','17421','17423','17424','17425','17426','17427','17473','17474','17475','17477','17478','17479','17482','17483','17509','17570','17600','17627','17628','17629','17630','17631','17633','17634','17635','17636','17871','17891','17902','17916','17921','17991','17992','17993','18000','18001','18002','18221','18315','18317','18320','18322','18323','18331','18332','18333','18334','18335','18338','18339','18340','18345','18346','18347','18348','18349','18350','18351','18352','18353','18354','18355') ) 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,1201,1174,551,534,0) , g.store_sort asc LIMIT 0,16
搜索商品 - 我的五金商城-MRO工业品一站式购销服务平台！
