4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
 
08 May 97
20:30 Finalizado
Napoli Napoli 1-0 Vicenza Vicenza más información Jugadas destacadas ...
21' F. Pecchia 1-0
 
29 May 97
20:45 Finalizado
Vicenza Vicenza 3-0 Napoli Napoli más información Jugadas destacadas ...
21' Giampiero Maini 1-0
91' Caccia
118' Rossi 2-0
120' Iannuzzi 3-0
Global Pr.
Napoli 1 - 3 Vicenza

INFORMACIÓN

La Copa de Italia (oficialmente por motivos de patrocinio TIM Cup) es una competición de fútbol de Italia en la que participan los equipos de la Serie A, y de la Serie B. La primera vez que se disputó la Copa de Italia fue en 1922, aunque hasta 1936 no se volvió a jugar. Entre los años 1944 y 1957 no se disputó este campeonato a causa de la Segunda Guerra Mundial. Los equipos se enfrentan entre ellos en eliminatorias. El ganador pasa a la siguiente ronda. El campeón de la Copa de Italia consigue un puesto en la siguiente edición de la UEFA Europa League. Además, disputa la Supercopa de Italia, contra el ganador de la Serie A de esa misma temporada. Al ganador de 10 Copas de Italia se le atribuye una Estrella de Plata, condecoración que lucen los jugadores del club poseedor en sus camisetas, similar a la Estrella de Oro (se atribuye al ganar 10 Scudettos) pero en este caso plateada. Antes de la edición 2007/08 la competición se disputaba con una final a ida y vuelta.

  USO DE MEMORIA  
4,917,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.2357
Total Execution Time  0.2380
  CADENA URL  
/coppa_italia1997
  GET DATOS  
$_GET['/coppa_italia1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=296 AND type_rel = 3
0.0134  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 296 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1312313,1312243,1312248,1312066,1310874) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 20:49:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 20:49:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 20:49:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 20:49:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0134  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1997` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 22634 AND c.`round` = 6 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0129  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events1997 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1997 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 22634 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (30258,30259) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0127  SELECT data1, data2 FROM services_tags WHERE categoryId=296
0.0128  SELECT group_code, extraName from `leagues` WHERE categoryId=296 AND year=1997