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 ('9674265980') AND o.manufacturerId=21) OR ( o.oemSearch IN ('9674265980') AND o.manufacturerId=804) OR ( o.oemSearch IN ('9674265980') AND o.manufacturerId=84) OR ( o.oemSearch IN ('9674265980') AND o.manufacturerId=88) OR ( o.oemSearch IN ('9674265980') AND o.manufacturerId=117))