SELECT o.articlenumber, b.title as suppliername, o.supplierid, sup.id AS id 
                  FROM tecdoc2021.article_oem o 
                  /*INNER JOIN tecdoc2021.supplier s ON s.supplierid = o.supplierid*/ 
                  INNER JOIN tecdoc2021.article a ON a.articlenumber = o.articlenumber AND a.supplierid = o.supplierid 
                  INNER JOIN products.brands b ON b.offline_tecdoc_id = o.supplierid
                  INNER JOIN LATERAL (
                      SELECT ps.id 
                      FROM products.products p
                      INNER JOIN products.products_suppliers as ps ON ps.product_id = p.id 
                      WHERE p.article = a.articlesearch 
                        AND p.brand_id = b.main_id 
                        AND ps.supplier_id IN (223,225,226,224,227) 
                        AND ps.quantity > 0
                      LIMIT 1
                  ) sup ON true
                  WHERE (( o.oemSearch IN ('46229251', '46759688', '467596880', '5894585', '5984036', '6000613515', '60504563', '60800325', '60806024', '6423K4', '71711639', '71711640', '71711806', '71778446', '71805145', '7554436', '7554442', '7554444', '7686643', '7760381', '7760382', '7772515', '7FYSR', '7FYSSR', '8521210140', '983602B000', '9FYSSR') AND o.manufacturerId=3854) OR ( o.oemSearch IN ('01EFA013', '01EFA052', '01FB0008', '01FBO008', '01FBO010', '01FBO011', '01FBO024', '01FBO028', '01FBO045', '2000070', '426FS', '43FS', '7984232', '7984233', '7984256', '7984716', 'A33C', 'A3439', 'A761C', 'AC124', 'AC6218E', 'ADD62101', 'ADN12103', 'ADN12109', 'ADT32102', 'ADT32103', 'ADT32105', 'ADT32107', 'ADT32109', 'ADT32113', 'ADT32114', 'C42CXLS', 'C42XLS', 'C64', 'FX0087', 'HC2', 'P1102', 'PC1004', 'PC124', 'PC164', 'PC2001E', 'PC2214E', 'PC2246E', 'PC2249', 'PC2255E', 'PC233', 'PC2353E', 'PC2357E', 'PC241', 'PC305', 'PC3243E', 'PC40', 'PC641', 'PC809', 'PC87', 'PF1', 'PF1026', 'PF1180', 'PF1219', 'PF1232', 'PF1233', 'PF1245', 'PF13', 'PF13C', 'PF13F', 'PF19', 'PF1HC', 'PF2', 'PF20', 'PF2049', 'PF2191', 'PF32', 'PF34', 'PF41', 'PF53', 'PF54', 'PF56', 'PF60', 'PF952', 'SA', 'SB', 'SC', 'SD', 'SE', 'SEF', 'SF', 'SH', 'SJ', 'SK', 'SP', 'SPA', 'SPF13', 'SR', 'ST', 'SY', 'UPF13', 'X100', 'X11', 'X113', 'X115', 'X116', 'X121', 'X123', 'X124', 'X126', 'X129', 'X13', 'X139', 'X14', 'X148', 'X15', 'X150', 'X152', 'X16', 'X170', 'X174', 'X18', 'X18BMW', 'X19', 'X20', 'X21', 'X23', 'X29', 'X35', 'X37', 'X40', 'X4004E', 'X4006E', 'X4015E', 'X4020E', 'X4033E', 'X4047E', 'X4048E', 'X4049E', 'X4053E', 'X4055E', 'X4062E', 'X4064E', 'X4100E', 'X4105E', 'X4130E', 'X4314E', 'X49', 'X501', 'X502', 'X503', 'X504', 'X51', 'X52', 'X522', 'X525', 'X527', 'X528', 'X53', 'X530', 'X532', 'X533', 'X536', 'X541', 'X542', 'X543', 'X544', 'X551', 'X558', 'X559', 'X561', 'X565', 'X567', 'X587', 'X607', 'X61', 'X614', 'X632', 'X64', 'X65', 'X650', 'X66', 'X7', 'X71', 'X72', 'X74', 'X75', 'X87', 'X9', 'X97') AND o.manufacturerId=609) OR ( o.oemSearch IN ('1068702M91', '156513AS', '2213533', '330083836', '3757038M2', '491056', '5205002', '72101498', '72118856', '72161316', '72214117', '72257947', '74920158', '7825516', 'HB03028811', 'X696617800000') AND o.manufacturerId=1033) OR ( o.oemSearch IN ('7007007010006', '7007007021007') AND o.manufacturerId=128) OR ( o.oemSearch IN ('50249', '50912', '52706', '59999', '75999') AND o.manufacturerId=659) OR ( o.oemSearch IN ('101947', '107037', '108017', '116760210300', '119001020700', '2068028', '2137077', '4042901', '4049101', '4060336', '4062365', '4126435', '4150202', '4153752', '4153753', '4229143', '4229145', '4279749', '4286051', '4301066', '4316238', '4335580', '4337104', '4363485', '4382104', '4458068', '4470182', '4547446', '4606270', '46229251', '4758123', '554021602', '5899108', '5901370', '5901375', '59030255', '5911650', '5948450', '5948451', '5951891', '5953873', '5978842', '5990576', '5990649', '5990790', '60503994', '60504563', '60517424', '60556707', '60800269', '60807651', '6272240', '7032389', '71719641', '71739900', '71804097', '7301221', '7541662', '7546910', '7554442', '7580224', '7596397', '7609091', '7609093', '7617420', '7640261', '7652117', '7662411', '7671401', '7671402', '7692630', '7692828', '7692829', '7813076000', '82308185', '82342881', '9406426509', '9835038000', '9990155', 'CC3067330', 'DD1467330', 'K04781452AA', 'MR300877') AND o.manufacturerId=255) OR ( o.oemSearch IN ('0046214770', '0046805830', '0050508585', '00510313', '00510889', '00534372', '0060517424', '0060521128', '0060536129', '0060744108', '04371582', '04434794', '053121039', '101947', '1019471', '1019471B', '105000603000', '10514051060100', '105550503002', '105550503003', '105550600300', '105550600302', '105550603000', '105550603001', '105550603002', '105550603003', '105550603005', '105550603006', '106000603000', '107037', '107037B', '108017', '110259', '110259A', '113150210300', '116090603000', '116090603e11', '116120603000', '116120603e11', '116121E11', '116440603000', '116441E11', '116760210300', '116760603000', '119000000000', '119000210300', '11900051060100', '119001020700', '119003206101', '119113206100', '119113206101', '119113206104', '119280000000', '1192802103', '119280210300', '130564', '133481', '188017', '1903790', '1L4JR', '21013707001', '232779', '37064000', '370640000', '4126435', '4158728', '4160703', '4199523', '4212109', '4228326', '4249164', '428326', '4286050', '4286051', '4286052', '4301066', '4316238', '4323062', '4334597', '4335580', '4335880', '4339509', '4343597', '4345041', '4346196', '4346796', '4356500', '4359424', '4363484', '4363485', '4371581', '4371582', '4382018', '4382101', '4394254', '4394463', '43944630', '4401550', '4419493', '4434790', '4434791', '4434792', '4434793', '4434794', '4434857', '4434867', '4434959', '4460206', '4469396', '4469397', '4469398', '4469399', '4469400', '4470182', '45170000', '451700000', '46214770', '46229251', '46411135', '46411138', '46462626', '46481378', '46510517', '46521529', '46536388', '46550153', '46550991', '46552951', '46557534', '46557535', '46759688', '467596880', '46799653', '46805828', '46805830', '46805831', '46808221', '46823093', '46823094', '46842227', '46842228', '470069400', '499031372', '49977792', '49978792', '50508583', '50508585', '50509339', '50509340', '50509398', '50509399', '50509400', '50509401', '50514912', '50514913', '50516364', '50516542', '50529573', '50529575', '50529576', '50539273', '510313', '51031300000', '510313E11', '510889', '510889E11', '51776326', '51782035', '51831050', '51834094', '52406856', '530388', '53121039', '534372', '534372E11', '542044', '546898', '55129620', '55181512', '55181513', '55186669', '55187820', '55189845', '55194768', '55202883', '55202885', '55202887', '5889209', '5889274', '5894585', '5894587', '5899108', '5901370', '5901373', '5901375', '5901423', '5901472', '5911650', '5939831', '5939832', '5940898', '5951865', '5984036', '5990790', '60503994', '60504284', '60504563', '60504569', '60504835', '60507080', '60510871', '60512848', '60512929', '60513237', '60517424', '60522173', '60523246', '60524560', '60534466', '60537470', '60543482', '60549313', '60553431', '60556707', '60564432', '60574554', '605745540', '605745541', '60593572', '60594597', '60602148', '60610797', '60614140', '60623447', '60625772', '60626029', '60651940', '60652012', '60652013', '60652465', '60652466', '60653551', '60653552', '60657246', '60659264', '60666020', '60666021', '60666789', '60668003', '60678134', '60678135', '60686891', '60686892', '60690113', '60695908', '60695909', '60698819', '60699862', '60754994', '60800100', '60800269', '60800325', '60806024', '60806748', '60807651', '60810709', '608107091', '60812410', '60815415', '60815681', '68121039', '71711639', '71711640', '71711806', '71735344', '71736162', '71736166', '71741078', '71754154', '71754231', '71771274', '71778861', '71778862', '71802624', '71804094', '71804097', '71805141', '71805776', '7300943', '74419493', '7554436', '7554442', '7554444', '7554445', '7554451', '7554452', '7581562', '7596397', '7609091', '7609093', '7654167', '76591527', '7686643', '7689285', '7692630', '7724167', '7739430', '7750716', '7760381', '7760382', '7772399', '7772515', '7773854', '7786626', '7FYSR', '7FYSSR', '82323784', '82342881', '82360558', '83986742', '87800068', '9004831064', '9151700180', '9945775', '99457750', '99465680', '9FYSR', '9FYSSR', 'HB03028811', 'K03549957', 'K04105409AC', 'K04781452AB', 'K04781452BB', 'K04884899AA', 'K04884899AB', 'K04884899AC', 'K05013780AA', 'K05037333AA', 'K05281090', 'K05281090AB', 'K4105409AB', 'K4105409AC', 'K4781452AA', 'K4781452BB', 'K53020234', 'K53020311', 'K68045835AA', 'KMD308302', 'KMD353795', 'S8100181') AND o.manufacturerId=2) OR ( o.oemSearch IN ('02305781', '02324211', '02325784', '02349008', '0237000', '02370005', '02513810', '04513411', '1014120', '132578', '1650954', '2067272', '207976908', '2080483', '2097690', '20976908', '2100723', '2101498', '230578', '2305781', '232241', '232421', '2324211', '232578', '2325784', '234900', '2349008', '235781', '237000', '2370005', '251178', '2513810', '267272', '29976908', '40279796', '4126435', '4228326', '4316238', '4335580', '4343591', '4434794', '4446355', '4511629', '45116290', '45116292', '451341', '4602816', '4630787', '4910328', '4910810', '4920158', '501547', '64511629', '70237000', '71650954', '720976901', '721014983', '72102503', '721185533', '72370000', '74126435', '74910810', '74942265', '7825516', '99100240', 'HB03028803', 'HB03028811', 'PH2895') AND o.manufacturerId=914) OR ( o.oemSearch IN ('0948200392', '11421266773', '11421287836', '11421707779', '11421761087', '11429061198') AND o.manufacturerId=866) OR ( o.oemSearch IN ('7700503052') AND o.manufacturerId=810) OR ( o.oemSearch IN ('4105409', '8127168', 'DO714', 'DO721', 'HA706', 'HA873', 'IO316', 'IO317', 'KO1534', 'MO522', 'MO539', 'MO540', 'NO214', 'NO215', 'NO221', 'NO222', 'NO227', 'NO249', 'SO801', 'TO124', 'TO130', 'TO136') AND o.manufacturerId=2246) OR ( o.oemSearch IN ('3232126', '3250334', '7701031111', '8127128', '8127168', '8953002184', '8990499') AND o.manufacturerId=758) OR ( o.oemSearch IN ('1103827', '49540000111', '5150408400', '541C02032430', '7612915035151') AND o.manufacturerId=2762) OR ( o.oemSearch IN ('41152006') AND o.manufacturerId=3825) OR ( o.oemSearch IN ('PH228', 'PH2812A', 'PH2814', 'PH2821', 'PH2821A', 'PH2822', 'PH2835', 'PH2861', 'PH400', 'PH561') AND o.manufacturerId=5136) OR ( o.oemSearch IN ('82883R', '82960R', '8560153') AND o.manufacturerId=4049) OR ( o.oemSearch IN ('0891418110', '1521332090', '1521332430', 'AA10118110', 'FEL136', 'RB913311261') AND o.manufacturerId=879) OR ( o.oemSearch IN ('200523', '21013707001', '9501110') AND o.manufacturerId=881) OR ( o.oemSearch IN ('00100261', '01174391', '10300882', '1030088200', '10301068', '12028497', '1202849700', '1202849700ED1', '12928497', '1513016000', '16193558', '16196227', '1619622700', '2903033701', '29148058', '2914805800', '2914805800ED0', '370950', '3929440', '392944011', '6211472600', '852931', '97076483', '9707648300', '97090000103', '9709000103', '970900103', 'M46', 'M52') AND o.manufacturerId=917) OR ( o.oemSearch IN ('10300882', '12028497', '1202849700', '16193558', '2903033700', '3929440', '852931', '97076483', '9709000103') AND o.manufacturerId=916) OR ( o.oemSearch IN ('0003897991', '0003897992', '0003936569', '0003936608', '0003936870', '0003945577', '0003963373', '0004359424', '0005940898', '0019973792', '0028115351', '007045248', '010325421A', '010325421AS2', '010398009', '021115351A', '021115531A', '021116351A', '023145271', '023145271A', '023145271B', '0261155613', '026903137C', '027903137A', '028115351', '028145271F', '028903137', '030115561C', '030115561D', '030129620', '030129620A', '0321269620F', '032129620', '032129620F', '034115561A', '035115561', '035115561G', '036129608', '037115561', '037115561A', '037115561B', '03D129620', '03D145933AD', '040903137A', '041903137A', '046130113C', '046145271A', '046903137', '047115561F', '047198561F', '047903137E', '048903137', '049145271', '049903137', '049903137A', '049903137B', '049903137C', '049903137D', '049903137E', '0499O3137A', '050121039A', '050903137', '050903137A', '052126620A', '052129620', '052129620A', '053121039', '053121039A', '053903137', '054903137', '054903137D', '055903127G', '055903137A', '056115516B', '056115561', '056115561A', '056115561B', '056115561C', '056115561G', '056129620', '056903137', '056999651G', '057115561', '057115561L', '059103193', '059103193S1', '059115561A', '059115561B', '059115562', '059115562A', '059115562B', '059115661A', '059119137', '059119137A', '059903137', '059903137B', '060903137', '062145271A', '068121039F', '068121039M', '068121039P', '068903137A', '068903137B', '068903137BSBV', '068903137C', '068903137L', '068903137M', '06893137M', '06A115561', '06A115561A', '06A115561B', '06A115561BDSF', '06A115561E', '06C903137E', '070115561', '074145271J', '076145107', '078115561K', '078117015A', '078903137BC', '078903137BJ', '079117021M', '095325429C', '095325429D', '100115561G', '101000000AB', '101000001AB', '101000001AC', '101000002AA', '101000002AB', '101000005AA', '101000005AB', '101000005AC', '101000005AE', '101000006AA', '101000006AB', '101000006AC', '101000007AA', '101000007AB', '101000007AD', '101000026AB', '101000027AA', '101000034AA', '101000036AA', '101000036AC', '101000040AD', '101000050AC', '10325421A', '1104020050', '111201195', '111903137B', '111903137C', '111903137D', '111903137E', '114040200N', '115094100', '115946202', '115946204', '115946204S', '115946205', '115946205S', '15890062') AND o.manufacturerId=5))