4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atom Novovoronezh

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Atom Novovoronezh

Enviar Datos
Información

Partidos del Atom Novovoronezh

Ir al LIVESCORE

Estadísticas

GOLEADORES
S. Kolpakov1
AMARILLAS
V. Mezinov1
Ilya Korotkikh1

Noticias de Copa Rusa

Ver últimas noticias

Los penaltis le dan al CSKA la Copa una década después

BeSoccer - Domingo, 11 Junio 2023
0 1.397

El CSKA de Moscú se proclamó campeón de la Copa Rusa tras derrotar al Krasnodar en la tanda de penaltis. Tras el 1-1 del tiempo reglamentario, los de la capital se llevaron el título con un resultado de 6-5 tras una década de sequía.

Crisis en el fútbol ruso: el sistema Fan ID vacía los estadios

BeSoccer - Martes, 14 Marzo 2023
2 9.878

En el fútbol estadio se instaló el Fan ID, el sistema de identificación de aficionados al fútbol, y, desde entonces, ha provocado que las gradas estén más vacías. " Jugamos para los aficionados, pero no están", afirmó Alexandr Sóbolev, delantero del Spartak de Moscú.

¿Hasta cuándo? A Wendel y a Douglas Santos le lanzaron una banana desde la grada

BeSoccer - Sábado, 25 Febrero 2023
1 1.051

Durante el partido entre el Volga Ulyanovsk y el Zenit por la Copa Rusa, los futbolistas del equipo visitante Wendel y Douglas Santos fueron víctimas de un hecho racista. En el momento que el técnico decidió sustituirlos, la grada del cuadro local les lanzó una banana.

A falta de guerra en Rusia... ¡batalla campal en el Zenit-Spartak y 6 expulsados!

BeSoccer - Domingo, 27 Noviembre 2022
7 7.079

El partido entre el Zenit de San Petersburgo y el Spartak de Moscú quedó manchado absolutamente por una batalla campal pocas veces vista. La mayoría de los protagonistas acabaron pegándose y hasta seis futbolistas fueron expulsados.

Rusia se hace el sueco con el Mundial: su Copa seguirá jugándose

BeSoccer - Sábado, 12 Noviembre 2022
0 1.377

El fútbol ruso, marginado por la campaña militar rusa en Ucrania, no parará durante el Mundial de Catar. La Liga rusa se suspende durante casi cuatro meses a partir de este domingo, pero la Copa se jugará hasta finales de noviembre.

Ver más noticias del equipo»



  USO DE MEMORIA  
4,686,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0559
Total Execution Time  0.0578
  CADENA URL  
/Fc-Atom-Novovoronezh/2024
  GET DATOS  
$_GET['/Fc-Atom-Novovoronezh/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT type FROM routes WHERE alias = 'fc-atom-novovoronezh'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89492 AND type_rel = 2
0.0021  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '89492' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 89492 or c.datateam2 = 89492) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0020  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 89492 or c.datateam2 = 89492) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0020  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 89492 or c.datateam2 = 89492) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0019  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024_base as c ON c.league_id = l.id WHERE (c.datateam1 = 89492 or c.datateam2 = 89492) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0020  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024_base as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 89492 or c.datateam2 = 89492) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0020  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024_base as c ON c.league_id = l.id INNER JOIN events2024_base as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players_base rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 89492 or c.datateam2 = 89492) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0020  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '89492' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '89492' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '89492' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73402 WHERE rp.league_id = 73402 AND rp.teamId = 89492 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73402 WHERE rp.league_id = 73402 AND rp.teamId = 89492 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73402 WHERE rp.league_id = 73402 AND rp.teamId = 89492 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30