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 63
Jornada Siguiente »
 
01 Sep 20
14:00 Finalizado 		Wehen Wiesbaden Wehen Wiesbaden 1-0 Kaiserslautern Kaiserslautern más información Jugadas destacadas 2
78' M. Malone 1-0
 
01 Sep 20
14:00 Finalizado 		Stoke City Stoke City 3-0 Leeds United Leeds United más información Jugadas destacadas ...
24' Nathan Collins 1-0
52' Lee Gregory 2-0
62' Tom Ince 3-0
 
01 Sep 20
14:00 Finalizado 		Middlesbrough Middlesbrough 5-1 Newcastle Newcastle más información Jugadas destacadas 119
42' B. Assombalonga 1-0
43' M. Tavernier 2-0
44' B. Assombalonga 3-0
3-1 45' A. Saint-Maximin
89' Grant Hall 4-1
90' S. Walker 5-1
 
01 Sep 20
14:30 Finalizado 		Swansea City Swansea City 2-1 Forest Green Rovers Forest Green Rovers más información Jugadas destacadas 3
9' Jamal Lowe 1-0
28' Yan Dhanda 2-0
2-1 36' K. Wilson
 
01 Sep 20
15:00 Finalizado 		Preston North End Preston North End 0-0 Burnley Burnley más información ...
 
01 Sep 20
15:00 Finalizado 		Millwall Millwall 0-1 Crystal Palace Crystal Palace más información Jugadas destacadas 4
0-1 28' Max Meyer
 
01 Sep 20
16:00 Finalizado 		Brentford Brentford 2-2 Oxford United Oxford United más información Jugadas destacadas ...
55' Sergi Canós 1-0
73' Sergi Canós 2-0
2-1 84' D. Osei Yaw
2-2 86' D. Osei Yaw
 
01 Sep 20
16:00 Finalizado 		Birmingham City Birmingham City 3-0 Walsall Walsall más información Jugadas destacadas 6
45' Agus Medina 1-0
56' Amari Miller 2-0
87' O. Bailey 3-0
 
01 Sep 20
16:30 Finalizado 		Kasımpaşa Kasımpaşa 1-1 Istanbulspor AS Istanbulspor AS más información Jugadas destacadas ...
0-1 32' P. Diouf
74' A. Kara 1-1
 
01 Sep 20
17:00 Aplazado 		Reading Reading Apl West Ham West Ham más información 1
 
01 Sep 20
17:00 Finalizado 		Lazio Lazio 1-0 Padova Padova más información Jugadas destacadas 98
88' N. Fazzi
 
01 Sep 20
17:30 Finalizado 		Panaitolikos Panaitolikos 3-1 Karaiskakis Karaiskakis más información Jugadas destacadas 11
7' J. Mendoza 1-0
20' C. Belevonis 2-0
52' J. Mendoza 3-0
 
01 Sep 20
17:30 Finalizado 		Parma Parma 2-0 AC Carpi AC Carpi más información Jugadas destacadas ...
27' A. Grassi 1-0
33' R. Inglese 2-0
 
01 Sep 20
18:00 Finalizado 		Rain / Lech Rain / Lech 4-1 Ingolstadt 04 II Ingolstadt 04 II más información ...
 
01 Sep 20
18:00 Finalizado 		Derby County Derby County 0-2 Sheffield United Sheffield United más información Jugadas destacadas 11
0-1 38' Ben Osborn
0-2 73' Billy Sharp
 
01 Sep 20
19:00 Finalizado 		Albacete Albacete 2-0 Rayo Majadahonda Rayo Majadahonda más información Jugadas destacadas 49
3' Manu Fuster 1-0
60' K. Azamoum 2-0
 
01 Sep 20
19:00 Finalizado 		Portimonense Portimonense 0-0 Reading Reading más información ...
01 Sep 20
19:00 Aplazado 		Everton Everton Apl Blackburn Rovers Blackburn Rovers más información 2
 
01 Sep 20
19:30 Aplazado 		SC Telstar SC Telstar Apl Rijnsburgse Boys Rijnsburgse Boys más información 2
 
01 Sep 20
19:30 Finalizado 		FSV Duisburg FSV Duisburg 2-1 VfB Frohnhausen VfB Frohnhausen más información Jugadas destacadas ...
70' Emre Sahin 1-0
1-1 78' Kim Dedek
89' Nermin Badnjevic 2-1
 
01 Sep 20
19:30 Finalizado 		SV Sodingen SV Sodingen 1-1 Holzwickeder Holzwickeder más información 2
 
01 Sep 20
19:30 Finalizado 		YF Juventus YF Juventus 3-3 Aarau Aarau más información Jugadas destacadas 2
0-1 3' Karakurd
18' Willy 1-1
1-2 31' P. Mišić
41' N. Plavci 2-2
48' N. Plavci 3-2
3-3 54' P. Mišić
 
