¿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
Mineros de Fresnillo - Tigres de Álica
Jornada 2
FINALIZADO
10
20
233 Pts. Elo
10º

5 Pts. Elo
2º

0-1
Domingo, 15 Septiembre 2024, 01:00
0 - 1
 17' B. Sartiaguin

Eventos del partido

Goles

minuto 17'B. SartiaguinGol de B. Sartiaguin

Tarjetas

minuto 19'César GutiérrezT. Amarilla César Gutiérrez
minuto 22'Carlos HinestrozaT. Amarilla Carlos Hinestroza
Emiliano TrejoT. Amarilla
Emiliano Trejo
minuto 49'

Cambios

minuto 41'Jesús DelgadoEntra en el partido Jesús Delgado
minuto 41'César GutiérrezSale del partido César Gutiérrez
Weymmar CastroEntra en el partido
Weymmar Castro
minuto 46'
Erick MonteroSale del partido
Erick Montero
minuto 46'
minuto 64'Sahid DuránSale del partido Sahid Durán
minuto 64'C. OrtízEntra en el partido C. Ortíz
Yair MartínezEntra en el partido
Yair Martínez
minuto 71'
Emiliano TrejoSale del partido
Emiliano Trejo
minuto 71'
Emiliano MartínezEntra en el partido
Emiliano Martínez
minuto 71'
Emiliano AyalaEntra en el partido
Emiliano Ayala
minuto 71'
Brayan MuñózSale del partido
Brayan Muñóz
minuto 71'
A. PreciadoSale del partido
A. Preciado
minuto 71'
Yaro MartínezSale del partido
Yaro Martínez
minuto 79'
L. CruzEntra en el partido
L. Cruz
minuto 79'
minuto 90'Mario Domínguez CastroEntra en el partido Mario Domínguez Castro
minuto 90'Leonardo VelascoSale del partido Leonardo Velasco
minuto 90'Jesús DelgadoSale del partido Jesús Delgado
minuto 90'B. IbáñezEntra en el partido B. Ibáñez

Alineaciones

Mineros de Fresnillo

Mineros de Fresnillo

4-4-2
Alineación Inicial
Suplentes
Tigres de Álica

Tigres de Álica

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,967,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.8372
Total Execution Time  0.8381
  CADENA URL  
/partido/Mineros-De-Fresnillo/Tigres-Alica/2025?section=legal
  GET DATOS  
$_GET['/partido/Mineros-De-Fresnillo/Tigres-Alica/2025']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77414 AND teamId = 6663477 and type = 33
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77414 AND teamId = 6663483 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 = '146978' 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 = 146978 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 146978 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2025` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 77414 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='146978' AND `active` = 1 AND year = 2025
0.0037  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='77414' AND relp.team_id=6663477 WHERE relp.in_squad=1 and mp.`match_id` = '146978' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0039  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='77414' AND relp.team_id=6663483 WHERE relp.in_squad=1 and mp.`match_id` = '146978' 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=146978 AND extraId = 77414 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1415 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1415 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 (1081943,1008128,684922,673672,273827) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 146978 AND league_id = 77414 AND year = 2025