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 ('232','326','327','328','329','330','332','333','351','355','356','358','364','368','373','375','376','380','381','384','388','390','391','401','403','405','406','407','537','581','583','705','708','754','755','1444','1543','1544','1600','1604','1606','1607','1608','1609','1624','1626','1627','1628','1771','1772','1821','1822','1866','1867','1868','1869','1870','1871','1872','2500','2571','2983','2986','2989','2992','2993','2994','3017','3034','3039','3042','3045','3047','3060','3061','3062','3063','3064','3065','3066','3219','3224','3225','3339','3348','3349','3350','3351','3352','3362','3364','3366','3367','3368','3369','3370','3373','3374','3375','3377','3378','3379','4072','4073','4074','4075','5253','6166','6167','6168','6169','6170','6309','6366','6367','6368','6441','7276','7312','7313','7314','7315','7316','7333','7998','7999','8000','8001','8020','8021','8022','8051','8052','8053','8054','8055','8077','8078','8079','8164','9955','9970','9988','9989','9992','9993','10019','10226','10231','10233','10651','10652','10653','10655','10656','10657','10658','10659','10660','10662','10663','10664','10665','10666','10704','10966','10968','10969','10970','10972','10975','10977','10984','11313','11337','11339','11340','11341','11342','11343','11344','11346','11347','11398','11399','11449','11450','11451','11452','11453','11454','11455','11456','11457','11458','11459','11460','11461','11462','11463','11464','11465','11466','11650','11859','11885','11886','11889','14092','14093','14094','14130','14443','14898','14901','14904','14906','14910','14944','15018','15048','15049','15050','15051','15052','15137','15322','15323','15324','15325','15326','15327','15328','15329','15330','15331','15696','15697','15698','15699','15700','15701','15702','15703','15705','15706','15707','15974','15975','15976','15981','15982','15985','15987','15994','15995','15996','15997','16445','16447','16448','16449','16450','16451','16452','16453','16454','16455','16456','16460','16461','16462','16466','16467','16468','16469','16471','16472','17179','17502','17518','17519','17761','17909','17910','17959','17995','17996','17997','17999','18004','18005','18006','18054','18062') ) 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,539,1683,1679,992,991,990,792,2315,1252,1245,740,751,731,1247,1243,486,1255,0,1192,1244) , g.store_sort asc LIMIT 32,16
搜索商品 - 我的五金商城-MRO工业品一站式购销服务平台！
