4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Sambenedettese - Ternana Calcio
Jornada 34
FINALIZADO
00
00
446 Pts. Elo
15º

692 Pts. Elo
12º

0-0
Domingo, 27 Mayo 1979, 00:00

Eventos del partido

Cambios

Ferdinando BozziSale del partido
Ferdinando Bozzi
minuto 75'
Ruggiero CorvasceEntra en el partido
Ruggiero Corvasce
minuto 75'
minuto 82'Andrea MitriEntra en el partido Andrea Mitri
minuto 82'Franco CacciaSale del partido Franco Caccia

Alineaciones

Sambenedettese

Sambenedettese

4-4-2
Alineación Inicial
Suplentes
Ternana Calcio

Ternana Calcio

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,751,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Match / Index )  0.1017
Total Execution Time  0.1030
  CADENA URL  
/partido/Ss-Sambenedettese-Calcio/Ternana-Calcio/1979
  GET DATOS  
$_GET['/partido/Ss-Sambenedettese-Calcio/Ternana-Calcio/1979']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0019  SELECT data1 FROM stats1979 t WHERE league_id = 30851 AND teamId = 707749 and type = 33
0.0017  SELECT data1 FROM stats1979 t WHERE league_id = 30851 AND teamId = 707748 and type = 33
0.0023  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '13929' and rp.type = 1979 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0029  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 13929 AND year = 1979 AND channel = 'Footters' LIMIT 1
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 13929 AND year = 1979 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='13929' AND `active` = 1 AND year = 1979
0.0073  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='30851' AND relp.team_id=707749 WHERE relp.in_squad=1 and mp.`match_id` = '13929' AND mp.year='1979' ORDER BY mp.`team` ASC, p.`role` ASC
0.0069  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='30851' AND relp.team_id=707748 WHERE relp.in_squad=1 and mp.`match_id` = '13929' AND mp.year='1979' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13929 AND extraId = 30851 AND type_rel = 4
0.0024  SELECT rating1, rating2 FROM calendars_elo WHERE id=13929 AND league_id=30851 AND year=1979
0.0022  SELECT * FROM futbol.calendars_lineups WHERE id = 13929 AND league_id = 30851 AND year = 1979