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 
('9001DNE','9002DNE','9003DNE','9004DNE','NV2001NIR','NV2002NIR','NV2003NIR','NV2004NIR','NV2005NIR','NV2006NIR','NV2010DNE','NV2008DNE','NV2011DNE',
'NV2012DNE','59070NIR','EM14058EMB','EM14059EMB','EM14060EMB','EM14076EMB','EM14077EMB','EM14078EMB','NV14055NIR','NV14056NIR','NV14057NIR','NV14073NIR','NV14074NIR',
'NV14075NIR','NV59065NIR','NV59167NIR','NV59168NIR','NV59169NIR','EM14034EMB','EM14035EMB','EM14036EMB','EM14037EMB','EM14038EMB','EM14039EMB','EM14040EMB','EM14041EMB',
'EM14042EMB','EM14043EMB','EM14068EMB','ML14030MIL','ML14031MIL','ML14032MIL','ML14033MIL','C59173CSO','C59174CSO','C59175CSO','27057LND','27064LND','C14022CSO',
'DN59292DNE','EM59042EMB','EM59043EMB','EM59044EMB','EM59045EMB','EM-59045MUT','EM59164EMB','EM59165EMB','EM59166EMB','GE59288GRD','GE59290GRD','LE16001LND','LE16002LND',
'LE16003LND','LE27002LND','LE27006LND','LE27022LND','LE27056LND','LE27065LND','LE27098LND','LE27099LND','LE27100LND','LE27104LND','LE27105LND','LE27106LND','LE27107LND',
'LE27108LND','LE27109LND','LE27110LND','LE27111LND','LE27112LND','LE27121LND','LE27122LND','LE27123LND','LE27124LND','LE27340LGP','LE27341GNP','LE27343GNP','LS27113SNS',
'LS27113SGL','LS27114SNS','LS27115SNS','LS27116SNS','LS27119SNS','NV59046NIR','NV59047NIR','NV59048NIR','NV59049NIR','EM61L01EMB','EM61L02EMB','EM61L03EMB','EM61L04EMB',
'EM62L01EMB','EM62L02EMB','EM62L03EMB','EM62L04EMB','EM62L05EMB','EM62L06EMB','NV62L07NIR','NV62L08NIR','NV62L09NIR','MA80M79MAS','MA80M78MAS','002-0357LAM','001-0906LAM',
'001-0907LAM','001-0908LAM','001-0909LAM','001-0948AMG','AMP-779TXB','AMP-781TXB','AMP-782TXB','AMP-783TXB','AMP-784TXB','AMP-785TXB','AMP-786TXB','AMP-787TXB',
'AMP-788TXB','YDS-76120194XVR','CMS65VRS','CM558VRS','CMS48VRS','CMP78VRS','CM3745VRS','8511NVL','4010SXA','2310SXA','3010SXA','3030SXA','3310SXA',
'3320SXA','3660SXA','4020SXA','5013NLV','MCC3001ABD','MCT3001ABD','MCT5002ABD','MCV3001ABD','MCV5002ABD','SXCP-001SXA','SXCP-002SXA','SXCP-003SXA','XMCC-002SXA',
'XMCP-001SXA','YDS-7612XVR','FLR-4470LLR','FLR-4588LLR','FLR-4589LLR','1827CLS','1510BMS','2006CLS','3195CLS','3434CLS','3442CLS','1569AMS','3403CLS',
'494-10006AIR','3435CLS','3456CLS','494-10005AIR','494-50008AIR','494-10014AIR','494-50006AIR','494-50014AIR','3420CLS','449-0633L&L','494-50005AIR','449-0629L&L','449-0663SEX',
'494-10013AIR','449-0632L&L','494-10007AIR','494-10008AIR','494-50013AIR','LS15039SGL','449-0630L&L','449-0631L&L','3441CLS','DT1204PRP','DST22002FYK','JT3466KOAWA','CMX3745VRS',
'CMS66VRS','DST22001FYK','DST22003FYK','DST22005FYK','DT1168PRP','DST22004-1FYK','DST22004-2FYK','JAM-26001STL','LS15030SNS','JAM-3001VDA','DT1212PRP','449-0360SEX','449-0361SEX',
'494-50007AIR','449-0359SEX','LS15028SNS','LS15029SNS','LS15033SNS','CM3646VRS','CMS78VRS','LS15034SNS','LS15032SNS','LS15036SGL','LS15037SGL','MNSC18VRS','449-0662SEX',
'449-0660SEX','449-0661SEX','449-0659SEX','449-0664SEX','V-024NFS','MNSS-CHARCOALVRS','DST22234FYK','DSTF2912FYK','T111DAI','CM3325VRS','449-0496SEX','4980VRS','MC1450VRS',
'DT1214PRP','3431CLS','1028JMIL','1034HCSO','1035HCSO','1037HCSO','1038NMIL','1041NCSO','1042NCSO','1059HCSO','1068DNIR','1091DNIR','1092DNIR',
'1094DNIR','1099JNIR','1100JNIR','1101JNIR','1102NNIR','1107NCSO','1109HCSO','1110NCSO','1111NCSO','1112JCSO','1113HCSO','1117DNIR','1121JNIR',
'1122JEMB','1123DNIR','1126DNIR','1133DNIR','1134DNIR','1137HEMB','1138HEMB','1142DNIR','1143DNIR','1144DNIR','1145DNIR','1147DNIR','1148DNIR',
'1149DNIR','1150DNIR','1151DNIR','1152DNIR','1153HEMB','1154HEMB','1155HEMB','1156HEMB','1157HEMB','1158HEMB','1159DNIR','1160JEMB','1161DNIR',
'1162DNIR','1163JNIR','1164JNIR','1165DNIR','1166DNIR','1167DNIR','1168DNIR','1169DNIR','1170DNIR','1171DNIR','1172DNIR','1173DNIR','1174DNIR',
'1175HEMB','1176HEMB','1177HEMB','1178HEMB','1179HEMB','1180JEMB','1181DNIR','1182JNIR','1183DNIR','1184JNIR','1185NNIR','1186NEMB','14063NMIL',
'14064JMIL','15057SNS','15061DSNS','15069JSNS','15093HCSO','15094HCSO','15095HCSO','15114DSNS','15116DSNS','15118JSNS','15119JSNS','15120JSNS','15121JSNS',
'15122JSNS','15122J804','15123JSNS','15125HCSO','15126HCSO','15127HCSO','15128HCSO','15129HCSO','15131HCSO','15132HCSO','15133HCSO','15134HCSO','15136HCSO',
'15137JCSO','15138JCSO','15139JCSO','15140DSNS','15141DSNS','15142DSNS','15143DSNS','15147DSNS','15148DSNS','15149DSNS','15152DSNS','15153DSNS','15154DSNS',
'15155DSNS','15156DSNS','15157DSNS','15158DSNS','15159DSNS','15160DSNS','15162HCSO','15163DSNS','15165DSNS','15167DSNS','15169DSNS','15171DSNS','15173DSNS',
'15174JSNS','15177JSNS','15179DSNS','15181DSNS','15182DSNS','15183DSNS','15184DSNS','15185DSNS','15186DMIL','15187DMIL','15188DMIL','15189DMIL','15190DMIL',
'15191DMIL','15192DMIL','15194DSNS','15195DSNS','15196DSNS','15197DSNS','15198NSNS','15199NSNS','15200NSNS','15201NSNS','15202HCSO','15203H408','15204HCSO',
'15205HCSO','15207HCSO','15208HCSO','15209HCSO','15210HCSO','15211HCSO','15212HCSO','15213J408','15213JCSO','15214JCSO','15215JCSO','15216HCSO','15217HCSO',
'15218HCSO','15219HCSO','15220HCSO','15221HCSO','15222DSNS','15223DSNS','15224DSNS','15225DSNS','15226DSNS','15227DSNS','15228DSNS','15229DSNS','15230DSNS',
'15231DSNS','15232DSNS','15233DSNS','15234DSNS','15235DSNS','15236DSNS','15237JSNS','15238JSNS','15239JSNS','15240JSNS','15241JSNS','15242JSNS','15243HCSO',
'15244HCSO','15245HCSO','15246HCSO','15247HCSO','15248HCSO','15249HCSO','15250HCSO','15251HCSO','15252JCSO','15253JCSO','15254JCSO','15255JCSO','15256JCSO',
'15257DSNS','15275DNIR','15288DSNS','15291JSNS','15295DSNS','15301DSNS','15305HCSO','15306HCSO','15307HCSO','15308DMIL','15309DMIL','15310DMIL','15311DMIL',
'15312DMIL','15313DSNS','15315HCSO','15316HCSO','15317HCSO','15318HCSO','15319HCSO','15320HCSO','15331JSNS','15333JSNS','15341JSNS','15346DSNS','15347JSNS',
'18017DMIL','18026JMIL','18027JMIL','18029NMAS','18030NMIL','18032DMIL','18033DMIL','18034DMIL','18035DMIL','18039DMIL','18040DMIL','18041JMIL','18042JMIL',
'18043JMIL','18044JMIL','18045DMIL','18046DMIL','18047NMIL','18048DMIL','18049DMIL','18051DMIL','18052DMIL','18053NMAS','18054DNIR','18055DNIR','18056DNIR',
'19039DSNS','19055NMAS','19056DSNS','19057DSNS','19058DSNS','19059DSNS','19061JSNS','19062DMIL','19063DMIL','19064DSNS','19065HEMB','19066HEMB','19067HEMB',
'19068HEMB','19069HEMB','19070HEMB','19071HGNP','19072HGNP','19073HGNP','19074HGNP','19075HGNP','19076JGNP','19077HCSO','19078HCSO','19079HCSO','19080HCSO',
'19081HCSO','2052DMIL','23098DMIL','23115HCSO','23138JCSO','23154HCSO','23155HCSO','23156HCSO','23157DMIL','23158DMIL','23160JCSO','23162JMIL','23163JMIL',
'23165HCSO','23166HCSO','23167HCSO','23168HCSO','23169HCSO','23170HCSO','23171HCSO','23172HCSO','23173DMIL','23175DMIL','23177DMIL','23178JCSO','23180JMIL',
'23184HCSO','23185HCSO','23186HCSO','23188DMIL','23191DMIL','23194JMIL','23195DMIL','23196JMIL','23204JMIL','23205JMIL','23206JMIL','23207NMIL','23208NMIL',
'23209JMIL','23210DMIL','23212JMIL','23213DMIL','23214JMIL','23215JMIL','23217JMIL','23218JMIL','23219DMIL','23220NCSO','23222HCSO','23223HCSO','23225JCSO',
'23226HCSO','23227HCSO','23228NCSO','23229JCSO','23234HCSO','23235HCSO','23236NCSO','23237JCSO','23238HCSO','23239HCSO','23242HCSO','23243HCSO','23244DMIL',
'23247DMIL','23248DMIL','23249DMIL','23250DMIL','23251DMIL','23252DMIL','23253DMIL','23254DMIL','23255DMIL','23256DMIL','23257DMIL','23258DMIL','23259JCSO',
'23260HCSO','23261HCSO','23262JMIL','23263DMIL','23263D801','23265HCSO','23266HCSO','23267HCSO','23268HCSO','23269HCSO','23270JNIR','23271DNIR','23272DNIR',
'23273JEMB','23274HEMB','23275HEMB','23276HCSO','23277HCSO','23278DMIL','23279DMIL','23280HCSO','23281JCSO','23282DMIL','23283DMIL','23284DMIL','23285DMIL',
'23286JMIL','23287JMIL','23288JMIL','23289JMIL','23290NMIL','23291DMIL','23292DMIL','23293DMIL','23294DMIL','23295DMIL','23296DMIL','23297DMIL','23298DMIL',
'23299DMIL','23300DMIL','23301DMIL','23302DMIL','23304DMIL','23305JMIL','23306JMIL','23307JMIL','23308JMIL','23309NMIL','23310NMIL','23311NMIL','23312NMIL',
'23313NMIL','23315JMIL','23316JMIL','23317DMIL','23318DMIL','23319DMIL','23320DMIL','23322DMIL','23323DMIL','25004HEMB','25019DNIR','25029DNIR','26020NCSO',
'26025NMIL','26034NMIL','26035NCSO','26036NMIL','26040NMIL','26043NCSO','26044NCSO','26045NCSO','26046NMIL','26047NMIL','26048NMIL','26049NCSO','26050NCSO',
'26051NCSO','26052NMIL','26053NMIL','26054NMIL','26055NCSO','26056NMIL','26057NCSO','26058NMIL','26060NCSO','26061NMIL','26062NMIL','26064NCSO','26065NMIL',
'26066NMIL','27057DMIL','27058DMIL','27061DMIL','27063NMIL','27066DMIL','27067DMIL','27069DMIL','27070DMIL','27071DMIL','27074DMIL','27076DMIL','27077HEMB',
'27078HEMB','27079DNIR','27080DNIR','27081DNIR','27082DNIR','27083HEMB','27084DNIR','27085DNIR','27086HEMB','27087DNIR','28085HCSO','28089JMIL','28090JMIL',
'28095DMIL','28100JMIL','28101JMIL','28102NMIL','28103NMIL','28110HCSO','28111HCSO','28119HCSO','28123HEMB','28124DNIR','28127JCSO','28128HCSO','28132HCSO',
'28133JMIL','28134DMIL','28135DMIL','28137DNIR','28138HEMB','28139DNIR','28141NCSO','28142JCSO','28143NMIL','28144JMIL','28145NCSO','28146JCSO','28147HCSO',
'28149JMIL','28150NMIL','28152JMIL','28153NMIL','28177HCSO','28178JCSO','28179NCSO','28216DMIL','28217JMIL','28218NMIL','30034HCSO','30039NMIL','30053NMIL',
'30055JMIL','30057DMIL','30062NMIL','30068NMIL','30070JMIL','30073NCSO','30074NMIL','30076NMIL','30083HCSO','30085HCSO','30087JMIL','30090HCSO','30091DMIL',
'30093JCSO','30094JMIL','30095HCSO','30096HCSO','30097JCSO','30098JMIL','30099NCSO','30100NMIL','30101HCSO','30101H408','30102DMIL','30104NCSO','30105NCSO',
'30106NMIL','30107NMIL','30109JCSO','30110JMIL','30111NCSO','30112NMIL','30114DMIL','30121DNIR','30122JNIR','30124HEMB','30125JEMB','30128JCSO','30130HCSO',
'30141DMIL','30144HCSO','30145HCSO','30148DMIL','30151HCSO','30154DMIL','30155JMIL','30156HCSO','30157HCSO','30158JCSO','30159DMIL','30162HCSO','30163HCSO',
'30166DMIL','30169HCSO','30170HCSO','30173HCSO','30174HCSO','30175J408','30175JCSO','30176N408','30176NCSO','30177HCSO','30178HCSO','30179JCSO','30180JMIL',
'30181NMIL','30182NMIL','30183JCSO','30184NCSO','30184N800','30185NCSO','30187JMIL','30188NMIL','30189HCSO','30190HCSO','30191JCSO','30192NCSO','30193DMIL',
'30194JMIL','30195NMIL','30196HCSO','30197HCSO','30198JCSO','30199NCSO','30200HCSO','30201HCSO','30202NMIL','30203N408','30203NCSO','30204NMIL','30205NMIL',
'30206NMIL','30207N408','3088HCSO','3093HCSO','3098HCSO','3099DMIL','31022JMIL','31023JMIL','31024NMIL','31027DMIL','3102DMIL','31031DMIL','31033NMIL',
'31035HCSO','3103DMIL','31040DMIL','31041DMIL','31042DMIL','31043DMIL','31044DMIL','31045DMIL','31048DMIL','31049DMIL','3104DMIL','31050JMIL','31051DMIL',
'31052DMIL','31053JMIL','31054DMIL','31056DMIL','31059HCSO','31061HCSO','31062HCSO','31063HCSO','31065HCSO','31066DMIL','31067DMIL','3106DMIL','31070JCSO',
'31075DMIL','31076DMIL','3109DMIL','3110DMIL','3112HCSO','3113HCSO','3117DMIL','3118DMIL','3120DMIL','3123HCSO','3127HCSO','3132H408','3135NCSO',
'3146HCSO','3147HCSO','3148HCSO','3149HCSO','3150HCSO','3151HCSO','3153DMIL','3154HCSO','3155HCSO','3157HCSO','3158HCSO','3159HCSO','3160HCSO',
'3161HCSO','3162HCSO','3163HCSO','3164HCSO','3165HCSO','3166HCSO','32012NMIL','32027NCSO','32028NMIL','32029JCSO','32030JMIL','32031DMIL','32032HCSO',
'32034DMIL','32035HCSO','32036HCSO','32039HCSO','32041HCSO','32043DMIL','32044JMIL','32045NMIL','32046NMIL','32051DMIL','32052JMIL','32055DMIL','32056DMIL',
'32057JMIL','32058JEMB','32059HEMB','32060HEMB','32061HEMB','32062HEMB','32063DNIR','32064DMIL','32065DNIR','32066JEMB','32067JEMB','32068JEMB','32069JNIR',
'32070JNIR','32071JNIR','32072NEMB','32073NEMB','32074NNIR','32077HCSO','32080HCSO','32081H408','32082DMIL','32083NCSO','32084NCSO','32085NMIL','32086NMIL',
'32087JMIL','32088NMIL','32089JCSO','32090NCSO','32091JMIL','32092NMIL','32093JCSO','32094NCSO','32095JMIL','32096NMIL','32097JCSO','32098NCSO','3212NCSO',
'3213NCSO','3262HCSO','3263HCSO','3264NCSO','3270HCSO','3271NCSO','3272NCSO','33011NMIL','33014HMAS','33015HMAS','33016HMAS','33017HEMB','33018DNIR',
'33019HEMB','34002NMIL','34003NCSO','34006NCSO','34007NMIL','34008NCSO','34010NCSO','34012NCSO','34013NMIL','34014JCSO','34015JMIL','34020HCSO','34021HCSO',
'34022DMIL','34023JCSO','34024JMIL','34026NMIL','34027DMIL','34028HCSO','34031DMIL','34032HCSO','34033JCSO','34034JMIL','34035NCSO','34036NMIL','34037NMIL',
'34038DNIR','34043HCSO','34044HCSO','34045NMIL','34046NCSO','34047JCSO','34048NMIL','34049JMIL','34057N408','34061HCSO','34062HCSO','34063J408','34064NCSO',
'34065DMIL','34066 JMIL','34067NMIL','34068DMIL','34072DMIL','36003DMIL','36007DMIL','36028DMIL','36029DMIL','36030DMIL','36031DMIL','36032DMIL','36033DMIL',
'36034DMIL','36035DMIL','36036DMIL','36037DMIL','36038DMIL','36039DMIL','36040DMIL','36042JMIL','36043JMIL','36044DMIL','36045DMIL','36046DMIL','36047DMIL',
'36049DMIL','36050DMIL','36051DMIL','36052DMIL','36053DMIL','36054DMIL','36057DMIL','36060DMIL','36061DMIL','36062DMIL','36063DMIL','36064DMIL','36065DMIL',
'36066DMIL','36067DMIL','36068DMIL','36069DMIL','36070DMIL','36071JMIL','36072DMIL','36073JMIL','36074DMIL','36075JMIL','36087JMIL','3628JSYD','37011MIL',
'38001HCSO','38002HCSO','38003DMIL','38004JCSO','38005JMIL','38006HCSO','38007DMIL','38008DMIL','38009JMIL','38010NMIL','38011DMIL','38013DMIL','38014DMIL',
'38015DMIL','38016DMIL','38017JMIL','38018NMIL','38019JMIL','38020NMIL','38021NMIL','38022NMIL','38023NMIL','38025NMIL','38026NMIL','38027DMIL','38028HCSO',
'38029HCSO','38030JCSO','38031NCSO','38032HCSO','38033HCSO','38034JCSO','38035NCSO','38036HCSO','38037HCSO','38038JCSO','38039HCSO','38040HCSO','38041HCSO',
'38042HCSO','38044JCSO','38045NCSO','38047NCSO','38051HCSO','38058HCSO','38085JCSO','38086N408','38087J408','38088N408','38089JCSO','38096HCSO','38097HCSO',
'38098NMIL','38099JMIL','38101NMIL','38102JMIL','38104JMIL','38105JMIL','38109DMIL','39001DSNS','39002DSNS','39003DSNS','39004HCSO','39005HCSO','39006HCSO',
'40001HCSO','40002HCSO','40004HCSO','40005HCSO','40008HCSO','40008H408','40009HCSO','40010HCSO','40011H408','40011HCSO','4032NCSO','4035JCSO','4036HCSO',
'41001DNIR','41002HEMB','41003HEMB','41004JEMB','41005JEMB','41006JEMB','41007HEMB','41008HEMB','41009HEMB','41010HEMB','41011HEMB','41012HEMB','41014DNIR',
'41016HEMB','41018HEMB','41019DNIR','41021DNIR','4142DMIL','4143NCSO','4144JCSO','4146HCSO','42001HCSO','42002HCSO','42003HCSO','42004HCSO','42005HCSO',
'42006HCSO','42007HCSO','42008HCSO','42009HCSO','4207NCSO','4209HCSO','4210HCSO','4215DMIL','4216DMIL','4217JCSO','4218JCSO','4219JMIL','4220JMIL',
'4221HCSO','4223HCSO','4224DMIL','4232NMIL','4235JMIL','4237NCSO','4238NMIL','4241NCSO','4242NCSO','4245NMIL','4247NMIL','4248NCSO','4249JCSO',
'4251NCSO','4252JCSO','4253HCSO','43001HEMB','43003DNIR','43004DNIR','45001HEMB','45003HEMB','45005HEMB','45006HEMB','45007HEMB','45008DMIL','45009DMIL',
'45010DMIL','45011DMIL','45012DMIL','46001HCSO','46002HCSO','46003JCSO','46004NCSO','46005NCSO','46006DMIL','46007JMIL','46008NMIL','46009NMIL','46010HCSO',
'46019HCSO','46023DMIL','46047DMIL','46062HCSO','46063HCSO','46067DMIL','46071HCSO','46072HCSO','46076DMIL','46077JMIL','46091JMIL','46092NMIL','46093JMIL',
'46094NMIL','46100NCSO','46102JEMB','46103HEMB','46104HEMB','46105DNIR','46108DNIR','47002HEMB','47003HEMB','47004HEMB','47005HEMB','47006DNIR','5016DMIL',
'5017DMIL','5018DMIL','5019DMIL','5021DMIL','5023DMIL','5025DMIL','5029HCSO','5030HCSO','5031HCSO','5032HCSO','5033HCSO','5034HCSO','5035HCSO',
'5335DSTY','6016DNIR','6017DNIR','7003DMIL','7007HCSO','FD01VRS','FC01VRS','FN01VRS','FN02VRS','XL001-1350LAM','XL001-1351LAM','XL001-1352LAM','XL001-1353LAM',
'XL001-1354LAM','001-1392LAM','001-1393LAM','001-1394LAM','001-1196CTR','001-1197CTR','001-1198CTR','001-1199CTR','001-1200CTR','001-1409CTR','001-1410CTR','001-1411CTR','001-1412CTR',
'001-1413CTR','001-1414CTR','001-1415CTR','001-1416CTR','001-1417CTR','001-1418CTR','BRIP-666TXB','BRIP-672TXB','BRIP-668TXB','BRIP-670TXB','BRIP-671TXB','BRIP-669TXB','BRIP-664TXB',
'BRIP-665TXB','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','04L176-180NIR','418-0387L&L',
'2-233-VBVRS','JOG01KLN','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-0062AATD','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',
'XW021FAP','001-1981CTR','001-1982CTR','001-1984CTR','001-1985CTR','001-1989CTR','30173H408','30174H408','30177H408','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-50001AIR','494-50002AIR','494-50003AIR','494-50004AIR',
'8511NLV','AMP-745TXB','AMP-748TXB','AMP-757TXB','AMP-946TXB','BK01VRS','FRA03VRS','LEG01VRS','OV01VRS','FRA3,90KLN','418-0386L&L','418-0389LO&','418-0390L&L',
'418-0392L&L','418-0393L&L','418-0394L&L','418-0617BCE','418-0618BCE','418-0621BCE','534GNK','56HER','59432GNK','A2-I20-PY071DFF','A2-I20-PY073DFF','B3-E20-LW216DFF','B3-E20-LW217DFF',
'D-187GNK','D-188GNK','D-190GNK','D-193GNK','D-194GNK','DTS9097HEN','DTS9098HEN','DTS9106HEN','DTS9139HEN','DTS9141HEN','DTS9145HEN','DTS9146HEN','DTS9153HEN',
'DTS9155HEN','DW158GNK','DW159GNK','001-0947AMG','001-0948AMG','001-0949AMG','001-0950AMG','001-1340AMG','001-1341AMG','001-1343AMG','001-1344AMG','001-1345AMG','001-1346AMG',
'001-1347AMG','001-1348AMG','001-1349AMG','001-1399AMG','001-1400AMG','001-1401AMG','001-1402AMG','001-1403AMG','001-1404AMG','001-1405AMG','001-1406AMG','001-1407AMG','001-1408AMG',
'449-0513L&L','001-1389LAM','001-1391LAM','0039-0001NUF','0039-0002NUF','XL001-1357LAM','LR0401LRN','LS8001SNS','LS8010SNS','LS8012SNS','LR0410LRN','LR32L141LRN','LR32L140LRN',
'LS80M26SNS','LS80M27SNS','LR80M94LRN','LR80M93LRN','LR80M96LRN','LR80M30LRN','LR80M95LRN','LS8002SNS','BK-0110SEX','BK-0111SEX','BK-0109ESEX','BK-0094L&L','BK-0111ESEX',
'GP32B0GNP','GP32M31GNP','GP32M32GNP','GP32M33GNP','GP32M34GNP','GP32M35GNP','GP32M36GNP','GP34I12GNP','GP34I16GNP','GP3601GNP','GP3602GNP','GP36K14GNP','GP36K15GNP',
'GP36K16GNP','GP36K17GNP','GP36K18GNP','GP36K19GNP','GP36K20GNP','LE32B0LEA','LE32G69LND','LE32G72LND','LE32G73LND','LE32G76LND','LE32K100LND','LE32K101LND','LE32K96LND',
'LE32K98LND','LE32M83LND','LE32M84LND','LE32M85LND','LE32M86LND','LE32M89LND','LE32M90LND','LE32M91LND','LE32M92LND','LE32N171LND','LE32N172LND','LE32N173LND','LE32N174LND',
'LE32N175LND','LE32N176LND','LE32N177LND','LE32N178LND','LE32N179LND','LE32N180LND','LE32K92LND','MA32B0MAS','MA32F56MAS','MA32F64MAS','MA32F65MAS','MA32I09MAS','MA32I14MAS',
'MA32K102MAS','MA32K103MAS','MA32K104MAS','MA32K105MAS','MA32K106MAS','MA32K107MAS','MA32K108MAS','MA32K109MAS','MA32K110MAS','MA32K111MAS','MA32M148MAS','MA32M63MAS','MA32M64MAS',
'MA32M66MAS','MA32M67MAS','MA32M68MAS','MA32M69MAS','MA32M70MAS','MA32M71MAS','MA32M72MAS','MA32N192MAS','MA32N193MAS','MA32N194MAS','MA32N195MAS','MA32N196MAS','MA32N197MAS',
'MA32N198MAS','MA32N199MAS','MA32N200MAS','MA32N201MAS','LR0411LRN','LR04M49LRN','LR04M50LRN','LR04M51LRN','LR04M52LRN','LR28O18LRN','LR8010LRN','LR8011LRN','LR8012LRN',
'LR80M11LRN','LR80M12LRN','LR80M13LRN','LR80M29LRN','LR80M52LRN','LR80M53LRN','LR80M91LRN','LR80M92LRN','NV28O17LRN','NV28O18LRN','LS04K128SNS','LS04K129SNS','LS04K144SNS',
'LS04M45SNS','LS04M46SNS','LS04M47SNS','LS04M48SNS','LS04M49SNS','LS04M50SNS','LS04M51SNS','LS04M52SNS','LS80J21SNS','LS80L27SNS','LS80L28SNS','LS80L30SNS','LS80M29SNS',
'LS80M28SNS','LS80M30SNS','LR04M54LRN','LR04M55LRN','LR04M56LRN','LR04M57LRN','LR04M58LRN','LR04O14LRN','LR04O16LRN','LR28O16LRN','LR28O17LRN','LR3201LRN','LR3202LRN',
'LR3203LRN','LR3205LRN','LR3206LRN','LR32K52LRN','LR32K53LRN','LR32K54LRN','LR32K55LRN','LR32K62LRN','LR32K63LRN','LR32K64LRN','LR32K65LRN','LR32K69LRN','LR32K70LRN',
'LR32K71LRN','LR32M13LRN','LR32M14LRN','LR32M15LRN','LR32M19LRN','LR32M20LRN','LR32M29LRN','LR32M30LRN','LR8002LRN','LR80M21LRN','LR80M22LRN','LR80M23LRN','LR80M24LRN',
'LR80M25LRN','NV28O15LRN','NV28O16LRN','LS04K141SNS','LS04M53SNS','LS04M54SNS','LS04M55SNS','LS04M56SNS','LS04M57SNS','LS04M58SNS','LS32G23SNS','LS32K07SNS','LS32K08SNS',
'LS32K42SNS','LS32K43SNS','LS32K44SNS','LS32K45SNS','LS32K51SNS','LS32K52SNS','LS32K53SNS','LS32K62SNS','LS32K63SNS','LS32K64SNS','LS32K69SNS','LS32K70SNS','LS32K71SNS',
'LS32L132SNS','LS32L133SNS','LS32L134SNS','LS32L135SNS','LS32M11SNS','LS32M14SNS','LS32M15SNS','LS32M17SNS','LS32M18SNS','LS32M19SNS','LS32M20SNS','LS32M21SNS','LS32M22SNS',
'LS32M23SNS','LS32M24SNS','LS32M25SNS','LS32M26SNS','LS32M27SNS','LS32M28SNS','LS32M29SNS','LS32M30SNS','LS32N202SNS','LS32N203SNS','LS32N204SNS','LS32N205SNS','LS32N206SNS',
'LS32N207SNS','LS32N208SNS','LS32N209SNS','LS32N210SNS','LS32N211SNS','LS3601SNS','LS36K08SNS','LS80J26SNS','LS80J28SNS','LS80L17SNS','LS80L18SNS','LS80L19SNS','LS80L20SNS',
'LS80L21SNS','LS80L22SNS','LS80L23SNS','LS80L24SNS','LS80L26SNS','LS80M16SNS','LS80M17SNS','LS80M18SNS','LS80M19SNS','LS80M20SNS','LS80M21SNS','LS80M22SNS','LS80M23SNS',
'LS80M24SNS','LS80M25SNS','LS32M16SNS','LS32K55SNS','LS32K65SNS','LS32M12SNS','LS32M13SNS','LS80L25SNS','78571GNK','HB2288GNK','NK5252GNK','NSK2108GNK','NST8500GNK',
'NST8507GNK','NST8819GNK','NST8822GNK','NST8877GNK','NST8879GNK','QC9160GNK','SK2219GNK','SK2259GNK','SK2262GNK','SK2265GNK','SK2267GNK','SN5447GNK','SN5795GNK',
'X1467GNK','LS32L140KRN','C21-LW5892CLTS','C21-LW5893CLTS','E21-LGQ5934WBBLTS','E21-LGQ5935CLTS','ML32K75MIL','ML32K76MIL','ML32K77MIL','ML32K78MIL','ML32K79MIL','ML32K80MIL','ML32K81MIL',
'NV04M18NIR','SP09M09SPH','SP09M10SPH','SP09M11SPH')
GROUP BY Referencia, CodigoMarca