4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Valerenga IF - Odd
Jornada 20
FINALIZADO
00
20
1058 Pts. Elo
44%
12º

972 Pts. Elo
55%
9º

2-2
Domingo, 27 Agosto 2023, 17:00
0 - 1
 8' D. Gjengaar
S. Johansen 19'
1 - 1
Eneo Bitri 39'
2 - 1
2 - 2
 67' E. Midtskogen

Eventos del partido

Goles

minuto 8'D. GjengaarGol de D. Gjengaar
S. Johansen Gol de (p.p)
S. Johansen
minuto19'
Eneo BitriGol de
Eneo Bitri
minuto 39'
minuto 67'E. MidtskogenGol de E. Midtskogen

Tarjetas

minuto 84'A. MugeeseT. Amarilla A. Mugeese
minuto 91'E. RuudT. Amarilla E. Ruud

Cambios

minuto 75'A. MugeeseEntra en el partido A. Mugeese
minuto 75'Tobias SvendsenEntra en el partido Tobias Svendsen
minuto 75'S. OwusuSale del partido S. Owusu
minuto 75'E. MidtskogenSale del partido E. Midtskogen
minuto 75'M. IngebrigtsenEntra en el partido M. Ingebrigtsen
minuto 75'D. GjengaarSale del partido D. Gjengaar
Torgeir BørvenEntra en el partido
Torgeir Børven
minuto 76'
Andrej IlicSale del partido
Andrej Ilic
minuto 76'
Mohamed OfkirSale del partido
Mohamed Ofkir
minuto 85'
J. Dicko EngEntra en el partido
J. Dicko Eng
minuto 85'
minuto 92'Leon HienEntra en el partido Leon Hien
minuto 92'J. BaccaySale del partido J. Baccay

Otros

Elias HagenAsistencia
Elias Hagen
minuto 39'
minuto 67'E. RuudAsistencia E. Ruud
minuto 91'J. BaccayLesionado J. Baccay

Alineaciones

Valerenga IF

Valerenga IF

4-4-2
Alineación Inicial
Suplentes
Odd

Odd

3-6-1
Alineación Inicial
Suplentes

Estadísticas del partido

Valerenga IF Valerenga Odd Odd
44%
Posesión del balón
 55%
2
Goles
 2
3
Tiros a puerta
 4
6
Tiros fuera
 6
15
Total tiros
 13
2
Paradas del portero
 2
8
Saques de esquina
 5
0
Tarjetas Rojas
 0
1
Asistencias
 1
0
Lesiones
 1
2
Sustituciones
 3
7
Faltas
 6


  USO DE MEMORIA  
6,645,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3998
Total Execution Time  0.4008
  CADENA URL  
/partido/Valerenga-If-Oslo/Odd-Grenland-Skien/2007?section=legal
  GET DATOS  
$_GET['/partido/Valerenga-If-Oslo/Odd-Grenland-Skien/2007']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0137   SELECT c.*, c.stadium as real_stadium, 2024 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 calendars2024 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 = 'Valerenga-If-Oslo' AND dt2.basealias = 'Odd-Grenland-Skien'
0.0187   SELECT c.*, c.stadium as real_stadium, 2025 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 calendars2025 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 = 'Valerenga-If-Oslo' AND dt2.basealias = 'Odd-Grenland-Skien'
0.0125  SELECT data1 FROM stats2023 t WHERE league_id = 70738 AND teamId = 6563400 and type = 33
0.0125  SELECT data1 FROM stats2023 t WHERE league_id = 70738 AND teamId = 6563394 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 = '574026' and rp.type = 2023 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 574026 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 574026 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='574026' AND `active` = 1 AND year = 2023
0.0198  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='70738' AND relp.team_id=6563400 WHERE relp.in_squad=1 and mp.`match_id` = '574026' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0182  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='70738' AND relp.team_id=6563394 WHERE relp.in_squad=1 and mp.`match_id` = '574026' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=574026 AND extraId = 70738 AND type_rel = 4
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 574026 AND league_id = 70738 AND year = 2023