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

Resultados de Fútbol

« Temporada Anterior

Temporada 1995

Temporada Siguiente »

1994/1995

Premier League 1995

Premier League

Premier League 1995

La temporada finalizó el Domingo, 14 Mayo 1995.

19 Nov 94 Finalizado	Southampton	Southampton - Arsenal 1994-11-19T00:00:00 St. Mary's Stadium 1-0	Arsenal	más información Jugadas destacadas ...
	60' Jim Magilton	1-0
19 Nov 94 Finalizado	Coventry City	Coventry City - Norwich City 1994-11-19T00:00:00 City of Coventry Stadium 1-0	Norwich City	más información Jugadas destacadas ...
	62' C. Jones	1-0
19 Nov 94 Finalizado	Manchester United	Manchester United - Crystal Palace 1994-11-19T00:00:00 Old Trafford 3-0	Crystal Palace	más información Jugadas destacadas ...
	8' Denis Irwin	1-0
	34' E. Cantona	2-0
	50' A. Kanchelskis	3-0
19 Nov 94 Finalizado	Nottingham Forest	Nottingham Forest - Chelsea 1994-11-19T00:00:00 The City Ground 0-1	Chelsea	más información Jugadas destacadas ...
		0-1	28' J. Spencer
19 Nov 94 Finalizado	Queens Park Rangers	Queens Park Rangers - Leeds United 1994-11-19T00:00:00 Loftus Road 3-2	Leeds United	más información Jugadas destacadas ...
	30' Les Ferdinand	1-0
	39' Les Ferdinand	2-0
	55' A. Mcdonald
	67' Kevin Gallen	4-0
		4-1	72' Brian Deane
19 Nov 94 Finalizado	Sheffield Wednesday	Sheffield Wednesday - West Ham 1994-11-19T00:00:00 Hillsborough Stadium 1-0	West Ham	más información Jugadas destacadas ...
	28' D. Petrescu	1-0
19 Nov 94 Finalizado	Wimbledon FC	Wimbledon FC - Newcastle 1994-11-19T00:00:00 No disponible 3-2	Newcastle	más información Jugadas destacadas ...
	1' Andy Clarke	1-0
	27' Efan Ekoku	2-0
		2-1	30' P. Beardsley
		2-2	32' Kitson
	36' Mick Harford	3-2
	90' Vinnie Jones
19 Nov 94 Finalizado	Ipswich Town	Ipswich Town - Blackburn Rovers 1994-11-19T00:00:00 Portman Road Stadium 1-3	Blackburn Rovers	más información Jugadas destacadas ...
		0-1	8' Chris Sutton
	28' Claus Thomsen	1-1
		1-2	41' Tim Sherwood
		1-3	70' A. Shearer
19 Nov 94 Finalizado	Tottenham Hotspur	Tottenham Hotspur - Aston Villa 1994-11-19T00:00:00 Tottenham Hotspur Stadium 3-4	Aston Villa	más información Jugadas destacadas ...
		0-1	8' Atkinson
		0-2	21' Fenton
		0-3	27' Fenton
	40' Teddy Sheringham	1-3
	53' J. Klinsmann	2-3
	74' J. Klinsmann	3-3
		3-4	90' Dean Saunders
20 Nov 94 Finalizado	Leicester	Leicester - Manchester City 1994-11-20T00:00:00 King Power Stadium 0-1	Manchester City	más información Jugadas destacadas ...
		0-1	16' Niall Quinn
	86' Richard Smith
