4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Stevenage - Notts County
Jornada 25
FINALIZADO
40
10
511 Pts. Elo
8º

734 Pts. Elo
10º

2-0
Martes, 05 Febrero 2013, 20:45
  • Asistencia: 2.550 espectadores
S. Hoskins 1'
1 - 0
M. Haber 89'
2 - 0

Eventos del partido

Goles

S. HoskinsGol de
S. Hoskins
minuto 1'
M. HaberGol de
M. Haber
minuto 89'

Tarjetas

Greg TanseyT. Amarilla
Greg Tansey
minuto 32'
D. GrayT. Amarilla
D. Gray
minuto 36'
minuto 73'G. MahonT. Amarilla G. Mahon
A. GrantT. Amarilla
A. Grant
minuto 74'
minuto 80'Dean LeacockT. Amarilla Dean Leacock

Cambios

Luke FreemanEntra en el partido
Luke Freeman
minuto 54'
L. AkinsSale del partido
L. Akins
minuto 54'
A. GrantEntra en el partido
A. Grant
minuto 63'
S. HoskinsSale del partido
S. Hoskins
minuto 63'
minuto 67'E. ShowunmiEntra en el partido E. Showunmi
minuto 67'F. ZokoSale del partido F. Zoko
M. HaberEntra en el partido
M. Haber
minuto 69'
S. BeleckSale del partido
S. Beleck
minuto 69'
minuto 83'H. BencherifEntra en el partido H. Bencherif
minuto 83'G. MahonSale del partido G. Mahon

Otros

Filipe MoraisAsistencia
Filipe Morais
minuto 89'

Alineaciones

Stevenage

Stevenage

4-4-2
Alineación Inicial
Suplentes
Notts County

Notts County

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,009,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3423
Total Execution Time  0.3433
  CADENA URL  
/partido/Stevenage/Notts-County/2013
  GET DATOS  
$_GET['/partido/Stevenage/Notts-County/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0252  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 1917
0.0125  SELECT data1 FROM stats2013 t WHERE league_id = 1917 AND teamId = 39411 and type = 33
0.0125  SELECT data1 FROM stats2013 t WHERE league_id = 1917 AND teamId = 39402 and type = 33
0.0126  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '474536' and rp.type = 2013 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 474536 AND year = 2013 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 474536 AND year = 2013 AND channel = 'Footters' LIMIT 1
0.0127  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 1917 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1917 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='474536' AND `active` = 1 AND year = 2013
0.0287  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='1917' AND relp.team_id=39411 WHERE relp.in_squad=1 and mp.`match_id` = '474536' AND mp.year='2013' ORDER BY mp.`team` ASC, p.`role` ASC
0.0247  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='1917' AND relp.team_id=39402 WHERE relp.in_squad=1 and mp.`match_id` = '474536' AND mp.year='2013' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=474536 AND extraId = 1917 AND type_rel = 4
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 474536 AND league_id = 1917 AND year = 2013