SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps_sub.id AS id FROM ( VALUES ('0258006046',30), ('0258006295',30), ('0258986615',30), ('60395',47), ('OS3567',215), ('CS0065',215), ('TP0028',215), ('AS0006',215), ('WS2602',215), ('LS140132',215), ('SS10803',89), ('SS1068912B1',89), ('TS10416',89), ('ES1079312B1',89), ('ES2028012B1',89), ('ES2031112B1',89), ('DOX0150',4760), ('DOX2002',4760), ('1830252',4005), ('330027',234), ('330340',234), ('550051',234), ('550051A',234), ('550072',234), ('550537',234), ('550150',234), ('550386',234), ('550663',234), ('570003',234), ('E144004',4391), ('70131',4005), ('93224',4005), ('90543',4005), ('105083',4005), ('104005',4005), ('73252',4005), ('108280',4005), ('108282',4005), ('FT75527',4938), ('34970',101), ('22261',101), ('TSN22968',271), ('1293102400',268), ('SEB1530',4501), ('LS0998',4707), ('064848160010',4723), ('064848280010',4723), ('219244300500',4723), ('466016355006',4723), ('72027',244), ('87501',244), ('87176',244), ('87176E',244), ('87484',244), ('83050',244), ('82141',244), ('81503E',244), ('81504',244), ('CSE003',4705), ('CSE020',4705), ('OS15P',4705), ('OSB4115P',4705), ('1952',15), ('91508',15), ('92080',15), ('95801',15), ('ESLAU002',6355), ('ESLAU005',6355), ('ESLAU008',6355), ('ESLCH003',6355), ('06865',4683), ('20055',4683), ('05825',4683), ('06861',4683), ('01759',4683), ('01765',4683), ('05478',4683), ('07859',4683), ('13996',4683), ('PE70050',4558), ('PE30003',4558), ('VSOS0919',4771), ('VSOS0920',4771), ('0609000SX',4595), ('0600004SX',4595), ('0604009SX',4595), ('0604040SX',4595), ('2000008SX',4595), ('2000023SX',4595), ('2000277SX',4595), ('255400',21), ('254070',21), ('V46720021',183), ('A2C59513360Z',83), ('95600',4598), ('12004024',4657), ('12004119',4657), ('12004120',4657), ('12004159',4657), ('APT028',374), ('ASC038',374), ('ASTR150',374), ('SLS13168',374), ('SLS13171',374), ('SLS13173',374), ('SLS13186',374), ('SLS13235',374), ('SLS13312',374), ('SLS13314',374), ('SLS13315',374), ('SLS13316',374), ('SLS13317',374), ('SLS13318',374), ('SLS13319',374), ('SLS13321',374), ('SLS13326',374), ('SLS13335',374), ('SLS13337',374), ('SLS13338',374), ('SLS13339',374), ('SLS13347',374), ('SLS41',374), ('SLS42',374), ('SLS43',374), ('SLS44',374), ('SLS45',374), ('SLS4B1',374), ('SLS4B2',374), ('SLS4B3',374), ('SLS4B4',374), ('SLS4B5',374), ('SLS60404',374), ('51711',6558), ('51712',6558), ('53238',6558), ('53357',6558), ('54513',6558), ('54519',6558), ('54522',6558), ('54522SET',6558), ('54524',6558), ('54524SET',6558), ('55400',6558), ('751069N',80), ('XS2602',4975), ('XS3521',4975), ('XS3578',4975), ('30669',4576), ('30972',4576), ('30978',4576), ('30981',4576), ('33664',4576), ('55801',4576), ('56565',4576), ('74121',4576), ('74124',4576), ('74137',4576), ('74140',4576), ('74166',4576), ('74169',4576), ('74183',4576), ('74204',4576), ('43U03',257), ('43U04',257), ('920048002',442), ('B40401',442), ('105575',4495), ('83420',4495), ('903102',300), ('903104',300), ('903106',300), ('AS2048',4737), ('AS2109',4737), ('AS2113',4737), ('AS2115',4737), ('AS2200',4737), ('AS2203',4737), ('AS2208',4737), ('AS2212',4737), ('AS3039',4737), ('AS4123',4737), ('AS4235',4737), ('AS4236',4737), ('AS4260',4737), ('AS4545',4737), ('AS4702',4737), ('AS4738',4737), ('140000210',323), ('150012210',323), ('150033010',323), ('150033210',323), ('150034010',323), ('150059910',323), ('150061210',323), ('150065110',323), ('150065610',323), ('150072710',323), ('150072810',323), ('150073510',323), ('OES6024',4337), ('PES0025',4337), ('PES0037',4337), ('PES3516',4337), ('PES6024',4337), ('PSE1034',4337), ('PSE1040',4337), ('PSE1043',4337), ('PSE1060',4337), ('PSS1450',4337), ('0011016865',4995), ('0011017441',4995), ('0011021229',4995), ('0011021399',4995), ('0011028005',4995), ('0273016418',4995), ('0294013654',4995), ('CSS1533',194), ('CSS1534',194), ('CSS1535',194), ('CSS1542',194), ('OXY413040',194), ('OXY425117',194), ('OXY453042',194), ('OXY472045',194), ('OPH011',6444), ('OPH015',6444), ('OPH016',6444), ('OPH020',6444), ('OPH021',6444), ('OPH026',6444), ('OPH028',6444), ('OPH030',6444), ('OPH033',6444), ('OPH034',6444), ('OPH035',6444), ('OPH038',6444), ('OPH040',6444), ('OPH041',6444), ('OPH042',6444), ('OPH043',6444), ('OPH045',6444), ('OPH046',6444), ('OPH047',6444), ('OPH074',6444), ('OZH184',6444), ('SPR028',6444), ('SPR036',6444), ('ST233',6444), ('ADA106607',350), ('ADA107014C',350), ('ADA107021',350), ('ADA107027',350), ('ADC47038',350), ('ADN17037C',350), ('ADN17056',350), ('ADN17259',350), ('ADN17260',350), ('ADN17269',350), ('ADP157004C',350), ('ADR167001',350), ('ADZ96603',350), ('ADZ99204',350), ('BOP1001',475), ('BOP1019',475), ('BOP1020',475), ('BTS3030',475), ('B16926',4815), ('B16927',4815), ('B16929',4815), ('B18921',4815), ('0258003673',30), ('0258005135',30), ('0258005136',30), ('0258005717',30), ('0258005729',30), ('0258006020',30), ('0258006026',30), ('0258006027',30), ('0258006033',30), ('0258006035',30), ('0258006039',30), ('0258006063',30), ('0258006064',30), ('0258006123',30), ('0258006125',30), ('0258006128',30), ('0258006146',30), ('0258006159',30), ('0258006161',30), ('0258006163',30), ('0258006165',30), ('0258006167',30), ('0258006173',30), ('0258006174',30), ('0258006175',30), ('0258006179',30), ('0258006183',30), ('0258006186',30), ('0258006189',30), ('0258006190',30), ('0258006196',30), ('0258006213',30), ('0258006237',30), ('0258006243',30), ('0258006245',30), ('0258006247',30), ('0258006249',30), ('0258006255',30), ('0258006257',30), ('0258006259',30), ('0258006261',30), ('0258006268',30), ('0258006272',30), ('0258006274',30), ('0258006276',30), ('0258006281',30), ('0258006283',30), ('0258006285',30), ('0258006294',30), ('0258006305',30), ('0258006307',30), ('0258006311',30), ('0258006312',30), ('0258006314',30), ('0258006318',30), ('0258006320',30), ('0258006322',30), ('0258006324',30), ('0258006328',30), ('0258006334',30), ('0258006348',30), ('0258006353',30), ('0258006359',30), ('0258006361',30), ('0258006363',30), ('0258006371',30), ('0258006376',30), ('0258006378',30), ('0258006379',30), ('0258006388',30), ('0258006389',30), ('0258006392',30), ('0258006404',30), ('0258006406',30), ('0258006411',30), ('0258006420',30), ('0258006422',30), ('0258006431',30), ('0258006432',30), ('0258006442',30), ('0258006444',30), ('0258006469',30), ('0258006471',30), ('0258006525',30), ('0258006527',30), ('0258006544',30), ('0258006582',30), ('0258006584',30), ('0258006609',30), ('0258006623',30), ('0258006624',30), ('0258006682',30), ('0258006740',30), ('0258006791',30), ('0258006953',30), ('0258006970',30), ('0258006978',30), ('0258006980',30), ('0258010032',30), ('0258010073',30), ('0258986507',30), ('0258986602',30), ('0258986603',30), ('0258986625',30), ('0258986680',30), ('0258986726',30), ('0258986727',30), ('0258986738',30), ('0986280410',30), ('0986280454',30), ('0986280455',30), ('0986280457',30), ('F00099S002',30), ('BREL9914',6371), ('60313',47), ('60314',47), ('60396',47), ('60415',47), ('BSG25840001',4455), ('BSG65840034',4455), ('BSG65840038',4455), ('BSG75840009',4455), ('54030',157), ('54032',157), ('54061',157), ('54077',157), ('54078',157), ('54079',157), ('54081',157), ('54091',157), ('CS0222',215), ('CS0257',215), ('CS0318',215), ('CS0335',215), ('CS0379',215), ('LS140023',215), ('LS140028',215), ('LS140038',215), ('LS140061',215), ('LS140065',215), ('LS140083',215), ('LS140096',215), ('LS140207',215), ('LS140275',215), ('LS140282',215), ('LS140546',215), ('LS140547',215), ('LS140548',215), ('LS140549',215), ('LS140608',215), ('LS140713',215), ('OS3516',215), ('OS3521',215), ('6771',4604), ('756871',405), ('758342',405), ('700101968',6411), ('700101968N',6411), ('700103504',6411), ('701042145',6411), ('701044743',6411), ('71628HN',6411), ('760548175',6411), ('782052063',6411), ('782551743',6411), ('782647554',6411), ('782746497',6411), ('A2C59513168Z',83), ('A2C59513169Z',83), ('A2C59513171Z',83), ('A2C59513173Z',83), ('A2C59513186Z',83), ('A2C59513235Z',83), ('A2C59513312Z',83), ('A2C59513315Z',83), ('A2C59513316Z',83), ('A2C59513317Z',83), ('A2C59513318Z',83), ('A2C59513319Z',83), ('A2C59513321Z',83), ('A2C59513326Z',83), ('A2C59513337Z',83), ('A2C59513338Z',83), ('A2C59513339Z',83), ('A2C59513347Z',83), ('A2C59513878Z',83), ('A2C59515059',83), ('S105757001Z',83), ('S119974001Z',83), ('S119976001Z',83), ('CCI5104',4334), ('CPM9122',4334), ('CSL2052',4334), ('CSL2134',4334), ('CSL2135',4334), ('CSL2161',4334), ('CSL2165',4334), ('CSP9007',4334), ('CSP9016',4334), ('CSP9017',4334), ('CSR9055',4334), ('CSR9105',4334), ('CSR9111',4334), ('CSR9138',4334), ('CSR9367',4334), ('CSR9416',4334), ('CST1451',4334), ('CST2056',4334), ('CST9459',4334), ('CST9514',4334), ('CST9520',4334), ('CST9523',4334), ('CTH2242',4334), ('ES1076312B1',89), ('ES1079712B1',89), ('ES20014',89), ('ES20039',89), ('ES20062',89), ('ES20115',89), ('ES2011511B1',89), ('ES2011512B1',89), ('ES20151',89), ('ES2015112B1',89), ('ES2016212B1',89), ('ES20163',89), ('ES20164',89), ('ES2016411B1',89), ('ES2016412B1',89), ('ES2016612B1',89), ('ES20168',89), ('ES2016812B1',89), ('ES2016911B1',89), ('ES2017311B1',89), ('ES2017312B1',89), ('ES20174',89), ('ES2017412B1',89), ('ES20175',89), ('ES2017512B1',89), ('ES20177',89), ('ES2017811B1',89), ('ES2023012B1',89), ('ES2023812B1',89), ('ES2025812B1',89), ('ES2030812B1',89), ('ES2030912B1',89), ('ES2031012B1',89), ('ES2031212B1',89), ('ES2031312B1',89), ('ES2031512B1',89), ('ES2031811B1',89), ('ES2031812B1',89), ('ES2032812B1',89), ('ES2033812B1',89), ('ES2034212B1',89), ('ES2034312B1',89), ('ES2034412B1',89), ('ES2034612B1',89), ('ES20376',89), ('ES2041812B1',89), ('ES2067612B1',89), ('SS10689',89), ('SS10802',89), ('SS10889',89), ('SS10923',89), ('SS11011',89), ('SW90000',89), ('SW90002',89), ('SW90051',89), ('TS1022012B1',89), ('TS1022112B1',89), ('WC10026',89), ('DOX0109',4760), ('DOX0114',4760), ('DOX0119',4760), ('DOX0121',4760), ('DOX1371',4760), ('DOX2000',4760), ('DOX2005',4760), ('DOX2006',4760), ('DOX2007',4760), ('DOX2008',4760), ('DOX2009',4760), ('DOX2011',4760), ('DOX2012',4760), ('DOX2015',4760), ('DOX2018',4760), ('DOX2021',4760), ('DOX2022',4760), ('DOX2023',4760), ('DOX2025',4760), ('DOX2026',4760), ('DOX2027',4760), ('DOX2033',4760), ('DOX2035',4760), ('DOX2037',4760), ('DOX2039',4760), ('DOX2047',4760), ('DOX2048',4760), ('DOX2051',4760), ('INJCS032N',4882), ('INJCS083N',4882), ('INJCS087N',4882), ('INJCS100N',4882), ('INJCS110N',4882), ('INJCS111N',4882), ('INJLS045N',4882), ('INJLS058BSCN',4882), ('INJLS074N',4882), ('INJLS075N',4882), ('INJLS124N',4882), ('INJLS126N',4882), ('INJLS127N',4882), ('INJLS129N',4882), ('INJLS166N',4882), ('INJLS188HLLN',4882), ('INJLS204BSCN',4882), ('INJLSU001DNSN',4882), ('INJSPF002MRLN',4882), ('1040310011',4345), ('1040310013',4345), ('1227041',355), ('1227042',355), ('1227044',355), ('627357',355), ('633328',355), ('681020',355), ('780131',355), ('LSK024',488), ('LSK062',488), ('LSK081',488), ('LSK100',488), ('LSK231',488), ('144444',211), ('144446',211), ('144453',211), ('144456',211), ('144458',211), ('144459',211), ('144460',211), ('295106',211), ('295108',211), ('295150',211), ('303291',211), ('EE0011',4344), ('EE0015',4344), ('EE0021',4344), ('EE0073',4344), ('EE0094',4344), ('EE0381',4344), ('EE0541',4344), ('EE0542',4344), ('EE0564',4344), ('EE0569',4344), ('EE3202',4344), ('EE3242',4344), ('EE8051',4344), ('EV0015',4344), ('EV0301',4344), ('EV0308',4344), ('EX0002',4344), ('EX0007',4344), ('EX0010',4344), ('EX0038',4344), ('EX0053',4344), ('EX0064',4344), ('EX0080',4344), ('EX0113',4344), ('EX0132',4344), ('EX0229',4344), ('EX0408',4344), ('XCS6012',4344), ('XCS6020',4344), ('XCS6023',4344), ('XCS6071',4344), ('XCS6085',4344), ('XCS6388',4344), ('XCS6487',4344), ('XCS6553',4344), ('XCS6557',4344), ('XCS6568',4344), ('XLS1005',4344), ('XLS1008',4344), ('XLS1009',4344), ('XLS1044',4344), ('XLS1056',4344), ('XLS1071',4344), ('XLS1110',4344), ('XLS1123',4344), ('XLS1134',4344), ('XLS1277',4344), ('XLS1508',4344), ('XOS8203',4344), ('XOS8236',4344), ('XSP7227',4344), ('XTS7718',4344), ('XTS7767',4344), ('XTS7856',4344), ('ENT600010',6889), ('ENT600011',6889), ('ENT600013',6889), ('ENT600016',6889), ('ENT600021',6889), ('ENT600023',6889), ('ENT600058',6889), ('ENT800001',6889), ('ENT820007',6889), ('SALEENT600016',6889), ('1800076',4005), ('1800096',4005), ('1800131',4005), ('1953540',4005), ('1953543',4005), ('1953543K',4005), ('1953545',4005), ('1953545K',4005), ('1953597K',4005), ('1953658',4005), ('1994005',4005), ('1995083',4005), ('1997097',4005), ('1997281',4005), ('1997282',4005), ('1997322',4005), ('1997591',4005), ('1997594',4005), ('1998169',4005), ('1998222',4005), ('1998240',4005), ('1998242',4005), ('1998247',4005), ('1998248',4005), ('1998252',4005), ('1998253',4005), ('1998280',4005), ('1998281',4005), ('1998282',4005), ('1998283',4005), ('1998284',4005), ('1998285',4005), ('1998286',4005), ('1998287',4005), ('1998289',4005), ('1998301',4005), ('1998302',4005), ('1998306',4005), ('1998332',4005), ('1998333',4005), ('1998352',4005), ('1998353',4005), ('1998386',4005), ('330138',234), ('550066',234), ('550066A',234), ('550072A',234), ('550150A',234), ('550386A',234), ('550409',234), ('550537A',234), ('550616A',234), ('550663A',234), ('550785',234), ('550785A',234), ('550842A',234), ('550843A',234), ('570002',234), ('570002A',234), ('570003A',234), ('570019',234), ('570027',234), ('570027A',234), ('570030',234), ('570030A',234), ('570038A',234), ('570039A',234), ('570042',234), ('570042A',234), ('570054A',234), ('570055A',234), ('570070',234), ('570070A',234), ('570083A',234), ('570087A',234), ('570091A',234), ('570111A',234), ('570148',234), ('570148A',234), ('570203A',234), ('570212A',234), ('570217A',234), ('570228A',234), ('570248A',234), ('570263A',234), ('09SKV015',4969), ('09SKV029',4969), ('09SKV031',4969), ('09SKV032',4969), ('09SKV035',4969), ('09SKV036',4969), ('09SKV037',4969), ('09SKV038',4969), ('09SKV039',4969), ('09SKV048',4969), ('09SKV057',4969), ('09SKV059',4969), ('09SKV078',4969), ('09SKV079',4969), ('09SKV080',4969), ('09SKV097',4969), ('09SKV098',4969), ('09SKV100',4969), ('09SKV101',4969), ('09SKV593',4969), ('09SKV617',4969), ('09SKV619',4969), ('09SKV624',4969), ('09SKV638',4969), ('09SKV639',4969), ('09SKV640',4969), ('09SKV641',4969), ('09SKV643',4969), ('09SKV644',4969), ('09SKV646',4969), ('09SKV647',4969), ('09SKV681',4969), ('09SKV684',4969), ('09SKV691',4969), ('09SKV694',4969), ('09SKV695',4969), ('09SKV696',4969), ('09SKV699',4969), ('09SKV704',4969), ('09SKV705',4969), ('09SKV706',4969), ('09SKV711',4969), ('09SKV729',4969), ('09SKV904',4969), ('09SKV909',4969), ('09SKV911',4969), ('09SKV913',4969), ('09SKV993',4969), ('17SKV010',4969), ('17SKV280',4969), ('17SKV281',4969), ('17SKV282',4969), ('17SKV535',4969), ('06A906262AH',6367), ('06A906262F',6367), ('06A906262FUNIV',6367), ('06A906262Q',6367), ('06A906265M',6367), ('2524000QAA',6367), ('7700101968',6367), ('E144003',4391), ('107097',4005), ('107281',4005), ('107282',4005), ('107322',4005), ('107591',4005), ('107594',4005), ('108169',4005), ('108222',4005), ('108240',4005), ('108242',4005), ('108247',4005), ('108248',4005), ('108252',4005), ('108253',4005), ('108281',4005), ('108283',4005), ('108284',4005), ('108285',4005), ('108286',4005), ('108287',4005), ('108289',4005), ('108301',4005), ('108302',4005), ('108306',4005), ('108332',4005), ('108333',4005), ('108352',4005), ('108353',4005), ('108386',4005), ('70076',4005), ('70096',4005), ('90540',4005), ('90543K',4005), ('90545',4005), ('90545K',4005), ('90597K',4005), ('90658',4005), ('12370',240), ('12430',240), ('12630',240), ('33510',240), ('33512',240), ('33724',240), ('77141',240), ('77142',240), ('77143',240), ('77144',240), ('77148',240), ('77151',240), ('77153',240), ('77171',240), ('77201',240), ('77203',240), ('77204',240), ('77206',240), ('77207',240), ('77224',240), ('77226',240), ('77227',240), ('77234',240), ('77235',240), ('77240',240), ('77249',240), ('77250',240), ('77251',240), ('77252',240), ('77256',240), ('77270',240), ('77274',240), ('77283',240), ('77284',240), ('77328',240), ('77332',240), ('77333',240), ('77334',240), ('77362',240), ('77406',240), ('77412',240), ('77499',240), ('77582',240), ('77602',240), ('77618',240), ('77622',240), ('77623',240), ('77629',240), ('77676',240), ('77902',240), ('77903',240), ('77906',240), ('77911',240), ('79027',240), ('79028',240), ('79030',240), ('79214',240), ('79217',240), ('79320',240), ('79321',240), ('79323',240), ('79324',240), ('79328',240), ('FT75528',4938), ('FT75529',4938), ('FT75530',4938), ('FT75538',4938), ('FT75560',4938), ('FT80124',4938), ('103150',101), ('107098',101), ('107099',101), ('12228',101), ('22891',101), ('22903',101), ('24028',101), ('26171',101), ('34387',101), ('34388',101), ('37091',101), ('37174',101), ('37432',101), ('44646',101), ('45075',101), ('XL782040040',415), ('XL782640130',415), ('XL785240045',415), ('XL882640057',415), ('XL887740072',415), ('FOP1001',407), ('FOP1019',407), ('FOP1020',407), ('FTS3030',407), ('405104',441), ('405105',441), ('82007',441), ('82016',441), ('82017',441), ('821451',441), ('82450',441), ('82514',441), ('82520',441), ('82523',441), ('83055',441), ('83055A2',441), ('83105',441), ('83111',441), ('83415',441), ('83415A2',441), ('83470',441), ('84122',441), ('90052',441), ('90054',441), ('90054A2',441), ('90054HQ',441), ('90056',441), ('90056A2',441), ('90057',441), ('90058',441), ('90058A2',441), ('90058HQ',441), ('90059',441), ('90059A2',441), ('90059HQ',441), ('90061',441), ('90061A2',441), ('90074',441), ('90074A2',441), ('90074HQ',441), ('90075',441), ('90083',441), ('90125',441), ('90125A2',441), ('90127',441), ('90127A2',441), ('90127HQ',441), ('90131',441), ('90131A2',441), ('90132',441), ('90132A2',441), ('90134',441), ('90134A2',441), ('90135',441), ('90135A2',441), ('90135HQ',441), ('90139',441), ('90139A2',441), ('90139HQ',441), ('90161',441), ('90165',441), ('90169',441), ('90169A2',441), ('90170',441), ('90170A2',441), ('90182',441), ('90183',441), ('90185',441), ('90196',441), ('90197',441), ('90197A2',441), ('90197HQ',441), ('90245',441), ('90245A2',441), ('90264',441), ('90264A2',441), ('90264HQ',441), ('90283',441), ('90283A2',441), ('90335',441), ('90446',441), ('90446A2',441), ('90463',441), ('90615',441), ('90951',441), ('FSE51712',236), ('780600901',6484), ('780601801',6484), ('GO9437',4933), ('GS7389',4933), ('GS8269',4933), ('GS8556',4933), ('911291',4379), ('920561',4379), ('921831',4379), ('970031',4379), ('970051',4379), ('970141',4379), ('970171',4379), ('970231',4379), ('970241',4379), ('970331',4379), ('970351',4379), ('970391',4379), ('970431',4379), ('GAS0006',6456), ('150404',4819), ('150475',4819), ('150683',4819), ('151056',4819), ('181294',4819), ('181300',4819), ('181303',4819), ('181308',4819), ('181701',4819), ('181702',4819), ('181716',4819), ('181772',4819), ('181788',4819), ('181819',4819), ('181829',4819), ('181838',4819), ('181845',4819), ('182480',4819), ('182899',4819), ('182902',4819), ('182928',4819), ('6PA009165691',4734), ('6PA009165701',4734), ('6PA009166781',4734), ('6PA009166971',4734), ('6PA358066111',4734), ('6PA358066151',4734), ('6PA358066171',4734), ('6PA358066191',4734), ('6PA358066201',4734), ('6PA358066341',4734), ('6PA358066391',4734), ('6PA358066401',4734), ('6PA358103161',4734), ('6PA358103291',4734), ('6PA358103381',4734), ('6PA358103571',4734), ('6PT009107131',4734), ('6PT009109191',4734), ('6PT009109221',4734), ('6PU009163641',4734), ('6PU009163651',4734), ('6PU009163851',4734), ('6PU009163861',4734), ('6PU009163871',4734), ('6PU009163881',4734), ('6PU009163901',4734), ('6PX008476451',4734), ('6ZL003259601',4734), ('6ZL007675001',4734), ('6ZL009600051',4734), ('51277298',72), ('70511542',72), ('70541076',72), ('70605500',72), ('70610005',72), ('70610008',72), ('70610017',72), ('J1461026',72), ('J1474008',72), ('J1475006',72), ('J5611015',72), ('J5611016',72), ('138114',449), ('138116',449), ('138117',449), ('138132',449), ('7472138',341), ('7472141',341), ('7472177',341), ('7472481',341), ('7481022',341), ('7481022E',341), ('7481029',341), ('7481029E',341), ('7481076',341), ('7481087',341), ('7481087E',341), ('7481088',341), ('7481088OQ',341), ('7481090',341), ('7481090E',341), ('7481091',341), ('7481091E',341), ('7481096',341), ('7481096E',341), ('7481097',341), ('7481097E',341), ('7481099',341), ('74811017',341), ('7481503',341), ('7481503E',341), ('7481504',341), ('7481504E',341), ('7481508',341), ('7481508E',341), ('7481509',341), ('7481509E',341), ('7481516',341), ('7481516E',341), ('7481539',341), ('7481544',341), ('7481548',341), ('7481548E',341), ('7481549',341), ('7481549E',341), ('7481561',341), ('7481562',341), ('7481564',341), ('7481578',341), ('7481579',341), ('7481579E',341), ('7481601',341), ('7481633',341), ('7481633E',341), ('7481654',341), ('7481654OQ',341), ('7481702',341), ('7481710',341), ('7481710E',341), ('7481736',341), ('7481846',341), ('7481846E',341), ('7481863',341), ('7481951',341), ('7513050',341), ('7517174',341), ('7517176',341), ('7517176E',341), ('7517177',341), ('7517484',341), ('75174841',341), ('7517567',341), ('7532022',341), ('7532026',341), ('7532027',341), ('8035104',341), ('8035105',341), ('17132',269), ('18877',269), ('18878',269), ('18965',269), ('19087',269), ('19087K',269), ('19088',269), ('19088K',269), ('19089K',269), ('19925',269), ('50981',269), ('51133',269), ('51173',269), ('55144',269), ('55711',269), ('55714',269), ('64132',269), ('64136',269), ('64156',269), ('64162',269), ('64165',269), ('64190',269), ('64194',269), ('64197',269), ('64200',269), ('64205',269), ('64237',269), ('64238',269), ('64241',269), ('64244',269), ('64246',269), ('64247',269), ('64248',269), ('64249',269), ('64250',269), ('64252',269), ('64256',269), ('64259',269), ('64263',269), ('64266',269), ('64289',269), ('64355',269), ('64376',269), ('64378',269), ('64380',269), ('64383',269), ('64400',269), ('64436',269), ('64449',269), ('64454',269), ('64458',269), ('64473',269), ('64493',269), ('64498',269), ('64499',269), ('64500',269), ('64505',269), ('64507',269), ('64508',269), ('64509',269), ('64515',269), ('64527',269), ('64528',269), ('64564',269), ('64671',269), ('64784',269), ('64787',269), ('64929',269), ('SD12308',6387), ('SD38369',6387), ('402097',262), ('402099',262), ('402101',262), ('OOU03',156), ('OOU04',156), ('3U03',481), ('3U04',481), ('LSO1301001',138), ('LSO1318001',138), ('LSO6009001',138), ('1193800500',268), ('1193801500',268), ('1193801800',268), ('1193802400',268), ('1193802500',268), ('1193802600',268), ('1193802700',268), ('1193802800',268), ('1193803400',268), ('1193803800',268), ('1193804600',268), ('1214603110',268), ('1293501300',268), ('109019',185), ('ECR6506',201), ('ECR6536',201), ('ECT6510',201), ('EIT6501',201), ('EOP5505',201), ('EOP6501',201), ('EOS2036',201), ('EOS6549',201), ('862610036',286), ('884510008',286), ('884510011',286), ('884510020',286), ('884512005',286), ('884512006',286), ('884512007',286), ('884512018',286), ('884514523',286), ('884516003',286), ('884517005',286), ('884521060',286), ('884523004',286), ('884523006',286), ('884523015',286), ('884523016',286), ('884523031',286), ('884523032',286), ('884523033',286), ('884523040',286), ('884523046',286), ('884523056',286), ('884524061',286), ('884524119',286), ('884524120',286), ('884524121',286), ('884524122',286), ('884525002',286), ('884525005',286), ('884525007',286), ('884525012',286), ('884525018',286), ('884525019',286), ('884525042',286), ('884525045',286), ('884525047',286), ('884528006',286), ('884528034',286), ('884528048',286), ('884529008',286), ('884529009',286), ('884529012',286), ('884529032',286), ('884529039',286), ('884529040',286), ('884529106',286), ('884529126',286), ('884529136',286), ('884529165',286), ('884529167',286), ('884529168',286), ('884529190',286), ('885510122',286), ('885525102',286), ('885525104',286), ('885525107',286), ('161243Z',387), ('161263Z',387), ('1633724Z',387), ('1679328Z',387), ('49001Z',387), ('49002Z',387), ('49006Z',387), ('49009Z',387), ('49010Z',387), ('49017Z',387), ('49019Z',387), ('49030Z',387), ('49031Z',387), ('49039Z',387), ('49501Z',387), ('49502Z',387), ('49503Z',387), ('8805010',4546), ('8805040',4546), ('8805121',4546), ('453540',4006), ('453543',4006), ('453543K',4006), ('453545',4006), ('453545K',4006), ('453597K',4006), ('453658',4006), ('494005',4006), ('495083',4006), ('497097',4006), ('497281',4006), ('497282',4006), ('497322',4006), ('497591',4006), ('497594',4006), ('498169',4006), ('498222',4006), ('498240',4006), ('498242',4006), ('498247',4006), ('498248',4006), ('498252',4006), ('498253',4006), ('498280',4006), ('498281',4006), ('498282',4006), ('498283',4006), ('498284',4006), ('498285',4006), ('498286',4006), ('498287',4006), ('498289',4006), ('498301',4006), ('498302',4006), ('498306',4006), ('498332',4006), ('498333',4006), ('498352',4006), ('498353',4006), ('498386',4006), ('500076',4006), ('500096',4006), ('500131',4006), ('530252',4006), ('LAT017',6518), ('LCS083',6518), ('LCS161',6518), ('LCS162',6518), ('LCS233',6518), ('LCS328',6518), ('LCS328K',6518), ('LCS329',6518), ('LCS329K',6518), ('LCS330K',6518), ('LLB087',6518), ('LLB089',6518), ('LLB108',6518), ('LLB114',6518), ('LLB117',6518), ('LLB138',6518), ('LLB142',6518), ('LLB145',6518), ('LLB148',6518), ('LLB152',6518), ('LLB180',6518), ('LLB181',6518), ('LLB184',6518), ('LLB187',6518), ('LLB189',6518), ('LLB190',6518), ('LLB191',6518), ('LLB192',6518), ('LLB193',6518), ('LLB199',6518), ('LLB203',6518), ('LLB206',6518), ('LLB209',6518), ('LLB210',6518), ('LLB232',6518), ('LLB282',6518), ('LLB304',6518), ('LLB308',6518), ('LLB312',6518), ('LLB330',6518), ('LLB366',6518), ('LLB378',6518), ('LLB383',6518), ('LLB386',6518), ('LLB400',6518), ('LLB420',6518), ('LLB423',6518), ('LLB424',6518), ('LLB425',6518), ('LLB430',6518), ('LLB432',6518), ('LLB433',6518), ('LLB434',6518), ('LLB442',6518), ('LLB455',6518), ('LLB490',6518), ('LLB626',6518), ('LLB752',6518), ('LLB755',6518), ('LLB908',6518), ('LLB987',6518), ('LLB998',6518), ('LOPS065',6518), ('LOPS100',6518), ('LOPS123',6518), ('LTP005',6518), ('LWS068',6518), ('L0001V560',117), ('L0025B1000',117), ('L0027B450',117), ('L0029B450',117), ('L0042B580',117), ('L0081H1300',117), ('L0101B260',117), ('L0124V1200',117), ('L0151H1850',117), ('L0159B450',117), ('L0170B600',117), ('L0198B550',117), ('L0201H800',117), ('L0237B1200',117), ('L0240B980',117), ('L0290B600',117), ('L0293B450',117), ('LEB417',4501), ('LEB418',4501), ('LEB419',4501), ('LEB420',4501), ('LEB425',4501), ('LEB426',4501), ('LEB435',4501), ('LEB444',4501), ('LEB459',4501), ('LEB466',4501), ('LEB468',4501), ('LEB479',4501), ('LEB481',4501), ('LEB482',4501), ('LEB485',4501), ('LEB490',4501), ('LEB5037',4501), ('LEB5047',4501), ('LEB5048',4501), ('LEB5060',4501), ('LEB5065',4501), ('LEB5140',4501), ('LEB5219',4501), ('LEB5346',4501), ('LEB5347',4501), ('LEB5352',4501), ('LEB5357',4501), ('LEB5358',4501), ('LEB5447',4501), ('LEB5456',4501), ('LEB588',4501), ('LEB590',4501), ('LEB595',4501), ('LEB596',4501), ('LEB597',4501), ('LEB604',4501), ('LEB614',4501), ('LEB617',4501), ('LEB622',4501), ('LEB668',4501), ('LEB743',4501), ('LEB769',4501), ('LEB781',4501), ('LEB783',4501), ('LEB893',4501), ('LEB900',4501), ('LEB915',4501), ('LEB934',4501), ('LEB946',4501), ('LEB967',4501), ('SEB1240',4501), ('SEB1371',4501), ('SEB1717',4501), ('SEB304',4501), ('SEB438',4501), ('SEB440',4501), ('SEB481',4501), ('SEB5004',4501), ('SEB5129',4501), ('SNB936',4501), ('SNB984',4501), ('SOB710',4501), ('SOB711',4501), ('SOB833',4501), ('064848129010',4723), ('064848143010',4723), ('064848159010',4723), ('064848195010',4723), ('171901011010',4723), ('171916011080',4723), ('230016073047',4723), ('230016073067',4723), ('460000287010',4723), ('460000415010',4723), ('460000480010',4723), ('460001814010',4723), ('460001820010',4723), ('460002008710',4723), ('460002008810',4723), ('460002009210',4723), ('460002135010',4723), ('466016355001',4723), ('466016355004',4723), ('466016355007',4723), ('466016355018',4723), ('466016355025',4723), ('466016355036',4723), ('466016355047',4723), ('466016355049',4723), ('466016355052',4723), ('466016355060',4723), ('466016355099',4723), ('466016355104',4723), ('466016355122',4723), ('466016355126',4723), ('466016355157',4723), ('MSC3',287), ('MSC4',287), ('TSE11',287), ('TX10089D',287), ('82303',133), ('82305',133), ('82307',133), ('88100',133), ('7700103504PCSMS',358), ('7701044743PCSMS',358), ('8200052063PCSMS',358), ('MOE4003',6270), ('MOEE0004',6270), ('MOEE0014',6270), ('MOEE0032',6270), ('210138',403), ('210330',403), ('210354',403), ('210357',403), ('240022',403), ('240043',403), ('240046',403), ('240053',403), ('240099',403), ('590013',403), ('590014',403), ('590015',403), ('590048',403), ('590058',403), ('590060',403), ('590066',403), ('590068',403), ('590071',403), ('590086',403), ('590098',403), ('590100',403), ('590101',403), ('590110',403), ('590112',403), ('590114',403), ('590123',403), ('590124',403), ('590125',403), ('EPS1800076',4773), ('EPS1800096',4773), ('EPS1800131',4773), ('EPS1830252',4773), ('EPS1953540',4773), ('EPS1953543',4773), ('EPS1953543K',4773), ('EPS1953545',4773), ('EPS1953545K',4773), ('EPS1953597K',4773), ('EPS1953658',4773), ('EPS1994005',4773), ('EPS1995083',4773), ('EPS1997097',4773), ('EPS1997281',4773), ('EPS1997282',4773), ('EPS1997322',4773), ('EPS1997591',4773), ('EPS1997594',4773), ('EPS1998169',4773), ('EPS1998222',4773), ('EPS1998240',4773), ('EPS1998242',4773), ('EPS1998247',4773), ('EPS1998248',4773), ('EPS1998252',4773), ('EPS1998253',4773), ('EPS1998280',4773), ('EPS1998281',4773), ('EPS1998282',4773), ('EPS1998283',4773), ('EPS1998284',4773), ('EPS1998285',4773), ('EPS1998286',4773), ('EPS1998287',4773), ('EPS1998289',4773), ('EPS1998301',4773), ('EPS1998302',4773), ('EPS1998306',4773), ('EPS1998332',4773), ('EPS1998333',4773), ('EPS1998352',4773), ('EPS1998353',4773), ('EPS1998386',4773), ('MLS9U03',4773), ('MLS9U04',4773), ('MRP2B03',4773), ('25104',244), ('25105',244), ('72022',244), ('72026',244), ('81022',244), ('81022E',244), ('81029',244), ('81029E',244), ('81076',244), ('81087',244), ('81087E',244), ('81088',244), ('81088OQ',244), ('81090',244), ('81090E',244), ('81091',244), ('81091E',244), ('81096',244), ('81096E',244), ('81097',244), ('81097E',244), ('81099',244), ('811017',244), ('81503',244), ('81504E',244), ('81508',244), ('81508E',244), ('81509',244), ('81509E',244), ('81516',244), ('81516E',244), ('81539',244), ('81544',244), ('81548',244), ('81548E',244), ('81549',244), ('81549E',244), ('81561',244), ('81562',244), ('81564',244), ('81578',244), ('81579',244), ('81579E',244), ('81601',244), ('81633',244), ('81633E',244), ('81654',244), ('81654OQ',244), ('81702',244), ('81710',244), ('81710E',244), ('81736',244), ('81846',244), ('81846E',244), ('81863',244), ('81951',244), ('82138',244), ('82177',244), ('82481',244), ('87174',244), ('87177',244), ('874841',244), ('87567',244), ('03102',4664), ('03234',4664), ('35705',4664), ('0893009',94), ('0893016',94), ('0893021',94), ('0893022',94), ('0893023',94), ('0893027',94), ('0893051',94), ('0893065',94), ('0893068',94), ('0893069',94), ('0893072',94), ('0893074',94), ('0893076',94), ('0893165',94), ('0893174',94), ('0893175',94), ('0893178',94), ('0893191',94), ('0893216',94), ('0893264',94), ('0893266',94), ('0893267',94), ('0893328',94), ('0893329',94), ('0893411',94), ('0893412',94), ('0893413',94), ('0893483',94), ('0895051',94), ('0895464',94), ('0895465',94), ('0895539',94), ('0902016',94), ('0902050',94), ('0902051',94), ('0902184',94), ('0902200',94), ('0902223',94), ('0902224',94), ('0902225',94), ('0902226',94), ('0902277',94), ('0902373',94), ('0904011',94), ('0905069',94), ('0905102',94), ('0910022',94), ('0910033',94), ('2322010',94), ('2324051',94), ('1009500001',144), ('16148000023',144), ('16148000026',144), ('16148130000',144), ('16148210008',144), ('16148990010',144), ('CSE003A',4705), ('CSE013',4705), ('CSE020A',4705), ('CSE096',4705), ('CSE153',4705), ('CSE205',4705), ('CSE226A',4705), ('OSB4100P',4705), ('OSB4101P',4705), ('OSB4107P',4705), ('OSB4109P',4705), ('OSB4111P',4705), ('OSB4112P',4705), ('OSB4113P',4705), ('OSB4114P',4705), ('OSB4116P',4705), ('OSB4117P',4705), ('OSB4119P',4705), ('OSB4123P',4705), ('OSB4124P',4705), ('OSB412P',4705), ('OSB4165P',4705), ('OSB4166P',4705), ('OSB4167P',4705), ('OSB4183P',4705), ('OSB4195P',4705), ('OSB420P',4705), ('OSB427P',4705), ('OSB429P',4705), ('OSB430P',4705), ('OSB431P',4705), ('OSB432P',4705), ('OSB438P',4705), ('OSB441P',4705), ('OSB444P',4705), ('OSB455P',4705), ('OSB457P',4705), ('OSB458P',4705), ('OSB460P',4705), ('OSB461P',4705), ('OSB464P',4705), ('OSB472P',4705), ('OSB473P',4705), ('OSB474P',4705), ('OSB476P',4705), ('OSB477P',4705), ('OSB478P',4705), ('OSB494P',4705), ('OSB495P',4705), ('OSB496P',4705), ('OSB497P',4705), ('OSC414P',4705), ('OSF406P',4705), ('OSF420P',4705), ('OSF425P',4705), ('OSV407P',4705), ('TPE009',4705), ('LVAT108',4564), ('LVCT129',4564), ('LVOS1032',4564), ('LVOS1107',4564), ('LVOS1114',4564), ('LVOS1145',4564), ('LVOS1146',4564), ('LVOS1148',4564), ('LVOS1154',4564), ('LVOS1208',4564), ('LVOS1220',4564), ('LVOS1237',4564), ('LVOS1253',4564), ('LVOS1303',4564), ('LVOS1326',4564), ('LVOS1363',4564), ('LVOS1367',4564), ('LVOS1378',4564), ('LVOS1387',4564), ('LVOS1411',4564), ('LVOS1439',4564), ('LVOS1471',4564), ('LVOS1476',4564), ('LVOS1479',4564), ('LVOS1484',4564), ('LVOS1516',4564), ('LVOS1546',4564), ('LVOS1554',4564), ('LVOS1560',4564), ('LVOS1566',4564), ('LVOS1570',4564), ('LVOS1671',4564), ('LVOS1699',4564), ('LVOS1700',4564), ('LVOS1703',4564), ('LVOS1714',4564), ('LVOS1739',4564), ('LVOS1746',4564), ('LVOS1762',4564), ('LVOS1766',4564), ('LVOS1777',4564), ('LVOS1787',4564), ('LVOS1799',4564), ('LVOS1808',4564), ('LVOS1824',4564), ('LVOS1825',4564), ('LVOS1850',4564), ('LVOS1909',4564), ('LVOS1946',4564), ('LVOS1948',4564), ('LVOS6027',4564), ('LVOS6046',4564), ('LVOS6206',4564), ('LVOS6978',4564), ('LVRC124',4564), ('LVRC274',4564), ('LVRC282',4564), ('LVRC307',4564), ('LVRC370',4564), ('LVRC482',4564), ('LVRC517',4564), ('LVRC539',4564), ('LVRP222',4564), ('LVRP258',4564), ('LVRP368',4564), ('LVTP137',4564), ('VRC132',4564), ('CPS4022',6420), ('CPS4038',6420), ('CPS4043',6420), ('CPS4044',6420), ('CPS4045',6420), ('1KR521',388), ('1KR619',388), ('M23377',6533), ('M23382',6533), ('4058',320), ('5064',320), ('5067',320), ('70306',320), ('70508',320), ('7051',320), ('70510',320), ('70515',320), ('7262',320), ('782040040',320), ('782040082',320), ('782640130',320), ('785240030',320), ('785240040',320), ('785240045',320), ('796040046',320), ('882040030',320), ('882040040',320), ('882040046',320), ('882140042',320), ('882140088',320), ('882140145',320), ('882140170',320), ('882640057',320), ('882640070',320), ('882640085',320), ('882640106',320), ('882640125',320), ('882640150',320), ('882640186',320), ('882940144',320), ('883440043',320), ('883440090',320), ('883440100',320), ('883440120',320), ('883440202',320), ('883945039',320), ('885240035',320), ('885240045',320), ('885340026',320), ('885340032',320), ('885340040',320), ('885340045',320), ('885340046',320), ('885340050',320), ('885340059',320), ('885340063',320), ('885340090',320), ('885740033',320), ('887340046',320), ('887340052',320), ('887340065',320), ('887640051',320), ('887640058',320), ('887640072',320), ('887640090',320), ('887640114',320), ('887640130',320), ('887640145',320), ('887642057M3',320) ) 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.