« Temporada Anterior
Temporada 1996
Temporada Siguiente »
Publicidad 600x120.gif
Premier League 1996
1995/1996

Premier League 1996

  • Manchester United
  • Newcastle
  • Liverpool
  • Aston Villa
  • Arsenal
  • Everton
  • Blackburn Rovers
  • Tottenham Hotspur
  • Nottingham Forest
  • West Ham
  • Chelsea
  • Middlesbrough
  • Leeds United
  • Wimbledon FC
  • Sheffield Wednesday
  • Coventry City
  • Southampton
  • Manchester City
  • Queens Park Rangers
  • Bolton Wanderers

Premier League 1996

La temporada finalizó el Domingo, 05 Mayo 1996.
Resultados
« Jornada Anterior
Jornada 38
 
 
05 May 96
Finalizado 		Everton Everton 1-0 Aston Villa Aston Villa más información Jugadas destacadas ...
78' Joseph Parkinson 1-0
 
05 May 96
Finalizado 		Chelsea Chelsea 2-3 Blackburn Rovers Blackburn Rovers más información Jugadas destacadas ...
34' D. Wise 1-0
1-1 36' Tim Sherwood
1-2 47' B. Mckinlay
1-3 59' Fenton
88' J. Spencer 2-3
 
05 May 96
Finalizado 		Arsenal Arsenal 2-1 Bolton Wanderers Bolton Wanderers más información Jugadas destacadas ...
0-1 76' Andy Todd
82' David Platt 1-1
84' D. Bergkamp 2-1
 
05 May 96
Finalizado 		Coventry City Coventry City 0-0 Leeds United Leeds United más información ...
 
05 May 96
Finalizado 		Manchester City Manchester City 2-2 Liverpool Liverpool más información Jugadas destacadas ...
6' Steve Lomas
1-1 41' Ian Rush
71' Rösler 2-1
78' K. Symons 3-1
 
05 May 96
Finalizado 		Middlesbrough Middlesbrough 0-3 Manchester United Manchester United más información Jugadas destacadas ...
0-1 13' David May
0-2 53' Andy Cole
0-3 80' R. Giggs
 
05 May 96
Finalizado 		Nottingham Forest Nottingham Forest 3-0 Queens Park Rangers Queens Park Rangers más información Jugadas destacadas ...
44' Steve Stone 1-0
63' Bryan Roy 2-0
77' Bobby Howe 3-0
 
05 May 96
Finalizado 		West Ham West Ham 1-1 Sheffield Wednesday Sheffield Wednesday más información Jugadas destacadas ...
72' Julian Dicks 1-0
1-1 89' Jonathan Newsome
 
05 May 96
Finalizado 		Newcastle Newcastle 1-1 Tottenham Hotspur Tottenham Hotspur más información Jugadas destacadas ...
0-1 57' Dozzell
71' Les Ferdinand 1-1
 
05 May 96
Finalizado 		Southampton Southampton 0-0 Wimbledon FC Wimbledon FC más información ...
Clasificación
« Jornada Anterior
Jornada 38
 
Equipos Puntos J. G. E. P. F. C. Forma
1 Manchester United Manchester 82 38 25 7 6 73 35
  • VICTORIA
  • Manchester City 2
  • Manchester United 3
  • VICTORIA
  • Manchester United 1
  • Coventry City 0
  • DERROTA
  • Southampton 3
  • Manchester United 1
  • VICTORIA
  • Manchester United 5
  • Nottingham Forest 0
  • VICTORIA
  • Middlesbrough 0
  • Manchester United 3
2 Newcastle Newcastle 78 38 24 6 8 66 37
  • VICTORIA
  • Newcastle 2
  • Queens Park Ranger. 1
  • DERROTA
  • Blackburn Rovers 2
  • Newcastle 1
  • VICTORIA
  • Newcastle 1
  • Aston Villa 0
  • VICTORIA
  • Leeds United 0
  • Newcastle 1
  • EMPATE
  • Newcastle 1
  • Tottenham Hotspur 1
