4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Júpiter Leonés - UD Santa Marta
Jornada 30
FINALIZADO
20
30
292 Pts. Elo

311 Pts. Elo

1-2
Sábado, 07 Marzo 2020, 15:45
Romano 9'
1 - 0
1 - 1
 39' S. Montes
1 - 2
 73' L. Galiano

Eventos del partido

Goles

RomanoGol de falta
Romano
minuto 9'
minuto 39'S. MontesGol de penalti S. Montes
minuto 73'L. GalianoGol de L. Galiano

Tarjetas

minuto 37'MitoT. Amarilla Mito
RomanoT. Amarilla
Romano
minuto 38'
minuto 52'Jose Luis AsensioT. Amarilla Jose Luis Asensio
minuto 70'LoloT. Amarilla Lolo
Abel De PradoT. Amarilla
Abel De Prado
minuto 72'

Cambios

Juan RodriguezEntra en el partido
Juan Rodriguez
minuto 45'
O. AtayevSale del partido
O. Atayev
minuto 45'
ÁlvarezEntra en el partido
Álvarez
minuto 55'
TitoSale del partido
Tito
minuto 55'
WillySale del partido
Willy
minuto 70'
minuto 70'MitoSale del partido Mito
MohaEntra en el partido
Moha
minuto 70'
minuto 70'AarónEntra en el partido Aarón
minuto 79'Raúl ArroyoEntra en el partido Raúl Arroyo
minuto 79'Jorge GarcíaSale del partido Jorge García
minuto 82'A. MartiñaEntra en el partido A. Martiña
minuto 82'LermaSale del partido Lerma

Alineaciones

Júpiter Leonés

Júpiter Leonés

4-4-2
Alineación Inicial
Suplentes
UD Santa Marta

UD Santa Marta

4-4-2
Alineación Inicial
Suplentes


Partido televisado en...
Canal Medio Idioma País
FoottersFootters TV Castellano es

  USO DE MEMORIA  
6,713,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3280
Total Execution Time  0.3290
  CADENA URL  
/partido/C-Leonesa-B/Ud-Santa-Marta-Tormes/2020
  GET DATOS  
$_GET['/partido/C-Leonesa-B/Ud-Santa-Marta-Tormes/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT data1 FROM stats2020 t WHERE league_id = 50276 AND teamId = 6292136 and type = 33
0.0018  SELECT data1 FROM stats2020 t WHERE league_id = 50276 AND teamId = 6292171 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 = '127152' and rp.type = 2020 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 = 127152 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 127152 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='127152' AND `active` = 1 AND year = 2020
0.0031  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='50276' AND relp.team_id=6292136 WHERE relp.in_squad=1 and mp.`match_id` = '127152' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0025  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='50276' AND relp.team_id=6292171 WHERE relp.in_squad=1 and mp.`match_id` = '127152' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=127152 AND extraId = 50276 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 127152 AND league_id = 50276 AND year = 2020