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 ('443611301D', '4A0611301K', '6C0611349', '6N1611349B', '893611301', '893611301A', '8A0611301A', '8D0611301', '8E0611301') AND o.manufacturerId=5) OR ( o.oemSearch IN ('1H0611346', '443611301D', '6C0611349', '6N1611349A', '6N1611349B', '893611301A', '8A0611301A', '8A0611349', '8A0611349A', '8D0611301', '8E0611301') AND o.manufacturerId=104) OR ( o.oemSearch IN ('1H0611346', '443611301D', '6C0611349', '6N1611349A', '6N1611349B', '893611301A', '8A0611301A', '8A0611349', '8A0611349A', '8D0611301', '8E0611301') AND o.manufacturerId=106) OR ( o.oemSearch IN ('1H0611346', '443611301D', '4A0611301K', '6C0611349', '6N1611349', '6N1611349A', '6N1611349B', '893611301', '893611301A', '8A0611301A', '8A0611349', '8A0611349A', '8D0611301', '8E0611301') AND o.manufacturerId=253) OR ( o.oemSearch IN ('1H0611346', '443611301D', '4A0611301K', '6C0611349', '6N1611349B', '893611301', '893611301A', '8A0611301A', '8A0611349', '8A0611349A', '8D0611301', '8E0611301') AND o.manufacturerId=121))