TEMPORADA 2023/2024
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Arsenal Arsenal 28 70 24 64
2 Liverpool Liverpool 28 65 26 64
3 Manchester City Manchester 28 63 28 63
4 Aston Villa Aston Villa 29 60 42 56
5 Tottenham Hotspur Tottenham 28 59 42 53
6 Manchester United Manchester 28 39 39 47
7 West Ham West Ham 29 46 50 44
8 Brighton & Hove Albion Brighton 28 50 44 42
9 Wolves Wolves 28 42 44 41
10 Newcastle Newcastle 28 59 48 40
11 Chelsea Chelsea 27 47 45 39
12 Fulham Fulham 29 43 44 38
13 AFC Bournemouth Bournemouth 28 41 52 35
14 Crystal Palace Crystal 28 33 48 29
15 Brentford Brentford 29 41 54 26
16 Everton Everton 28 29 39 25
17 Luton Town Luton Town 29 42 60 22
18 Nottingham Forest Nottingham 29 35 51 21
19 Burnley Burnley 29 29 63 17
20 Sheffield United Sheffield 28 24 74 14
TEMPORADA 2022/2023
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 38 94 33 89
2 Arsenal Arsenal 38 88 43 84
3 Manchester United Manchester 38 58 43 75
4 Newcastle Newcastle 38 68 33 71
5 Liverpool Liverpool 38 75 47 67
6 Brighton & Hove Albion Brighton 38 72 53 62
7 Aston Villa Aston Villa 38 51 46 61
8 Tottenham Hotspur Tottenham 38 70 63 60
9 Brentford Brentford 38 58 46 59
10 Fulham Fulham 38 55 53 52
11 Crystal Palace Crystal 38 40 49 45
12 Chelsea Chelsea 38 38 47 44
13 Wolves Wolves 38 31 58 41
14 West Ham West Ham 38 42 55 40
15 AFC Bournemouth Bournemouth 38 37 71 39
16 Nottingham Forest Nottingham 38 38 68 38
17 Everton Everton 38 34 57 36
18 Leicester Leicester 38 51 68 34
19 Leeds United Leeds United 38 48 78 31
20 Southampton Southampton 38 36 73 25
TEMPORADA 2021/2022
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 38 99 26 93
2 Liverpool Liverpool 38 94 26 92
3 Chelsea Chelsea 38 76 33 74
4 Tottenham Hotspur Tottenham 38 69 40 71
5 Arsenal Arsenal 38 61 48 69
6 Manchester United Manchester 38 57 57 58
7 West Ham West Ham 38 60 51 56
8 Leicester Leicester 38 62 59 52
9 Brighton & Hove Albion Brighton 38 42 44 51
10 Wolves Wolves 38 38 43 51
11 Newcastle Newcastle 38 44 62 49
12 Crystal Palace Crystal 38 50 46 48
13 Brentford Brentford 38 48 56 46
14 Aston Villa Aston Villa 38 52 54 45
15 Southampton Southampton 38 43 67 40
16 Everton Everton 38 43 66 39
17 Leeds United Leeds United 38 42 79 38
18 Burnley Burnley 38 34 53 35
19 Watford Watford 38 34 77 23
20 Norwich City Norwich City 38 23 84 22
TEMPORADA 2020/2021
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 38 83 32 86
2 Manchester United Manchester 38 73 44 74
3 Liverpool Liverpool 38 68 42 69
4 Chelsea Chelsea 38 58 36 67
5 Leicester Leicester 38 68 50 66
6 West Ham West Ham 38 62 47 65
7 Tottenham Hotspur Tottenham 38 68 45 62
8 Arsenal Arsenal 38 55 39 61
9 Leeds United Leeds United 38 62 54 59
10 Everton Everton 38 47 48 59
11 Aston Villa Aston Villa 38 55 46 55
12 Newcastle Newcastle 38 46 62 45
13 Wolves Wolves 38 36 52 45
14 Crystal Palace Crystal 38 41 66 44
15 Southampton Southampton 38 47 68 43
16 Brighton & Hove Albion Brighton 38 40 46 41
17 Burnley Burnley 38 33 55 39
18 Fulham Fulham 38 27 53 28
19 West Bromwich Albion West 38 35 76 26
20 Sheffield United Sheffield 38 20 63 23
TEMPORADA 2019/2020
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 38 85 33 99
2 Manchester City Manchester 38 102 35 81
3 Manchester United Manchester 38 66 36 66
4 Chelsea Chelsea 38 69 54 66
5 Leicester Leicester 38 67 41 62
6 Tottenham Hotspur Tottenham 38 61 47 59
7 Wolves Wolves 38 51 40 59
8 Arsenal Arsenal 38 56 48 56
9 Sheffield United Sheffield 38 39 39 54
10 Burnley Burnley 38 43 50 54
11 Southampton Southampton 38 51 60 52
12 Everton Everton 38 44 56 49
13 Newcastle Newcastle 38 38 58 44
14 Crystal Palace Crystal 38 31 50 43
15 Brighton & Hove Albion Brighton 38 39 54 41
16 West Ham West Ham 38 49 62 39
17 Aston Villa Aston Villa 38 41 67 35
18 AFC Bournemouth Bournemouth 38 40 65 34
19 Watford Watford 38 36 64 34
20 Norwich City Norwich City 38 26 75 21
TEMPORADA 2018/2019
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 38 95 23 98
2 Liverpool Liverpool 38 89 22 97
3 Chelsea Chelsea 38 63 39 72
4 Tottenham Hotspur Tottenham 38 67 39 71
5 Arsenal Arsenal 38 73 51 70
6 Manchester United Manchester 38 65 54 66
7 Wolves Wolves 38 47 46 57
8 Everton Everton 38 54 46 54
9 Leicester Leicester 38 51 48 52
10 West Ham West Ham 38 52 55 52
11 Watford Watford 38 52 59 50
12 Crystal Palace Crystal 38 51 53 49
13 Newcastle Newcastle 38 42 48 45
14 AFC Bournemouth Bournemouth 38 56 70 45
15 Burnley Burnley 38 45 68 40
16 Southampton Southampton 38 45 65 39
17 Brighton & Hove Albion Brighton 38 35 60 36
18 Cardiff City Cardiff City 38 34 69 34
19 Fulham Fulham 38 34 81 26
20 Huddersfield Town Huddersfield 38 22 76 16
TEMPORADA 2017/2018
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 38 106 27 100
2 Manchester United Manchester 38 68 28 81
3 Tottenham Hotspur Tottenham 38 74 36 77
4 Liverpool Liverpool 38 84 38 75
5 Chelsea Chelsea 38 62 38 70
6 Arsenal Arsenal 38 74 51 63
7 Burnley Burnley 38 36 39 54
8 Everton Everton 38 44 58 49
9 Leicester Leicester 38 56 60 47
10 Newcastle Newcastle 38 39 47 44
11 Crystal Palace Crystal 38 45 55 44
12 AFC Bournemouth Bournemouth 38 45 61 44
13 West Ham West Ham 38 48 68 42
14 Watford Watford 38 44 64 41
15 Brighton & Hove Albion Brighton 38 34 54 40
16 Huddersfield Town Huddersfield 38 28 58 37
17 Southampton Southampton 38 37 56 36
18 Swansea City Swansea City 38 28 56 33
19 Stoke City Stoke City 38 35 68 33
20 West Bromwich Albion West 38 31 56 31
TEMPORADA 2016/2017
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 38 85 33 93
2 Tottenham Hotspur Tottenham 38 86 26 86
3 Manchester City Manchester 38 80 39 78
4 Liverpool Liverpool 38 78 42 76
5 Arsenal Arsenal 38 77 44 75
6 Manchester United Manchester 38 54 29 69
7 Everton Everton 38 62 44 61
8 Southampton Southampton 38 41 48 46
9 AFC Bournemouth Bournemouth 38 55 67 46
10 West Bromwich Albion West 38 43 51 45
11 West Ham West Ham 38 47 64 45
12 Leicester Leicester 38 48 63 44
13 Stoke City Stoke City 38 41 56 44
14 Crystal Palace Crystal 38 50 63 41
15 Swansea City Swansea City 38 45 70 41
16 Burnley Burnley 38 39 55 40
17 Watford Watford 38 40 68 40
18 Hull City Hull City 38 37 80 34
19 Middlesbrough Middlesbroug 38 27 53 28
20 Sunderland Sunderland 38 29 69 24
TEMPORADA 2015/2016
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Leicester Leicester 38 68 36 81
2 Arsenal Arsenal 38 65 36 71
3 Tottenham Hotspur Tottenham 38 69 35 70
4 Manchester City Manchester 38 71 41 66
5 Manchester United Manchester 38 49 35 66
6 Southampton Southampton 38 59 41 63
7 West Ham West Ham 38 65 51 62
8 Liverpool Liverpool 38 63 50 60
9 Stoke City Stoke City 38 41 55 51
10 Chelsea Chelsea 38 59 53 50
11 Everton Everton 38 59 55 47
12 Swansea City Swansea City 38 42 52 47
13 Watford Watford 38 40 50 45
14 West Bromwich Albion West 38 34 48 43
15 Crystal Palace Crystal 38 39 51 42
16 AFC Bournemouth Bournemouth 38 45 67 42
17 Sunderland Sunderland 38 48 62 39
18 Newcastle Newcastle 38 44 65 37
19 Norwich City Norwich City 38 39 67 34
20 Aston Villa Aston Villa 38 27 76 17
TEMPORADA 2014/2015
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 38 73 32 87
2 Manchester City Manchester 38 83 38 79
3 Arsenal Arsenal 38 71 36 75
4 Manchester United Manchester 38 62 37 70
5 Tottenham Hotspur Tottenham 38 58 53 64
6 Liverpool Liverpool 38 52 48 62
7 Southampton Southampton 38 54 33 60
8 Swansea City Swansea City 38 46 49 56
9 Stoke City Stoke City 38 48 45 54
10 Crystal Palace Crystal 38 47 51 48
11 Everton Everton 38 48 50 47
12 West Ham West Ham 38 44 47 47
13 West Bromwich Albion West 38 38 51 44
14 Leicester Leicester 38 46 55 41
15 Newcastle Newcastle 38 40 63 39
16 Sunderland Sunderland 38 31 53 38
17 Aston Villa Aston Villa 38 31 57 38
18 Hull City Hull City 38 33 51 35
19 Burnley Burnley 38 28 53 33
20 Queens Park Rangers Queens Park 38 42 73 30
TEMPORADA 2013/2014
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester City Manchester 38 102 37 86
2 Liverpool Liverpool 38 101 50 84
3 Chelsea Chelsea 38 71 27 82
4 Arsenal Arsenal 38 68 41 79
5 Everton Everton 38 61 39 72
6 Tottenham Hotspur Tottenham 38 55 51 69
7 Manchester United Manchester 38 64 43 64
8 Southampton Southampton 38 54 46 56
9 Stoke City Stoke City 38 45 52 50
10 Newcastle Newcastle 38 43 59 49
11 Crystal Palace Crystal 38 33 48 45
12 Swansea City Swansea City 38 54 54 42
13 West Ham West Ham 38 40 51 40
14 Sunderland Sunderland 38 41 60 38
15 Aston Villa Aston Villa 38 39 61 38
16 Hull City Hull City 38 38 53 37
17 West Bromwich Albion West 38 43 59 36
18 Norwich City Norwich City 38 28 62 33
19 Fulham Fulham 38 40 85 32
20 Cardiff City Cardiff City 38 32 74 30
TEMPORADA 2012/2013
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 86 43 89
2 Manchester City Manchester 38 66 34 78
3 Chelsea Chelsea 38 75 39 75
4 Arsenal Arsenal 38 72 37 73
5 Tottenham Hotspur Tottenham 38 66 46 72
6 Everton Everton 38 55 40 63
7 Liverpool Liverpool 38 71 43 61
8 West Bromwich Albion West 38 53 57 49
9 Swansea City Swansea City 38 47 51 46
10 West Ham West Ham 38 45 53 46
11 Norwich City Norwich City 38 41 58 44
12 Fulham Fulham 38 50 60 43
13 Stoke City Stoke City 38 34 45 42
14 Southampton Southampton 38 49 60 41
15 Aston Villa Aston Villa 38 47 69 41
16 Newcastle Newcastle 38 45 68 41
17 Sunderland Sunderland 38 41 54 39
18 Wigan Athletic Wigan 38 47 73 36
19 Reading Reading 38 43 73 28
20 Queens Park Rangers Queens Park 38 30 60 25
TEMPORADA 2011/2012
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Reading Reading 46 69 41 89
2 Southampton Southampton 46 85 46 88
3 West Ham West Ham 46 81 48 86
4 Birmingham City Birmingham 46 78 51 76
5 Blackpool Blackpool 46 79 59 75
6 Cardiff City Cardiff City 46 66 53 75
7 Middlesbrough Middlesbroug 46 52 51 70
8 Hull City Hull City 46 47 44 68
9 Leicester Leicester 46 66 55 66
10 Brighton & Hove Albion Brighton 46 52 52 66
11 Watford Watford 46 56 64 64
12 Derby County Derby County 46 50 58 64
13 Burnley Burnley 46 61 58 62
14 Leeds United Leeds United 46 65 68 61
15 Ipswich Town Ipswich Town 46 69 77 61
16 Millwall Millwall 46 55 57 57
17 Crystal Palace Crystal 46 46 51 56
18 Portsmouth Portsmouth 46 50 59 50
19 Peterborough United Peterborough 46 67 77 50
20 Nottingham Forest Nottingham 46 48 63 50
21 Bristol City Bristol City 46 44 68 49
22 Barnsley Barnsley 46 49 74 48
23 Coventry City Coventry 46 41 65 40
24 Doncaster Rovers Doncaster 46 43 80 36
TEMPORADA 2010/2011
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 78 37 80
2 Chelsea Chelsea 38 69 33 71
3 Manchester City Manchester 38 60 33 71
4 Arsenal Arsenal 38 72 43 68
5 Tottenham Hotspur Tottenham 38 55 46 62
6 Liverpool Liverpool 38 59 44 58
7 Everton Everton 38 51 45 54
8 Fulham Fulham 38 49 43 49
9 Aston Villa Aston Villa 38 48 59 48
10 Sunderland Sunderland 38 45 56 47
11 West Bromwich Albion West 38 56 71 47
12 Newcastle Newcastle 38 56 57 46
13 Stoke City Stoke City 38 46 48 46
14 Bolton Wanderers Bolton 38 52 56 46
15 Blackburn Rovers Blackburn 38 46 59 43
16 Wigan Athletic Wigan 38 40 61 42
17 Wolves Wolves 38 46 66 40
18 Birmingham City Birmingham 38 37 58 39
19 Blackpool Blackpool 38 55 78 39
20 West Ham West Ham 38 43 70 33
TEMPORADA 2009/2010
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 38 103 32 86
2 Manchester United Manchester 38 86 28 85
3 Arsenal Arsenal 38 83 41 75
4 Tottenham Hotspur Tottenham 38 67 41 70
5 Manchester City Manchester 38 73 45 67
6 Aston Villa Aston Villa 38 52 39 64
7 Liverpool Liverpool 38 61 35 63
8 Everton Everton 38 60 49 61
9 Birmingham City Birmingham 38 38 47 50
10 Blackburn Rovers Blackburn 38 41 55 50
11 Stoke City Stoke City 38 34 48 47
12 Fulham Fulham 38 39 46 46
13 Sunderland Sunderland 38 48 56 44
14 Bolton Wanderers Bolton 38 42 67 39
15 Wolves Wolves 38 32 56 38
16 Wigan Athletic Wigan 38 37 79 36
17 West Ham West Ham 38 47 66 35
18 Burnley Burnley 38 42 82 30
19 Hull City Hull City 38 34 75 30
20 Portsmouth Portsmouth 38 34 66 19
TEMPORADA 2008/2009
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 68 24 90
2 Liverpool Liverpool 38 77 27 86
3 Chelsea Chelsea 38 68 24 83
4 Arsenal Arsenal 38 68 37 72
5 Everton Everton 38 55 37 63
6 Aston Villa Aston Villa 38 54 48 62
7 Fulham Fulham 38 39 34 53
8 Tottenham Hotspur Tottenham 38 45 45 51
9 West Ham West Ham 38 42 45 51
10 Manchester City Manchester 38 58 50 50
11 Wigan Athletic Wigan 38 34 45 45
12 Stoke City Stoke City 38 38 55 45
13 Bolton Wanderers Bolton 38 41 53 41
14 Portsmouth Portsmouth 38 38 57 41
15 Blackburn Rovers Blackburn 38 40 60 41
16 Sunderland Sunderland 38 34 54 36
17 Hull City Hull City 38 39 64 35
18 Newcastle Newcastle 38 40 59 34
19 Middlesbrough Middlesbroug 38 28 57 32
20 West Bromwich Albion West 38 36 67 32
TEMPORADA 2007/2008
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 80 22 87
2 Chelsea Chelsea 38 65 26 85
3 Arsenal Arsenal 38 74 31 83
4 Liverpool Liverpool 38 67 28 76
5 Everton Everton 38 55 33 65
6 Aston Villa Aston Villa 38 71 51 60
7 Blackburn Rovers Blackburn 38 50 48 58
8 Portsmouth Portsmouth 38 48 40 57
9 Manchester City Manchester 38 45 53 55
10 West Ham West Ham 38 42 50 49
11 Tottenham Hotspur Tottenham 38 66 61 46
12 Newcastle Newcastle 38 45 65 43
13 Middlesbrough Middlesbroug 38 43 53 42
14 Wigan Athletic Wigan 38 34 51 40
15 Sunderland Sunderland 38 36 59 39
16 Bolton Wanderers Bolton 38 36 54 37
17 Fulham Fulham 38 38 60 36
18 Reading Reading 38 41 66 36
19 Birmingham City Birmingham 38 46 62 35
20 Derby County Derby County 38 20 89 11
TEMPORADA 2006/2007
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 83 27 89
2 Chelsea Chelsea 38 64 24 83
3 Liverpool Liverpool 38 57 27 68
4 Arsenal Arsenal 38 63 35 68
5 Tottenham Hotspur Tottenham 38 57 54 60
6 Everton Everton 38 52 36 58
7 Bolton Wanderers Bolton 38 47 52 56
8 Reading Reading 38 52 47 55
9 Portsmouth Portsmouth 38 45 42 54
10 Blackburn Rovers Blackburn 38 52 54 52
11 Aston Villa Aston Villa 38 43 41 50
12 Middlesbrough Middlesbroug 38 44 49 46
13 Newcastle Newcastle 38 38 47 43
14 Manchester City Manchester 38 29 44 42
15 West Ham West Ham 38 35 59 41
16 Fulham Fulham 38 38 60 39
17 Wigan Athletic Wigan 38 37 59 38
18 Sheffield United Sheffield 38 32 55 38
19 Charlton Athletic Charlton 38 34 60 34
20 Watford Watford 38 29 59 28
TEMPORADA 2005/2006
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 38 72 22 91
2 Manchester United Manchester 38 72 34 83
3 Liverpool Liverpool 38 57 25 82
4 Arsenal Arsenal 38 68 31 67
5 Tottenham Hotspur Tottenham 38 53 38 65
6 Blackburn Rovers Blackburn 38 51 42 63
7 Newcastle Newcastle 38 47 42 58
8 Bolton Wanderers Bolton 38 49 41 56
9 West Ham West Ham 38 52 55 55
10 Wigan Athletic Wigan 38 45 52 51
11 Everton Everton 38 34 49 50
12 Fulham Fulham 38 48 58 48
13 Charlton Athletic Charlton 38 41 55 47
14 Middlesbrough Middlesbroug 38 48 58 45
15 Manchester City Manchester 38 43 48 43
16 Aston Villa Aston Villa 38 42 55 42
17 Portsmouth Portsmouth 38 37 62 38
18 Birmingham City Birmingham 38 28 50 34
19 West Bromwich Albion West 38 31 58 30
20 Sunderland Sunderland 38 26 69 15
TEMPORADA 2004/2005
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sunderland Sunderland 46 76 41 94
2 Wigan Athletic Wigan 46 79 35 87
3 Ipswich Town Ipswich Town 46 85 56 85
4 Derby County Derby County 46 71 60 76
5 Preston North End Preston 46 67 58 75
6 West Ham West Ham 46 66 56 73
7 Reading Reading 46 51 44 70
8 Sheffield United Sheffield 46 57 56 67
9 Wolves Wolves 46 72 59 66
10 Millwall Millwall 46 51 45 66
11 Queens Park Rangers Queens Park 46 54 58 62
12 Stoke City Stoke City 46 36 38 61
13 Burnley Burnley 46 38 39 60
14 Leeds United Leeds United 46 49 52 60
15 Leicester Leicester 46 49 46 57
16 Cardiff City Cardiff City 46 48 51 54
17 Plymouth Argyle Plymouth 46 52 64 53
18 Watford Watford 46 52 59 52
19 Coventry City Coventry 46 61 73 52
20 Brighton & Hove Albion Brighton 46 40 65 51
21 Crewe Alexandra Crewe 46 66 86 50
22 Gillingham Gillingham 46 45 66 50
23 Nottingham Forest Nottingham 46 42 66 44
24 Rotherham United Rotherham 46 35 69 29
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  
9,250,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.5874
Total Execution Time  0.5890
  CADENA URL  
