4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Arg. Quilmes - Laferrere
Jornada 2
FINALIZADO
30
52
507 Pts. Elo
4º

206 Pts. Elo
14º

1-1
Lunes, 12 Febrero 2024, 21:00
0 - 1
 14' A. Espeche
Á. López 88'
1 - 1

Arg. Quilmes

4-4-2
Alineación Inicial
Suplentes

Laferrere

4-4-2
Alineación Inicial
Suplentes
Arg. Quilmes
Laferrere
Gol
T. Amarilla
T. Amarilla
T. Amarilla
T. Amarilla
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido
T. Amarilla
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Sale del partido
Entra en el partido
T. Roja
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
T. Amarilla
Gol de penalti
T. Amarilla
2a Amarilla y Roja

Eventos del partido

Goles

minuto 14'Gol de A. Espeche
Gol de penalti
Á. López
minuto 88'

Tarjetas

minuto 16'T. Amarilla G. Iñiguez
T. Amarilla
A. Stringa
minuto 17'
T. Amarilla
F. Valdez
minuto 42'
T. Amarilla
J. Vivas
minuto 53'
minuto 62'T. Amarilla I. Tierno
minuto 82'Tarjeta Roja a F. Arébalo
minuto 86'T. Amarilla J. Banegas
minuto 91'T. Amarilla J. Azil
minuto 92'2a Amarilla y Roja I. Tierno

Cambios

minuto 60'Entra en el partido I. Tierno
minuto 60'Sale del partido G. Iñiguez
Sale del partido
F. Valdez
minuto 60'
Entra en el partido
A. Cecconato
minuto 60'
minuto 71'Entra en el partido F. Ocampo
minuto 71'Entra en el partido F. Arébalo
minuto 71'Sale del partido B. Chavez
minuto 71'Sale del partido A. Espeche
Sale del partido
A. Stringa
minuto 79'
Entra en el partido
E. Madariaga
minuto 79'
minuto 85'Sale del partido I. Arbello
minuto 85'Entra en el partido G. Pedrosa
minuto 85'Sale del partido D. Rojas
minuto 85'Entra en el partido A. Faillace

Estadísticas del partido

Arg. Quilmes Arg. Quilmes Laferrere Laferrere
1
Goles
 1
0
Tarjetas Amarillas
 1
0
Tarjetas Rojas
 2
2
Sustituciones
 3
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,883,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.6073
Total Execution Time  0.6085
  CADENA URL  
/partido/Argentino-Quilmes/Deportivo-Lafe/2024
  GET DATOS  
$_GET['/partido/Argentino-Quilmes/Deportivo-Lafe/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0061   SELECT c.*, c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Argentino-Quilmes' AND dt2.basealias = 'Deportivo-Lafe'
0.0023  SELECT c.*, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Argentino-Quilmes' AND dt2.basealias = 'Deportivo-Lafe'
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 75059 AND teamId = 6626334 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 75059 AND teamId = 6626340 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 = '671289' and rp.type = 2024 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 = 671289 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 671289 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75059 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0055  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 >= 1 AND t.round <= 14 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`='671289' AND `active` = 1 AND year = 2024
0.0045  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=6626334 WHERE relp.in_squad=1 and mp.`match_id` = '671289' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0048  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=6626340 WHERE relp.in_squad=1 and mp.`match_id` = '671289' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=671289 AND extraId = 75059 AND type_rel = 4
0.0026  SELECT avg_rating FROM elo_teams WHERE id=6605
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 671289 AND league_id = 75059 AND year = 2024