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

Partidos Amistosos 2014

Resultados
« Jornada Anterior
Jornada 34
Jornada Siguiente »
 
10 Ago 13
14:45 Finalizado 		Malaysian XI Malaysian XI 1-3 Barcelona Barcelona más información Jugadas destacadas 85
0-1 31' Cesc Fàbregas
0-2 42' Neymar
0-3 74' G. Piqué
 
10 Ago 13
16:00 Finalizado 		Aston Villa Aston Villa 3-2 Málaga Málaga más información Jugadas destacadas 13
12' C. Benteke 1-0
20' R. Vlaar 2-0
30' C. Benteke 3-0
 
10 Ago 13
16:00 Finalizado 		Cardiff City Cardiff City 2-1 Athletic Athletic más información Jugadas destacadas 9
45' Peter Whittingham 1-0
52' F. Campbell 2-0
2-1 55' A. Iraola
 
10 Ago 13
16:00 Finalizado 		West Bromwich Albion West Bromwich Albion 2-0 Bologna Bologna más información 1
 
10 Ago 13
16:00 Finalizado 		Fulham Fulham 1-2 Parma Parma más información 1
 
10 Ago 13
16:00 Finalizado 		Norwich City Norwich City 2-0 Panathinaikos Panathinaikos más información ...
 
10 Ago 13
16:00 Finalizado 		Crystal Palace Crystal Palace 0-1 Lazio Lazio más información ...
 
10 Ago 13
16:00 Finalizado 		Arsenal Arsenal 3-1 Manchester City Manchester City más información Jugadas destacadas 15
8' Theo Walcott 1-0
58' Aaron Ramsey 2-0
61' O. Giroud 3-0
 
10 Ago 13
16:00 Finalizado 		Hull City Hull City 3-0 Real Betis Real Betis más información 20
 
10 Ago 13
17:00 Finalizado 		Reus Deportiu Reus Deportiu (0) 1-1 (3) Rapitenca Rapitenca más información 1
 
10 Ago 13
17:00 Finalizado 		Villarreal B Villarreal B 0-0 Alcoyano Alcoyano más información 5
 
10 Ago 13
18:00 Finalizado 		Liverpool Liverpool 0-1 Celtic Celtic más información 11
 
10 Ago 13
18:30 Finalizado 		Tottenham Hotspur Tottenham Hotspur 1-1 Espanyol Espanyol más información Jugadas destacadas 17
29' R. Soldado 1-0
1-1 44' David López
 
10 Ago 13
18:30 Finalizado 		UD Logroñés UD Logroñés 1-2 Deportivo Alavés Deportivo Alavés más información Jugadas destacadas 24
23' Omar 1-0
1-1 42' Luciano
1-2 76' I. Vélez
 
10 Ago 13
19:00 Finalizado 		CD Lugo CD Lugo 0-1 Real Oviedo Real Oviedo más información Jugadas destacadas 8
0-1 9' Héctor Simón
 
10 Ago 13
19:00 Finalizado 		At. Levante At. Levante 0-0 Huracán Valencia Huracán Valencia más información 5
 
10 Ago 13
19:00 Finalizado 		Newcastle Newcastle 1-1 Sporting Braga Sporting Braga más información 1
 
10 Ago 13
19:00 Finalizado 		Mirandés Mirandés 1-1 Eibar Eibar más información 5
 
10 Ago 13
19:30 Finalizado 		Atl. Astorga Atl. Astorga 1-2 Zamora Zamora más información Jugadas destacadas 10
0-1 33' C. Salvador
39' Héctor Taranilla 1-1
1-2 88' Manu
 
10 Ago 13
20:00 Finalizado 		Real Murcia Real Murcia 0-1 Elche Elche más información Jugadas destacadas 203
0-1 60' Coro
 
10 Ago 13
20:00 Finalizado 		Las Palmas Las Palmas 0-2 Atlético Atlético más información 49
 
10 Ago 13
20:00 Finalizado 		Racing Ferrol Racing Ferrol 1-1 Ponferradina Ponferradina más información 4
 
10 Ago 13
20:00 Finalizado 		Osasuna Osasuna 1-1 Real Valladolid Real Valladolid más información Jugadas destacadas 1
0-1 55' J. Rueda
70' M. Onwu 1-1
 
10 Ago 13
20:10 Finalizado 		Real Madrid Real Madrid 3-0 Inter Inter más información Jugadas destacadas 80
37' C. Ronaldo 1-0
67' Ricky Álvarez
 
10 Ago 13
20:30 Finalizado 		Lucena Lucena 2-2 Marbella FC Marbella FC más información Jugadas destacadas 1
25' Javi Gómez 1-0
40' Javi Gómez 2-0
 
10 Ago 13
20:30 Finalizado 		Almería B Almería B 0-1 Real Jaén Real Jaén más información Jugadas destacadas 22
0-1 79' Machado
 
10 Ago 13
20:45 Finalizado 		Tenerife Tenerife 5-0 Rayo Vallecano Rayo Vallecano más información 67
 
10 Ago 13
21:00 Finalizado 		Córdoba CF Córdoba CF 3-2 Almería Almería más información 12
 
10 Ago 13
22:00 Finalizado 		Marítimo Marítimo 0-0 Celta Celta más información 2

INFORMACIÓN

Partidos Amistosos entren clubes de todo el mundo.Se realizan antes de comenzar sus respectivas ligas.
TOP colaboradores para esta liga
Pablo De La Calle
Pablo De La Calle
1435 pts
jvdgs24
jvdgs24
1382 pts
Xavi
Xavi
692 pts
Más colaboradores en esta liga (62)
¿Quieres ser colaborador? haz click aquí

  USO DE MEMORIA  
5,209,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0037
Controller Execution Time ( Home / Category )  0.0887
Total Execution Time  0.0924
  CADENA URL  
/partidos_amistosos2014/grupo1/jornada34
  GET DATOS  
$_GET['/partidos_amistosos2014/grupo1/jornada34']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0050  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 = 2399 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 12:18:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 12:18:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 12:18:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 12:18:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  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=2399 AND rel.round=34
0.0018  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-01" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 2399 ORDER BY creation_date DESC LIMIT 0, 10
0.0040  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-01" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 2399
0.0085  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 `calendars2014` 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` = 2399 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0094  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 events2014 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2014 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 2399 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 (53339,1361,27433,27515,27516,53641,53640,43378,51781,53647,28367,22201,22068,45675,45840,45663,43390,38507,45988,45799,45803,51716,53644,27522,52881,35270,53636,45925,53637) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0033  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 `events2014` e INNER JOIN calendars2014 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 2399 ORDER BY total DESC LIMIT 40
0.0018  SELECT distinct(shedule), round FROM `calendars2014` as c WHERE c.`league_id` = 2399 AND shedule >= '2013/08/01' AND shedule < '2013/09/01' ORDER BY shedule ASC
0.0029  SELECT data1, data2 FROM services_tags WHERE categoryId=153
0.0029  SELECT group_code, extraName from `leagues` WHERE categoryId=153 AND year=2014