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 14
Jornada Siguiente »
 
14 Jul 20
10:00 Finalizado 		SKA-Khabarovsk SKA-Khabarovsk 3-1 Chernomorets Novorossisk Chernomorets Novorossisk más información Jugadas destacadas ...
8' R. Gadzhimuradov 1-0
1-1 11' R. Akhmedkhanov
15' V. Kamilov 2-1
33' D. Bolshakov 3-1
 
14 Jul 20
14:00 Aplazado 		Krupa na Vrbasu Krupa na Vrbasu Apl Mačva Šabac Mačva Šabac más información ...
 
14 Jul 20
14:45 Finalizado 		Montevideo Wanderers Montevideo Wanderers 1-0 Rampla Juniors Rampla Juniors más información Jugadas destacadas ...
60' J. Barboza 1-0
 
14 Jul 20
15:00 Aplazado 		AP Brera AP Brera Apl Makedonija GP Makedonija GP más información 1
 
14 Jul 20
16:00 Finalizado 		Inđija Inđija 0-2 Borac Banja Luka Borac Banja Luka más información Jugadas destacadas 1
0-1 22' S. Vranjes
0-2 81' D. Zilkic
 
14 Jul 20
17:00 Finalizado 		Sigma Olomouc II Sigma Olomouc II 4-0 Šumperk Šumperk más información Jugadas destacadas 2
2' R. Badura 1-0
61' J. Spacil 2-0
76' J. Spacil 3-0
78' Milos Sidlik 4-0
 
14 Jul 20
17:00 Finalizado 		Slovan Galanta Slovan Galanta 1-3 Komárno Komárno más información ...
 
14 Jul 20
17:00 Finalizado 		Pirin Blagoevgrad Pirin Blagoevgrad 2-5 Vihren Vihren más información Jugadas destacadas ...
18' V. Zlatinov 1-0
23' D. Aleksiev 2-0
2-1 32' Vladimir Kabranov
45' M. Pushkarov
3-2 55' A. Yakimov
3-3 57' Vladimir Kabranov
3-4 77' T. Galabov
 
14 Jul 20
17:00 Finalizado 		Humenné Humenné 2-1 Bardejov Bardejov más información Jugadas destacadas ...
72' M. Polascik 1-0
74' M. Milunovic 2-0
 
14 Jul 20
17:00 Finalizado 		SKA-Khabarovsk SKA-Khabarovsk 1-0 FK Olimpia Gelendzhik FK Olimpia Gelendzhik más información Jugadas destacadas ...
87' D. Ivankov 1-0
 
14 Jul 20
17:30 Finalizado 		Renova Renova 2-0 Vardari Forino Vardari Forino más información Jugadas destacadas ...
55' E. Ramadani 1-0
66' S. Shefiti 2-0
 
14 Jul 20
17:30 Finalizado 		FK Borec FK Borec 0-0 Tikves Tikves más información ...
 
14 Jul 20
17:45 Finalizado 		Belasica Belasica 0-1 Sileks Sileks más información Jugadas destacadas 3
0-1 5' D. Tanturovski
 
14 Jul 20
18:00 Finalizado 		AP Brera AP Brera 3-0 Osogovo Osogovo más información Jugadas destacadas ...
12' K. Velinovski 1-0
50' N. Serafimov 2-0
85' A. Mishov 3-0
 
14 Jul 20
18:30 Finalizado 		Javor Ivanjica Javor Ivanjica 2-1 Proleter Novi Sad Proleter Novi Sad más información Jugadas destacadas ...
0-1 9' D. Bacanović
67' N. Sevic 1-1
79' N. Sevic 2-1
 
14 Jul 20
18:30 Finalizado 		Austria Klagenfurt Austria Klagenfurt 0-2 FC KAC 1909 FC KAC 1909 más información Jugadas destacadas ...
0-1 16' Plieschnegger
0-2 29' D. Grafischer
 
