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

Partidos Amistosos 2021

Resultados
« Jornada Anterior
Jornada 24
Jornada Siguiente »
 
24 Jul 20
08:20 Finalizado 		Beitar Tel Aviv Bat Yam Beitar Tel Aviv Bat Yam 2-3 Hapoel Ramat Gan Hapoel Ramat Gan más información ...
 
24 Jul 20
13:00 Aplazado 		Anderlecht Anderlecht Apl Olympique Lyonnais Olympique Lyonnais más información 5
 
24 Jul 20
13:00 Finalizado 		Almere City Almere City 1-0 Jong Utrecht Jong Utrecht más información Jugadas destacadas ...
78' I. Alhaft 1-0
 
24 Jul 20
15:00 Aplazado 		FK Borec FK Borec Apl Belasica Belasica más información ...
 
24 Jul 20
15:00 Aplazado 		Kortrijk Kortrijk Apl RWD Molenbeek RWD Molenbeek más información ...
 
24 Jul 20
16:00 Finalizado 		ENPPI ENPPI 0-0 Talaea El-Gaish Talaea El-Gaish más información ...
 
24 Jul 20
16:00 Finalizado 		Antwerp Antwerp 2-3 Olympique Lyonnais Olympique Lyonnais más información Jugadas destacadas 3
0-1 25' M. Dembélé
44' A. Seck
1-2 48' Maxwel Cornet
71' Martin Hongla 2-2
79' Aurélio Buta 3-2
 
24 Jul 20
16:00 Finalizado 		Metz Metz 2-0 Charleroi Charleroi más información Jugadas destacadas 6
53' F. Boulaya 1-0
87' F. Boulaya 2-0
 
24 Jul 20
17:00 Finalizado 		Nîmes Nîmes 0-1 Strasbourg Strasbourg más información Jugadas destacadas 27
0-1 88' L. Mothiba
 
24 Jul 20
17:30 Finalizado 		Kromeriz Kromeriz 1-1 Slovácko II Slovácko II más información Jugadas destacadas 1
53' M. Votava 1-0
1-1 60' Robert Janas
 
24 Jul 20
18:00 Finalizado 		Rabotnički Rabotnički 0-2 KF Shkëndija KF Shkëndija más información Jugadas destacadas ...
0-1 56' V. Ahmedi
0-2 68' B. Ibraimi
 
24 Jul 20
18:00 Finalizado 		Chambly Chambly 1-1 Dunkerque Dunkerque más información Jugadas destacadas 1
53' A. Soubervie 1-0
1-1 90' K. Rocheteau
 
24 Jul 20
18:00 Aplazado 		ASKÖ Gmünd ASKÖ Gmünd Apl Spittal Spittal más información ...
 
24 Jul 20
18:00 Finalizado 		Kutna Hora Kutna Hora 0-4 Havlíčkův Brod Havlíčkův Brod más información Jugadas destacadas ...
0-1 23' M. Šihart
0-2 45' M. Cakl
0-3 63' J. Zila
0-4 77' J. Henek
 
24 Jul 20
18:30 Finalizado 		Hallwang Hallwang 0-2 USK Anif USK Anif más información 1
 
24 Jul 20
18:30 Finalizado 		First Vienna First Vienna 6-3 Wiener Neustadt Wiener Neustadt más información Jugadas destacadas ...
0-1 3' Marco Dominkus
14' Luca Edelhofer 1-1
36' E. Jusic 2-1
36' M. Konrad 3-1
3-2 41' O. Bozkurt
41' E. Jusic 4-2
69' P. Schneider 5-2
84' P. Schneider 6-2
6-3 86' Yusuf Onur
 
24 Jul 20
19:00 Finalizado 		SV Wallern SV Wallern 1-4 Vöcklamarkt Vöcklamarkt más información Jugadas destacadas ...
0-1 10' P. Lipczinski
0-2 60' B. Taferner
0-3 80' B. Taferner
0-4 85' M. Olivotto
86' Michael Streif 1-4
 
24 Jul 20
19:00 Finalizado 		Hannover 96 II Hannover 96 II 0-1 Arminia Hannover Arminia Hannover más información ...
 
24 Jul 20
19:00 Finalizado 		Lebring Lebring 0-1 TUS Bad Gleichenberg TUS Bad Gleichenberg más información Jugadas destacadas ...
0-1 67' Krenn
 
24 Jul 20
19:00 Finalizado 		Weindorf Weindorf 7-0 SV Strass SV Strass más información Jugadas destacadas ...
8' A. Lackner 1-0
22' Markus Klöckl 2-0
47' Sandro Schleich 3-0
49' Sandro Schleich 4-0
53' C. Kobald 5-0
56' C. Kobald 6-0
60' A. Lackner 7-0
 
24 Jul 20
19:00 Finalizado 		Luckenwalde Luckenwalde 3-1 FC Hertha 03 Zehlendorf FC Hertha 03 Zehlendorf más información Jugadas destacadas ...
0-1 2' Huke
22' Tobias Göth 1-1
41' T. Plumpe 2-1
48' D. Rothenstein 3-1
89' Tobias Göth
 
24 Jul 20
19:00 Finalizado 		NK Nosteria NK Nosteria 0-3 Vukovar '91 Vukovar '91 más información ...
 
24 Jul 20
19:00 Finalizado 		Ortmann Ortmann 7-4 Bad Fischau-Brunn Bad Fischau-Brunn más información ...
 
24 Jul 20
19:15 Finalizado 		Eintracht Bad Kreuznach Eintracht Bad Kreuznach 1-0 Russingen Russingen más información Jugadas destacadas ...
83' Thiemo Stavridis 1-0

INFORMACIÓN

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

  USO DE MEMORIA  
5,473,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1262
Total Execution Time  0.1283
  CADENA URL  
/partidos_amistosos2021/grupo1/jornada24
  GET DATOS  
$_GET['/partidos_amistosos2021/grupo1/jornada24']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0185  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 = 56547 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-27 23:57:30' 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-27 23:57:30' 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-27 23:57:30' 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-04-27 23:57:30' 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=56547 AND rel.round=24
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` = 56547 ORDER BY creation_date DESC LIMIT 0, 10
0.0027  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` = 56547
0.0036  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 `calendars2021` 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` = 56547 AND c.`round` = 24 ORDER BY shedule ASC LIMIT 200
0.0265  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 events2021 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2021 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 56547 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 (18779,418,6273,329,8859,17947,9553,5302,5512,989,506,663,17953,18005,17956,17955,6121,17957,17959,18115,8863,18797,18798,17961) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0035  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 `events2021` e INNER JOIN calendars2021 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 = 24 AND e.real_date IS NOT NULL AND e.league_id = 56547 ORDER BY total DESC LIMIT 40
0.0021  SELECT distinct(shedule), round FROM `calendars2021` as c WHERE c.`league_id` = 56547 AND shedule >= '2020/07/01' AND shedule < '2020/08/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=2021