SUM(CASE WHEN `url` LIKE 'mixes-mp3/%' THEN 1 ELSE 0 END) AS rutas_bucket_mixes_mp3, SUM(CASE WHEN `url` LIKE 'DJIMMY-PANDA/%' THEN 1 ELSE 0 END) AS rutas_bucket_djimmy_panda, SUM(CASE WHEN `url` LIKE ...