Publicidad 600x120.gif
Premier League 1959
  • Wolves
  • Manchester United
  • Arsenal
  • Bolton Wanderers
  • West Bromwich Albion
  • West Ham
  • Burnley
  • Blackpool
  • Birmingham City
  • Blackburn Rovers
  • Newcastle
  • Preston North End
  • Nottingham Forest
  • Chelsea
  • Leeds United
  • Everton
  • Luton Town
  • Tottenham Hotspur
  • Leicester
  • Manchester City
  • Aston Villa
  • Portsmouth

Premier League 1959

La temporada finalizó el Lunes, 04 Mayo 1959.
 
25 Abr 59
Finalizado
Leeds United Leeds United 1-0 West Ham West Ham más información Jugadas destacadas ...
90' Alan Shackleton 1-0
 
25 Abr 59
Finalizado
Everton Everton 0-1 Wolves Wolves más información Jugadas destacadas ...
0-1 90' Jimmy Murray
 
25 Abr 59
Finalizado
Luton Town Luton Town 1-1 Blackpool Blackpool más información Jugadas destacadas ...
90' Gordon Turner 1-0
1-1 90' Ewan Fenton
 
25 Abr 59
Finalizado
Preston North End Preston North End 2-2 Tottenham Hotspur Tottenham Hotspur más información Jugadas destacadas ...
90' Tommy Thompson 1-0
90' Jim Smith 2-0
2-1 90' John Brooks
2-2 90' Bobby Smith
 
25 Abr 59
Finalizado
Burnley Burnley 2-2 Newcastle Newcastle más información Jugadas destacadas ...
90' Brian Pilkington 1-0
90' Albert Cheesebrough 2-0
2-1 90' I. Allchurch
2-2 90' Bill Curry
 
25 Abr 59
Finalizado
West Bromwich Albion West Bromwich Albion 2-0 Nottingham Forest Nottingham Forest más información Jugadas destacadas ...
90' Ronnie Allen 1-0
90' Jimmy Campbell 2-0
 
25 Abr 59
Finalizado
Bolton Wanderers Bolton Wanderers 3-1 Blackburn Rovers Blackburn Rovers más información Jugadas destacadas ...
0-1 90' Peter Dobing
90' Ray Parry 1-1
90' Ray Parry 2-1
90' N. Lofthouse 3-1
 
25 Abr 59
Finalizado
Arsenal Arsenal 5-2 Portsmouth Portsmouth más información Jugadas destacadas ...
0-1 45' J. Dickinson
45' Vic Groves 1-1
45' Jackie Henderson 2-1
45' Vic Groves 3-1
90' Phil Gunter
4-2 90' Ron Saunders
90' Vic Groves 5-2
 
25 Abr 59
Finalizado
Birmingham City Birmingham City 4-1 Chelsea Chelsea más información Jugadas destacadas ...
90' Harry Hooper 1-0
90' Johnny Gordon 2-0
90' Johnny Gordon 3-0
3-1 90' Ron Tindall
90' Brian Taylor 4-1
 
29 Abr 59
Finalizado
West Bromwich Albion West Bromwich Albion 1-1 Aston Villa Aston Villa más información Jugadas destacadas ...
0-1 90' G. Hitchens
90' Ronnie Allen 1-1
 
29 Abr 59
Finalizado
Manchester City Manchester City 3-1 Leicester Leicester más información Jugadas destacadas ...
90' Joe Hayes 1-0
1-1 90' Jimmy Walsh
90' Ray Sambrook 2-1
90' Billy Mcadams 3-1
 
29 Abr 59
Finalizado
Newcastle Newcastle 1-1 Birmingham City Birmingham City más información Jugadas destacadas ...
0-1 90' Harry Hooper
90' I. Allchurch 1-1
 
