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 ('0060513069', '0060534211', '0060537610', '0060568851', '0060576437', '0060590027', '0060590029', '195006507900', '4460206', '46411135', '46411138', '46462626', '46536388', '46550153', '46552951', '46557534', '46557535', '46808221', '46823093', '46823094', '46842227', '46842228', '470069400', '50509339', '50509340', '51776326', '51782035', '51831050', '51834094', '55181512', '55181513', '55186669', '55187820', '55189845', '55194768', '55202883', '55202885', '55202887', '60513069', '60523246', '60537610', '60537945', '60543482', '60549313', '60564432', '60568851', '60576437', '60590027', '60590029', '60593572', '60602148', '60610797', '60614140', '60623447', '60625772', '60626029', '60651940', '60652012', '60652013', '60652465', '60652466', '60653551', '60653552', '60657246', '60659264', '60666020', '60666021', '60666789', '60678134', '60678135', '60686891', '60686892', '60800100', '60806748', '60812410', '60815681', '71735344', '71741078', '7739430', '7750716', '91535633', '9750596780', '9751739080', '9945775', '99457750', '99465680', 'S8100181') AND o.manufacturerId=2) OR ( o.oemSearch IN ('RB913311261') AND o.manufacturerId=879) OR ( o.oemSearch IN ('004028149', '004050014', '004050016', '021905106', '021905106A', '021905106B', '021905106C', '031088001', '032905106', '032905106B', '032905106D', '035905105A', '036035281A', '036905100A', '036905100B', '036905100C', '036905100D', '036905715', '036905715A', '036905715C', '036905715E', '036905715F', '036905715G', '040100025', '047905115', '04795115', '04C905110A', '04C905110B', '04C905110C', '04C905110D', '04C905110E', '04C905110F', '04C905110H', '04C905110J', '04C905110K', '04C905110L', '04E905110', '04E905110A', '04E905110B', '04E905110C', '04E905110D', '04E905110E', '04E905110F', '04E905110H', '04E905110K', '04E905110L', '04E905110M', '052035281', '058905101', '058907447C', '06A905115', '06A905115A', '06A905115B', '06A905115C', '06A905115D', '06A905115G', '06A905115H', '06A905115J', '06A905115L', '06A905115M', '06A905115N', '06A905115P', '06A905115Q', '06A905115R', '06A905115S', '06B905105', '06B905115', '06B905115A', '06B905115B', '06B905115D', '06B905115E', '06B905115G', '06B905115H', '06B905115J', '06B905115L', '06B905115M', '06B905115N', '06B905115P', '06B905115Q', '06B905115R', '06B905115S', '06B905115T', '06B905116J', '06B905117L', '06C905115B', '06C905115D', '06C905115E', '06C905115F', '06C905115G', '06C905115H', '06C905115K', '06C905115L', '06C905115M', '075905104', '078117015A', '078905101', '078905101A', '078905101C', '078905104', '079117021M', '191905115', '191905115A', '191905351', '191905351A', '191905351B', '191905351BC', '191905351C', '2119051158', '211905115B', '211905115D', '211905351D', '251905115A', '31585001', '357905104', '357905105', '357905352', '377905105D', '379905352', '40100025', '4050016', '443905105', '443905105A', '443905105B', '443905105C', '443905105CPART', '443905105D', '443905105DPART', '443905105E', '443905105EPART', '47905115', '4A0905105', '4A0905105B', '4A0905105BPART', '4A0905105PART', '4B0121101N', '4C905110B', '4E905110', '4E905110A', '4E905110B', '4E905110E', '4E905110K', '535905115', '547905104', '58905101', '58905105', '6B905115', '6B905115B', '6B905115E', '6N0905104', '6NO905104', '701905104', '701905104A', '78905101C', '78905104', '78905104A', '811905115', '867905104', '867905104A', '867905105A', '867905351', '867905352', '893905105', '893905105E', '893905105EPART', '893905105PART', '8A0905105', '8A0905105PART', '8D0905105', '8D0905105PART', '8E0121101J', '8E1955408C', '9050046N0', 'O219O51O6', 'O219O51O6A') AND o.manufacturerId=5) OR ( o.oemSearch IN ('ADU5447') AND o.manufacturerId=248) OR ( o.oemSearch IN ('56027871') AND o.manufacturerId=9) OR ( o.oemSearch IN ('88921283', '88921348', '88921391') AND o.manufacturerId=10) OR ( o.oemSearch IN ('004028149', '004050016', '047905115', '211905115D', '357905104', '4028149', '4050016', '47905115', '6N0905104', '701905104', '701905104A', '811905115', '867905104', '867905104A', '867905105A') AND o.manufacturerId=815) OR ( o.oemSearch IN ('400141KA1A', '40014CN000', '40014JE20A', '400151KA1A', '40015CN000', '40015JE20A', '432110K030', '432110K040', '4321152050', '43211KK010', '432120K030', '432120K040', '4321252050', '43212KK010', '4511165J00', '4515165J00', '4865416110') AND o.manufacturerId=11) OR ( o.oemSearch IN ('11111432478', '11117511395', '11117511396', '11117511529', '11117514923', '11117530262', '11117530823', '11117547841', '11117547842', '11117548101', '11117551866', '11117584398', '11117587168', '11120032224', '11120034104', '11120034105', '11120035738', '11120141055', '11120391974', '11121435584', '11121435586', '11127501304', '11127506983', '11127507597', '11127512839', '11127512840', '11127513194', '11127513195', '11127513944', '11127514378', '11127518017', '11127530225', '11127530256', '11127531863', '11127534714', '11127542127', '11127548921', '11127551822', '11127552280', '11127553171', '11127555212', '11127555310', '11127555755', '11127555757', '11127557265', '11127563412', '11127565284', '11127565286', '11127568178', '11127570292', '11127571963', '11127572758', '11127584128', '11127587804', '11127588412', '11127588417', '11127588418', '11127591482', '11127599212', '11127620697', '11127646555', '11128645888', '11129069871', '11129069872', '11129071589', '11129071590', '11130607100', '11131280901', '11131432703', '11131436324', '11131437237', '11131720519', '11131727574', '11131727974', '11131730234', '11131738199', '11131739592', '11131742109', '11137500210', '11137500260', '11137506774', '11137511224', '11137539412', '11137545293', '11137548031', '11137552414', '11137600482', '11137618512', '11137629210', '11139065875', '11141439717', '11147512100', '11147512101', '11147647380', '11151437641', '11151705258', '11151705272', '11151743386', '11157522931', '11157530829', '11157532649', '11157556838', '11157559527', '11157559528', '11157567801', '11157567802', '11157581815', '11280415304', '11281440237', '11281722789', '11281726773', '11281726774', '11282243510', '11282244424', '11282246769', '11282248168', '11287549557', '11287549588', '11287582766', '11287589361', '11287603347', '11287838797', '11288604267', '11288620023', '11311703717', '11311722651', '11311726471', '11311726480', '11317504471', '11317504475', '11317505608', '11317512520', '11317516079', '11317533479', '11317533483', '11317533489', '11317542836', '11317584651', '11317585020', '11317592850', '11317805960', '11317805961', '11331247054', '11331433672', '11331712010', '11331714604', '11331715458', '11331721698', '11331734402', '11337805973', '11341437237', '11367540346', '11367540347', '11367540348', '11367548459', '11367583207', '11367583208', '11368605123', '11377501015', '11377502022', '11377509295', '11377516302', '11377518204', '11377548387', '11377548388', '11427508971', '11427525335', '11427537293', '11427625489', '11427788463', '11427808437', '11428507626', '11428507627', '11428507662', '11428510855', '11428510856', '11428510857', '11428512435', '11428574004', '11428585236', '11428585238', '11428585624', '11428637820', '11428637821', '11437633477', '11442245343', '11510393340', '11511742598', '11511742647', '11512246961', '11512247269', '11512247552', '11517500597', '11517563659', '11517588885', '11517596763', '11517632426', '11517805992', '11518516435', '11521260459', '11521260469', '11521277060', '11521287120', '11521706499', '11522243304', '11522245195', '11522245496', '11522245498', '11527831619', '11531247122', '11531432884', '11531436407', '11531436408', '11531436409', '11531438632', '11531438633', '11531438634', '11531705210', '11531705224', '11531705225', '11531743017', '11532247269', '11532367436', '11533400207', '11537500728', '11537500733', '11537500735', '11537500750', '11537500752', '11537505949', '11537505950', '11537510120', '11537512733', '11537512734', '11537519494', '11537521049', '11537526941', '11537530647', '11537541992', '11537545665', '11537545890', '11537547244', '11537550062', '11537556924', '11537560363', '11537566329', '11537572159', '11537580585', '11537580969', '11537581063', '11537581576', '11537581870', '11537581872', '11537581942', '11537583666', '11537584543', '11537584549', '11537585023', '11537588257', '11537588876', '11537592085', '11537592094', '11537592095', '11537593513', '11537598496', '11537598771', '11537600586', '11537601158', '11537601159', '11537603512', '11537603514', '11537603515', '11537609944', '11537633477', '11537639998', '11537647305', '11537647751', '11537649394', '11537649409', '11537829959', '11537829960', '11538635689', '11538636594', '11538648791', '11538657054', '11538674895', '11611436631', '11617504536', '11617521181', '11617522928', '11617522929', '11617526654', '11617537999', '11617547242', '11617560537', '11617560538', '11617579114', '11621732969', '11627505789', '11668626471', '11712247723', '11717801942', '11717805447', '11717808171', '11717810871', '11787506539', '11787512002', '11787512567', '11787512973', '11787530282', '11787537984', '11787537993', '11787539123', '11787540168', '11787544561', '11787544655', '11787545074', '11787545244', '11787549860', '11787557756', '11787557758', '11787558054', '11787558055', '11787561410', '11787570104', '11787570760', '11787573319', '11787586692', '11787586693', '11787589139', '11787589146', '11787589147', '11787589475', '11787596924', '11811094149', '11811139819', '11811141889', '11814407513', '12121266705', '12121266706', '12121271673', '12121272170', '12121277635', '12121279567', '12121286059', '12121288161', '12121362801', '12131247281', '12131273216', '12131317585', '12131363629', '12137550012', '12137575010', '12140872648', '12141244089', '12141244191', '12141244226', '12141244477', '12141244481', '12141273198', '12141401186', '12141433263', '12141433264', '12141485845', '12141739886', '12147506926', '12147516056', '12147539169', '12147539172', '12147539173', '12147833134', '12147833137', '12317521385', '12317522962', '12317532965', '12317532966', '12317532969', '12317533270', '12517646145', '1273216', '1279569', '13537546244', '13537781486', '13537812345', '13620416414', '13621739510', '13622243946', '13622246977', '13627501554', '13627502055', '13627524136', '13627533853', '13627540508', '13627548995', '13627551638', '13627552114', '13627566987', '13627566988', '13627585680', '13627593624', '13627602038', '13627788743', '13627790657', '13627791347', '13627793633', '13627793825', '13627794981', '13627799452', '13627801387', '13627801951', '13627805415', '13627805472', '13627830359', '13627839014', '13628509724', '13628509725', '1363629', '13641427240', '13717571350', '13717571355', '13717582310', '13717599294', '13717601868', '13717609810', '13717609811', '13717615026', '13717624208', '13717795284', '13718626487', '13907618643', '16116754762', '16116763817', '16117159144', '16117260647', '16127236934', '16146756185', '16146763811', '16146764716', '16146765705', '16146766177', '16147054041', '16147163504', '16147163505', '16147169960', '16147180426', '16147197075', '16147203993', '16147209286', '16147218339', '16147219343', '16147229173', '16147229175', '16147240389', '16147263392', '16147264011', '16147268028', '16147268462', '16147276046', '16147276073', '16147358144', '16147407513', '17101439101', '17101439103', '17101439104', '17101439115', '17101475577', '17107500745', '17107509714', '17107529272', '17107535902', '17107544668', '17107544669', '17107559966', '17107570821', '17111436055', '17111436062', '17111436063', '17111436251', '17111438819', '17111438820', '17111439103', '17111439104', '17111439125', '17111475552', '17111707540', '17111707817', '17111712066', '17111712520', '17111712850', '17111719259', '17111723067', '17113400018', '17113401056', '17113404398', '17113414008', '17113415181', '17113438717', '17113442089', '17113452509', '17117507973', '17117519209', '17117519211', '17117521067', '17117524710', '17117534907', '17117535099', '17117544668', '17117544669', '17117547059', '17117554668', '17117593854', '17117593855', '17117600511', '17117612954', '17117620688', '17117639020', '17117639021', '17117639022', '17117695769', '17123415433', '17123417607', '17123422785', '17123424499', '17123448462', '17127507749', '17127508010', '17127508011', '17127508012', '17127508013', '17127508014', '17127508015', '17127508038', '17127508041', '17127508042', '17127508960', '17127509963', '17127509965', '17127509966', '17127509967', '17127511204', '17127516416', '17127519247', '17127519248', '17127519256', '17127519258', '17127524838', '17127524841', '17127526616', '17127526954', '17127531581', '17127531590', '17127532063', '17127534527', '17127535742', '17127536231', '17127536232', '17127537107', '17127537745', '17127537746', '17127540020', '17127540127', '17127544549', '17127548203', '17127548221', '17127548222', '17127548223', '17127548224', '17127552404', '17127561686', '17127564478', '17127565091', '17127565093', '17127565780', '17127568246', '17127568749', '17127568751', '17127568753', '17127568754', '17127575428', '17127575429', '17127575430', '17127575434', '17127575453', '17127576280', '17127576282', '17127576356', '17127576363', '17127576367', '17127576370', '17127576371', '17127578403', '17127578404', '17127578405', '17127580955', '17127580957', '17127580960', '17127580961', '17127580962', '17127580963', '17127580964', '17127580965', '17127582923', '17127582924', '17127583175', '17127584405', '17127584560', '17127584561', '17127585743', '17127586774', '17127589442', '17127589632', '17127591089', '17127591512', '17127593490', '17127596831', '17127596834', '17127596839', '17127596840', '17127596841', '17127598004', '17127598248', '17127598249', '17127599452', '17127600836', '17127601852', '17127605640', '17127609532', '17127610704', '17127612444', '17127612445', '17127612446', '17127617368', '17127618510', '17127619255', '17127619256', '17127619684', '17127619685', '17127619687', '17127619688', '17127619694', '17127619696', '17127620668', '17127623272', '17127640287', '17127640916', '17127640917', '17127646150', '17127646151', '17127798493', '17127805600', '17128606014', '17128606583', '17128614879', '17128614882', '17128651450', '17137601959', '17137619189', '17137642158', '17137649733', '17138614293', '17215741058', '17217507975', '17217541058', '17217560160', '17217560962', '17217593856', '17217638579', '17217638582', '17227575387', '17227575390', '1726177', '17414578976', '17417504732', '17417505109', '17417589028', '17417589031', '17417618786', '17417618787', '17417789256', '17418617102', '17418619142', '17418642161', '17418642162', '17422754854', '17427524881', '17427525116', '17427526824', '17427537357', '17427540681', '17427543560', '17427547305', '17427563258', '17427576281', '17427599494', '17427601176', '17427603565', '17427616104', '17427634466', '17427634467', '17427634471', '17427634472') AND o.manufacturerId=16))