-- ============================================================================
-- Update UEFA Competition Popularity - QUICK FIX
-- Date: 2026-01-22
-- Description: Set UEFA competitions to top popularity (100) like Premier League
-- Safe to run anytime - just updates existing popularity values
-- ============================================================================

-- Major European Competitions - TOP PRIORITY (100)
UPDATE `soccer_leagues` SET `popularity` = 100 WHERE `name` LIKE '%UEFA Champions League%';
UPDATE `soccer_leagues` SET `popularity` = 100 WHERE `name` LIKE '%UEFA Europa League%' AND `name` NOT LIKE '%Conference%';
UPDATE `soccer_leagues` SET `popularity` = 95 WHERE `name` LIKE '%UEFA Europa Conference League%';

-- Verify the changes
SELECT 
    `id`,
    `name`, 
    `country`, 
    `popularity`
FROM `soccer_leagues`
WHERE `name` LIKE '%UEFA%' OR `popularity` = 100
ORDER BY `popularity` DESC, `name` ASC;