04 May 59
Finalizado
Arsenal Arsenal 2-1 Birmingham City Birmingham City más información Jugadas destacadas ...
45' Vic Groves 1-0
45' Danny Clapton 2-0
2-1 90' Robin Stubbs
Equipos Puntos J. G. E. P. F. C. Forma
1 Wolves Wolves 61 42 28 5 9 110 49
  • EMPATE
  • Bolton Wanderers 2
  • Wolves 2
  • VICTORIA
  • Blackpool 0
  • Wolves 1
  • VICTORIA
  • Wolves 5
  • Luton Town 0
  • VICTORIA
  • Wolves 3
  • Leicester 0
  • VICTORIA
  • Everton 0
  • Wolves 1
2 Manchester United Manchester 55 42 24 7 11 103 66
  • VICTORIA
  • Manchester United 3
  • Bolton Wanderers 0
  • EMPATE
  • Luton Town 0
  • Manchester United 0
  • VICTORIA
  • Portsmouth 1
  • Manchester United 3
  • VICTORIA
  • Manchester United 1
  • Birmingham City 0
  • DERROTA
  • Leicester 2
  • Manchester United 1
3 Arsenal Arsenal 50 42 21 8 13 88 68
  • EMPATE
  • Arsenal 1
  • Chelsea 1
  • DERROTA
  • Birmingham City 4
  • Arsenal 1
  • VICTORIA
  • Blackpool 1
  • Arsenal 2
  • VICTORIA
  • Arsenal 5
  • Portsmouth 2
  • VICTORIA
  • Arsenal 2
  • Birmingham City 1
4 Bolton Wanderers Bolton Wanderers 50 42 20 10 12 79 66
  • EMPATE
  • Bolton Wanderers 2
  • Wolves 2
  • VICTORIA
  • Burnley 0
  • Bolton Wanderers 1
  • VICTORIA
  • Portsmouth 0
  • Bolton Wanderers 1
  • DERROTA
  • Newcastle 2
  • Bolton Wanderers 0
  • VICTORIA
  • Bolton Wanderers 3
  • Blackburn Rovers 1
5 West Bromwich Albion West Bromwich A. 49 42 18 13 11 88 68
  • VICTORIA
  • West Bromwich Albi. 2
  • Luton Town 0
  • DERROTA
  • Tottenham Hotspur 5
  • West Bromwich Albi. 0
  • VICTORIA
  • Chelsea 0
  • West Bromwich Albi. 2
  • VICTORIA
  • West Bromwich Albi. 2
  • Nottingham Forest 0
  • EMPATE
  • West Bromwich Albi. 1
  • Aston Villa 1
6 West Ham West Ham 48 42 21 6 15 85 70
  • EMPATE
  • West Ham 0
  • Luton Town 0
  • EMPATE
  • Leicester 1
  • West Ham 1
  • EMPATE
  • West Ham 1
  • Preston North End 1
  • VICTORIA
  • West Ham 5
  • Manchester City 1
  • DERROTA
  • Leeds United 1
  • West Ham 0
7 Burnley Burnley 48 42 19 10 13 81 70
  • EMPATE
  • Tottenham Hotspur 2
  • Burnley 2
  • VICTORIA
  • Burnley 2
  • Portsmouth 1
  • DERROTA
  • Burnley 0
  • Bolton Wanderers 1
  • EMPATE
  • Aston Villa 0
  • Burnley 0
  • EMPATE
  • Burnley 2
  • Newcastle 2
8 Blackpool Blackpool 47 42 18 11 13 66 49
  • VICTORIA
  • Manchester City 0
  • Blackpool 2
  • DERROTA
  • Blackpool 0
  • Wolves 1
  • DERROTA
  • Blackpool 1
  • Arsenal 2
  • VICTORIA
  • Blackpool 2
  • Birmingham City 0
  • EMPATE
  • Luton Town 1
  • Blackpool 1
9 Birmingham City Birmingham City 46 42 20 6 16 84 68
  • DERROTA
  • Blackpool 2
  • Birmingham City 0
  • VICTORIA
  • Birmingham City 3
  • Blackburn Rovers 0
  • VICTORIA
  • Birmingham City 4
  • Chelsea 1
  • EMPATE
  • Newcastle 1
  • Birmingham City 1
  • DERROTA
  • Arsenal 2
  • Birmingham City 1
