4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Municipal Reşiţa - Unirea Slobozia
FINALIZADO
00
11
539 Pts. Elo
17º

451 Pts. Elo

0-1
Sábado, 05 Agosto 2023, 10:00
0 - 1
61' C. Toma

Eventos del partido

Goles

minuto 61'C. TomaGol de falta C. Toma

Tarjetas

minuto 91'S. Ekollo2a Amarilla y Roja S. Ekollo

Cambios

minuto 46'Ș. PacionelSale del partido Ș. Pacionel
minuto 46'S. EkolloEntra en el partido S. Ekollo
minuto 46'M. ZukanovićEntra en el partido M. Zukanović
minuto 46'C. AtanaseSale del partido C. Atanase
V. CheraEntra en el partido
V. Chera
minuto 61'
S. VelcotaEntra en el partido
S. Velcota
minuto 61'
F. CristeaSale del partido
F. Cristea
minuto 61'
Ciprian RusSale del partido
Ciprian Rus
minuto 61'
minuto 68'S. CojocariSale del partido S. Cojocari
minuto 68'F. IbrianEntra en el partido F. Ibrian

Estadísticas del partido

Municipal Reşiţa Municipal Unirea Slobozia Unirea
0
Goles
1
4
Tarjetas Amarillas
3
0
Tarjetas Rojas
1
2
Sustituciones
3

No hay comentarios



  USO DE MEMORIA  
6,696,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.5323
Total Execution Time  0.5333
  CADENA URL  
/partido/Fc-Municipal-Resita/Unirea-Slobozia/2024
  GET DATOS  
$_GET['/partido/Fc-Municipal-Resita/Unirea-Slobozia/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0128  SELECT data1 FROM stats2024 t WHERE league_id = 72232 AND teamId = 6585406 and type = 33
0.0130  SELECT data1 FROM stats2024 t WHERE league_id = 72232 AND teamId = 6585415 and type = 33
0.0138  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '458191' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 458191 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0132  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 458191 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0146  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 = 72232 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='458191' AND `active` = 1 AND year = 2024
0.0216  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='72232' AND relp.team_id=6585406 WHERE relp.in_squad=1 and mp.`match_id` = '458191' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0162  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='72232' AND relp.team_id=6585415 WHERE relp.in_squad=1 and mp.`match_id` = '458191' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=458191 AND extraId = 72232 AND type_rel = 4
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=242 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 242 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  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 (1145696,1008496,993818,969163,898033) ORDER BY n.cover_points DESC, update_date DESC
0.0124  SELECT * FROM futbol.calendars_lineups WHERE id = 458191 AND league_id = 72232 AND year = 2024