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

Partidos Amistosos 2020

Resultados
« Jornada Anterior
Jornada 150
Jornada Siguiente »
 
26 Ene 20
00:15 Finalizado 		Liga de Quito Liga de Quito 2-0 Fénix Fénix más información Jugadas destacadas ...
12' C. Martínez Borja 1-0
77' J. Arce 2-0
 
26 Ene 20
04:30 Finalizado 		Los Angeles FC Los Angeles FC 2-0 Peñarol Peñarol más información Jugadas destacadas ...
10' C. Vela 1-0
41' A. Perez 2-0
61' F. Torres
 
26 Ene 20
13:00 Finalizado 		Dassendorf Dassendorf 2-4 Hannoverscher Hannoverscher más información ...
 
26 Ene 20
13:00 Finalizado 		Eintracht Norderstedt Eintracht Norderstedt 7-0 Victoria Hamburg Victoria Hamburg más información Jugadas destacadas ...
10' A. Tourgaidis 1-0
31' Johann Von Knebel 2-0
33' Brüning 3-0
65' Lüneburg 4-0
76' A. Tourgaidis 5-0
76' Lüneburg 6-0
88' Lüneburg 7-0
 
26 Ene 20
13:00 Finalizado 		Jablonec Jablonec 1-2 FK Krasnodar FK Krasnodar más información Jugadas destacadas ...
0-1 29' M. Fernandes
32' J. Krob 1-1
1-2 57' A. Chernikov
 
26 Ene 20
13:00 Finalizado 		Sered Sered 2-3 KF Shkëndija KF Shkëndija más información Jugadas destacadas ...
6' T. Ba 1-0
30' Alex Ivan 2-0
2-1 32' B. Ibraimi
2-2 57' M. Radeski
2-3 66' L. Sadriu
 
26 Ene 20
13:30 Finalizado 		Altglienicke Altglienicke 0-0 Neustrelitz Neustrelitz más información ...
 
26 Ene 20
14:00 Finalizado 		FC Flora FC Flora 3-0 Levadia Levadia más información ...
 
26 Ene 20
14:00 Finalizado 		FK Spartak Subotica FK Spartak Subotica 0-2 Shakhtyor Soligorsk Shakhtyor Soligorsk más información Jugadas destacadas ...
0-1 62' A. Llullaku
0-2 87' A. Llullaku
 
26 Ene 20
14:00 Aplazado 		FC Táborsko FC Táborsko Apl České Budějovice II České Budějovice II más información ...
 
26 Ene 20
14:00 Finalizado 		Baltika Kaliningrad Baltika Kaliningrad 0-0 AP Brera AP Brera más información ...
 
26 Ene 20
14:00 Finalizado 		IFK Göteborg IFK Göteborg 2-3 Aalborg BK Aalborg BK más información Jugadas destacadas 1
0-1 45' Mathias Ross
59' Tobias Sana 1-1
1-2 65' Mikkel Kaufmann
1-3 72' S. Tengstedt
83' A. Affane 2-3
90' Jores Okore
 
26 Ene 20
15:00 Finalizado 		Arsenal Tula Arsenal Tula 2-2 Titograd Podgorica Titograd Podgorica más información Jugadas destacadas ...
36' S. Tkachev 1-0
38' E. Kangwa 2-0
2-1 53' M. Brnović
2-2 70' M. Brnović
 
26 Ene 20
15:00 Finalizado 		Spartak Trnava Spartak Trnava 0-1 Olimpik Donetsk Olimpik Donetsk más información ...
 
26 Ene 20
15:00 Finalizado 		Tsarsko Selo Tsarsko Selo 1-0 Ural Yekaterinburg Ural Yekaterinburg más información ...
 
26 Ene 20
15:30 Finalizado 		JS Hercules JS Hercules 2-1 Oulun Luistinseura Oulun Luistinseura más información Jugadas destacadas ...
0-1 31' J. Vääräniemi
36' S. Ukkola 1-1
75' Joonas Kurvinen 2-1
 
26 Ene 20
15:30 Finalizado 		Legia Warszawa Legia Warszawa 2-0 Kairat Almaty Kairat Almaty más información Jugadas destacadas ...
41' D. Antolić 1-0
71' A. Martins 2-0
 
26 Ene 20
15:30 Finalizado 		Crvena Zvezda Crvena Zvezda 3-2 Arka Gdynia Arka Gdynia más información Jugadas destacadas ...
24' M. Degenek 1-0
1-1 24' D. Zbozien
1-2 45' F. Serrarens
74' A. Vukanović 2-2
 
26 Ene 20
15:30 Finalizado 		Shakhtar Donetsk Shakhtar Donetsk 1-1 Vojvodina Novi Sad Vojvodina Novi Sad más información Jugadas destacadas ...
78' S. Bolbat
82' Alan Patrick 2-0
 
26 Ene 20
15:30 Finalizado 		TPV Tampere TPV Tampere 3-0 Tampere United Tampere United más información Jugadas destacadas ...
18' A. Kujala 1-0
49' G. Shala 2-0
74' T. Jarvi 3-0
 
26 Ene 20
15:30 Finalizado 		Vardar Skopje Vardar Skopje 1-2 FK TSC FK TSC más información ...
 
26 Ene 20
16:00 Finalizado 		BSV Kickers Emden BSV Kickers Emden 4-4 VfL Oldenburg VfL Oldenburg más información Jugadas destacadas ...
0-1 4' P. Steinwender
7' H. Wulff 1-1
25' Aderinan A. 2-1
2-2 40' P. Steinwender
48' Tido Steffens 3-2
3-3 49' E. Bytyqi
56' S. Adeniran 4-3
4-4 65' Kifuta Makangu
 
26 Ene 20
16:00 Finalizado 		Lokomotiv Moskva Lokomotiv Moskva 1-1 Jeonbuk Hyundai Motors Jeonbuk Hyundai Motors más información Jugadas destacadas 1
0-1 56' Seung-Ki Lee
64' Éder 1-1
 
26 Ene 20
18:00 Finalizado 		Waterford United Waterford United 0-0 Shamrock Rovers Shamrock Rovers más información ...
 
26 Ene 20
18:00 Finalizado 		Åsane Åsane 6-2 Os Turn Os Turn más información ...

INFORMACIÓN

Partidos Amistosos entren clubes de todo el mundo.Se realizan antes de comenzar sus respectivas ligas.

  USO DE MEMORIA  
5,720,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1065
Total Execution Time  0.1087
  CADENA URL  
/partidos_amistosos2020/grupo1/jornada150
  GET DATOS  
$_GET['/partidos_amistosos2020/grupo1/jornada150']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0144  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 = 49506 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 12:04:47' 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-04-28 12:04:47' 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-04-28 12:04:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 12:04:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  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=49506 AND rel.round=150
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-03-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 49506 ORDER BY creation_date DESC LIMIT 0, 10
0.0033  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-03-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 49506
0.0077  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 `calendars2020` 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` = 49506 AND c.`round` = 150 ORDER BY shedule ASC LIMIT 200
0.0048  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 events2020 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2020 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 49506 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 (355550,355552,323424,330179,320895,347026,354147,320896,350380,354451,346078,320897,336420,321822,347568,355554,354140,353370,351246,347031,332282,354159,347555,351232,347032) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0018  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 `events2020` e INNER JOIN calendars2020 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 = 150 AND e.real_date IS NOT NULL AND e.league_id = 49506 ORDER BY total DESC LIMIT 40
0.0037  SELECT data1, data2 FROM services_tags WHERE categoryId=153
0.0037  SELECT group_code, extraName from `leagues` WHERE categoryId=153 AND year=2020