4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Olimpic Xátiva - UE Sant Andreu
Jornada 38
FINALIZADO
00
00
175 Pts. Elo
8º

281 Pts. Elo
11º

1-0
Domingo, 14 Mayo 1978, 00:00
Cristóbal 44'
1 - 0

Eventos del partido

Goles

CristóbalGol de
Cristóbal
minuto 44'

Cambios

minuto 45'ÁvilaEntra en el partido Ávila
minuto 45'CalderóSale del partido Calderó
minuto 50'De FríasEntra en el partido De Frías
minuto 50'SantiSale del partido Santi
DiegoEntra en el partido
Diego
minuto 55'
PaúlSale del partido
Paúl
minuto 55'

Alineaciones

Olimpic Xátiva

Olimpic Xátiva

4-4-2
Alineación Inicial
Suplentes
UE Sant Andreu

UE Sant Andreu

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,785,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.0809
Total Execution Time  0.0819
  CADENA URL  
/partido/Olimpic/Sant-Andreu/1978
  GET DATOS  
$_GET['/partido/Olimpic/Sant-Andreu/1978']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT data1 FROM stats1978 t WHERE league_id = 22229 AND teamId = 617580 and type = 33
0.0018  SELECT data1 FROM stats1978 t WHERE league_id = 22229 AND teamId = 617579 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 = '16841' and rp.type = 1978 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 = 16841 AND year = 1978 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 16841 AND year = 1978 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='16841' AND `active` = 1 AND year = 1978
0.0028  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='22229' AND relp.team_id=617580 WHERE relp.in_squad=1 and mp.`match_id` = '16841' AND mp.year='1978' ORDER BY mp.`team` ASC, p.`role` ASC
0.0051  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='22229' AND relp.team_id=617579 WHERE relp.in_squad=1 and mp.`match_id` = '16841' AND mp.year='1978' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16841 AND extraId = 22229 AND type_rel = 4
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=16841 AND league_id=22229 AND year=1978
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 16841 AND league_id = 22229 AND year = 1978