4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
OJC Rosmalen - SV TEC Tiel
Jornada 17
FINALIZADO
60
40
215 Pts. Elo
14º

302 Pts. Elo
6º

2-0
Sábado, 16 Diciembre 2023, 19:00
D. Meurs 76'
1 - 0
Nigel De Weerd 90'
2 - 0

OJC Rosmalen

4-4-2
Alineación Inicial
Suplentes

SV TEC Tiel

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

Gol de
D. Meurs
minuto 76'
Gol de
Nigel De Weerd
minuto 90'

Tarjetas

minuto 38'T. Amarilla P. Van Anholt
T. Amarilla
B. Zonnenberg
minuto 57'
T. Amarilla
Y. Aharchaou
minuto 71'
minuto 75'T. Amarilla J. Antonia
T. Amarilla
Lex Van Dijk
minuto 78'
minuto 78'T. Amarilla F. Serrarens
T. Amarilla
T. Pijnenburg
minuto 90'
minuto 90'T. Amarilla Givon Derby
T. Amarilla
D. De Bijl
minuto 90'
T. Amarilla
D. Van Tooren
minuto 90'

Cambios

minuto 61'Entra en el partido R. Roshanali
Entra en el partido
Nigel De Weerd
minuto 61'
minuto 61'Sale del partido M. El Makrini
Sale del partido
B. Zonnenberg
minuto 61'
minuto 61'Entra en el partido A. Valpoort
minuto 61'Sale del partido Anderson Lopez
Sale del partido
Y. Aharchaou
minuto 78'
Entra en el partido
D. De Bijl
minuto 78'
Entra en el partido
Z. Azizov
minuto 82'
minuto 82'Entra en el partido Niall Raben
Sale del partido
M. Hassan
minuto 82'
minuto 82'Sale del partido G. Van Rijn
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,841,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Match / Index )  0.4169
Total Execution Time  0.4184
  CADENA URL  
/partido/Ojc-Rosmalen/Sv-Tielse-Eendracht-Combinatie/2024
  GET DATOS  
$_GET['/partido/Ojc-Rosmalen/Sv-Tielse-Eendracht-Combinatie/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0063  SELECT data1 FROM stats2024 t WHERE league_id = 72700 AND teamId = 6591981 and type = 33
0.0045  SELECT data1 FROM stats2024 t WHERE league_id = 72700 AND teamId = 6591985 and type = 33
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '152584' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0034  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 152584 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 152584 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0030  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='152584' AND `active` = 1 AND year = 2024
0.0041  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='72700' AND relp.team_id=6591981 WHERE relp.in_squad=1 and mp.`match_id` = '152584' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0063  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='72700' AND relp.team_id=6591985 WHERE relp.in_squad=1 and mp.`match_id` = '152584' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=152584 AND extraId = 72700 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=225 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 225 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (643398,640930,407176,308163,31304) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 152584 AND league_id = 72700 AND year = 2024