/historico/West-Ham-United
  GET DATOS  
$_GET['/historico/West-Ham-United']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0216  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73871
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2804 AND type_rel = 2
0.0155  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2804 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0107  SELECT /*35 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 (540,704,1158,1370,1442) ORDER BY n.cover_points DESC, update_date DESC
0.0123  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '2804' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0105  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73871 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 71849 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0119  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=2804 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74791,72728,72258,71849,71432,70410,67758) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0176  SELECT count(id) as num_players from rel_players WHERE league_id = 71849 AND teamId = 2804
0.0174  SELECT count(id) as num_players from rel_players WHERE league_id = 74791 AND teamId = 2804
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 2804
0.0116  SELECT count(id) as num_players from rel_players WHERE league_id = 70410 AND teamId = 2804
0.0118  SELECT count(id) as num_players from rel_players WHERE league_id = 72258 AND teamId = 2804
0.0114  SELECT count(id) as num_players from rel_players WHERE league_id = 67758 AND teamId = 2804
0.0197  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2804
0.0123  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 2804 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 2804 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 2804 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0125  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 2804 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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 `tables2023` 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 = 67672 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2022` 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 = 62729 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2021` 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 = 57338 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 49845 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 43543 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 38633 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 29314 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 `tables2016` 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 = 15131 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2014` 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 = 2435 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 `tables2013` 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 = 1900 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 `tables2012` 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 = 1316 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 `tables2011` 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 = 1068 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 `tables2010` 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 = 810 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2009` 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 = 150 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2008` 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 = 29 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2007` 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 = 48 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 `tables2006` 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 = 47 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 `tables2005` 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 = 153 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC