SELECT COUNT(*) FROM brands WHERE logo_url IS NOT NULL AND logo_url != '';
SELECT brand, COUNT(*) as cnt FROM products GROUP BY brand ORDER BY cnt DESC LIMIT 20;