3 Liverpool Liverpool 71 38 20 11 7 70 34
  • DERROTA
  • Coventry City 1
  • Liverpool 0
  • VICTORIA
  • Liverpool 2
  • West Ham 0
  • EMPATE
  • Everton 1
  • Liverpool 1
  • VICTORIA
  • Liverpool 1
  • Middlesbrough 0
  • EMPATE
  • Manchester City 2
  • Liverpool 2
4 Aston Villa Aston Villa 63 38 18 9 11 52 35
  • VICTORIA
  • Chelsea 1
  • Aston Villa 2
  • VICTORIA
  • Aston Villa 3
  • Southampton 0
  • DERROTA
  • Newcastle 1
  • Aston Villa 0
  • DERROTA
  • Aston Villa 0
  • Manchester City 1
  • DERROTA
  • Everton 1
  • Aston Villa 0
5 Arsenal Arsenal 63 38 17 12 9 49 32
  • VICTORIA
  • Arsenal 2
  • Leeds United 1
  • DERROTA
  • Sheffield Wednesda. 1
  • Arsenal 0
  • EMPATE
  • Arsenal 0
  • Tottenham Hotspur 0
  • EMPATE
  • Blackburn Rovers 1
  • Arsenal 1
  • VICTORIA
  • Arsenal 2
  • Bolton Wanderers 1
6 Everton Everton 61 38 17 10 11 64 44
  • VICTORIA
  • Everton 3
  • Bolton Wanderers 0
  • DERROTA
  • Queens Park Ranger. 3
  • Everton 1
  • EMPATE
  • Everton 1
  • Liverpool 1
  • VICTORIA
  • Sheffield Wednesda. 2
  • Everton 5
  • VICTORIA
  • Everton 1
  • Aston Villa 0
7 Blackburn Rovers Blackburn Rovers 61 38 18 7 13 61 47
  • DERROTA
  • Southampton 1
  • Blackburn Rovers 0
  • VICTORIA
  • Blackburn Rovers 2
  • Newcastle 1
  • VICTORIA
  • Nottingham Forest 1
  • Blackburn Rovers 5
  • EMPATE
  • Blackburn Rovers 1
  • Arsenal 1
  • VICTORIA
  • Chelsea 2
  • Blackburn Rovers 3
8 Tottenham Hotspur Tottenham 61 38 16 13 9 50 38
  • DERROTA
  • Nottingham Forest 2
  • Tottenham Hotspur 1
  • EMPATE
  • Tottenham Hotspur 1
  • Middlesbrough 1
  • EMPATE
  • Arsenal 0
  • Tottenham Hotspur 0
  • EMPATE
  • Tottenham Hotspur 1
  • Chelsea 1
  • EMPATE
  • Newcastle 1
  • Tottenham Hotspur 1
9 Nottingham Forest Nottingham 58 38 15 13 10 50 54
  • VICTORIA
  • Nottingham Forest 2
  • Tottenham Hotspur 1
  • VICTORIA
  • Leeds United 1
  • Nottingham Forest 3
  • DERROTA
  • Nottingham Forest 1
  • Blackburn Rovers 5
  • DERROTA
  • Manchester United 5
  • Nottingham Forest 0
  • VICTORIA
  • Nottingham Forest 3
  • Queens Park Ranger. 0
10 West Ham West Ham 51 38 14 9 15 43 52
  • EMPATE
  • West Ham 1
  • Wimbledon FC 1
  • DERROTA
  • Liverpool 2
  • West Ham 0
  • VICTORIA
  • West Ham 1
  • Bolton Wanderers 0
  • DERROTA
  • Queens Park Ranger. 3
  • West Ham 0
  • EMPATE
  • West Ham 1
  • Sheffield Wednesda. 1
