4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Minerva - Unión Molinense B
Jornada 29
FINALIZADO
10
30
61 Pts. Elo
3º

23 Pts. Elo
13º

1-1
Domingo, 21 Abril 2024, 11:30
D. Ardid 46'
1 - 0
1 - 1
 52' D. Ros

Eventos del partido

Goles

D. ArdidGol de
D. Ardid
minuto 46'
minuto 52'D. RosGol de D. Ros

Tarjetas

minuto 53'D. RosT. Amarilla D. Ros
minuto 57'B. AssolochanT. Amarilla B. Assolochan
minuto 65'D. LopezT. Amarilla D. Lopez
A. VidalT. Amarilla
A. Vidal
minuto 86'

Cambios

minuto 59'M. JiménezEntra en el partido M. Jiménez
minuto 59'L. SalminiEntra en el partido L. Salmini
minuto 59'J. CanoSale del partido J. Cano
minuto 59'A. CanoSale del partido A. Cano
IvalínSale del partido
Ivalín
minuto 61'
Diego VelascoEntra en el partido
Diego Velasco
minuto 61'
D. GomezEntra en el partido
D. Gomez
minuto 61'
A. AgueraSale del partido
A. Aguera
minuto 61'
minuto 67'V. VicenteEntra en el partido V. Vicente
minuto 67'F. HerreraEntra en el partido F. Herrera
minuto 67'D. RosSale del partido D. Ros
minuto 67'B. AssolochanSale del partido B. Assolochan
MuñozEntra en el partido
Muñoz
minuto 80'
C. GómezEntra en el partido
C. Gómez
minuto 80'
A. EspinosaSale del partido
A. Espinosa
minuto 80'
Sergio CortadoSale del partido
Sergio Cortado
minuto 80'
minuto 81'Álex GómezSale del partido Álex Gómez
minuto 81'A. GuillénEntra en el partido A. Guillén

Alineaciones

Minerva

Minerva

4-4-2
Alineación Inicial
Suplentes
Unión Molinense B

Unión Molinense B

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: comment/main_view.php

Line Number: 2065

Minerva Minerva Unión Molinense B Unión
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,883,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.6448
Total Execution Time  0.6457
  CADENA URL  
/partido/Sfc-Minerva-Senior/Union-Molinense-B-Senior/2024
  GET DATOS  
$_GET['/partido/Sfc-Minerva-Senior/Union-Molinense-B-Senior/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0144  SELECT data1 FROM stats2024 t WHERE league_id = 73547 AND teamId = 6604126 and type = 33
0.0144  SELECT data1 FROM stats2024 t WHERE league_id = 73547 AND teamId = 6604118 and type = 33
0.0146  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '496995' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 496995 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 496995 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0157  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 `tables2024` 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 = 73547 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 `tables2024` 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 = 73547 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='496995' AND `active` = 1 AND year = 2024
0.0224  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='73547' AND relp.team_id=6604126 WHERE relp.in_squad=1 and mp.`match_id` = '496995' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0178  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='73547' AND relp.team_id=6604118 WHERE relp.in_squad=1 and mp.`match_id` = '496995' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=496995 AND extraId = 73547 AND type_rel = 4
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=81 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 81 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0151  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 (1099011,976498,863991,836089,719860) ORDER BY n.cover_points DESC, update_date DESC
0.0144  SELECT rating1, rating2 FROM calendars_elo WHERE id=496995 AND league_id=73547 AND year=2024
0.0144  SELECT * FROM futbol.calendars_lineups WHERE id = 496995 AND league_id = 73547 AND year = 2024