Inicio
Perfil
Sitios
- Quinielas
- Twitter
- Grupos
- Blogs
- Canal Fantasy
- API
Mensajes 0
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

Resultados de Fútbol

« Temporada Anterior

Temporada 2024

2023/2024

Premier League

Premier League

0-0 23/09/2023 - 16:00 Crystal - Fulham

Canal	Medio	Idioma	País
DAZN	TV	Castellano

23 Sep 23
16:00 Finalizado

Crystal Palace

0-0

Fulham

más información 441

1-1 23/09/2023 - 16:00 Luton Town - Wolves

Canal	Medio	Idioma	País
DAZN	TV	Castellano

23 Sep 23
16:00 Finalizado

Luton Town

1-1

Wolves

más información Jugadas destacadas 351

39'

J. Bellegarde

0-1

50'

Pedro Neto

65'

Carlton Morris

1-1

2-0 23/09/2023 - 16:00 Manchester - Nottingham

Canal	Medio	Idioma	País
DAZN	TV	Castellano

23 Sep 23
16:00 Finalizado

Manchester City

2-0

Nottingham Forest

más información Jugadas destacadas 507

Phil Foden

1-0

14'

E. Haaland

2-0

46'

Rodri

1-3 23/09/2023 - 18:30 Brentford - Everton

Canal	Medio	Idioma	País
DAZN	TV	Castellano

23 Sep 23
18:30 Finalizado

Brentford

1-3

Everton

más información Jugadas destacadas 268

0-1

A. Doucouré

28'

Mathias Jensen

1-1

1-2

67'

J. Tarkowski

1-3

71'

D. Calvert-Lewin

0-1 23/09/2023 - 21:00 Burnley - Manchester

Canal	Medio	Idioma	País
DAZN	TV	Castellano

23 Sep 23
21:00 Finalizado

Burnley

0-1

Manchester United

más información Jugadas destacadas 612

0-1

45'

Bruno Fernandes

2-2 24/09/2023 - 15:00 Arsenal - Tottenham

Canal	Medio	Idioma	País
DAZN	TV	Castellano

24 Sep 23
15:00 Finalizado

Arsenal

2-2

Tottenham Hotspur

más información Jugadas destacadas 779

26'

Cristian Romero

1-1

42'

Heung-Min Son

54'

Bukayo Saka

2-1

2-2

55'

Heung-Min Son

3-1 24/09/2023 - 15:00 Brighton - Bournemouth

Canal	Medio	Idioma	País
DAZN	TV	Castellano

24 Sep 23
15:00 Finalizado

Brighton & Hove Albion

3-1

AFC Bournemouth

más información Jugadas destacadas 441

0-1

25'

D. Solanke

46'

Kaoru Mitoma

1-1

47'

Milos Kerkez

77'

Kaoru Mitoma

3-1

0-1 24/09/2023 - 15:00 Chelsea - Aston Villa

Canal	Medio	Idioma	País
DAZN	TV	Castellano

24 Sep 23
15:00 Finalizado

Chelsea

0-1

Aston Villa

más información Jugadas destacadas 944

58'

Malo Gusto

0-1

73'

O. Watkins

3-1 24/09/2023 - 15:00 Liverpool - West Ham

Canal	Medio	Idioma	País
DAZN	TV	Castellano

24 Sep 23
15:00 Finalizado

Liverpool

3-1

West Ham

más información Jugadas destacadas 394

16'

M. Salah

1-0

1-1

42'

Jarrod Bowen

60'

Darwin Núñez

2-1

85'

Diogo Jota

3-1

0-8 24/09/2023 - 17:30 Sheffield - Newcastle

Canal	Medio	Idioma	País
DAZN	TV	Castellano

24 Sep 23
17:30 Finalizado

Sheffield United

0-8

Newcastle

más información Jugadas destacadas 427

0-1

21'

S. Longstaff

0-2

31'

Dan Burn

0-3

35'