11 Chelsea Chelsea 50 38 12 14 12 46 44
  • DERROTA
  • Chelsea 1
  • Aston Villa 2
  • DERROTA
  • Bolton Wanderers 2
  • Chelsea 1
  • VICTORIA
  • Chelsea 4
  • Leeds United 1
  • EMPATE
  • Tottenham Hotspur 1
  • Chelsea 1
  • DERROTA
  • Chelsea 2
  • Blackburn Rovers 3
12 Middlesbrough Middlesbrough 43 38 11 10 17 35 50
  • VICTORIA
  • Middlesbrough 3
  • Sheffield Wednesda. 1
  • EMPATE
  • Tottenham Hotspur 1
  • Middlesbrough 1
  • DERROTA
  • Middlesbrough 1
  • Wimbledon FC 2
  • DERROTA
  • Liverpool 1
  • Middlesbrough 0
  • DERROTA
  • Middlesbrough 0
  • Manchester United 3
13 Leeds United Leeds United 43 38 12 7 19 40 57
  • DERROTA
  • Arsenal 2
  • Leeds United 1
  • DERROTA
  • Leeds United 1
  • Nottingham Forest 3
  • DERROTA
  • Chelsea 4
  • Leeds United 1
  • DERROTA
  • Leeds United 0
  • Newcastle 1
  • EMPATE
  • Coventry City 0
  • Leeds United 0
14 Wimbledon FC Wimbledon FC 41 38 10 11 17 55 70
  • EMPATE
  • West Ham 1
  • Wimbledon FC 1
  • VICTORIA
  • Wimbledon FC 3
  • Manchester City 0
  • VICTORIA
  • Middlesbrough 1
  • Wimbledon FC 2
  • DERROTA
  • Wimbledon FC 0
  • Coventry City 2
  • EMPATE
  • Southampton 0
  • Wimbledon FC 0
15 Sheffield Wednesday Sheffield 40 38 10 10 18 48 61
  • DERROTA
  • Middlesbrough 3
  • Sheffield Wednesda. 1
  • VICTORIA
  • Sheffield Wednesda. 1
  • Arsenal 0
  • DERROTA
  • Manchester City 1
  • Sheffield Wednesda. 0
  • DERROTA
  • Sheffield Wednesda. 2
  • Everton 5
  • EMPATE
  • West Ham 1
  • Sheffield Wednesda. 1
16 Coventry City Coventry City 38 38 8 14 16 42 60
  • VICTORIA
  • Coventry City 1
  • Liverpool 0
  • DERROTA
  • Manchester United 1
  • Coventry City 0
  • VICTORIA
  • Coventry City 1
  • Queens Park Ranger. 0
  • VICTORIA
  • Wimbledon FC 0
  • Coventry City 2
  • EMPATE
  • Coventry City 0
  • Leeds United 0
17 Southampton Southampton 38 38 9 11 18 34 52
  • VICTORIA
  • Southampton 1
  • Blackburn Rovers 0
  • DERROTA
  • Aston Villa 3
  • Southampton 0
  • VICTORIA
  • Southampton 3
  • Manchester United 1
  • VICTORIA
  • Bolton Wanderers 0
  • Southampton 1
  • EMPATE
  • Southampton 0
  • Wimbledon FC 0
18 Manchester City Manchester City 38 38 9 11 18 33 58
  • DERROTA
  • Manchester City 2
  • Manchester United 3
  • DERROTA
  • Wimbledon FC 3
  • Manchester City 0
  • VICTORIA
  • Manchester City 1
  • Sheffield Wednesda. 0
  • VICTORIA
  • Aston Villa 0
  • Manchester City 1
  • EMPATE
  • Manchester City 2
  • Liverpool 2
19 Queens Park Rangers Queens Park Ran. 33 38 9 6 23 38 57
  • DERROTA
  • Newcastle 2
  • Queens Park Ranger. 1
  • VICTORIA
  • Queens Park Ranger. 3
  • Everton 1
  • DERROTA
  • Coventry City 1
  • Queens Park Ranger. 0
  • VICTORIA
  • Queens Park Ranger. 3
  • West Ham 0
  • DERROTA
  • Nottingham Forest 3
  • Queens Park Ranger. 0
