4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
San Martín Burzaco - Cañuelas
Jornada 14
FINALIZADO
20
41
204 Pts. Elo
12º

407 Pts. Elo
7º

1-0
Sábado, 27 Abril 2024, 20:30
L. Vico 27'
1 - 0

Eventos del partido

Goles

L. VicoGol de
L. Vico
minuto 27'

Tarjetas

minuto 29'G. ZabalaT. Amarilla G. Zabala
M. CamejoT. Amarilla
M. Camejo
minuto 33'
minuto 35'Nahuel RíosT. Amarilla Nahuel Ríos
minuto 66'M. ManáT. Amarilla M. Maná
minuto 68'U. OjedaTarjeta Roja a U. Ojeda
minuto 69'A. BottiniT. Amarilla A. Bottini
L. MaldonadoT. Amarilla
L. Maldonado
minuto 75'

Cambios

minuto 46'N. GuerreroEntra en el partido N. Guerrero
minuto 46'M. JuárezEntra en el partido M. Juárez
L. CariagaSale del partido
L. Cariaga
minuto 46'
minuto 46'G. PatrittiSale del partido G. Patritti
D. LeonelEntra en el partido
D. Leonel
minuto 46'
minuto 46'A. BarquettSale del partido A. Barquett
S. DelucaEntra en el partido
S. Deluca
minuto 59'
K. CaraballoEntra en el partido
K. Caraballo
minuto 59'
M. CamejoSale del partido
M. Camejo
minuto 59'
F. OjedaSale del partido
F. Ojeda
minuto 59'
minuto 63'M. ManáEntra en el partido M. Maná
minuto 63'L. GimenezSale del partido L. Gimenez
L. VicoSale del partido
L. Vico
minuto 75'
B. SosaEntra en el partido
B. Sosa
minuto 75'
minuto 77'Nahuel RíosSale del partido Nahuel Ríos
minuto 77'J. GranadosEntra en el partido J. Granados
minuto 77'F. GuelerEntra en el partido F. Gueler
minuto 77'B. HernandezSale del partido B. Hernandez
N. RenfigueEntra en el partido
N. Renfigue
minuto 80'
L. VeraSale del partido
L. Vera
minuto 80'

Alineaciones

San Martín Burzaco

San Martín Burzaco

4-4-2
Alineación Inicial
Suplentes
Cañuelas

Cañuelas

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

San Martín Burzaco Martín Cañuelas Cañuelas
1
Goles
 0
0
Tarjetas Rojas
 1
3
Sustituciones
 3


  USO DE MEMORIA  
6,886,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2692
Total Execution Time  0.2702
  CADENA URL  
/partido/San-Martin-Burzaco/Canuelas/2008?section=legal
  GET DATOS  
$_GET['/partido/San-Martin-Burzaco/Canuelas/2008']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 75059 AND teamId = 6626347 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 75059 AND teamId = 6626339 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 = '671427' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 671427 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 671427 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0061  SELECT t.points,t.team,t.round 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 = 75059 AND t.round >= 6 AND t.round <= 21 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='671427' AND `active` = 1 AND year = 2024
0.0046  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='75059' AND relp.team_id=6626347 WHERE relp.in_squad=1 and mp.`match_id` = '671427' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
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='75059' AND relp.team_id=6626339 WHERE relp.in_squad=1 and mp.`match_id` = '671427' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=671427 AND extraId = 75059 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=206 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 206 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1217126,1186023,1100435,1089425,1054264) ORDER BY n.cover_points DESC, update_date DESC
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 671427 AND league_id = 75059 AND year = 2024