Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

2019/2020

Fase de Grupos

Eliminatoria

EFL Trophy 2020

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Scunthorpe	3	6	2	7
2	Leicester	3	5	3	7
3	Sunderland	3	4	7	3
4	Grimsby Town	3	4	7	0
5	Accrington	3	10	3	9
6	Fleetwood	3	7	5	4
7	Oldham	3	5	10	3
8	Liverpool	3	5	9	1
9	Salford City	2	4	0	6
10	Tranmere	2	2	3	3
11	Bury	0	0	0	0
12	Aston Villa	2	1	4	0
13	Port Vale	3	7	4	9
14	Shrewsbury	3	7	3	6
15	Macclesfield	3	5	7	3
16	Newcastle	3	2	7	0
17	Everton	3	5	3	5
18	Mansfield	3	4	3	5
19	Burton	3	4	5	3
20	Crewe	3	4	6	2
21	Man. City	3	5	4	6
22	Bolton	3	5	3	5
23	Rochdale	3	3	4	4
24	Bradford	3	3	5	1
25	Blackpool	3	7	3	6
26	Wolves	3	6	5	4
27	Morecambe	3	6	8	4
28	Carlisle	3	5	8	3
29	Man.	2	4	1	6
30	Lincoln City	2	4	3	3
31	Doncaster	3	6	6	3
32	Rotherham	3	3	7	3
33	Colchester	3	5	3	7
34	Ipswich Town	3	6	2	6
35	Gillingham	3	4	7	3
36	Tottenham	3	2	5	1
37	Oxford	3	8	4	7
38	Portsmouth	3	6	3	7
39	Norwich City	3	4	6	3
40	Crawley Town	3	2	7	0
41	Brighton	3	5	1	7
42	Leyton	3	3	4	4
43	Wimbledon	3	4	5	3
44	Southend	3	3	5	3
45	Walsall	3	7	0	7
46	Coventry	3	3	2	5
47	Forest Green	3	3	8	4
48	Southampton	3	4	7	0
49	Exeter City	3	6	1	9
50	Newport	3	11	11	3
51	West	3	9	11	3
52	Cheltenham	3	8	11	3
53	Bristol	3	4	2	7
54	Chelsea	3	5	4	6
55	Plymouth	3	4	2	4
56	Swindon Town	3	2	7	0
57	Milton	3	5	2	6
58	Fulham	3	3	3	4
59	Stevenage	3	2	4	4
60	Wycombe	3	3	4	3
61	Peterborough	3	5	1	9
62	Northampton	3	2	3	4
63	Arsenal	3	2	3	2
64	Cambridge	3	2	4	1

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Sunderland	3	4	1	7
2	Stoke City	3	3	2	5
3	Carlisle	3	5	6	4
4	Morecambe	3	3	6	0
5	Rochdale	3	6	3	7
6	Bury	3	6	4	6
7	Leicester	3	5	6	2
8	Fleetwood	3	3	7	1
9	Accrington	3	8	5	6
10	Blackpool	3	7	7	4
11	Macclesfield	3	6	8	4
12	West	3	4	5	3
13	Shrewsbury	3	9	2	7
14	Man. City	3	6	2	7
15	Crewe	3	6	9	3
16	Tranmere	3	3	11	0
17	Port Vale	3	5	1	9
18	Walsall	3	6	4	6
19	Middlesbroug	3	2	5	3
20	Burton	3	1	4	0
21	Barnsley	3	5	3	7
22	Oldham	3	8	5	6
23	Everton	3	4	5	2
24	Bradford	3	3	7	1
25	Newcastle	3	8	3	9
26	Notts County	3	5	6	3
27	Doncaster	3	5	7	3
28	Grimsby Town	3	4	6	3
29	Mansfield	3	7	4	9
30	Lincoln City	3	4	5	2
31	Scunthorpe	3	3	4	2
32	Wolves	3	3	4	2
33	Portsmouth	3	8	2	9
34	Tottenham	3	7	4	4
35	Gillingham	3	2	9	3
36	Crawley Town	3	2	4	1
37	Cambridge	3	8	4	6
38	Southend	3	6	3	6
39	Colchester	3	3	5	3
40	Southampton	3	2	7	3
41	Chelsea	3	9	3	6
42	Newport	3	5	1	6
43	Swindon Town	3	4	4	6
44	Plymouth	3	0	10	0
45	Exeter City	3	4	0	7
46	Bristol	3	4	2	6
47	Yeovil Town	3	4	2	4
48	West	3	0	8	0
49	Cheltenham	3	8	6	6
50	Arsenal	3	8	7	6
51	Forest Green	3	6	4	4
52	Coventry	3	1	6	1
53	Oxford	3	7	2	6
54	Northampton	3	4	2	6
55	Wycombe	3	3	4	6
56	Fulham	3	1	7	0
57	Swansea City	3	2	5	6
58	Charlton	3	10	3	4
59	Wimbledon	3	6	3	4
60	Stevenage	3	5	12	3
61	Luton Town	3	6	3	6
62	Peterborough	3	7	6	5
63	Brighton	3	6	6	4
64	Milton	3	5	9	1

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Fleetwood	3	7	2	9
2	Leicester	3	3	5	4
3	Carlisle	3	3	3	3
4	Morecambe	3	3	6	1
5	Blackpool	3	7	3	7
6	Accrington	3	8	4	6
7	Wigan	3	5	6	4
8	Middlesbroug	3	4	11	0
9	Bury	3	4	5	6
10	Rochdale	3	5	1	5
11	Blackburn	3	2	2	4
12	Stoke City	3	1	4	1
13	Oldham	3	5	1	7
14	Port Vale	3	5	2	7
15	Newcastle	3	3	6	3
16	Crewe	3	3	7	0
17	Walsall	3	6	3	7
18	Shrewsbury	3	6	3	6
19	Coventry	3	6	6	4
20	West	3	2	8	0
21	Bradford	3	6	6	6
22	Rotherham	3	5	3	4
23	Chesterfield	3	6	7	4
24	Man. City	3	4	5	2
25	Lincoln City	3	7	3	9
26	Mansfield	3	4	4	6
27	Notts County	3	4	5	3
28	Everton	3	2	5	0
29	Scunthorpe	3	6	3	7
30	Doncaster	3	3	2	5
31	Grimsby Town	3	3	4	2
32	Sunderland	3	2	5	1
33	Portsmouth	3	7	4	7
34	Charlton	3	5	3	6
35	Fulham	3	8	7	4
36	Crawley Town	3	2	8	0
37	Gillingham	3	10	6	9
38	Southend	3	4	2	6
39	Reading	3	7	10	1
40	Colchester	3	2	5	1
41	Swindon Town	3	7	5	6
42	West	3	6	5	6
43	Bristol	3	8	8	3
44	Wycombe	3	3	6	3
45	Yeovil Town	3	6	3	7
46	Chelsea	3	6	4	5
47	Plymouth	3	5	6	2
48	Exeter City	3	4	8	1
49	Swansea City	3	6	2	9
50	Forest Green	3	4	3	6
51	Cheltenham	3	4	5	3
52	Newport	3	2	6	0
53	Wimbledon	3	9	8	6
54	Luton Town	3	5	4	5
55	Barnet	3	6	6	4
56	Tottenham	3	6	8	1
57	Milton	3	6	3	7
58	Oxford	3	11	8	4
59	Stevenage	3	5	7	4
60	Brighton	3	3	7	1
61	Peterborough	3	5	1	7
62	Southampton	3	4	5	4
63	Northampton	3	5	5	3
64	Cambridge	3	1	4	1

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Cheltenham	3	4	3	6
2	Everton	3	4	3	4
3	Blackpool	3	3	3	4
4	Bolton	3	1	3	3
5	Wolverhampto	3	8	4	6
6	Chesterfield	3	5	5	6
7	Crewe	3	5	5	3
8	Accrington	3	4	8	3
9	Bradford	3	5	4	6
10	Morecambe	3	7	7	6
11	Bury	3	6	4	4
12	Stoke City	3	2	5	1
13	Carlisle	3	11	6	9
14	Oldham	3	8	7	4
15	Fleetwood	3	3	6	3
16	Blackburn	3	2	5	1
17	Mansfield	3	4	4	6
18	Doncaster	3	4	2	5
19	Port Vale	3	1	1	4
20	Derby County	3	4	6	1
21	Rochdale	3	5	3	7
22	Sunderland	3	4	2	7
23	Notts County	3	4	5	3
24	Hartlepool	3	2	5	0
25	Scunthorpe	3	6	1	9
26	Cambridge	3	3	3	6
27	Shrewsbury	3	3	3	3
28	Middlesbroug	3	2	7	0
29	Walsall	3	8	3	9
30	Sheffield	3	5	4	4
31	Leicester	3	1	1	4
32	Grimsby Town	3	4	10	0
33	Yeovil Town	3	6	3	7
34	Portsmouth	3	6	6	4
35	Reading	3	5	6	4
36	Bristol	3	2	4	1
37	Wimbledon	3	5	3	6
38	Swansea City	3	4	4	6
39	Plymouth	3	5	5	3
40	Newport	3	4	6	3
41	Oxford	3	5	3	5
42	Swindon Town	3	3	2	5
43	Exeter City	3	6	7	4
44	Chelsea	3	4	6	1
45	Coventry	3	11	5	9
46	Wycombe	3	8	4	6
47	West	3	3	8	1
48	Northampton	3	2	7	1
49	Southampton	3	6	1	7
50	Crawley Town	3	3	4	6
51	Charlton	3	1	3	2
52	Colchester	3	2	4	1
53	Norwich City	3	15	2	9
54	Milton	3	4	6	4
55	Peterborough	3	3	8	3
56	Barnet	3	3	9	1
57	Southend	3	3	4	6
58	Stevenage	3	7	5	4
59	Brighton	3	3	4	4
60	Leyton	3	3	3	3
61	Millwall	3	7	2	9
62	Luton Town	3	5	4	6
63	Gillingham	3	4	4	3
64	West	3	0	6	0

