4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Heerenveen - TOP Oss
Jornada 31
FINALIZADO
00
00
2255 Pts. Elo

772 Pts. Elo

4-1
Martes, 05 Julio 2022, 19:00
Thom Haye 2'
1 - 0
Rami Al Hajj 9'
2 - 0
S. Van Beek 41'
3 - 0
Ian Beelen 70'
4 - 0
4 - 1
 91' Kay Tejan

Eventos del partido

Goles

Thom HayeGol de
Thom Haye
minuto 2'
Rami Al HajjGol de
Rami Al Hajj
minuto 9'
S. Van BeekGol de
S. Van Beek
minuto 41'
Ian BeelenGol de
Ian Beelen
minuto 70'
minuto 91'Kay TejanGol de Kay Tejan

Cambios

minuto 43'N. AbdatEntra en el partido N. Abdat
minuto 43'L. PiquéSale del partido L. Piqué
T. HalilovićSale del partido
T. Halilović
minuto 46'
Amin SarrSale del partido
Amin Sarr
minuto 46'
Trustin Van T LooEntra en el partido
Trustin Van T Loo
minuto 46'
Mats KöhlertSale del partido
Mats Köhlert
minuto 46'
D. NunumeteEntra en el partido
D. Nunumete
minuto 46'
S. Van BeekSale del partido
S. Van Beek
minuto 46'
Timo ZaalEntra en el partido
Timo Zaal
minuto 46'
Ian BeelenEntra en el partido
Ian Beelen
minuto 46'
S. Van OtteleEntra en el partido
S. Van Ottele
minuto 46'
P. BochniewiczSale del partido
P. Bochniewicz
minuto 46'
Van Der VeldtEntra en el partido
Van Der Veldt
minuto 46'
J. Van AkenSale del partido
J. Van Aken
minuto 46'
minuto 46'Kay TejanEntra en el partido Kay Tejan
minuto 46'K. LeidsmanSale del partido K. Leidsman
minuto 46'A. AllemeerschEntra en el partido A. Allemeersch
minuto 46'T. BeekmanSale del partido T. Beekman
minuto 46'D. LadanEntra en el partido D. Ladan
minuto 46'J. MathieuSale del partido J. Mathieu
Thom HayeSale del partido
Thom Haye
minuto 46'
Rami KaibEntra en el partido
Rami Kaib
minuto 46'
Anas TahiriSale del partido
Anas Tahiri
minuto 46'
A. Van Der HeideEntra en el partido
A. Van Der Heide
minuto 46'
Rami Al HajjSale del partido
Rami Al Hajj
minuto 46'
B. GudnasonEntra en el partido
B. Gudnason
minuto 46'
minuto 55'M. AfakerEntra en el partido M. Afaker
minuto 55'Jearl MargarithaSale del partido Jearl Margaritha
minuto 63'B. FrankenEntra en el partido B. Franken
minuto 63'Dehninio MuringenSale del partido Dehninio Muringen
minuto 63'M. HilderinkEntra en el partido M. Hilderink
minuto 63'R. Van Den HerikSale del partido R. Van Den Herik
minuto 63'LeeflangEntra en el partido Leeflang
minuto 63'İ. PataSale del partido İ. Pata

Otros

Mats KöhlertAsistencia
Mats Köhlert
minuto 9'

Alineaciones

Heerenveen

Heerenveen

3-5-2
Alineación Inicial
Suplentes
TOP Oss

TOP Oss

4-5-1
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,901,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Match / Index )  0.3754
Total Execution Time  0.3767
  CADENA URL  
/partido/Heerenveen/Fc-Oss/2022?section=legal
  GET DATOS  
$_GET['/partido/Heerenveen/Fc-Oss/2022']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0029   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 = 'Heerenveen' AND dt2.basealias = 'Fc-Oss'
0.0056   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 = 'Heerenveen' AND dt2.basealias = 'Fc-Oss'
0.0018  SELECT data1 FROM stats2023 t WHERE league_id = 67320 AND teamId = 6515163 and type = 33
0.0018  SELECT data1 FROM stats2023 t WHERE league_id = 67320 AND teamId = 6515210 and type = 33
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '664' and rp.type = 2023 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 664 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 664 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='664' AND `active` = 1 AND year = 2023
0.0035  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='67320' AND relp.team_id=6515163 WHERE relp.in_squad=1 and mp.`match_id` = '664' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0073  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='67320' AND relp.team_id=6515210 WHERE relp.in_squad=1 and mp.`match_id` = '664' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=664 AND extraId = 67320 AND type_rel = 4
0.0025  SELECT position FROM tables2023 WHERE team=6515163 AND league_id=67320 AND round=31
0.0018  SELECT position FROM tables2023 WHERE team=6515210 AND league_id=67320 AND round=31
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 664 AND league_id = 67320 AND year = 2023