10 Blackburn Rovers Blackburn Rovers 44 42 17 10 15 76 70
  • DERROTA
  • Leeds United 2
  • Blackburn Rovers 1
  • VICTORIA
  • Blackburn Rovers 2
  • Manchester City 1
  • VICTORIA
  • Blackburn Rovers 3
  • Luton Town 1
  • DERROTA
  • Birmingham City 3
  • Blackburn Rovers 0
  • DERROTA
  • Bolton Wanderers 3
  • Blackburn Rovers 1
11 Newcastle Newcastle 41 42 17 7 18 80 80
  • EMPATE
  • West Bromwich Albi. 2
  • Newcastle 2
  • EMPATE
  • Newcastle 2
  • Leeds United 2
  • VICTORIA
  • Newcastle 2
  • Bolton Wanderers 0
  • EMPATE
  • Burnley 2
  • Newcastle 2
  • EMPATE
  • Newcastle 1
  • Birmingham City 1
12 Preston North End Preston North 41 42 17 7 18 70 77
  • DERROTA
  • Preston North End 0
  • Burnley 4
  • VICTORIA
  • Portsmouth 1
  • Preston North End 2
  • VICTORIA
  • Preston North End 4
  • Aston Villa 2
  • EMPATE
  • West Ham 1
  • Preston North End 1
  • EMPATE
  • Preston North End 2
  • Tottenham Hotspur 2
13 Nottingham Forest Nottingham 40 42 17 6 19 71 74
  • DERROTA
  • Nottingham Forest 1
  • Chelsea 3
  • DERROTA
  • Nottingham Forest 1
  • Leicester 4
  • VICTORIA
  • Nottingham Forest 2
  • Aston Villa 0
  • DERROTA
  • Nottingham Forest 0
  • Leeds United 3
  • DERROTA
  • West Bromwich Albi. 2
  • Nottingham Forest 0
14 Chelsea Chelsea 40 42 18 4 20 77 98
  • EMPATE
  • Arsenal 1
  • Chelsea 1
  • VICTORIA
  • Nottingham Forest 1
  • Chelsea 3
  • VICTORIA
  • Chelsea 3
  • Everton 1
  • DERROTA
  • Chelsea 0
  • West Bromwich Albi. 2
  • DERROTA
  • Birmingham City 4
  • Chelsea 1
15 Leeds United Leeds United 39 42 15 9 18 57 74
  • DERROTA
  • Blackpool 3
  • Leeds United 0
  • VICTORIA
  • Leeds United 2
  • Blackburn Rovers 1
  • EMPATE
  • Newcastle 2
  • Leeds United 2
  • VICTORIA
  • Nottingham Forest 0
  • Leeds United 3
  • VICTORIA
  • Leeds United 1
  • West Ham 0
16 Everton Everton 38 42 17 4 21 71 87
  • DERROTA
  • West Ham 3
  • Everton 2
  • DERROTA
  • Everton 1
  • Nottingham Forest 3
  • VICTORIA
  • Portsmouth 2
  • Everton 3
  • DERROTA
  • Chelsea 3
  • Everton 1
  • DERROTA
  • Everton 0
  • Wolves 1
17 Luton Town Luton Town 37 42 12 13 17 68 71
  • DERROTA
  • West Bromwich Albi. 2
  • Luton Town 0
  • DERROTA
  • Wolves 5
  • Luton Town 0
  • DERROTA
  • Blackburn Rovers 3
  • Luton Town 1
  • VICTORIA
  • Luton Town 3
  • Portsmouth 1
  • EMPATE
  • Luton Town 1
  • Blackpool 1
18 Tottenham Hotspur Tottenham 36 42 13 10 19 85 95
  • EMPATE
  • Aston Villa 1
  • Tottenham Hotspur 1
  • EMPATE
  • Tottenham Hotspur 2
  • Burnley 2
  • DERROTA
  • Birmingham City 5
  • Tottenham Hotspur 1
  • VICTORIA
  • Tottenham Hotspur 5
  • West Bromwich Albi. 0
  • EMPATE
  • Preston North End 2
  • Tottenham Hotspur 2