01 Sep 20
20:00 Finalizado 		Beşiktaş Beşiktaş 0-1 Sivasspor Sivasspor más información Jugadas destacadas 49
31' D. Toköz
0-1 91' M. Yatabaré
 
01 Sep 20
20:00 Finalizado 		Holstein Kiel II Holstein Kiel II 2-8 Victoria Hamburg Victoria Hamburg más información ...
01 Sep 20
20:00 Finalizado 		Mallorca Mallorca 2-0 CD Castellón CD Castellón más información Jugadas destacadas 95
24' Álex Alegría 1-0
45' Joan Sastre 2-0
 
01 Sep 20
20:30 Finalizado 		Worksop Town Worksop Town 0-0 Guiseley Guiseley más información 10
 
01 Sep 20
20:30 Finalizado 		AFC Hornchurch AFC Hornchurch 0-0 Ebbsfleet United Ebbsfleet United más información ...
 
01 Sep 20
20:30 Finalizado 		Stalybridge Celtic Stalybridge Celtic 2-2 Belper Town FC Belper Town FC más información Jugadas destacadas ...
29' D. Holness 1-0
1-1 32' J. Woodcock
50' J. Ustabaşı 2-1
2-2 74' D. South
 
01 Sep 20
20:30 Finalizado 		Chadderton Chadderton 0-3 Mossley Mossley más información Jugadas destacadas ...
0-1 27' M. Waller
0-2 27' R. Shenton
0-3 45' J. Butterworth
 
01 Sep 20
20:30 Finalizado 		Bedworth United Bedworth United 0-1 Coalville Town Coalville Town más información Jugadas destacadas ...
0-1 54' T. Berridge
 
01 Sep 20
20:30 Finalizado 		Matlock Town Matlock Town 0-0 Sheffield FC Sheffield FC más información 4
 
01 Sep 20
20:30 Finalizado 		Ballyclare Comrades Ballyclare Comrades 1-3 Carrick Rangers Carrick Rangers más información Jugadas destacadas 1
24' S. Mcilveen 1-0
1-1 34' J. Ferrin
1-2 78' L. Hassin
78' L. Hassin 2-2
2-3 90' J. Dunne
 
01 Sep 20
20:30 Finalizado 		Bedford Town Bedford Town 1-6 Hitchin Town Hitchin Town más información Jugadas destacadas ...
0-1 10' L. Brown
11' C. Tomlinson 1-1
1-2 25' A. Marsh
1-3 33' Lawrence
1-4 69' L. Brown
1-5 74' J. Dhillon
1-6 77' A. Marsh
 
01 Sep 20
20:45 Finalizado 		Northwood Northwood 0-6 Wealdstone Wealdstone más información Jugadas destacadas ...
0-1 54' R. Lafayette
0-2 58' D. Parish
0-3 82' D. Parish
0-4 85' A. Charles
0-5 89' D. Parish
 
01 Sep 20
20:45 Finalizado 		Royston Town Royston Town 3-1 Barton Rovers Barton Rovers más información Jugadas destacadas ...
35' Edwards 1-0
40' Edwards 2-0
84' Edwards 3-0
 
01 Sep 20
20:45 Finalizado 		Warrington Town Warrington Town 0-4 Southport Southport más información Jugadas destacadas ...
0-1 27' Jack Sampson
0-2 64' M. Ali
0-3 71' M. Carver
0-4 89' G. Newell
 
01 Sep 20
20:45 Finalizado 		Trafford Trafford 2-2 Ashton United Ashton United más información Jugadas destacadas ...
76' Y. Fosian 1-0
1-1 76' T. Bentham
1-2 87' C. Rowney
89' M. Hazeldine 2-2
 
01 Sep 20
20:45 Finalizado 		Rushall Olympic Rushall Olympic 3-2 Coleshill Town FC Coleshill Town FC más información Jugadas destacadas 1
19' R. Reid 1-0
35' R. Reid 2-0
64' A. Moore 3-0
 
01 Sep 20
20:45 Finalizado 		Bowers and Pitsea Bowers and Pitsea 0-3 Welling United Welling United más información ...
 
01 Sep 20
20:45 Finalizado 		Banbury United Banbury United 6-1 Wantage Town Wantage Town más información Jugadas destacadas ...
7' J. Constable 1-0
14' K. Langmead 2-0
25' A. Awadh 3-0
43' G. Rasulo 4-0
56' J. Constable 5-0
77' P. Haysham 6-0
6-1 90' A. Stott
 
01 Sep 20
20:45 Finalizado 		Coggeshall Town Coggeshall Town 2-1 Hertford Town Hertford Town más información Jugadas destacadas ...
29' K. Bailey 1-0
65' J. Turner 2-0
 
01 Sep 20
20:45 Finalizado 		Faversham Town Faversham Town 4-0 Margate Margate más información Jugadas destacadas ...
25' De Santos 1-0
31' Brown 2-0
31' De Santos 3-0
66' W. Risdon 4-0
 
01 Sep 20
20:45 Finalizado 		Ilkeston Town FC Ilkeston Town FC 0-1 Grantham Town Grantham Town más información Jugadas destacadas ...
34' Michael Hollingsworth
0-1 50' N. Dyer
 
01 Sep 20
20:45 Finalizado 		Ramsbottom United Ramsbottom United 1-2 Bamber Bridge Bamber Bridge más información Jugadas destacadas ...
0-1 17' C. Marlow
0-2 65' D. O'Brien
 
01 Sep 20
20:45 Aplazado 		Rotherham United Rotherham United Apl Burton Albion Burton Albion más información 1
 
01 Sep 20
20:45 Finalizado 		Metropolitan Police Metropolitan Police 0-2 Aldershot Town Aldershot Town más información Jugadas destacadas ...
0-1 23' M. Bettamer
0-2 69' H. Panayiotou
 
01 Sep 20
20:45 Finalizado 		Marlow FC Marlow FC 1-2 Winchester City Winchester City más información Jugadas destacadas ...
0-1 13' T. Mitford
0-2 65' G. Purdy
 
01 Sep 20
20:45 Finalizado 		Hythe Town Hythe Town 0-1 Dover Athletic Dover Athletic más información ...
 
01 Sep 20
20:45 Finalizado 		Corby Town Corby Town 1-0 Stamford Stamford más información Jugadas destacadas ...
10' C. Wise 1-0
 
01 Sep 20
20:45 Finalizado 		Chasetown Chasetown 1-3 Alvechurch FC Alvechurch FC más información Jugadas destacadas ...
12' J. Butlin 1-0
1-1 34' K. Cook
1-2 45' J. Wakeling
1-3 82' K. McFarlane
 
01 Sep 20
20:45 Aplazado 		Bury Town Bury Town Apl Braintree Town Braintree Town más información 1
 
01 Sep 20
20:45 Finalizado 		Aveley Aveley 1-1 Cray Wanderers Cray Wanderers más información Jugadas destacadas ...
0-1 4' J. Leader
 
01 Sep 20
20:45 Finalizado 		AFC Totton AFC Totton 0-1 Weymouth Weymouth más información Jugadas destacadas ...
0-1 62' C. Cooke
 
01 Sep 20
20:45 Finalizado 		Mickleover Sports FC Mickleover Sports FC 1-2 Alfreton Town Alfreton Town más información Jugadas destacadas ...
0-1 51' S. Tuton
51' S. Beavon 1-1
1-2 61' S. Tuton
 
01 Sep 20
20:45 Finalizado 		St Ives Town St Ives Town 2-6 Soham Town Rangers Soham Town Rangers más información ...
 
01 Sep 20
20:45 Finalizado 		Leek Town Leek Town 2-1 Nantwich Town Nantwich Town más información Jugadas destacadas 1
47' R. Stevenson 1-0
1-1 55' S. Cooke
 
01 Sep 20
20:45 Finalizado 		Glossop Glossop 0-0 Hyde Hyde 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  
6,399,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1658
Total Execution Time  0.1678
  CADENA URL  
/partidos_amistosos2021/grupo1/jornada63
  GET DATOS  
$_GET['/partidos_amistosos2021/grupo1/jornada63']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'partidos_amistosos2021'
0.0040  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.0024  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.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:10:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 19:10:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 19:10:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 19:10:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0036  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.0041  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=63
0.0025  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.0020  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-28" 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.0093  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 56547
0.0125  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` = 63 ORDER BY shedule ASC LIMIT 200
0.0062  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 (70562,94575,78988,85366,91164,81515,91166,81516,91167,83020,86980,91172,91170,91173,78990,84069,91458,73469,67375,91175,91177,82392,85374,91176,81934,91188,86987,91187,91184,83437,82544,91182,91183,71662,91203,91207,91206,91204,91192,91476,91479,91481,91484,91490,71907,91200,91199,91197,91195,91194,91193,86989,91189,85377,85380,86992,86991) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0129  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 = 63 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/09/01' AND shedule < '2020/10/01' ORDER BY shedule ASC
0.0017  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 56547 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0031  SELECT data1, data2 FROM services_tags WHERE categoryId=153
0.0031  SELECT group_code, extraName from `leagues` WHERE categoryId=153 AND year=2021