4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Getafe B - Marbella FC
Semifinales
FINALIZADO
50
40
362 Pts. Elo

347 Pts. Elo

0-0
Domingo, 12 Mayo 2024, 11:30
  • Estadio: Ciudad Deportiva Fernando Santos de la Parra

Eventos del partido

Tarjetas

minuto 35'Marcos OlguínT. Amarilla Marcos Olguín
Rafa DizT. Amarilla
Rafa Diz
minuto 46'
Facu EsnaiderT. Amarilla
Facu Esnaider
minuto 49'
minuto 73'Aitor PuñalT. Amarilla Aitor Puñal
minuto 80'Marco TulioT. Amarilla Marco Tulio
A. KeitaT. Amarilla
A. Keita
minuto 83'
Nico ConesaT. Amarilla
Nico Conesa
minuto 85'
Marcos DeniaT. Amarilla
Marcos Denia
minuto 87'
minuto 91'AleT. Amarilla Ale

Ocasiones

Jeremy JoséGol anulado
Jeremy José
minuto 69'

Cambios

Jeremy JoséEntra en el partido
Jeremy José
minuto 60'
A. ClaveríasSale del partido
A. Claverías
minuto 60'
A. KeitaEntra en el partido
A. Keita
minuto 60'
J. CarbonellSale del partido
J. Carbonell
minuto 60'
minuto 75'Juanma AcevedoEntra en el partido Juanma Acevedo
minuto 75'GatoSale del partido Gato
Marcos DeniaEntra en el partido
Marcos Denia
minuto 77'
G. CalçadaSale del partido
G. Calçada
minuto 77'
minuto 78'Fran MorenoEntra en el partido Fran Moreno
minuto 78'Jorge ÁlvarezSale del partido Jorge Álvarez
minuto 82'AleEntra en el partido Ale
minuto 82'Marco TulioSale del partido Marco Tulio
minuto 82'Jack HarperEntra en el partido Jack Harper
minuto 82'DagoSale del partido Dago
J. PatrickEntra en el partido
J. Patrick
minuto 86'
Rafa DizSale del partido
Rafa Diz
minuto 86'

Alineaciones

Getafe B

Getafe B

4-4-2
Alineación Inicial
Suplentes
Marbella FC

Marbella FC

3-4-3
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,686,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.3917
Total Execution Time  0.3929
  CADENA URL  
/partido/Getafe-B/Ud-Marbella
  GET DATOS  
$_GET['/partido/Getafe-B/Ud-Marbella']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 75887 AND teamId = 6637939 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 75887 AND teamId = 6637937 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '731211' and rp.type = 2024 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 = 731211 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 731211 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='731211' AND `active` = 1 AND year = 2024
0.0043  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='75887' AND relp.team_id=6637939 WHERE relp.in_squad=1 and mp.`match_id` = '731211' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0027  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='75887' AND relp.team_id=6637937 WHERE relp.in_squad=1 and mp.`match_id` = '731211' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=731211 AND extraId = 75887 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2616 AND type_rel = 3
0.0019  SELECT position FROM tables2024 WHERE team=6637939 AND league_id=75887 AND round=1
0.0019  SELECT position FROM tables2024 WHERE team=6637937 AND league_id=75887 AND round=1
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 731211 AND league_id = 75887 AND year = 2024