Sven Botman

0-4

56'

Callum Wilson

0-5

61'

Anthony Gordon

0-6

68'

M. Almirón

0-7

73'

B. Guimarães

0-8

87'

Alexander Isak

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Manchester City	18	6	6	0	0	16	3	VICTORIA Manchester City 1 Newcastle 0 VICTORIA Sheffield United 1 Manchester City 2 VICTORIA Manchester City 5 Fulham 1 VICTORIA West Ham 1 Manchester City 3 VICTORIA Manchester City 2 Nottingham Forest 0
2	Liverpool	16	6	5	1	0	15	5	VICTORIA Liverpool 3 AFC Bournemouth 1 VICTORIA Newcastle 1 Liverpool 2 VICTORIA Liverpool 3 Aston Villa 0 VICTORIA Wolves 1 Liverpool 3 VICTORIA Liverpool 3 West Ham 1
3	Brighton Hove A.	15	6	5	0	1	18	8	VICTORIA Wolves 1 Brighton & Hove Al. 4 DERROTA Brighton & Hove Al. 1 West Ham 3 VICTORIA Brighton & Hove Al. 3 Newcastle 1 VICTORIA Manchester United 1 Brighton & Hove Al. 3 VICTORIA Brighton & Hove Al. 3 AFC Bournemouth 1
4	Tottenham	14	6	4	2	0	15	7	VICTORIA Tottenham Hotspur 2 Manchester United 0 VICTORIA AFC Bournemouth 0 Tottenham Hotspur 2 VICTORIA Burnley 2 Tottenham Hotspur 5 VICTORIA Tottenham Hotspur 2 Sheffield United 1 EMPATE Arsenal 2 Tottenham Hotspur 2
5	Arsenal	14	6	4	2	0	11	6	VICTORIA Crystal Palace 0 Arsenal 1 EMPATE Arsenal 2 Fulham 2 VICTORIA Arsenal 3 Manchester United 1 VICTORIA Everton 0 Arsenal 1 EMPATE Arsenal 2 Tottenham Hotspur 2
6	Aston Villa	12	6	4	0	2	12	10	VICTORIA Aston Villa 4 Everton 0 VICTORIA Burnley 1 Aston Villa 3 DERROTA Liverpool 3 Aston Villa 0 VICTORIA Aston Villa 3 Crystal Palace 1 VICTORIA Chelsea 0 Aston Villa 1
7	West Ham	10	6	3	1	2	11	10	VICTORIA West Ham 3 Chelsea 1 VICTORIA Brighton & Hove Al. 1 West Ham 3 VICTORIA Luton Town 1 West Ham 2 DERROTA West Ham 1 Manchester City 3 DERROTA Liverpool 3 West Ham 1
8	Newcastle	9	6	3	0	3	16	7	DERROTA Manchester City 1 Newcastle 0 DERROTA Newcastle 1 Liverpool 2 DERROTA Brighton & Hove Al. 3 Newcastle 1 VICTORIA Newcastle 1 Brentford 0 VICTORIA Sheffield United 0 Newcastle 8
9	Manchester	9	6	3	0	3	7	10	DERROTA Tottenham Hotspur 2 Manchester United 0 VICTORIA Manchester United 3 Nottingham Forest 2 DERROTA Arsenal 3 Manchester United 1 DERROTA Manchester United 1 Brighton & Hove Al. 3 VICTORIA Burnley 0 Manchester United 1
10	Crystal Palace	8	6	2	2	2	6	7	DERROTA Crystal Palace 0 Arsenal 1 EMPATE Brentford 1 Crystal Palace 1 VICTORIA Crystal Palace 3 Wolves 2 DERROTA Aston Villa 3 Crystal Palace 1 EMPATE Crystal Palace 0 Fulham 0
11	Fulham	8	6	2	2	2	5	10	DERROTA Fulham 0 Brentford 3 EMPATE Arsenal 2 Fulham 2 DERROTA Manchester City 5 Fulham 1 VICTORIA Fulham 1 Luton Town 0 EMPATE Crystal Palace 0 Fulham 0
12	Nottingham	7	6	2	1	3	7	9	VICTORIA Nottingham Forest 2 Sheffield United 1 DERROTA Manchester United 3 Nottingham Forest 2 VICTORIA Chelsea 0 Nottingham Forest 1 EMPATE Nottingham Forest 1 Burnley 1 DERROTA Manchester City 2 Nottingham Forest 0
13	Brentford	6	6	1	3	2	9	9	VICTORIA Fulham 0 Brentford 3 EMPATE Brentford 1 Crystal Palace 1 EMPATE Brentford 2 AFC Bournemouth 2 DERROTA Newcastle 1 Brentford 0 DERROTA Brentford 1 Everton 3
14	Chelsea	5	6	1	2	3	5	6	DERROTA West Ham 3 Chelsea 1 VICTORIA Chelsea 3 Luton Town 0 DERROTA Chelsea 0 Nottingham Forest 1 EMPATE AFC Bournemouth 0 Chelsea 0 DERROTA Chelsea 0 Aston Villa 1
15	Everton	4	6	1	1	4	5	10	DERROTA Aston Villa 4 Everton 0 DERROTA Everton 0 Wolves 1 EMPATE Sheffield United 2 Everton 2 DERROTA Everton 0 Arsenal 1 VICTORIA Brentford 1 Everton 3
16	Wolves	4	6	1	1	4	6	12	DERROTA Wolves 1 Brighton & Hove Al. 4 VICTORIA Everton 0 Wolves 1 DERROTA Crystal Palace 3 Wolves 2 DERROTA Wolves 1 Liverpool 3 EMPATE Luton Town 1 Wolves 1
17	AFC Bournemouth	3	6	0	3	3	5	11	DERROTA Liverpool 3 AFC Bournemouth 1 DERROTA AFC Bournemouth 0 Tottenham Hotspur 2 EMPATE Brentford 2 AFC Bournemouth 2 EMPATE AFC Bournemouth 0 Chelsea 0 DERROTA Brighton & Hove Al. 3 AFC Bournemouth 1
18	Luton Town	1	5	0	1	4	3	11	DERROTA Brighton & Hove Al. 4 Luton Town 1 DERROTA Chelsea 3 Luton Town 0 DERROTA Luton Town 1 West Ham 2 DERROTA Fulham 1 Luton Town 0 EMPATE Luton Town 1 Wolves 1
19	Burnley	1	5	0	1	4	4	13	DERROTA Burnley 0 Manchester City 3 DERROTA Burnley 1 Aston Villa 3 DERROTA Burnley 2 Tottenham Hotspur 5 EMPATE Nottingham Forest 1 Burnley 1 DERROTA Burnley 0 Manchester United 1
20	Sheffield United	1	6	0	1	5	5	17	DERROTA Nottingham Forest 2 Sheffield United 1 DERROTA Sheffield United 1 Manchester City 2 EMPATE Sheffield United 2 Everton 2 DERROTA Tottenham Hotspur 2 Sheffield United 1 DERROTA Sheffield United 0 Newcastle 8

	Campeón : Manchester City
	Champions League : Liverpool, Brighton Hove A., Tottenham
	Europa League : Arsenal
	Descenso : Luton Town, Burnley, Sheffield United