21 Nov 94 Finalizado	Everton	Everton - Liverpool 1994-11-21T00:00:00 Goodison Park 2-0	Liverpool	más información Jugadas destacadas ...
	56' Duncan Ferguson	1-0
	89' Rideout	2-0

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Manchester	34	15	11	1	3	31	10	VICTORIA Blackburn Rovers 2 Manchester United 4 VICTORIA Manchester United 2 Newcastle 0 VICTORIA Manchester United 5 Manchester City 0 VICTORIA Aston Villa 1 Manchester United 2 VICTORIA Manchester United 3 Crystal Palace 0
2	Blackburn Rovers	33	15	10	3	2	31	13	DERROTA Blackburn Rovers 2 Manchester United 4 VICTORIA Nottingham Forest 0 Blackburn Rovers 2 VICTORIA Sheffield Wednesda. 0 Blackburn Rovers 1 VICTORIA Blackburn Rovers 2 Tottenham Hotspur 0 VICTORIA Ipswich Town 1 Blackburn Rovers 3
3	Newcastle	33	15	10	3	2	33	16	VICTORIA Newcastle 2 Sheffield Wednesda. 1 DERROTA Manchester United 2 Newcastle 0 EMPATE Nottingham Forest 0 Newcastle 0 VICTORIA Newcastle 2 Queens Park Ranger. 1 DERROTA Wimbledon FC 3 Newcastle 2
4	Liverpool	29	15	9	2	4	32	16	VICTORIA Liverpool 3 Wimbledon FC 0 VICTORIA Ipswich Town 1 Liverpool 3 DERROTA Queens Park Ranger. 2 Liverpool 1 VICTORIA Liverpool 1 Nottingham Forest 0 DERROTA Everton 2 Liverpool 0
5	Nottingham	28	15	8	4	3	25	15	VICTORIA Aston Villa 0 Nottingham Forest 2 DERROTA Nottingham Forest 0 Blackburn Rovers 2 EMPATE Nottingham Forest 0 Newcastle 0 DERROTA Liverpool 1 Nottingham Forest 0 DERROTA Nottingham Forest 0 Chelsea 1
6	Chelsea	24	15	7	3	5	25	19	VICTORIA Chelsea 2 Ipswich Town 0 EMPATE Sheffield Wednesda. 1 Chelsea 1 EMPATE Tottenham Hotspur 0 Chelsea 0 EMPATE Chelsea 2 Coventry City 2 VICTORIA Nottingham Forest 0 Chelsea 1
7	Leeds United	24	15	7	3	5	23	19	VICTORIA Leeds United 2 Leicester 1 VICTORIA Southampton 1 Leeds United 3 DERROTA Ipswich Town 2 Leeds United 0 VICTORIA Leeds United 3 Wimbledon FC 1 DERROTA Queens Park Ranger. 3 Leeds United 2
8	Manchester City	22	15	6	4	5	25	25	VICTORIA Manchester City 5 Tottenham Hotspur 2 DERROTA Coventry City 1 Manchester City 0 DERROTA Manchester United 5 Manchester City 0 EMPATE Manchester City 3 Southampton 3 VICTORIA Leicester 0 Manchester City 1
9	Norwich City	21	15	5	6	4	13	13	VICTORIA Norwich City 4 Queens Park Ranger. 2 DERROTA Wimbledon FC 1 Norwich City 0 EMPATE Southampton 1 Norwich City 1 EMPATE Norwich City 0 Everton 0 DERROTA Coventry City 1 Norwich City 0
10	Southampton	20	15	5	5	5	23	26	DERROTA West Ham 2 Southampton 0 DERROTA Southampton 1 Leeds United 3 EMPATE Southampton 1 Norwich City 1 EMPATE Manchester City 3 Southampton 3 VICTORIA Southampton 1 Arsenal 0
11	Arsenal	19	15	5	4	6	18	16	VICTORIA Arsenal 2 Coventry City 1 EMPATE Everton 1 Arsenal 1 DERROTA Leicester 2 Arsenal 1 EMPATE Arsenal 0 Sheffield Wednesda. 0 DERROTA Southampton 1 Arsenal 0
12	Crystal Palace	19	15	5	4	6	15	18	VICTORIA Crystal Palace 1 Everton 0 VICTORIA Leicester 0 Crystal Palace 1 VICTORIA Coventry City 1 Crystal Palace 4 VICTORIA Crystal Palace 3 Ipswich Town 0 DERROTA Manchester United 3 Crystal Palace 0
13	Coventry City	19	15	5	4	6	18	26	DERROTA Arsenal 2 Coventry City 1 VICTORIA Coventry City 1 Manchester City 0 DERROTA Coventry City 1 Crystal Palace 4 EMPATE Chelsea 2 Coventry City 2 VICTORIA Coventry City 1 Norwich City 0
14	Tottenham	18	15	5	3	7	24	30	DERROTA Manchester City 5 Tottenham Hotspur 2 VICTORIA Tottenham Hotspur 3 West Ham 1 EMPATE Tottenham Hotspur 0 Chelsea 0 DERROTA Blackburn Rovers 2 Tottenham Hotspur 0 DERROTA Tottenham Hotspur 3 Aston Villa 4
15	Wimbledon FC	18	15	5	3	7	17	26	DERROTA Liverpool 3 Wimbledon FC 0 VICTORIA Wimbledon FC 1 Norwich City 0 VICTORIA Wimbledon FC 4 Aston Villa 3 DERROTA Leeds United 3 Wimbledon FC 1 VICTORIA Wimbledon FC 3 Newcastle 2
16	Sheffield	17	15	4	5	6	16	22	DERROTA Newcastle 2 Sheffield Wednesda. 1 EMPATE Sheffield Wednesda. 1 Chelsea 1 DERROTA Sheffield Wednesda. 0 Blackburn Rovers 1 EMPATE Arsenal 0 Sheffield Wednesda. 0 VICTORIA Sheffield Wednesda. 1 West Ham 0
17	West Ham	17	15	5	2	8	9	16	VICTORIA West Ham 2 Southampton 0 DERROTA Tottenham Hotspur 3 West Ham 1 DERROTA Everton 1 West Ham 0 VICTORIA West Ham 1 Leicester 0 DERROTA Sheffield Wednesda. 1 West Ham 0
18	Queens Park Ran.	16	15	4	4	7	23	27	DERROTA Norwich City 4 Queens Park Ranger. 2 VICTORIA Queens Park Ranger. 2 Aston Villa 0 VICTORIA Queens Park Ranger. 2 Liverpool 1 DERROTA Newcastle 2 Queens Park Ranger. 1 VICTORIA Queens Park Ranger. 3 Leeds United 2
19	Aston Villa	13	15	3	4	8	19	27	DERROTA Aston Villa 0 Nottingham Forest 2 DERROTA Queens Park Ranger. 2 Aston Villa 0 DERROTA Wimbledon FC 4 Aston Villa 3 DERROTA Aston Villa 1 Manchester United 2 VICTORIA Tottenham Hotspur 3 Aston Villa 4
20	Leicester	12	15	3	3	9	16	27	DERROTA Leeds United 2 Leicester 1 DERROTA Leicester 0 Crystal Palace 1 VICTORIA Leicester 2 Arsenal 1 DERROTA West Ham 1 Leicester 0 DERROTA Leicester 0 Manchester City 1
21	Everton	11	15	2	5	8	11	24	DERROTA Crystal Palace 1 Everton 0 EMPATE Everton 1 Arsenal 1 VICTORIA Everton 1 West Ham 0 EMPATE Norwich City 0 Everton 0 VICTORIA Everton 2 Liverpool 0
22	Ipswich Town	10	15	3	1	11	14	30	DERROTA Chelsea 2 Ipswich Town 0 DERROTA Ipswich Town 1 Liverpool 3 VICTORIA Ipswich Town 2 Leeds United 0 DERROTA Crystal Palace 3 Ipswich Town 0 DERROTA Ipswich Town 1 Blackburn Rovers 3

	Champions League : Manchester
	UEFA : Blackburn Rovers, Newcastle, Liverpool, Nottingham
	Recopa : Wimbledon FC
	Descenso : Aston Villa, Leicester, Everton, Ipswich Town

