4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jerv - Tromsdalen
Jornada 30
FINALIZADO
20
10
600 Pts. Elo
13º

453 Pts. Elo
7º

0-1
Domingo, 11 Noviembre 2018, 13:00
0 - 1
 90' L. Andreassen

Eventos del partido

Goles

minuto 90'L. AndreassenGol de penalti L. Andreassen

Tarjetas

P. ReinhardsenT. Amarilla
P. Reinhardsen
minuto 27'
minuto 42'V. LysvollT. Amarilla V. Lysvoll
U. BerglannT. Amarilla
U. Berglann
minuto 90'

Cambios

minuto 65'L. AndreassenEntra en el partido L. Andreassen
minuto 65'A. KarlsenSale del partido A. Karlsen
H. SuggeliaEntra en el partido
H. Suggelia
minuto 72'
T. ZernichowSale del partido
T. Zernichow
minuto 72'
S. OkoliEntra en el partido
S. Okoli
minuto 77'
A. KhaliliSale del partido
A. Khalili
minuto 77'

Alineaciones

Jerv

Jerv

4-4-2
Alineación Inicial
Suplentes
Tromsdalen

Tromsdalen

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,798,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.2770
Total Execution Time  0.2781
  CADENA URL  
/partido/Jerv/Tromsdalen/2018
  GET DATOS  
$_GET['/partido/Jerv/Tromsdalen/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0125  SELECT data1 FROM stats2018 t WHERE league_id = 42251 AND teamId = 856923 and type = 33
0.0125  SELECT data1 FROM stats2018 t WHERE league_id = 42251 AND teamId = 856929 and type = 33
0.0127  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '709309' and rp.type = 2018 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 709309 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 709309 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0126  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='709309' AND `active` = 1 AND year = 2018
0.0133  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='42251' AND relp.team_id=856923 WHERE relp.in_squad=1 and mp.`match_id` = '709309' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0132  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='42251' AND relp.team_id=856929 WHERE relp.in_squad=1 and mp.`match_id` = '709309' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=709309 AND extraId = 42251 AND type_rel = 4
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 709309 AND league_id = 42251 AND year = 2018