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 ('3B0399151', '4B0151399L', '4B0399151', '4B0399151AA', '4B0399151E', '4B0399151K', '4B0399151L', '4B0399151M', '4B0399151S', '8D0399151J', '8D0399151M', '8D0399151P', '8e0399151d', '8E0399151D') AND o.manufacturerId=5) OR ( o.oemSearch IN ('4B0399151L', '4B0399151S', '8E0399151D') AND o.manufacturerId=2858) OR ( o.oemSearch IN ('6013240050', 'A6013240050', '6013240150', 'A6013240150', '6023240050', 'A6023240050', '6023240150', 'A6023240150') AND o.manufacturerId=74) OR ( o.oemSearch IN ('97037511801') AND o.manufacturerId=92) OR ( o.oemSearch IN ('3B0399151', '4B0151399L', '4B0399151', '4B0399151K', '4B0399151L', '4B0399151M', '4B0399151S', '8D0399151J', '8D0399151M', '8D0399151P', '8e0399151d', '8E0399151D') AND o.manufacturerId=104) OR ( o.oemSearch IN ('3B0399151', '4B0151399L', '4B0399151', '4B0399151K', '4B0399151L', '4B0399151M', '4B0399151S', '8D0399151J', '8D0399151M', '8D0399151P', '8e0399151d', '8E0399151D') AND o.manufacturerId=106) OR ( o.oemSearch IN ('4B0151399L', '4B0399151', '4B0399151K', '4B0399151L', '4B0399151M', '4B0399151S', '8D0399151M', '8e0399151d', '8E0399151D') AND o.manufacturerId=253) OR ( o.oemSearch IN ('3B0399151', '4B0151399L', '4B0399151', '4B0399151K', '4B0399151L', '4B0399151M', '4B0399151S', '8D0399151J', '8D0399151M', '8D0399151P', '8e0399151d', '8E0399151D') AND o.manufacturerId=121) OR ( o.oemSearch IN ('4B0399151L', '4B0399151M', '4B0399151S', '8E0399151D') AND o.manufacturerId=864))