JUGADORES DESTACADOS

RK	Nombre	Goles	Posición	Equipo
1	E. Haaland	8	DEL	Manchester City
2	Heung-Min Son	5	DEL	Tottenham Hotspur
3	Callum Wilson	4	DEL	Newcastle
4	O. Edouard	4	DEL	Crystal Palace
5	Jarrod Bowen	4	DEL	West Ham
6	Bryan Mbeumo	4	DEL	Brentford
7	Evan Ferguson	4	DEL	Brighton & Hove Albi.
8	M. Salah	3	DEL	Liverpool
9	T. Awoniyi	3	DEL	Nottingham Forest
10	D. Solanke	3	DEL	AFC Bournemouth
11	Solly March	3	DEL	Brighton & Hove Albi.
12	Hee-Chan Hwang	3	DEL	Wolves
13	Alexander Isak	3	DEL	Newcastle
14	Kaoru Mitoma	3	DEL	Brighton & Hove Albi.
15	Darwin Núñez	3	DEL	Liverpool
16	Bukayo Saka	3	DEL	Arsenal
17	Pascal Groß	2	MED	Brighton & Hove Albi.
18	M. Antonio	2	DEL	West Ham
19	R. Sterling	2	DEL	Chelsea
20	J. Ward-Prowse	2	MED	West Ham