Equipos de esta liga

USO DE MEMORIA

8,532,928 bytes

BENCHMARKS

Loading Time Base Classes	0.0022
Controller Execution Time ( Home / Category )	0.5101
Total Execution Time	0.5124

CADENA URL

/league_trophy2020/grupo1/historico

GET DATOS

$_GET['/league_trophy2020/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (26)

0.0125	SELECT type FROM routes WHERE alias = 'league_trophy2020'
0.0254	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_trophy' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1870 AND type_rel = 3
0.0129	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1870 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0133	SELECT /53 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1092528,1062539,1060452,949168,697891) ORDER BY n.cover_points DESC, update_date DESC
0.0143	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 = 50480 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1870 AND group_code = 1 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0161	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50480 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44710 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38990 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 34032 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 03:44:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 03:44:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 03:44:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 03:44:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_trophy' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1870 AND l.year = 2020
0.0136	SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50480,51796) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0134	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (50480,51796) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (84553,366112,244085,427483,30136,47418,59434,112581,117579,205903) ORDER BY rp.in_squad = 1 DESC
0.0133	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1870 AND l.year = 2020
0.0158	SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50480,51796) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0163	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (50480,51796) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (345942,209911,288975,307221,13143,142008,189398,191339,204737,206387) ORDER BY rp.in_squad = 1 DESC
0.0133	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1870 AND l.year = 2020
0.0134	SELECT e.action, count(e.action) as total, e.player_id FROM events2020 e WHERE e.league_id IN (50480,51796) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0141	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (50480,51796) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (13143,44117,65712,67108,160348,206156,206950,209911,216486,244116) ORDER BY rp.in_squad = 1 DESC
0.0277	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50480 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC