DELETE FROM dbo.REFERENCIAS_MAYORISTAS

INSERT INTO dbo.REFERENCIAS_MAYORISTAS (ID, Codigo, EsReferencia, EsExcepcion, PorcentajeDescuento, FechaCreacion, Cantidad ) 
VALUES (1, '+++', 1, 0, 35, GETDATE(), 6  )

INSERT INTO dbo.REFERENCIAS_MAYORISTAS (ID,Codigo,EsReferencia,EsExcepcion,PorcentajeDescuento, FechaCreacion, Cantidad )
SELECT 
           ROW_NUMBER() OVER (ORDER BY Referencia+CodigoMarca ASC) + 1
           ,Referencia+CodigoMarca
           ,1
           ,1
		   ,0
           ,GETDATE()
		   ,0
FROM INVENTARIO 
WHERE Referencia+CodigoMarca IN 
('TREG-10TAR','DST22001FYK','DST22003FYK','DST22004-1FYK','DST22234FYK','DSTF2912FYK','449-0537SEX','449-0538SEX','449-0539SEX','449-0540SEX','449-0616SEX','449-0617SEX',
'449-0618SEX','449-0619SEX','449-0620SEX','449-0621SEX','449-0622SEX','494-0043AATD','494-0044AATD','494-0049AATD','494-0050AATD','494-0059AATD','494-0061AATD',
'494-0065AATD','494-0066AATD','494-04009AIR','494-04010AIR','494-04011AIR','494-04012AIR','494-44009AIR','494-44010AIR','494-44011AIR','494-44012AIR','5908-1RTS',
'5918-1RTS','5929-1RTS','5930-1RTS','915-1RTS','H-902RTS','HW-89UBB','I21-DMY132CSO','I21-DMY133CSO','I21-DMY134CSO','I21-DMY135CSO','I21-DMY136CSO',
'I21-DMY137CSO','I21-DMY138CSO','I21-DMY141CSO','I21-DMY143CSO','I21-DMY144CSO','I21-DMY145CSO','I21-DMY147CSO','I21-DMY148CSO','I21-DMY149CSO','J21-DMY163CSO','JOG01KLN',
'XW021FAP','2-233-VBVRS','DST22002FYK','DST22004-2FYK','DST22005FYK','46103HEMB','31066DMIL','1827CLS','3403CLS','3441CLS','449-0359SEX',
'449-0360SEX','449-0496SEX','JAM-26001STL','LS15028SNS','LS15029SNS','LS15030SNS','LS15032SNS','LS15033SNS','LS15034SNS','LS15036SGL','LS15037SGL',
'LS15039SGL','DT1204PRP','DT1212PRP','FRA3,90KLN','NV62L08NIR','NV62L09NIR','T111DAI','V-024NFS','38085JCSO','38087J408','DT1168PRP',
'1510BMS','1569AMS','2310SXA','25004HEMB','25019DNIR','25029DNIR','3010SXA','3195CLS','3310SXA','3320SXA','3420CLS',
'3431CLS','3434CLS','3435CLS','3442CLS','3456CLS','3660SXA','4010SXA','4020SXA','449-0361SEX','449-0629L&L','449-0630L&L',
'449-0631L&L','449-0632L&L','449-0633L&L','449-0659SEX','449-0660SEX','449-0661SEX','449-0662SEX','449-0663SEX','449-0664SEX','449-0714RDC','449-0715RDC',
'449-0726RDC','449-0727RDC','449-0732RDC','494-0079AAIR','494-0082AAIR','494-0090AAIR','494-03009AIR','494-10001AIR','494-10002AIR','494-10003AIR','494-10004AIR',
'494-10005AIR','494-10006AIR','494-10007AIR','494-10008AIR','494-10013AIR','494-10014AIR','494-50001AIR','494-50002AIR','494-50003AIR','494-50004AIR','494-50005AIR',
'494-50006AIR','494-50007AIR','494-50008AIR','494-50013AIR','494-50014AIR','5013NLV','8511NLV','AMP-745TXB','AMP-748TXB','AMP-757TXB','AMP-779TXB',
'AMP-781TXB','AMP-782TXB','AMP-783TXB','AMP-784TXB','AMP-785TXB','AMP-786TXB','AMP-787TXB','AMP-788TXB','AMP-946TXB','BK01VRS','BRIP-664TXB',
'BRIP-665TXB','BRIP-666TXB','BRIP-668TXB','BRIP-669TXB','BRIP-670TXB','BRIP-671TXB','BRIP-672TXB','CM3325VRS','CM3646VRS','CM3745VRS','CM558VRS',
'CMP78VRS','CMS48VRS','CMS78VRS','CMX3745VRS','FC01VRS','FD01VRS','FLR-4470LLR','FLR-4588LLR','FLR-4589LLR','FRA03VRS','JAM-3001VDA',
'LEG01VRS','MCC3001ABD','MCT3001ABD','MCT5002ABD','MCV3001ABD','MCV5002ABD','MNSC18VRS','OV01VRS','SXCP-001SXA','SXCP-002SXA','SXCP-003SXA',
'XMCC-002SXA','XMCP-001SXA','YDS-7612XVR','YDS-76120194XVR','001-1981CTR','001-1982CTR','001-1984CTR','001-1985CTR','001-1989CTR','1041NCSO','1092DNIR',
'1094DNIR','1099JNIR','1101JNIR','1102NNIR','1110NCSO','1111NCSO','1112JCSO','1113HCSO','1126DNIR','1134DNIR','1143DNIR',
'1144DNIR','1147DNIR','1148DNIR','1149DNIR','1150DNIR','1151DNIR','1152DNIR','1153HEMB','1155HEMB','1156HEMB','1159DNIR',
'1160JEMB','1162DNIR','1169DNIR','1173DNIR','1176HEMB','1177HEMB','1181DNIR','1182JNIR','23098DMIL','23115HCSO','23155HCSO',
'23156HCSO','23157DMIL','23166HCSO','23167HCSO','23170HCSO','23171HCSO','23173DMIL','23175DMIL','23180JMIL','23185HCSO','23186HCSO',
'23194JMIL','23196JMIL','23206JMIL','23207NMIL','23209JMIL','23210DMIL','23212JMIL','23213DMIL','23214JMIL','23215JMIL','23217JMIL',
'23218JMIL','23219DMIL','23225JCSO','23227HCSO','23234HCSO','23236NCSO','23237JCSO','23238HCSO','23242HCSO','23244DMIL','23248DMIL',
'23249DMIL','23250DMIL','23251DMIL','23252DMIL','23253DMIL','23255DMIL','23256DMIL','23258DMIL','23259JCSO','23260HCSO','23262JMIL',
'23263DMIL','23265HCSO','23269HCSO','23280HCSO','23287JMIL','23294DMIL','23296DMIL','23297DMIL','23306JMIL','23307JMIL','23308JMIL',
'23310NMIL','23312NMIL','23315JMIL','23316JMIL','23318DMIL','23322DMIL','23323DMIL','26034NMIL','26040NMIL','26043NCSO','26044NCSO',
'26045NCSO','26046NMIL','26047NMIL','26048NMIL','26049NCSO','26050NCSO','26051NCSO','26053NMIL','26054NMIL','26055NCSO','26056NMIL',
'26057NCSO','26058NMIL','26061NMIL','26062NMIL','26065NMIL','27061DMIL','27063NMIL','27069DMIL','27070DMIL','27078HEMB','27079DNIR',
'27080DNIR','27086HEMB','28095DMIL','28100JMIL','28101JMIL','28102NMIL','28110HCSO','28119HCSO','28127JCSO','28132HCSO','28135DMIL',
'28137DNIR','28141NCSO','28142JCSO','28145NCSO','28146JCSO','28147HCSO','28177HCSO','28178JCSO','28216DMIL','28217JMIL','28218NMIL',
'30068NMIL','30070JMIL','30083HCSO','30085HCSO','30087JMIL','30090HCSO','30091DMIL','30093JCSO','30094JMIL','30097JCSO','30098JMIL',
'30099NCSO','30100NMIL','30102DMIL','30104NCSO','30106NMIL','30107NMIL','30109JCSO','30110JMIL','30111NCSO','30112NMIL','30114DMIL',
'30122JNIR','30125JEMB','30130HCSO','30141DMIL','30144HCSO','30148DMIL','30151HCSO','30154DMIL','30155JMIL','30156HCSO','30157HCSO',
'30158JCSO','30159DMIL','30162HCSO','30163HCSO','30169HCSO','30170HCSO','30176N408','30180JMIL','30181NMIL','30182NMIL','30183JCSO',
'30184NCSO','30185NCSO','30187JMIL','30188NMIL','30189HCSO','30190HCSO','30192NCSO','30193DMIL','30194JMIL','30195NMIL','30196HCSO',
'30197HCSO','30198JCSO','30199NCSO','30201HCSO','30205NMIL','3088HCSO','3099DMIL','31022JMIL','31023JMIL','31024NMIL','31031DMIL',
'3103DMIL','31045DMIL','3104DMIL','31054DMIL','31065HCSO','31067DMIL','3106DMIL','31070JCSO','31075DMIL','31076DMIL','3109DMIL',
'3110DMIL','3113HCSO','3117DMIL','3120DMIL','3123HCSO','3127HCSO','3146HCSO','3151HCSO','3153DMIL','3155HCSO','3158HCSO',
'3159HCSO','3160HCSO','3161HCSO','3163HCSO','3164HCSO','3165HCSO','32012NMIL','32028NMIL','32029JCSO','32030JMIL','32032HCSO',
'32035HCSO','32041HCSO','32044JMIL','32045NMIL','32059HEMB','32060HEMB','32061HEMB','32062HEMB','32063DNIR','32064DMIL','32065DNIR',
'32066JEMB','32067JEMB','32068JEMB','32069JNIR','32070JNIR','32071JNIR','32072NEMB','32074NNIR','32080HCSO','32082DMIL','32083NCSO',
'32084NCSO','32085NMIL','32086NMIL','32087JMIL','32088NMIL','32089JCSO','32090NCSO','32091JMIL','32092NMIL','32095JMIL','32096NMIL',
'32098NCSO','3262HCSO','3263HCSO','3270HCSO','33011NMIL','33015HMAS','33019HEMB','34002NMIL','34006NCSO','34007NMIL','34008NCSO',
'34010NCSO','34012NCSO','34013NMIL','34014JCSO','34015JMIL','34020HCSO','34021HCSO','34022DMIL','34023JCSO','34024JMIL','34026NMIL',
'34027DMIL','34028HCSO','34032HCSO','34033JCSO','34034JMIL','34035NCSO','34036NMIL','34037NMIL','34043HCSO','34044HCSO','34045NMIL',
'34046NCSO','34047JCSO','34048NMIL','34049JMIL','34057N408','34061HCSO','34064NCSO','34065DMIL','34066JMIL','34067NMIL','34068DMIL',
'34072DMIL','36067DMIL','36068DMIL','36069DMIL','36070DMIL','36071JMIL','36073JMIL','36074DMIL','36087JMIL','38001HCSO','38002HCSO',
'38003DMIL','38004JCSO','38005JMIL','38007DMIL','38008DMIL','38009JMIL','38010NMIL','38011DMIL','38014DMIL','38015DMIL','38016DMIL',
'38017JMIL','38018NMIL','38019JMIL','38020NMIL','38021NMIL','38022NMIL','38023NMIL','38025NMIL','38026NMIL','38028HCSO','38029HCSO',
'38031NCSO','38032HCSO','38034JCSO','38036HCSO','38037HCSO','38038JCSO','38040HCSO','38041HCSO','38042HCSO','38045NCSO','38047NCSO',
'38051HCSO','38058HCSO','38086N408','38089JCSO','38096HCSO','38097HCSO','38098NMIL','38099JMIL','38101NMIL','38102JMIL','38104JMIL',
'38109DMIL','40004HCSO','40005HCSO','40008HCSO','41002HEMB','41003HEMB','41004JEMB','41006JEMB','41011HEMB','41018HEMB','41021DNIR',
'4143NCSO','4144JCSO','42001HCSO','42004HCSO','42006HCSO','4210HCSO','4215DMIL','4216DMIL','4217JCSO','4219JMIL','4224DMIL',
'4232NMIL','4237NCSO','4238NMIL','4241NCSO','4248NCSO','4249JCSO','4251NCSO','4252JCSO','4253HCSO','45001HEMB','45007HEMB',
'46001HCSO','46002HCSO','46004NCSO','46005NCSO','46006DMIL','46007JMIL','46008NMIL','46009NMIL','46019HCSO','46023DMIL','46047DMIL',
'46062HCSO','46063HCSO','46067DMIL','46071HCSO','46072HCSO','46076DMIL','46077JMIL','46091JMIL','46092NMIL','46093JMIL','46094NMIL',
'46100NCSO','46102JEMB','46104HEMB','46105DNIR','46108DNIR','47002HEMB','47003HEMB','47004HEMB','47006DNIR','7003DMIL','7007HCSO',
'DN59292DNE','FN01VRS','FN02VRS','GE59288GRD','GE59290GRD','JT3466KOAWA','EM59044EMB','EM59045EMB','NV59048NIR','NV59049NIR','2006CLS',
'C14022CSO','EM59043EMB','EM-59045MUT','EM59164EMB','EM59165EMB','EM59166EMB','LE27123LND','LE27124LND','LS27115SNS','LS27119SNS','NV59167NIR',
'NV59168NIR','NV59169NIR','9001DNE','9002DNE','9003DNE','9004DNE','001-0906LAM','001-0907LAM','001-0908LAM','001-0909LAM','001-0947AMG',
'001-0948AMG','001-0949AMG','001-0950AMG','001-1196CTR','001-1197CTR','001-1198CTR','001-1199CTR','001-1200CTR','001-1340AMG','001-1341AMG','001-1343AMG',
'001-1344AMG','001-1345AMG','001-1346AMG','001-1347AMG','001-1348AMG','001-1349AMG','001-1389LAM','001-1391LAM','001-1392LAM','001-1393LAM','001-1394LAM',
'001-1399AMG','001-1400AMG','001-1401AMG','001-1402AMG','001-1403AMG','001-1404AMG','001-1405AMG','001-1406AMG','001-1407AMG','001-1408AMG','001-1409CTR',
'001-1410CTR','001-1411CTR','001-1412CTR','001-1413CTR','001-1414CTR','001-1415CTR','001-1416CTR','001-1417CTR','001-1418CTR','002-0357LAM','0039-0001NUF',
'0039-0002NUF','004-0786NUF','004-0791NUF','004-0792NUF','004-0793NUF','004-0796NUF','004-0799NUF','004-1324NUF','004-1331NUF','004-1332NUF','004-1333NUF',
'004-1334NUF','004-1335NUF','004-1336NUF','004-1337NUF','004-1338NUF','004-1339NUF','004-1340NUF','004-1421NUF','004-1422NUF','004-1423NUF','004-1426NUF',
'004-1428NUF','004-1429NUF','15118JSNS','15119JSNS','15120JSNS','15121JSNS','15122JSNS','15123JSNS','15125HCSO','15137JCSO','15139JCSO',
'15149DSNS','15163DSNS','15167DSNS','15169DSNS','15179DSNS','15190DMIL','15194DSNS','15195DSNS','15196DSNS','15197DSNS','15199NSNS',
'15201NSNS','15212HCSO','15213J408','15222DSNS','15223DSNS','15226DSNS','15228DSNS','15231DSNS','15237JSNS','15238JSNS','15239JSNS',
'15240JSNS','15244HCSO','15249HCSO','15252JCSO','15254JCSO','15256JCSO','15257DSNS','15288DSNS','15291JSNS','15295DSNS','15305HCSO',
'15306HCSO','15307HCSO','15309DMIL','15311DMIL','15312DMIL','15315HCSO','15317HCSO','15333JSNS','15341JSNS','15347JSNS','18035DMIL',
'18040DMIL','18041JMIL','18042JMIL','18043JMIL','18046DMIL','18047NMIL','18048DMIL','18049DMIL','18051DMIL','18053NMAS','18055DNIR',
'18056DNIR','19057DSNS','19058DSNS','19065HEMB','19067HEMB','19068HEMB','19069HEMB','19070HEMB','19071HGNP','19075HGNP','19076JGNP',
'19078HCSO','30101HCSO','30200HCSO','30202NMIL','30203N408','30204NMIL','30206NMIL','30207N408','31027DMIL','31041DMIL','31042DMIL',
'31043DMIL','31049DMIL','31050JMIL','31052DMIL','31053JMIL','31059HCSO','31061HCSO','31062HCSO','31063HCSO','32034DMIL','32057JMIL',
'32058JEMB','32077HCSO','34038DNIR','36030DMIL','36031DMIL','36033DMIL','36034DMIL','36035DMIL','36036DMIL','36038DMIL','36039DMIL',
'36040DMIL','36042JMIL','36043JMIL','36044DMIL','36046DMIL','36052DMIL','36053DMIL','36054DMIL','36057DMIL','36060DMIL','36062DMIL',
'36063DMIL','36064DMIL','36065DMIL','36066DMIL','38027DMIL','39001DSNS','39004HCSO','418-0386L&L','418-0387L&L','418-0389LO&','418-0390L&L',
'418-0393L&L','418-0394L&L','418-0617BCE','418-0618BCE','418-0621BCE','449-0513L&L','5016DMIL','5017DMIL','5018DMIL','5019DMIL','5021DMIL',
'5029HCSO','534GNK','56HER','59432GNK','6016DNIR','6017DNIR','78571GNK','A2-I20-PY071DFF','A2-I20-PY073DFF','B3-E20-LW216DFF','BK-0094L&L',
'BK-0109ESEX','BK-0110SEX','BK-0111SEX','BK-0111ESEX','C21-LW5892CLTS','C21-LW5893CLTS','D-187GNK','D-188GNK','D-190GNK','D-193GNK','D-194GNK',
'DW158GNK','DW159GNK','E21-LGQ5934WBBLTS','E21-LGQ5935CLTS','EM14058EMB','EM14059EMB','EM14060EMB','EM14076EMB','EM14077EMB','EM14078EMB','HB2288GNK',
'LE27121LND','LE27122LND','LR0401LRN','LR0410LRN','LR32L140LRN','LR32L141LRN','LR80M29LRN','LR80M30LRN','LR80M93LRN','LR80M94LRN','LR80M95LRN',
'LR80M96LRN','LS27113SNS','LS27114SNS','LS32K07SNS','LS32K08SNS','LS32M11SNS','LS32M20SNS','LS32M29SNS','LS8001SNS','LS8002LRN','LS8010SNS',
'LS8012SNS','LS80M20SNS','LS80M26LRN','LS80M27SNS','NK5252GNK','NSK2108GNK','NST8500GNK','NST8507GNK','NST8819GNK','NST8822GNK','NST8877GNK',
'NST8879GNK','NV14055NIR','NV14056NIR','NV14057NIR','NV14073NIR','NV14074NIR','NV14075NIR','NV2001NIR','NV2008DNE','NV2010DNE','NV2011DNE',
'NV2012DNE','QC9160GNK','SK2219GNK','SK2259GNK','SK2262GNK','SK2265GNK','SK2267GNK','SN5447GNK','SN5795GNK','X1467GNK','XL001-1350LAM',
'XL001-1351LAM','XL001-1352LAM','XL001-1353LAM','XL001-1354LAM','XL001-1357LAM','DTS9097HEN','DTS9098HEN','DTS9106HEN','DTS9139HEN','DTS9141HEN','DTS9145HEN',
'DTS9146HEN','DTS9153HEN','DTS9155HEN','EM59042EMB','LE16002LND','LS27116SNS','NV59046NIR','NV59047NIR','MA80M78MAS','MA80M79MAS','EM14036EMB',
'EM14037EMB','EM14038EMB','EM14041EMB','EM14042EMB','EM14043EMB','EM14068EMB','LE27105LND','LE27107LND','LE27110LND','LE27111LND','ML14032MIL',
'ML14033MIL','27057LND','14063NMIL','14064JMIL','15061DSNS','15069JSNS','18017DMIL','18026JMIL','18027JMIL','19039DSNS','37011MIL',
'5335DSTY','C59173CSO','EM14034EMB','EM14035EMB','EM14039EMB','EM14040EMB','ML14030MIL','ML14031MIL','C59174CSO','C59175CSO','X7478GNK',
'X7488GNK','X7490GNK','X7507GNK','X7508GNK','X7509GNK','X7565GNK','X7567GNK','X7568GNK','X7651GNK','X7652GNK','X7653GNK',
'X7654GNK','X7219GNK','X7360GNK','X7361GNK','X7561GNK','X7562GNK','X7634GNK','X7661GNK','QC9892GNK','QC9894GNK','A3565GNK',
'A4817GNK','A4822GNK','A7296GNK','A7360GNK','A8750GNK','A8853GNK','SP40854GNK','SP45873GNK','SP4736GNK','SP4737GNK','SP4739GNK',
'SP4747GNK','SP4753GNK','SP4775GNK','SP4803GNK','SP4807GNK','SP4809GNK','SP4810GNK','SP4814GNK','SP4818GNK','SP4830GNK','SP4831GNK',
'SP4836GNK','SP4837GNK','SP4841GNK','X3060GNK','X3102GNK','X3106GNK','X3107GNK','X3321GNK','X3372GNK','X3395GNK','X3472GNK',
'X3479GNK','X3574GNK','X3575GNK','X3580GNK','X3596GNK','X3638GNK','X3640GNK','X3649GNK','X3655GNK','X3656GNK','X3699GNK',
'X3712GNK','X3714GNK','X3723GNK','X3724GNK','X3727GNK','X3730GNK','X3734GNK','X3735GNK','X3891GNK','170GNK','1082AEL',
'5130GNK','5553GNK','6629GNK','8724GNK','8728GNK','8731GNK','24001GNK','1203-110GNK','40S-801GNK','7311GNK','A1994GNK',
'A3501GNK','A3562GNK','A3568GNK','A3591GNK','A6907GNK','A6936GNK','A7273GNK','A7403GNK','A7724GNK','A8665GNK','A8764GNK',
'A8766GNK','A8770GNK','A8775GNK','A8781GNK','A8782GNK','A8784GNK','A8787GNK','A8812GNK','A8813GNK','A8881GNK','A8987GNK',
'A8988GNK','A8992GNK','A8993GNK','A9005GNK','A9009GNK','A9032GNK','ACF-202HGM','BCT-48269-23NED','BCT-48269-24GNK','BCT-48269-25NED','F6563GNK',
'HB30GNK','K147GNK','QC266GNK','QC267GNK','QC268GNK','QC269GNK','QC322GNK','QC357GNK','QC358GNK','QC372GNK','QC373GNK',
'QC374GNK','QC391GNK','QC392GNK','QC393GNK','QC394GNK','QC395GNK','QC9674GNK','QC9677GNK','QC9678GNK','QC9763GNK','QC9954GNK',
'QC9958GNK','QC9959GNK','QC9960GNK','QC9961GNK','RF064GNK','RF1023GNK','SIV51084UDR','SK2102GNK','SK2103GNK','SK2136GNK','SK2154GNK',
'SK2183GNK','SK2195GNK','SK2205GNK','SK2220GNK','SK2225GNK','SK2266GNK','SK2279GNK','SK2284GNK','SK2286GNK','SN3351SAI','SN3356SAI',
'SN3371SAI','SN3381SAI','SN3382SAI','SN3420GNK','SN3547GNK','SN3618GNK','SN4278GNK','SN4286GNK','SN4392GNK','SN4587GNK','000089DNE',
'000090DNE','0011-0010POO','0011-0013POO','0011-0014NZW','0011-0015POO','0011-0047POO','0016-0111NZW','0016-0114NZW','0016-0118NZW','0016-0119NZW','0016-0121NZW',
'0016-0168NZW','002374DNE','002375DNE','002376DNE','002377DNE','002387DNE','002389DNE','002396DNE','002403DNE','002406DNE','002407DNE',
'002408DNE','002409DNE','0027-0008PBX','0034-0001POO','0034-0007POO','0034-0015POO','0034-0029POO','011284DNE','011285DNE','011359DNE','011362DNE',
'011374DNE','011376DNE','011385DNE','011388DNE','011389DNE','011390DNE','011393DNE','011394DNE','011398DNE','013240DNE','01GUGCC',
'01LVLVV','020728DNE','020736DNE','020745DNE','020759DNE','020760DNE','021337DNE','021539DNE','021683DNE','021684DNE','021701DNE',
'021742DNE','021745DNE','021768DNE','025012DNE','025015DNE','025019DNE','04-71782DCAF','04-71863D770','04-71865B770','04-72066AVZO','04-72069AVZO',
'04-72072AVZO','04-72079AVZO','04-72170AFOX','04-72187ALM','04-72198ALM','04-72199ALM','04-72200ALM','04-72205ALM','04-72213ALM','04-72218ALM','04-72244ALM',
'04-72245ALM','04-72293DCAF','04-72411CAF','04-72412CAF','04-72413CAF','04-72414CAF','04-72415CAF','04-72419CAF','04-72420CAF','04-72476FOX','04-72535VZO',
'04-72541AVZO','04-72543AVZO','04-72548DALM','04-72566DALM','04-72568DALM','04-72577DALM','04-72836SVZO','09-17274AFOX','09-17276AFOX','09-17278AFOX','09-17279AFOX',
'09-17282AFOX','09-17293AFOX','09-17314AFOX','09-17345AFOX','09-17348AFOX','09-17356AFOX','09-17368AFOX','09-17372AFOX','09-17373AFOX','09-17375AFOX','09-17376AFOX',
'09-17378AFOX','09-17401ADTD','09-17405ADTD','09-17419ADTD','09-17422ADTD','09-17423ADTD','09-17427ADTD','092086DNJ','1001-1LRN','1002LRN','1002NMIL',
'10074PLL','100DNIR','1013NMIL','1025NMIL','1026NMIL','102DNIR','10-3140BLNY','10-3146BLNY','10-3147BLNY','10-3149BLNY','10-3153BLNY',
'10-3158BLNY','1033NMIL','103DNIR','107-08798CAF','107-08799CAF','107-08800CAF','107-08801CAF','107-08803CAF','107-08804CAF','107-08805CAF','107-08806CAF',
'107-08807CAF','107-08808CAF','107-08809CAF','107-08810CAF','107-08811CAF','107-08812CAF','107-08813CAF','107-09294CAF','107-09308CAF','107-09313CAF','107-09503CAF',
'107-09515CAF','107-10059CAF','107-MJ-2041AVZO','107-MJ-2042AVZO','107-MJ-2073AVZO','107-MJ-2083AVZO','1158DNIR','115DNIR','1198DNIR','1199DNIR','1206DNIR',
'1212DNIR','1213DNIR','1216DNIR','1223DNIR','1224DNIR','1225DNIR','1252DNIR','15276JNIR','15287JSNS','15314JSNS','15325JSNS',
'15327JSNS','15337JSNS','15349JSNS','15351JSNS','15365NCSO','15367NCSO','15394JSNS','15396JSNS','15398JSNS','15429NSNS','15430NSNS',
'15431NSNS','15438NSNS','15439NSNS','15440NSNS','15441NCSO','15442NCSO','15463HCSO','15464HCSO','15465H408','15466HCSO','15467HCSO',
'20005PLL','20019PLL','20021PLL','200DNIR','201-5DPD','201DNIR','2028NMIL','2029NMIL','202DNIR','2030NMIL','2032NMIL',
'2034NMIL','205-3DPD','2061NMIL','2063NMIL','2064NMIL','206-5DPD','2065NMIL','207-1DPD','2071NMIL','2080NMIL','2-184-121VRS',
'226DNIR','22Y-016CXL','22Y-018CXL','22Y-023CXL','22Y-024CXL','22Y-025CXL','22Y-108CXL','22Y-122CXL','22Y-123CXL','22Y-130CXL','22Y-134CXL',
'22Y-141CXL','22Y-227CXL','22Y-228CXL','22Y-230CXL','22Y-231CXL','22Y-414CXL','22Y-416CXL','22Y-417CXL','22Y-418CXL','22Y-518CXL','22Y-528CXL',
'22Y-534CXL','22Y-535CXL','22Y-706CXL','22Y-721CXL','22Y-723CXL','22Y-726CXL','22Y-728CXL','2393DNE','2395DNE','2397DNE','2402HTMH',
'2405DNE','2410DNE','2411DNE','2414DNE','2417DNE','2466DNE','25008HEMB','25009HEMB','25011HEMB','25014DNIR','25015HEMB',
'25016HEMB','2503HBSS','25078H408','25079H408','2507HTMH','2527HTMH','2565DNE','258DNIR','265DNIR','268DNIR','270DNIR',
'2895LRN','3015PLL','3022PLL','30223HMAS','30224HMAS','30227NMAS','30228DMIL','30231NMIL','30245NMAS','30249NMIL','306-5468A770',
'306-5469A770','306-5473AVZO','306-5475AVZO','306DNIR','31047DMIL','31064HCSO','31072DMIL','31082H408','31083H408','31084H408','31085DMIL',
'31086DMIL','316DNIR','32143DSNS','3-228-1011SM1','322DNIR','3230-PNEN','328DNIR','330-1260AMVL','330-1400AMVL','330-1408AMVL','330-1417AMVL',
'330-1424AMVL','330-1429AMVL','330-1483AMVL','330-1494AMVL','330-1520AMVL','330-1523AMVL','330-1531AMVL','330-1537AMVL','330-1544AMVL','330-1545AMVL','330-1547AMVL',
'330-1557AMVL','330-1714AJST','330-1756ADCC','33020HMAS','33021HMAS','330-2242BMNM','330-2246BMNM','330-2251BMNM','330-2262BMNM','330-2265BMNM','330-2270BMNM',
'330-2276BMNM','33022DMIL','33023H408','33024H408','330-2604AMVL','330-2720ADCC','330-2916ADNY','330-2920ADNY','330-2955ASTW','330-2956AMVL','330-2959AMVL',
'330-3003AMVL','330-3048AMVL','330-3052AMVL','330-3054AMRD','330-3080ADCC','330-3087ADCC','330-3093ADCC','330-3095ADCC','330-3098AMVL','330-3163ADNY','330-3222ADNY',
'330-3232ADNY','330-3233ADNY','330-3250ADNY','330-3253ADNY','330-3256ADNY','330-3258ADNY','330-3260ADNY','330-3264ADNY','330-3282ADNY','330-3288ADNY','330-3290ADNY',
'330-3293ADNY','330-3302ADNY','330-3315ADNY','330-3346ADNY','330-3349ADNY','330-3356ADNY','330-3636STW','330-3642STW','330-3663STW','330-3666STW','330-3671BMNM',
'330-3673BMNM','330-3674BMNM','330-3678BMNM','330-3679BMNM','330-3695BMNM','330-3697BMNM','330-3709BMNM','330-3914TSM','330-3916TSM','330-3918TSM','330-4056MVL',
'330-4071MVL','330-4092MVL','330-4093MVL','330-4095MVL','330-4099MVL','330-4110DNY','330-4112DNY','330-4115DNY','330-4116DNY','330-4118DNY','330-4125DNY',
'330-4136DNY','330-4161DNY','330-4163DNY','330-4164DNY','330-4166DNY','330-4167DNY','330-4183DNY','330-4185DCC','330-4189MVL','330-4190BDCC','330-4191DCC',
'330-4192DCC','330-4193MVL','330-4197BDCC','330-4198DCC','330-4199MVL','330-821AMVL','331DNIR','3344JAZ','334DNIR','335DNIR','336DNIR',
'338DNIR','34039DMIL','34040HCSO','34041HCSO','34050DMIL','34051HCSO','34052DMIL','34053HCSO','34054HCSO','34055HCSO','34056JCSO',
'34058DMIL','34059JMIL','34060NMIL','34069DMIL','34070DMIL','34071DMIL','34081HCSO','34082HCSO','34083HCSO','34087DMIL','34091DMIL',
'34096HCSO','34097HCSO','34100DMIL','34108HCSO','34109HCSO','34110DMIL','34116HCSO','34117HCSO','34118JCSO','34119DMIL','34120JMIL',
'34121HCSO','34122HCSO','34123DMIL','34124DMIL','34125HCSO','34126DMIL','34127HCSO','34128JCSO','34129H408','34130H408','34131H408',
'34132H408','34133DMIL','34145J408','34146JMIL','3600TIM','3602TIL','36-12345DCC','36-12357MVL','36-12875DNY','36-12878DNY','36-12881PWT',
'36-12884PWT','36-12893MVL','36-12895MVL','36-12900MVL','36-12913DCC','36-12919DCC','3614TIL','3618TIM','3664TIM','38052HCSO','38053JCSO',
'38055DMIL','38059JCSO','38064JCSO','38071HMAS','38072DMIL','38073HMAS','38074HMAS','38075DMIL','38076HMAS','38077DMIL','38079DMIL',
'38092HCSO','38095HCSO','38103NMIL','38107DMIL','38108DMIL','38110DMIL','38125HMAS','38126HMAS','3838TIM','3994TIM','3998TIM',
'4016TIL','40-68013LEI','40-68015LEI','40-68018LEI','40-68025LEI','4082JAZ','41061HEMB','41063JEMB','41065JNIR','41066HEMB','41068JNIR',
'41069HEMB','41071JEMB','41072DNIR','41073JNIR','41075JNIR','41076HEMB','41077JEMB','41154HEMB','41155HEMB','41156HEMB','41157HEMB',
'41158HEMB','41159HEMB','41160JEMB','41161JEMB','41162JEMB','414DNIR','41-68001ATD','41-68002ATD','41-68006ATD','41-68007ATD','41-68008ATD',
'41-68010ATD','41-68012ATD','41-68015ATD','41-68020ATD','41-68022ATD','41-68023ATD','41-68026ATD','41-68028ATD','41-68032ATD','41-68033ATD','41-68036ATD',
'41-68039ATD','41-68041ATD','41-68043ATD','41-68046ATD','41-68047ATD','41-68048ATD','41-68049ATD','41-68050ATD','41-68051ATD','4229JAZ','4230JAZ',
'428DNIR','437DNIR','439DNIR','446-0193AFOX','446-0198AFOX','446-0200AFOX','4485JAZ','45040HEMB','45041HEMB','45042HEMB','45043HEMB',
'45045DMIL','45046DNIR','45048HEMB','45049HEMB','45050HEMB','45054DNIR','45055HEMB','45056HEMB','45057DNIR','46064JCSO','46068JMIL',
'46073JCSO','46074N408','46075NCSO','46078NMIL','46079NMIL','46095NMIL','46107JNIR','46152DNIR','46153JMIL','46155DMIL','46156DMIL',
'46157DMIL','46158HMAS','46159HMAS','46160NMIL','46161JMIL','46162DMIL','46163NMAS','46164JMAS','46165HMAS','46166HMAS','46167DMIL',
'46168DMIL','46169HMAS','487DNIR','4888JAZ','4892JAZ','4893JAZ','4894JAZ','4897JAZ','4898JAZ','4899JAZ','4902JAZ',
'4909JAZ','4912JAZ','4913JAZ','4921JAZ','4928JAZ','4930JAZ','4932JAZ','4936JAZ','4937JAZ','494-0024AATD','494-0036AATD',
'494-0042AATD','494-0051AATD','494-0052AATD','494-0053AATD','494-0054AATD','494-0056AATD','494-0058AATD','494-0098AAIR','494-0100A','494-0101AAIR','494-0104A',
'494-0106A','494-0108A','494-03005AIR','494-03011','494-03013AIR','494-03014AIR','494-03015AIR','494-03016AIR','494-10009AIR','494-10010AIR','494-10011AIR',
'494-10012AIR','4942JAZ','4943JAZ','494-43005AIR','494-43013AIR','494-43014AIR','4945JAZ','494-50009AIR','494-50010AIR','494-50011AIR','494-50012AIR',
'4947JAZ','4948JAZ','4960JAZ','4972JAZ','4973JAZ','4982JAZ','498DNIR','4993JAZ','4999JAZ','5000-1LRN','500DNIR',
'5037DSNS','5038JSNS','5039DSNS','5041DSNS','5042JSNS','5043DSNS','5045DSNS','5048JSNS','5049DSNS','504DNIR','5053DSNS',
'5060JSNS','506DNIR','5071DSNS','510-1WZD','5102HMAS','5103HMAS','5104HMAS','5105JAZ','5105HMAS','5106HMAS','5107HMAS',
'5114JAZ','5117JAZ','5118JAZ','512-0308ACAF','512-0310ACAF','512-0352ACAF','512-0354ACAF','5127JAZ','5128JAZ','5135JAZ','5136JAZ',
'5140JAZ','5142JAZ','5145JAZ','5148JAZ','5150JAZ','5176BEP','519DNIR','535DNIR','543DNIR','578DNIR','587DNIR',
'601DNIR','602DNIR','604DNIR','618DNIR','6191JAZ','6249JAZ','6252JAZ','6265JAZ','690DNIR','7026JAZ','703DNIR',
'7141JAZ','7145JAZ','720253LRN','720255LRN','72-11114ADNL','72-11115ADNL','72-11153ADNL','72-11154ADNL','72-11155ADNL','72-11156ADNL','72-11157ADNL',
'72-11158ADNL','72-11159ADNL','72-11162ADNL','72-11178ADNL','72-11185ADNL','72-11195ADNL','72-11352ADNL','72-11353ADNL','72-11453ADNL','72-11474ADNL','72-11493ADNL',
'72-11497ADNL','72-11567ADNL','72-11568ADNL','756TIW','781TIW','7827VJO','7891VJO','7899VJO','794TIW','8038JAZ','8051JAZ',
'8053JAZ','8055JAZ','836DNIR','862DNIR','881DNIR','901DNIR','902DNIR','903DNIR','904DNIR','905DNIR','906DNIR',
'9162PLL','9172PLL','9179PLL','9182PLL','9184PLL','9198PLL','9199PLL','9208PLL','933DNIR','9451SIX','9838ALW',
'A01377PLL','A01378PLL','A01382PLL','A01384PLL','A01389PLL','A01405PLL','A01406PLL','A01407PLL','A01415PLL','A01418PLL','A01419PLL',
'A01420PLL','A01426PLL','A01432PLL','A01438PLL','A01665PLL','A01670PLL','A01671PLL','A01681PLL','A01693PLL','A01697PLL','A01702PLL',
'A01730PLL','A01788PLL','A03NADS','A04NADS','A-051DNIR','A-054DNIR','A-058DNIR','A-074DNIR','A-076DNIR','A1052NMIL','A1056NMIL',
'A1059NMIL','A2089NMIL','A2301NMIL','A2308NMIL','A45JNIR','A600NADS','A601NADS','AP-106CAF','AP-2892DALM','AP-2965AALM','AP-2965DALM',
'AP-2966AALM','AP-2968AALM','AP-2980DALM','AP-2981DALM','AP-2982DALM','AP-2983DALM','AP-2996AALM','AP-3000ADNL','AP-3002AALM','AP90-20A-RDIJ','ASN-1001EMB',
'ASN-1002EMB','ASN-1003EMB','ASN-1004EMB','ASN-1005EMB','ASN-1006EMB','ASN-1007EMB','ASN-1008EMB','ASN-1009EMB','ASN-1010EMB','ASN-1011EMB','B-001NFS',
'B006DNIR','B-009UNC','B-018UNC','B-018NFS','B018DNIR','B-020UNC','B-021UNC','B-021NFS','B021DNIR','B-022UNC','B-024UNC',
'B-024NFS','B-025UNC','B-025NFS','B-026UNC','B-026NFS','B-027UNC','B-027NFS','B-028NFS','B-030NFS','B-035NFS','B-036NFS',
'B-037NFS','B039DNIR','B-041NFS','B-044NFS','B044DNIR','B-045NFS','B045DNIR','B052DNIR','B19189SZR','B19196SZR','B19197SZR',
'B230DNIR','B905DNIR','B917DNIR','B971DNIR','B972DNIR','BBX-287GGCHO','BBX-288GGCHO','BBX-297GGCHO','BBX-304GGCHO','BE20125SZR','BJ101HNIK',
'BJ102HNIK','BJ103HNIK','BJ106DNIK','BJ107DNIK','BLK-0200BBBD','BLK-0208BBBD','BLK-0216MBBD','BLK-0219MBBD','BLUE023LRN','BLUE024LRN','BLUE027LRN',
'BON-5325GMBN','BON-5325GGMBN','BRAZILGNO','C-018UNC','C021HLAC','C022NLAC','C02NLAC','C101DBLC','C102DNIR','C103DNIR','C104DNIR',
'C105DNIR','C106DNIR','C107DNIR','C108DNIR','C109DNIR','C110DNIR','C-5923FX2','CA92N03CSO','CA92N15CSO','CDD-6050MRDX','CDD-6602MRDX',
'CDD-6603MRDX','CDD-9318MRDX','CDY-6982MRDX','CH-9323CRV','CJ20126SZR','CM-018NFS','CMC20199SZR','CMC20264SZR','CONJ4,90KLN','CONJ5,90KLN','CONJ6,90KLN',
'CONJ9,90KLN','CRL-4989CAF','CRL-4994CAF','CRL-4995CAF','CRL-4998CAF','CRL-5002CAF','CRL-5004770','CRL-5121CAF','CRL-5148CAF','CRL-5214CAF','CRL-5231CAF',
'CRL-5238CAF','CRL-5488CAF','CRL-5788CAF','CRL-5877CAF','CRL-5879CAF','CRL-5954CAF','CRL-5955CAF','CRL-5959CAF','CRL-5960CAF','D001JNIR','D004DNIR',
'D006DNIR','D115DNIR','D120DNIR','D142DNIR','D144DNIR','D147DNIR','D1915DNIR','D1978DNIR','D2022DNIR','D2060DNIR','D2182DNIR',
'D2184DNIR','D4023JCSO','D4024JCSO','D4025NCSO','D4026NCSO','D40NDSL','D41NDSL','D42DDSL','D601DNIR','D722DNIR','D728DNIR',
'DC02L9DNE','DC03L9DNE','DC04L9DNE','DC05L9DNE','DC07L5DNE','DC07L9DNE','DC08L9DNE','DC93L9DNE','DC97L9DNE','DF01L3DNE','DF03A4DNE',
'DF03L3DNE','DF04A4DNE','DF25L3DNE','DF40L3DNE','DI-1001-ADIJ','DI-1003-ADIJ','DI-1004-ADIJ','DI-1005-ADIJ','DI-1007-ADIJ','DI-1009-ADIJ','DI22-05ADEY',
'DI22-06ADIJ','DJ001JMIL','DJ002JMIL','DJ003JMIL','DJ006DMIL','DL-2769ADNL','DL-3015ADNL','DL-3117DNL','DL-3119DNL','DL-3124DNL','DOP-0096BDOP',
'DOP-0096BBDOP','DOP-0153MRATY','DOP-0164MRATY','DPK-0541GGPPM','DR0232PLL','DR0238PLL','DR0239PLL','DR0241PLL','DR0242PLL','DR0250PLL','DR0253PLL',
'DR0264PLL','DR0297PLL','DR0302PLL','DR0306PLL','DR0307PLL','DR0308PLL','DWI1C2DNE','DWI1D2DNE','DWI2B3DNE','DWI2L2DNE','DWS1B3DNE',
'DWS1C3DNE','DWS1D2DNE','DX18L10DNX','DX18L11DNX','DX18L12DNX','DX18N01DNX','DX18N02DNX','DX18N03DNX','DX18N04DNX','DX18N05DNX','EDD-0640MRDX',
'EDD-0642MRDX','EDD-0659MRDX','EDD-0661MRDX','EL7005EGU','EL7006EGU','EL7007EGU','EL7013EGU','F-001FUNC','F-005UNC','F-005FUNC','F-017UNC',
'F-018UNC','F100DNIR','G120DNIR','GCP-AT-3442WLSVJ','GCP-AT-3444STSVJ','GCP-AT-3595STSVJ','GCP-AT-3598STSVJ','GCP-AT-3887ASVJ','GCP-AT-3896ASVJ','GCP-AT-3897ASVJ','GERMANYGNO',
'GG02C1GRD','GG03B3GRD','GG03D2GRD','GG10B1GRD','GG10B2GRD','GG11B2GRD','GL913DNIR','GUVALISO','GXR-2748SVJ','HMM-8451SVJ','HMM-8467SVJ',
'HMM-8470SVJ','HQM-8015LOL','HQM-8023LOL','HTI-7664CCB','HZ42#FAP','HZ68#FAP','HZO-8121CCB','HZO-9286SVJ','HZO-9288SVJ','I002HCSO','I006HCSO',
'I21-DMY150CSO','I21-DMY151CSO','I21-DMY152CSO','I21-DMY153CSO','I21-DMY154CSO','I21-DMY155CSO','I21-DMY156CSO','I21-DMY157CSO','ICA-006MSRDX','IJ01L3DNG','IND-003MLTLD',
'J-001UNC','J-002UNC','J-002NFS','J-003UNC','J007-1DNE','J-012UNC','J-014UNC','J-017UNC','J-021UNC','J-081UNC','J-085UNC',
'J103PFDL','J104FDL','J1123DNIR','J1275DNIR','J1291DNIR','J1293DNIR','J1309DNIR','J1313DNIR','J1316DNIR','J21-DMY166CSO','J246NNIR',
'J248NNIR','J249NNIR','J500DREE','J501DCNV','J525DNIR','J540DNIR','J549DNIR','J650DNIR','J684DNIR','J688DNIR','J920DNIR',
'K275NEKN','K276NEKN','K277NEKN','K278NEKN','K279NEKN','K52DTMY','KZ1008002DND','L170DLVV','LBO-0405MBN','LBO-5297GGBNT','LBO-5298GGBNT',
'M100NEKN','M203DNIR','M208DNIR','M221DNIR','M401DNIR','M402DNIR','M403DNIR','MAH20-118AOTD','MASSIVO-10MSV','MBN-0159GBNT','MBN-0159GGBNT',
'MBN-0229LOLL','MBN-0236LOLL','MBN-0259LOLL','MBN-0269LOLL','MBN-0275LOLL','MEXICOGNO','MFW-070#FAP','MG-0161D770','MG-0173D770','MG-0189D770','MG-0191A770',
'MG-0191D770','MG-0194A770','MG-0194D770','MG-0195DFOX','MG-0198D770','MG-0211A770','MG-0211D770','MG-0216A770','MG-0217A770','MG-0218A770','MG-0219A770',
'MG-0220A770','MG-0223A770','MIN-006XXSBD','MIN-011MLSBD','MIN-012XXSBD','MK001DNIK','MK002HNIK','MK003HNIK','ML01L8EMB','ML3019MIL','ML3020MIL',
'ML3021MIL','ML3022MIL','ML3023MIL','ML3024MIL','ML3025MIL','ML3026MIL','ML3027MIL','ML3028MIL','ML3029MIL','ML3030MIL','ML3031MIL',
'ML3032MIL','ML3033MIL','ML3034MIL','ML3035MIL','ML3036MIL','ML3071MIL','ML3072MIL','ML3073MIL','ML3074MIL','ML3075MIL','ML3076MIL',
'ML3077MIL','ML3078MIL','ML3079MIL','ML3080MIL','ML3081MIL','ML3082MIL','ML3083MIL','ML3084MIL','ML3085MIL','ML3086MIL','ML3087MIL',
'ML3088MIL','ML3089MIL','ML3090MIL','ML3091MIL','ML3092MIL','ML3093MIL','ML3095MIL','ML3096MIL','ML3097MIL','ML3098MIL','ML3099MIL',
'ML3103MIL','ML3104MIL','ML3106','ML3107MIL','ML3108MIL','ML3110MIL','ML3111MIL','ML3112MIL','ML3113MIL','ML3114MIL','ML5008MIL',
'ML5009MIL','ML5011MIL','ML5012MIL','ML5013MIL','ML5014MIL','ML5015MIL','ML5016MIL','ML5018MIL','MY101NFRZ','N03NNIK','N04NNIK',
'N200DNIK','N300HNIK','NCL-0101BBBD','NCL-0260MNCR','NIGERIAGNO','NIÑA-MBPZG','NIÑA-MDPZG','NIÑA-MNPZG','NOB-0006MNBD','NOB-0009MNBD','NOB-0046MNBD',
'NOB-0059MNBD','OD03L5LRT','OE-88#FAP','OLL-515LOLL','OLL-535GGMBN','OLL-544LMBN','OLL-549LMBN','OLL-559LMBN','OLL-564LMBN','OLL-576LMBN','OLL-591GGOLL',
'OUT-002LOUT','OUT-006LOUT','OUT-007LOUT','OUT-009LOUT','OUT-010LOUT','OUT-3015BOUT','OUT-3025BOUT','OUT-3027BOUT','OXF-001MSSBD','OXF-002MSSBD','OXF-002XXSBD',
'OXF-003MSVER','P-005UNC','P03NNIR','P041HPUM','P04NPUM','P09DNIR','P10697PLL','P10753PLL','P10758PLL','P10783PLL','P10785PLL',
'P10786PLL','P10790PLL','P10792PLL','P10800PLL','P10803PLL','P10806PLL','P10939PLL','P10982PLL','P10986PLL','P10999PLL','P11007PLL',
'P11009PLL','P11011PLL','P11012PLL','P11037PLL','P11042PLL','P11045PLL','P11059PLL','P11068PLL','P20241PLL','P20245PLL','P20250PLL',
'P20251PLL','P20254PLL','P20255PLL','P20256PLL','P20258PLL','P20260PLL','P20270PLL','P20272PLL','P20273PLL','P20274PLL','P20277PLL',
'P20355PLL','P20379PLL','P20434PLL','P20441PLL','P20443PLL','P20445PLL','P20451PLL','P20454PLL','P20455PLL','P20457PLL','P20458PLL',
'P20462PLL','P20463PLL','P20466PLL','P20475PLL','P20478PLL','P20479PLL','P20486PLL','P20499PLL','P20510PLL','P23DNIR','P26DNIR',
'P3001DNIR','P3002DNIR','P3003DNIR','P3004DNIR','P3005DNIR','P3006DNIR','P30691PLL','P30695PLL','P30712PLL','P30813PLL','P30814PLL',
'P30821PLL','P30823PLL','P30826PLL','P30830PLL','P30832PLL','P30837PLL','P30838PLL','P30845PLL','P30846PLL','P30850PLL','P30851PLL',
'P30852PLL','P30860PLL','P30861PLL','P30863PLL','P31045PLL','P31046PLL','P31055PLL','P31056PLL','P31059PLL','P31062PLL','P31065PLL',
'P31085PLL','P31087PLL','P31089PLL','P31099PLL','P31103PLL','P31106PLL','P31124PLL','P31131PLL','P32NNIR','P33NNIR','P40079PLL',
'P40081PLL','P40084PLL','P40085PLL','P40087PLL','P40090PLL','P40091PLL','P40094PLL','P40095PLL','P40096PLL','P400DREE','P40114PLL',
'P40115PLL','P40159PLL','P40182PLL','P40189PLL','P40191PLL','P40194PLL','P401DREE','P40287PLL','P40288PLL','P40290PLL','P40291PLL',
'P40293PLL','P40305PLL','P40309PLL','P40311PLL','P40325PLL','P40327PLL','P40338PLL','P40392PLL','P45DNIR','PI01AGRF','PI07JGRF',
'PI08JGRF','PI09A-AGRF','PI12AGRF','PLUWAP','P-NIÑOPZK','PPT-0011GPPM','PPT-0126GPPM','PPT-0148GPPM','PPT-0165GPPM','PPT-0169GPPM','PPT-0278GGPPM',
'PPT-0282GGPPM','PPT-0305GGPPM','PPT-0348GGPPM','PS11JGRF','PS12AGRF','PT1103PPY','PT1104PPY','PT1107PPY','PULZO-12PZO','PW71071DGR','PW71951DGR',
'PW71961DGR','PW72711-2DGR','PW73051-NDGR','PW75981DGR','PW77020-NDGR','PW79540DGR','PW79740-NDGR','PY72511-NYOG','PY72761-NYOG','RE800NREB','RE801HREB',
'S45DADS','SBA20101-1SZR','SBE20143SZR','SBE20144SZR','SBE20145SZR','SBE20145-1SZR','SBE201525SZR','SBE20159SZR','SBE20163-1SZR','SBE20179SZR','SBE20183SZR',
'SBE20186SZR','SBE20191SZR','SBE20196SZR','SBE20197SZR','SBE20198SZR','SBE20228SZR','SBE20240SZR','SBE20250SZR','SBM20101-1SZR','SBM20103SZR','SBM20104-1SZR',
'SBM20104-2SZR','SCF20101SZR','SCF20101-1SZR','SCJ20115SZR','SCJ20115-2SZR','SCJ20117SZR','SCJ20121SZR','SCJ20129SZR','SCMC20220SZR','SCMC20222SZR','SCMC20239-1SZR',
'SCMC20267SZR','SCMC20338SZR','SCP20103SZR','SCPR20101SZR','SCPR20101-SZR','SCPR20104SZR','SCPR20110SZR','SCPR20121SZR','SE20102SZR','SH-010UNC','SLB-002MSBBD',
'SLB-005MSBBD','SLV-0074MSBD','SLV-0082MSBD','SLV-0085MSBD','SM-04-060ATSM','SM-04-062ATSM','SM-04-063ATSM','SM-04-070ATSM','SM-04-071CTSM','SM-04-072ATSM','SM-04-072CTSM',
'SM-04-072DTSM','SM-04-077ATSM','SM-04-079ATSM','SM-04-081ATSM','SM-04-082ATSM','SM-04-086ATSM','SM-04-088ATSM','SM-04-088CTSM','SM-04-088DTSM','SM-04-092ATSM','SM-04-093ATSM',
'SM-04-097ATSM','STCB20101SZR','SUETER-01SIN','SUETER-02SIN','SUETER-03SIN','SUETER-04SIN','SVL20121SZR','T200DPUM','T201JPUM','T205NPUM','T206DNIR',
'T207DNIK','TLF-125#FAP','TLF-602#FAP','TLF-603#FAP','TLF-615#FAP','TLF-636#FAP','TLF-650#FAP','TLF-651#FAP','TLF-652#FAP','TLF-656#FAP','USAGNO',
'V-010UNC','V-011UNC','V19181SZR','VES9,90KLN','VIS-003BBBBD','VIS-008MSBBD','VIS-021BBBD','W-11DNIR','W-16DNIR','W-21DNIR','W49DNIR',
'W54DNIR','W55DNIR','W-803DNIR','W-808DNIR','W-831DNIR','W-832DNIR','W-833DNIR','W-882DNIR','W-883DNIR','W-970DNIR','W-974DNIR',
'WAL-004BBWAL','WD-074#FAP','WFX-5780FLW','WFX-5927FLW','WHX-6316CCB','WHX-6323CCB','WJ033#FAP','WJ042#FAP','WJZ-6425FLW','WJZ-6426FLW','WJZ-6433FLW',
'WJZ-6441FLW','WJZ-6442FLW','WJZ-6459FLW','WJZ-6465FLW','WJZ-6467FLW','WJZ-6496CCB','WJZ-6507FLW','WJZ-6508XXFLW','WJZ-6548GFLW','WJZ-6553GFLW','WJZ-6764CCB',
'WJZ-6766CCB','WJZ-6774CCB','WK-076#FAP','WMA-6146FLW','WML-201VRS','WML-527VRS','WML-534VRS','WQS-5855CCB','WS136#FAP','WVLG4565-BWRS','WXF-6011FLW',
'WXF-6016FLW','WXF-6019FLW','XN1030#FAP','XN1035#FAP','XN1036#FAP','XN1038#FAP','XN1050#FAP','XN1051#FAP','XN1053#FAP','XN1055#FAP','XN1056#FAP',
'XW025FAP','XW033FAP','Y-055DNIR','Y089HBLD','Y093HTAC','Y200HBNN','Y470HTAC','Y501DNIR','Y502DNIR','Y503NNIR','Y504NNIR',
'Y505NNIR','Y544HBLD','YHM-1761ALVL','YHM-1790ALVL','YHM-1792ALVL','YMY-1309ALVL','YMY-1312ALVL','YMY-1321ASVJ','YNL-1285SVJ','09-17361AFOX','DI91N08DNE',
'DI91N09DNE','DI91N10DNE','DI91N11DNE','DI91N12DNE','DI91O01DNE','DI91O02DNE','DI91O03DNE','DI91O04DNE','DI91O05DNE','DI91O06DNE','DI91O07DNE',
'GE91N03GRD','GE91N04GRD','GE91N05GRD','GE91N06GRD','GE91N07GRD','GE91N08GRD','GE91N09GRD','GE91N10GRD','ML91N04MIL','ML91N05MIL','ML91N06MIL',
'ML91N07MIL','DQ-4086408','DQ-4088408','DQ-6905MIL','DQ-6906MIL','DQ-6906-BOY408','EM30017EMB','EM30018EMB','FCH-4084TES','FCH-4085TES','FCH-6903TES',
'FCH-6904TES','MA30001MAS','MA30003MAS','MA30005MAS','MA30007MAS','MA30009MAS','MA30011MAS','MA30013MAS','MA30014MAS','ML30002MIL','ML30004MIL',
'ML30006MIL','ML30008MIL','ML30010MIL','NV59034NIR','NV59197NIR')
GROUP BY Referencia, CodigoMarca