4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Modena - Pisa SC
Jornada 14
FINALIZADO
00
00
775 Pts. Elo

766 Pts. Elo

2-2
Domingo, 18 Diciembre 1966, 00:00
Roberto Gasparroni 4'
1 - 0
1 - 1
 35' Adelio Colombo
Rubén Merighi 39'
2 - 1
2 - 2
 49' Pier Paolo Manservisi

Eventos del partido

Goles

Roberto Gasparroni Gol de (p.p)
Roberto Gasparroni
minuto4'
minuto 35'Adelio ColomboGol de Adelio Colombo
Rubén MerighiGol de
Rubén Merighi
minuto 39'
minuto 49'Pier Paolo ManservisiGol de Pier Paolo Manservisi

Alineaciones

Modena

Modena

4-4-2
Alineación Inicial
Pisa SC

Pisa SC

4-4-2
Alineación Inicial



  USO DE MEMORIA  
5,486,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  1.7420
Total Execution Time  1.7429
  CADENA URL  
/partido/Modena-Fc/Pisa-Calcio/1967
  GET DATOS  
$_GET['/partido/Modena-Fc/Pisa-Calcio/1967']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0107  SELECT data1 FROM stats1967 t WHERE league_id = 30839 AND teamId = 706643 and type = 33
0.0107  SELECT data1 FROM stats1967 t WHERE league_id = 30839 AND teamId = 706650 and type = 33
0.0115  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '13921' and rp.type = 1967 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 13921 AND year = 1967 AND channel = 'Footters' LIMIT 1
0.0109  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 13921 AND year = 1967 AND channel = 'Footters' LIMIT 1
0.0109  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='13921' AND `active` = 1 AND year = 1967
0.0127  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='30839' AND relp.team_id=706643 WHERE relp.in_squad=1 and mp.`match_id` = '13921' AND mp.year='1967' ORDER BY mp.`team` ASC, p.`role` ASC
0.0127  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='30839' AND relp.team_id=706650 WHERE relp.in_squad=1 and mp.`match_id` = '13921' AND mp.year='1967' ORDER BY mp.`team` ASC, p.`role` ASC
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13921 AND extraId = 30839 AND type_rel = 4
0.0105  SELECT rating1, rating2 FROM calendars_elo WHERE id=13921 AND league_id=30839 AND year=1967
0.0106  SELECT position FROM tables1967 WHERE team=706643 AND league_id=30839 AND round=14
0.0106  SELECT position FROM tables1967 WHERE team=706650 AND league_id=30839 AND round=14
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 13921 AND league_id = 30839 AND year = 1967