Busca la liga de tu equipo

Introduce el nombre de tu equipo y busca rápidamente su competición

NOTICIAS RELACIONADAS

Ver más noticias de la competicion»

Equipos de esta competición

INFORMACIÓN

La Premier League (por motivos de patrocinio Barclays Premier League), es la máxima categoría de la liga de clubes de fútbol de Inglaterra.

La Premier League fue fundada en 1992 por la Football League First Division (hasta entonces la máxima categoría de la liga inglesa) de separarse de la Football League para tomar ventaja de un lucrativo trato de derechos de televisión.

Reglas de la competición

Clasificación

Si dos o más equipos tienen los mismos puntos en la clasificación, se ordenarán según su gol average, en orden descendente.
Si dos o más equipos continuan en situación de empate (tanto en puntos como en Gol average) se ordenarán según los goles marcados, siendo el equipo con el mayor número de goles marcados el primero y el equipo con menor número el último.
Si dos o más equipos mantienen todavía una situación de empate (contando puntos, goal average y goles marcados) estarán compartiendo la misma posición en la tabla durante esa jornada.

Premier League

Aston Villa vs Brighton & Hove Albion 30 Sep 23 13:30

Villa Park

Wolves vs Man. City 30 Sep 23 16:00

Molineux Stadium

Man. Utd vs Crystal Palace 30 Sep 23 16:00

Old Trafford

AFC Bournemouth vs Arsenal 30 Sep 23 16:00

Vitality Stadium

West Ham vs Sheffield United 30 Sep 23 16:00

London Stadium

USO DE MEMORIA

6,913,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1094
Total Execution Time	0.1114

CADENA URL

/premier/grupo1/jornada6

GET DATOS

$_GET['/premier/grupo1/jornada6']

POST DATOS

No hay datos POST existentes

CONSULTAS (21)

