Error al cargar el ranking. Inténtalo de nuevo. (SQL Error: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYfd=107' (OS errno 28 - No space left on device) (Connection: frpg, SQL: select `users`.`username`, `users_puntos_grupos`.`posicion`, `users_puntos_grupos`.`puntos`, IF(users.url is not null, users.url, LOWER(username)) as url, participaciones_grupos.nombre as nombre, CAST(COALESCE(SUM(CASE WHEN pj.respuesta IS NOT NULL THEN pj.respuestas ELSE 0 END), 0) AS UNSIGNED) as pronosticos, users.id as user_id, CAST(COALESCE(SUM(CASE WHEN p.id IS NOT NULL THEN TIMESTAMPDIFF(SECOND, GREATEST(p.created_at, p.updated_at), pj.date_end) ELSE 0 END), 0) AS SIGNED) as tiempo_diferencia, CONCAT(FLOOR(COALESCE(SUM(CASE WHEN p.id IS NOT NULL THEN TIMESTAMPDIFF(SECOND, GREATEST(p.created_at, p.updated_at), pj.date_end) ELSE 0 END), 0) / 86400), " días, ", FLOOR((COALESCE(SUM(CASE WHEN p.id IS NOT NULL THEN TIMESTAMPDIFF(SECOND, GREATEST(p.created_at, p.updated_at), pj.date_end) ELSE 0 END), 0) % 86400) / 3600), " horas, ", FLOOR((COALESCE(SUM(CASE WHEN p.id IS NOT NULL THEN TIMESTAMPDIFF(SECOND, GREATEST(p.created_at, p.updated_at), pj.date_end) ELSE 0 END), 0) % 3600) / 60), " minutos") as tiempo_diferencia_formateado from `users_puntos_grupos` inner join `participaciones_grupos` on `participaciones_grupos`.`id` = `users_puntos_grupos`.`grupo_id` inner join `users` on `users`.`id` = `users_puntos_grupos`.`user_id` inner join `participaciones_juegos` as `pj` on `pj`.`grupo_id` = `participaciones_grupos`.`id` inner join `participaciones` as `p` on `p`.`juego_id` = `pj`.`id` and `p`.`user_id` = `users`.`id` where `participaciones_grupos`.`id` in (6) and `pj`.`respuesta` is not null and `p`.`puntos` is not null group by `users`.`id`, `users`.`username`, `users_puntos_grupos`.`posicion`, `users_puntos_grupos`.`puntos`, `users`.`url`, `participaciones_grupos`.`nombre` order by `posicion` asc limit 10 offset 3400))