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 ('01EFA040', 'PC2512E', 'PC2546E', 'PC618', 'XD9032E') AND o.manufacturerId=609) OR ( o.oemSearch IN ('05712435C', '057127401', '057127401A', '057127401C', '057127401D', '057127401G', '057127435C', '057127435D', '057127435E', '059127401', '059127401B', '059127401C', '059127401D', '059127401E', '059127401F', '059127401H', '57127401A', '57127401G', '57127435D', '59127401B', '59127401C', '59127401D', '59127401E', '59127401F', '59127401H', '6K0129620B', '7L0129620', '7L0129620A', '7P0129620', '7P0129620A', '8Z0127435') AND o.manufacturerId=5) OR ( o.oemSearch IN ('057127401', '057127401A', '059127401B', '059127401C', '059127401E', '059127401F') AND o.manufacturerId=3) OR ( o.oemSearch IN ('68001297AA') AND o.manufacturerId=20) OR ( o.oemSearch IN ('1444P6', '1444Q4') AND o.manufacturerId=21) OR ( o.oemSearch IN ('057127401', '057127401A', '057127401C', '057127401D', '057127401G', '057127435C', '057127435D', '057127435E', '059127401B', '059127401C', '059127401D', '059127401E', '059127401F', '059127401H', '57127401G', '59127401C', '59127401E', '6K0129620B', '7L0129620A', '8Z0127435') AND o.manufacturerId=4896) OR ( o.oemSearch IN ('60522418', 'K68001297AA') AND o.manufacturerId=35) OR ( o.oemSearch IN ('1118184', '1137518', '1137519', '1250679', '6H429610BA') AND o.manufacturerId=36) OR ( o.oemSearch IN ('51091475') AND o.manufacturerId=2383) OR ( o.oemSearch IN ('PHE500020', 'PHE500021') AND o.manufacturerId=978) OR ( o.oemSearch IN ('PHB500074', 'PHE500020', 'PHE500021', 'PHE500074') AND o.manufacturerId=1820) OR ( o.oemSearch IN ('592313014') AND o.manufacturerId=679) OR ( o.oemSearch IN ('VW071115562C') AND o.manufacturerId=1029) OR ( o.oemSearch IN ('MN980125', 'MN980408', 'MZ690902', 'TS200008') AND o.manufacturerId=77) OR ( o.oemSearch IN ('PA3268') AND o.manufacturerId=0) OR ( o.oemSearch IN ('1654600QAL') AND o.manufacturerId=80) OR ( o.oemSearch IN ('059127401B', '059127401C', '059127401E', '059127401F', '2147483647', '7L0129620', '7L0129620A', '7P0129620', '95511013100', '95511013110', '95557221910', '95811013000', '95811013010') AND o.manufacturerId=92) OR ( o.oemSearch IN ('PHB500074', 'PHE500020', 'PHE500021') AND o.manufacturerId=95) OR ( o.oemSearch IN ('FG2064') AND o.manufacturerId=249) OR ( o.oemSearch IN ('057127401A', '057127401C', '057127401D', '057127401G', '057127435C', '057127435D', '057127435E', '059127401B', '059127401C', '059127401E', '059127401F', '1L0129601C', '1L0129601D', '1L0129607M', '1L0129607N', '1L0129607Q', '1LO129620', '1LO129620A', '6K0129601B', '6K0129601E', '6K0129607M', '6K0129607R', '6K0129607T', '6K0129620B', '6K0129620C', '7L0129620', '7L0129620A', '7L0201849', '7P0129620', '7P0129620A', '8Z0127435', 'W01L0129620A') AND o.manufacturerId=104) OR ( o.oemSearch IN ('057127401', '057127401A', '057127401C', '057127401D', '057127401G', '057127435C', '057127435D', '057127435E', '059127401', '059127401B', '059127401C', '059127401E', '059127401F', '57127401A', '57127435D', '59127401C', '59127401E', '59127401F', '6K0129620B', '6K0129620C', '7L0129620', '7L0129620A', '7L0201849', '7P0129620', '7P0129620A', '8Z0127435') AND o.manufacturerId=106) OR ( o.oemSearch IN ('0172777') AND o.manufacturerId=859) OR ( o.oemSearch IN ('045115466', '045115466A', '045115466B', '045115466C', '045118466', '057127401', '057127401A', '057127401C', '057127401COE8Z0', '057127401D', '057127401DOE8Z0', '057127401G', '057127401OE057A', '057127435C', '057127435D', '057127435E', '059115561A', '059115561B', '059115562', '059127401', '059127401A', '059127401B', '059127401BC', '059127401C', '059127401CEF', '059127401D', '059127401DE', '059127401E', '059127401F', '059127401FOE057A', '059127401H', '059127401HOE057A', '059133843', '059133843A', '070115562', '071115562', '071115562A', '071115562B', '071115562C', '1H0819638', '1H0819638A', '1H0819638B', '1H0819644', '1H0819644A', '1H0819644B', '1H0819646', '1HO819644', '57127401', '57127401A', '57127401G', '57127435D', '59127401C', '59127401E', '6K0129620B', '7H0819631A', '7J0129620A', '7L0129620', '7L0129620A', '7L012962A', '7L0201849', '7LO129620', '7P0129620', '7P0129620A', '893091400A', '893091700', '893819439', '8A0819439', '8A0819439A', '8D0091800', '8Z0127435', '95511013100', '95511013110', 'JZW819653E') AND o.manufacturerId=253) OR ( o.oemSearch IN ('05712435C', '057127401', '057127401A', '057127401C', '057127401D', '057127401G', '057127435C', '057127435D', '057127435E', '059127401', '059127401B', '059127401C', '059127401D', '059127401E', '059127401F', '059127401H', '57127401', '57127401A', '57127435D', '59127401B', '59127401C', '59127401D', '59127401E', '59127401F', '59127401H', '6K0129620B', '6K0129620C', '7J0129620A', '7L0129620', '7L0129620A', '7P0129620', '7P0129620A', '8Z0127435', '95511013110') AND o.manufacturerId=121))