JUGADORES DESTACADOS

RK	Nombre	Goles	Posición	Equipo
1	A. Shearer	34	DEL	Blackburn Rovers
2	Robbie Fowler	25	DEL	Liverpool
3	Les Ferdinand	24	DEL	Queens Park Rangers
4	S. Collymore	22	DEL	Nottingham Forest
5	Andy Cole	21	DEL	Manchester United
6	J. Klinsmann	21	DEL	Tottenham Hotspur
7	Matthew Le Tissier	19	MED	Southampton
8	Teddy Sheringham	18	DEL	Tottenham Hotspur
9	Ian Wright	18	DEL	Arsenal
10	Chris Sutton	15	DEL	Blackburn Rovers
11	Rösler	15	DEL	Manchester City
12	Dean Saunders	15	DEL	Aston Villa
13	A. Kanchelskis	14	DEL	Manchester United
14	Rideout	14	DEL	Everton
15	Dion Dublin	13	DEL	Coventry City
16	Cottee	13	DEL	West Ham
17	P. Beardsley	13	DEL	Newcastle
18	Bryan Roy	13	DEL	Nottingham Forest
19	Ian Rush	12	DEL	Liverpool
20	E. Cantona	12	DEL	Manchester United

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.

TOP colaboradores para esta liga

Lorenzo

6 pts

Jherson Suárez

3 pts

Víctor HS

1 pts

Más colaboradores en esta liga (9)

¿Quieres ser colaborador? haz click aquí

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.

USO DE MEMORIA

6,334,856 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1804
Total Execution Time	0.1824

CADENA URL

/premier1995/grupo1/jornada15

GET DATOS

