4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
UM Escobedo - Atlético Mineros
Jornada 8
FINALIZADO
30
20
96 Pts. Elo
2º

48 Pts. Elo
18º

2-0
Domingo, 29 Octubre 2023, 12:00
G. Peña 28'
1 - 0
M. Bastante 61'
2 - 0

Eventos del partido

Goles

G. PeñaGol de penalti
G. Peña
minuto 28'
M. BastanteGol de
M. Bastante
minuto 61'

Tarjetas

minuto 27'GuillermoT. Amarilla Guillermo
minuto 33'JacoboT. Amarilla Jacobo
Joan MartínT. Amarilla
Joan Martín
minuto 42'
PicónT. Amarilla
Picón
minuto 55'
VíctorT. Amarilla
Víctor
minuto 75'

Cambios

minuto 13'KimiEntra en el partido Kimi
minuto 13'I. CoboSale del partido I. Cobo
minuto 44'A. VillanuevaEntra en el partido A. Villanueva
minuto 44'D. RiveroSale del partido D. Rivero
Joan MartínSale del partido
Joan Martín
minuto 55'
DaniEntra en el partido
Dani
minuto 55'
minuto 57'Diego VillarSale del partido Diego Villar
minuto 57'J. SarasEntra en el partido J. Saras
Javier MoralesSale del partido
Javier Morales
minuto 65'
LuchoEntra en el partido
Lucho
minuto 65'
S. BasterrecheaEntra en el partido
S. Basterrechea
minuto 65'
M. BastanteSale del partido
M. Bastante
minuto 65'
SomazaSale del partido
Somaza
minuto 70'
FerminSale del partido
Fermin
minuto 70'
A. PelayoEntra en el partido
A. Pelayo
minuto 70'
Izam OrtizEntra en el partido
Izam Ortiz
minuto 70'

Alineaciones

UM Escobedo

UM Escobedo

4-4-2
Alineación Inicial
Suplentes
Atlético Mineros

Atlético Mineros

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,769,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3647
Total Execution Time  0.3657
  CADENA URL  
/partido/Um-Escobedo/Atletico-Minero-Senior/2024?section=legal
  GET DATOS  
$_GET['/partido/Um-Escobedo/Atletico-Minero-Senior/2024']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0045  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72262
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72262 AND teamId = 6586155 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72262 AND teamId = 6586157 and type = 33
0.0023  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '420629' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 420629 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 420629 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0022  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72262 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='420629' AND `active` = 1 AND year = 2024
0.0034  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='72262' AND relp.team_id=6586155 WHERE relp.in_squad=1 and mp.`match_id` = '420629' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0028  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='72262' AND relp.team_id=6586157 WHERE relp.in_squad=1 and mp.`match_id` = '420629' 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=420629 AND extraId = 72262 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 420629 AND league_id = 72262 AND year = 2024