4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Villa Dálmine - Dep. Santamarina
FINALIZADO
20
40
851 Pts. Elo
18º

1080 Pts. Elo

0-1
Sábado, 06 Febrero 2016, 21:00
0 - 1
29' Facundo Castro

Eventos del partido

Goles

minuto 29'Facundo CastroGol de Facundo Castro

Tarjetas

minuto 46'N. LujánT. Amarilla N. Luján
minuto 54'A. AguirreT. Amarilla A. Aguirre
G. DíazT. Amarilla
G. Díaz
minuto 62'
M. AlonsoT. Amarilla
M. Alonso
minuto 74'
minuto 83'N. MiraccoT. Amarilla N. Miracco
minuto 84'M. ZarateT. Amarilla M. Zarate

Cambios

minuto 53'M. ZarateEntra en el partido M. Zarate
minuto 53'M. PierceSale del partido M. Pierce
W. AlbarracínSale del partido
W. Albarracín
minuto 61'
M. AlonsoEntra en el partido
M. Alonso
minuto 61'
F. FydriszewskiEntra en el partido
F. Fydriszewski
minuto 68'
G. DíazSale del partido
G. Díaz
minuto 68'
minuto 73'N. MiraccoEntra en el partido N. Miracco
minuto 73'N. LujánSale del partido N. Luján
J. FigueiraEntra en el partido
J. Figueira
minuto 79'
L. FormicaSale del partido
L. Formica
minuto 79'
minuto 88'M. BuzziniEntra en el partido M. Buzzini
minuto 88'N. ValerioSale del partido N. Valerio

Alineaciones




  USO DE MEMORIA  
5,997,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.4423
Total Execution Time  0.4433
  CADENA URL  
/partido/Villa-Dalmine/Deportivo-Santamarina-Ar/2016
  GET DATOS  
$_GET['/partido/Villa-Dalmine/Deportivo-Santamarina-Ar/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0146  SELECT data1 FROM stats2016 t WHERE league_id = 20209 AND teamId = 582570 and type = 33
0.0147  SELECT data1 FROM stats2016 t WHERE league_id = 20209 AND teamId = 582560 and type = 33
0.0151  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '314035' and rp.type = 2016 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 314035 AND year = 2016 AND channel = 'Footters' LIMIT 1
0.0146  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 314035 AND year = 2016 AND channel = 'Footters' LIMIT 1
0.0147  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='314035' AND `active` = 1 AND year = 2016
0.0420  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='20209' AND relp.team_id=582570 WHERE relp.in_squad=1 and mp.`match_id` = '314035' AND mp.year='2016' ORDER BY mp.`team` ASC, p.`role` ASC
0.0296  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='20209' AND relp.team_id=582560 WHERE relp.in_squad=1 and mp.`match_id` = '314035' AND mp.year='2016' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=314035 AND extraId = 20209 AND type_rel = 4
0.0145  SELECT * FROM futbol.calendars_lineups WHERE id = 314035 AND league_id = 20209 AND year = 2016