All Forums Database
l.k 75 posts Joined 10/08
09 Jul 2009
Insufficient memory to parse this request,during optimizer phase....

Hi, When i execute this query in teradata V2R12,it is generating errors as "Insufficient memory to parse this request,during optimizer phase".But the same query is working fine in Teradata V2R6 Version.In my DBS control Max ParseTree setting is 6000.we have collected statistics for all the index columns.SELECT DIM_PRODUCT.PRODUCT_CODE,DIM_PRODUCT.PRODUCT_DESCRIPTI ON|| '-' ||trim(PRODUCT_STYLE_DESC)|| '-' ||trim(PRODUCT_SIZE) "Product",DIM_PRODUCT.EAN_NUMBER"C627", DIM_PRODUCT.PRODUCT_DESCRIPTION"C157", DIM_PRODUCT.PRODUCT_STYLE_DESC"C153", DIM_PRODUCT.PRODUCT_SIZE"C156", DIM_PRODUCT.PRODUCT_UOM"C604", DIM_PRODUCT.CREATED_DATE"C998", (case when ATTRIB2_DESC IN('ZAP' , 'KIL' , 'DEL' , 'zap' , 'kil' , 'del') THEN 'D' ELSE 'A' END) "C659", DIM_PRODUCT.ATTRIB2_DESC"C712", DIM_PRODUCT.ATTRIB1_DESC"C648", DIM_PRODUCT.ATTRIB3_DESC"C628", DIM_PRODUCT.PRODUCT_DETAIL_CODE"C146", DIM_PRODUCT.DEPARTMENT_CODE"C134", DIM_PRODUCT.DEPARTMENT_DESC"C135", DIM_PRODUCT.CLASS_CODE"C136", DIM_PRODUCT.CLASS_DESC"C137", DIM_PRODUCT.SUBCLASS_CODE"C138", DIM_PRODUCT.SUBCLASS_DESC"C139", DIM_PRODUCT.ACCT_DEPT_CODE"C606", DIM_PRODUCT.SUB_DEPT_CODE"C608", ' ' "C761", ' ' "C732", SUM(SALE_TOT_QTY)"C1", SUM(SALE_TOT_QTY_LY)"C2", ' ' "C1254", ' ' "C688", SUM(SALE_NET_VAL)"C3", SUM(SALE_NET_VAL_LY)"C4", ' ' "C1253", ' ' "C100", SUM(SALE_TOT_VAL_AT_PP)"C29", SUM(ACCRUED_REBATE_VAL)"C735", ' ' "C772", ' ' "C97", ' ' "C101", SUM(SALE_TOT_VAL_AT_PP_LY)"C30", SUM(ACCRUED_REBATE_VAL_LY) "C736", ' ' "C773", ' ' "C98", ' ' "C102", ' ' "C1255", ' ' "C103" FROM arcprod.AGG_MLY_STR_PROD,DIM_STORE, DIM_PRODUCT,ADMIN_USER_STORE,ADMIN_USER_DEPARTMENT WHERE AGG_MLY_STR_PROD.DATE_KEY >=1212 AND AGG_MLY_STR_PROD.DATE_KEY <=1295 AND DIM_STORE.ACTIVE = 1 AND DIM_PRODUCT.PRODUCT_CODE IN ('5150004007','48000355501','4180000012','4180000025' ,'72698419000','1122542185', '48000354501','72698419050','48000355601',' 72698419051','48000703801','4180000017', '4180000028','5150001316','4180000036','48000307501',' 72698419001','72698419003','5150000683', '5150000163','5150004008','5150001687','48000502401',' 72698419053','5150002219','72698419002', '1122542184','5150000690','72698419004','48000300801' ,'48000354701','5150000682','48000417301', '4129201216','5150000006','48000355701','48000417501' ,'75512200012','75512200007', '5150003259','5150003258','48000356601','48000497301' ,'5150028604','48000417901', '48000521801','5150003363','8870200952','48000511801' ,'48000511901','48000512001', '48000684201','5150003069','48000355001','48000355201' ,'5964424617','48000355301', '48000355401','48000497401','48000497401','5150003056' ,'48000354901','48000400501','5964420217', '48000400601','8186720009','8186720018','48000369701' ,'48000098701','8186720010','48000488001', '48000701201','48000680301','48000279601',' 48000369801','4364738001','4364768003','48000316501', '48000611101','4164202670','48000105501','48000357301' ,'48000595101','48000357401','3680018151', '48000356101','5150024320','48000336801','5150024334' ,'48000216401','48000356201','5150024322', '48000357701','48000337701','48000595001',' 48000357601','48000684501','48000684601','1122504180', '72698419020','1870000078','72698419022','1870000040' ,'1870000314','72698419021','1122542189', '72698419024','72663512152','48000609001',' 48000608901','72663512153','73753919049','48000744601' , '980089500','66780300195','4179500098','48000738501',' 48000695801','72698428050','48000596201', '7299949303','48000424301','4125300905','72698428065' ,'72698428064','7372320040','7372320041', '7372320042','72698428066','72698428061','72698428062' ,'7299924103','7299927203','72698428063', '7067000555','7321400107','7321400803','8915684010',' 7107201250','4125300926','4125300933', '48000280801','8915680109','48000424401','4125300910' ,'8915680100','8915680123','8915680101', '8915680122','8915680112','7299924203','3727908001',' 7321400604','8915680111','7321400604', '3727908005','48000427901','8915680113','7321400587',' 7647963616','48000504401','48000424201', '8915680128','48000704401','3727908002','3727908003',' 8915600136','7321406350','7321406350', '48000427801','48000427801','48000512601',' 48000428001','7321400618','7321406332','4122471470', '4122471488','3285100005','1121000835','72698428005',' 48000596301','7157911002','48000302501', '5410000360','72698428042','72698428019','72698428043' ,'48000302101','48000302301','48000302201', '7157910817','7157911003','7157977000','48000596401',' 4182006045','7157911011','72698428041', '48000596501','5410000450','4182010506','4182010509',' 4182010616','48000302401','4182007038', '48000696601','48000301901','48000302001',' 48000405501','48000405601','48000365201','48000596601' ,' 1122542167','48000301801','48000405401','7157911004',' 7157944005','4182003090','2370900407', '4125300007','7321400402','7321400403','2370900403',' 4122470006','4122470090','2370911042', '4125300960','48000427701','7321400129','48000427701' ,'7321400162','74815941660','74815941274', '4125310400','48000281101','4125337100','48000280901' ,'7067000088','7067000452','4125300200', '7321400104','5150028661','7321400146','7321400146',' 7067000554','1121002555','1122506354', '48000357001','4125300066','7321400103','4182006033',' 3727908008','48000509001','7057355555', '7057366666','1122506355','18372300001','18372300002' ,'1121002555','7321400160','72698408139', '72698408133','72698408140','72698408134','7040400100' ,'72698408142','72698408141','1300000854', '1300000814','7321000240','7040400135','7040400136',' 48000676901','7321003325','48000427601', '48000427501','5150028640','48000417401','48000430901' ,'3915341305','3915341306','48000392601', '7241282001','7086060250','7107201141','7107201141',' 48000721001','7079690008','7241200035', '48000395501','7241282001','4125300180','48000390501' ,'7067000957','1786942007','1362860893', '1362860900','7224826354','3915341300','4125300183',' 7107201132','73449270130','7321000200', '48000577101','48000577201','8186750010','3915341308' ,'3915341310','8186750002','8186750001', '4364651023','4364651020','7224827755','7224827751',' 7067000289','4125300185','1786942003', '1786942004','48000417001','3915341302','5152806015',' 73449270135','48000113001','64850535250', '48000731501','1362860887','48000268601','8634157120' ,'48000504301','8634157120','3915341355', '48000567101','1362860887','64850533250','64850530250' ,'6726420000','6726420000','4122470548', '64850530250','3915310130','80824500013','1362860850' ,'1362860850','8423859013199','48000150101', '48000179201','48000441201','48000114101',' 48000146401','48000665601','48000115701','48000194601' , '7460907233','1340935231','5160000004','4150080502',' 48000098801','48000098601','1121000609', '1121000001','7047501064','4150001310','5160000501',' 72698408110','5160000001','1300000264', '48000284201','48000148801','48000153401',' 48000365701','48000158101','48000441101','48000334001' , '1122506307','1122506309','1122506316','4749600054',' 2400037396','4142117745','7110000052', '74815910732','7507610016','48000445601','74815910730' ,'1121000825','1121000825','5150028651', '7507610007','48000356901','48000356801','48000585101' ,'7067000460','48000417801','7067000430', '7124038504','48000098901','48000607901','48000607801' ,'73475600108','48000608001','48000608101', '73475600208','73475600209','3979600221','48000269701' ,'7124038520','48000356701','77610011349', '77610092375','7067000459','48000630501','1121002010' ,'7067000025','5150028620','48000608801', '7356200510','48000695901','7215500005','4973380011',' 48000613001','8186780012','4973309101', '7067060108','48000103701','48000103801','48000147601' ,'48000630701','2013813604','2013813630', '6970250002','4973312345','79285135657','48000523001' ,'75449600122','1121002010','72698408906', '72698408907','1121002150','72698408111','2700038249' ,'72698408112','2700038354','72698408108', '1300000121','72698408301','4150000025','72698408304' ,'48000114001','72698408303','72698408305', '6414432160','48000724201','4150000031','4150000700',' 48000365601','48000365801','5440060050', '7113701209','7182800212','48000678601','1300000112',' 1300000113','48000709301','48000715101', '48000203301','4132101438','2100064947','7182800127',' 7182800228','7182800149','1300001520', '48000408201','7182800238','48000408101','48000099001' ,'48000443001','1048100200','48000099001', '48000408301','48000408401','1300001530','48000102701' ,'7182801108','48000408501','7020050232', '48000382101','4364651018','7182800277','7182801405',' 7245788011','66780300217','66780300218', '7182801106','4364651018','4364670777','4364670777',' 7142907617','48000306001','66780300005', '48000747501','48000747601','48000628801',' 48000103901','4364646301','4364646101','48000316401', '4364646301','48000316401','4364646101','48000654501' ,'48000523101','4364620137','2250613806', '7430500016','3680012045','2250628032','48000237501',' 3680004341','48000238201','9232522223', '48000148701','48000516501','48000240201','7110028654' ,'48000631801','2548400041','2250600235', '2250620232','2250620132','2250680006','2250613410',' 3680004313','3680012042','2250600200', '48000561101','48000305601','72698430003','7180083850' ,'72698430001','4800100147','72698430000', '48000337101','2100064507','4800126552','72698430004' ,'2100064504','2100064591','48000597201', '48000282001','48000149501','48000148201',' 48000148901','48000151701','7110000550','48000274701', '48000396301','4100000610','48000275001','48000275501' ,'48000361201','48000719601','7110021015', '48000378101','48000312701','48000672701',' 48000396201','48000378001','7110000465','4300097940', '4300097825','7052800631','48000387901','48000455201' ,'48000630801','48000631001','1600040060', '48000242901','7038110014','48000630901','4470002773' ,'4470002966','48000261801','5210015530', '4300097868','4760002334','4760009136','3760026426',' 73007622100','48000201201','7182800211', '48000724301','4132101331','48000450401','7038110027' ,'48000404401','48000182001','48000417701', '48000380501','48000203201','48000515501',' 48000384701','1121002300','1121002300','48000664901', '48000504101','7020011001','48000696001','48000630601' ,'7468300445','48000442901','7147500013', '48000731201','48000442801','7147501082','7147501082' ,'4760005004','48000382301','48000504001', '8634112401','8817742487','48000503901','48000503901' ,'48000749001','8634112112','48000664101', '78640900001','48000121601','72698420120','1480058204' ,'72698420013','48000637501','1480058226', '7045011864','1122561723','72698420044','1480064608',' 48000428401','48000595401','1122541602', '48000447201','4175500106','48000595501','72698420600' ,'4175500900','48000509401','2870000308', '72698420024','72698420080','7535511181','7535511182' ,'48000595301','72698420029','48000447101', '48000595601','48000595201','48000745201','2870011305' ,'48000202701','48000299401','4175500267', '48000350501','48000744701','4175500808','48000566101' ,'48000202401','48000202501','48000351501', '48000202601','48000203001','48000447001',' 48000202801','48000301401','48000301201','4175500119', '5100001293','48000351003','48000000101','48000364901' ,'48000498001','8105705407','3680300109', '48000248801','4124400152','48000285201','4277430070' ,'48000280401','7990000461','4124400253', '4124499030','4180070652','4180070752','7000551012',' 48000100701','48000683601','48000683501' ,'48000359701','48000360301','48000696201',' 48000341902','48000360101','48000359601','48000706501' , '48000360001','48000360201','48000667102',' 48000193901','48000193801','48000184901','48000508201' , '48000170301','48000185201','48000301601','4180021450' ,'48000508301','3400031300','48000623201', '48000202201','48000442301','48000202101','4124446256' ,'4180020850','48000339601','3610000224', '72698420031','72698420032','2870000024','5100000366' ,'5100000007','3890000947','72698420040', '3610000222','3610000122','2870000027','5100000336',' 5100011977','48000347801','5100006992', '48000301301','48000348301','3680007903','3680004311' ,'48000442401','48000441901','48000226901', '48000442101','3680016750','48000227201','7468210301' ,'48000307401','7468210327','3619212216', '3680014411','3680016748','48000709201','7468210731',' 3619212259','48000227101','7468210717' ,'48000691401','3619212215','3680016749','48000711101' ,'48000711201','48000590101','48000584201', '48000560001','48000520001','48000590001',' 48000650801','48000201501','48000590701','48000653601' , '68596000001','76059010076','48000569901','7334700800' ,'48000570101','48000744301','3997800461', '3997800452','73788096055','48000522401','48000609601' ,'9370930060','9370930040','48000644701', '9370930030','9370930010','48000512401','8912531800',' 5137615111','5137611101','48000731901', '48000732501','7511964724','48000732401','48000516601' ,'48000732601','48000201001','1120600034', '48000732001','48000665101','48000732701',' 62168302135','48000744801','7581000125','48000594701', '48000194201','48000594601','4175550000','7020055600' ,'7020000227','48000268101','48000167801', '48000594801','48000194101','1122541574','72698414110' ,'7372385507','48000594301','72698414111', '72698414090','72698414091','48000202301','3890009081' ,'2400001092','48000245001','3890003096', '3890004000','48000268201','3890004205','48000167901' ,'3890004215','1122541571','72698414010', '72698414115','48000153001','1119418754','48000168301' ,'48000594401','48000098001','2400001062', '2400001745','2400006096','72698414108','48000594501' ,'48000168201','48000267901','48000421401', '48000268001','48000167601','3120001005','48000242101' ,'3680014409','72698414126','4134536512', '7372300103','72698414127','4134531712','7045016160',' 2400016700','72698414133','48000282801', '4134515512','72698414128','3732313909','48000478701' ,'1122506350','7707523059','7707523059', '7075900005','73755003005','7372340081','48000105201' ,'1119434819','48000340701','72698441009', '72698441043','48000599801','72698441011',' 48000168001','48000260401','48000098301','48000168101' , '48000320201','72698441018','48000098101',' 72698441017','72698441016','72698441015','2400016299', '48000167501','48000600201','48000260301','2000010453' ,'2000010546','72698441042','72698441045', '48000599901','2400001544','2000010419','48000098201' ,'7372300010','48000248601','3680091114', '48000431101','3680092314','1122541586','2400016308',' 1119431740','1119432755','72698441044', '4125336003','2000010165','72698441047','2400016312',' 3470009612','3470009411','48000230601', '48000260501','2418230011','48000243701','3680004307' ,'3680004306','3680009720','48000592401', '3680005609','3680009711','3680009719','72534228371',' 72534228571','72534229111','72534229121', '72534238171','72534228103','72534228193',' 48000592301','72534229043','72534229373','48000234401' , '48000231901','7487316322','7487316325','2418200259',' 48000241401','48000241501','48000223701', '48000305801','48000240301','48000234501',' 48000305901','4125300634','72698441040','4125300601', '7372301015','4182000005','1119434041','72698441151',' 2400016320','7372399917','48000600301','72698441034',' 4182020110','48000280701','72698441046','7157955000',' 3710005816','4125300490','72698441230','4182001090',' 3900004512','48000677901','1122503963','3900004512',' 4125300400','3710005810','48000120601','4125300410',' 3900004504','3900004504','48000100501','2230000002',' 48000286901','48000103501','7182800160','7067000033',' 7321400608','7047500045','48000220701','7067000935',' 7372301510','7372310205','78532801995','4125336001',' 78532801987','7032084410','7067000524','7067000536',' 7067000507','7819204608','1122506358','48000129501',' 48000708101','48000196601','48000597001','72698429090' ,'48000127901','2970000114','1600041610','48000128501' ,'1600017799','72698441007','72698441029',' 48000600401','48000099201','48000599601','1122541590' ,'48000600101','48000599701','48000098401',' 48000372201','1119432383','1119436871','1119437089',' 2700037831','48000179001','1119436508','48000707201',' 2700037837','2700037882','48000707301','48000707401',' 48000179101','2700038040','72698441023','48000600001' ,'1122541593','48000599501','1122541592','2700039104' ,'2700039023','2700039014','2700039005','2700039103',' 2700038807', '72698441004','72698441003','2700038963','2700038815' ,'48000179301','2700038811','7067000583', '63898200044','48000391701','48000391701','7079630001' ,'4125336005','7321400607','7321400606','7321400607',' 48000169401','79921098001','8775412031','7075912611',' 72698442014','72698442004','72698442006','72698442020' ,'72698442012','72698442001','72698442002',' 72698442008','72698442009','72698442018','72698442005' ,'72698442013','72698442019','3940005500',' 48000269201','48000233201','48000330601','4780033044' ,'48000269101','48000269601','5200001248','4780034004' ,'3940001617','48000268901','48000269301',' 48000098501','48000599401','72698441041','48000269401' ,'48000269501','72698441024','48000260601',' 3680007250','3680007249','3680007254','3680007253',' 3680018145','7032080139','7032080171','48000383301',' 4119602035','72698442016','72698442073','72698442071' ,'72698442015','48000137401','7276912226',' 48000137401','7276960508','5480001008','72698442072',' 74050094156','1740011840','1740011845','1740011840',' 1740011845','48000682401','48000682401','48000682501' ,'72698442070','48000682501','1740010695','5480034429' ,'1740011810','1740011810','48000403001','48000403201' ,'48000275301','4600082341','1530043000','48000366401' ,'48000366501','48000727301','48000594001',' 4300028521','48000312301','7317600150','48000625801',' 48000395101','2857100407','7107201303','48000742901',' 48000742901','7440111041','7440131041','48000438301',' 7440131041','7440191041','2857100448','7440191041',' 7440170432','7440141041','7440161041','48000415701',' 48000395601','48000415601','48000415901','2857100461' ,'7440176033','7440199041','7440173432','7317600158',' 7613201010','48000415801','7067001022','7613201004',' 7613201005','7613295048','4239911016','48000100401',' 7323402008','3760026701','1700001686','48000335901',' 4800001191','48000336601','4800001197','4800001475',' 4800000086','8660000098','4800001480','82916920031',' 1122502084','7478510210','7478510280','5100010348',' 7478505280','5100002379','4800000062','4800000071',' 4800000072','7175934104','7175901170','4800000396',' 4800000303','48000336401','48000504801','48000336501' ,'48000675401','4800000120','4800000195','48000336301' ,'8660011451','8660011451','4800000399','8660010251',' 48000675301','48000722501','4800000523','8000049525',' 4800000009','48000675501','8660000025','48000703901',' 4800000095','48000504601','48000688801','72698412100' ,'48000504701','8660025021','72698412103','4800000262' ,'8000000145','4800000245','4256300600','8660000012',' 8660000011','4800001164','8660000031','8660000001',' 4800000189','48000336001','48000636601','7175902110',' 4800000065','4800000061','4800000191','3900008589',' 3760027554','4125300313','4125300250','4800000672',' 48000407401','48000147401','48000336701','7175902112' ,'4800000068','7175900201','3480000400','48000336201' ,'7175902111','48000280601','4125300314','4125300315' ,'4125300290','4122417120','7067000785','4122460304',' 4122424620','4780000027','7067000643','4122415220',' 79852516320','7067000642','48000403301','7071800092',' 7071800101','7020023015','7020023035','5239148150',' 1122506314','7323000846','48000372001','5100002523',' 48000729701','48000349301','48000349401','48000371801' ,'48000371901','4132124105','48000371501',' 48000396401','7110672007','4132124178','48000269001',' 48000282201','6414402115','7110672040','48000262501',' 4132124022','3760024687','48000262401','3900008568',' 3760018888','3760000001','48000261901','3760021629',' 4132124718','48000282301','48000346701','4132124830',' 2700044118','2700044110','2898901900','2898902310',' 75764567130','75764567130','48000656701','48000656801' ,'48000656901','48000657001','78087208306',' 48000657101','70115937700','70115937704','1122502326' ,'82927445117','7860141007','48000473901',' 48000075501','5000001489','5000005140','1780045324',' 2310021673','2310007103','3680008059','3680008062',' 48000235101','78087208506','78087208515','3680008025' ,'78087208503','3680008024','48000145201',' 48000235401','8660000050','5000004060','48000345001',' 48000162901','48000343401','48000163801','48000644101' ,'48000163301','48000164101','3680008692',' 48000235501','48000345301','48000345401','48000627901' ,'48000163401','48000622501','48000197101',' 48000139101','3000008180','48000643901','48000343701' ,'2310008541','48000369501','1780002063','48000138301' ,'48000164001','2310021764','70115914702',' 48000715701','48000099801','48000070401','48000074901' ,'48000234801','48000078101','48000235001',' 48000075101','48000139501','48000723001','48000069901' ,'1780012631','7910049298','3810033346','3680008045',' 48000163601','1780001448','3810033022','3680008043',' 1780041124','1780011030','1780010164','1780040400',' 75764566010','75764566120','3680008015','75764566010' ,'78087208015','78087208315','48000234701',' 48000726401','48000726501','78087208006','48000138901' ,'3680008676','48000235301','48000162801',' 48000236201','48000163001','48000138501','48000715901' ,'48000096701','48000097101','48000097201',' 5000036358','5000057211','48000344801','48000162701',' 48000096901','48000163101','48000410801','48000715001' ,'48000144901','48000139201','1780013285',' 48000163901','48000698301','78087207802','78087207807' ,'75764561200','75764561205','48000622401',' 78087207801','78087207805','75764561200','75764561205' ,'3810011912','5000057475','3000007450','48000113201' ,'48000235201','48000197501','1262373480','1122502519' ,'48000113101','2310030705','1113200188','48000096801' ,'3270001849','3810012853','48000375601','48000716901' ,'3810010655','7910049300','1780012889','1113200681',' 3810012891','3000008360','48000502301','48000266201',' 48000163701','7910052300','7910090207','7000218006',' 1780050542','7910070010','1780029955','7910045127',' 3810010815','48000266101','5849670116','2310027795',' 48000475001','48000700701','2310027789','48000660601' ,'48000574801','48000695601','65922324060',' 70115914117','48000582601','70115914200','48000627801' ,'48000566701','48000628001','1262371012',' 48000072301','48000070601','48000072501','4133400103' ,'1122502292','3680008660','7023010710','4133400102',' 1262399910','7023000071','48000072601','4460002001',' 3320002140','4133400154','3320015020','4460003073',' 4460002031','4460001311','48000069101','48000282701',' 48000070501','48000236101','3320002200','48000071701' ,'48000072201','48000209101','48000073001',' 48000382701','76437581556','48000382601','7023010782' ,'7023001606','7290400012','3680090217','48000673701' ,'48000343001','3680011965','5000001051','48000573201' ,'7107900005','4175600300','4175604012','3680095512',' 5000010152','48000234601','48000231401','2529360086',' 2529360088','7487396810','7487396860','48000296901',' 48000363701','6195400037','48000644201','48000105001' ,'48000235601','48000240101','48000236601',' 48000122101','48000124101','68635280175','48000318901' ,'48000123901','48000678901','48000687201',' 48000123101','48000123501','1500001341','48000123201' ,'48000124301','48000113801','48000716001',' 48000716201','48000121901','48000241701','3680013295' ,'48000240401','48000682201','5100001021','5100001047' ,'5100001437','48000348501','48000351801',' 72698437002','72698437005','72698437004','72698437010' ,'72698437011','72698437012','5100000660','5100001081' ,'5100001621','5100004937','48000350701','72698437001' ,'48000598801','5100000618','5100005887','5100005897' ,'5100001291','5100001051','48000348401','5100001031' ,'5100001161','5100001231','48000636501','72698437023' ,'72698437033','48000599001','48000599101',' 72698437019','72698437021','48000598901','1122503482' ,'1122503699','48000348101','48000718201','1122503696' ,'48000346501','48000279101','48000572601',' 1122504151','1122503698','1122503483','48000279201',' 48000349101','48000351701','48000351901','48000352401' ,'48000351601','48000350901','48000350801',' 48000351201','48000351401','48000346401','48000390701' ,'48000390701','48000395901','48000395901',' 48000571901','7154020005','48000300601','48000390301' ,'48000726301','7423544100','48000275201',' 72698437028','7423528451','48000274801','48000281201' ,'4100000324','4100000332','48000390401','48000208301' ,'9830800209','48000337801','48000409101','4318200394' ,'4318200391','4318200393','4318200392','4125875119',' 4125875120','48000281301','48000281401','72698437016' ,'1122541610','5100002107','72698437017','48000703701' ,'48000349201','48000572701','48000279301',' 48000350401','48000352001','48000562901','48000352301' ,'48000678501','5100002430','5100015634','48000727201' ,'48000390201','48000609301','48000652901',' 48000609301','48000484801','48000484901','8105705633' ,'8105705635','48000484601','48000484701',' 48000395301','48000185801','48000744401','48000690401' ,'48000690401','48000337401','9830800210','9830822581' ,'48000623801','48000185901','48000365901',' 48000395801','48000521201','48000589301','48000239001' ,'48000223501','48000223601','3574222103','3574222104' ,'3574222401','48000592701','48000655901',' 48000363301','48000242401','48000363501','5260305400' ,'48000626301','72698405017','3680014970',' 72698405015','3680014972','3680055816','3680021179',' 72698405030','72698405014','3680013696','3000007840',' 3680014597','3680008506','72698405012','72698405029',' 48000238901','72698405028','48000131301','48000234201' ,'3800000810','48000239901','3800043031','48000310801' ,'3680014977','1600027511','48000129801','48000130001' ,'48000130801','48000130901','1600026344',' 48000709101','4300018059','3800001411','48000129701',' 48000410201','48000130201','3800039116','3800039125',' 3800039132','3800000110','48000130301','1600027554',' 48000308801','48000198001','4300018050','48000309201' ,'3800004530','3800042875','3800043239','48000131401' ,'3800001932','48000263801','4300011460','4300018005' ,'4300018062','4300018160','4300018170','48000129601' ,'3800027357','3800030400','48000710601','3800039492' ,'1600027472','1600027538','3800022775','3800024490',' 3800030402','3800037399','1600042973','4300001786',' 4300002639','48000310601','3000006860','3000006150',' 48000198101','3800005332','3800003530','1600040945',' 3800031844','3800001302','48000310401','48000310301',' 3800000828','48000131601','3800000600','3800031834',' 3800031846','48000132001','3800031829','3800039134',' 3800087010','48000197901','3800060160','3800066330',' 48000306301','48000593501','3000026335','48000593401' ,'4144940006','48000593301','1313000698','48000681901' ,'48000198901','48000115501','48000115601',' 3000001554','48000306201','48000197201','5000029155',' 3000002190','4144905055','7246300021','8634133001',' 5900003975','7246300026','7246300024','7246300032',' 7246300020','7246300020','48000244201','48000132701',' 48000264301','78928098118','78928099118','48000099601' ,'4240091378','4240091078','4240090478','48000306501' ,'48000306401','4240091678','4240009764','48000306601' ,'4240091278','48000306701','4240009769','4240093978' ,'48000375501','4240009772','48000344901',' 48000345201','5000053172','3680015117','48000584101',' 3680003456','3680007511','3680015119','3680006257',' 3680006259','48000369201','3680006258','3680012008',' 48000368501','5571206701','6667629008','6667699032',' 3997800105','3997850103','3680014117','48000143901',' 3680014168','48000241301','1862701234','48000230301',' 5844943002','48000475301','48000143001','48000705601' ,'48000691101','48000154201','48000475401',' 5844941000','5844941001','7130000023','48000402101',' 48000402201','7130000023','48000402101','48000402201' ,'48000402001','3340007010','48000215401',' 48000215501','48000215701','48000215801','48000402001' ,'3340007010','48000215401','48000215501',' 48000215701','48000215801','3340006508','48000215601' ,'48000402401','48000402501','3340006508','7130000080' ,'7130000081','48000215601','48000402301',' 48000402401','48000402501','48000595801','7130000080' ,'7130000081','48000402301','48000407301',' 48000595901','48000720401','48000407201','3340007011' ,'48000402601','3340007011','72698423028',' 48000402601','7130000090','48000331001','7680851558',' 48000456001','72698423009','7130000090','48000710901' ,'48000456101','48000595701','48000100601',' 48000101101','48000719101','48000330801','48000456201' ,'48000330901','48000402701','48000455901',' 48000402701','48000456301','48000663701','48000168501' ,'48000281001','2409407001','48000404801','8147571412' ,'8147572543','8147590123','48000486801','8147540556' ,'8147571688','7151800017','48000700101','2409427012' ,'48000404601','8147594567','7038110015','48000404701' ,'7140303210','7140303210','48000583601','48000610201' ,'2409421101','2800069180','39153211605','39153211643' ,'2409407078','2409407118','83292400570','48000104901' ,'48000231701','48000231601','48000507301',' 2706457011','48000490601','79921066661','79921054540' ,'48000704601','48000231501','48000708901',' 48000709001','48000152201','48000149401','1122502881' ,'72698423501','48000596001','2100001373','2100001254' ,'48000149601','48000149801','2100001721','2100065321' ,'2100065655','2100065894','48000099401','48000357901' ,'48000666401','48000132801','48000128401',' 48000346301','48000650001','48000403101','48000432201' ,'48000423701','7293469248','7293469266','48000628901' ,'48000698501','48000234001','7341605091',' 75928340003','48000115801','48000116201','48000623301' ,'48000228001','48000462201','48000593701',' 48000100301','48000148401','5100017345','48000348601' ,'48000352101','48000227501','48000227901',' 48000148601','48000276601','3620003800','48000227701' ,'7248600130','3620000550','1700000389','63898200010' ,'63898200013','48000103601','7071800108','7071800109' ,'7071800110','48000428101','4119607105','48000395401' ,'48000610001','48000664001','4119606082',' 48000486901','48000572101','48000612801','48000594101' ,'48000594201','48000401901','48000127201',' 5150020441','1600018980','48000127301','4163100056',' 5150042000','1600010710','1600013310','48000273501',' 1792900028','3320001155','72698403050','3320001710',' 3320001110','76172098818','3320001140','7985100424',' 1990000320','4161700220','1990000385','48000624601',' 5000025045','5000027045','3997800309','85756500000',' 3997800304','3997800125','3997800462','3997800454',' 3997800456','3997800467','48000272101','3997800464',' 3997802987','3997801381','73041600009','73041600005',' 73041600007','73041600010','7511912448','73041600001' ,'3680018646','3680018647','3680020170','3680020171',' 48000308701','4144930015','48000308301','48000279501' ,'48000308201','4144900140','3800007010','4300095802' ,'8449303124','48000268701','48000380701','3915600004' ,'7142902434','4123470911','7065100200','4123441611',' 3915600007','48000726801','1122504195','48000354301',' 1600045410','1600044030','48000285501','1090000383',' 74599890101','48000128901','72698401000','5150076642' ,'5150000285','72698401001','48000127801',' 48000356501','4144930006','48000129201','48000357501' ,'48000285601','1600014797','48000129101',' 48000285401','48000128201','48000099701','48000140301' ,'48000354401','48000418001','48000418101',' 4144930011','4144930129','48000285301','48000132501',' 1600027184','5150065330','48000127401','1600044530',' 48000132201','7596810504','48000451301','48000285701' ,'4144940028','5833601501','70875800101','48000583801' ,'5833615300','5833615250','70842308011','48000656001' ,'70559901117','48000748901','1122507501','1122507503' ,'1122507502','48000368401','1122507500','5446700431' ,'5446730254','5446730250','5446730256','5446730258',' 1600042940','3680009876','4144900135','4144940024',' 3680083880','48000474701','7891318606','7891317028',' 5110007903','5110007930','3900004521','3900004521',' 48000352701','5110007927','5110007915','4164200111',' 48000298001','48000298001','76848810019','70210104533' ,'70210104543','48000366001','70210104503',' 70210104794','4164200149','7065000005','70210104513',' 70210104523','7065000006','6970230011','6970230013',' 48000573301','73449217561','73449270339','48000354801' ,'48000105601','76172005140','48000178801',' 72698439000','48000624501','72698439003','48000723501' ,'72698439001','48000263301','5150000956','4300000037' ,'64420929047','48000570601','48000705301',' 48000705201','71028232832','71028242832','1600019426' ,'48000285101','2996800189','72698402201','1600028282' ,'3979600270','4144900202','4144905000','4144905010',' 48000285001','3000005300','4144900160','48000284901',' 48000168401','1480071249','5390000031','48000197001',' 7245788066','48000442701','4163100055','70559901112',' 48000488101','4144905005','7468300551','3905955112',' 73449287005','73449287005','7489000112','48000506901' ,'5446700461','6827000301','6827000302','72698439100' ,'3905972984','7222080594','7222080545','7222080546',' 7222080570','7222080571','7222080574','7222080575',' 7222080576','7222080577','7222080587','7222080597',' 48000415101','48000415201','48000415301','48000119701' ,'7222080555','7222080567','48000182701','48000182901' ,'48000182801','48000182601','4245605052','4400001837' ,'48000318201','4400004557','4400004558','3010038387' ,'48000168801','3010010135','48000128701','3680011962' ,'48000200001','48000676501','4400000365','4400000068' ,'48000099101','48000231301','6731200525','6731200551' ,'48000367401','4400000379','48000373901',' 48000237701','8201118371','8201191257','8201198466',' 48000738401','48000219201','48000318101','48000319001' ,'2410041429','48000318501','48000318401',' 48000199001','4400000699','4400004631','48000199401',' 3010046445','4400000335','48000199101','48000318001',' 48000319301','4400000159','48000681401','48000680901' ,'3010090011','48000681301','48000119901',' 48000319401','48000168901','48000199801','48000318601' ,'48000320001','48000189001','48000318301',' 48000119201','48000119301','48000712401','48000119001' ,'48000681201','48000681701','48000731401',' 5565366930','3361741001','48000365401','48000365401',' 7107200307','48000367501','48000306801','48000672801' ,'3361759628','48000391901','48000208801',' 48000582101','7056910220','7056920030','7056935040',' 74988013090','5929057218','48000268401','48000672001' ,'70175068433','48000684001','48000613901',' 7056981430','7056981340','39047014589','3904701458',' 48000683801','48000683901','48000623101','48000388901' ,'48000234101','75928320008','3680015124','3680015126' ,'3680015123','48000622101','48000622301','1410007487' ,'1410008932','1410008943','1410008947','48000119801' ,'1410007447','48000319601','48000241101',' 72698409120','48000317701','3680010220','72698409122' ,'48000319101','48000264401','48000712301',' 48000199201','48000199701','4400000118','48000317601' ,'72698409102','48000485701','48000319501',' 48000317201','48000199901','48000119401','48000119601' ,'3680012218','48000168701','48000168601',' 48000319201','48000690901','48000673801','48000296701' ,'48000501401','75928310046','48000661301',' 48000661401','48000116001','48000691201','75928310005' ,'7341600023','4165104000','48000631301','48000395701' ,'48000395701','48000587801','7110500001',' 48000102601','48000614001','48000103401','48000515601' ,'48000164501','48000380601','48000439001',' 7731400202','7846642300','48000215901','48000164601',' 48000710801','48000380801','48000592201','7067000956' ,'48000704201','74988011079','48000299301',' 48000367601','48000299301','60587000117','7581000015' ,'7581000016','48000319701','48000561601','5929034237' ,'48000369601','5929057461','48000631201',' 48000198701','48000723201','48000198601','48000198801' ,'48000198501','1122502056','3680031032','72698409101' ,'4400000064','4400000386','48000317301','72698409100' ,'3010000133','4400000501','2020008511','4400002006',' 48000593901','3010018201','48000199501','3010042945',' 3010042950','48000317801','48000599201','48000599301' ,'48000126401','48000126501','1580003048',' 48000002401','72698438000','1580003058','1122541560',' 1580003636','4480000101','48000591101','48000591201',' 4480000145','4480000102','30025810950','4480040250',' 4480000103','1580005012','4480045002','4480000107',' 4480075005','72277622701','4480045006','72277620180',' 72277620002','72277621002','72277623032','72277621004' ,'72277620003','4480000144','1580008861','73449228730' ,'48000607701','1580008913','72277623001',' 81097900120','71706723000','7180082830','72698432026' ,'72698432027','2700061226','48000180101',' 48000356001','3377609500','72698432002','2700061286',' 72698432009','72698432012','3377609140','5150025362',' 5150025151','2700069086','5150099283','5150016948',' 2700069061','48000371601','72698432003','72698432040' ,'2900007827','48000597701','72698432022',' 48000355901','6414403009','48000371701','6414403031',' 6414403017','5150023913','5010050350','48000385901',' 48000356401','72698432000','48000356301','72698432035' ,'5150024275','4125311106','7040400022','72698432028' ,'48000427401','48000597601','87358900016',' 48000357801','7040400008','7321000009','7321000017',' 7321000011','7321000018','72698432036','7321000054',' 87358900014','7321000051','7321000015','7321000013',' 7629000206','7040400116','7224826660','3915350045',' 85719000031','48000577001','48000577001','48000415501' ,'48000606101','2325411121','85719000001','3915301006' ,'48000342401','4125300037','2409448002','2409448002' ,'4125300039','3915310019','85719000041','74504207016' ,'3915310078','7321400635','48000654701','85719000021' ,'2920500051','73449245590','48000103101',' 85719000011','82466200002','74747900050','3915310016' ,'1122506025','72698432100','48000731301','3915301010' ,'64850501500','4122470664','3915341279','3915341279' ,'7067001111','3915301002','3915301002','4122470660',' 64850501500','70827151017','64850503500','2409448001' ,'48000567001','85719000057','85719000067',' 3915310040','82680400777','3680013203','48000236001',' 48000234301','48000494901','3680008158','3680008491',' 7724150070','1251110500','48000459001','7724159128',' 72958201281','48000676001','71612312591','1251144641' ,'3680013434','3680013435','48000718001','85832000005' ,'1251144471','1251140600','1251160000','85832000002' ,'4161700225','4161700225','48000501501','48000236301' ,'3004290519','7638400097','3680014320','48000236401' ,'3680009746','48000227401','48000227001','7724150050' ,'3680007949','1730090791','1730090794','48000385701' ,'7045024891','48000386101','7045074391','48000385801' ,'7045084891','1730090792','1730090795','7045084191',' 7045004441','7045004151','48000386001','7045004231',' 1730090678','1730090680','7045014251','7045014231',' 7045004210','72698403010','4300027678','48000217401',' 48000613101','4300025235','48000312101','3400005200',' 3400005300','48000312201','3400014600','48000717201',' 48000185701','3400014830','4000002931','48000218401',' 48000613201','72698403000','7570003208','3120029451',' 4114309071','74759962018','48000673201','2800010233',' 2800010238','4114302956','4114308956','4114302570',' 72698415108','72698415101','88428404015','4114302870' ,'4114302010','72698402146','4114302900','4114302460' ,'88428404025','4114305160','4114308808','4114308908' ,'80276333120','4114304100','48000637301','4114307020' ,'48000276801','48000276901','3120000159',' 48000739101','4114307240','4180058050','4114307170',' 4114307125','48000431301','3120029450','48000637401',' 80276302880','48000637201','88428404220','4180058200' ,'4180058290','80276307330','4180058000','4180058019' ,'48000719001','2460004212','2460000039','2460000050' ,'2460001086','48000597501','72698431147','2460001841' ,'48000169501','48000103301','2460001093','2460001097' ,'2460001700','2460001058','2460001041','2460001987',' 2460001981','1122502032','4760001012','48000361801',' 1122502287','2150000070','4760001006','4760002326',' 4760054961','5210000232','5210000257','5210000428',' 5210000843','5210074603','5210074604','5210000534',' 5210000696','5210000283','5210000438','5210000355',' 5210000284','5210082791','5210000352','5210000320',' 5210000332','5210000295','5210000626','5210000381',' 5210000448','5210000418','5210050102','5210082790',' 5210000298','5210000375','5210007091','5210007092',' 5210000426','5210000286','5210000838','5210000647',' 5210000698','4760062420','5210000236','8105702032',' 8105702035','4760003094','48000334501','5210000241',' 4760003113','4760003114','4760062409','5210007073',' 5210007078','5210000218','5210000251','5210000247',' 48000334601','5210000508','5210000261','5210000258',' 4760003180','4760003089','5210000292','5210000326',' 5210007450','5210052338','5210066585','5210082328',' 5210000442','4760003120','4760003134','5210000233',' 5210007107','5210016025','4760023055','48000334401',' 5210058187','4760003056','4010000392','1122502879',' 4760003118','4010000391','72698431103','8105702038',' 4760003099','3600651929','72698431100','4760003054',' 4010000268','4010000266','4010000351','4010000352',' 48000273401','4010000257','4010000241','4010000263',' 4010000262','4010000224','4010000303','4010000272',' 4010000294','4010000293','4010000211','4010000225',' 4010000273','4010000274','4010000275','4010000217',' 4010000356','4010000208','4010000282','4010000226',' 4010000237','4010000345','4010000349','4010000347',' 4010000223','4010000280','4010000357','4010000348',' 4010000204','4010000289','4010000249','4010000291',' 4010000325','4010000353','4010000270','4010000281',' 4010000233','4010000292','4010000339','4010000298',' 4010000304','4010000251','4010000284','4010000243',' 4010000267','4010000385','4010000234','4010000277',' 4010000319','4010000206','4010000231','4010000236',' 4010000309','4010000269','4010000260','4010000307',' 4010000297','4010000202','4010000229','4010000244',' 48000273201','4010000216','4010000315','4010000283',' 4010000258','4010000316','4010000271','4010000230',' 4010000302','4010000485','4010000218','4010000215',' 4010000288','4010000279','4010000207','4010000312',' 4010000227','4010000295','4010000209','4010000228',' 4760062107','4010000354','4760009152','4760062204',' 48000335101','4760062109','4760062186','48000335401',' 4760062114','4760062215','4760062217','4760062211',' 4760062112','4760002208','4760062111','4760062105',' 4760062218','4760002240','4760001015','4760009070',' 4760062404','4760002253','4760009015','4760002205',' 4760009020','4760002365','4760015050','4760015051',' 4760002289','4760062305','4760062401','4760062222',' 4760062206','4760062108','4760002280','4760002327',' 4760054967','4760062101','4760062302','4760009080',' 4760062208','4760062110','4760062219','4760062209',' 4760002314','4760062205','4760009065','4760002332',' 4760002335','4760002331','4760062202','4760002364',' 4760002251','4760002274','4760001013','4760012277',' 4760062207','4760002276','4760062213','4760012368',' 4760012369','4760002213','4760062220','4760062201',' 4760002168','4760002353','4760002112','4760002027',' 4760062102','4760002037','4760002254','4760002269',' 4760002019','4760002185','4760002318','4760012330',' 4760002216','4760002337','4760002333','1122502873',' 7199800001','4480000022','4480000401','4480000402',' 7038110009','48000157801','4010000622','4010000623',' 4010000617','4010000618','4010000615','4010000619',' 4010000624','4010000625','4010000626','48000243101',' 4010000296','4010000621','4010000620','4010000616',' 73402790160','48000360601','5210000245','5210035224',' 5210069313','5210056922','5210056923','5210058500',' 48000335001','4760009134','5210025213','48000334101',' 48000739301','48000360801','2150005850','2150000074',' 2150000450','7038110011','5210005712','2150000300',' 2150000036','7038110000','2150000052','4780000054',' 5210012267','5210022534','5210022586','5210022598',' 5210025711','7142912100','5210000361','5210000423',' 5210000539','5210000627','48000360701','5210084733',' 5210044163','8105702024','8105702026','7142901565',' 8105702022','8105702023','48000673501','5210044339',' 48000450501','48000361901','48000361501','48000665701' ,'3915600008','48000384601','48000104601','8105701870' ,'4799712385','4799713020','48000704501','48000710501' ,'48000342301','8105701510','4430009428','8105701640' ,'48000484501','4127800005','8105701985','8105701965' ,'4799712385','8105701275','4799713020','8105701180',' 8105701966','8105701080','8105701641','8105701937',' 8105701440','48000361301','48000443201','8105701081',' 82680400888','8105701165','8105701170','7142912430',' 8105701840','8105701218','48000478101','8105701205',' 8105701960','8105701830','8105701450','8105701720',' 8105701890','48000335201','8105701325','8105701531',' 8105701453','8105701012','8105701350','5210044518',' 5210044639','4799713010','8105701420','8105701636',' 8105701750','8105701451','8105701421','8105701745',' 8105701650','8105701540','3600601408','8105701400',' 8105701240','8105701470','48000484401','7067000523',' 8105701250','8105701745','8105701245','8105701324',' 8105701090','7142910525','48000576901','8105701940',' 8105701611','7435000002','8105701653','8105701610',' 7067000511','7067000512','8105701095','48000441301',' 8105701310','66780300070','8105701260','1878810109',' 7435000003','8105701155','67236100030','8105701265',' 1878810250','48000666901','89954900049','4010000314',' 4010000317','4010000318','4010000334','4010000335',' 4010000336','4010000337','4010000338','4010000340',' 4010000341','4010000342','48000334301','8105702088',' 48000597401','4760009030','5210008980','4760009035',' 4150005834','48000277001','5210009860','4760008157',' 4150005802','5210060605','4150005848','4150005711',' 4150005712','4150005811','4760008242','4760008116',' 4150005845','2150020205','48000597301','5210009160',' 5210009180','5210027462','5210076067','48000361001',' 2150020208','2150022600','5210014260','48000334201',' 48000335301','4150008010','5210094269','48000360901',' 4150005773','2150011700','2150020200','2840000239',' 2150022500','5210065128','5210065188','4150005864',' 48000327501','48000327601','48000327701','3900000820' ,'4150005890','7488200100','7239610000','7488200100',' 5210044288','7109200069','4600028874','4150103010',' 48000287001','4150008005','2150011100','4150005807',' 5210009140','4150005710','2150011300','48000521301',' 4760008192','48000334801','48000334901','48000335501' ,'5210015733','5210051598','4760008252','7038180068',' 7038100068','4760008104','4760008283','4760008102',' 4760008274','5210052178','48000349501','48000114301',' 48000349001','5100015032','48000514501','48000514401' ,'48000514601','48000361401','48000361601',' 48000361701','48000334701','3620006405','5210068452',' 48000361101','7038110100','48000104701','48000338001' ,'4114901182','48000337901','48000338101',' 48000444501','48000521401','7488820201','48000337501' ,'48000337501','3804125600','6205813984','1121000400' ,'5150000025','5150002118','5150002501','72698410100' ,'48000354201','48000423901','48000217201',' 5150002123','5150002511','5150002512','3400031500',' 3400000017','3400000125','3619212077','48000217001',' 3680064606','3010012724','3010029835','48000199301',' 48000417601','48000593201','48000559701','60069966073' ,'4164200500','72698404005','60069966145',' 48000100001','4300021200','48000311301','48000311401' ,'48000311601','48000179501','48000100101',' 48000311701','48000311801','4300021100','4300021363',' 48000309401','48000149701','48000150901','48000179401' ,'48000179601','2070042701','48000312001',' 48000311901','4300022802','4100003500','7067000400',' 5833614111','5833600006','5833602220','48000368301',' 7334735500','4300025953','87251300602','2550006319',' 2550081121','2550081122','2550000365','2550006764',' 4300071085','72698407023','72698407026','48000256201' ,'76211172857','76211172859','76211172857',' 76211172859','48000593601','72698407063','72698407062' ,'48000615001','48000629901','48000629801',' 48000576801','48000620801','7056810010','48000623901' ,'48000113501','48000569601','48000569701',' 48000716401','48000579201','48000624701','48000624801' ,'48000624901','48000624901','48000445801',' 48000445701','1291912615','48000233601','48000113601' ,'48000607401','7447100079','7447100075','2550000032' ,'48000677301','2550000034','48000677201','2550000080' ,'65272912955','72698425045','48000173101',' 48000343201','48000244401','1122542286','72698425032' ,'5000030302','5000030162','48000241201','72698425030' ,'5000030212','48000512301','48000512101',' 48000308101','48000310101','48000512201','48000406401' ,'4300070700','48000185601','2800059643','7447100091' ,'74599840105','74599840405','74599840300',' 4195302703','48000686901','71612312353','68995171225' ,'68995111020','48000686801','68995131070',' 68995191000','68995171010','68995112020','68995112005' ,'68995131010','68995111000','68995131060',' 48000235901','48000333601','48000390901','48000391001' ,'7073407049','48000457001','7073405372','4744591921' ,'4744591991','48000457101','7695045063','70708270008' ,'7695045018','7695045036','48000685401','48000579101' ,'63243296201','63243296801','48000566601',' 48000583201','48000749301','48000678301','72698407057' ,'72698407060','72698407059','72698407054',' 72698407058','72698407056','72698407055','72698407061' ,'48000248701','3680096672','5000060012','48000605301' ,'3680096314','48000244701','48000126001',' 48000343801','1570005551','2800081320','48000126201',' 48000344001','48000343501','48000102801','75174603212' ,'75174603361','1570005517','48000126101',' 48000241901','48000219101','48000689401','1122502882' ,'1115605152','4100000845','4100000286','72698440000' ,'2070000500','4100000271','2070000319','4100000267',' 1115605450','4100000287','4100000753','2800033980',' 4100000873','48000275101','68995111035','68995171140' ,'68995171100','4100000847','48000366701',' 48000462301','48000149101','48000462401','48000416001' ,'48000416301','48000416201','48000381501',' 48000381601','48000180301','7073400403','4100000848',' 4100000843','48000103201','48000416101','48000381401' ,'7231007248','2040107640','48000663001','48000639601' ,'7369562770','66780300090','48000683401',' 48000664801','3680014443','3680014444','89672300002',' 3680044017','48000104201','48000101501','7829121926',' 48000210501','3700043516','3700043515','7048101101',' 4460001151','81793900060','48000256801','48000475201' ,'2570023223','48000641501','2570023223','48000321901' ,'4460000604','1920000888','1920077182','48000321801' ,'48000321501','48000321601','1920078914','4460030209' ,'4460000450','4460030311','48000739201','48000210601' ,'48000370901','48000640701','3700004249',' 81143500190','3680077382','1122502613','1980070110',' 48000146801','4191100050','4460000454','48000147001',' 1980010122','3680077638','3680077639','1122504044',' 1750004403','2340000240','79271600064','67811219497',' 3320035240','79271621050','1750004403','2570023338',' 4460001260','67811219490','79271600064','3320035240',' 67811256032','79271621050','48000164901','2570022172' ,'4460001263','67811219492','2570070164','4460008033' ,'4460030057','48000164801','48000174001','2570022174' ,'4460001580','48000321701','4460001195','48000174801' ,'4460001204','1920002699','4173726076','2570070079',' 75703735018','75703735015','3680011341','4650022220',' 3700032695','3700034285','3680011342','3680011343',' 1920005432','4650000182','4460014901','4460014902',' 3680011344','3700008441','48000257001','48000257601',' 4460014903','3700030942','3680077379','3320000855',' 1122542356','1121804645','4650026363','4129440174',' 4159816018','48000281601','6233801863','4460000453',' 4650012128','48000329101','4650070350','48000328301',' 1112410014','4460000229','1980000116','1980012738',' 4460000221','1980000111','4460000228','48000697401',' 4460000214','1920080306','1122505476','4173726901',' 3680013510','2120097852','2120097878','4460014882',' 48000321401','48000146101','4460000451','48000174701' ,'2570021548','1980000117','4191100824','6233800178',' 48000370501','3320006800','48000096601','1112100040',' 7161811510','7829116911','4159814038','48000470801',' 48000255801','4331813022','7829131082','48000255401',' 4159800054','4159800052','4159800050','5113197289',' 5113197296','5113197270','5113197271','4159880807',' 81793900401','81793900084','81793900731','81793900732' ,'48000640801','48000640401','81793900562',' 81793900008','85695400000','85695400002','85695400004' ,'85695400003','48000242601','48000242801',' 5908021002','72899721000','71725600053','72899722000' ,'73291322714','73291355501','73291355503',' 4650014324','48000329601','48000146001','4650061577',' 4650061581','48000330101','48000707101','48000174401' ,'4650061829','48000255001','4650070340','4650070341' ,'6233878047','6233880339','4650000684','4650070342',' 4650017888','48000370701','4650023314','48000329301',' 2340033045','48000707001','4650017598','48000328001',' 48000328101','4650015877','3700012587','48000250901',' 4650070349','4650070533','2340033042','48000370601',' 6233805768','48000165101','48000328201','48000329401' ,'48000146901','48000253501','48000165001',' 4650061649','48000641101','48000329201','48000329701' ,'48000330201','48000641301','48000641201',' 7954222007','48000520301','48000641001','48000688201' ,'48000711301','4650015476','48000329501',' 48000209701','1112000534','74267830014','48000330301' ,'1112000399','1920000601','1920000619','74267810002' ,'7973800032','48000688101','48000209301','3700035535' ,'3500033860','48000258401','3700035534','3700032368' ,'48000099901','48000221301','3500043300',' 48000233901','48000640501','88596743528','48000254301' ,'3700000614','48000249801','3700011094','48000254201' ,'3700042902','3700014389','48000322501','48000220801' ,'3500046902','48000254001','48000254101','3700000080' ,'48000244601','48000254501','5170078234',' 48000248201','48000257301','48000257401','48000248101' ,'5170075708','48000221201','3500047805','48000358501' ,'3700000634','3700000635','5170080312','48000358401' ,'5170036565','48000242701','5908012022','5908020002' ,'48000104801','48000518201','7261301107',' 48000244001','48000243801','48000258201','48000096001' ,'48000209501','48000209601','88304906690',' 3700013844','48000326601','3700012873','3700012786',' 48000247501','3680022049','4460001692','4460002450',' 48000322101','4460002901','48000322001','48000247701' ,'4460030036','4460003096','2420000981','2340000201',' 80575225547','4460004690','48000322301','4460030038',' 3700001870','75703751555','3680077645','3496937816',' 4650002274','48000328901','48000697301','3680013363',' 75703751244','75703751693','75703751515','75703751299' ,'6233877667','3680077641','4460030218','3700019737',' 3700019743','48000256301','79922800903','48000250101' ,'48000709401','68727311106','48000704301',' 7044491208','4650002246','6233800006','6233800230',' 48000169301','48000257801','48000250801','48000258901' ,'48000247901','48000242201','48000247801',' 3680077410','48000248001','48000209801','3320014271',' 48000251001','48000259301','48000660701','2240000441' ,'3700033697','48000370801','7061000501','7061000503' ,'7061000500','7061000105','7061000518','7061000115',' 7061000519','1440082000','1440083000','1440083000',' 1440061171','1440061171','1440061162','1440061162',' 1440061170','1440061175','7061000087','7061000070',' 7061000088','7061000071','48000120501','1440061180',' 1440071400','1440024100','4300029343','1440071200',' 4300029320','4300029106','4300029322','7851212001',' 48000077101','4460030059','4460071724','48000076901',' 1122505740','3680017433','4460071254','48000102901',' 48000103001','48000276701','4460030215','1122504224',' 4460073137','4460071711','4460071701','4460071723',' 4460071700','4460071706','4460071176','48000070901',' 1122504610','48000071101','48000101701','48000071001' ,'4878911003','48000287701','48000069801',' 48000008801','48000070001','4878904530','4878902122',' 48000002301','2460001500','1122542304','3680077301',' 3680077303','3680077299','1090000024','3680077302',' 1090000114','1090000021','3680077327','2570000130',' 3680077326','48000246601','3680011394','1258700020',' 1090000531','1258770441','1090001331','1090000392',' 48000112501','3680077307','3680014164','1122542314',' 48000174101','48000246001','3680011397','48000112701' ,'3680077306','48000245901','48000173801',' 48000246701','48000246801','48000246901','1258770707' ,'3680077314','3680077310','3680077311','48000246201' ,'48000246101','3680077319','48000173901','3680077324' ,'48000246401','48000246501','1370081222','1370081417' ,'48000116501','48000174901','2570015621',' 48000174301','48000173501','48000173601','48000698401' ,'48000094801','2570001143','3680077312','3680077313' ,'3680077317','1090000510','1090000590','1122505784',' 3680077325','3680077354','3680077365','3680077353',' 3680077350','48000247001','1258760172','1258760933',' 1258770067','3680017420','3680077375','3680077355',' 3680077363','48000247401','3680077349','3680014272',' 48000116401','48000247201','3680077352','48000247101' ,'1370020920','48000112901','3680013345','1370000662' ,'1121798611','1121798610','48000173701','3680077332' ,'3680033592','48000243001','1258770129','48000174201' ,'48000174501','1258778082','1258778082','1258770108' ,'1258770108','1258770240','48000112801','1258770240' ,'48000112801','48000174601','1122564124','3680077269' ,'1122502099','3680017498','48000243301','3680077270' ,'4200014207','48000243401','4116501739','3680077446' ,'48000248301','48000709501','48000709801',' 3770032279','48000262901','48000729301','48000244901' ,'48000303001','3770032226','3680077272','3680013437' ,'3680017501','48000243501','3770032348','3680013761' ,'48000240901','48000241001','4142600991','3680013756' ,'3680013757','3680013758','48000238101','3680010923' ,'48000340801','4878941860','3680013753','4878941265' ,'3680077440','3680077449','48000248501','4200015627' ,'4200043295','3680077448','48000248401','3680077267' ,'3770038254','3680017502','1122502320','3680077265',' 4200015613','48000277201','3680077273','4200014011',' 4200043900','4116539020','3680014334','3680077268',' 4116508799','48000727601','48000727401','3600025152',' 3680077284','3700007548','3600028110','72698426005',' 72698426006','3700007545','48000226001','3700033549',' 3600028100','48000225901','3600028200','3600028201',' 3600029490','48000226101','3600029440','48000677601',' 72698426013','3770033334','72698426012','7331045200',' 3680077292','48000709601','3600046150','4200035501',' 1122508032','1122536952','48000252201','72698426703',' 72698426015','4200096031','3600072484','48000200501',' 4200096042','4200086532','3040076103','3040076388',' 48000200401','3600072442','48000252101','5400042401',' 3600067207','1122504403','72698426009','72698426011',' 4200044711','72698426285','4200044702','4200044811',' 4200044845','3700016821','48000255701','3700021359',' 48000365001','5400016445','3600019208','3600019266',' 48000225201','3600014190','6366835104','3680018007',' 3680018009','3680018008','48000230401','48000311201',' 3680014725','48000712701','3800034352','48000265101',' 48000244301','4300001760','1600029860','1600066450',' 48000263701','48000197701','48000263401','48000264201' ,'48000718301','48000128601','48000714301',' 48000714401','1600014624','48000127701','48000265201' ,'48000265301','3800044548','48000197801','3000045130' ,'1122502047','48000242501','48000264801',' 48000127601','48000264501','1600017314','48000128101' ,'48000128801','7912600830','48000712601',' 48000674701','48000598201','48000107201','48000190201' ,'48000192701','48000598001','4886731216',' 48000724601','48000431801','48000598401','48000468101' ,'48000729401','48000188901','48000192301',' 2840007096','2840007097','72698429085','71921210105',' 2100001374','2100001376','48000190401','2840007089',' 2840002658','2840007835','48000189801','48000191401',' 48000253901','7492340527','48000128001','48000129001' ,'48000132401','48000262801','48000522301',' 1600028370','1566560104','48000125901','75535500210',' 75535500214','48000429001','7698254501','48000722301' ,'48000727801','8411410597','48000495101',' 48000126601','48000495201','48000495001','72822901315' ,'48000126801','1122541633','48000597901',' 48000186501','48000452101','48000452201','48000717901' ,'48000729001','2700048089','48000179801',' 48000129401','6414415050','48000129301','48000180001' ,'48000148301','48000186301','48000216301',' 48000179901','48000597801','72698433001','48000186401' ,'72698433061','2900007337','2620000710','1122502827' ,'48000296801','72698433072','72698433073',' 72698433079','72698433070','72698433071','48000598101' ,'48000195801','72698433076','1122502828','2900007280' ,'72698433062','72698433063','48000296501',' 48000195901','48000296601','7299204002','72698433055' ,'72698433060','2900007345','48000195201',' 72698433054','72698433075','2900007215','2900007328',' 48000195601','48000195701','48000195401','7299204019' ,'48000424101','72698433056','72698433058',' 72698433057','72698433059','48000176401','48000092001' ,'2620046878','48000092101','48000176501','1030080321' ,'48000195301','2900007313','2900007329','1411373406' ,'9510817100','1030093621','1030086301','1030033601',' 1030033301','48000233801','7038110040','3000027163',' 48000372101','6414410974','48000576201','2700060716',' 48000521901','3000002913','48000620901','18033245108' ,'8558204111','85685600103','85685600104','4256300876' ,'4256300923','72698433065','72698433068',' 48000683701','72698433067','72698433066','48000312401' ,'48000738901','4300095350','4300095353','48000309801' ,'48000312501','48000308901','7239285100',' 48000388001','48000664501','4300090248','4300010340',' 48000310201','48000309301','48000312601','48000309601' ,'48000309901','48000310001','48000171601',' 48000303201','48000565301','4900003075','48000565201' ,'7800001840','48000468304','48000469106',' 48000469803','48000690804','48000469403','48000468402' ,'48000710002','48000568701','48000568802',' 48000568804','48000568805','3410066805','9879431304',' 5096833001','48000703501','48000469602','48000469502' ,'48000703401','48000598701','7800014545','8634191240' ,'7065596030','7065596030','48000598601','7065599478' ,'48000389901','1660000074','1660000071','7065590412' ,'48000390101','48000134401','48000134401',' 7065590121','7184509830','48000415401','48000104301',' 7065593521','48000390001','48000101801','48000394501' ,'48000628301','48000628402','7246300027',' 48000387301','48000571101','48000628302','48000134501' ,'48000134501','7549600040','7065591221','48000672601' ,'65487104901','48000620701','65487100903',' 48000645601','87917400011','7514000515','48000603201' ,'48000001601','48000001701','48000003601',' 72698461506','3768800010','48000070301','72698461505' ,'48000428301','48000072801','7114222439','7114242378' ,'7114200948','48000568601','48000134306','3049488122' ,'78616250700','48000569202','63256500002',' 63671110107','63256500001','48000068901','18473900013' ,'48000598501','48000662703','48000662803',' 48000662709','63791011389','63791021773','48000104501' ,'48000104401','48000452802','48000569102',' 48000705405','48000452602','48000109101','48000641809' ,'48000392002','48000392006','48000392103',' 48000392105','48000568904','48000641610','48000562505' ,'48000562506','48000562510','48000392005',' 48000392104','48000641611','48000641612','48000564909' ,'48000718105','48000562804','48000562805',' 48000562809','48000109206','48000108104','48000108106' ,'48000109204','48000392302','48000392306',' 48000392305','72698477027','72698477029','72698477030' ,'7294570544','7222010070','7222010071','7313035200',' 7222000006','7294560133','7294560154','7294561012',' 7313038005','72698477120','72698477121','72698477122' ,'72698477123','72698477124','72698477126',' 72698477216','72698477031','48000603801','3149324242' ,'3149382888','3149302160','3149354371','3149324242',' 7294571589','7294571588','48000495401','8421300078',' 8421300662','48000495501','7313000161','71873800051',' 71873800052','71873800054','48000588401','7067001101' ,'7056985240','2018200310','7304015410','7304000205',' 7304006210','7304006250','48000425201','7304006215',' 76011614610','7294511305','7102505723','7294555065',' 7304006305','48000425301','76011600050','7222000077',' 76011600050','2415212377','7294576444','7294535066',' 7294535068','7294535069','7294535070','7294561003',' 7294576431','7294576430','72698477110','72698477111',' 72698477113','48000604101','72698477112','72698477226' ,'72698477228','5960800800','72698477108','7304015400' ,'7294555044','7222000193','72698477104','72698477218' ,'72698477220','72698477224','7313000036','7313000078' ,'7313000079','48000426301','7294576146','7222000233' ,'7222000234','7294560146','72698477106','48000604001' ,'5040075116','72698477116','72698477131',' 72698477401','7294575116','7294576145','7304000558',' 7222000235','7222000271','7222000232','7222000296',' 48000443301','48000443301','48000678101','48000678201' ,'48000119101','72698477009','72698477009',' 7432309501','7432309523','7432309104','48000437801',' 4500000001','4500000001','4500000002','4500000002',' 4500000014','4500000014','4500000025','4500000025',' 4500000028','4500000028','4500000029','4500000029',' 4500000031','4500000031','4500000037','4500000037',' 4500000039','4500000039','4500000041','4500000041',' 4500000096','4500000097','4500000098','4500000139',' 4500000139','48000325001','7432309104','7432309113',' 7432309122','7432309123','7432309145','7432309157',' 7432309173','7432309501','7432309535','7432309585',' 7432309103','7432309182','7432309183','7432309506',' 5739140002','48000398201','5739140002','7432309524',' 48000373101','7432309971','7432301061','7432305156',' 7432304704','48000430101','7182800105','48000429901',' 7349012383','7270020038','8468500009','8468500005',' 7022750125','7754478930','7022750181','7754482600',' 7022750008','7270010188','7270010217','7042000801',' 7022750064','7022750166','7754480620','7270010128',' 48000274901','7270010404','48000421001','7022750063',' 7022750051','7270000007','7270000011','7270010413',' 7693700285','48000420901','7270000048','48000420701',' 48000420801','7270000738','7270010202','48000382401',' 7270000064','7270006235','7349000000','7270000099',' 7270000037','8468517007','8468540004','7270010084',' 7270010181','7270010208','7349013104','7349012833',' 48000430001','7270000473','7030302216','7270010079',' 7270010096','7270000041','7693799000','7349012501',' 7270000003','73537560125','7270005606','7270010180',' 7270000090','7270000091','7270020001','7270000173',' 48000189301','48000596801','48000320301','48000320401' ,'72698429082','2840000417','4600027918','4600081101' ,'48000268301','7488201060','48000191501',' 48000432001','48000192201','48000189901','48000596901' ,'48000596701','48000480301','48000280101',' 48000280201','48000280101','48000280201','48000148501' ,'48000588901','48000294701','48000295301',' 48000295101','48000411501','48000411701','48000294801' ,'48000295201','48000411601','48000411401',' 48000287101','48000411301','7210101265','72698429083' ,'48000280301','48000280301','3900001039','7210101270' ,'3900001001','3900001021','4150101006','4600083251',' 7210104620','3900001010','7210104650','3900001011',' 48000597101','48000411801','48000327801','4430010645' ,'4150110008','4150100898','4600086031','48000287201' ,'7210101519','4150111008','8062141163','48000731601' ,'48000560901','48000100201','48000560801',' 3390750012','48000216701','48000216501','48000216601' ,'71921210102','2013813611','48000147701',' 48000295501','8634113140','8634190112','8634190212',' 48000713201','4856422012','7373100766','48000702401',' 7373100419','48000702501','48000702201','48000724701' ,'7373100116','7111700109','7111700112','7885802018',' 7885852039','48000686601','7934106008','7373100240',' 7373100118','48000724801','48000340301','48000708701' ,'48000431701','7373100205','48000708601','3723200104' ,'7934101176','67979000026','48000578401',' 48000578501','48000578601','67979000559','67979009026' ,'67979000030','67979000915','67979000053',' 67979000683','67979003910','48000717301','67979001054' ,'67979002642','48000710301','67979002662',' 67979002673','67979001601','67979001631','67979001661' ,'67979001651','67979001653','67979001672',' 67979001685','7698242410','48000578701','67979002652' ,'67979005634','67979005663','4856400118',' 48000701701','48000726001','48000701901','4150584108' ,'4150584109','4150581200','4150581201','4150581202',' 4150583001','4150583017','4150583101','4150583104',' 4150583115','4150583119','4150583124','4150583125',' 4150583142','4150583223','1238800005','48000109601',' 1200500572','3508412116','3508412111','3508412104',' 3508412107','3508412107','7124001166','48000222801',' 3508412150','3508412151','3508412151','73508412152',' 3508460416','3508412216','3508412204','3508461022',' 3508461022','3508461016','4133102146','3508412122',' 48000071401','48000071401','3508460422','3508412222',' 3508460422','3508412222','9733900002','68670010124',' 3862900112','68670010125','48000580201','3862900113',' 68670010140','68670010123','68670010134','68670010150' ,'68670010130','68670010133','48000580101',' 68670010141','68670010139','48000337201','48000615801' ,'1238800008','48000615901','3046700001','2800092112' ,'2800015785','48000205601','48000453501',' 48000453601','8766606616','9047821627','2986000301',' 72986000101','8615475139','48000515301','48000306101' ,'48000515201','8615415131','2800051720','7885300305' ,'68670010129','48000002201','2800051780','7239200309' ,'48000608201','72486900019','48000693401',' 4800171127','48000693301','48000423001','61994210101' ,'4122470806','4345607690','4345607700','4800171104',' 4800171103','4800171111','4800171138','4800171112',' 48000337301','7013207012','4800171108','4800171128',' 7538604986','7538604968','7538604975','7538604967',' 7423499113','7639700112','7639700312','7287828533',' 7538604974','7236000084','7423498113','7287828536',' 7639700212','7639700307','7538604701','7639700511',' 7287828543','7423499115','7423498115','7013200500',' 7538604966','7538604858','7423499112','7639700107',' 7538605643','7639700907','7639700128','7639700207',' 7639700328','7423498112','7639700828','7639700528',' 7538604976','7639701028','7423495113','7538604965',' 72745200011','7639700412','7639700412','7423459215',' 7639700228','72745200031','7538604973','72745200270',' 7538605124','7287828538','7287828548','7538604868',' 7013200603','48000398701','48000398601','7013200600',' 7013200100','48000380901','48000381001','7013200700',' 7013200750','5239185150','5239185151','7287851524',' 7287851527','7124000865','7124001132','7639720218',' 7124001167','7165100200','7165100202','4886711006',' 1587801250','5150016640','3729791447','4886711007',' 3729794447','5010050511','5010050365','5010050438',' 1200500007','4150112008','4150112017','7287827526',' 7788588200','7788571061','4973300005','48000436401',' 9733900003','9733900001','7013200501','9733900005',' 1295710001','48000228101','7236000208','9733900004',' 9733900006','7788589202','48000157601','7013200461',' 7287850523','48000324501','7538604995','48000447901',' 7236000005','7287827523','7287827533','7287827543',' 48000453401','48000453401','7236000202','7287827558',' 48000423101','7236000203','48000416601','7287827557',' 48000338301','1060962862','4886730305','1060980299',' 48000436301','7013209911','48000196101','4430012171',' 4430012330','48000743201','48000742301','48000743501' ,'48000742801','48000742701','4430012350',' 48000743401','4430012111','4261407006','4261407005',' 72155746081','1115209939','7613205002','1115203194',' 7482103008','1115223835','7613205022','48000742501',' 73805551691','1115203851','64595600102','73762801700' ,'7613205015','7613205023','7613205024','7613217021',' 1115245304','48000678701','7613217033','48000431201',' 7613299000','48000451901','7613217007','7613218001',' 7613217008','1115209633','1115204283','7254618138',' 7065080038','4783400005','1115220508','48000743901',' 7889513656','7889513655','48000743601','7889513654',' 7889513646','7889513652','7613209003','7889513657',' 4139000001','1121000918','7889513651','4139001052',' 4139002150','7356200090','18250300010','7581002125',' 7613209240','18250300004','7613205016','48000451701',' 7613209020','48000743101','7613209022','7613209034',' 7613209026','4139002045','1121000818','7389955250',' 4139004760','72233781904','1115206828','7613209029',' 1115209645','7613209025','2446306107','7613209030',' 7613205019','7613209021','7389901175','7613205018',' 4473807231','7980971945','4139000191','7613209030',' 7581002325','2446306104','7980947240','48000444401',' 4430012513','7581011225','7581014025','7505000616',' 48000445301','48000738301','48000284001','4139000002' ,'4139000005','4139002060','48000743701','48000743801' ,'1115209627','1115228647','18250300035','48000743301' ,'48000742401','7627700986','7627700989','2800051212' ,'48000184401','48000284101','3739831025','8817701104' ,'48000239801','7581000425','4473807234','48000743001' ,'73762800300','2446306116','7627700992','73762800300' ,'2800023529','48000283901','8634180416','74281231012' ,'73762800510','4139000110','74281231012',' 48000509501','4139000145','73762800510','4139000140',' 6970210003','7357554300','4139004200','48000284601',' 4139004120','7613213001','7613213003','48000430701',' 7356200230','48000451801','7613213002','48000444201',' 1115281760','2540780310','2540780350','4139003086',' 48000444101','4783400006','7737704830','7737711302',' 48000444101','48000444301','7357527725','73796400025' ,'7357529539','73796400025','48000389501','7613211201' ,'7613211001','7613211002','7613209012','7064100005',' 7357529550','7064100008','4139000460','7627700867',' 1115204730','48000097401','7627700983','7613209010',' 7613209015','7627700856','1115202140','1115203263',' 7613209007','1115206759','1115203260','7357597039',' 48000659001','7937700100','7356200055','7114631111',' 1115201057','1115202780','48000742601','4122483700',' 1115229100','7314115004','7314115005','1115285174',' 7314115083','1115285168','1115285171','73796400040',' 48000089101','73796400060','73796400060','48000678801' ,'4139000802','3114627060','48000452901','7618600018' ,'7114600014','3114615060','3114615030','7336610084',' 3114615030','3114615060','2446306109','4139002050',' 7737736196','4139003084','48000284501','7336610082',' 7336610089','4139000160','7441045509','7441025025',' 7482300114','48000609401','48000609401','7613216006',' 48000742201','48000652801','48000652701','7065080005' ,'7065080013','48000609501','48000609501',' 73762802660','7065080082','73762802530','73762802525' ,'73762802530','7065080009','73762802540',' 48000609201','73762802540','48000609201','73762800100' ,'73762800400','73762800400','7065080021',' 48000389601','7065080031','73762800500','6264606075',' 4139005004','4122487500','1122506709','73762807950',' 1115245343','1115203362','1115203023','1115202023',' 73762800600','73762800600','1115208335','1115227641',' 7175703001','1115217475','7281029358','7281029360',' 48000137201','7182800192','48000571801','7356200500',' 7093500700','7488002002','7114600011','7093500711',' 48000625701','48000653001','48000609101','48000609101' ,'48000366601','4139001556','48000097301','7482300021' ,'4139002081','7613213010','1115202401','7488002002',' 48000121501','80453111025','1115205043','7065080012',' 1115201249','4139003082','7613204004','4473801843',' 48000284401','7314115003','48000644401','67810817111' ,'1115201096','7441056523','3114615691','7613213012',' 3114615691','1115202786','48000284301','84190502011',' 84190502021','84190502031','84190502041','84190502051' ,'84190502061','6468427010','78888926504',' 78888926506','78888926507','78888926508','78888926511' ,'78888926512','48000375301','78888910520',' 78888910365','78888910405','78888928406','78888928439' ,'84190501061','78888910201','6927604012',' 78888910295','78888926505','48000375401','6927601200' ,'6927601205','81818700004','48000375201','6927601260' ,'6927601215','6927603217','81818700002','78888910200' ,'48000650501','48000650501','48000375101',' 6927603200','48000375001','48000650701','48000650701' ,'6205821024','78888910091','80599300021',' 80599300051','80599300111','80599300131','80599300151' ,'6205816462','6205816470','48000650601','48000650601' ,'6840080413','48000374401','78888910001',' 78888910076','48000650401','48000650401','78888910112' ,'78888910048','78888910277','85361000112',' 78888910211','85361000101','78888910113','6205881640' ,'85361000100','78888910210','78888928521',' 6840056311','85361000102','85361000119','48000722101' ,'78888910220','6840056241','78888910046','6840056371' ,'78888910181','85361000106','78888910007',' 78888910019','85361000117','48000721801','48000721901' ,'78888910172','78888910082','78888910123',' 85361000109','78888910083','6840056291','78888910115' ,'4371728010','4371728050','4371727730','4371728150',' 4371750640','4371728120','48000266901','3827479545',' 7550200001','4371729485','4371729510','7819205055',' 4371728240','48000326101','7127000729','7819204056',' 7819204883','4371728760','4371728790','48000564701',' 4371727740','48000520401','48000520501','48000388201' ,'4371732680','3827451611','61661800241','9783100500' ,'3827473601','3827442528','3827441505','4371732690',' 61896477152','63898200060','7107201136','7107201136',' 63898200009','63898200011','2682501853','2682501854',' 2682500968','2682500879','48000125401','1522937519',' 1522937749','48000125401','7079670001','48000629701',' 48000629701','78532801991','48000744501','48000744501' ,'2682500409','48000416701','48000416801',' 48000416901','78532801991','2682500409','8440757103',' 8440757104','74747900003','2682500403','2682500404',' 2682500405','2682501500','2682501200','2682501201',' 2682501202','2682501203','2682500892','2682500891',' 2682500893','2682500889','2682500890','3915313037',' 8939710881','2682500772','2682500111','48000417201',' 3915311003','3915311013','3915311015','74747900005',' 74747900009','3534280006','3534285006','3534287006',' 74747900008','74747900014','3915321163','3915311001',' 3915312019','3915314031','74747900026','74747900029',' 74747900031','74747900034','74747900036','74747900075' ,'48000612901','2682500959','2682500967','2682500963' ,'8440757100','8440757101','3915321160','3915321164',' 2682500400','2682500402','2682500407','8440757106',' 48000417101','2682500401','7067001116','75512200003',' 75512200020','79285135441','48000621001','79285135690' ,'79285135580','79285135595','79285135596',' 79285135633','5150028663','79285135461','79285135464' ,'7241711314','79285135556','7241711315','48000633501' ,'79285135592','79285135591','7241711316',' 48000633601','79285135654','5100015134','78996800002' ,'75678100056','79285135686','79285135565',' 79285135566','7241708540','79285135471','79285135546' ,'79285135593','79285135594','79285135517',' 75678100055','79285135630','79285135632','79285135514' ,'79285135493','79285135500','79285135515',' 48000633401','48000582401','79285135687','69963200066' ,'92069692233','7241743173','9128223464','7241723042' ,'5018919529517','69963200067','72069691235',' 66780300213','66780300212','7350060000148',' 66780300095','79285135473','79285135497','79285135522' ,'20670200000','20672000000','20672400000',' 20672100000','20670100000','20673600000','20671600000' ,'20671100000','20671400000','20671500000',' 20671300000','20671900000','20672200000','20672300000' ,'20673700000','20671200000','20670900000',' 20671000000','20670800000','70378900735','70378900735' ,'70378900735','48000121001','48000745001',' 7347200167','6098821203','2529360011','4111600271',' 2200000926','2800017825','2018205703','89014600147',' 75764502253','83611000011','66706320001','66706320009' ,'72958211620','72958211630') AND DIM_PRODUCT.ACTIVE = 1 AND DIM_STORE.LATEST = 1 AND DIM_PRODUCT.LATEST = 1 AND AGG_MLY_STR_PROD.STORE_CODE=DIM_STORE.STORE_CODE AND AGG_MLY_STR_PROD.PRODUCT_CODE=DIM_PRODUCT.PRODUCT_CODE AND DIM_STORE.STORE_CODE=ADMIN_USER_STORE.STORE_CODE AND ADMIN_USER_STORE.USER_ID=37 AND DIM_PRODUCT.DEPARTMENT_CODE=ADMIN_USER_DEPARTMENT.DEPA RTMENT_CODE AND ADMIN_USER_DEPARTMENT.USER_ID=37 GROUP BY DIM_PRODUCT.PRODUCT_CODE,DIM_PRODUCT.PRODUCT_DESCRIPTI ON|| '-' ||trim(PRODUCT_STYLE_DESC)|| '-' ||trim(PRODUCT_SIZE) ,DIM_PRODUCT.EAN_NUMBER,DIM_PRODUCT.PRODUCT_DESCRIPTIO N,DIM_PRODUCT.PRODUCT_STYLE_DESC,DIM_PRODUCT.PRODUCT_S IZE,DIM_PRODUCT.PRODUCT_UOM,DIM_PRODUCT.CREATED_DATE, (case when ATTRIB2_DESC IN('ZAP' , 'KIL' , 'DEL' , 'zap' , 'kil' , 'del') THEN 'D' ELSE 'A' END) ,DIM_PRODUCT.ATTRIB2_DESC,DIM_PRODUCT.ATTRIB1_DESC,DIM _PRODUCT.ATTRIB3_DESC,DIM_PRODUCT.PRODUCT_DETAIL_CODE, DIM_PRODUCT.DEPARTMENT_CODE,DIM_PRODUCT.DEPARTMENT_DES C,DIM_PRODUCT.CLASS_CODE,DIM_PRODUCT.CLASS_DESC,DIM_PR ODUCT.SUBCLASS_CODE,DIM_PRODUCT.SUBCLASS_DESC,DIM_PROD UCT.ACCT_DEPT_CODE,DIM_PRODUCT.SUB_DEPT_CODE ORDER BY DIM_PRODUCT.PRODUCT_CODE asc How to fix this kind of issues?

robpaller 159 posts Joined 05/09
10 Jul 2009

You may be able to evaluate the MaxParseTreeSegs setting in the DBSControls, but I would consider reducing the number of items in your IN list or placing them into a table (permanent, global temp, or volatile) and use a subquery in your IN list instead.

tmrmodest 6 posts Joined 02/09
14 Jul 2009

You can insert those values in the IN clause into a volatile table. Then join the volatile table with the existing table. I think this may be helpful. correct me if i am wrong.Regards,Sathish.

You must sign in to leave a comment.