CREATE   PROCEDURE SP_MATCH_PRODUCERCODE_OR_CODE
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @LIST NVARCHAR(MAX) =
N'48609-0F021, 51726-TR0-A01, 48619-F4010, 52722-SDA-A01, 51722-SS0-004, 51722-SMG-E04, 51722-TET-H01, 52722-S9A-014, 51722-SWA-A02, 52722-SS0-003, 52722-TET-A01, UNI-ANTEN-114, UNI-ANTEN-145, UNI-ANTEN-127, UNI-ANTEN-105, 39151-S6A-E02, UNI-ANTEN-107, UNI-ANTEN-124-122, 8980530480, UNI-ANTEN-101, UNI-ANTEN-132, UNI-ANTEN-108, UNI-ANTEN-129, UNI-ANTEN-123/112D, UNI-ANTEN-102, UNI-ANTEN-103, 282B3-4BA0A, 1428451, 1428452, UNI-AYNA-77-LH, UNI-AYNA-78-RH, 601000018AADQJ-H-L, 601000017AADQJ-H-L, 87321-25500, 87321-1E000, 87321-0U000, 74865-SEL-T11, 74865-S04-003, 74865-S5A-003, 74865-SEN-A01, 64461-12290, 75490-TR0-A01, 75495-TR0-A01, 60117-02010, 60118-02010, 60117-02250, 60118-02250, 60117-0D100, 60118-0D100, 53293-02240, 53294-02230, 4605A195, 8-98102359-2, 11955-5X00E, 11925-EB32A, 16577-37030, 17910-65J00, 85321-28020, 16268-33070, 17831-69G00, 17860-63J00, 17580-65D00, 21022-EB70A, 23810-30100, 13368882, 13368880, 20940465, 20940464, 13368873, 13368872, UNI-BRKT-020, UNI-BRKT-019, 22793772, 22793771, 22798556, 22798555, 39145054, 39145053, MB423467, 53823-02130, 53824-02130, 55708-02590, 55708-12130, 72910-TL0-003, 72950-TL0-003, 72450-TL0-003, 72910-TR0-A01, 72950-TR0-A01, 72950-TR0-A01, 72410-TR0-A01, 72450-TR0-A01, 72910-T20-A01, 72950-T20-A01, 75730-12360, 75740-12440, 75740-02410, 75710-12830, 75720-12830, 75730-02490 NIKELAJ, 75740-02490 NIKELAJ, 75740-02490 SIYAH, 75710-02490 SIYAH, 75710-02490 NIKELAJ, 75720-02490 NIKELAJ, 75720-02490 SIYAH, UNI-CCSF-034, UNI-CCSF-033, UNI-CCSF-032, UNI-CCSF-031, 72910-SWA-A01, 72950-SWA-A01, 72410-SWA-A01, 72450-SWA-A01, 68163-0K010, 68164-0K010, 68162-0K010, 68161-0K010, 68180-0K010, 68230-0K010, 68160-0K010, MN117616, MN117615, MN117612, MN117611, 82821-4EA0A, 82821-HV00A, 8251A020, 85110-12860/85110-12810, MK548498, MK548497, UH71-26-630/UH71-26-640, UR58-26-630/UR58-26-640, 04943-02020/04943-02060, 8979474030, 53840-65D00, 53810-65D00/53820-65D00, 04943-0K070/04943-0K050, 04943-0K045/04943-0K040, 04942-0K210, MR205286/MR205287, 44200-AX600, 44201-EB360/44200-EB70AT, 4600A139/4600A140-T, 48190-0K010, 8972345245, 48190-0K040, 48190-0K050, 54580-2ZG0A, 54419-VK80A, 11056-AD200, 39600-SAA-003, 52591-02410, 52592-02380, 86812-29000, 86820-2P000, 86810-2P000, 622A0-BM400, 622A0-BN700, UNI-21890, UNI-07218, 622A0-3HN0H, 85071-4EA0A, 85071-BR00A, 75555-05070, 75556-05070, 75555-05040, 75556-05040, 75055-12120, 75056-12120, 75555-02090, 75556-02100, 74306-TR0-A01, 74316-TR0-A01, 74306-TBA-A00, 75555-02011, 75556-02011, 75555-02270, 75556-02260, 75552-02140, 75551-02140, 75555-02220, 75556-02220, 75551-0K011, 75552-0K011, 74306-SAA-003, 74316-SAA-003, 73852-JE20A, 73853-JE20A, 52611-02530, UNI-MAC-101, UNI-MAC-100, F201-16-520B, 31204-52010, 897039266, 31204-0K071, 31204-0K110, 22821-PWL-000, 30531-EB300, 45260-12580, 45203-0K010, UNI-MD-100, UNI-BDK-335, UNI-BDK-334, MB561722, 25290-73P00, 25290-JD09B, 84840-28030, 35750-SMG-G01, UNI-DCM-100, 8-97417004-0, 8981912520, 47125-SNA-A82ZB, 71-13040-00, 11049-00Q0A, 14033-00Q0C, 14033-00Q0B, 8-973333481, 8973714472, 1675812480, 1675812580, 9817296980, 9817298380, BG2M-51-040, 216-1139-RH, 216-1139-LH, 216-1120-RH, 216-1120-LH, GE8K-51-030D, GE8K-51-040P, 8V0941044, 8V0941043, 8K0941030G, 8K0941029G, 8K0941044, 8K0941043, 8W0941044, 8W0941043, 4K0941040, 4K0941039, 92101-22010, 92102-22010, 92102-22300, 92101-22300, 92102-25511-T, 92101-25511-T, 92102-1R040, 92101-1R040, 33103-SM4-E04, 33153-SM4-E04, 2H1941016N, 2H1941015N, 92102-02010, 92101-02010, 92102-05520, 92101-05520, 81130-05190, 81170-05194, 81130-05240, 81170-05240, 96650528, 96650754, 96650755, 8BUR-51-030, 8BUR-51-040, 53271-12060, 71140-SNB-003, 71190-SNB-003, 71140-S9A-A00, 71190-S9A-A00, 62044-4EA0A, 62045-4EA0A, 62044-HV00A, 62045-HV00A, 26042-4CA0A, 26092-4CA0A, 33119-TA0-003(W3T19371), 33119-SZT-G01, 0K600-51-020-RH, 0K600-51-020-LH, 0K6M7-51-030, 0K6M7-51-040, 92102-4E000, 92101-4E000, 92102-4E510, 92101-4E510, 92102-4E700, 92101-4E700, 1J5941018BE, 1J5941017BE, UR82-51-0K0G, UR82-51-0L0E, UB9B-51-0K0A, UB9B-51-0L0A, 2K1941006A, 2K1941005A, 2K1941016B, 2K1941015B, 2K8941006B, 2K8941005B, MK581218, MK581217, 35120-77A00, 35320-77A00, 3C8941754Q, 3C8941753Q, 9675139980, 9675140080, 9817297880, 9817298480, 92102-2F010, 92101-2F010, 123-1101-RH, 123-1101-LH, 92102-A7550, 92101-A7550, 92102-A7500, 92101-A7500, 33101-SEL-P61, 33151-SEL-P61, 33100-TM0-T01, 33150-TM0-T01, 33101-S04-G02, 33151-S04-G02, 33101-S04-B03, 33151-S04-B03, 33101-S5A-901, 33151-S5A-901, 33101-TR0-G11, 33151-TR0-G11, 33100-T24-Y12, 33150-T24-Y12, 212-1112-RH, 212-1112-LH, 81110-1E180, 81150-1E440, 212-11A4-RH, 212-11A4-LH, 212-11D1-RH, 212-11D1-LH, 81130-02B10, 81170-02B10, 81130-02E70-RH, 81170-02E70-LH, 81130-02T31-M, 81170-02T31-M, 81110-2B640, 81150-2B600, 33101-S9A-B01-BYZ, 33151-S9A-B01-BYZ, 33101-S9A-B01-SARI, 33151-S9A-B01-SARI, 33101-SWA-G01, 33151-SWA-G01, 213-1131-RH, 213-1131-LH, 213-1137-RH, 213-1137-LH, 213-1138-RH, 213-1138-LH, 8981253845-B, 8981253855-B, 213-1142-RH, 213-1142-LH, 213-1143-RH, 213-1143-LH, UNI-X-084-2-LH, 92102-2D500, 92101-2D500, 92102-F2100, 92101-F2100, 92102-F2000, 92101-F2000, 92102-F2600, 92101-F2600, 92102-F2500, 92101-F2500, 92102-AA100, 92101-AA100, 92102-24300, 92101-24300, 1J1941018F, 1J1941017F, 1K6941006R, 1K6941005R, 5K1941006L, 5K1941005L, 5G1941034, 5G1941033, 5G1941006, 5G1941005, 5G1941774, 5G1941773, 5G1941006D, 5G1941005D, 5H1941036, 5H1941035, 35120-65D30, 35320-65D30, 35120-50J20, 35320-50J20, 35120-65JB0, 35320-65JB0, 92102-4H000, 92101-4H000, 92102-4B000, 92102-43420, 92101-43420, 92102-43800-T, 92101-43800-T, 92102-4F030, 92101-4F030, 92102-4F500, 92101-4F500, 92102-4F700, 92101-4F700, 81130-35370, 81170-35350, UNI-FAR-042-RH, UNI-FAR-041-LH, 81110-0K440, 81150-0K440, UNI-FAR-034-RH, UNI-FAR-033-LH, 81110-0K690, 81150-0K690, UNI-X-170A, UNI-X-170A, UNI-06305, UNI-09860, 92102-0X010, 92101-0X010, 92102-0X120, 92101-0X120, 92102-1J010, 92101-1J010, 221-1146-RH, 221-1146-LH, 92102-2S520, 92101-2S520, 33101-SAA-H61, 33151-SAA-H61, 33101-SAA-H51, 33151-SAA-H51, 33100-TG5-H01, 33150-TG5-H01, 33100-TF0-H51, 33150-TF0-H51, 5C7941006A, 5C7941005A, 96108150, 96408151, 8301A824, 8301A823, 214-1180-RH, 214-1180-LH, UNI-FAR-420, UNI-FAR-410, UNI-FAR-020-RH, UNI-FAR-019-LH, 8301C730, 8301C729, 8301D380, 8301D381, 8301D378, 8301D377, MR439534, MR439533, 92102-10000, 92101-10000, 26015-1HM0A-B201, 26065-1HM0A-B201, 215-11B2-RH, 215-11B2-LH, 26010-5X00B, 26060-5X00B, 26010-4JA3B, 26060-4JA3B, 26010-4JA0B, 26060-4JA0B, 9806306580, 9806306180, 9677202380, 9677202480, 3B0941016AK, 3B0941015AK, 3C0941006M, 3C0941005M, 3AB941006, 3AB941754, 3AB941005, 3AB941753, 3G1941006B, 3G1941005B, 3C8941754C, 3C8941753C, 215-1173-RH, 215-1173-LH, 215-1189-RH, 215-1189-LH, 6Q1941008AT, 6Q1941007AT, 6R1941008F, 6R1941007F, 6R1941016E, 6R1941015E, 6C1941006, 6R1941008G, 6C1941005, 6R1941007G, 2G1941006, 2G1941005, 2G1941006C, 2G1941005C, 26010-2F925, 26060-2F925, 26010-JD000, 26060-JD000, 26010-4EA0A, 26060-4EA0A, 26010-HV00A, 26060-HV00A, 0K31G-51-030C, 0K31G-51-040C, 92102-1G020, 92101-1G020, 92102-1G630, 92101-1G630, 92102-1W200, 92101-1W200, 92102-1W050, 92101-1W050, 92102-H9000, 92101-H9000, 92102-3E020, 92101-3E020, 92102-1F010, 92101-1F010, 92102-03000, 92101-03000, 92102-3W420, 92101-3W420, 35121-60B30, 35321-60B30, 35120-63J10, 35320-63J10, 35120-79J00, 35320-79J00, 1514952-00-C, 1514953-00-C, 5N1941032AB, 5N1941031AB, 5N1941006B, 5N1941005B, 5NB941114A, 5NB941113A, 5NB941114C, 5NB941113C, 7H1941018N, 7H1941017N, 92102-2E020, 92101-2E020, 92102-2E021, 92101-2E021, 92102-D3110, 92101-D3110, 92102-D3040, 92101-D3040, 92102-D7600, 92101-D7600, 35100-60A30, 35300-60A30, UNI-FAR-303-RH, UNI-FAR-303-LH, 212-11A2-RH, 212-11A2-LH, 81130-0D090, 81170-0D090, 85353-12081, 85354-12081, 85354-02904, 85353-02904, UNI-18086, UNI-18087, UNI-21303, UNI-21302, UNI-13336, UNI-13345, 33100-TET-H11, 33150-TET-H11, 25420-5X9-A01, 8973310630, 8-97207143-0, 8980580110, MB618320, UNI-19798, 04942-0K130, 44200-VW000, 44201-VW000, 32005-4KV0A, 74320-12A30-B0, 74310-12A60-B0, 88217-TR0-A01ZA, 74348-33040-GRI, 96409-3DF0B-A156, 88217-S01-A01-GRI, 53701-SDA-A01, US9350000, 44360-0K050, B6BF-13-220C, 16578-5M000, 17881-0H040, 17244-PLC-000, 17225-5AA-A00, 17228-59N-G00, 17228-P2J-000, 17880-0T070, 17881-22040, 17881-0D040, 17881-15160, 17881-11380, 17881-15170, 17881-15180, 17880-11350/17881-11560, 17881-0D010, 17881-0D081, 17881-33060, 17881-0D150, 17881-74450, 17225-RZP-G00, 13881-65J00, 17881-0L051, 17881-67040, 17881-54820, 1505A781, ZJ01-13-221A, 16578-EB70B, 16578-BC20C, 16578-VK50A, 16578-AU00A, 16576-JD00A/UNI-04-1028, 17880-0N031, 14463-4JA0A, 14460-JD51B, 14460-JG70A, 14463JD72A, 14460-BB30A, 14460-4BE2B/14460-4EB1B, 14460-HX40B/14460-4EB0B, 14460-HX40B/14460-4EB0B, 14460-4BE2B/14460-4EB1B, 13453635, 39130494, 9829832380, 9829831980, 1320224, 39108221, 8980779970, 8-98078176-0, 01473-S04-000, UNI-13585, 898019761-1, 898019762-1, 8-980791050, MR527979, UNI-GIH-001, UNI-GIH-002, 12180-21010, UNI-KRFKTR-001, UNI-KRFKTR-002, 71504-TBA-A00-FC, 71509-TBA-A00-FC, 67871-12380, 67872-12380, 67861-12820, 67862-12780, 68610-02180, 898103030/5, 35400-S5A-013, UNI-19132, 84231-0D030, 37670-58J10, 93560-3B100, 8608A220, MB698713, 25360-41L00, 25360-KA60A, 83120-1E001, 83110-1E001, 82110-1E001, 62311-02020, 69210-12170, 69220-12170, 69230-12110, 69240-12110, 82660-29002, 82650-29002, 74141-TR0-A00, 74141-TET-H00, 53341-02060/53341-02050, 53341-12260, 53341-02280, 74141-SWW-G00, 65840-BR00A, 60120-TR0-000, 60170-TR0-000, 75120-S5A-003, 75120-S5A-031, 51410-02190, 75832-4BE0A, 8-98036594-0, 90310-T0008, 90311-T0084, MN110724, 43232-EB70B, 40227-EA000, 40232-33P00/19018090B, 91205-PL3-A01, 90311-T0065, MB393883, 38189-N3112, 91213-PE1-722, 23682-30020, 91212-PLC-003, 91212-RNA-A01, 91212-P7A-004, MN128731T, 1052B393, 1052B382, 12279-AD200, MB919210, MD731708, 33142-4JA1A, 82201-85500, 82202-85500, UNI-02-1185/74120-TR0-A0, 53510-02830, 65601-JD000, 83408-S5A-010ZA, 84450-35090, 30542-02N10, MD348238, 1035B313, MB421498, MB421497, 92501-25000, 92501-22010, 92501-1E000, 81270-0D120, 92502-4X000, 92501-4X000, 92501-2L100, 26510-1HA0A, 26510-ZP50A, 26510-8990A/26510-JD00A, 92501-4A000, 23300-0L010, 1770A163/1770A229, UNI-16005, UNI-02462, 65601-JX31A, 79710-S5D-A02, 87240-12260, 292400-0360/A6860-VM09A, UNI-TY-050, UNI-PÇK-040, UNI-TY-046, 7104.L2, 75450-TR0-A00, 75450-TRN-H01, 7403A314, 71129-T1W-A01, 9676957880, 9816049280, UNI-PJR-703, UNI-PJR-046, 13419813, 13300945-A, 87310-0U100, 90810-JE20B/UNI-04-1032, 87310-4A010, 34101-S5A-A01, 34100-TEA-T11, 16711-0D060, 7403A344, 0K70C-51-270, UNI-RFKTR-017, UNI-RFKTR-003, UNI-RFKTR-004, 81570-0K080-BYZ, 8334A059, UNI-RFKTR-1001, 26590-JD000, 52164-F4060, UNI-RFKTR-002, UNI-RFKTR-001, 33505-SEA-013, 33555-SEA-013, UNI-RFKTR-021, UNI-RFKTR-022, UNI-RFKTR-026, UNI-RFKTR-025, UNI-01-1166, UNI-01-1165, 92406-A2000, 92405-A2000, 81910-F4020, 81920-F4020, 33505-T31-H01, 33555-T31-H01, UNI-02-1144, UNI-02-1143, UNI-02-1146, UNI-02-1145, 33505-SWA-J01, 33555-SWA-J01, 92406-AA000, 92405-AA000, 92406-3X200, 92405-3X200, 92406-F2510, 92405-F2510, 35950-65J01, 35970-65J01, 92406-B4100, 92405-B4100, 92406-C8700, 92405-C8700, 26560-5C000, 26565-5C000, 26580-ED50A, BN8P-51-5M0C, BN8P-51-5L0C, BBP2-51-5L0A/BFF4-51-5L0, BBP2-51-5M0A/BFF4-51-5M0, UNI-RFKTR-011, GJ6A-51-5M0B, GJ6A-51-5L0A, 92406-1Y000, 92405-1Y000, 92405-G6000, 92406-G6000, 26560-JE20A RH, 26561-JE20A LH, 26580-JE20A, 26560-JJ90A, 26565-JJ90A, 92406-1W700, 92405-1W700, 92406-H9100, 92405-H9100, 92480-3E050XX, 92470-3E050, 92406-3U300, 92405-3U300, 92406-D9200, 92405-D9200, 92401-4A100, 27150-3S810, 92202-1G000, 92201-1G000, 92202-1G600, 92201-1G600, 92202-1W200, 92201-1W200, 8.97387990.151, 8.97387989.151, 8.980521191, 8.980521201, 8980476610, 8980476610, 39680-TEX-Y111, 39680-TEX-Y412, 39680-TLA-Y011, 39680-SHJ-A61, UNI-19475, 8200074008, 1005A327, 11056-43G00, 92303-3K000, B6170-59G00, B6175-59G00, B455-51-060A, B455-51-070A, B455-51-060A, B455-51-070A, B21H-51-06XB, B21H-51-070B, B25D-51-060D, B25D-51-070D, 216-1540/05-1522-RH, 216-1540/05-1522-LH, 05-1510-RH, 05-1510-LH, 92302-22010, 92301-22010, 92302-22300, 92301-22310, 34301-SM4-G01, 34351-SM4-G01, 26130-BM415, 26135-BM415, 81510-05020-RH, 81520-05020-LH, 81510-05030-RH, 81521-05030-LH, 87624-1R000, 87614-1R000, UNI-SINY-02-RH, UNI-SINY-01-LH, UNI-SINY-011, UNI-SINY-012, 87624-1M000, 87614-1M000, 87624-A7000, 34300-SNB-013, 34350-SNB-013, 34300-TM0-T01, 34350-TM0-T01, JD-B031-RH, JD-B031-LH, 81730-12150, 81740-12150, 81730-52100 RH, 81740-52050 LH, UNI-SINY-014, UNI-SINY-013, JBL001-RH, JBL001-LH, 87624-3X000, 87614-3X000, 87624-F2000, 87614-F2000, JD-56-RH, JD-56-LH, 87624-B9000, 87614-B9000, 87624-C8000, 87614-C8000, 87614-2L600, 87613-2L600, 87624-2S200, 87614-2S200, 34300-SAA-013, 34350-SAA-013, 34300-TG5-H01/JBL005-RH, 34350-TG5-H01/JBL005-LH, 96303-5KS0A, 96304-5KS0A, 26160-4BA0A-BEYAZ, 26160-4BA0A-SIYAH, 26165-4BA0A-BEYAZ, 26165-4BA0A-SIYAH, 87624-1W000, 87614-1W000, 87623-2P000, 87613-2P000, 87624-3W100, 87614-3W100, 87624-F1000, 87614-F1000, UNI-SINY-017, UNI-SINY-016, UH71-51-060, UH71-51-070, 216-1550-RH, 216-1550-LH, 0K60C-51-060B, 0K60C-51-070B, MB302245, MB302244, MC139767, MC139766, MB952158, MB952157, 34300-SH3-G04, 34500-SH3-G04, 33300-SR3-000, 33350-SR3-000, 81619-12530, 81620-12530, 81610-12580, 81620-12580, 81620-12390, 81610-12390, 81510-80053, 81520-80054, 81510-20660, 81520-20650, 81610-20530, 81620-20530, B01W-51-120, 92303-22020-T, 92303-25000-T, 92304-1E000, 92303-1E000, 92304-1R000/92302-1J000, 92303-1R000/92301-1J000, 81731-05020, 81741-05010, MR911199, 92304-1M000, 92303-1M000, 34300-TET-H01, 34350-TET-H01, 33851-S2H-G01, 34300-SL4-003, MR957363, 81730-12240, 8-97237378, 92304-2D110, 36410-63J00, 92304-4H000, 92303-4H000, 92304-1Y000, 92303-1Y000, 92304-C7000, 92303-C7000, 92303-3L100, 26160-89900, UNI-SÇK-003, 8351A003, MR991187, 8351A039, GJ6A-51-120C, 26160-AX001, 26160-61Y10, 26160-70N00, 26160-AU300, 26160-9F000, 0K34C-51-120, 0K33C-51-120, 92304-3B100, 36410-60A00-RH, 36430-60A00-LH, 81730-0D011/81730-0D010, 81740-0D011/81740-0D010, 05-1202-RH, 05-1202-LH, 92303-24320, 92301-24320, MR109212, MR109211, MK581220/MK580528, MK581219/MK580527, MK427118, MK427117, MK353664, MK353663, 92302-43300, 92301-43300, 92302-43810-RH, 92301-43810-LH, 81510-95J16, 81520-95J16, 212-1539-6-RH, 212-1539-6-LH, 212-1539-RH, 212-1539-LH, 81511-35290, 81521-35280, 212-15C3-AE6-RH, 212-15C3-AE6-LH, 212-15C3-AE1-RH, 212-15C3-AE1-LH, MC139775, MC139776, 92305-26031, 214-1508-AE1-RH, 214-1508-AE1-LH, MB527090, MB527089, MB527294, MB527293, MB907018, MB907017, 8980108830, 8980108840, 8975851722, 8975851732, B6170-21G01, B6175-21G01, 02-1019-RH, 02-1019-LH, 26100-2S425-RH, 26115-3S225-LH, 0K72A-51-060D, 0K76B-51-070D, 215-1582-RH, 215-1582-LH, 92302-4A500-RH, 92301-4A500-LH, B6120-50Y00, B6125-50Y00, 36115-60B20, 36135-60B20, 33300-SM4-G01, 33350-SM4-G01, 33300-SM4-A04, 33350-SM4-A04, 35601-78020/35602-78020, 33350-SH4-013, 81510-12670-RH, 81520-12520-LH, 81510-20650, 81520-20640, 81510-89133, 81520-89133, 214-1625-RH, 214-1625-LH, MR109134, MR109133, MB831288, MB831287, MR496654, MR496653, 897173535-0, 897173536-0, 897910032-1, 897910033-1, 26124-0C800, 26129-0C800, 26910-BV80A/NS-966, 26915-BV80A/NS-966, 26910-JD01A, 26915-JD01A, 26910-BR00A, 26915-BR00A, NS-736-RH, 1400410, 1400409, 13241991, 9830218180-RH, 9830218180-LH, 6400C042ZZ/6400B642, 6400C041ZZ/6400B641, B25G-51-680C, B25G-51-690C, 92202-22310, 92201-22310, 92202-22300, 92201-22300, 92202-25000, 92201-25000, 92405-25500, 92202-25710, 92201-25710, 92202-1E000-RH, 92201-1E000-LH, 92202-1R000-T, 92201-1R000-T, UNI-12323, UNI-14082, 26150-4M426, 26159-4M426, TY-519/81210-05040-RH, TY-519/81220-05040-LH, 81210-05050, 81220-05050, 81210-05060, 81220-05060, OK6B-52-500, 0K6B6-52-500, 92202-4E001, 92201-4E001, 92202-4E500, 92201-4E500, MC139759, MC139758, UNI-GHG-008, UNI-GHG-007, 92202-A2000, 92201-A2000, 92202-2F010, 92201-2F010, 92202-2F100, 92201-2F100, 92202-1M400, 92201-1M400, 92202-1M010, 92201-1M010, 92202-A7500, 92201-A7500, HD-051-RH, HD-051-LH, HD-050-RH, UNI-15445, HD-042-RH, HD-042-LH, UNI-02-3356, HD-273-RH, HD-273-LH, UNI-14842, UNI-14829, UNI-14080, UNI-14079, UNI-01615, UNI-01614, 33900-T24-T01, 33950-T24-T01, HD-045-RH, HD-045-LH, HD-043-RH, UNI-07231, HD-038-RH, HD-038-LH, 81210-12100, 81220-12150, 81210-02051, 81220-02051, 81211-12150, 81221-12160, 212-2048R-A, 212-2048L-A, TY-007-SIS-RH, TY-007-SIS-LH, TY-482-RH, TY-482-LH, UNI-LSIS-019, UNI-LSIS-018, 33901-S9A-003, 33951-S9A-003, 33901-SPA-H02, 33951-SPA-H02, 33901-SWA-H01, 33951-SWA-H01, 34550-T0A-H01, 34500-T0A-H01, 33505-T1W-A01, 33555-T1W-A01, 34401-S10-G01, 34751-S10-G10, 8-97237590-1, 8 97237589-1, 8-97374665-2, 8981862170, 8981862180, 92202-3X010, 92201-3X010, 92202-3X200, 92201-3X220, 92208-F2010, 92207-F2010, 92202-F2000, 92201-F2000, 92302-F2500, 92301-F2500, 92405-1C005, 92202-1C000, 92201-1C000, 92405-1C500, 92202-1C510, 92201-1C510, 92202-4H000, 92201-4H000, 92202-43800, 92201-43800, 92202-4F030, 92201-4F030, 92202-4F500, 92201-4F500, TY-019-RH, TY-019-LH, TY-018-RH, TY-018-LH, TY-341-RH, TY-341-LH, 92202-B4000, 92201-B4000, 92202-1J510, 92201-1J510, 92202-C8000, 92201-C8000, 92202-C8100, 92201-C8100, 92202-C8800, 92201-C8800, 92208-C8700, 92207-C8700, 92202-2L000, 92201-2L000, 92202-A6000, 92201-A6000, 92406-2Y300, 92405-2Y300, UNI-06838, UNI-GHG-009, HD-302-RH/33901-SAA-H11Z, HD-302-LH/33951-SAA-H11Z, HD-054-RH, HD-054-LH, 92202-4B000/92201-4B000, MS-083-RH, MS-083-LH, MS-085-RH, MS-085-LH, 8315A060, 8315A059, MN186328, MN161677, UNI-15406, MS-237-LH, 8321A108, 8321A107, BN8V-51-690, BN8V-51-680, UNI-17786, UNI-17785, 26150-1HA0A, 26155-1HA0A, NS-068/MS-068-RH, NS-068/MS-068-LH, 26155-2F025, 26150-2F025, NS-911/NS-945-RH, NS-911/NS-945-LH, 92202-FD000, 92201-FD000, UNI-01-23003-H-RH, UNI-01-23003-H-LH, 92202-2B000, 92409-2B000, 92408-2B000, 92201-2B000, 92202-03000, 92201-03000, 92202-3W010, 92201-3W010, 92202-H3100, 92201-H3100, 92202-4A500, 92201-4A500, UNI-25960, UNI-25959, 92202-2E000, 92201-2E000, 92406-D3100, 92405-D3100, 92208-D3000, 92207-D3000, 92202-D3020, 92201-D3020, UNI-GHG-023, UNI-GHG-022, UNI-SIS-303-RH, UNI-SIS-303-LH, 92402-A7700, 92401-A7700, 92404-A7700, 92403-A7700, 33550-T00-K014M1, 33500-T00-K014M1, 92401-Q0000, 92402-Q0000, 92403-Q0000, 92404-Q0000, 26555-BV80A, 26550-BV80A, 26550-BR00A, 26555-BR00A, 8V5945092D, 8V5945091D, 8V5945095D, 8V5945094D, 8K5945096AC, 8K5945095AC, 8K5945094AC, 8K5945093AC, 8W5945092B, 8W5945091B, 8W5945094G, 8W5945093G, 8W5945092AA, 8W5945091AA, 8W5945094AA, 8W5945093AA, 8W6945092P, 8W6945091P, 4F5945096L, 4F5945095L, 4F5945096J, 4F5945095J, 4FD945094J, 4FD945093J, 4G5945096A, 4G5945095A, 92402-22010, 92401-22010, 92402-25010, 92401-25010, 92402-25510, 92401-25510, 92402-1E030, 92401-1E030, 92402-1R000, 92401-1R000, UNI-STOP-2002, UNI-STOP-2001, UNI-01-007-RH, UNI-18117, 215-19G7-RH, 215-19G7-LH, 35602-82001, 35603-82001, 2H1945096A-DUYSUZ, 2H1945095A-DUYSUZ, 8330A690, 8330A689, 92402-05510, 92401-05510, 81560-05050, 81550-05050, 81551-05090-RH, 81561-05090-LH, 81551-05140, 81561-05130, 81551-05190, 81561-05210, 81551-05250, 81561-05270, 96540269, 96540268, 96550611, 96550610, 95952067, 95952066, 96830976, 96830975, 05-1002-2-RH, 05-1002-2-LH, 216-1947-RH, 216-1947-LH, 216-1953-RH, 216-1953-LH, 05-1002-1-RH, 05-1002-1-LH, 36225-70C00, 0K70C-51-150, 0K70C-51-160, 0K60A-51-160D, 0K60A-51-150C, UNI-STOP-891-RH, UNI-STOP-890-LH, 2K1945096Q, 2K1945095Q, 2K1945096E, 2K1945095E, 81550-05030, 81560-05030, 81591-05050-RH, 81591-05050-LH, 35650-77A00, 35670-77A00, 218-1909-RH, 218-1909-LH, 3C8945208AD, 3C8945207AD, 3C8945308T, 3C8945307S, 92402-1H000, 92401-1H000, 92402-A2000, 92401-A2000, 9674809180, 9674809080, 9818810280, 9817303780, 92402-1M010, 92401-1M010, 92404-1M010, 92403-1M010, 92404-A7600, 92403-A7600, 92402-A7600, 92401-A7600, 33501-SEL-H61, 33551-SEL-H61, 34151-SEL-H61, 34156-SEL-H61, 33500-TM0-H01, 33550-TM0-H01, 33501-S04-G02, 33551-S04-G02, 33501-S5A-003, 33551-S5A-003, 34151-S5A-A01, 34156-S5A-A01, 34151-S5B-A01, 34156-S5B-A01, 33501-S5B-003, 33551-S5B-003, 34151-SM3-013, 33501-SNB-003, 33551-SNB-003, 34156-SM3-013, 34151-SNB-G51, 34156-SNB-G51, 33501-SNB-G52, 33511-SNB-G52, 117-4001-RH, 117-4001-LH, 34150-TET-H01, 34155-TET-H01, 33500-T24-T01, 33550-T24-T01, 34150-T24-T01, 34155-T24-T01, UNI-STOP-2004, UNI-STOP-2003, 81551-13350, 81561-13350, 81551-02150, 81561-02150, 81551-02300, 81561-02300, 81551-12A10, 81561-12A10, 81581-12110, 81591-12100, 81551-02560, 81561-02560, 81581-02340, 81591-02340, 81551-02790, 81561-02790, 81581-02520, 81591-02530, 81551-02D10, 81561-02D10, 81581-02C50, 81591-02C50, 81551-13350, 81561-13350, 81550-2B260, 81560-2B260, 95127056, 95127057, 33501-S9A-G00, 33551-S9A-G00, 33501-SWA-H01, 33551-SWA-H01, 33500-T1G-E52, 33550-T1G-E52, 8982222812, 8982222822, 898326843351, 898328798351, 8974882830, 8974882820, 216-1911-RH, 216-1911-LH, 216-1969-RH, 216-1969-LH, 92402-2D510, 92401-2D510, 92402-3X010, 92401-3X010, 92404-3X010, 92403-3X010, 92402-3X210, 92401-3X210, 92404-3X210, 92403-3X210, 92402-F2000, 92401-F2000, 92402-F2100, 92401-F2100, 92404-F2000, 92403-F2000, 92402-F2500, 92401-F2500, 92404-F2500, 92403-F2500, 92402-AA000, 92401-AA000, 33551-ST3-G11-B, 33501-ST3-G11-B, 33551-ST3-G11-S, 33501-ST3-G11-S, 92402-24320, 92401-24320, 92402-1C000, 92401-1C000, 92402-1C510-T, 92401-1C510-T, 1J6945112Q, 1J6945111Q, 5K0945096N, 5K0945095N, 5K0945094, 5K0945093, 5G0945208, 5G0945207, 5G0945308F, 5G0945307F, 5G0945208G, 5G0945207G, 5G0945308P, 5G0945094AG, 5G0945307P, 5G0945093AG, 5G0945096AG, 5G0945095AG, 5H0945096C, 5H0945095C, 5G0945094, 5G0945093, 5H0945096-LED, 5H0945095-LED, 5H0945094-LED, 5H0945093-LED, 36255-65D00, 36275-65D00, 92402-4H000, 92401-4H000, 92402-43300, 92401-43300, 81550-95J10, 81560-95J10, 0K73N-51-150A, 0K73N-51-160A, 212-1945-RH, 212-1945-LH, 81550-35130-RH, 81560-35130-LH, 212-19F3-RH, 212-19F3-LH, 81550-0K010, 81560-0K010, 92402-0X010, 92401-0X010, 92402-1J000, 92401-1J000, 92402-1J500, 92401-1J500, 92402-C8000, 92401-C8000, 92402-C8600, 92401-C8600, 92404-C8600, 92403-C8600, 213-1926-RH, 213-1926-LH, 8973756062, 8973746052, 8981253983, 8981254013, 8-981254023, 8-981254053, 92402-2S020, 92401-2S020, 92406-2S020, 92405-2S020, 6J4945096K, 6J4945095K, 33501-SAA-H02, 33551-SAA-H02, 33500-TG5-H01, 33550-TG5-H01, 33500-TF0-H51, 33550-TF0-H51, 33500-T5A-G01, 33550-T5A-G01, 1K5945096G, 1K5945095G, 1K5945094G, 1K5945093G, 5C6945094A, 5C6945093A, 5C6945096H, 5C6945095H, 5C6945094H, 5C6945093H, 214-1923-1-RH, 214-1923-1-LH, 214-1923-2-RH, 214-1923-2-LH, MR109128, MR109127, 03-1104-RH, 03-1104-LH, UNI-STOP-236, UNI-STOP-235, UNI-STOP-893-RH/8330A944, UNI-STOP-892-LH/8330A945, UNI-44-1201-RH, UNI-44-1200-LH, 8330B210, 8330B211, MB527316, MB527315, 8330A606, 8330A607, 5F0945208E, 5F0945207E, 5FA945208C, 5FA945207C, 92402-17000, 92401-17000, 92402-17910, 92401-17910, BN8V-51-150D, BN8V-51-160D, BN9A-51-150C, BN9A-51-160C, 26554-1HM1B, 26555-1HM0B, 26550-3HN0A, 26555-3HN0A, 215-19K6-RH, 215-19K6-LH, 215-19ACR-RD-UE, 215-19ACL-LD-UE, 5E5 945 112A, 5E5 945 111A, 3C5945096H, 3C5945095H, 3C5945094C, 3C5945093C, 3AE945096F, 3AE945095F, 3AE945208B, 3AE945207B, 3AE945308, 3AE945307, 3G5945096A, 3G5945208, 3G5945095A, 3G5945207, 3G5945094B, 3G5945308, 3G5945093B, 3G5945307, 3G5945208F, 3G5945207F, 3G5945308F, 3G5945307F, 3G5945096A, 3G5945095J, 3G5945094F, 3G5945093F, 3C8945096D, 3C8945095D, B6550-25G60, B6555-25G60, 26550-2S425-T, 26555-2S425-T, 6Q6945096G, 6Q6945095G, 6Q6945096M, 6Q6945095M, 6R0945096A, 6R0945095A, 6C0945096, 6C0945095, 2G0945096B, 2G0945095B, 2G0945096E, 2G0945095E, 2G0945094B, 2G0945093B, 0K72A-51-150, 0K72A-51-160, 26550-2F025, 26555-2F025, 215-19B4-UE-RY-RH, 215-19B4-UE-RY-LH, 26550-2F925, 26555-2F925, 26550-JD000, 26555-JD000, 26550-JD800, 26555-JD800, 26550-BR01A, 26555-BR01A, 26550-4EA5B, 26555-4EA5A, 26550-4EA0A, 26555-4EA0A, 26550-HV00A, 26555-HV00A, 26550-HV05A, 26555-HV05A, 92402-FD020, 92401-FD020, 92402-1G010, 92401-1G010, 92402-1W200, 92401-1W200, 92404-1W200, 92403-1W200, 92402-1W000, 92401-1W000, 92402-H9000, 92401-H9000, 92404-H9000, 92403-H9000, 9820555280, 9819427380, 92402-3E000, 92401-3E000, 92402-C5000, 92401-C5000, 92402-03000, 92401-03000, 92402-3W010, 92401-3W010, 92406-3W010, 92405-3W010, UNI-GHG-014, UNI-GHG-013, 92401-47000/92402-47000, 92402-4A600-T, 92401-4A600-T, 92406-4A600-T, 92405-4A600-T, 35650-62J00, 35670-62J00, 35650-73K00, 35670-73K00, 35650-79J00, 35670-79J00, 701945096, 701945095, 7E5945096, 7E5945095, 7E0945096K, 7E0945095K, UNI-TSL-051, UNI-TSL-050, UNI-TSL-053, UNI-25798, 897910303-0, 897910304-0, 897114440-0, 897114450-0, 5N0945096H, 5N0945093H, 5N0945208, 5N0945207, 5N0945308, 5N0945307, 5NA945208C, 5NA945096C, 5NA945207C, 5NA945095C, 5NA945308D, 5NA945094F, 5NA945307D, 5NA945093F, 2GA945096A, 2GA945095A, 2GA945094A, 2GA945093A, 92402-2E010, 92401-2E010, 92402-D7000, 92401-D7000, 92404-D7000, 92403-D7000, 92402-D3100, 92401-D3100, 92402-D3600, 92401-D3600, UNI-STOP-303-RH, UNI-STOP-303-LH, 218-1911-RH, 218-1911-LH, 26550-6FP0A, 26555-6FP0A, 212-19C7-RH, 212-19C7-LH, 212-19H3-RH, 212-19H3-LH, 81550-1A720-RH, 81560-1A630-LH, 2K7945208E, 2K7945207E, 28915-DF30A, 37513-SB0-961, 76840-SNB-S02, 8-980576090, UNI-DSF-001, 76815-SDA-A11, 38480-77500, 76810-TGG-E01, 85381-12280, 76810-S10-013, 85035-89115, 85381-35040, 76810-SAA-E01, 76850-SAA-004, 76810-TF0-G01, 28932-1KA0A, 8265A335, MN169829, 28930-AX600, UNI-13752, 28931-5JG0A, 28930-5JG0A, UNI-19757, 28931-AU000, 28930-2F901, 38480-61M10, 85330-02030, 90602-JD00A, 8979428760, CA100005130, 37522-EB30A, 10101-00Q1M, 10101-00Q1M-C, 8973672850, 12363-0T140, 12305-0T331, 12372-0T571, 8-973677272-0, 8-97367273-0, 8-98250592-0, 8-98075376-0, 11220-EB70C, 8972349821/8972476811, 11320-JS10A-T, 11320-JR70D, 52618-02070, 52618-02190, 52618-02010, 1401037, 85226-AX600, 85227-AX600, 71193-SEA-003, 71198-SEA-003, 71193-TVA-A01, 71198-TVA-A01, 1406548, 1406547, 52575-02091, 52576-02091, 52576-05030, 52575-05030, 52535-05020, 52536-05020, 71193-S5A-003, 71198-S5A-003, 52535-02030, 52536-02020, 52562-12130, 52563-12040, 52115-02290, 52116-02290, 52575-0F030, 52576-0F030, 8-98247-822-1, 8-98248-822-1, 898074258451, 898074259451, UNI-X-096-RH, UNI-X-096-LH, 71593-TF0-003, 71598-TF0-003, 62222-1KA0A, 62223-1KA0A, 85228-1KA0A, 85229-1KA0A, 62222-BV80A, 62223-BV80A, MN146320T, MN146319T, 6410C544, 6410C543, 85220-1HA0A, 85221-1HA0A, 62224-1HA0A, 62226-AX000, 62225-1HA0A, 62227-AX000, 62222-BR00A, 62223-BR00A, 71832-63J00, 71731-68L00, 71732-68L00, 71731-80J00, 71732-80J00, 62222-3UB0A, 62223-3UB0A, 62222-4CL0A, 62223-4CL0A, 85220-4CE0A, 85221-4CE0A, 52155-0D050, UNI-BRKT-024, UNI-BRKT-023, UNI-BRKT-022/52535-52111, UNI-BRKT-021/52536-52080, 6420A020, 6420A019, 85065-EB710, 39020290, 39020289, 13238553, UNI-18231, 1320211-B, 13387316, 13387317, 92800-1E000OR, 92800-1R0008M, 92800-2D000QS, 74880-S04-G01, 74880-SNA-A01, 8980737262, 46420-02121, 46430-02121, 46420-02140/46420-12700, 46430-02140/46430-12580, 46420-02300, 46430-02300, 89800-70070, 89800-70081, 8-97368-068-0, 8-97363-346-0, 898067048-1, 898067049-1, 46420-0K030, 46430-0K030, 46420-0K210, 46430-0K210, 36530-9F000, 74130-S5A-A01ZA, 8987333-1432-7M04, 898071760, 47510-TR0-A52, 84450-05040, 48750-1E411, 84450-0K010, MB903639, 4408A142, MB686054, MR123396, MB141845, MN113754/MR449457, 48750-2F000/48750-0M010, 37111-62JA0, 84450-71010, 55406-02060, MB620790, 2020A031, 8657A099/8657A065, 44610-1E310, 44610-3D730, 77298-SNA-D01ZA, UNI-19532, UNI-19503, UNI-11721, UNI-02532, UNI-07895, UNI-13236, 54131-SDA-Q81, 54102-TR0-A03ZB, UNI-19535, 33504-12310, 83357-24504-GRI, UNI-19533, 33504-12180, 33504-22140, UNI-06405, 54130-SAA-981, UNI-20988, UNI-24814, 32865-50Y00, 32865-JD100, UNI-18851, 11140-4M500, 15301-74010, 15650-PLM-004, 15650-PWA-000, 15301-33020, UNI-03449, 15301-22050, 15301-37010, 16910-69G01, 16910-77E02, 15301-30070, 15301-54080, UNI-17982, 1255A068, 11140-EB300, 11140-VK50A, 11140-9F600, 15710-33030, UNI-YS-002, 15301-47050, 8972548551, 8972548541, 8972548531, 44201-EB360/44200-EB70A, 8-97941501-3, 19101-RSA-G00, 16480-0N010, 21710-1KK0A';

    ;WITH SPLITLIST AS
    (
        SELECT LTRIM(RTRIM(Split.a.value('.', 'nvarchar(200)'))) AS PRODUCTCODE
        FROM (
                SELECT CAST('<X>' +
                    REPLACE(@LIST, ',', '</X><X>') + '</X>' AS XML) AS DATA
             ) A
        CROSS APPLY DATA.nodes('/X') AS Split(a)
    ),

    MATCHED AS
    (
        SELECT
            S.PRODUCTCODE,

            -- 1?? PRODUCERCODE LIKE ARAMA
            (
                SELECT TOP 1 I.CODE
                FROM LG_011_ITEMS I
                WHERE I.PRODUCERCODE COLLATE Turkish_CI_AI
                      LIKE '%' + S.PRODUCTCODE COLLATE Turkish_CI_AI + '%'
            ) AS CODE_FROM_PRODUCER,

            -- 2?? CODE = KOD ARAMA
            (
                SELECT TOP 1 I.CODE
                FROM LG_011_ITEMS I
                WHERE I.CODE COLLATE Turkish_CI_AI =
                      S.PRODUCTCODE COLLATE Turkish_CI_AI
            ) AS CODE_FROM_CODE
        FROM SPLITLIST S
    )

    SELECT
        PRODUCTCODE AS LISTE_KODU,
        COALESCE(CODE_FROM_PRODUCER, CODE_FROM_CODE, '') AS ITEM_CODE
    FROM MATCHED
    ORDER BY PRODUCTCODE;
END