SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps_sub.id AS id
FROM (
    
    VALUES 
        ('BSG65700033',4455), ('1242700100',268), ('915329',85), ('PK064',4752), ('PPK10307',4558), ('19372029',6307), ('19372032',6307), ('19372095',6307), ('19374355',6307), ('19374356',6307), ('19374360',6307), ('19374361',6307), ('A380446',4364), ('MLS6696030',4400), ('MLS6696032',4400), ('52013',6558), ('52036',6558), ('52593',6558), ('52625',6558), ('56267',6558), ('102223',96), ('103223',96), ('103583',96), ('103613',96), ('105650',96), ('109310',96), ('200083',96), ('200100',96), ('200103',96), ('200110',96), ('200113',96), ('200350',96), ('200513',96), ('202163',96), ('204593',96), ('209773',96), ('300203',96), ('300223',96), ('300230',96), ('300233',96), ('300243',96), ('300473',96), ('300834',96), ('300835',96), ('300864',96), ('300865',96), ('300884',96), ('300885',96), ('301033',96), ('301173',96), ('301430',96), ('301440',96), ('301483',96), ('301554',96), ('301555',96), ('301734',96), ('301735',96), ('301914',96), ('301924',96), ('302304',96), ('302394',96), ('302395',96), ('302544',96), ('302545',96), ('302844',96), ('302875',96), ('303673',96), ('303734',96), ('303735',96), ('303754',96), ('303755',96), ('306714',96), ('306715',96), ('306724',96), ('306725',96), ('306744',96), ('306745',96), ('306864',96), ('306865',96), ('308523',96), ('400023',96), ('400863',96), ('400893',96), ('400903',96), ('400913',96), ('405940',96), ('405943',96), ('407923',96), ('407943',96), ('408180',96), ('810017',96), ('810082',96), ('810084',96), ('X041335',4975), ('X283344',4975), ('X284344',4975), ('X290343',4975), ('X308343',4975), ('X379333',4975), ('X380333',4975), ('X383333',4975), ('X384333',4975), ('X459343',4975), ('X709333',4975), ('X710333',4975), ('X759339',4975), ('X840334',4975), ('X841334',4975), ('34968',4576), ('34969',4576), ('34977',4576), ('34978',4576), ('70431',4576), ('70460',4576), ('70462',4576), ('70474',4576), ('70885',4576), ('70891',4576), ('70907',4576), ('70938',4576), ('71465',4576), ('71466',4576), ('71498',4576), ('75731',4576), ('75794',4576), ('75797',4576), ('75834',4576), ('MA00087',257), ('MA00088',257), ('MA00138',257), ('MA00139',257), ('MA00178',257), ('MA00200',257), ('MA00213',257), ('MA00215',257), ('MA00230',257), ('MA00231',257), ('MA00234',257), ('MA00235',257), ('MA00237',257), ('MA00239',257), ('MA00241',257), ('MA00242',257), ('MA00244',257), ('MA00246',257), ('MA00247',257), ('MA00250',257), ('MA00252',257), ('MA00254',257), ('MA00262',257), ('MA00265',257), ('MA00326',257), ('MA00329',257), ('MA00336',257), ('MA00341',257), ('MA00344',257), ('MA00345',257), ('MA00346',257), ('MA00351',257), ('MA00398',257), ('MA00406',257), ('MA00535',257), ('MA00538',257), ('MA00539',257), ('MA00565',257), ('MA00566',257), ('MA00670',257), ('MA00679',257), ('MA00748',257), ('MA00790',257), ('MA00924',257), ('MA00925',257), ('MA10056',257), ('MA10058',257), ('MA10060',257), ('MA10067',257), ('MA10070',257), ('MA10071',257), ('MA15532',257), ('MA15534',257), ('MA20007',257), ('MA20008',257), ('MA20009',257), ('MA20010',257), ('MA20011',257), ('MA20012',257), ('MA20015',257), ('MA20018',257), ('MA20019',257), ('MA20021',257), ('MA20026',257), ('MA20027',257), ('MA20061',257), ('MA20062',257), ('MA20063',257), ('MA20064',257), ('MA20091',257), ('MA22013',257), ('MA22014',257), ('MA22015',257), ('MA22030',257), ('MA22041',257), ('MA22042',257), ('MA22045',257), ('MA22052',257), ('MA22057',257), ('MA22058',257), ('MA22102',257), ('MA22103',257), ('MA22104',257), ('MA22105',257), ('MA22128',257), ('MA33021',257), ('MA33042',257), ('MA33043',257), ('MA33044',257), ('MA33045',257), ('MA33049',257), ('MA33050',257), ('MA40036',257), ('MA40037',257), ('MA50058',257), ('MA50063',257), ('MA50064',257), ('MA50080',257), ('MA50081',257), ('MA53425',257), ('MA70000',257), ('MA70001',257), ('MA70002',257), ('MA70003',257), ('MA70022',257), ('MA70027',257), ('MA70028',257), ('MA70030',257), ('MA70032',257), ('MA70040',257), ('MA70041',257), ('MA80001',257), ('MA80003',257), ('MA90027',257), ('MAHY044',257), ('MAHY052',257), ('MAW0004',257), ('PAL90003',442), ('PAL90016',442), ('PAL90033',442), ('PAL90034',442), ('PAL90050',442), ('93451',4495), ('D5103',351), ('D5152',351), ('110007110',323), ('110011910',323), ('110012410',323), ('110012510',323), ('110012710',323), ('110071510',323), ('110097510',323), ('110149010',323), ('110168710',323), ('110170910',323), ('110180710',323), ('110180810',323), ('PSG2021',4337), ('PSG2371',4337), ('PSG2372',4337), ('PSG2515',4337), ('PSG2571',4337), ('PSG2581',4337), ('PSG4003',4337), ('PSG4004',4337), ('PSG4046',4337), ('PSG4088',4337), ('PSG4348',4337), ('PSG4659',4337), ('PSG5212',4337), ('PSG8029',4337), ('PSG8078',4337), ('PSG8194',4337), ('PSG8240',4337), ('PSG8280',4337), ('PSG8346',4337), ('PSG8347',4337), ('PSG8387',4337), ('PSG8466',4337), ('PSG8468',4337), ('PSH0929',4337), ('PSH2371',4337), ('PSH2372',4337), ('PSH4004',4337), ('PSH4046',4337), ('PSH4088',4337), ('PSH8078',4337), ('PSH8194',4337), ('PSH8466',4337), ('PSH8468',4337), ('0011022659',4995), ('0011022660',4995), ('043641B',49), ('060255GB',49), ('060275GB',49), ('060446HB',49), ('060463HB',49), ('060470HB',49), ('060477GB',49), ('060479GB',49), ('060515HB',49), ('060546GB',49), ('060559GB',49), ('060628GB',49), ('060629GB',49), ('060648GB',49), ('060650GB',49), ('060650HB',49), ('060651GB',49), ('060683GB',49), ('060735GLB',49), ('060745GLB',49), ('060745GRB',49), ('060813HB',49), ('060831GLB',49), ('060831GRB',49), ('060853GLB',49), ('060853GRB',49), ('060872GLB',49), ('060872GRB',49), ('060886GRB',49), ('060889GRB',49), ('060951GLB',49), ('060951GRB',49), ('060997GB',49), ('061104GLB',49), ('061104GRB',49), ('061108GLB',49), ('061108GRB',49), ('061116GLB',49), ('061116GRB',49), ('061118GLB',49), ('061118GRB',49), ('061123GLB',49), ('061123GRB',49), ('061126GLB',49), ('061126GRB',49), ('061148GLB',49), ('061148GRB',49), ('061160GLB',49), ('061217GLB',49), ('061217GRB',49), ('061369GB',49), ('061372GB',49), ('061413GLB',49), ('061413GRB',49), ('061442GLB',49), ('061442GRB',49), ('061524GB',49), ('061549GB',49), ('061591GB',49), ('061607GB',49), ('061638GB',49), ('061639HB',49), ('061677B',49), ('062066GB',49), ('062066HB',49), ('062166GLB',49), ('062166GRB',49), ('062176GLB',49), ('062176GRB',49), ('062196GLB',49), ('062196GRB',49), ('062228GLB',49), ('062228GRB',49), ('062232GLB',49), ('062232GRB',49), ('062255GLB',49), ('062255GRB',49), ('062261GLB',49), ('062261GRB',49), ('062312GLB',49), ('062312GRB',49), ('062599GLB',49), ('062599GRB',49), ('062781GLB',49), ('17047166',16), ('19028514',16), ('19028521',16), ('19028743',16), ('19028835',16), ('19063553',16), ('19063577',16), ('19063584',16), ('19065663',16), ('19146980',16), ('19158495',16), ('19228945',16), ('21030246',16), ('21030536',16), ('21030543',16), ('21031137',16), ('21031144',16), ('21031199',16), ('21031434',16), ('22041234',16), ('22045584',16), ('22045607',16), ('22045621',16), ('22045768',16), ('22046864',16), ('22046871',16), ('22049056',16), ('22049063',16), ('22049254',16), ('22049261',16), ('22049278',16), ('22049285',16), ('22049292',16), ('22049308',16), ('22049315',16), ('22049322',16), ('22049339',16), ('22049346',16), ('22049407',16), ('22049414',16), ('22049483',16), ('22049490',16), ('22049506',16), ('22049513',16), ('22049520',16), ('22049537',16), ('22049568',16), ('22049575',16), ('22049582',16), ('22049599',16), ('22049629',16), ('22049636',16), ('22059543',16), ('22059550',16), ('22111760',16), ('22111777',16), ('22112811',16), ('22112880',16), ('22135971',16), ('22139924',16), ('22151100',16), ('22165978',16), ('22165985',16), ('22169976',16), ('22169983',16), ('22217134',16), ('22217141',16), ('22227096',16), ('22227102',16), ('22227812',16), ('22227829',16), ('22228116',16), ('22228123',16), ('24019118',16), ('24024518',16), ('24214230',16), ('34002926',16), ('34003688',16), ('34030219',16), ('34030226',16), ('34031483',16), ('34100608',16), ('35043959',16), ('35110736',16), ('35110743',16), ('50252',208), ('53581',208), ('274429',14), ('275900',14), ('27A84A',14), ('27D24A',14), ('27D25A',14), ('27D30A',14), ('27D31A',14), ('27F69A',14), ('27F70A',14), ('27K26A',14), ('28B46A',14), ('28B47A',14), ('28B76A',14), ('28B77A',14), ('28C02A',14), ('28C03A',14), ('30024A',14), ('30025A',14), ('30027A',14), ('30A43A',14), ('30C14A',14), ('30C19A',14), ('30C20A',14), ('30C630',14), ('30C680',14), ('30F69A',14), ('30F71A',14), ('30F76A',14), ('30G68A',14), ('30K75A',14), ('30K77A',14), ('321351',14), ('328701',14), ('328910',14), ('329860',14), ('32A41A',14), ('32A740',14), ('32A840',14), ('32A84F',14), ('32A850',14), ('32A85F',14), ('32A86F',14), ('32B03A',14), ('32B04A',14), ('32B10A',14), ('32B11A',14), ('32B48F',14), ('32B65F',14), ('32C07F',14), ('32C08F',14), ('32C260',14), ('32C270',14), ('32C58A',14), ('32C59A',14), ('32C70A',14), ('32C71A',14), ('32C78A',14), ('32C79A',14), ('32D12A',14), ('32D13A',14), ('32D34A',14), ('32D65A',14), ('32D66A',14), ('32D99F',14), ('32E02A',14), ('32E03A',14), ('32E42A',14), ('32E43A',14), ('32E57A',14), ('32E58A',14), ('32E63A',14), ('32F48A',14), ('32F68A',14), ('32F69A',14), ('32G56A',14), ('32G57A',14), ('32G60A',14), ('32G61A',14), ('32G67A',14), ('32G76A',14), ('32G77A',14), ('32G910',14), ('32G920',14), ('32G930',14), ('32G940',14), ('32H100',14), ('32H47A',14), ('32J10A',14), ('32J11A',14), ('32J920',14), ('32J930',14), ('32J94A',14), ('32L91A',14), ('32L92A',14), ('32L93A',14), ('32L94A',14), ('32M17A',14), ('32M18A',14), ('32M28A',14), ('32M29A',14), ('32M66A',14), ('32M67A',14), ('32M83F',14), ('32M84F',14), ('32M870',14), ('32M87F',14), ('32M95A',14), ('32M96F',14), ('32N04A',14), ('32N05A',14), ('32N50A',14), ('32N51A',14), ('32N82A',14), ('32N83A',14), ('32P05A',14), ('32P06A',14), ('32P13A',14), ('32P14A',14), ('32P15A',14), ('32P16A',14), ('32P20A',14), ('32P21A',14), ('32P32A',14), ('32P33A',14), ('32P37A',14), ('32P38A',14), ('32P82A',14), ('32P83A',14), ('32P84A',14), ('32P85A',14), ('32Q13A',14), ('32Q14A',14), ('32Q50A',14), ('32Q51A',14), ('32Q54A',14), ('32Q55A',14), ('32Q74A',14), ('32Q79A',14), ('32R09A',14), ('32R10A',14), ('32R16A',14), ('32R17A',14), ('32R39A',14), ('32U48A',14), ('32U49A',14), ('32V24A',14), ('32V25A',14), ('32V70A',14), ('32V71A',14), ('32V72A',14), ('32V73A',14), ('32V80A',14), ('32V81A',14), ('32V86A',14), ('32V87A',14), ('32W01A',14), ('32W02A',14), ('32W13A',14), ('32W14A',14), ('32Y43A',14), ('32Y44A',14), ('32Y94A',14), ('36676F',14), ('36679A',14), ('36746A',14), ('36747A',14), ('36A23F',14), ('36A24F',14), ('36A68A',14), ('36A69A',14), ('36C22A',14), ('36C23A',14), ('36C33A',14), ('36C570',14), ('36E27A',14), ('36E29A',14), ('36E30A',14), ('36E32A',14), ('36E80A',14), ('46A310',14), ('46A330',14), ('60A950',14), ('84130A',14), ('87392A',14), ('BSM5504',475), ('BSG15300027',4455), ('BSG15300028',4455), ('BSG30300003',4455), ('BSG30300005',4455), ('BSG30300032',4455), ('BSG30300033',4455), ('BSG30300035',4455), ('BSG30300038',4455), ('BSG30300043',4455), ('BSG30300044',4455), ('BSG30300055',4455), ('BSG30300056',4455), ('BSG65300015',4455), ('BSG65300016',4455), ('BSG65300017',4455), ('BSG65300020',4455), ('760599',405), ('752RE012',6411), ('752RE019',6411), ('752RE073',6411), ('752RE074',6411), ('414718',6479), ('414750',6479), ('422533',6479), ('434710',6479), ('444750',6479), ('451003L',6479), ('451003R',6479), ('451005L',6479), ('451005R',6479), ('451031L',6479), ('451031R',6479), ('452202L',6479), ('452202R',6479), ('452209L',6479), ('452209R',6479), ('452506',6479), ('452518',6479), ('452519',6479), ('452530',6479), ('452540',6479), ('452544',6479), ('452562',6479), ('452563',6479), ('452564L',6479), ('452564R',6479), ('452621L',6479), ('452621R',6479), ('453001',6479), ('453270L',6479), ('453652',6479), ('453907L',6479), ('453907R',6479), ('453908L',6479), ('453908R',6479), ('453910L',6479), ('453910R',6479), ('453923',6479), ('453924',6479), ('453940',6479), ('454553L',6479), ('454553R',6479), ('454554L',6479), ('454554R',6479), ('454810L',6479), ('454810R',6479), ('455204L',6479), ('455204R',6479), ('552520',6479), ('552531',6479), ('553602L',6479), ('553602R',6479), ('553904L',6479), ('553904R',6479), ('554510L',6479), ('554510R',6479), ('562329',6479), ('562366',6479), ('562549',6479), ('563611',6479), ('563661',6479), ('564711',6479), ('PK3630',6479), ('D2253373',89), ('D2253744',89), ('D2254106',89), ('D2255572',89), ('D2255793',89), ('D2255897',89), ('D2255968',89), ('D2257530',89), ('D2257531',89), ('D2257566',89), ('DG2591',89), ('DG5826',89), ('DG5968',89), ('DG7719',89), ('DG7720',89), ('DG7726',89), ('DG7746',89), ('DG7762',89), ('DG7763',89), ('DG7768',89), ('DG7813',89), ('DG7814',89), ('DG7889',89), ('DG7944',89), ('DG7946',89), ('DG8002',89), ('DG8019',89), ('DG8021',89), ('DG8073',89), ('DG9155',89), ('DG9351',89), ('DG9446',89), ('K01756913',89), ('K2259165',89), ('K2259166',89), ('KG10040',89), ('KG10214',89), ('KG10216',89), ('KG3866',89), ('KG4040',89), ('KG4042',89), ('KG4092',89), ('KG4102',89), ('KG4104',89), ('KG7742',89), ('KG7942',89), ('KG9187',89), ('KG9289',89), ('V00334413',89), ('V01195622',89), ('V01274822',89), ('V22560513',89), ('V22560613',89), ('V22565213',89), ('V22584213',89), ('V22584313',89), ('V22585013',89), ('V22754413',89), ('V22762113',89), ('V22762213',89), ('V64263323',89), ('V64264623',89), ('V69333523',89), ('V76557213',89), ('DSB047G',186), ('DSB048G',186), ('DSB138G',186), ('DSB199G',186), ('DSB247G',186), ('DSB248G',186), ('DSB251G',186), ('DSB256G',186), ('DSB279G',186), ('DSB305G',186), ('DSB306G',186), ('DSB307G',186), ('DSB308G',186), ('DSB323G',186), ('DSB324G',186), ('DSF114G',186), ('DSF171G',186), ('9970043',253), ('9970049',253), ('9970076',253), ('9970298L',253), ('9970298R',253), ('9970375L',253), ('9970375R',253), ('9970426',253), ('9970485',253), ('9970554L',253), ('9970554R',253), ('9971523L',253), ('9971523R',253), ('9971529L',253), ('9971529R',253), ('9971534',253), ('9971542L',253), ('9971542R',253), ('9971544L',253), ('9971544R',253), ('9971555L',253), ('9971555R',253), ('9971556L',253), ('9971556R',253), ('9971586L',253), ('SSB1942GN',4882), ('1060140052',4345), ('1060140079',4345), ('1060140080',4345), ('1060140081',4345), ('1060140086',4345), ('1060140088',4345), ('1060140099',4345), ('1060140100',4345), ('1060140116',4345), ('1060170031',4345), ('1060170032',4345), ('1060170043',4345), ('1060170057',4345), ('1060170066',4345), ('1060170074',4345), ('122343',355), ('122343SP',355), ('1260009',355), ('DSA331701',4881), ('DSA331702',4881), ('DSA331900',4881), ('DSA333107',4881), ('DSA333108',4881), ('DSA333216',4881), ('DSA333267',4881), ('DSA333379',4881), ('DSA333380',4881), ('DSA333388',4881), ('DSA333389',4881), ('DSA333390',4881), ('DSA333391',4881), ('DSA333410',4881), ('DSA333411',4881), ('DSA333417',4881), ('DSA333418',4881), ('DSA333419',4881), ('DSA333709',4881), ('DSA333710',4881), ('DSA333715',4881), ('DSA333729',4881), ('DSA333826',4881), ('DSA333909',4881), ('DSA333944',4881), ('DSA334061',4881), ('DSA334062',4881), ('DSA334063',4881), ('DSA334064',4881), ('DSA334109',4881), ('DSA334110',4881), ('DSA334172',4881), ('DSA334173',4881), ('DSA334176',4881), ('DSA334177',4881), ('DSA334188',4881), ('DSA334189',4881), ('DSA334190',4881), ('DSA334191',4881), ('DSA334192',4881), ('DSA334195',4881), ('DSA334196',4881), ('DSA334197',4881), ('DSA334198',4881), ('DSA334202',4881), ('DSA334203',4881), ('DSA334204',4881), ('DSA334233',4881), ('DSA334234',4881), ('DSA334243',4881), ('DSA334244',4881), ('DSA334251',4881), ('DSA334252',4881), ('DSA334263',4881), ('DSA334264',4881), ('DSA334269',4881), ('DSA334270',4881), ('DSA334308',4881), ('DSA334309',4881), ('DSA334319',4881), ('DSA334320',4881), ('DSA334329',4881), ('DSA334330',4881), ('DSA334331',4881), ('DSA334332',4881), ('DSA334333',4881), ('DSA334334',4881), ('DSA334335',4881), ('DSA334338',4881), ('DSA334339',4881), ('DSA334340',4881), ('DSA334341',4881), ('DSA334342',4881), ('DSA334343',4881), ('DSA334344',4881), ('DSA334345',4881), ('DSA334362',4881), ('DSA334363',4881), ('DSA334366',4881), ('DSA334367',4881), ('DSA334372',4881), ('DSA334373',4881), ('DSA334374',4881), ('DSA334386',4881), ('DSA334387',4881), ('DSA334388',4881), ('DSA334389',4881), ('DSA334394',4881), ('DSA334395',4881), ('DSA334398',4881), ('DSA334400',4881), ('DSA334405',4881), ('DSA334420',4881), ('DSA334464',4881), ('DSA334465',4881), ('DSA334478',4881), ('DSA334479',4881), ('DSA334480',4881), ('DSA334481',4881), ('DSA334812',4881), ('DSA334821',4881), ('DSA334838',4881), ('DSA334839',4881), ('DSA334903',4881), ('DSA334905',4881), ('DSA334906',4881), ('DSA334922',4881), ('DSA335020',4881), ('DSA335021',4881), ('DSA335040',4881), ('DSA335041',4881), ('DSA335803',4881), ('DSA335922',4881), ('DSA335923',4881), ('DSA339023',4881), ('DSA339024',4881), ('DSA339748',4881), ('DSA341141',4881), ('DSA341365',4881), ('DSA341846',4881), ('DSA343047',4881), ('DSA343248',4881), ('DSA343271',4881), ('DSA343290',4881), ('DSA343308',4881), ('DSA343459',4881), ('DSA344200',4881), ('DSA344254',4881), ('DSA344261',4881), ('DSA344283',4881), ('DSA344288',4881), ('DSA345900',4881), ('DSA365097',4881), ('DSA366002',4881), ('DSA366007',4881), ('DSA441905',4881), ('DSA444095',4881), ('DSA444119',4881), ('DSA444161',4881), ('DSA553307',4881), ('DSA633827',4881), ('DSA633831',4881), ('DSA634021',4881), ('DSA634022',4881), ('DSA634802',4881), ('DSA635800',4881), ('DSA665500',4881), ('DSA666001',4881), ('7324643',4135), ('7327868',4135), ('520102',4512), ('520171',4512), ('32SKV033',4969), ('32SKV034',4969), ('32SKV035',4969), ('32SKV036',4969), ('32SKV053',4969), ('32SKV057',4969), ('32SKV103',4969), ('32SKV126',4969), ('32SKV157',4969), ('19ST833',4003), ('32BJ927',4003), ('1623305480',4391), ('1623308580',4391), ('1623309080',4391), ('1623310880',4391), ('1623312380',4391), ('1623313080',4391), ('1623322480',4391), ('1623323580',4391), ('1623323680',4391), ('1623326880',4391), ('1623327280',4391), ('1623327780',4391), ('1623327880',4391), ('1623328880',4391), ('1623334880',4391), ('1623335080',4391), ('1623339780',4391), ('1623339880',4391), ('1623339980',4391), ('1623340080',4391), ('1635539480',4391), ('1635540980',4391), ('1635541380',4391), ('1635544480',4391), ('1635545080',4391), ('1635546080',4391), ('1635546580',4391), ('1635547780',4391), ('1635547880',4391), ('1635549480',4391), ('1635550780',4391), ('1648228880',4391), ('1674694880',4391), ('1674696380',4391), ('810001810',192), ('810010410',192), ('FT11011',4938), ('FT11016',4938), ('FT11017',4938), ('FT11292',4938), ('FT11316',4938), ('0107G002RR',4674), ('0107G003RL',4674), ('0107G007FR',4674), ('0107G008FL',4674), ('0107G011RL',4674), ('0107G012RR',4674), ('0207G001F',4674), ('0207G003R',4674), ('0407G002R',4674), ('0407G014F',4674), ('0507G005FR',4674), ('0507G006FL',4674), ('0507G013FL',4674), ('0507G014FR',4674), ('07665534FL',4674), ('07665535FR',4674), ('1707G002F',4674), ('1707S001F',4674), ('1807G011F',4674), ('1807G016R',4674), ('1907G002F',4674), ('1907G011F',4674), ('2107G002R',4674), ('2107G003FR',4674), ('2107G004FR',4674), ('2107G007F',4674), ('2107G008F',4674), ('2107G009R',4674), ('2107G013R',4674), ('21665158FL',4674), ('21665159FR',4674), ('2207G003R',4674), ('2307G002R',4674), ('2307G006F',4674), ('2307G019F',4674), ('2307S003F',4674), ('2307S008F',4674), ('2307S011F',4674), ('2307S013F',4674), ('2407G012F',4674), ('2407G015F',4674), ('2407S006F',4674), ('2407S011F',4674), ('2807G001R',4674), ('HAB154',4674), ('MAB158',4674), ('NABR50R',4674), ('171220',101), ('17287',101), ('A21111',271), ('A22062',271), ('A31002',271), ('A41003',271), ('A51038',271), ('A51054',271), ('A61024',271), ('A61084',271), ('A61085',271), ('A61198',271), ('A61199',271), ('A61208',271), ('A61209',271), ('A61213',271), ('A61230',271), ('A61231',271), ('A61265',271), ('A61278',271), ('A61279',271), ('A62001',271), ('A62003',271), ('A62054',271), ('A62055',271), ('FSA172',4838), ('FSA174',4838), ('13045GR',4741), ('13046GL',4741), ('13085GR',4741), ('13086GL',4741), ('13113GR',4741), ('13114GL',4741), ('23039GU',4741), ('25016GU',4741), ('FSM5504',407), ('F210G0430',441), ('F210G0435',441), ('F210G0474',441), ('F210G1103',441), ('F210G1104',441), ('F210G1109',441), ('F210G1110',441), ('F210G1114',441), ('F220G0163',441), ('F220G0917',441), ('F220G0919',441), ('F220G0968',441), ('F220G1028',441), ('F220G1101',441), ('F220G1102',441), ('35116',4639), ('35117',4639), ('35282',4639), ('44924',4639), ('44931',4639), ('44941',4639), ('69020',4639), ('69422',4639), ('69465',4639), ('69856',4639), ('83454',4639), ('G35056',4639), ('G35057',4639), ('G35070',4639), ('G35110',4639), ('G35112',4639), ('G35264',4639), ('G35269',4639), ('G35281',4639), ('G35343',4639), ('G35344',4639), ('G35357',4639), ('G35358',4639), ('G35368',4639), ('G35397',4639), ('G35437',4639), ('G35438',4639), ('G35457',4639), ('G35458',4639), ('G37833',4639), ('G37834',4639), ('G44477',4639), ('G44497',4639), ('G44498',4639), ('G44941',4639), ('G44972',4639), ('G44979',4639), ('G44991',4639), ('G54019',4639), ('G54044',4639), ('G54338',4639), ('G54339',4639), ('G54363',4639), ('G54364',4639), ('G55606',4639), ('G55652',4639), ('G55653',4639), ('G55672',4639), ('G55912',4639), ('G55913',4639), ('G55929',4639), ('G55930',4639), ('G63620',4639), ('G63670',4639), ('G63781',4639), ('G63823',4639), ('G63904',4639), ('G71048',4639), ('GK402',4639), ('GP127',4639), ('7170016',4395), ('7170032',4395), ('7170039',4395), ('7170040',4395), ('7170045',4395), ('8130088',4395), ('8130191',4395), ('8130200',4395), ('8130214',4395), ('8130337',4395), ('8130343',4395), ('8130402',4395), ('8130747',4395), ('8130757',4395), ('8130860',4395), ('8131482',4395), ('8150018',4395), ('8150043',4395), ('8150060',4395), ('8150085',4395), ('8150086',4395), ('8150347',4395), ('8150385',4395), ('8150542',4395), ('8150942',4395), ('8250639',4395), ('8250640',4395), ('8250831',4395), ('8250832',4395), ('8250833',4395), ('8250834',4395), ('8260043',4395), ('8260044',4395), ('8260057',4395), ('8260058',4395), ('8260073',4395), ('8260074',4395), ('8260085',4395), ('8260086',4395), ('8260091',4395), ('8260092',4395), ('8260103',4395), ('8260119',4395), ('8260120',4395), ('8260135',4395), ('8260136',4395), ('8260139',4395), ('8260140',4395), ('8260149',4395), ('8260150',4395), ('8260155',4395), ('8260156',4395), ('8260167',4395), ('8260168',4395), ('8260181',4395), ('8260182',4395), ('8260215',4395), ('8260216',4395), ('8260245',4395), ('8260246',4395), ('8260253',4395), ('8260255',4395), ('8260305',4395), ('8260379',4395), ('8260380',4395), ('8260383',4395), ('8260384',4395), ('8260385',4395), ('8260386',4395), ('8260435',4395), ('8260436',4395), ('8260447',4395), ('8260448',4395), ('8260459',4395), ('8260460',4395), ('8260461',4395), ('8260462',4395), ('8260631',4395), ('8260632',4395), ('8260741',4395), ('8260742',4395), ('8260763',4395), ('8260764',4395), ('8260765',4395), ('8260766',4395), ('8260819',4395), ('8260841',4395), ('8260842',4395), ('8260897',4395), ('8260898',4395), ('8260987',4395), ('8260988',4395), ('8261097',4395), ('8261131',4395), ('8261132',4395), ('8261219',4395), ('8261220',4395), ('8261329',4395), ('8261791',4395), ('8261792',4395), ('8262205',4395), ('8262206',4395), ('8262765',4395), ('8262766',4395), ('8270007',4395), ('8270199',4395), ('8350030',4395), ('8350055',4395), ('8350120',4395), ('8360033',4395), ('8370002',4395), ('8370008',4395), ('9130088',4395), ('9130191',4395), ('9130200',4395), ('9130214',4395), ('9130337',4395), ('9130343',4395), ('9130402',4395), ('9130418',4395), ('9130747',4395), ('9130757',4395), ('9130860',4395), ('9130881',4395), ('9130895',4395), ('9131482',4395), ('9150013',4395), ('9150018',4395), ('9150043',4395), ('9150060',4395), ('9150085',4395), ('9150086',4395), ('9150347',4395), ('9150385',4395), ('9150523',4395), ('9150542',4395), ('9150725',4395), ('9150752',4395), ('9150942',4395), ('9151152',4395), ('9160016',4395), ('9160224',4395), ('9160226',4395), ('9160366',4395), ('9160389',4395), ('9250639',4395), ('9250640',4395), ('9250831',4395), ('9250832',4395), ('9250833',4395), ('9250834',4395), ('9260043',4395), ('9260044',4395), ('9260057',4395), ('9260058',4395), ('9260073',4395), ('9260074',4395), ('9260081',4395), ('9260085',4395), ('9260086',4395), ('9260091',4395), ('9260092',4395), ('9260097',4395), ('9260098',4395), ('9260099',4395), ('9260100',4395), ('9260103',4395), ('9260119',4395), ('9260120',4395), ('9260135',4395), ('9260136',4395), ('9260139',4395), ('9260140',4395), ('9260149',4395), ('9260150',4395), ('9260155',4395), ('9260156',4395), ('9260167',4395), ('9260168',4395), ('9260181',4395), ('9260182',4395), ('9260215',4395), ('9260216',4395), ('9260245',4395), ('9260246',4395), ('9260253',4395), ('9260255',4395), ('9260301',4395), ('9260302',4395), ('9260305',4395), ('9260306',4395), ('9260317',4395), ('9260379',4395), ('9260380',4395), ('9260383',4395), ('9260384',4395), ('9260385',4395), ('9260386',4395), ('9260435',4395), ('9260436',4395), ('9260447',4395), ('9260448',4395), ('9260459',4395), ('9260460',4395), ('9260461',4395), ('9260462',4395), ('9260569',4395), ('9260631',4395), ('9260632',4395), ('9260741',4395), ('9260742',4395), ('9260763',4395), ('9260764',4395), ('9260765',4395), ('9260766',4395), ('9260819',4395), ('9260841',4395), ('9260842',4395), ('9260897',4395), ('9260898',4395), ('9260955',4395), ('9260956',4395), ('9261034',4395), ('9261045',4395), ('9261046',4395), ('9261057',4395), ('9261058',4395), ('9261093',4395), ('9261094',4395), ('9261097',4395), ('9261131',4395), ('9261132',4395), ('9261163',4395), ('9261164',4395), ('9261219',4395), ('9261220',4395), ('9261329',4395), ('9261339',4395), ('9261471',4395), ('9261495',4395), ('9261496',4395), ('9261791',4395), ('9261792',4395), ('9261793',4395), ('9261803',4395), ('9261804',4395), ('9261843',4395), ('9261844',4395), ('9261965',4395), ('9261966',4395), ('9262029',4395), ('9262030',4395), ('9262159',4395), ('9262160',4395), ('9262205',4395), ('9262206',4395), ('9262227',4395), ('9262228',4395), ('9262295',4395), ('9262296',4395), ('9262321',4395), ('9262322',4395), ('9262334',4395), ('9262456',4395), ('9262555',4395), ('9262617',4395), ('9262669',4395), ('9262751',4395), ('9262752',4395), ('9262765',4395), ('9262766',4395), ('9263687',4395), ('9263688',4395), ('9263691',4395), ('9263692',4395), ('9263771',4395), ('9263772',4395), ('9264261',4395), ('9264262',4395), ('9264481',4395), ('9264482',4395), ('9264935',4395), ('9264936',4395), ('9270007',4395), ('9270055',4395), ('9270056',4395), ('9270199',4395), ('9270415',4395), ('9350030',4395), ('9350055',4395), ('9350120',4395), ('9360016',4395), ('9360032',4395), ('9360033',4395), ('9370002',4395), ('9370008',4395), ('9370009',4395), ('9370013',4395), ('9370014',4395), ('9370015',4395), ('9370018',4395), ('9370019',4395), ('9370022',4395), ('9370023',4395), ('9370024',4395), ('510924S',373), ('512720',373), ('519187',373), ('GSA334825',6529), ('GSA334947',6529), ('GSA344283',6529), ('GSA366007',6529), ('J4300826',72), ('J4302014',72), ('J4308003',72), ('J4310826',72), ('J4312014',72), ('J4318003',72), ('J4320902',72), ('J4321001',72), ('J4322015',72), ('J4325003',72), ('SH20031G',4756), ('SH21005G',4756), ('SH21018G',4756), ('SH21019G',4756), ('SH21024G',4756), ('SH21033G',4756), ('SH21034G',4756), ('SH21035G',4756), ('SH21091G',4756), ('SH22005G',4756), ('SH22018G',4756), ('SH22019G',4756), ('SH22024G',4756), ('SH22033G',4756), ('SH22034G',4756), ('SH22035G',4756), ('SH22091G',4756), ('SH40006G',4756), ('SH40031G',4756), ('SH40092G',4756), ('50409012G',6359), ('50409072',6359), ('50412021',6359), ('50413043',6359), ('50413045',6359), ('50413045G',6359), ('50413083B',6359), ('50413084B',6359), ('50413102',6359), ('50413103',6359), ('50416054',6359), ('50416055',6359), ('50417056',6359), ('50417076',6359), ('50417076B',6359), ('50417077',6359), ('50417077B',6359), ('50417082B',6359), ('50417083B',6359), ('50421054',6359), ('50421055',6359), ('50421058',6359), ('MM00087',156), ('MM00088',156), ('MM00138',156), ('MM00139',156), ('MM00178',156), ('MM00200',156), ('MM00213',156), ('MM00215',156), ('MM00230',156), ('MM00231',156), ('MM00234',156), ('MM00235',156), ('MM00237',156), ('MM00239',156), ('MM00241',156), ('MM00242',156), ('MM00244',156), ('MM00246',156), ('MM00247',156), ('MM00250',156), ('MM00252',156), ('MM00254',156), ('MM00262',156), ('MM00265',156), ('MM00326',156), ('MM00329',156), ('MM00336',156), ('MM00341',156), ('MM00344',156), ('MM00345',156), ('MM00346',156), ('MM00351',156), ('MM00398',156), ('MM00406',156), ('MM00535',156), ('MM00538',156), ('MM00539',156), ('MM00565',156), ('MM00566',156), ('MM00670',156), ('MM00679',156), ('MM00748',156), ('MM00790',156), ('MM00924',156), ('MM00925',156), ('MM10056',156), ('MM10058',156), ('MM10060',156), ('MM10067',156), ('MM10070',156), ('MM10071',156), ('MM15532',156), ('MM15534',156), ('MM20007',156), ('MM20008',156), ('MM20009',156), ('MM20010',156), ('MM20011',156), ('MM20012',156), ('MM20015',156), ('MM20018',156), ('MM20019',156), ('MM20021',156), ('MM20026',156), ('MM20027',156), ('MM20061',156), ('MM20062',156), ('MM20063',156), ('MM20064',156), ('MM20091',156), ('MM22013',156), ('MM22014',156), ('MM22015',156), ('MM22030',156), ('MM22041',156), ('MM22042',156), ('MM22045',156), ('MM22052',156), ('MM22057',156), ('MM22058',156), ('MM22102',156), ('MM22103',156), ('MM22104',156), ('MM22105',156), ('MM22128',156), ('MM33021',156), ('MM33042',156), ('MM33043',156), ('MM33044',156), ('MM33045',156), ('MM33049',156), ('MM33050',156), ('MM40036',156), ('MM40037',156), ('MM50058',156), ('MM50063',156), ('MM50064',156), ('MM50080',156), ('MM50081',156), ('MM53425',156), ('MM70000',156), ('MM70001',156), ('MM70002',156), ('MM70003',156), ('MM70022',156), ('MM70027',156), ('MM70028',156), ('MM70030',156), ('MM70032',156), ('MM70040',156), ('MM70041',156), ('MM80001',156), ('MM80003',156), ('MM90027',156), ('MMHY044',156), ('MMHY052',156), ('MMW0004',156), ('MJ00087',481), ('MJ00088',481), ('MJ00138',481), ('MJ00139',481), ('MJ00178',481), ('MJ00200',481), ('MJ00213',481), ('MJ00215',481), ('MJ00230',481), ('MJ00231',481), ('MJ00234',481), ('MJ00235',481), ('MJ00237',481), ('MJ00239',481), ('MJ00241',481), ('MJ00242',481), ('MJ00244',481), ('MJ00246',481), ('MJ00247',481), ('MJ00250',481), ('MJ00252',481), ('MJ00254',481), ('MJ00262',481), ('MJ00265',481), ('MJ00326',481), ('MJ00329',481), ('MJ00336',481), ('MJ00341',481), ('MJ00344',481), ('MJ00345',481), ('MJ00346',481), ('MJ00351',481), ('MJ00398',481), ('MJ00406',481), ('MJ00535',481), ('MJ00538',481), ('MJ00539',481), ('MJ00565',481), ('MJ00566',481), ('MJ00670',481), ('MJ00679',481), ('MJ00748',481), ('MJ00790',481), ('MJ00924',481), ('MJ00925',481), ('MJ10056',481), ('MJ10058',481), ('MJ10060',481), ('MJ10067',481), ('MJ10070',481), ('MJ10071',481), ('MJ15532',481), ('MJ15534',481), ('MJ20007',481), ('MJ20008',481), ('MJ20009',481), ('MJ20010',481), ('MJ20011',481), ('MJ20012',481), ('MJ20015',481), ('MJ20018',481), ('MJ20019',481), ('MJ20021',481), ('MJ20026',481), ('MJ20027',481), ('MJ20061',481), ('MJ20062',481), ('MJ20063',481), ('MJ20064',481), ('MJ20091',481), ('MJ22013',481), ('MJ22014',481), ('MJ22015',481), ('MJ22030',481), ('MJ22041',481), ('MJ22042',481), ('MJ22045',481), ('MJ22052',481), ('MJ22057',481), ('MJ22058',481), ('MJ22102',481), ('MJ22103',481), ('MJ22104',481), ('MJ22105',481), ('MJ22128',481), ('MJ33021',481), ('MJ33042',481), ('MJ33043',481), ('MJ33044',481), ('MJ33045',481), ('MJ33049',481), ('MJ33050',481), ('MJ40036',481), ('MJ40037',481), ('MJ50058',481), ('MJ50063',481), ('MJ50064',481), ('MJ50080',481), ('MJ50081',481), ('MJ53425',481), ('MJ70000',481), ('MJ70001',481), ('MJ70002',481), ('MJ70003',481), ('MJ70022',481), ('MJ70027',481), ('MJ70028',481), ('MJ70030',481), ('MJ70032',481), ('MJ70040',481), ('MJ70041',481), ('MJ80001',481), ('MJ80003',481), ('MJ90027',481), ('MJHY044',481), ('MJHY052',481), ('MJW0004',481), ('BS20004',6786), ('BS22007',6786), ('RB51001',6786), ('1142100700',268), ('1142100800',268), ('1142101400',268), ('1152103000',268), ('1242105070',268), ('1242105080',268), ('1242105200',268), ('1242400200',268), ('1252103400',268), ('1252104100',268), ('1252104200',268), ('1542101700',268), ('1542104070',268), ('1542104080',268), ('1542104970',268), ('1542105070',268), ('1542105080',268), ('1552100900',268), ('1552103700',268), ('3352101300',268), ('4052101070',268), ('4052101080',268), ('4742100670',268), ('4742100680',268), ('4942101370',268), ('4942101380',268), ('2000010',185), ('2000133',185), ('2000134',185), ('2000198',185), ('2000209',185), ('2000253',185), ('2000254',185), ('2000280',185), ('2000281',185), ('2000289',185), ('2000290',185), ('2000293',185), ('2000294',185), ('2000308',185), ('2000309',185), ('2000312',185), ('2000313',185), ('2000319',185), ('2000320',185), ('2000330',185), ('2000331',185), ('2000360',185), ('2000365',185), ('2000366',185), ('2000367',185), ('2000369',185), ('2000408',185), ('2000409',185), ('2000411',185), ('2000422',185), ('2000423',185), ('2000426',185), ('2000427',185), ('2000481',185), ('2000596',185), ('2000597',185), ('2000606',185), ('2000607',185), ('2000720',185), ('2000810',185), ('2000956',185), ('2001005',185), ('2001068',185), ('2019008',185), ('2019009',185), ('2019010',185), ('2019011',185), ('2019025',185), ('20300011',185), ('20333829',185), ('20334009',185), ('20334010',185), ('20334017',185), ('20334018',185), ('20334021',185), ('20334022',185), ('20334025B',185), ('20334026B',185), ('20334036',185), ('20334037',185), ('20334040',185), ('20334041',185), ('20334047',185), ('20334048',185), ('20334054',185), ('20334059',185), ('20334060',185), ('20334107',185), ('20334107F',185), ('20334108',185), ('20334129',185), ('20334420',185), ('20334803',185), ('20334804',185), ('20334909',185), ('20334910',185), ('20334927',185), ('20334928',185), ('20335110',185), ('20339095',185), ('20339096',185), ('20339953',185), ('20339954',185), ('20343001',185), ('20343399',185), ('20344007',185), ('20365158',185), ('20366002',185), ('20553002',185), ('20554003',185), ('20635029',185), ('209130',185), ('209183',185), ('SSA1006',201), ('SSA10122',201), ('SSA10123',201), ('SSA10124',201), ('SSA10126',201), ('SSA10181',201), ('SSA10182',201), ('SSA10185',201), ('SSA10191',201), ('SSA10217',201), ('SSA10218',201), ('SSA10256',201), ('SSA10257',201), ('SSA10263',201), ('SSA10264',201), ('SSA10268',201), ('SSA10326',201), ('SSA10366',201), ('SSA10367',201), ('SSA2005',201), ('SSA2018',201), ('SSA4505',201), ('SSA5507',201), ('SSA6540',201), ('SSA6561',201), ('SSA6562',201), ('SSA6565',201), ('SSA8504',201), ('SSA8512',201), ('SSA9017',201), ('SSA9033',201), ('SSA9056',201), ('SSA9081',201), ('SSA9082',201), ('SSA9083',201), ('SSA9084',201), ('850024921',286), ('46021Z',387), ('46084Z',387), ('46085Z',387), ('46118Z',387), ('46125Z',387), ('46153Z',387), ('46162Z',387), ('46163Z',387), ('46190Z',387), ('46191Z',387), ('46194Z',387), ('46211Z',387), ('46212Z',387), ('46230Z',387), ('46239Z',387), ('46286Z',387), ('46294Z',387), ('46301Z',387)
        
) AS search_list(search_art, search_sup)

INNER JOIN article a 
    ON a.articleSearch = search_list.search_art 
   AND a.supplierId = search_list.search_sup

LEFT JOIN article_oem ao 
    ON ao.articleNumber = a.articleNumber 
   AND ao.supplierId = a.supplierId
LEFT JOIN manufacturer m 
    ON m.manufacturerId = ao.manufacturerId
LEFT JOIN products.brands b 
    ON b.title = m.manufacturerName
LEFT JOIN products.products p 
    ON p.article = ao.oemSearch 
   AND p.brand_id = b.id
LEFT JOIN LATERAL (
    SELECT ps_sub.id 
    FROM products.products_suppliers ps_sub 
    WHERE ps_sub.product_id = p.id 
      AND ps_sub.supplier_id IN (223)
) ps_sub ON true;
An internal server error occurred.