0.0025	SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=10 ORDER BY l.group_code ASC
0.0019	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2023-09-26 23:38:14' 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 > '2023-09-26 23:38:14' 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 > '2023-09-26 23:38:14' 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 > '2023-09-26 23:38:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026	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=71849 AND rel.round=6
0.0017	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 > "2023-08-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 71849 ORDER BY creation_date DESC LIMIT 0, 10
0.0028	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 > "2023-08-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 71849
0.0038	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 `calendars2024` 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` = 71849 AND c.`round` = 6 ORDER BY shedule ASC LIMIT 200
0.0053	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 events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 71849 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 (12673,12675,12676,12669,12671,12668,12670,12672,12674,12677) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0024	SELECT 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 `events2024` e INNER JOIN calendars2024 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.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 71849 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0052	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* `tables2024` 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 = 71849 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2024` 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 = 71849 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039	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` > '2023-09-27 00:00:00' AND c.`shedule` < '2023-10-01 23:59:59' AND l.id = 71849 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0030	SELECT c., c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM* calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 12678
0.0031	SELECT c., c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM* calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 12687
0.0032	SELECT c., c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM* calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 12682
0.0030	SELECT c., c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM* calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 12679
0.0018	SELECT c., c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM* calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 12686
0.0020	SELECT data1, data2 FROM services_tags WHERE categoryId=10
0.0020	SELECT group_code, extraName from `leagues` WHERE categoryId=10 AND year=2024


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra:


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

RK	Nombre	Amarillas	Posición	Equipo
1	N. Jackson	5	DEL	Chelsea
2	Anthony Gordon	4	DEL	Newcastle
3	Tim Ream	3	DEF	Fulham
4	Lucas Digne	3	DEF	Aston Villa
5	Emerson	3	DEF	West Ham
6	Mario Lemina	3	MED	Wolves
7	Bruno Fernandes	3	MED	Manchester United
8	Nélson Semedo	3	DEF	Wolves
9	Ola Aina	3	DEF	Nottingham Forest
10	Orel Mangala	3	MED	Nottingham Forest
11	Ben Chilwell	3	DEF	Chelsea
12	Y. Bissouma	3	MED	Tottenham Hotspur
13	L. Paquetá	3	MED	West Ham
14	A. Ahmedhodžić	3	DEF	Sheffield United
15	Douglas Luiz	3	MED	Aston Villa
16	Edson Álvarez	3	MED	West Ham
17	B. Guimarães	3	MED	Newcastle
18	Aaron Hickey	3	DEF	Brentford
19	J. Branthwaite	3	DEF	Everton
20	João Gomes	3	MED	Wolves

RK	Nombre	Rojas	Posición	Equipo
1	Tim Ream	1	DEF	Fulham
2	V. Van Dijk	1	DEF	Liverpool
3	Rodri	1	MED	Manchester City
4	Oliver Mcburnie	1	DEL	Sheffield United
5	T. Tomiyasu	1	DEF	Arsenal
6	Joe Worrall	1	DEF	Nottingham Forest
7	Nayef Aguerd	1	DEF	West Ham
8	J. Bellegarde	1	MED	Wolves
9	C. Bassey	1	DEF	Fulham
10	A. Mac Allister	1	MED	Liverpool
11	A. Zaroury	1	DEL	Burnley
12	L. Foster	1	DEL	Burnley
13	Matheus Nunes	1	MED	Manchester City
14	Malo Gusto	1	DEF	Chelsea

RK	Nombre	Asistencias	Posición	Equipo
1	M. Salah	4	DEL	Liverpool
2	J. Maddison	4	MED	Tottenham Hotspur
3	Pedro Neto	4	DEL	Wolves
4	K. Trippier	3	DEF	Newcastle
5	J. Ward-Prowse	3	MED	West Ham
6	P. Estupiñán	3	DEF	Brighton & Hove Albi.
7	Jean Mateta	3	DEL	Crystal Palace
8	Kaoru Mitoma	3	DEL	Brighton & Hove Albi.
9	Julián Álvarez	3	DEL	Manchester City
10	Jordan Ayew	2	DEL	Crystal Palace
11	Lucas Digne	2	DEF	Aston Villa
12	Serge Aurier	2	DEF	Nottingham Forest
13	V. Coufal	2	DEF	West Ham
14	T. Awoniyi	2	DEL	Nottingham Forest
15	O. Watkins	2	DEL	Aston Villa
16	M. Solomon	2	DEL	Tottenham Hotspur
17	M. Diaby	2	DEL	Aston Villa
18	Phil Foden	2	DEL	Manchester City
19	Tariq Lamptey	2	DEF	Brighton & Hove Albi.
20	Anthony Gordon	2	DEL	Newcastle


	Partido televisado en... x

Resultados de Fútbol

Partido televisado en... x

Premier League

Busca la liga de tu equipo

Los recién ascendidos naufragan en la Premier

El dato de Haaland que ridiculiza al Chelsea

Los seguidores del United contrataron una avioneta para protestar contra los Glazer

"Quizás exageré un poco al decir que Matheus Nunes era uno de los mejores del mundo"

El United destierra a Sancho: ¡no le deja ni entrar en el comedor!