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

Chornomorets Odessa

Entrenador: Roman Grygorchuk

Temporada 2023/2024

Estadísticas

ASISTENCIAS
V. Vakula3
A. Shtogrin3
Ziguy Badibanga3
M. Braharu2
A. Avagimian2
O. Kuzyk1
Samson Iyede1
I. Putria1
Dadá Belmonte1
B. Boychuk1
J. Sporn1
M. Grysyo1
ENTRA
G. Hadida12
A. Avagimian11
S. Bolbat11
V. Ogirya8
V. Vakula8
Samson Iyede7
B. Boychuk6
Zé Gomes6
Danylo Golub6
Dadá Belmonte5
F. Alvarenga5
A. Prysiazhniuk4
Ziguy Badibanga3
Luka Gucek3
A. Shtogrin2
O. Kuzyk2
Jack Ipalibo2
V. Salyuk1
M. Grysyo1
Ilya Ukhan1
SALE
Samson Iyede11
O. Kuzyk10
B. Boychuk8
A. Shtogrin7
A. Avagimian6
J. Sporn6
M. Grysyo6
Oleksandr Vasyliev5
Ziguy Badibanga5
V. Vakula5
Luka Gucek4
G. Hadida3
Dadá Belmonte3
I. Putria3
V. Shapoval3
S. Bolbat3
M. Braharu2
F. Alvarenga1
V. Ogirya1

  USO DE MEMORIA  
5,190,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1585
Total Execution Time  0.1597
  CADENA URL  
/estadisticas/Chornomorets
  GET DATOS  
$_GET['/estadisticas/Chornomorets']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0149  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 = '5825' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0163  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 = 72212 WHERE rp.league_id = 72212 AND rp.teamId = 5825 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0168  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 = 72212 WHERE rp.league_id = 72212 AND rp.teamId = 5825 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 72212 WHERE rp.league_id = 72212 AND rp.teamId = 5825 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30