4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Dnipro-1 - Metalist 1925 Kharkiv
Jornada 24
FINALIZADO
20
30
282 Pts. Elo
1º

278 Pts. Elo
2º

1-0
Sábado, 07 Abril 2018, 17:00
  • Asistencia: 4.000 espectadores
S. Loginov 34'
1 - 0

Eventos del partido

Goles

S. LoginovGol de
S. Loginov
minuto 34'

Tarjetas

minuto 33'A. RalyuchenkoT. Amarilla A. Ralyuchenko
minuto 50'O. ZhdanovT. Amarilla O. Zhdanov
minuto 82'Y. BulychevT. Amarilla Y. Bulychev
S. PeredystyiT. Amarilla
S. Peredystyi
minuto 83'
M. LopyronokT. Amarilla
M. Lopyronok
minuto 88'

Cambios

I. KogutSale del partido
I. Kogut
minuto 57'
A. BelyaevEntra en el partido
A. Belyaev
minuto 57'
minuto 61'S. RomanovSale del partido S. Romanov
minuto 61'D. SkotarenkoEntra en el partido D. Skotarenko
minuto 67'EdmarSale del partido Edmar
minuto 67'Y. BulychevEntra en el partido Y. Bulychev
Y. PoplavkaEntra en el partido
Y. Poplavka
minuto 69'
R. MemeshevSale del partido
R. Memeshev
minuto 69'
minuto 71'A. RalyuchenkoSale del partido A. Ralyuchenko
minuto 71'V. SidorenkoEntra en el partido V. Sidorenko
E. ChegurkoSale del partido
E. Chegurko
minuto 80'
S. PeredystyiEntra en el partido
S. Peredystyi
minuto 80'
V. KireevEntra en el partido
V. Kireev
minuto 90'
V. SupryagaSale del partido
V. Supryaga
minuto 90'

Alineaciones

Dnipro-1

Dnipro-1

4-4-2
Alineación Inicial
Suplentes
Metalist 1925 Kharkiv

Metalist 1925 Kharkiv

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,817,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.4088
Total Execution Time  0.4098
  CADENA URL  
/partido/Sk-Dnipro-1/Fc-Metalist-1925-Kharkiv/2018
  GET DATOS  
$_GET['/partido/Sk-Dnipro-1/Fc-Metalist-1925-Kharkiv/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0143   SELECT c.*, c.stadium as real_stadium, 2018 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2018 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Sk-Dnipro-1' AND dt2.basealias = 'Fc-Metalist-1925-Kharkiv'
0.0109  SELECT c.*, 2018 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2018 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Sk-Dnipro-1' AND dt2.basealias = 'Fc-Metalist-1925-Kharkiv'
0.0105  SELECT data1 FROM stats2018 t WHERE league_id = 38898 AND teamId = 788141 and type = 33
0.0105  SELECT data1 FROM stats2018 t WHERE league_id = 38898 AND teamId = 788151 and type = 33
0.0107  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '786725' and rp.type = 2018 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 786725 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 786725 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0106  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='786725' AND `active` = 1 AND year = 2018
0.0114  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='38898' AND relp.team_id=788141 WHERE relp.in_squad=1 and mp.`match_id` = '786725' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0115  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='38898' AND relp.team_id=788151 WHERE relp.in_squad=1 and mp.`match_id` = '786725' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=786725 AND extraId = 38898 AND type_rel = 4
0.0108  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1530 AND type_rel = 3
0.0108  SELECT avg_rating FROM elo_teams WHERE id=101756
0.0108  SELECT * FROM futbol.calendars_lineups WHERE id = 786725 AND league_id = 38898 AND year = 2018