SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM ( VALUES ('0258003300', 30), ('0258986502', 30), ('0412', 15), ('93111', 15), ('02469', 4683), ('03185', 4683), ('04820', 4683), ('10539', 4683), ('POS013', 4558), ('SLS13168', 374), ('SLS13183', 374), ('SLS13192', 374), ('SLS13214', 374), ('SLS13222', 374), ('SLS13225', 374), ('SLS13237', 374), ('SLS13290', 374), ('SLS13291', 374), ('SLS13292', 374), ('SLS13293', 374), ('SLS13294', 374), ('SLS13295', 374), ('SLS13296', 374), ('SLS13297', 374), ('SLS13299', 374), ('SLS13300', 374), ('SLS60469', 374), ('SLS60470', 374), ('43M03', 257), ('43N08', 257), ('43SU02', 257), ('DOX1545', 257), ('920046316', 442), ('79027', 4495), ('AS2107', 4737), ('AS2200', 4737), ('150033510', 323), ('150033610', 323), ('0011026671', 4995), ('OXY308037', 194), ('OXY308055', 194), ('OXY308091', 194), ('OXY321036', 194), ('OXY321060', 194), ('OXY321071', 194), ('OXY333058', 194), ('OXY356040', 194), ('OXY432061', 194), ('OZH003', 6444), ('OZH006', 6444), ('OZH007', 6444), ('OZH009', 6444), ('OZH010', 6444), ('OZH011', 6444), ('OZH017', 6444), ('OZH019', 6444), ('OZH022', 6444), ('OZH026', 6444), ('OZH027', 6444), ('OZH028', 6444), ('OZH032', 6444), ('OZH033', 6444), ('OZH037', 6444), ('OZH040', 6444), ('OZH044', 6444), ('OZH046', 6444), ('OZH047', 6444), ('OZH052', 6444), ('OZH056', 6444), ('OZH058', 6444), ('OZH066', 6444), ('OZH095', 6444), ('OZH100', 6444), ('OZH103', 6444), ('OZH107', 6444), ('OZH108', 6444), ('OZH125', 6444), ('OZH139', 6444), ('OZH142', 6444), ('OZH147', 6444), ('OZH155', 6444), ('OZH157', 6444), ('OZH158', 6444), ('OZH160', 6444), ('OZH196', 6444), ('OZH201', 6444), ('OZH207', 6444), ('OZH225', 6444), ('OZU001', 6444), ('ADJ137006', 350), ('ADJ137007', 350), ('ADN17001', 350), ('ADN17011', 350), ('ADN17042', 350), ('ADS77005', 350), ('ADS77010', 350), ('ADS77016', 350), ('0258003001', 30), ('0258003003', 30), ('0258003004', 30), ('0258003005', 30), ('0258003006', 30), ('0258003008', 30), ('0258003009', 30), ('0258003011', 30), ('0258003012', 30), ('0258003017', 30), ('0258003019', 30), ('0258003021', 30), ('0258003027', 30), ('0258003030', 30), ('0258003032', 30), ('0258003035', 30), ('0258003046', 30), ('0258003047', 30), ('0258003048', 30), ('0258003049', 30), ('0258003058', 30), ('0258003060', 30), ('0258003061', 30), ('0258003063', 30), ('0258003075', 30), ('0258003077', 30), ('0258003081', 30), ('0258003083', 30), ('0258003084', 30), ('0258003085', 30), ('0258003097', 30), ('0258003101', 30), ('0258003112', 30), ('0258003130', 30), ('0258003134', 30), ('0258003136', 30), ('0258003138', 30), ('0258003139', 30), ('0258003141', 30), ('0258003144', 30), ('0258003146', 30), ('0258003156', 30), ('0258003160', 30), ('0258003164', 30), ('0258003165', 30), ('0258003181', 30), ('0258003189', 30), ('0258003190', 30), ('0258003194', 30), ('0258003206', 30), ('0258003209', 30), ('0258003211', 30), ('0258003232', 30), ('0258003241', 30), ('0258003254', 30), ('0258003256', 30), ('0258003263', 30), ('0258003276', 30), ('0258003277', 30), ('0258003281', 30), ('0258003291', 30), ('0258003295', 30), ('0258003311', 30), ('0258003313', 30), ('0258003328', 30), ('0258003331', 30), ('0258003344', 30), ('0258003390', 30), ('0258003396', 30), ('0258003445', 30), ('0258003446', 30), ('0258003447', 30), ('0258003448', 30), ('0258003503', 30), ('0258003508', 30), ('0258003524', 30), ('0258003554', 30), ('0258003569', 30), ('0258003570', 30), ('0258003604', 30), ('0258003624', 30), ('0258003703', 30), ('0258003704', 30), ('0258003715', 30), ('0258003763', 30), ('0258003765', 30), ('0258003766', 30), ('0258003797', 30), ('0258003852', 30), ('0258003892', 30), ('0258003913', 30), ('0258003915', 30), ('0258003918', 30), ('0258003924', 30), ('0258003925', 30), ('0258003926', 30), ('0258003930', 30), ('0258003950', 30), ('0258003953', 30), ('0258003957', 30), ('0258003973', 30), ('0258003979', 30), ('0258003995', 30), ('0258005115', 30), ('0258005211', 30), ('0258005274', 30), ('0258005323', 30), ('0258005328', 30), ('0258005329', 30), ('0258005334', 30), ('0258005701', 30), ('0258005725', 30), ('0258005726', 30), ('0258005737', 30), ('0258986501', 30), ('0258986503', 30), ('0258986504', 30), ('0258986506', 30), ('0986258009', 30), ('F00HL00006', 30), ('F00HL00018', 30), ('F00HL00020', 30), ('F00HL00038', 30), ('F00HL00053', 30), ('F00HL00083', 30), ('F00HL00108', 30), ('F00HL00114', 30), ('F00HL00117', 30), ('F00HL00130', 30), ('F00HL00149', 30), ('F00HL00162', 30), ('F00HL00205', 30), ('F00HL00206', 30), ('F00HL00233', 30), ('LS030079', 215), ('LS130001', 215), ('LS130002', 215), ('LS130005', 215), ('LS130007', 215), ('LS130008', 215), ('LS130010', 215), ('LS130013', 215), ('LS130014', 215), ('LS130015', 215), ('LS130019', 215), ('LS130020', 215), ('LS130022', 215), ('LS130023', 215), ('LS130026', 215), ('LS130028', 215), ('LS130031', 215), ('LS130033', 215), ('LS130040', 215), ('LS130054', 215), ('LS130078', 215), ('LS130081', 215), ('LS130089', 215), ('LS130091', 215), ('LS130092', 215), ('LS130101', 215), ('LS130104', 215), ('LS130107', 215), ('LS130111', 215), ('LS130112', 215), ('LS130113', 215), ('LS130119', 215), ('LS130120', 215), ('LS130124', 215), ('LS130128', 215), ('LS130130', 215), ('LS130176', 215), ('LS130216', 215), ('LS130252', 215), ('LS130253', 215), ('LS130254', 215), ('LS130255', 215), ('LS130256', 215), ('LS140328', 215), ('LS140449', 215), ('LS140574', 215), ('65819', 4604), ('6771', 4604), ('221825018155C', 83), ('A2C59513183Z', 83), ('A2C59513192Z', 83), ('A2C59513214Z', 83), ('A2C59513222Z', 83), ('A2C59513225Z', 83), ('A2C59513237Z', 83), ('A2C59513290Z', 83), ('A2C59513291Z', 83), ('A2C59513292Z', 83), ('A2C59513293Z', 83), ('A2C59513294Z', 83), ('A2C59513295Z', 83), ('A2C59513296Z', 83), ('A2C59513297Z', 83), ('A2C59513299Z', 83), ('A2C59513300Z', 83), ('A2C59513457Z', 83), ('A2C59513458Z', 83), ('A2C59513866Z', 83), ('A2C59513867Z', 83), ('A2C59513868Z', 83), ('CSL2002', 4334), ('CSL2004', 4334), ('CSL2005', 4334), ('CSL2019', 4334), ('CSL2020', 4334), ('CSL2021', 4334), ('CSL2036', 4334), ('CSL2088', 4334), ('CSL2112', 4334), ('CSL2115', 4334), ('CSL2129', 4334), ('CSL2230', 4334), ('CSL2231', 4334), ('CSL2732', 4334), ('CST9566', 4334), ('ES1000512B1', 89), ('ES1004712B1', 89), ('ES10134', 89), ('ES1013512B1', 89), ('ES1018012B1', 89), ('ES1023412B1', 89), ('ES10240', 89), ('ES1024012B1', 89), ('ES10242', 89), ('ES1024212B1', 89), ('ES10258', 89), ('ES1025812B1', 89), ('ES1026012B1', 89), ('ES10262', 89), ('ES1026212B1', 89), ('ES10289', 89), ('ES1028912B1', 89), ('ES10295', 89), ('ES1029512B1', 89), ('ES10301', 89), ('ES1030111B1', 89), ('ES1033112B1', 89), ('ES1037712B1', 89), ('ES1038312B1', 89), ('ES10456', 89), ('ES1045612B1', 89), ('ES1064911B1', 89), ('ES10680', 89), ('ES1068011B1', 89), ('ES1068012B1', 89), ('ES1068112B1', 89), ('ES1068512B1', 89), ('ES10686', 89), ('ES1068611B1', 89), ('ES10687', 89), ('ES1068711B1', 89), ('ES10688', 89), ('ES1076212B1', 89), ('ES1082012B1', 89), ('ES10957', 89), ('ES1095712B1', 89), ('ES10958', 89), ('ES1096712B1', 89), ('ES1096812B1', 89), ('ES1096912B1', 89), ('ES1097012B1', 89), ('ES1097112B1', 89), ('ES10973', 89), ('ES10975', 89), ('ES1099012B1', 89), ('ES1099112B1', 89), ('ES1099212B1', 89), ('ES1099312B1', 89), ('ES1099512B1', 89), ('ES1099612B1', 89), ('ES1100012B1', 89), ('ES1100912B1', 89), ('ES1101012B1', 89), ('ES2002512B1', 89), ('ES2004512B1', 89), ('ES2004612B1', 89), ('ES20056', 89), ('ES2023812B1', 89), ('ES2024412B1', 89), ('ES2064012B1', 89), ('DOX0115', 4760), ('DOX0116', 4760), ('DOX0120', 4760), ('DOX1023', 4760), ('DOX1025', 4760), ('DOX1031', 4760), ('DOX1311', 4760), ('DOX1350', 4760), ('DOX1351', 4760), ('DOX1352', 4760), ('DOX1373', 4760), ('DOX1376', 4760), ('DOX1377', 4760), ('DOX1378', 4760), ('DOX1379', 4760), ('DOX1381', 4760), ('DOX1446', 4760), ('DOX1500', 4760), ('DOX1501', 4760), ('DOX1502', 4760), ('DOX1503', 4760), ('DOX1593', 4760), ('DOX1594', 4760), ('INJLS032N', 4882), ('INJLS087N', 4882), ('INJLS153N', 4882), ('INJLS154N', 4882), ('INJLS155N', 4882), ('INJLS156N', 4882), ('INJLS157N', 4882), ('1180540', 355), ('1180541', 355), ('681020', 355), ('LSK038', 488), ('EV0189', 4344), ('EX0069', 4344), ('EX0070', 4344), ('EX0092', 4344), ('EX0151', 4344), ('EX0267', 4344), ('XLS1067', 4344), ('XLS1095', 4344), ('XLS1096', 4344), ('XLS1246', 4344), ('XLS1480', 4344), ('XTS8117', 4344), ('ENT600007', 6889), ('ENT600009', 6889), ('1997003', 4005), ('1997005', 4005), ('1997023', 4005), ('1997025', 4005), ('1997026', 4005), ('1997028', 4005), ('1997030', 4005), ('1997031', 4005), ('1997042', 4005), ('1997045', 4005), ('1997048', 4005), ('1997051', 4005), ('1997053', 4005), ('1997058', 4005), ('1997060', 4005), ('1997062', 4005), ('1997106', 4005), ('1997110', 4005), ('1997264', 4005), ('1997265', 4005), ('1997279', 4005), ('1997284', 4005), ('1997300', 4005), ('1997327', 4005), ('1997346', 4005), ('1997347', 4005), ('1997396', 4005), ('1997624', 4005), ('1997866', 4005), ('1997909', 4005), ('1997912', 4005), ('1998059', 4005), ('570006', 234), ('570011', 234), ('570040A', 234), ('570050A', 234), ('570058A', 234), ('570064A', 234), ('570074A', 234), ('570082A', 234), ('570089', 234), ('570089A', 234), ('570090', 234), ('570090A', 234), ('570126', 234), ('570126A', 234), ('570151A', 234), ('570172', 234), ('570172A', 234), ('570177', 234), ('570178', 234), ('570178A', 234), ('570179', 234), ('570180', 234), ('570180A', 234), ('570186', 234), ('570186A', 234), ('570187', 234), ('570233A', 234), ('09SKV009', 4969), ('09SKV010', 4969), ('09SKV014', 4969), ('09SKV016', 4969), ('09SKV018', 4969), ('09SKV019', 4969), ('09SKV020', 4969), ('09SKV021', 4969), ('09SKV033', 4969), ('09SKV047', 4969), ('09SKV051', 4969), ('09SKV052', 4969), ('09SKV063', 4969), ('09SKV066', 4969), ('09SKV068', 4969), ('09SKV076', 4969), ('09SKV089', 4969), ('09SKV096', 4969), ('09SKV532', 4969), ('09SKV533', 4969), ('09SKV534', 4969), ('09SKV535', 4969), ('09SKV536', 4969), ('09SKV537', 4969), ('09SKV538', 4969), ('09SKV539', 4969), ('09SKV540', 4969), ('09SKV541', 4969), ('09SKV543', 4969), ('09SKV544', 4969), ('09SKV545', 4969), ('09SKV546', 4969), ('09SKV547', 4969), ('09SKV548', 4969), ('09SKV549', 4969), ('09SKV550', 4969), ('09SKV551', 4969), ('09SKV552', 4969), ('09SKV553', 4969), ('09SKV565', 4969), ('09SKV599', 4969), ('09SKV610', 4969), ('09SKV660', 4969), ('09SKV661', 4969), ('09SKV662', 4969), ('09SKV663', 4969), ('09SKV664', 4969), ('09SKV721', 4969), ('09SKV722', 4969), ('09SKV901', 4969), ('09SKV903', 4969), ('09SKV904', 4969), ('09SKV909', 4969), ('09SKV913', 4969), ('030906265', 6367), ('E144001', 4391), ('E144002', 4391), ('E144005', 4391), ('E144008', 4391), ('107003', 4005), ('107005', 4005), ('107023', 4005), ('107025', 4005), ('107026', 4005), ('107028', 4005), ('107030', 4005), ('107031', 4005), ('107042', 4005), ('107045', 4005), ('107048', 4005), ('107051', 4005), ('107053', 4005), ('107058', 4005), ('107060', 4005), ('107062', 4005), ('107106', 4005), ('107110', 4005), ('107264', 4005), ('107265', 4005), ('107279', 4005), ('107284', 4005), ('107300', 4005), ('107327', 4005), ('107346', 4005), ('107347', 4005), ('107396', 4005), ('107624', 4005), ('107866', 4005), ('107909', 4005), ('107912', 4005), ('108059', 4005), ('77105', 240), ('77106', 240), ('77107', 240), ('77108', 240), ('77109', 240), ('77111', 240), ('77113', 240), ('77114', 240), ('77115', 240), ('77116', 240), ('77117', 240), ('77118', 240), ('77119', 240), ('77120', 240), ('77121', 240), ('77122', 240), ('77191', 240), ('77199', 240), ('77221', 240), ('77228', 240), ('77229', 240), ('77230', 240), ('77231', 240), ('77306', 240), ('77307', 240), ('77317', 240), ('77370', 240), ('77377', 240), ('77378', 240), ('77381', 240), ('77390', 240), ('77466', 240), ('77467', 240), ('77472', 240), ('77478', 240), ('77479', 240), ('77779', 240), ('21355', 101), ('21419', 101), ('21421', 101), ('21424', 101), ('21430', 101), ('21432', 101), ('21434', 101), ('21436', 101), ('XL782130041', 415), ('XL782230057', 415), ('XL782630110', 415), ('XL782730050', 415), ('XL782730098', 415), ('XL782730125', 415), ('XL782730170', 415), ('XL783031072', 415), ('90002', 441), ('90004', 441), ('90004A2', 441), ('90004HQ', 441), ('90005', 441), ('90013', 441), ('90014', 441), ('90016', 441), ('90017', 441), ('90019', 441), ('90019A2', 441), ('90019HQ', 441), ('90020', 441), ('90021', 441), ('90036', 441), ('90042', 441), ('90042A2', 441), ('90043', 441), ('90048', 441), ('90054', 441), ('90054A2', 441), ('90054HQ', 441), ('90055', 441), ('90055A2', 441), ('90055HQ', 441), ('90070', 441), ('90070A2', 441), ('90070HQ', 441), ('90073', 441), ('90073A2', 441), ('90073HQ', 441), ('90077', 441), ('90077A2', 441), ('90077HQ', 441), ('90085', 441), ('90088', 441), ('90094', 441), ('90097', 441), ('90108', 441), ('90110', 441), ('90110A2', 441), ('90111', 441), ('90112', 441), ('90115', 441), ('90125', 441), ('90125A2', 441), ('90129', 441), ('90143', 441), ('90204', 441), ('90205', 441), ('90230', 441), ('90231', 441), ('90336', 441), ('90600', 441), ('90600A2', 441), ('GO8370', 4933), ('970251', 4379), ('970471', 4379), ('970581', 4379), ('181732', 4819), ('181751', 4819), ('181760', 4819), ('181773', 4819), ('181780', 4819), ('181791', 4819), ('181833', 4819), ('181839', 4819), ('181850', 4819), ('182956', 4819), ('6PA009166901', 4734), ('6PA358066911', 4734), ('6PA358066921', 4734), ('6PA358103311', 4734), ('J1460303', 72), ('J1461006', 72), ('J1461009', 72), ('J1461017', 72), ('J1461018', 72), ('J1463015', 72), ('J1467004', 72), ('J1467006', 72), ('J1470306', 72), ('J1477001', 72), ('7481000', 341), ('74810001', 341), ('7481000OQ', 341), ('7481001', 341), ('7481001E', 341), ('7481004', 341), ('7481006', 341), ('7481007', 341), ('7481008', 341), ('7481011', 341), ('7481014', 341), ('7481014E', 341), ('7481014OQ', 341), ('7481015', 341), ('7481015E', 341), ('7481016', 341), ('7481016E', 341), ('7481017', 341), ('7481017E', 341), ('7481018', 341), ('7481019', 341), ('7481021', 341), ('7481021OQ', 341), ('7481022', 341), ('7481022E', 341), ('7481039', 341), ('7481042', 341), ('7481043', 341), ('7481053', 341), ('7481054', 341), ('7481058', 341), ('7481061', 341), ('7481063', 341), ('7481063OQ', 341), ('7481064', 341), ('7481065', 341), ('7481066', 341), ('7481069', 341), ('7481070', 341), ('7481072', 341), ('7481087', 341), ('7481087E', 341), ('7481093', 341), ('74811002', 341), ('7481515', 341), ('7481515E', 341), ('7481518', 341), ('7481588', 341), ('7481589', 341), ('7481618', 341), ('7481619', 341), ('7481660', 341), ('7481663', 341), ('7481665', 341), ('7481704', 341), ('64003', 269), ('64004', 269), ('64005', 269), ('64006', 269), ('64012', 269), ('64015', 269), ('64016', 269), ('64017', 269), ('64030', 269), ('64031', 269), ('64032', 269), ('64033', 269), ('64035', 269), ('64039', 269), ('64040', 269), ('64043', 269), ('64051', 269), ('64054', 269), ('64055', 269), ('64056', 269), ('64057', 269), ('64059', 269), ('64061', 269), ('64071', 269), ('64072', 269), ('64073', 269), ('64075', 269), ('64081', 269), ('64082', 269), ('64089', 269), ('64090', 269), ('64093', 269), ('64095', 269), ('64102', 269), ('64107', 269), ('64111', 269), ('64113', 269), ('64125', 269), ('64134', 269), ('64135', 269), ('64137', 269), ('64148', 269), ('64155', 269), ('64170', 269), ('64189', 269), ('64215', 269), ('64226', 269), ('64227', 269), ('64231', 269), ('64265', 269), ('64288', 269), ('64291', 269), ('64403', 269), ('64423', 269), ('64440', 269), ('64523', 269), ('64554', 269), ('64558', 269), ('64563', 269), ('64568', 269), ('64578', 269), ('64698', 269), ('64750', 269), ('64751', 269), ('64785', 269), ('64808', 269), ('64836', 269), ('64858', 269), ('SD11161', 6387), ('DOX1545', 156), ('OOM03', 156), ('OON08', 156), ('OOSU02', 156), ('3M03', 481), ('3N08', 481), ('3SU02', 481), ('DOX1545', 481), ('LSO1010001', 138), ('LSO5014001', 138), ('LSO5527001', 138), ('1193800600', 268), ('1293800200', 268), ('EOS3029', 201), ('EOS3072', 201), ('EOS4010', 201), ('EOS4521', 201), ('EOS6503', 201), ('EOS6507', 201), ('EOS6508', 201), ('EOS6515', 201), ('EOS6518', 201), ('EOS6520', 201), ('EOS6522', 201), ('EOS6524', 201), ('EOS6525', 201), ('EOS6528', 201), ('EOS6540', 201), ('EOS6541', 201), ('EOS6553', 201), ('EOS8010', 201), ('EOS8016', 201), ('884510005', 286), ('884512030', 286), ('884514105', 286), ('884514108', 286), ('884514119', 286), ('884514132', 286), ('884514168', 286), ('884514500', 286), ('884514505', 286), ('884523060', 286), ('884524037', 286), ('884524057', 286), ('884524127', 286), ('884525006', 286), ('884525009', 286), ('884525011', 286), ('884525037', 286), ('884525051', 286), ('884529051', 286), ('884529221', 286), ('884543017', 286), ('884543132', 286), ('884543543', 286), ('884550043', 286), ('884550502', 286), ('884568505', 286), ('884568509', 286), ('49011Z', 387), ('49013Z', 387), ('49014Z', 387), ('49016Z', 387), ('49023Z', 387), ('49034Z', 387), ('49504Z', 387), ('49506Z', 387), ('49507Z', 387), ('49508Z', 387), ('497003', 4006), ('497005', 4006), ('497023', 4006), ('497025', 4006), ('497026', 4006), ('497028', 4006), ('497030', 4006), ('497031', 4006), ('497042', 4006), ('497045', 4006), ('497048', 4006), ('497051', 4006), ('497053', 4006), ('497058', 4006), ('497060', 4006), ('497062', 4006), ('497106', 4006), ('497110', 4006), ('497264', 4006), ('497265', 4006), ('497279', 4006), ('497284', 4006), ('497300', 4006), ('497327', 4006), ('497346', 4006), ('497347', 4006), ('497396', 4006), ('497624', 4006), ('497866', 4006), ('497909', 4006), ('497912', 4006), ('498059', 4006), ('LLB003', 6518), ('LLB004', 6518), ('LLB005', 6518), ('LLB006', 6518), ('LLB013', 6518), ('LLB023', 6518), ('LLB024', 6518), ('LLB025', 6518), ('LLB031', 6518), ('LLB037', 6518), ('LLB044', 6518), ('LLB046', 6518), ('LLB049', 6518), ('LLB055', 6518), ('LLB058', 6518), ('LLB060', 6518), ('LLB069', 6518), ('LLB071', 6518), ('LLB100', 6518), ('LLB1000', 6518), ('LLB107', 6518), ('LLB122', 6518), ('LLB137', 6518), ('LLB162', 6518), ('LLB172', 6518), ('LLB173', 6518), ('LLB175', 6518), ('LLB231', 6518), ('LLB234', 6518), ('LLB333', 6518), ('LLB352', 6518), ('LLB370', 6518), ('LLB449', 6518), ('LLB485', 6518), ('LLB489', 6518), ('LLB497', 6518), ('LLB512', 6518), ('LLB656', 6518), ('LLB720', 6518), ('LLB721', 6518), ('LLB753', 6518), ('LLB776', 6518), ('LLB819', 6518), ('LLB840', 6518), ('LLB947', 6518), ('LLB949', 6518), ('LLB950', 6518), ('LLB951', 6518), ('LLB954', 6518), ('LLB956', 6518), ('LLB957', 6518), ('LLB958', 6518), ('LLB959', 6518), ('LLB960', 6518), ('LLB962', 6518), ('LLB965', 6518), ('LLB966', 6518), ('LLB968', 6518), ('LLB969', 6518), ('LLB972', 6518), ('LLB974', 6518), ('LEB128', 4501), ('LEB133', 4501), ('LEB151', 4501), ('LEB168', 4501), ('LEB181', 4501), ('LEB208', 4501), ('LEB214', 4501), ('LEB244', 4501), ('LEB265', 4501), ('LEB268', 4501), ('LEB291', 4501), ('LEB320', 4501), ('LEB323', 4501), ('LEB327', 4501), ('LEB364', 4501), ('LEB367', 4501), ('LEB369', 4501), ('LEB392', 4501), ('LEB394', 4501), ('LEB399', 4501), ('LEB400', 4501), ('LEB401', 4501), ('LEB403', 4501), ('LEB4033', 4501), ('LEB4048', 4501), ('LEB414', 4501), ('LEB5001', 4501), ('LEB5006', 4501), ('LEB5007', 4501), ('LEB5009', 4501), ('LEB5010', 4501), ('LEB5013', 4501), ('LEB5014', 4501), ('LEB5018', 4501), ('LEB5020', 4501), ('LEB5023', 4501), ('LEB5027', 4501), ('LEB5030', 4501), ('LEB5235', 4501), ('LEB524', 4501), ('LEB5252', 4501), ('LEB526', 4501), ('LEB5345', 4501), ('LEB5436', 4501), ('LEB5437', 4501), ('LEB552', 4501), ('LEB555', 4501), ('LEB556', 4501), ('LEB686', 4501), ('LEB692', 4501), ('LEB712', 4501), ('LEB732', 4501), ('LEB758', 4501), ('LEB759', 4501), ('LEB762', 4501), ('LEB804', 4501), ('LEB862', 4501), ('LEB880', 4501), ('LEB928', 4501), ('LEB959', 4501), ('LEB963', 4501), ('LEB966', 4501), ('LEB974', 4501), ('LEB981', 4501), ('SEB527', 4501), ('171916011240', 4723), ('460000126010', 4723), ('460000128010', 4723), ('460000134010', 4723), ('460000147010', 4723), ('460000150010', 4723), ('460000155010', 4723), ('460000158010', 4723), ('460000188010', 4723), ('460000194010', 4723), ('460000218010', 4723), ('460000237010', 4723), ('460000251010', 4723), ('460000256010', 4723), ('460000269010', 4723), ('460000280010', 4723), ('460000291010', 4723), ('460000402010', 4723), ('460000450010', 4723), ('460000457010', 4723), ('460000460010', 4723), ('460000461010', 4723), ('460000472010', 4723), ('460000483010', 4723), ('460001827010', 4723), ('460001833010', 4723), ('460001837010', 4723), ('460001838010', 4723), ('460001848010', 4723), ('460001855010', 4723), ('460001859010', 4723), ('460001861010', 4723), ('460001866010', 4723), ('460001872010', 4723), ('460001877010', 4723), ('460001878010', 4723), ('460001887010', 4723), ('460001898010', 4723), ('460002140810', 4723), ('460002145710', 4723), ('460002145810', 4723), ('460002146110', 4723), ('466016355069', 4723), ('466016355078', 4723), ('466016355088', 4723), ('466016355098', 4723), ('466016355197', 4723), ('USL03PCSMS', 358), ('590001', 403), ('590002', 403), ('590004', 403), ('590007', 403), ('590008', 403), ('590009', 403), ('590010', 403), ('590012', 403), ('590016', 403), ('590017', 403), ('590019', 403), ('590020', 403), ('590038', 403), ('590039', 403), ('590051', 403), ('590052', 403), ('590064', 403), ('EPS1997003', 4773), ('EPS1997005', 4773), ('EPS1997023', 4773), ('EPS1997025', 4773), ('EPS1997026', 4773), ('EPS1997028', 4773), ('EPS1997030', 4773), ('EPS1997031', 4773), ('EPS1997042', 4773), ('EPS1997045', 4773), ('EPS1997048', 4773), ('EPS1997051', 4773), ('EPS1997053', 4773), ('EPS1997058', 4773), ('EPS1997060', 4773), ('EPS1997062', 4773), ('EPS1997106', 4773), ('EPS1997110', 4773), ('EPS1997264', 4773), ('EPS1997265', 4773), ('EPS1997279', 4773), ('EPS1997284', 4773), ('EPS1997300', 4773), ('EPS1997327', 4773), ('EPS1997346', 4773), ('EPS1997347', 4773), ('EPS1997396', 4773), ('EPS1997624', 4773), ('EPS1997866', 4773), ('EPS1997909', 4773), ('EPS1997912', 4773), ('EPS1998059', 4773), ('MLS9M03', 4773), ('MLS9N08', 4773), ('MLS9SU02', 4773), ('81000', 244), ('810001', 244), ('81000OQ', 244), ('81001', 244), ('81001E', 244), ('81004', 244), ('81006', 244), ('81007', 244), ('81008', 244), ('81011', 244), ('81014', 244), ('81014E', 244), ('81014OQ', 244), ('81015', 244), ('81015E', 244), ('81016', 244), ('81016E', 244), ('81017', 244), ('81017E', 244), ('81018', 244), ('81019', 244), ('81021', 244), ('81021OQ', 244), ('81022', 244), ('81022E', 244), ('81039', 244), ('81042', 244), ('81043', 244), ('81053', 244), ('81054', 244), ('81058', 244), ('81061', 244), ('81063', 244), ('81063OQ', 244), ('81064', 244), ('81065', 244), ('81066', 244), ('81069', 244), ('81070', 244), ('81072', 244), ('81087', 244), ('81087E', 244), ('81093', 244), ('811002', 244), ('81515', 244), ('81515E', 244), ('81518', 244), ('81588', 244), ('81589', 244), ('81618', 244), ('81619', 244), ('81660', 244), ('81663', 244), ('81665', 244), ('81704', 244), ('0893019', 94), ('0893042', 94), ('0893043', 94), ('0893053', 94), ('0893054', 94), ('0893149', 94), ('0893150', 94), ('0893162', 94), ('0893163', 94), ('0893246', 94), ('0893247', 94), ('0893271', 94), ('0893294', 94), ('0893341', 94), ('0893385', 94), ('0895166', 94), ('0895196', 94), ('0895212', 94), ('1009000000', 144), ('1148030024', 144), ('1148030027', 144), ('OSA301P', 4705), ('OSB301P', 4705), ('OSB306P', 4705), ('OSB307P', 4705), ('OSB308P', 4705), ('OSB309P', 4705), ('OSB311P', 4705), ('OSB312P', 4705), ('OSB313P', 4705), ('OSB317P', 4705), ('OSB420P', 4705), ('OSC301P', 4705), ('OSC424P', 4705), ('OSF303P', 4705), ('OSF306P', 4705), ('OSG301P', 4705), ('OSG302P', 4705), ('OSK403P', 4705), ('OSN301P', 4705), ('OSN302P', 4705), ('OSN303P', 4705), ('OSN304P', 4705), ('OSN305P', 4705), ('OSN306P', 4705), ('OSN307P', 4705), ('OSN308P', 4705), ('OSN311P', 4705), ('OSN402P', 4705), ('OSR301P', 4705), ('OSR303P', 4705), ('OSR304P', 4705), ('OSR305P', 4705), ('OSR306P', 4705), ('OSS301P', 4705), ('OSS302P', 4705), ('OSS303P', 4705), ('OSS304P', 4705), ('OSU301P', 4705), ('OSU304P', 4705), ('OSV301P', 4705), ('OSV302P', 4705), ('OSV303P', 4705), ('OSY301P', 4705), ('OSZ301P', 4705), ('OSZ302P', 4705), ('OSZ304P', 4705), ('OSZ403P', 4705), ('LVOS1124', 4564), ('LVOS1140', 4564), ('LVOS1166', 4564), ('LVOS1207', 4564), ('LVOS1242', 4564), ('LVOS1261', 4564), ('LVOS1270', 4564), ('LVOS1313', 4564), ('LVOS1317', 4564), ('LVOS1337', 4564), ('LVOS1347', 4564), ('LVOS1357', 4564), ('LVOS1360', 4564), ('LVOS1371', 4564), ('LVOS1375', 4564), ('LVOS1405', 4564), ('LVOS1413', 4564), ('LVOS1418', 4564), ('LVOS1420', 4564), ('LVOS1446', 4564), ('LVOS1447', 4564), ('LVOS1448', 4564), ('LVOS1462', 4564), ('LVOS1463', 4564), ('LVOS1494', 4564), ('LVOS1502', 4564), ('LVOS1530', 4564), ('LVOS1532', 4564), ('LVOS1534', 4564), ('LVOS1549', 4564), ('LVOS1550', 4564), ('LVOS1556', 4564), ('LVOS1558', 4564), ('LVOS1559', 4564), ('LVOS1573', 4564), ('LVOS1590', 4564), ('LVOS1597', 4564), ('LVOS1608', 4564), ('LVOS1611', 4564), ('LVOS1619', 4564), ('LVOS1634', 4564), ('LVOS1650', 4564), ('LVOS1696', 4564), ('LVOS1717', 4564), ('LVOS1745', 4564), ('LVOS1793', 4564), ('LVOS1798', 4564), ('LVOS1834', 4564), ('LVOS1837', 4564), ('LVOS1870', 4564), ('LVOS1879', 4564), ('LVOS1883', 4564), ('LVOS1911', 4564), ('LVOS1924', 4564), ('LVOS1959', 4564), ('M23381', 6533), ('781345040', 320), ('781630033', 320), ('781630040', 320), ('781630046', 320), ('781630057', 320), ('781630091', 320), ('781630122', 320), ('782030050', 320), ('782130041', 320), ('782230026', 320), ('782230031', 320), ('782230041', 320), ('782230057', 320), ('782230068', 320), ('782230088', 320), ('782230093', 320), ('782230182', 320), ('782330050', 320), ('782330064', 320), ('782330071', 320), ('782330074', 320), ('782330076', 320), ('782330094', 320), ('782330176', 320), ('782430057', 320), ('782530072', 320), ('782530120', 320), ('782530170', 320), ('782630050', 320), ('782630098', 320), ('782630110', 320), ('782630150', 320), ('782630190', 320), ('782730050', 320), ('782730072', 320), ('782730090', 320), ('782730098', 320), ('782730125', 320), ('782730170', 320), ('783030030', 320), ('783031030', 320), ('783031040', 320), ('783031072', 320), ('783440120', 320), ('783845046', 320), ('784141058', 320), ('784141072', 320), ('784141101', 320), ('784230061', 320), ('784430026', 320), ('784430095', 320), ('785131040', 320), ('786630030', 320), ('786630042', 320), ('786631038', 320), ('786830048', 320), ('787030051', 320), ('787030076', 320), ('787030096', 320), ('787130032', 320), ('787130056', 320), ('787430097', 320), ('788430057', 320), ('788430120', 320), ('789045032', 320), ('789630040', 320), ('789830090', 320), ('793930042', 320), ('795730030', 320), ('795730039', 320), ('795730070', 320), ('796330025', 320), ('796330045', 320), ('796330060', 320), ('796530035', 320), ('796530050', 320), ('796530090', 320), ('0123', 15), ('0126', 15), ('0128', 15), ('0134', 15), ('0139', 15), ('0147', 15), ('0150', 15), ('0155', 15), ('0158', 15), ('0162', 15), ('0177', 15), ('0188', 15), ('0193', 15), ('0194', 15), ('0204', 15), ('0215', 15), ('0226', 15), ('0237', 15), ('0256', 15), ('0258', 15), ('0269', 15), ('0280', 15), ('0289', 15), ('0291', 15), ('0450', 15), ('0457', 15), ('0460', 15), ('0461', 15), ('0472', 15), ('0483', 15), ('0495', 15), ('1535', 15), ('1639', 15), ('1729', 15), ('1730', 15), ('1737', 15), ('1826', 15), ('1827', 15), ('1833', 15), ('1837', 15), ('1838', 15), ('1848', 15), ('1855', 15), ('1859', 15), ('1860', 15), ('1861', 15), ('1866', 15), ('1872', 15), ('1877', 15), ('1878', 15), ('1887', 15), ('1898', 15), ('1951', 15), ('1952', 15), ('5680', 15), ('5709', 15), ('90019', 15), ('90368', 15), ('90474', 15), ('90545', 15), ('90698', 15), ('91071', 15), ('91157', 15), ('91204', 15), ('91454', 15), ('91575', 15), ('91773', 15), ('91941', 15), ('92016', 15), ('92076', 15), ('92134', 15), ('92272', 15), ('92497', 15), ('92592', 15), ('92656', 15), ('92939', 15), ('93087', 15), ('93211', 15), ('93395', 15), ('93429', 15), ('93521', 15), ('93792', 15), ('93986', 15), ('94426', 15), ('94650', 15), ('95175', 15), ('95257', 15), ('95555', 15), ('95599', 15), ('96121', 15), ('96560', 15), ('97037', 15), ('97675', 15), ('97757', 15), ('97952', 15), ('DOX0109', 440), ('DOX0115', 440), ('DOX0117', 440), ('DOX0120', 440), ('DOX1023', 440), ('DOX1025', 440), ('DOX1031', 440), ('DOX1350', 440), ('DOX1351', 440), ('DOX1352', 440), ('DOX1376', 440), ('DOX1377', 440), ('DOX1378', 440), ('DOX1379', 440), ('DOX1381', 440), ('DOX1446', 440), ('DOX1545', 440), ('ESLNS007', 6355), ('ESLSB001', 6355), ('ESLUV000', 6355), ('2376224', 4380), ('2376229', 4380), ('2376231', 4380), ('2376235', 4380), ('2376237', 4380), ('2376240', 4380), ('04815', 4683), ('05107', 4683), ('05480', 4683), ('05515', 4683), ('08282', 4683), ('08971', 4683), ('09104', 4683), ('09250', 4683), ('09254', 4683), ('09257', 4683), ('09258', 4683), ('09301', 4683), ('09302', 4683), ('09303', 4683), ('09304', 4683), ('09305', 4683), ('09313', 4683), ('10538', 4683), ('10540', 4683), ('10969', 4683), ('12318', 4683), ('16465', 4683), ('17548', 4683), ('17551', 4683), ('19112', 4683), ('19949', 4683), ('21160', 4683), ('21270', 4683), ('21271', 4683), ('34374', 4683), ('41060', 4683), ('41457', 4683), ('41478', 4683), ('41566', 4683), ('46994', 4683), ('47676', 4683), ('48747', 4683), ('60013', 4558), ('HZ109030171507', 4558), ('HZ303010060029', 4558), ('HZ303010060034', 4558), ('HZ303010060037', 4558), ('HZ303010060042', 4558), ('HZ303010060142', 4558), ('HZ303010110038', 4558), ('HZ308010200022', 4558), ('HZ308010200028', 4558), ('HZ308010200032', 4558), ('HZ403010030027', 4558), ('HZ403010250031', 4558), ('702604010', 5), ('702604030', 5), ('702604500', 5), ('702604680', 5), ('702604690', 5), ('702604700', 5), ('702604710', 5), ('705270240', 5), ('705270460', 5), ('705270470', 5), ('705270480', 5), ('705270490', 5), ('705270500', 5), ('705270510', 5), ('705270590', 5), ('705270600', 5), ('705270840', 5), ('40050002', 4686), ('40050003', 4686), ('40050006', 4686), ('40050009', 4686), ('XLOS1002', 57), ('XLOS1003', 57), ('XLOS1004', 57), ('XLOS1005', 57), ('XLOS1012', 57), ('XLOS1024', 57), ('XLOS1029', 57), ('XLOS1035', 57), ('XLOS1048', 57), ('XLOS1054', 57), ('XLOS1057', 57), ('XLOS1059', 57), ('XLOS1070', 57), ('XLOS1099', 57), ('XLOS1106', 57), ('XLOS1120', 57), ('XLOS1136', 57), ('XLOS1161', 57), ('XLOS1171', 57), ('XLOS1172', 57), ('XLOS1175', 57), ('XLOS1227', 57), ('XLOS1230', 57), ('XLOS1321', 57), ('XLOS1339', 57), ('XLOS1356', 57), ('XLOS1428', 57), ('XLOS1458', 57), ('XLOS1462', 57), ('XLOS1467', 57), ('XLOS1475', 57), ('XLOS1582', 57), ('XLOS1633', 57), ('XLOS1634', 57), ('XLOS1665', 57), ('XLOS1687', 57), ('XLOS1732', 57), ('3922L0003', 6358), ('3922L0031', 6358), ('3922L0033', 6358), ('3922L0043', 6358), ('3922L0047', 6358), ('3922L0075', 6358), ('3922L0076', 6358), ('3922L0078', 6358), ('3922L0082', 6358), ('3922L0094', 6358), ('3922L0101', 6358), ('3922L0107', 6358), ('3922L0130', 6358), ('3922L0135', 6358), ('3922L0139', 6358), ('3922L0154', 6358), ('3922L0157', 6358), ('3922L0197', 6358), ('3922L0219', 6358), ('3922L0222', 6358), ('3922L0223', 6358), ('3922L0224', 6358), ('3922L0226', 6358), ('203177', 4623), ('90002', 27), ('90004', 27), ('90004A2', 27), ('90004HQ', 27), ('90005', 27), ('90013', 27), ('90014', 27), ('90016', 27), ('90017', 27), ('90019', 27), ('90019A2', 27), ('90019HQ', 27), ('90020', 27), ('90021', 27), ('90036', 27), ('90042', 27), ('90042A2', 27), ('90043', 27), ('90048', 27), ('90054', 27), ('90054A2', 27), ('90054HQ', 27), ('90055', 27), ('90055A2', 27), ('90055HQ', 27), ('90070', 27), ('90070A2', 27), ('90070HQ', 27), ('90073', 27), ('90073A2', 27), ('90073HQ', 27), ('90077', 27), ('90077A2', 27), ('90077HQ', 27), ('90085', 27), ('90088', 27), ('90094', 27), ('90097', 27), ('90108', 27), ('90110', 27), ('90110A2', 27), ('90111', 27), ('90112', 27), ('90115', 27), ('90125', 27), ('90125A2', 27), ('90129', 27), ('90143', 27), ('90204', 27), ('90205', 27), ('90230', 27), ('90231', 27), ('90336', 27), ('90600', 27), ('90600A2', 27), ('SKLS0140002', 6357), ('SKLS0140030', 6357), ('SKLS0140032', 6357), ('SKLS0140042', 6357), ('SKLS0140046', 6357), ('SKLS0140072', 6357), ('SKLS0140076', 6357), ('SKLS0140081', 6357), ('SKLS0140083', 6357), ('SKLS0140093', 6357), ('SKLS0140094', 6357), ('SKLS0140096', 6357), ('SKLS0140111', 6357), ('SKLS0140132', 6357), ('SKLS0140144', 6357), ('SKLS0140155', 6357), ('SKLS0140205', 6357), ('SKLS0140217', 6357), ('SKLS0140220', 6357), ('SKLS0140235', 6357), ('SKLS0140297', 6357), ('SKLS0140309', 6357), ('SKLS0140326', 6357), ('SKLS0140332', 6357), ('VSOS0003', 4771), ('VSOS0007', 4771), ('VSOS0010', 4771), ('VSOS0012', 4771), ('VSOS0015', 4771), ('VSOS1403', 4771), ('2000001SX', 4595), ('2000003SX', 4595), ('2000004SX', 4595), ('2000006SX', 4595), ('2000010SX', 4595), ('2000020SX', 4595), ('2000027SX', 4595), ('2000036SX', 4595), ('2000042SX', 4595), ('2000048SX', 4595), ('2000057SX', 4595), ('2000058SX', 4595), ('2000060SX', 4595), ('2000068SX', 4595), ('2000093SX', 4595), ('2000135SX', 4595), ('2000146SX', 4595), ('2000161SX', 4595), ('2000179SX', 4595), ('2000306SX', 4595), ('99971', 6691), ('30921419', 151), ('30921421', 151), ('30921424', 151), ('30921430', 151), ('30921432', 151), ('30921434', 151), ('30921436', 151), ('60921355', 151), ('107542', 301), ('201752', 301), ('701078', 301), ('884510005', 108), ('884512014', 108), ('884512030', 108), ('884514105', 108), ('884514108', 108), ('884514119', 108), ('884514132', 108), ('884514168', 108), ('884514500', 108), ('884514505', 108), ('884523060', 108), ('884524037', 108), ('884524057', 108), ('884524127', 108), ('884525006', 108), ('884525009', 108), ('884525011', 108), ('884525037', 108), ('884525051', 108), ('884529051', 108), ('884529221', 108), ('884543017', 108), ('884543132', 108), ('884543543', 108), ('884550043', 108), ('884550502', 108), ('884568505', 108), ('884568509', 108), ('0142128', 209), ('0239051', 209), ('0239052', 209), ('0239053', 209), ('0739022', 209), ('0739041', 209), ('D33054', 4836), ('V10760020', 183), ('V10760021', 183), ('V10760023', 183), ('V10760025', 183), ('V10760026', 183), ('V10760027', 183), ('V10760048', 183), ('V10760054', 183), ('V10760078', 183), ('V10760103', 183), ('V24760003', 183), ('V24760008', 183), ('V24760022', 183), ('V25760022', 183), ('V25760033', 183), ('V30760043', 183), ('V30760044', 183), ('V32760003', 183), ('V32760004', 183), ('V32760012', 183), ('V38760001', 183), ('V38760002', 183), ('V38760009', 183), ('V38760010', 183), ('V38760011', 183), ('V38760023', 183), ('V40760003', 183), ('V40760005', 183), ('V46760005', 183), ('V46760006', 183), ('V46760007', 183), ('V46760008', 183), ('V46760009', 183), ('V46760015', 183), ('V50760003', 183), ('V50760007', 183), ('V53760002', 183), ('V53760004', 183), ('V63760002', 183), ('V63760003', 183), ('V95760001', 183), ('V95760011', 183), ('V95760012', 183), ('V95760013', 183), ('99061815301', 4346), ('25023000', 303), ('25023003', 303), ('25023004', 303), ('25023005', 303), ('25023013', 303), ('25023016', 303), ('25023018', 303), ('25023019', 303), ('25023023', 303), ('25023024', 303), ('25023028', 303), ('25023029', 303), ('25023031', 303), ('25023032', 303), ('25023033', 303), ('25023034', 303), ('25023047', 303), ('25023048', 303), ('25023060', 303), ('25023062', 303), ('25023067', 303), ('25023073', 303), ('25023074', 303), ('25023075', 303), ('25023078', 303), ('25023079', 303), ('25023080', 303), ('25023083', 303), ('25023084', 303), ('25023085', 303), ('25023086', 303), ('25023089', 303), ('25023092', 303), ('25023093', 303), ('25023094', 303), ('25023097', 303), ('25023100', 303), ('25023102', 303), ('25023103', 303), ('25023104', 303), ('25023106', 303), ('25023109', 303), ('25023113', 303), ('25023121', 303), ('25023126', 303), ('25023129', 303), ('25023137', 303), ('25023138', 303), ('25023141', 303), ('25023142', 303), ('25023144', 303), ('25023146', 303), ('25023147', 303), ('25023150', 303), ('25023154', 303), ('25023158', 303), ('25023159', 303), ('25023162', 303), ('25023163', 303), ('25023166', 303), ('25023167', 303), ('25023819', 303), ('25023822', 303), ('25023828', 303), ('250241026', 303), ('25024501', 303), ('25024530', 303), ('25024943', 303), ('290960001', 4275), ('290960005', 4275), ('290960006', 4275), ('290960008', 4275), ('290960010', 4275), ('290960011', 4275), ('290960012', 4275), ('290960014', 4275), ('290960015', 4275), ('290960017', 4275), ('290960025', 4275), ('290960028', 4275), ('290960029', 4275), ('290960041', 4275), ('290960043', 4275), ('290960044', 4275), ('290960045', 4275), ('290960046', 4275), ('290960047', 4275), ('290960050', 4275), ('290960061', 4275), ('290960071', 4275), ('290960094', 4275), ('290960169', 4275), ('290960170', 4275), ('290960195', 4275), ('290960196', 4275), ('290960240', 4275), ('290960243', 4275), ('290960245', 4275), ('290960512', 4275), ('290960582', 4275), ('290960608', 4275), ('290960630', 4275), ('290960645', 4275), ('290960674', 4275), ('290960675', 4275), ('290970001', 4275), ('290970002', 4275), ('290970005', 4275), ('290970006', 4275), ('290970007', 4275), ('290970014', 4275), ('290970022', 4275), ('290970027', 4275), ('290970034', 4275), ('290970035', 4275), ('290970038', 4275), ('360890079', 4275), ('360890080', 4275), ('360890081', 4275), ('WG1013848', 4832), ('WG1013853', 4832), ('WG1013854', 4832), ('WG1013869', 4832), ('WG1013880', 4832), ('WG1013928', 4832), ('WG1013929', 4832), ('WG1013945', 4832), ('WG1013970', 4832) ) 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 products.products_suppliers ps ON p.id = ps.product_id AND ps.supplier_id IN (223) An internal server error occurred.