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 ('5E5840', '6000613513', '6000613515', '6423K4', '71778446', '71805145', '8521210140', '983602B000') AND o.manufacturerId=3854) OR ( o.oemSearch IN ('15890065', '288955X11B', '5901370', '5901375', '5911650', '6000607070', '6000607071', '6000613513', '6000614980', '60608229191', '76630TE0A011M2', '9406426509', '9835038000', 'BJ0F67330') AND o.manufacturerId=255) OR ( o.oemSearch IN ('0050508583', '0050508585', '119136550304', '50508583', '50508585', '50509398', '50509399', '50509400', '50509401', '50514912', '50514913', '50516364', '50516542', '50516543', '50529573', '50529575', '50529576', '50539273', '51757532', '5901370', '5901373', '5901375', '5901423', '5901483', '5911650', '60510871', '60522173', '60594597', '60668003', '60690113', '60695908', '60695909', '60698819', '60699862', '71771274', '71778861', '71778862', '71779243', '71802624', '71804095', '71804099', '71805141', '71805144', '71805776', '7772399') AND o.manufacturerId=2) OR ( o.oemSearch IN ('13277083', '15890062', '161955425', '161955427', '161998003', '1733614', '191955427B', '1955425A', '1J0998003', '1P0455425B', '2889044F00', '2K1955425', '2K1955426', '30655217', '357955425', '357955427', '357998001A', '357998003A', '3834060B20000', '3834065B00', '3A1955425', '3A1955425D', '3A1955427', '423955425', '423955426', '431955427', '431998003', '4A0955425A', '4A0955425B', '4A0955427', '4B0955425', '4B0955427', '4B0998002', '4B0998003', '4B1955425B', '4B1955425C', '4B7955425G', '4B7955425L', '4E0998002', '4E1955425D', '4F1955425F', '4F1955426C', '4G1955425', '4G1955425A', '4G1998002A', '4G2998002A', '4G8955425B', '4H1955426B', '4L1955425B', '4L1955426A', '4M1998002', '61611367130', '61611372555', '61612158220', '6272246', '642302', '6N0955425A', '6N0955427A', '6U0955427C', '7701410020', '7M3955425D', '81264400058', '81B998002', '81C998002', '8522253070', '871955425A', '8D1955425A', '8D1955427', '8E0955425A', '8E1955425A', '8F1955426', '8F1955426A', '8F1955426B', '8F2998002A', '8H0955425B', '8H0998002', '8H1955426', '8H19585426C', '8J1955425A', '8J1955426A', '8J2955426A', '8K1955425', '8K1955425A', '8K1955426', '8K1955426A', '8K1998002', '8K1998002A', '8K2955425A', '8K2955426A', '8K2998002', '8K2998002A', '8L1955425B', '8L1955425C', '8N1955425D', '8N1955425E', '8N2955408D', '8P0998002', '8P0998002A', '8P1955425F', '8P1955425H', '8P1955425J', '8P1955426D', '8P1955426F', '8P1955426H', '8P2955425D', '8P2955425H', '8P2955426H', '8P2998002A', '8P7955426', '8P7955426A', '8R1955425B', '8R1955426B', '8R1998002', '8R2998002', '8S1998002', '8S2998002', '8T1955425A', '8T1955426A', '8U1955425', '8U1955426', '8U1998002', '8U2998002', '8V1955425', '8V1955426', '8V1998002A', '8V1998002B', '8W1998002', '8W7998002', '8X1955425', '8X1955425A', '8X1955426', '8X1955426A', '8X1998002A', '8X2955425', '8X2955425A', '8X2955426', '8X2955426A', '8X2955426B', '8X2998002A', 'B48167330', 'FBOE11', 'FBOE6', 'G22667330', 'HE2167330', 'KS95545053', 'MB622214') AND o.manufacturerId=5) OR ( o.oemSearch IN ('4B0955425', '8V1998002B') AND o.manufacturerId=2858) OR ( o.oemSearch IN ('BMP4501') AND o.manufacturerId=799) OR ( o.oemSearch IN ('BMP4501') AND o.manufacturerId=815) OR ( o.oemSearch IN ('0405167', '151539', '161955425', '1680513', '301370', '3201897', '3834070B10000', '390494', '405167', '60600028137', '60608229191', '60608229192', '60608229202', '60703800', '61610028137', '61610032741', '61610032743', '61610034739', '61610034741', '61610037009', '61610038893', '61610038895', '61610039343', '61610039696', '61610039697', '61610040534', '61610046517', '61610396417', '61610415881', '61610415882', '61610420549', '61610420550', '61610427668', '61610427669', '61610431438', '61610431463', '61610443590', '61611362189', '61611365991', '61611367130', '61611372555', '61611387678', '61612147361', '61612147365', '61612151749', '61612158219', '61612158220', '61612159627', '61612159628', '61612159629', '61612159630', '61612163749', '61612183576', '61612209047', '61612219147', '61612239962', '61612241357', '61612241375', '61612349870', '61612358552', '61612358553', '61612455435', '61612455436', '61612455437', '61612455438', '61612455439', '61612455440', '61612455442', '61612458006', '61612458015', '61612458017', '61613427726', '61617004901', '61617049186', '61617049187', '61617066331', '61617066332', '61617118214', '61617118216', '61617118223', '61617156483', '61617161613', '61617170545', '61617170549', '61617170570', '61617171639', '61617198668', '61617198669', '61617198670', '61617253386', '61617253397', '61617469820', '61618203954', '61618217706', '61618229191', '61618229192', '61618353289', '61618353297', '61618389573', '61619061906', '61619061907', '61619069195', '61619069196', '61619069197', '61619070579', '61619071613', '61619449923', '61619466377', '61627009884', '61627074477', '61627140959', '61627140965', '61ГЈГЎ61ГЈГЎ0ГЈГЎ427ГЈГЎ668', '6423F3', '6423J4', '6423K4', '642618', '6426KS', '6426XG', '6N0955427A', '6Q1955426A', '7049186', '7049187', '7118216', '7118223', '7122140', '7122141', '7170545', '7170549', '71804095', '7701038296', '7711172780', '7836005000', '7H6955425', '8K1955425A', '9061907', '96123311', '9835028920', '983602B000', '99362803800', 'A0018203545', 'A780X17528AJA', 'C2Z2269', 'SWF119745', 'XM3417528HA') AND o.manufacturerId=16) OR ( o.oemSearch IN ('61610427668', '61612163749', '61612219147', '61612241375', '61612358552', '61612455435', '61612455439') AND o.manufacturerId=3124) OR ( o.oemSearch IN ('96342895', '983501G000', '9835028030', 'BP4L67330A') AND o.manufacturerId=819) OR ( o.oemSearch IN ('134774002') AND o.manufacturerId=661) OR ( o.oemSearch IN ('5E5840', '6423J6', '86542AG160') AND o.manufacturerId=937) OR ( o.oemSearch IN ('22846938', '90511639', '92231676', '93195937', '95161605', '95161606', '95228809', '95228810', '95287043', '95423458', '95423459', '95423460', '95423461', '95479599', '96123311', '96252775', '96262505', '96442575', '96476632', '96476636', '96476652', '96602111', '96688383', '96898048', '96910777', '96910780') AND o.manufacturerId=138) OR ( o.oemSearch IN ('05014794AA', '05018407AA', '05018431AA', '05018433AA', '05066972AA', '05066973AA', '05066974AA', '05183008AA', '4389446', '5018407AA', '5066972AA', '5066973AA', '5066974AA', '68194931AA', '71805144', 'K04673042', 'K04673043', 'K04717349AB', 'K05018262AA', 'K05018430AA', 'K05018431AA', 'K05113253AA', 'K68015148AA', 'K68028442AA', 'K68125735AA', 'KD5367330', 'MB622214', 'MZ690098') AND o.manufacturerId=20) OR ( o.oemSearch IN ('5018407AA') AND o.manufacturerId=3646) OR ( o.oemSearch IN ('0008209645', '1272337', '13277083', '1608028680', '1608028780', '1609068980', '1609069180', '1610112080', '1610112380', '1610112480', '1610853880', '1611345580', '1611346180', '1611346280', '1611346580', '1611348580', '1611349180', '1611349280', '1611352580', '1611587580', '1611870280', '1611870480', '1612432480', '1613156580', '1613156680', '1613156780', '1613157180', '1613157380', '1613160080', '1613160180', '1613160280', '1613215580', '1613578480', '1613716080', '1615628080', '1615628180', '1615638380', '1615638480', '1623232780', '1623237280', '1642332580', '1642334580', '1642340480', '1642340680', '1642341080', '1642341180', '1642341280', '1642341380', '1H0955427', '1Q1955425', '2128201800', '2889040F05', '288909C008', '28890JD900', '2D0955425A', '3834060B20000', '3834065B00000', '4158240626', '431998003', '4A0955425A', '5911650', '6122489', '61617253386', '64230000', '642301', '642302', '642305', '642306', '642332', '642333', '642336', '642338', '642339', '642345', '642347', '642349', '642356', '642357', '642359', '642361', '642365', '642381', '642382', '642383', '642384', '642389', '6423A0', '6423C4', '6423C5', '6423C8', '6423C9', '6423E3', '6423E4', '6423E5', '6423E6', '6423G4', '6423H5', '6423H6', '6423H7', '6423H9', '6423J2', '6423J3', '6423J4', '6423J5', '6423J6', '6423J7', '6423K0', '6423K4', '6423K5', '6423K7', '6423L6', '6423L9', '6423N0', '642618', '642632', '642666', '642676', '6426AR', '6426AT', '6426AX', '6426CC', '6426CE', '6426CP', '6426FP', '6426GG', '6426HG', '6426JG', '6426JH', '6426KC', '6426KS', '6426LY', '6426NF', '6426NH', '6426NK', '6426NL', '6426P8', '6426PJ', '6426PK', '6426PW', '6426PX', '6426R1', '6426SF', '6426SH', '6426SJ', '6426SK', '6426SP', '6426SS', '6426T3', '6426TX', '6426WH', '6426XF', '6426XG', '6426XH', '6426XQ', '6426YP', '6426YQ', '6426YS', '6426ZE', '6426ZF', '6426ZW', '7701038296', '7701040775', '7701040777', '7711172772', '7711421437', '7H6955425', '8250A098', '85212YZZAV', '8J1955425A', '8V1955426', '9195184', '93178169', '9835028000', '9836022020', '983602P900', '99362803801', 'A0018200645', 'BJ0F67330', 'E429005', 'LR018436', 'MB382532', 'MR300879', 'MZ690431', 'Z204Z312', 'ZC9865230') AND o.manufacturerId=21) OR ( o.oemSearch IN ('1272346', '1272788', '13277083', '1611346580', '1611356380', '5483752', '6272241', '6423A1', '6423G4', '6423K5', '6423L6', '642618', '642632', '6426AR', '6426AS', '6426AT', '6426CC', '6426CE', '6426CP', '6426CR', '6426CS', '6426G7', '6426GG', '6426GH', '6426GX', '6426HG', '6426HP', '6426HQ', '6426JG', '6426KS', '6426KT', '6426KV', '6426KW', '6426KZ', '6426LF', '6426LG', '6426LK', '6426LY', '6426NL', '6426P0', '6426R8', '6426RT', '6426S4', '6426SF', '6426SP', '6426TW', '6426XN', '6426XQ', '6426XZ', '8524222040', 'A780X17528AJA', 'YL8X17528EA', 'Z007', 'ZC9865230') AND o.manufacturerId=804) OR ( o.oemSearch IN ('1K1955426A', '288901158R', '288901217R', '288903993R', '288905401R', '288905811R', '288907150R', '288907177R', '288907672R', '288908484R', '288909307R', '288954625R', '288B55277R', '6001547877', '6001550815', '61612159627', '8200769217', '91132009', 'FE1567330A', 'MN161331') AND o.manufacturerId=139) OR ( o.oemSearch IN ('25882578', '3465959', '38340A78B00000', '5C450', '5C500', '6272245', '642632', '7835005000', '7836005000', '90034997', '90240147', '92057198', '93746653', '93746654', '94795650', '94806697', '95161606', '95211013', '95211014', '95211017', '95287043', '96119480', '96123311', '96123311D', '96132997', '96132997D', '96208570', '96220735', '96220735D', '96227855', '96227855D', '96252775', '96252775D', '96262506', '96262506D', '96282390', '96282390D', '96301840', '96301840D', '96320725', '96327017', '96341424', '96341429', '96341429D', '96341435', '96341435D', '96341436', '96408440', '96474966', '96476632', '96476633', '96476636', '96492772', '96498670', '96498670D', '96498678', '96498678D', '96498679', '96498679D', '96498696', '96498696D', '96617853', '96636572', '96636592', '96636665', '96893308', '96893320', '96910780', '9835028020', '983602P000', 'I90034997', 'I90240147', 'I92057198', 'I96119480', 'I96208570', 'I96341436', 'P3465959', 'P38340A78B00000', 'P5C450', 'P5C500', 'P90034997', 'P93746653', 'P93746654', 'P94795650', 'P94806697', 'P95161606', 'P95211013', 'P95211014', 'P95211017', 'P95287043', 'P96123311', 'P96123311D', 'P96132997', 'P96132997D', 'P96220735', 'P96220735D', 'P96227855', 'P96227855D', 'P96252775', 'P96252775D', 'P96262506', 'P96262506D', 'P96282390', 'P96282390D', 'P96301840', 'P96301840D', 'P96320725', 'P96327017', 'P96341424', 'P96341429', 'P96341429D', 'P96341435', 'P96341435D', 'P96408440', 'P96474966', 'P96476632', 'P96476633', 'P96476636', 'P96492772', 'P96498670', 'P96498670D', 'P96498678', 'P96498678D', 'P96498679', 'P96498679D', 'P96498696', 'P96498696D', 'P96617853', 'P96636572', 'P96636592', 'P96636665', 'P96893308', 'P96893320', 'P96910780', 'XM3417528FA') AND o.manufacturerId=185) OR ( o.oemSearch IN ('0513952', '1288698', '288907177R', '513952', 'ABU8833', 'DAF5001517862', 'DAF5501517863') AND o.manufacturerId=24) OR ( o.oemSearch IN ('1868100240', '1868100260', '786542730', '8521214320', '8521216120', '8521217140', '8521220381', '8521220401', '8521220421', '8521226081', '8521226110', '8521226111', '8521228070000', '8521228120', '8521230310', '8521233121', '8521233160', '8521233161', '8521233200', '8521233240', '8521234012', '8521237091', '8521242080', '8521247020', '8521247021', '8521248040', '8521252141', '8521253050', '8521253051', '8521253060', '8521253061', '8521260110', '8521260130', '8521260131', '8521287201000', '8521287203000', '8521287209000', '8521287601000', '8521287701', '8521287701000', '8521287704', '8521287707000', '8521287708B', '8521297202', '8521297202000', '8521297202A', '8521297202B', '8521297203000', '8521297205000', '8521297208000', '8521297209', '8521297209000', '8521297504', '8521297504A', '85212B1020', '85212B2010000', '85212B2020', '85212B2020000', '85212B2040', '85212B2040000', '85212B2080', '85212B2090', '85212B2110', '85212B4030', '85212X6900', '8522016410000', '8522016420000', '8522087108000', '8522087110000', '8522087218000', '8522087228000', '8522087608000', '8522087726000', '8522087727000', '8522205090', '8522212711', '8522212730', '8522226051', '8522226100', '8522226101', '8522228030000', '8522228090', '8522230500', '8522234012', '8522237151', '8522242040', '8522242041', '8522252121', '8522252130', '8522252131', '8522253060', '8522260131', '8522260170', '8522287203B', '8522287401000', '8522287701', '8522287701000', '8522287704', '8522287707', '8522297201000', '8522297202', '8522297202000', '8522297202A', '8522297202B', '8522297205000', '85222B2050', '85222B2050000', '85222B2060', '85222B2060000', '85222B2140', '85222D16D0', '8524214010', '8524214020', '8524216030', '8524220050', '8524220080', '8524220090', '8524222050', '8524226030', '8524232020', '8524232030', '8524232040', '8524232060', '8524233020', '8524233031', '8524260071', '8529187704000', '8529187705', '8529187705000', '85291B2040000', '85291B2280', '85291B5070', '8943176710', '8943286790', '8943287810', '8943379850', '8943379860', '8944429000', '8944811270', '8971345611', '8971374691', '8980790890') AND o.manufacturerId=25) OR ( o.oemSearch IN ('288905PA0A') AND o.manufacturerId=807) OR ( o.oemSearch IN ('1907652') AND o.manufacturerId=751) OR ( o.oemSearch IN ('6423J4', '6423K0', '7H0998003') AND o.manufacturerId=4468) OR ( o.oemSearch IN ('H816810170020') AND o.manufacturerId=752) OR ( o.oemSearch IN ('1077150', '6000613515', '607038', '60703800', '6272245', '640260', '642618', '6426NL', '65081600', '66348000', '675464', '69771300', '6N0955427A', '80535000', '91126410') AND o.manufacturerId=700) OR ( o.oemSearch IN ('80539100') AND o.manufacturerId=3821) OR ( o.oemSearch IN ('0000005897555', '0014885V002', '0018200545') AND o.manufacturerId=35))