¿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
Mazatlán Sub 17 - Atl. San Luis Sub 17
Jornada 13
FINALIZADO
20
10
171 Pts. Elo
18º

179 Pts. Elo
13º

0-1
Martes, 19 Noviembre 2024, 19:30
0 - 1
 31' Juan Juárez

Eventos del partido

Goles

minuto 31'Juan JuárezGol de Juan Juárez

Tarjetas

minuto 50'Ángel AbundisT. Amarilla Ángel Abundis
S. ManzoT. Amarilla
S. Manzo
minuto 55'
Diego MontoyaT. Amarilla
Diego Montoya
minuto 70'

Cambios

minuto 46'Á. NúñezEntra en el partido Á. Núñez
minuto 46'Adler GonzálezSale del partido Adler González
Víctor MiramontesEntra en el partido
Víctor Miramontes
minuto 60'
Tristan FriasSale del partido
Tristan Frias
minuto 60'
Maximiliano AlvarezEntra en el partido
Maximiliano Alvarez
minuto 60'
Angel PalaciosSale del partido
Angel Palacios
minuto 60'
minuto 65'Juan JuárezSale del partido Juan Juárez
minuto 65'José SánchezEntra en el partido José Sánchez
J. RamírezEntra en el partido
J. Ramírez
minuto 73'
Jaime EstradaSale del partido
Jaime Estrada
minuto 73'
Fernando FonsecaSale del partido
Fernando Fonseca
minuto 73'
Diego MontoyaSale del partido
Diego Montoya
minuto 73'
Bengie MuñozEntra en el partido
Bengie Muñoz
minuto 73'
Alex CarrilloEntra en el partido
Alex Carrillo
minuto 73'
minuto 74'Maddox MontalvoSale del partido Maddox Montalvo
minuto 74'Hugo PadiernaEntra en el partido Hugo Padierna
Víctor VegaSale del partido
Víctor Vega
minuto 81'
Miguel OsunaEntra en el partido
Miguel Osuna
minuto 81'
Irving VirgenSale del partido
Irving Virgen
minuto 81'
Axel MartínezEntra en el partido
Axel Martínez
minuto 81'
minuto 84'Ángel ChávezSale del partido Ángel Chávez
minuto 84'Guillermo LópezSale del partido Guillermo López
minuto 84'Gael VegaEntra en el partido Gael Vega
minuto 84'Diego CerdaEntra en el partido Diego Cerda
minuto 84'Angel EscutiaSale del partido Angel Escutia
minuto 84'Aarón RamírezEntra en el partido Aarón Ramírez

Alineaciones

Mazatlán Sub 17

Mazatlán Sub 17

4-4-2
Alineación Inicial
Suplentes
Atl. San Luis Sub 17

Atl. San Luis Sub 17

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,488,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  1.1325
Total Execution Time  1.1335
  CADENA URL  
/partido_77179/Mazatlan-Sub17/Atletico-San-Luis-Sub17
  GET DATOS  
$_GET['/partido_77179/Mazatlan-Sub17/Atletico-San-Luis-Sub17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77179 AND teamId = 6658592 and type = 33
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77179 AND teamId = 6658597 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 = '106581' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 106581 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 106581 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0017  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='106581' AND `active` = 1 AND year = 2025
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='77179' AND relp.team_id=6658592 WHERE relp.in_squad=1 and mp.`match_id` = '106581' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0062  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='77179' AND relp.team_id=6658597 WHERE relp.in_squad=1 and mp.`match_id` = '106581' 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=106581 AND extraId = 77179 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1820 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1820 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (816274,756230,728971,694062) ORDER BY n.cover_points DESC, update_date DESC
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 106581 AND league_id = 77179 AND year = 2025