CREATE   PROCEDURE SP_GET_MATCHED_ITEMS
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-RH
UNI-X-170A-LH
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/17-5185-00
UNI-02-1143/17-5186-00
UNI-02-1146/33555-SWA-00
UNI-02-1145/33505-SWA-00
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 CODELIST AS
    (
        SELECT LTRIM(RTRIM(Split.a.value('.', 'nvarchar(200)'))) AS PRODUCTCODE
        FROM (
              SELECT CAST('<X>' + 
                  REPLACE(@LIST, CHAR(10), '</X><X>') +'</X>' AS XML) AS DATA
             ) AS A
        CROSS APPLY DATA.nodes('/X') AS Split(a)
    )

    SELECT 
        C.PRODUCTCODE AS LISTE_KODU,
        ISNULL(I.CODE, '') AS ITEM_CODE,   -- << BOS GETIRIR
        I.PRODUCERCODE
    FROM CODELIST C
    LEFT JOIN LG_011_ITEMS I
        ON I.PRODUCERCODE LIKE '%' + C.PRODUCTCODE + '%'
    ORDER BY LISTE_KODU;
END