SELECT b.name, b.logo_url, 
  (SELECT COUNT(DISTINCT p.id) FROM products p JOIN product_offers po ON po.product_id = p.id AND po.in_stock = true WHERE LOWER(p.brand) = LOWER(b.name) AND p.is_sneaker = true) as products
FROM brands b 
WHERE LOWER(b.name) IN ('nike','adidas','new balance','jordan','puma','asics','hoka','on','vans','nubikk','mizuno','reebok','converse')
ORDER BY products DESC;