19 Leicester Leicester 32 42 11 10 21 67 98
  • EMPATE
  • Leicester 1
  • West Ham 1
  • VICTORIA
  • Nottingham Forest 1
  • Leicester 4
  • DERROTA
  • Wolves 3
  • Leicester 0
  • VICTORIA
  • Leicester 2
  • Manchester United 1
  • DERROTA
  • Manchester City 3
  • Leicester 1
20 Manchester City Manchester City 31 42 11 9 22 64 95
  • DERROTA
  • Manchester City 0
  • Blackpool 2
  • DERROTA
  • Blackburn Rovers 2
  • Manchester City 1
  • DERROTA
  • West Ham 5
  • Manchester City 1
  • EMPATE
  • Manchester City 0
  • Aston Villa 0
  • VICTORIA
  • Manchester City 3
  • Leicester 1
21 Aston Villa Aston Villa 30 42 11 8 23 58 87
  • DERROTA
  • Preston North End 4
  • Aston Villa 2
  • EMPATE
  • Aston Villa 0
  • Burnley 0
  • DERROTA
  • Nottingham Forest 2
  • Aston Villa 0
  • EMPATE
  • Manchester City 0
  • Aston Villa 0
  • EMPATE
  • West Bromwich Albi. 1
  • Aston Villa 1
22 Portsmouth Portsmouth 21 42 6 9 27 64 112
  • DERROTA
  • Burnley 2
  • Portsmouth 1
  • DERROTA
  • Portsmouth 2
  • Everton 3
  • DERROTA
  • Portsmouth 0
  • Bolton Wanderers 1
  • DERROTA
  • Luton Town 3
  • Portsmouth 1
  • DERROTA
  • Arsenal 5
  • Portsmouth 2
Copa de Europa : Wolves
Copa de Ferias : Birmingham City, Chelsea
Descenso : Aston Villa, Portsmouth

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
  • 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 cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,144,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.1249
Total Execution Time  0.1271
  CADENA URL  
/premier1959
  GET DATOS  
$_GET['/premier1959']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0017  SELECT type FROM routes WHERE alias = 'premier1959'
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 = 1959 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 = 5669 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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-03-29 09:05:01' 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-03-29 09:05:01' 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-03-29 09:05:01' 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-03-29 09:05:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 1959 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0037  SELECT e.action, count(e.action) as total, e.player_id FROM events1959 e WHERE e.league_id IN (5669) 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.0028  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 (5669) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (382980,421181,383153,372877,456375,854509,389192,854539,454482,456026,454187,854564,854854,389259,395726,421036,520133,526678,854540,854526) ORDER BY rp.in_squad = 1 DESC
0.0031  SELECT e.action, count(e.action) as total, e.player_id FROM events1959 e WHERE e.league_id IN (5669) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0031  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 (5669) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1959 e WHERE e.league_id IN (5669) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0031  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 (5669) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (854625,854682) ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events1959 e WHERE e.league_id IN (5669) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (5669) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  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 = 5669 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 5669 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0018  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=5669 AND rel.round=42
0.0018  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 = 5669 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0026  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 = 5669 AND esl.points > 0
0.0036  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-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 5669 ORDER BY creation_date DESC LIMIT 0, 10
0.0021  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-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 5669
0.0019  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 `calendars1959` 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` = 5669 AND c.`round` = 42 ORDER BY shedule ASC LIMIT 200
0.0026  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 events1959 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1959 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 5669 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 (1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0049  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 `events1959` e INNER JOIN calendars1959 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 = 42 AND e.real_date IS NOT NULL AND e.league_id = 5669 ORDER BY total DESC LIMIT 40
0.0031  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 `events1959` e INNER JOIN calendars1959 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 = 5669 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0019  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 `tables1959` 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 = 5669 AND t.round = 41 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0017  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1959` 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 = 5669 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT distinct(shedule), round FROM `calendars1959` as c WHERE c.`league_id` = 5669 AND shedule >= '1959/04/01' AND shedule < '1959/05/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-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 5669 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=1959