4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2016
Temporada Siguiente »
Publicidad 600x120.gif
Amistosos Selecciones 2016
2015/2016

Amistosos Selecciones 2016

Resultados
« Jornada Anterior
Jornada 62
Jornada Siguiente »
 
17 Nov 15
12:00 Aplazado 		Líbano Líbano Apl Nueva Zelanda Nueva Zelanda más información 10
 
17 Nov 15
13:00 Finalizado 		Macedonia del Norte Macedonia del Norte 0-1 Líbano Líbano más información Jugadas destacadas 11
0-1 47' J. Oumari J. Oumari
 
17 Nov 15
17:00 Finalizado 		Rusia Rusia 1-3 Croacia Croacia más información Jugadas destacadas 86
14' F. Smolov F. Smolov 1-0
1-1 57' N. Kalinić N. Kalinić
1-2 60' M. Brozović M. Brozović
1-3 82' M. Mandžukić M. Mandžukić
 
17 Nov 15
18:00 Finalizado 		Azerbaiyán Azerbaiyán 2-1 Moldavia Moldavia más información Jugadas destacadas 5
33' C. Carp C. Carp
1-1 45' A. Antoniuc A. Antoniuc
50' A. Ramazanov A. Ramazanov 2-1
 
17 Nov 15
18:00 Finalizado 		Estonia Estonia 3-0 San Cristóbal y Nieves San Cristóbal y Nieves más información Jugadas destacadas 6
29' I. Antonov I. Antonov 1-0
50' K. Vassiljev K. Vassiljev 2-0
57' S. Puri S. Puri 3-0
 
17 Nov 15
19:15 Finalizado 		Turquía Turquía 0-0 Grecia Grecia más información 251
 
17 Nov 15
20:30 Finalizado 		Luxemburgo Luxemburgo 0-2 Portugal Portugal más información Jugadas destacadas 63
0-1 30' André André André André
0-2 87' Nani Nani
 
17 Nov 15
20:45 Aplazado 		Bélgica Bélgica Apl España España más información 864
 
17 Nov 15
20:45 Aplazado 		Alemania Alemania Apl Países Bajos Países Bajos más información 152
 
17 Nov 15
20:45 Finalizado 		Austria Austria 1-2 Suiza Suiza más información Jugadas destacadas 33
0-1 10' H. Seferović H. Seferović
14' David Alaba David Alaba 1-1
1-2 38' H. Seferović H. Seferović
 
17 Nov 15
20:45 Finalizado 		Polonia Polonia 3-1 República Checa República Checa más información Jugadas destacadas 33
3' A. Milik A. Milik 1-0
12' T. Jodlowiec T. Jodlowiec 2-0
2-1 41' Lalo Krejci Lalo Krejci
70' K. Grosicki K. Grosicki 3-1
 
17 Nov 15
20:45 Finalizado 		Italia Italia 2-2 Rumanía Rumanía más información Jugadas destacadas 240
0-1 8' B. Stancu B. Stancu
55' C. Marchisio C. Marchisio 1-1
66' M. Gabbiadini M. Gabbiadini 2-1
2-2 88' Florin Andone Florin Andone
 
17 Nov 15
20:45 Finalizado 		Eslovaquia Eslovaquia 3-1 Islandia Islandia más información Jugadas destacadas 17
0-1 8' A. Finnbogason A. Finnbogason
58' R. Mak R. Mak 1-1
61' R. Mak R. Mak 2-1
84' M. Ďuriš M. Ďuriš 3-1
 
17 Nov 15
21:00 Finalizado 		Inglaterra Inglaterra 2-0 Francia Francia más información Jugadas destacadas 375
39' Dele Alli Dele Alli 1-0
48' W. Rooney W. Rooney 2-0


  USO DE MEMORIA  
4,975,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0884
Total Execution Time  0.0903
  CADENA URL  
/amistosos_selecciones2016/grupo1/jornada62
  GET DATOS  
$_GET['/amistosos_selecciones2016/grupo1/jornada62']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 04:01:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 04:01:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 04:01:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 04:01:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=16586 AND rel.round=62
0.0035  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 `calendars2016` 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` = 16586 AND c.`round` = 62 ORDER BY shedule ASC LIMIT 200
0.0057  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 events2016 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2016 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 16586 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 (229688,269351,269352,229684,269354,269355,269356,229685,229686,246396,246397,269360,269362,229689) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0059  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2016` e INNER JOIN calendars2016 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 62 AND e.real_date IS NOT NULL AND e.league_id = 16586 ORDER BY total DESC LIMIT 40
0.0042  SELECT distinct(shedule), round FROM `calendars2016` as c WHERE c.`league_id` = 16586 AND shedule >= '2015/11/01' AND shedule < '2015/12/01' ORDER BY shedule ASC
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=307
0.0098  SELECT group_code, extraName from `leagues` WHERE categoryId=307 AND year=2016