$_GET['/premier1995/grupo1/jornada15']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0018	SELECT type FROM routes WHERE alias = 'premier1995'
0.0039	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1995 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020	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 = 336 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:04:07' 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 21:04:07' 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 21:04:07' 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 21:04:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1995 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0088	SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (336) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0029	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 (336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (265441,9464,9760,258216,9461,265147,265617,9489,265859,9493,265597,265722,265149,266080,10128,265702,265974,266100,265975,266083) ORDER BY rp.in_squad = 1 DESC
0.0098	SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (336) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0046	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 (336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (265790,265870,266201,266164,433317,10046,265965,266111,258433,265475,265488,265523,265674,265774,265859,265874,266173,266192,433484,259052) ORDER BY rp.in_squad = 1 DESC
0.0075	SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (336) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0025	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 (336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (9622,264711,265492,265774,265965,93,9439,9760,10642,10789,257149,258025,258433,265446,265487,265537,265548,265559,265597,265600) ORDER BY rp.in_squad = 1 DESC
0.0085	SELECT e.action, count(e.action) as total, e.player_id FROM events1995 e WHERE e.league_id IN (336) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0024	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 (336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0065	SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 336 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0022	SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 336 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
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=336 AND rel.round=15
0.0021	SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA 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 = 336 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0018	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 = 336 AND esl.points > 0
0.0025	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` = 336 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 > "2024-03-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 336
0.0063	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 `calendars1995` 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` = 336 AND c.`round` = 15 ORDER BY shedule ASC LIMIT 200
0.0019	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 events1995 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1995 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 336 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 (7571,7570,7569,7568,7567,7566,7565,7564,7563,7572,7573) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0022	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 `events1995` e INNER JOIN calendars1995 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 = 15 AND e.real_date IS NOT NULL AND e.league_id = 336 ORDER BY total DESC LIMIT 40
0.0048	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 `events1995` e INNER JOIN calendars1995 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 = 336 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0027	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* `tables1995` 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 = 336 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1995` 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 = 336 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018	SELECT distinct(shedule), round FROM `calendars1995` as c WHERE c.`league_id` = 336 AND shedule >= '1994/11/01' AND shedule < '1994/12/01' ORDER BY shedule ASC
0.0022	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 = 336 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022	SELECT data1, data2 FROM services_tags WHERE categoryId=10
0.0022	SELECT group_code, extraName from `leagues` WHERE categoryId=10 AND year=1995

Resultados de Fútbol

Partido televisado en... x

Premier League 1995

Premier League 1995

Busca la liga de tu equipo

NOTICIAS RELACIONADAS

LIGAS RELACIONADAS

Equipos de esta competición

INFORMACIÓN

Reglas de la competición


	¡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	David Burrows	13	DEF	Coventry City
2	Kenneth Monkou	12	DEF	Southampton
3	Andy Pearce	12	DEF	Sheffield Wednesday
4	Steve Bruce	11	DEF	Manchester United
5	Francis Benali	11	DEF	Southampton
6	Frank Sinclair	10	DEF	Chelsea
7	Vinnie Jones	10	MED	Wimbledon FC
8	John Ebbrell	10	MED	Everton
9	Stefan Schwarz	9	MED	Arsenal
10	Brian Deane	9	DEL	Leeds United
11	Tim Sherwood	9	MED	Blackburn Rovers
12	N. Winterburn	9	DEF	Arsenal
13	C. Palmer	9	MED	Leeds United
14	Andy Townsend	9	MED	Aston Villa
15	Ian Wright	9	DEL	Arsenal
16	Tim Breacker	9	DEF	West Ham
17	Simon Barker	9	MED	Queens Park Rangers
18	Martin Allen	9	MED	West Ham
19	David Linighan	9	DEF	Ipswich Town
20	Kevin Richardson	8	MED	Aston Villa

RK	Nombre	Rojas	Posición	Equipo
1	Duncan Ferguson	2	DEL	Everton
2	P. Srnícek	2	POR	Newcastle
3	Jason Wilcox	2	DEL	Blackburn Rovers
4	Andy Townsend	2	MED	Aston Villa
5	Vinnie Jones	2	MED	Wimbledon FC
6	S. Campbell	1	DEF	Tottenham Hotspur
7	Trevor Sinclair	1	MED	Queens Park Rangers
8	Les Ferdinand	1	DEL	Queens Park Rangers
9	Don Hutchison	1	MED	West Ham
10	D. Wise	1	MED	Chelsea
11	Mark Hughes	1	DEL	Manchester United
12	Samways	1	MED	Everton
13	Stefan Schwarz	1	MED	Arsenal
14	A. Johnson	1	MED	Norwich City
15	Martin Keown	1	DEF	Arsenal
16	Henning Berg	1	DEF	Blackburn Rovers
17	Whitlow	1	DEF	Leicester
18	Philip Andrew Babb	1	DEF	Coventry City
19	Rösler	1	DEL	Manchester City
20	Tim Flowers	1	POR	Blackburn Rovers

Resultados de Fútbol

Partido televisado en... x

Premier League 1995

Premier League 1995

Busca la liga de tu equipo

NOTICIAS RELACIONADAS

Otra vez el Onana héroe-villano, otra vez el United mediocre

Los Wolves muerden al Luton y Schlupp salva los muebles en Londres

El Newcastle confirma el descenso del Sheffield

El Lopetegui más cotizado: Milan, United, West Ham...

Ni falta ni amarilla para este pisotón de Paquetá en la cara del árbitro

LIGAS RELACIONADAS

Equipos de esta competición

INFORMACIÓN

Reglas de la competición