4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Udinese Sub 19 - Vicenza Sub 19
Jornada 22
FINALIZADO
00
21
120 Pts. Elo

60 Pts. Elo

1-0
Sábado, 28 Marzo 2009, 00:00
A. Mazzarani 90'
1 - 0

Eventos del partido

Goles

A. MazzaraniGol de
A. Mazzarani
minuto 90'

Tarjetas

minuto 46'FelipeT. Amarilla Felipe
minuto 85'A. De March2a Amarilla y Roja A. De March

Cambios

R. VillarEntra en el partido
R. Villar
minuto 75'
ProvenzanoSale del partido
Provenzano
minuto 75'
minuto 77'G. PomiroEntra en el partido G. Pomiro
minuto 77'E. TennerielloSale del partido E. Tenneriello
minuto 85'Michael CardinEntra en el partido Michael Cardin
minuto 85'M. MinessoSale del partido M. Minesso
A. BencivengaEntra en el partido
A. Bencivenga
minuto 90'
T. AzianSale del partido
T. Azian
minuto 90'
minuto 90'G. PiccioniEntra en el partido G. Piccioni
minuto 90'N. BianconiSale del partido N. Bianconi

Alineaciones

Udinese Sub 19

Udinese Sub 19

4-4-2
Alineación Inicial
Suplentes
Vicenza Sub 19

Vicenza Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,664,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2711
Total Execution Time  0.2721
  CADENA URL  
/partido/Udinese-Sub19/Vicenza-Sub19/2009
  GET DATOS  
$_GET['/partido/Udinese-Sub19/Vicenza-Sub19/2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0106  SELECT data1 FROM stats2009 t WHERE league_id = 44198 AND teamId = 6193394 and type = 33
0.0107  SELECT data1 FROM stats2009 t WHERE league_id = 44198 AND teamId = 6193396 and type = 33
0.0108  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '189566' and rp.type = 2009 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 189566 AND year = 2009 AND channel = 'Footters' LIMIT 1
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 189566 AND year = 2009 AND channel = 'Footters' LIMIT 1
0.0106  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='189566' AND `active` = 1 AND year = 2009
0.0113  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='44198' AND relp.team_id=6193394 WHERE relp.in_squad=1 and mp.`match_id` = '189566' AND mp.year='2009' ORDER BY mp.`team` ASC, p.`role` ASC
0.0116  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='44198' AND relp.team_id=6193396 WHERE relp.in_squad=1 and mp.`match_id` = '189566' AND mp.year='2009' ORDER BY mp.`team` ASC, p.`role` ASC
0.0120  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=189566 AND extraId = 44198 AND type_rel = 4
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1554 AND type_rel = 3
0.0108  SELECT rating1, rating2 FROM calendars_elo WHERE id=189566 AND league_id=44198 AND year=2009
0.0111  SELECT position FROM tables2009 WHERE team=6193394 AND league_id=44198 AND round=22
0.0111  SELECT position FROM tables2009 WHERE team=6193396 AND league_id=44198 AND round=22
0.0106  SELECT * FROM futbol.calendars_lineups WHERE id = 189566 AND league_id = 44198 AND year = 2009