4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Gimnástica Torrelavega - Real Avilés Industrial
Jornada 20
FINALIZADO
50
40
199 Pts. Elo
15º

296 Pts. Elo
10º

1-1
Domingo, 28 Enero 2024, 17:00
  • Estadio: El Malecón
0 - 1
 66' Natalio
Javi Delgado 86'
1 - 1

Gimnástica Torrelavega

4-5-1
Alineación Inicial
Suplentes

Real Avilés Industrial

4-5-1
Alineación Inicial
Suplentes

Eventos del partido

Goles

minuto 66'Gol de penalti Natalio
Gol de falta
Javi Delgado
minuto 86'

Tarjetas

T. Amarilla
Pol Bassa
minuto 20'
T. Amarilla
A. Delgado
minuto 25'
minuto 41'T. Amarilla Joel Del Pino
T. Amarilla
Lavsamba
minuto 46'
T. Amarilla
U. Hernández
minuto 68'
T. Amarilla
Alberto Gómez
minuto 70'
minuto 72'T. Amarilla Edu Cortina
minuto 74'T. Amarilla Miguel Sierra
minuto 85'T. Amarilla J. Mecerreyes

Cambios

minuto 59'Entra en el partido Raúl Rojas
minuto 59'Sale del partido Davo Fernández
Entra en el partido
Josemi Castañeda
minuto 72'
Sale del partido
Lavsamba
minuto 72'
Entra en el partido
Tobar
minuto 72'
Sale del partido
A. Delgado
minuto 72'
minuto 76'Entra en el partido Julio Rodríguez
minuto 76'Sale del partido P. Orfila
minuto 80'Sale del partido Miguel Sierra
minuto 80'Sale del partido Natalio
minuto 80'Entra en el partido Jorge Fernández
minuto 80'Entra en el partido Isma Cerro
minuto 80'Sale del partido Claudio Medina
minuto 80'Entra en el partido Alberto Martín
Sale del partido
Saul García
minuto 90'
Entra en el partido
Chamo
minuto 90'

Otros

Penalti cometido
Lavsamba
minuto 65'

Estadísticas del partido

Gimnástica Torrelavega Gimnástica Real Avilés Industrial Real Avilés
1
Goles
 1
1
Tarjetas Rojas
 0
3
Sustituciones
 3
1
Penalti cometido
 0
1 Comentarios + 1 respuestas
  • realavilesino93
    Hace 3 meses realavilesino93 dice: Para el objetivo real no es tan malo el resultado. El descenso directo sigue a 5 puntos, aunque una victoria habría venido bien para salvar el golaverage con un rival directo y meterle ya prácticamente tres partidos de distancia al descenso y dos a la promoción que a estas alturas de liga sería ya mucho. La semana que viene nuevo partido vital para salvar la categoría, mínimo hay que empatar otra vez.


  USO DE MEMORIA  
6,963,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Match / Index )  0.6126
Total Execution Time  0.6144
  CADENA URL  
/partido/Gimnastica/Real-Aviles-Ind/2024
  GET DATOS  
$_GET['/partido/Gimnastica/Real-Aviles-Ind/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0005   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '72362' AND c.`match_id` = '196906' AND c.comment_id IN (68990552) GROUP BY c.comment_id
0.0125  SELECT data1 FROM stats2024 t WHERE league_id = 72362 AND teamId = 6587607 and type = 33
0.0125  SELECT data1 FROM stats2024 t WHERE league_id = 72362 AND teamId = 6587605 and type = 33
0.0127  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '196906' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 196906 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 196906 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0126   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '68990552' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0133  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='196906' AND `active` = 1 AND year = 2024
0.0174  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='72362' AND relp.team_id=6587607 WHERE relp.in_squad=1 and mp.`match_id` = '196906' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0176  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='72362' AND relp.team_id=6587605 WHERE relp.in_squad=1 and mp.`match_id` = '196906' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=196906 AND extraId = 72362 AND type_rel = 4
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2469 AND type_rel = 3
0.0126  SELECT * FROM futbol.calendars_lineups WHERE id = 196906 AND league_id = 72362 AND year = 2024