20 Bolton Wanderers Bolton Wanderers 29 38 8 5 25 39 71
  • DERROTA
  • Everton 3
  • Bolton Wanderers 0
  • VICTORIA
  • Bolton Wanderers 2
  • Chelsea 1
  • DERROTA
  • West Ham 1
  • Bolton Wanderers 0
  • DERROTA
  • Bolton Wanderers 0
  • Southampton 1
  • DERROTA
  • Arsenal 2
  • Bolton Wanderers 1
Champions League : Manchester
UEFA : Newcastle, Aston Villa, Arsenal
Recopa : Liverpool
Descenso : Manchester City, Queens Park Ran., Bolton Wanderers
JUGADORES DESTACADOS

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
Lorenzo
7 pts
Víctor HS
Víctor HS
1 pts
Xerome Fernández Álvarez
Xerome Fernández Álvarez
1 pts
Más colaboradores en esta liga (9)
¿Quieres ser colaborador? haz click aquí

Reglas de la competició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,294,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.5670
Total Execution Time  0.5692
  CADENA URL  
/premier1996
  GET DATOS  
$_GET['/premier1996']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0105  SELECT type FROM routes WHERE alias = 'premier1996'
0.0213  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 = 1996 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0108  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 = 335 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 10:50:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-20 10:50:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-20 10:50:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-20 10:50:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  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 = 1996 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0143  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (335) 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.0111  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 (335) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (265441,9464,9760,484,9489,265149,265729,265859,10128,258216,266083,265885,7546,265879,266098,9461,9612,27147,265812,453) ORDER BY rp.in_squad = 1 DESC
0.0156  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (335) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0114  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 (335) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (257149,265617,12803,103199,265774,434701,10567,10655,10789,265150,265488,265524,265753,265965,266112,266170,266173,266217,266233,382525) ORDER BY rp.in_squad = 1 DESC
0.0315  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (335) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0128  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 (335) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (265440,265965,293,9382,9408,10025,10046,10083,10655,10712,12803,103199,257149,259052,265150,265455,265524,265537,265547,265600) ORDER BY rp.in_squad = 1 DESC
0.0311  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (335) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  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 (335) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (9461,12819,265980,9760,27147,72555,258022,258216,265131,265452,265553,265608,265858,265873,265950,265970,266015) ORDER BY rp.in_squad = 1 DESC
0.0126  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 = 335 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0126  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 = 335 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0115  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=335 AND rel.round=38
0.0110  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 = 335 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0112  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 = 335 AND esl.points > 0
0.0106  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-21" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 335 ORDER BY creation_date DESC LIMIT 0, 10
0.0114  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-21" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 335
0.0131  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 `calendars1996` 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` = 335 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0325  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 events1996 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1996 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 335 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 (10843,10844,10845,10846,10847,10848,10849,10850,10851,10852) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0115  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 `events1996` e INNER JOIN calendars1996 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 = 38 AND e.real_date IS NOT NULL AND e.league_id = 335 ORDER BY total DESC LIMIT 40
0.0117  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 `events1996` e INNER JOIN calendars1996 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 = 335 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0127  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 `tables1996` 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 = 335 AND t.round = 37 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1996` 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 = 335 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT distinct(shedule), round FROM `calendars1996` as c WHERE c.`league_id` = 335 AND shedule >= '1996/05/01' AND shedule < '1996/06/01' ORDER BY shedule ASC
0.0105  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-20 00:00:00' AND c.`shedule` < '2024-04-24 23:59:59' AND l.id = 335 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0108  SELECT data1, data2 FROM services_tags WHERE categoryId=10
0.0108  SELECT group_code, extraName from `leagues` WHERE categoryId=10 AND year=1996