14 Jul 20
18:30 Finalizado 		Köttmannsdorf Köttmannsdorf 3-0 ASKO Wolfnitz ASKO Wolfnitz más información Jugadas destacadas ...
16' T. Mccargo 1-0
73' S. Borovnik 2-0
81' Janschitz 3-0
 
14 Jul 20
19:00 Finalizado 		Ilzer SV Ilzer SV 4-1 SV Stegersbach SV Stegersbach más información Jugadas destacadas ...
8' J. Ostermann 1-0
44' J. Ostermann 2-0
66' L. Luttenberger 3-0
80' L. Luttenberger 4-0
 
14 Jul 20
19:00 Aplazado 		Gurten Gurten Apl Austria Salzburg Austria Salzburg más información ...
 
14 Jul 20
19:00 Finalizado 		Vöcklamarkt Vöcklamarkt 2-1 Weisskirchen Weisskirchen más información Jugadas destacadas ...
33' M. Olivotto 1-0
35' B. Taferner 2-0
2-1 42' M. Schröttner
 
14 Jul 20
19:00 Finalizado 		Bad Schallerbach Bad Schallerbach 3-0 Gmundner Milch Gmundner Milch más información ...
 
14 Jul 20
19:00 Finalizado 		Kitzbühel Kitzbühel 3-1 Austria Salzburg Austria Salzburg más información ...
 
14 Jul 20
19:00 Finalizado 		TUS Heiligenkreuz TUS Heiligenkreuz 4-1 Kalsdorf Kalsdorf más información Jugadas destacadas ...
23' P. Unterkircher 1-0
54' P. Jury 2-0
2-1 62' J. Appiah
81' Patrick Wiesenhofer 3-1
84' Mohsenzada 4-1
 
14 Jul 20
19:00 Finalizado 		Allerheiligen Allerheiligen 9-0 USC Eichkogl USC Eichkogl más información Jugadas destacadas ...
22' L. Überbacher 1-0
54' L. Überbacher 2-0
54' D. Bernsteiner 3-0
75' L. Überbacher 4-0
81' F. Knez 5-0
86' L. Puster 6-0
89' A. Kager 7-0
89' Josip Eskinja 8-0
90' L. Überbacher 9-0
 
14 Jul 20
19:00 Finalizado 		Strausberg Strausberg 0-0 Berliner AK 07 Berliner AK 07 más información 1
 
14 Jul 20
19:15 Finalizado 		SV Kumberg SV Kumberg 3-2 Sc St Ruprecht/raab Sc St Ruprecht/raab más información Jugadas destacadas ...
3' F. Bauer 1-0
8' N. Todtling 2-0
20' F. Bauer 3-0
3-1 24' F. Harrer
3-2 30' F. Krenn
 
14 Jul 20
19:30 Finalizado 		WSG Tirol WSG Tirol 6-4 Mils Mils más información 1

INFORMACIÓN

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

  USO DE MEMORIA  
5,586,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.4102
Total Execution Time  0.4124
  CADENA URL  
/partidos_amistosos2021/grupo1/jornada14
  GET DATOS  
$_GET['/partidos_amistosos2021/grupo1/jornada14']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0146  SELECT type FROM routes WHERE alias = 'partidos_amistosos2021'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'partidos_amistosos' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0147  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2021' WHERE c.parentId=153 GROUP BY c.id ORDER BY c.order_id ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:21:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:21:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:21:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:21:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'partidos_amistosos' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0148  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=14
0.0145  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 56547 AND esl.points > 0
0.0151  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` = 14 ORDER BY shedule ASC LIMIT 200
0.0165  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 (4224,3419,5408,623,5402,5208,5552,5207,5206,4227,557,327,590,4229,5213,5214,5215,5218,626,5223,5220,5219,4230,5216,4231,5222,5224) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0389  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 = 14 AND e.real_date IS NOT NULL AND e.league_id = 56547 ORDER BY total DESC LIMIT 40
0.0158  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.0145  SELECT data1, data2 FROM services_tags WHERE categoryId=153
0.0153  SELECT group_code, extraName from `leagues` WHERE categoryId=153 AND year=2021