-- Check for non-sneaker brands
SELECT brand, COUNT(*) c FROM products WHERE brand IN ('Hogan', 'Barracuda', 'Mason Garments', 'Nubikk') GROUP BY brand ORDER BY c DESC;
-- Sample Hogan products
SELECT name FROM products WHERE brand = 'Hogan' LIMIT 5;
-- Sample Barracuda  
SELECT name FROM products WHERE brand = 'Barracuda' LIMIT 5;
-- Check for non-sneaker keywords
SELECT COUNT(*) FROM products WHERE lower(name) LIKE '%slipper%' OR lower(name) LIKE '%sandal%' OR lower(name) LIKE '%boot%' OR lower(name) LIKE '%loafer%' OR lower(name) LIKE '%pump%' OR lower(name) LIKE '%heel%';
-- Feed distribution
SELECT f.name, COUNT(po.id) offers, COUNT(DISTINCT po.product_id) products FROM feeds f JOIN product_offers po ON po.feed_id = f.id GROUP BY f.name;
