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 ('7544693', '7727595', '854881') AND o.manufacturerId=255) OR ( o.oemSearch IN ('1449282001', '25501711', '7544693', '7727595', '854880', '854881', '90128079') AND o.manufacturerId=2) OR ( o.oemSearch IN ('1261479', '1449282600', '7544693', '854880') AND o.manufacturerId=799) OR ( o.oemSearch IN ('1261479', '854880') AND o.manufacturerId=10) OR ( o.oemSearch IN ('0854982', '0854986', '854982', '854986', '90128079', '90128082', '90280056') AND o.manufacturerId=138) OR ( o.oemSearch IN ('04427299', '4411494', '4427299', '854880') AND o.manufacturerId=20) OR ( o.oemSearch IN ('270249208701') AND o.manufacturerId=21) OR ( o.oemSearch IN ('1449282001', '25501711', '7727595', '854880', '854881', '90128079', '90128082') AND o.manufacturerId=185) OR ( o.oemSearch IN ('1449282001') AND o.manufacturerId=807) OR ( o.oemSearch IN ('4411494') AND o.manufacturerId=29) OR ( o.oemSearch IN ('1261479', '1449282001', '1449282600', '25501711', '7544693', '7727595', '854880', '854881', '90128079') AND o.manufacturerId=35) OR ( o.oemSearch IN ('0854881', '0854884', '0854982', '0854986', '1449282001', '25501711', '7727595', '854880', '854881', '854884', '854982', '854986', '90128079', '90128082', '90234204', '90280056') AND o.manufacturerId=753) OR ( o.oemSearch IN ('18230SA0930') AND o.manufacturerId=45) OR ( o.oemSearch IN ('2869543000') AND o.manufacturerId=183) OR ( o.oemSearch IN ('1449282001', '25501711', '7727595', '854880', '854881', '90128079') AND o.manufacturerId=52) OR ( o.oemSearch IN ('4411494') AND o.manufacturerId=882) OR ( o.oemSearch IN ('211001206056') AND o.manufacturerId=63) OR ( o.oemSearch IN ('1449282001', '25501711', '7544693', '7727595', '854880', '854881', '90128079') AND o.manufacturerId=64) OR ( o.oemSearch IN ('MB156480') AND o.manufacturerId=77) OR ( o.oemSearch IN ('1449282001') AND o.manufacturerId=80) OR ( o.oemSearch IN ('0854880', '0854881', '0854884', '0854982', '0854986', '1261479', '1449282001', '1449282600', '25501711', '7727595', '854880', '854881', '854884', '854950', '854982', '854986', '90128079', '90128082', '90234204', '90280056') AND o.manufacturerId=84) OR ( o.oemSearch IN ('854881') AND o.manufacturerId=88) OR ( o.oemSearch IN ('8671002731', '8671011841', '8671011884', '8671011990') AND o.manufacturerId=93) OR ( o.oemSearch IN ('270249208701', 'GEX77372') AND o.manufacturerId=95) OR ( o.oemSearch IN ('115608100', '6U0253353', '854986') AND o.manufacturerId=106) OR ( o.oemSearch IN ('1261479', '14492820', '1449282001', '854880') AND o.manufacturerId=109) OR ( o.oemSearch IN ('1449282001') AND o.manufacturerId=253) OR ( o.oemSearch IN ('0854884', '0854982', '0854986', '1261479', '1449282001', '1449282600', '25501711', '7727595', '854880', '854881', '854884', '854982', '854986', '90125082', '90128079', '90128082', '90234204', '90280056') AND o.manufacturerId=117) OR ( o.oemSearch IN ('1261479', '1449282001', '1449282600', '25501711', '3446572', '7727595', '854880', '854881', '90128079') AND o.manufacturerId=120))