¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Pumas UNAM Sub 23 - Club Tijuana Sub 23
Jornada 9
FINALIZADO
10
20
13º

10º

0(3-4)0
Domingo, 22 Septiembre 2024, 17:00

Eventos del partido

Tarjetas

Tiago GuthT. Amarilla
Tiago Guth
minuto 46'
minuto 57'Héctor UriasT. Amarilla Héctor Urias
minuto 74'Eduardo ArmentaT. Amarilla Eduardo Armenta

Cambios

Tiago GuthEntra en el partido
Tiago Guth
minuto 46'
R. GalindoSale del partido
R. Galindo
minuto 46'
Sebastián VenegasSale del partido
Sebastián Venegas
minuto 62'
M. HernándezEntra en el partido
M. Hernández
minuto 62'
minuto 64'Joban GonzálezEntra en el partido Joban González
minuto 64'Héctor UriasSale del partido Héctor Urias
minuto 68'Ramón PalomaresEntra en el partido Ramón Palomares
minuto 68'Octavio VázquezEntra en el partido Octavio Vázquez
minuto 68'M. QuiñonezSale del partido M. Quiñonez
minuto 68'B. OrdoricaSale del partido B. Ordorica
Y. Del ValleSale del partido
Y. Del Valle
minuto 75'
Leider MontañoEntra en el partido
Leider Montaño
minuto 75'
Felix RayaSale del partido
Felix Raya
minuto 75'
C. MundoEntra en el partido
C. Mundo
minuto 75'
minuto 78'Jaime ÁlvarezSale del partido Jaime Álvarez
minuto 78'G. VázquezEntra en el partido G. Vázquez
minuto 78'Emilio RuizEntra en el partido Emilio Ruiz
minuto 78'Eduardo ArmentaSale del partido Eduardo Armenta

Alineaciones

Pumas UNAM Sub 23

Pumas UNAM Sub 23

4-4-2
Alineación Inicial
Suplentes
Club Tijuana Sub 23

Club Tijuana Sub 23

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

Pumas UNAM Sub 23 Pumas UNAM Club Tijuana Sub 23 Club Tijuana
0
Goles
 0
2
Tarjetas Amarillas
 1
0
Tarjetas Rojas
 0
3
Sustituciones
 3


  USO DE MEMORIA  
7,391,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.8934
Total Execution Time  0.8944
  CADENA URL  
/partido/Pumas-Unam-Sub-23/Club-Tijuana-Sub-23
  GET DATOS  
$_GET['/partido/Pumas-Unam-Sub-23/Club-Tijuana-Sub-23']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 76942 AND teamId = 6654074 and type = 33
0.0018  SELECT data1 FROM stats2025 t WHERE league_id = 76942 AND teamId = 6654061 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 = '63029' and rp.type = 2025 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 = 63029 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 63029 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='63029' AND `active` = 1 AND year = 2025
0.0066  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='76942' AND relp.team_id=6654074 WHERE relp.in_squad=1 and mp.`match_id` = '63029' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0051  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='76942' AND relp.team_id=6654061 WHERE relp.in_squad=1 and mp.`match_id` = '63029' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63029 AND extraId = 76942 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2832 AND type_rel = 3
0.0017  SELECT avg_rating FROM elo_teams WHERE id=159063
0.0017  SELECT avg_rating FROM elo_teams WHERE id=159064
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 63029 AND league_id = 76942 AND year = 2025