1.UPC 2021整年年的数据 核对数据并设置沃尔玛京东国际两个平台已使用
统计截至到目前8560清除品牌池服务，服务截至到目前执行的所有类目和mysql凤凰计划中的当前实时已设置类目，用于比较
相关sql:
select b.OrderSourceId as '渠道ID',o.OrderSourceName as '渠道名称',b.BrowsePathById as '一级类目ID'
from apx_ordersource_browsenode b
INNER JOIN apx_brand_ordersource o on b.CustomerId =o.CustomerId and b.OrderSourceId=o.OrderSourceId
where b.CustomerId=1 and b.IsDelete=0 and o.IsEnable=1 and b.BrowsePathById !='' order by b.OrderSourceId
declare @F_Node table (
Country varchar(50), FirstBrowsePathByID varchar(200),BrowseNodeNameCn nvarchar(200),BrowsePathByName nvarchar(200) ) insert into @F_Node(Country,FirstBrowsePathByID,BrowseNodeNameCn,BrowsePathByName) values (N'AU',N'5547635051,5547636051',N'食品储藏室食品和饮料',N'Pantry Food & Drinks'), (N'AU',N'4852445051,4852446051',N'文具和办公产品',N'Stationery & Office Products'), (N'AU',N'4851453051,4851454051',N'汽车',N'Automotive'), (N'AU',N'4852207051,4852208051',N'照明',N'Lighting'), (N'AU',N'4852387051,4852388051',N'乐器',N'Musical Instruments'), (N'AU',N'4851567051,4851568051',N'美',N'Beauty'), (N'AU',N'4851683051,4851684051',N'计算机',N'Computers'), (N'AU',N'5653743051,5653744051',N'花园',N'Garden'), (N'AU',N'4851975051,4851976051',N'家',N'Home'), (N'AU',N'4852150051,4852151051',N'厨房和餐厅',N'Kitchen & Dining'), (N'BE',N'27156849031,27156850031',N'杂货店',N'Épicerie'), (N'BE',N'27157903031,27157904031',N'宠物店',N'Animalerie'), (N'BE',N'27155906031,27155907031',N'婴儿和儿童保育',N'Bébé et Puériculture'), (N'BE',N'27157786031,27157787031',N'办公用品',N'Fournitures de bureau'), (N'BE',N'27158020031,27158021031',N'软件',N'Logiciels'), (N'BE',N'27156608031,27156609031',N'花园',N'Jardin'), (N'BE',N'27156257031,27156258031',N'高科技',N'High-tech'), (N'BE',N'27157084031,27157085031',N'厨房和房子',N'Cuisine et maison'), (N'BE',N'27155784031,27155785031',N'汽车和摩托车',N'Auto et moto'), (N'BE',N'27158137031,27158138031',N'运动和户外',N'Sports et plein air'), (N'BE',N'27157201031,27157202031',N'DIY',N'Bricolage'), (N'BE',N'27155667031,27155668031',N'创意休闲',N'Loisirs créatifs'), (N'CA',N'667823011,677211011',N'电子学',N'Electronics'), (N'CA',N'16708697011,16708698011',N'手工制作',N'Handmade'), (N'CA',N'3006902011,3006903011',N'工具和家居装修',N'Tools & Home Improvement'), (N'CA',N'3561346011,3561347011',N'宝贝',N'Baby'), (N'CA',N'6916844011,6916845011',N'乐器、舞台和工作室',N'Musical Instruments, Stage & Studio'), (N'CA',N'11076213011,11076214011',N'工业与科学',N'Industrial & Scientific'), (N'AU',N'5514967051,5514968051',N'宠物用品',N'Pet Supplies'), (N'AU',N'4852559051,4852560051',N'运动、健身和户外运动',N'Sports, Fitness & Outdoors'), (N'AU',N'4852617051,4852618051',N'玩具和游戏',N'Toys & Games'), (N'AU',N'4851510051,4851511051',N'宝贝',N'Baby'), (N'AU',N'4851856051,4851857051',N'服装、鞋子和配饰',N'Clothing, Shoes & Accessories'), (N'AU',N'4851799051,4851800051',N'电子学',N'Electronics'), (N'AU',N'4851917051,4851918051',N'健康、家庭和个人护理',N'Health, Household & Personal Care'), (N'AU',N'4852033051,4852034051',N'家居装修',N'Home Improvement'), (N'BE',N'27158254031,27158255031',N'玩具',N'Jouets'), (N'BE',N'27156491031,27156492031',N'时尚',N'Mode'), (N'BE',N'27156023031,27156024031',N'美容和香水',N'Beauté et Parfum'), (N'BE',N'27157669031,27157670031',N'乐器',N'Instruments de musique'), (N'BE',N'27156967031,27156968031',N'卫生与健康',N'Hygiène et Santé'), (N'BE',N'27157318031,27157319031',N'工业与科学',N'Industrie et science'), (N'CA',N'6205511011,6205512011',N'办公产品',N'Office Products'), (N'CA',N'6205177011,6205178011',N'健康与个人护理',N'Health & Personal Care'), (N'CA',N'2206275011,2206276011',N'家庭和厨房',N'Home & Kitchen'), (N'CA',N'2242989011,2242990011',N'运动与户外',N'Sports & Outdoors'), (N'DE',N'10925031,10925241',N'花园',N'Garten'), (N'DE',N'3167641,3169011',N'厨房、家庭和家庭',N'Küche, Haushalt & Wohnen'), (N'DE',N'64187031,64257031',N'药店和个人护理',N'Drogerie & Körperpflege'), (N'DE',N'213083031,213084031',N'照明',N'Beleuchtung'), (N'DE',N'80084031,80085031',N'五金店',N'Baumarkt'), (N'DE',N'562066,569604',N'电子与照片',N'Elektronik & Foto'), (N'DE',N'9699311031,9699312031',N'手工产品',N'Handmade Produkte'), (N'DE',N'355007011,357577011',N'宝贝',N'Baby'), (N'DE',N'11961464031,11961465031',N'时尚',N'Fashion'), (N'ES',N'3628866031,3628867031',N'乐器',N'Instrumentos musicales'), (N'ES',N'599370031,599371031',N'电子',N'Electrónica'), (N'ES',N'5866088031,5866089031',N'工业、商业和科学',N'Industria, empresas y ciencia'), (N'ES',N'5512276031,5512277031',N'时尚',N'Moda'), (N'ES',N'4772050031,4772051031',N'大型家电',N'Grandes electrodomésticos'), (N'ES',N'3564289031,3564290031',N'照明',N'Iluminación'), (N'ES',N'1703495031,1703496031',N'宝贝',N'Bebé'), (N'ES',N'3628728031,3628729031',N'办公室和文具',N'Oficina y papelería'), (N'FR',N'1571265031,1571266031',N'汽车和摩托车',N'Auto et Moto'), (N'FR',N'11961521031,11961522031',N'时尚',N'Mode'), (N'FR',N'197861031,197862031',N'卫生与健康',N'Hygiène et Santé'), (N'FR',N'322086011,322088011',N'游戏和玩具',N'Jeux et Jouets'), (N'FR',N'206617031,206618031',N'婴儿和儿童保育',N'Bébé et Puériculture'), (N'FR',N'192419031,192420031',N'办公用品',N'Fournitures de bureau'), (N'FR',N'325614031,325615031',N'运动和休闲',N'Sports et Loisirs'), (N'CA',N'6948389011,6948390011',N'汽车',N'Automotive'), (N'CA',N'6205499011,6299024011',N'露台、草坪和花园',N'Patio, Lawn & Garden'), (N'CA',N'21204935011,21204936011',N'服装、鞋子和配饰',N'Clothing, Shoes & Accessories'), (N'CA',N'6205517011,6205518011',N'玩具和游戏',N'Toys & Games'), (N'CA',N'6205124011,6205125011',N'美容与个人护理',N'Beauty & Personal Care'), (N'CA',N'6205514011,6291628011',N'宠物用品',N'Pet Supplies'), (N'DE',N'5866098031,5866099031',N'商业、工业和科学',N'Gewerbe, Industrie & Wissenschaft'), (N'DE',N'340849031,340850031',N'乐器和DJ设备',N'Musikinstrumente & DJ-Equipment'), (N'DE',N'340852031,340853031',N'宠物',N'Haustier'), (N'DE',N'78191031,79899031',N'汽车和摩托车',N'Auto & Motorrad'), (N'DE',N'908823031,908824031',N'大型电气设备',N'Elektro-Großgeräte'), (N'DE',N'340843031,340844031',N'电脑及配件',N'Computer & Zubehör'), (N'DE',N'192416031,192417031',N'办公用品和文具',N'Bürobedarf & Schreibwaren'), (N'DE',N'12950651,12950661',N'玩具',N'Spielzeug'), (N'DE',N'16435051,16435121',N'运动与休闲',N'Sport & Freizeit'), (N'DE',N'84230031,84231031',N'化妆品',N'Kosmetik'), (N'ES',N'1571259031,1571260031',N'花园',N'Jardín'), (N'ES',N'3677430031,3677431031',N'健康和个人护理',N'Salud y cuidado personal'), (N'ES',N'2454136031,2665403031',N'运动和户外',N'Deportes y aire libre'), (N'ES',N'1951051031,1951052031',N'汽车和摩托车',N'Coche y moto'), (N'ES',N'6198054031,6198055031',N'美女',N'Belleza'), (N'ES',N'2454133031,2454134031',N'DIY和工具',N'Bricolaje y herramientas'), (N'ES',N'599391031,599392031',N'家庭和厨房',N'Hogar y cocina'), (N'ES',N'599385031,599386031',N'玩具和游戏',N'Juguetes y juegos'), (N'ES',N'9699482031,9699483031',N'Handmde产品',N'Productos Handmade'), (N'ES',N'667049031,667050031',N'计算机科学',N'Informática'), (N'FR',N'57004031,57686031',N'厨房和房子',N'Cuisine et Maison'), (N'FR',N'340858031,340859031',N'计算机科学',N'Informatique'), (N'FR',N'3557027031,3557028031',N'花园',N'Jardin'), (N'FR',N'9699368031,9699369031',N'手工制作的产品',N'Produits Handmade'), (N'FR',N'340861031,340862031',N'乐器和索诺',N'Instruments de musique et Sono'), (N'FR',N'1571268031,1571269031',N'宠物店',N'Animalerie'), (N'FR',N'213080031,213081031',N'照明和照明',N'Luminaires et Éclairage'), (N'FR',N'197858031,197859031',N'美容和香水',N'Beauté et Parfum'), (N'FR',N'13921051,13910671',N'高科技',N'High-Tech'), (N'FR',N'590748031,590749031',N'DIY',N'Bricolage'), (N'FR',N'908826031,908827031',N'大型家电',N'Gros électroménager'), (N'FR',N'5866109031,5866110031',N'商业、工业和科学',N'Commerce, Industrie et Science'), (N'GB',N'117332031,117333031',N'美',N'Beauty'), (N'GB',N'213077031,213078031',N'照明',N'Lighting'), (N'GB',N'340840031,340841031',N'宠物用品',N'Pet Supplies'), (N'AE',N'15149780031,15149781031',N'电器',N'Appliances'), (N'AE',N'15149837031,15149838031',N'工艺美术',N'Arts & Crafts'), (N'AE',N'15150065031,15150066031',N'工业与科学',N'Industrial & Scientific'), (N'AE',N'11601326031,11601327031',N'电子学',N'Electronics'), (N'AE',N'11498087031,11498088031',N'婴儿用品',N'Baby Products'), (N'AE',N'11497859031,11497860031',N'美',N'Beauty'), (N'AE',N'15149894031,15149895031',N'露台、草坪和花园',N'Patio, Lawn & Garden'), (N'AE',N'11601212031,11601213031',N'体育用品',N'Sporting Goods'), (N'AE',N'15150236031,15150237031',N'乐器',N'Musical Instruments'), (N'BR',N'16957239011,16957240011',N'文具和办公室',N'Papelaria e Escritório'), (N'BR',N'16215417011,16215418011',N'健康与福利',N'Saúde e Bem-Estar'), (N'BR',N'17242603011,17242604011',N'婴儿',N'Bebês'), (N'BR',N'16194299011,16194300011',N'玩具与游戏',N'Brinquedos e Jogos'), (N'BR',N'16191000011,16191001011',N'家',N'Casa'), (N'BR',N'16957125011,16957126011',N'厨房',N'Cozinha'), (N'BR',N'16522082011,16522083011',N'家电',N'Eletrodomésticos'), (N'BR',N'16957182011,16957183011',N'建筑工具和材料',N'Ferramentas e Materiais de Construção'), (N'BR',N'18991252011,18991253011',N'乐器',N'Instrumentos Musicais'), (N'BR',N'17349396011,17349397011',N'运动,冒险和休闲',N'Esporte, Aventura e Lazer'), (N'JP',N'3445393051,3445394051',N'产业 · 研究开发用品',N'産業・研究開発用品'), (N'JP',N'2016929051,2016930051',N'DIY工具花园',N'DIY・工具・ガーデン'), (N'JP',N'52374051,52391051',N'美女美女',N'ビューティー'), (N'JP',N'13299531,13299551',N'玩具',N'おもちゃ'), (N'JP',N'344845011,344919011',N'婴儿与马塔尼蒂',N'ベビー＆マタニティ'), (N'JP',N'2123629051,2123630051',N'乐器、音响设备',N'楽器・音響機器'), (N'JP',N'2229202051,2229203051',N'时尚',N'ファッション'), (N'MX',N'11260452011,11260453011',N'美女',N'Belleza'), (N'MX',N'9482660011,9482661011',N'运动和户外',N'Deportes y Aire libre'), (N'MX',N'9482610011,9482611011',N'健康和个人护理',N'Salud y Cuidado Personal'), (N'MX',N'9673844011,9673845011',N'办公室和文具',N'Oficina y Papelería'), (N'MX',N'9482593011,9482594011',N'家庭和厨房',N'Hogar y Cocina'), (N'PL',N'20659309031,20659310031',N'宠物用品',N'Artykuły dla zwierząt'), (N'PL',N'20658154031,20658155031',N'家庭和厨房',N'Dom i kuchnia'), (N'PL',N'20656961031,20656962031',N'汽车',N'Motoryzacja'), (N'GB',N'65801031,66280031',N'健康与个人护理',N'Health & Personal Care'), (N'GB',N'908798031,908799031',N'大型电器',N'Large Appliances'), (N'GB',N'3146281,11052591,11052671,10709021',N'花园和户外',N'Garden & Outdoors'), (N'GB',N'59624031,60032031',N'婴儿用品',N'Baby Products'), (N'GB',N'318949011,319530011',N'运动与户外',N'Sports & Outdoors'), (N'AE',N'11497916031,11497917031',N'家',N'Home'), (N'AE',N'11497973031,11497974031',N'厨房',N'Kitchen'), (N'AE',N'11497745031,11497746031',N'计算机',N'Computers'), (N'AE',N'11601269031,11601270031',N'工具和家居装修',N'Tools & Home Improvement'), (N'AE',N'11498030031,11498031031',N'汽车',N'Automotive'), (N'AE',N'15150350031,15150351031',N'办公产品',N'Office Products'), (N'AE',N'15150407031,15150408031',N'宠物用品',N'Pet Supplies'), (N'AE',N'11601440031,11601441031',N'健康',N'Health'), (N'AE',N'12421861031,12421862031',N'照明',N'Lighting'), (N'AE',N'11497631031,11497632031',N'时尚',N'Fashion'), (N'AE',N'11497802031,11497803031',N'玩具',N'Toys'), (N'BR',N'18991136011,18991137011',N'宠物店',N'Pet Shop'), (N'BR',N'18991195011,18991196011',N'工业和科学产品',N'Produtos Industriais e Científicos'), (N'BR',N'17365811011,17365812011',N'时尚',N'Moda'), (N'BR',N'18914209011,18914210011',N'汽车',N'Automotivo'), (N'BR',N'16194414011,16194415011',N'美',N'Beleza'), (N'BR',N'16339926011,16339927011',N'计算机和计算机',N'Computadores e Informática'), (N'BR',N'16209062011,16209063011',N'电子与技术',N'Eletrônicos e Tecnologia'), (N'BR',N'18991021011,18991022011',N'花园和游泳池',N'Jardim e Piscina'), (N'JP',N'3210981,3210991',N'家电 & 照相机',N'家電＆カメラ'), (N'JP',N'2127209051,2127210051',N'电脑、外围设备',N'パソコン・周辺機器'), (N'JP',N'2277724051,2277725051',N'大型家电',N'大型家電'), (N'JP',N'2017304051,2017305051',N'汽车 & 摩托车',N'車＆バイク'), (N'JP',N'2127212051,2127213051',N'宠物用品',N'ペット用品'), (N'JP',N'160384011,161669011',N'药妆店',N'ドラッグストア'), (N'JP',N'14304371,14315361',N'体育与户外运动',N'スポーツ＆アウトドア'), (N'JP',N'2277721051,2277722051',N'霍比',N'ホビー'), (N'JP',N'86731051,86732051',N'文具、办公室用品',N'文房具・オフィス用品'), (N'JP',N'3828871,3839151',N'家庭和厨房',N'ホーム＆キッチン'), (N'JP',N'637394,637872',N'游戏',N'ゲーム'), (N'MX',N'9482670011,9482671011',N'工具和家装',N'Herramientas y Mejoras del Hogar'), (N'MX',N'16566964011,16566965011',N'Handmde产品',N'Productos Handmade'), (N'MX',N'11260442011,11260443011',N'玩具和游戏',N'Juguetes y Juegos'), (N'MX',N'16215357011,16215358011',N'花园',N'Jardín'), (N'MX',N'9482650011,9482651011',N'宝贝',N'Bebé'), (N'MX',N'13848858011,13848859011',N'乐器',N'Instrumentos Musicales'), (N'MX',N'11782336011,11782337011',N'动物产品',N'Productos para animales'), (N'MX',N'13848838011,13848839011',N'服装、鞋履及配件',N'Ropa, Zapatos y Accesorios'), (N'MX',N'9482558011,9482559011',N'电子',N'Electrónicos'), (N'MX',N'11076223011,11076224011',N'工业,商业和科学',N'Industria, Empresas y Ciencia'), (N'MX',N'13848848011,13848849011',N'汽车和摩托车',N'Automotriz y Motocicletas'), (N'PL',N'20659660031,20659661031',N'玩具',N'Zabawki'), (N'PL',N'20659192031,20659193031',N'文具和办公室',N'Artykuły papiernicze i biurowe'), (N'PL',N'20657432031,20657433031',N'电子学',N'Elektronika'), (N'PL',N'20659075031,20659076031',N'乐器',N'Instrumenty muzyczne'), (N'PL',N'20657551031,20657552031',N'时尚',N'Moda'), (N'PL',N'20658607031,20658608031',N'工具和家庭装修',N'Narzędzia i renowacja domu'), (N'GB',N'560798,560800',N'电子与照片',N'Electronics & Photo'), (N'GB',N'248877031,248878031',N'汽车',N'Automotive'), (N'GB',N'9699254031,9699255031',N'手工产品',N'Handmade Products'), (N'GB',N'340831031,340832031',N'电脑及配件',N'Computers & Accessories'), (N'GB',N'340837031,340838031',N'乐器和DJ',N'Musical Instruments & DJ'), (N'GB',N'192413031,192414031',N'文具和办公用品',N'Stationery & Office Supplies'), (N'GB',N'5866054031,5866055031',N'商业、工业和科学',N'Business, Industry & Science'), (N'IN',N'1350387031,1350388031',N'手表',N'Watches'), (N'IN',N'2454172031,2454173031',N'办公产品',N'Office Products'), (N'IN',N'1984443031,1984444031',N'运动、健身和户外运动',N'Sports, Fitness & Outdoors'), (N'IN',N'13712257031,13712258031',N'收藏品和美术',N'Collectibles & Fine Art'), (N'IN',N'976419031,976420031',N'电子学',N'Electronics'), (N'IN',N'2454175031,2454176031',N'户外生活',N'Outdoor Living'), (N'IN',N'3704982031,3704983031',N'礼品卡',N'Gift Cards'), (N'IN',N'3677697031,3677698031',N'乐器',N'Musical Instruments'), (N'IN',N'1571271031,1571272031',N'服装及配件',N'Clothing & Accessories'), (N'IN',N'3704992031,3704993031',N'家居装修',N'Home Improvement'), (N'IN',N'1571274031,1571275031',N'宝贝',N'Baby'), (N'IN',N'976392031,976393031',N'电脑及配件',N'Computers & Accessories'), (N'IN',N'1355016031,1355017031',N'美',N'Beauty'), (N'IN',N'2454181031,4740420031',N'宠物用品',N'Pet Supplies'), (N'IT',N'1571280031,1571281031',N'汽车和摩托车',N'Auto e Moto'), (N'IT',N'3606310031,3606311031',N'文具和办公产品',N'Cancelleria e prodotti per ufficio'), (N'IT',N'524015031,524016031',N'家庭和厨房',N'Casa e cucina'), (N'IT',N'1571292031,1571293031',N'照明',N'Illuminazione'), (N'IT',N'635016031,635017031',N'花园和园艺',N'Giardino e giardinaggio'), (N'IT',N'12472499031,12472500031',N'宠物产品',N'Prodotti per animali domestici'), (N'IT',N'5512286031,5512287031',N'时尚',N'Moda'), (N'IT',N'14437356031,14437357031',N'大型电器',N'Grandi elettrodomestici'), (N'IT',N'425916031,425917031',N'计算机科学',N'Informatica'), (N'IT',N'524012031,524013031',N'运动与休闲',N'Sport e tempo libero'), (N'IT',N'5866068031,5866069031',N'商业、工业和科学',N'Commercio, Industria e Scienza'), (N'NL',N'16241927031,16241928031',N'花园、露台和草坪',N'Tuin, terras & gazon'), (N'NL',N'16242287031,16242288031',N'商业、工业和科学',N'Zakelijk, industrie & wetenschap'), (N'NL',N'16242171031,16242172031',N'健康与个人护理',N'Gezondheid & persoonlijke verzorging'), (N'NL',N'16242515031,16242516031',N'办公产品',N'Kantoorproducten'), (N'NL',N'16242686031,16242687031',N'运动与户外',N'Sport & outdoor'), (N'NL',N'16241607031,16241608031',N'汽车和摩托车',N'Auto & motor'), (N'NL',N'16241836031,16241837031',N'服装、鞋子和珠宝',N'Kleding, schoenen en sieraden'), (N'PL',N'20657669031,20657670031',N'花园',N'Ogród'), (N'GB',N'11961407031,11961408031',N'时尚',N'Fashion'), (N'GB',N'468292,595314',N'玩具和游戏',N'Toys & Games'), (N'GB',N'79903031,79904031',N'自制和工具',N'DIY & Tools'), (N'GB',N'3146281,11052591,11052681,3147411',N'家庭和厨房',N'Home & Kitchen'), (N'IN',N'6648217031,6648218031',N'时尚',N'Fashion'), (N'IN',N'1350380031,1350381031',N'玩具和游戏',N'Toys & Games'), (N'IN',N'1571283031,1571284031',N'鞋子和手袋',N'Shoes & Handbags'), (N'IN',N'1951048031,1951049031',N'珠宝',N'Jewellery'), (N'IN',N'976442031,976443031',N'家庭和厨房',N'Home & Kitchen'), (N'IN',N'4772060031,4772061031',N'汽车和摩托车',N'Car & Motorbike'), (N'IN',N'1350384031,1350385031',N'健康与个人护理',N'Health & Personal Care'), (N'IN',N'2454169031,2454170031',N'包、钱包和行李',N'Bags, Wallets and Luggage'), (N'IN',N'5866078031,5866079031',N'工业与科学',N'Industrial & Scientific'), (N'IN',N'5122348031,5122349031',N'电器',N'Appliances'), (N'IN',N'976445031,976446031',N'音乐',N'Music'), (N'IT',N'9699425031,9699426031',N'手工产品',N'Prodotti Handmade'), (N'IT',N'6198082031,6198083031',N'美',N'Bellezza'), (N'IT',N'3628629031,3628630031',N'乐器',N'Strumenti musicali'), (N'IT',N'523997031,523998031',N'玩具和玩具',N'Giochi e giocattoli'), (N'IT',N'2454160031,2454161031',N'自制',N'Fai da te'), (N'IT',N'1571289031,1571290031',N'健康和个人护理',N'Salute e cura della persona'), (N'IT',N'1571286031,1571287031',N'幼儿期',N'Prima infanzia'), (N'IT',N'14700958031,14700959031',N'车辆',N'Veicoli'), (N'IT',N'412609031,412610031',N'电子学',N'Elettronica'), (N'NL',N'16295907031,16295908031',N'生活和厨房',N'Wonen en keuken'), (N'NL',N'16269066031,16269067031',N'电子学',N'Elektronica'), (N'NL',N'16242572031,16242573031',N'宠物用品',N'Huisdierbenodigdheden'), (N'NL',N'16242229031,16242230031',N'自制和工具',N'Klussen & gereedschap'), (N'NL',N'16242458031,16242459031',N'乐器',N'Muziekinstrumenten'), (N'NL',N'16242743031,16242744031',N'玩具和游戏',N'Speelgoed & spellen'), (N'NL',N'16241721031,16241722031',N'美',N'Beauty'), (N'NL',N'16241664031,16241665031',N'婴儿用品',N'Babyproducten'), (N'NL',N'21305337031,21305338031',N'工艺品',N'Knutselen'), (N'TR',N'12466610031,12466611031',N'健康和个人护理',N'Sağlık ve Kişisel Bakım'), (N'TR',N'12466323031,12466324031',N'个人护理和化妆品',N'Kişisel Bakım ve Kozmetik'), (N'TR',N'12467068031,12467069031',N'运动和户外',N'Spor ve Outdoor'), (N'TR',N'12466208031,12466209031',N'宝贝',N'Bebek'), (N'TR',N'12466781031,12466782031',N'厨房',N'Mutfak'), (N'TR',N'12467009031,12467010031',N'办公室和文具',N'Ofis ve Kırtasiye'), (N'TR',N'12466439031,12466440031',N'计算机',N'Bilgisayar'), (N'PL',N'20658724031,20658725031',N'工业和科学',N'Przemysł i nauka'), (N'PL',N'20656844031,20656845031',N'工艺美术',N'Arts & Crafts'), (N'PL',N'20658035031,20658036031',N'健康和家庭',N'Zdrowie i gospodarstwo domowe'), (N'SA',N'16636789031,16636790031',N'露台、草坪和花园',N'Patio, Lawn & Garden'), (N'SA',N'12462934031,12462935031',N'婴儿用品',N'Baby Products'), (N'SA',N'12463162031,12463163031',N'电子学',N'Electronics'), (N'SA',N'16636732031,16636733031',N'工艺美术',N'Arts & Crafts'), (N'SA',N'12463333031,12463334031',N'首页',N'Home'), (N'SA',N'16637188031,16637189031',N'乐器',N'Musical Instruments'), (N'SA',N'12463618031,12463619031',N'玩具',N'Toys'), (N'SE',N'20513536031,20513537031',N'运动与户外',N'Sport & outdoor'), (N'SE',N'20513023031,20513024031',N'家庭和厨房',N'Hem & kök'), (N'SE',N'20512966031,20512967031',N'健康、护理和家庭',N'Hälsa, vård & hushåll'), (N'SE',N'20512396031,20512397031',N'爱好和手工艺',N'Hobby & hantverk'), (N'SE',N'20513593031,20513594031',N'玩具',N'Leksaker'), (N'SE',N'20512510031,20512511031',N'婴儿用品',N'Babyprodukter'), (N'SE',N'20513308031,20513309031',N'乐器',N'Musikinstrument'), (N'SG',N'6314273051,6314274051',N'婴儿用品',N'Baby Products'), (N'SG',N'6314449051,6314450051',N'电子学',N'Electronics'), (N'SG',N'6314630051,6314631051',N'首页',N'Home'), (N'SG',N'6315296051,6315297051',N'宠物用品',N'Pet Supplies'), (N'TR',N'21324944031,21324945031',N'花园',N'Bahçe'), (N'TR',N'12466553031,12466554031',N'时尚',N'Moda'), (N'TR',N'21325061031,21325062031',N'乐器和DJ',N'Müzik Enstrümanları ve DJ'), (N'PL',N'20657078031,20657079031',N'儿童产品',N'Produkty dziecięce'), (N'PL',N'20659543031,20659544031',N'体育和旅游',N'Sport i turystyka'), (N'PL',N'20657195031,20657196031',N'美',N'Uroda'), (N'PL',N'20657799031,20657800031',N'礼品卡',N'Karty podarunkowe'), (N'SA',N'16637302031,16637303031',N'宠物用品',N'Pet Supplies'), (N'SA',N'12462877031,12462878031',N'汽车',N'Automotive'), (N'SA',N'12462991031,12462992031',N'美',N'Beauty'), (N'SA',N'12463390031,12463391031',N'自制和工具',N'DIY & Tools'), (N'SA',N'16637245031,16637246031',N'办公产品',N'Office Products'), (N'SA',N'12463219031,12463220031',N'时尚',N'Fashion'), (N'SA',N'12463276031,12463277031',N'健康',N'Health'), (N'SA',N'16636960031,16636961031',N'工业与科学',N'Industrial & Scientific'), (N'SA',N'12463561031,12463562031',N'体育用品',N'Sporting Goods'), (N'SE',N'20513080031,20513081031',N'建造、电动和工具',N'Bygg, el & verktyg'), (N'SE',N'20512567031,20512568031',N'美',N'Skönhet'), (N'SE',N'20512738031,20512739031',N'时尚',N'Mode'), (N'SE',N'20512681031,20512682031',N'电子学',N'Elektronik'), (N'SE',N'20512453031,20512454031',N'车辆',N'Fordon'), (N'SE',N'20513422031,20513423031',N'宠物配件',N'Husdjurstillbehör'), (N'SE',N'20513137031,20513138031',N'工业工具和产品',N'Industriella verktyg & produkter'), (N'SE',N'20513365031,20513366031',N'办公产品',N'Kontorsprodukter'), (N'SE',N'20512795031,20512796031',N'花园',N'Trädgård'), (N'SG',N'6314215051,6314216051',N'汽车',N'Automotive'), (N'SG',N'6314330051,6314331051',N'美',N'Beauty'), (N'SG',N'6314687051,6314688051',N'自制和工具',N'DIY & Tools'), (N'SG',N'6314868051,6314869051',N'办公产品',N'Office Products'), (N'SG',N'6314940051,6314941051',N'体育用品',N'Sporting Goods'), (N'SG',N'6314572051,6314573051',N'健康、家庭和个人护理',N'Health, Household & Personal Care'), (N'SG',N'6315239051,6315240051',N'时尚',N'Fashion'), (N'SG',N'8107749051,8107750051',N'工业与科学',N'Industrial & Scientific'), (N'US',N'2972638011,3238155011',N'庭院、草坪和园艺',N'Patio, Lawn & Garden'), (N'US',N'11091801,11965861',N'乐器',N'Musical Instruments'), (N'SG',N'6315068051,6315069051',N'玩具',N'Toys'), (N'SG',N'8107890051,8107891051',N'乐器',N'Musical Instruments'), (N'SG',N'8107631051,8107632051',N'花园',N'Garden'), (N'US',N'1055398,1063498',N'家居、厨具、家装',N'Home & Kitchen'), (N'US',N'2619533011,2619534011',N'宠物用品',N'Pet Supplies'), (N'US',N'3375251,3375301',N'运动户外休闲',N'Sports & Outdoors'), (N'US',N'3760901,3760931',N'健康和家居用品',N'Health & Household'), (N'US',N'15684181,15690151',N'汽车用品',N'Automotive'), (N'US',N'228013,468240',N'家居装修',N'Tools & Home Improvement'), (N'US',N'2617941011,2617942011',N'艺术品、工艺品和缝纫用品',N'Arts, Crafts & Sewing'), (N'US',N'165796011,165797011',N'婴儿用品',N'Baby Products'), (N'US',N'3760911,11055981',N'美容和个人护理',N'Beauty & Personal Care'), (N'US',N'172282,493964',N'电子',N'Electronics'), (N'US',N'16310091,16310161',N'工业与科研用品',N'Industrial & Scientific'), (N'US',N'1064954,1084128',N'办公用品',N'Office Products'), (N'US',N'7141123011,7141124011',N'时尚',N'Clothing, Shoes & Jewelry'), (N'US',N'2335752011,2335753011',N'手机和配件',N'Cell Phones & Accessories'), (N'US',N'165793011,165795011',N'玩具和游戏',N'Toys & Games'), (N'TR',N'12466667031,12466668031',N'家与生活',N'Ev ve Yaşam'), (N'TR',N'12467126031,12467127031',N'玩具',N'Oyuncak'), (N'TR',N'12466724031,12466725031',N'建筑市场',N'Yapı Market'), (N'US',N'2619525011,2619526011',N'大家电',N'Appliances'), (N'US',N'2238192011,2864120011',N'礼品卡',N'Gift Cards'), (N'US',N'11260432011,11260433011',N'手工制品',N'Handmade Products'), (N'TR',N'12466496031,12466497031',N'电子学',N'Elektronik'), (N'TR',N'20230635031,20230636031',N'宠物产品',N'Evcil Hayvan Ürünleri'), (N'TR',N'12466266031,12466267031',N'汽车',N'Otomotiv'), (N'ES',N'12472654031,12472656031',N'宠物用品',N'Productos para mascotas')
select c.OrderSourceCountry as '站点',
--c.OrderSourceID,
o.OrderSourceName as '渠道',
c.BrowsePathByID, tree.BrowseNodeNameCn +'('+tree.BrowsePathByName+')' as '一级类目ID',
c.TotalNum as '刊登总量' ,c.ErrorNum as '8560报错数量', c.ErrorRate as '8560报错比例',c.ConfigNum as '8560数量配置',c.ConfigRate as '8560比例配置',
ad.UserName as '首选业务员',ad.UserFullPathName as '首选业务 部门',c.AddTime as 首次删除时间,'' as 品牌池是否恢复,'' as '3个失败渠道SKU'
from RB_Amazon_ClearBrandPool_Log(nolock) c
left join RB_OrderSource(nolock) o on c.CustomerID=o.CustomerID and c.OrderSourceID=o.ID
left join RB_admin(nolock) ad on c.CustomerID=o.CustomerID and o.SaleAdminID=ad.ID
left join @F_Node tree on tree.Country=c.OrderSourceCountry and tree.FirstBrowsePathByID=c.BrowsePathByID
where c.CustomerID=1
--and c.LockGuid='af72e8d79d9a4b018ea61977fcb44e0e'