4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Brighton & Hove Albion

Brighton & Hove Albion

Entrenador: Roberto De Zerbi

Temporada 1989/1990
TEMPORADA 1989/1990
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Leeds United Leeds United 46 79 52 85
2 Sheffield United Sheffield 46 78 58 85
3 Newcastle Newcastle 46 80 55 80
4 Swindon Town Swindon Town 46 79 59 74
5 Blackburn Rovers Blackburn 46 74 59 74
6 Sunderland Sunderland 46 70 64 74
7 West Ham West Ham 46 80 57 72
8 Oldham Athletic AFC Oldham 46 70 57 71
9 Ipswich Town Ipswich Town 46 67 66 69
10 Wolves Wolves 46 67 60 67
11 Port Vale Port Vale 46 62 57 61
12 Portsmouth Portsmouth 46 62 65 61
13 Leicester Leicester 46 67 79 59
14 Hull City Hull City 46 58 65 58
15 Watford Watford 46 58 60 57
16 Plymouth Argyle Plymouth 46 58 63 55
17 Oxford United Oxford 46 57 66 54
18 Brighton & Hove Albion Brighton 46 56 72 54
19 Barnsley Barnsley 46 49 71 54
20 West Bromwich Albion West 46 67 71 51
21 Middlesbrough Middlesbroug 46 52 63 50
22 AFC Bournemouth Bournemouth 46 57 76 48
23 Bradford City Bradford 46 44 68 41
24 Stoke City Stoke City 46 35 63 37
TEMPORADA 1988/1989
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 46 96 50 99
2 Manchester City Manchester 46 77 53 82
3 Crystal Palace Crystal 46 71 49 81
4 Watford Watford 46 74 48 78
5 Blackburn Rovers Blackburn 46 74 59 77
6 Swindon Town Swindon Town 46 68 53 76
7 Barnsley Barnsley 46 66 58 74
8 Ipswich Town Ipswich Town 46 71 61 73
9 West Bromwich Albion West 46 65 41 72
10 Leeds United Leeds United 46 59 50 67
11 Sunderland Sunderland 46 60 60 63
12 AFC Bournemouth Bournemouth 46 53 62 62
13 Stoke City Stoke City 46 57 72 59
14 Bradford City Bradford 46 52 59 56
15 Leicester Leicester 46 56 63 55
16 Oldham Athletic AFC Oldham 46 75 72 54
17 Oxford United Oxford 46 62 70 54
18 Plymouth Argyle Plymouth 46 55 66 54
19 Brighton & Hove Albion Brighton 46 57 66 51
20 Portsmouth Portsmouth 46 53 62 51
21 Hull City Hull City 46 52 68 47
22 Shrewsbury Town Shrewsbury 46 40 67 42
23 Birmingham City Birmingham 46 31 76 35
24 Walsall Walsall 46 41 80 31
TEMPORADA 1986/1987
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Derby County Derby County 42 64 38 84
2 Portsmouth Portsmouth 42 53 28 78
3 Oldham Athletic AFC Oldham 42 65 44 75
4 Leeds United Leeds United 42 58 44 68
5 Ipswich Town Ipswich Town 42 59 43 64
6 Crystal Palace Crystal 42 51 53 62
7 Plymouth Argyle Plymouth 42 62 57 61
8 Stoke City Stoke City 42 63 53 58
9 Sheffield United Sheffield 42 50 49 58
10 Bradford City Bradford 42 62 62 55
11 Barnsley Barnsley 42 49 52 55
12 Blackburn Rovers Blackburn 42 45 55 55
13 Reading Reading 42 52 59 53
14 Hull City Hull City 42 41 55 53
15 West Bromwich Albion West 42 51 49 51
16 Millwall Millwall 42 39 45 51
17 Huddersfield Town Huddersfield 42 54 61 51
18 Shrewsbury Town Shrewsbury 42 41 53 51
19 Birmingham City Birmingham 42 47 59 50
20 Sunderland Sunderland 42 49 59 48
21 Grimsby Town Grimsby Town 42 39 59 44
22 Brighton & Hove Albion Brighton 42 37 54 39
TEMPORADA 1985/1986
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Norwich City Norwich City 42 84 37 84
2 Charlton Athletic Charlton 42 78 45 77
3 Wimbledon FC Wimbledon 42 58 37 76
4 Portsmouth Portsmouth 42 69 41 73
5 Crystal Palace Crystal 42 57 52 66
6 Hull City Hull City 42 65 55 64
7 Sheffield United Sheffield 42 64 63 62
8 Oldham Athletic AFC Oldham 42 62 61 60
9 Millwall Millwall 42 64 65 59
10 Stoke City Stoke City 42 48 50 57
11 Brighton & Hove Albion Brighton 42 64 64 56
12 Barnsley Barnsley 42 47 50 56
13 Bradford City Bradford 42 51 63 54
14 Leeds United Leeds United 42 56 72 53
15 Grimsby Town Grimsby Town 42 58 62 52
16 Huddersfield Town Huddersfield 42 51 67 52
17 Shrewsbury Town Shrewsbury 42 52 64 51
18 Sunderland Sunderland 42 47 61 50
19 Blackburn Rovers Blackburn 42 53 62 49
20 Carlisle United Carlisle 42 47 71 46
21 Middlesbrough Middlesbroug 42 44 53 45
22 Fulham Fulham 42 45 69 36
TEMPORADA 1984/1985
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Oxford United Oxford 42 84 36 84
2 Birmingham City Birmingham 42 59 33 82
3 Manchester City Manchester 42 66 40 74
4 Portsmouth Portsmouth 42 69 50 74
5 Blackburn Rovers Blackburn 42 66 41 73
6 Brighton & Hove Albion Brighton 42 54 34 72
7 Leeds United Leeds United 42 66 43 69
8 Shrewsbury Town Shrewsbury 42 66 53 65
9 Fulham Fulham 42 68 64 65
10 Grimsby Town Grimsby Town 42 72 64 62
11 Barnsley Barnsley 42 42 42 58
12 Wimbledon FC Wimbledon 42 71 75 58
13 Huddersfield Town Huddersfield 42 52 64 55
14 Oldham Athletic AFC Oldham 42 49 67 53
15 Crystal Palace Crystal 42 46 65 48
16 Carlisle United Carlisle 42 50 67 47
17 Charlton Athletic Charlton 42 51 63 45
18 Sheffield United Sheffield 42 54 66 44
19 Middlesbrough Middlesbroug 42 41 57 40
20 Notts County Notts County 42 45 73 37
21 Cardiff City Cardiff City 42 47 79 35
22 Wolves Wolves 42 37 79 33
TEMPORADA 1983/1984
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Chelsea Chelsea 42 90 40 88
2 Sheffield Wednesday Sheffield 42 72 34 88
3 Newcastle Newcastle 42 85 53 80
4 Manchester City Manchester 42 66 48 70
5 Grimsby Town Grimsby Town 42 60 47 70
6 Blackburn Rovers Blackburn 42 57 48 64
7 Carlisle United Carlisle 42 48 41 64
8 Shrewsbury Town Shrewsbury 42 49 53 61
9 Brighton & Hove Albion Brighton 42 69 60 60
10 Leeds United Leeds United 42 55 56 60
11 Fulham Fulham 42 60 53 57
12 Huddersfield Town Huddersfield 42 56 49 57
13 Charlton Athletic Charlton 42 53 64 57
14 Cardiff City Cardiff City 42 55 66 54
15 Barnsley Barnsley 42 57 53 52
16 Portsmouth Portsmouth 42 73 64 49
17 Middlesbrough Middlesbroug 42 41 47 49
18 Crystal Palace Crystal 42 42 52 47
19 Oldham Athletic AFC Oldham 42 47 73 47
20 Derby County Derby County 42 36 72 42
21 Swansea City Swansea City 42 36 85 29
22 Cambridge United Cambridge 42 28 77 24
TEMPORADA 1982/1983
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 87 37 82
2 Watford Watford 42 74 57 71
3 Manchester United Manchester 42 56 38 70
4 Tottenham Hotspur Tottenham 42 65 50 69
5 Nottingham Forest Nottingham 42 62 50 69
6 Aston Villa Aston Villa 42 62 50 68
7 Everton Everton 42 66 48 64
8 West Ham West Ham 42 68 62 64
9 Ipswich Town Ipswich Town 42 64 50 58
10 Arsenal Arsenal 42 58 56 58
11 West Bromwich Albion West 42 51 49 57
12 Southampton Southampton 42 54 58 57
13 Stoke City Stoke City 42 53 64 57
14 Norwich City Norwich City 42 52 58 54
15 Notts County Notts County 42 55 71 52
16 Sunderland Sunderland 42 48 61 50
17 Birmingham City Birmingham 42 40 55 50
18 Luton Town Luton Town 42 65 84 49
19 Coventry City Coventry 42 48 59 48
20 Manchester City Manchester 42 47 70 47
21 Swansea City Swansea City 42 51 69 41
22 Brighton & Hove Albion Brighton 42 38 68 40
TEMPORADA 1981/1982
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 80 32 87
2 Ipswich Town Ipswich Town 42 75 53 83
3 Manchester United Manchester 42 59 29 78
4 Tottenham Hotspur Tottenham 42 67 48 71
5 Arsenal Arsenal 42 48 37 71
6 Swansea City Swansea City 42 58 51 69
7 Southampton Southampton 42 72 67 66
8 Everton Everton 42 56 50 64
9 West Ham West Ham 42 66 57 58
10 Manchester City Manchester 42 49 50 58
11 Aston Villa Aston Villa 42 55 53 57
12 Nottingham Forest Nottingham 42 42 48 57
13 Brighton & Hove Albion Brighton 42 43 52 52
14 Coventry City Coventry 42 56 62 50
15 Notts County Notts County 42 61 69 47
16 Birmingham City Birmingham 42 53 61 44
17 West Bromwich Albion West 42 46 57 44
18 Stoke City Stoke City 42 44 63 44
19 Sunderland Sunderland 42 38 58 44
20 Leeds United Leeds United 42 39 61 42
21 Wolves Wolves 42 32 63 40
22 Middlesbrough Middlesbroug 42 34 52 39
TEMPORADA 1980/1981
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Aston Villa Aston Villa 42 72 40 60
2 Ipswich Town Ipswich Town 42 77 43 56
3 Arsenal Arsenal 42 61 45 53
4 West Bromwich Albion West 42 60 42 52
5 Liverpool Liverpool 42 62 42 51
6 Southampton Southampton 42 76 56 50
7 Nottingham Forest Nottingham 42 62 44 50
8 Manchester United Manchester 42 51 36 48
9 Leeds United Leeds United 42 39 47 44
10 Tottenham Hotspur Tottenham 42 70 68 43
11 Stoke City Stoke City 42 51 60 42
12 Manchester City Manchester 42 56 59 39
13 Birmingham City Birmingham 42 50 61 38
14 Middlesbrough Middlesbroug 42 53 61 37
15 Everton Everton 42 55 58 36
16 Coventry City Coventry 42 48 68 36
17 Sunderland Sunderland 42 52 53 35
18 Wolves Wolves 42 43 55 35
19 Brighton & Hove Albion Brighton 42 54 67 35
20 Norwich City Norwich City 42 49 73 33
21 Leicester Leicester 42 40 67 32
22 Crystal Palace Crystal 42 47 83 19
TEMPORADA 1979/1980
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 81 30 60
2 Manchester United Manchester 42 65 35 58
3 Ipswich Town Ipswich Town 42 68 39 53
4 Arsenal Arsenal 42 52 36 52
5 Nottingham Forest Nottingham 42 63 43 48
6 Wolves Wolves 42 58 47 47
7 Aston Villa Aston Villa 42 51 50 46
8 Southampton Southampton 42 65 53 45
9 Middlesbrough Middlesbroug 42 50 44 44
10 West Bromwich Albion West 42 54 50 41
11 Leeds United Leeds United 42 46 50 40
12 Norwich City Norwich City 42 58 66 40
13 Crystal Palace Crystal 42 41 50 40
14 Tottenham Hotspur Tottenham 42 52 62 40
15 Coventry City Coventry 42 56 66 39
16 Brighton & Hove Albion Brighton 42 47 57 37
17 Manchester City Manchester 42 43 66 37
18 Stoke City Stoke City 42 44 58 36
19 Everton Everton 42 43 51 35
20 Bristol City Bristol City 42 37 66 31
21 Derby County Derby County 42 47 67 30
22 Bolton Wanderers Bolton 42 38 73 25
TEMPORADA 1978/1979
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Brighton & Hove Albion Brighton 42 72 39 79
2 Sunderland Sunderland 42 70 44 77
3 Stoke City Stoke City 42 58 31 76
4 Crystal Palace Crystal 42 51 24 76
5 West Ham West Ham 42 70 39 68
6 Newcastle Newcastle 42 51 55 59
7 Notts County Notts County 42 48 60 58
8 Cardiff City Cardiff City 42 56 70 58
9 Leyton Orient Leyton 42 51 51 55
10 Fulham Fulham 42 50 47 54
11 Preston North End Preston 42 59 57 54
12 Burnley Burnley 42 51 62 54
13 Cambridge United Cambridge 42 44 52 52
14 Oldham Athletic AFC Oldham 42 52 61 52
15 Bristol Rovers Bristol 42 48 60 52
16 Wrexham AFC Wrexham AFC 42 45 42 50
17 Luton Town Luton Town 42 60 57 49
18 Leicester Leicester 42 43 52 47
19 Charlton Athletic Charlton 42 60 69 46
20 Sheffield United Sheffield 42 52 69 45
21 Millwall Millwall 42 42 61 43
22 Blackburn Rovers Blackburn 42 41 72 40
TEMPORADA 1977/1978
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Bolton Wanderers Bolton 42 63 33 82
2 Southampton Southampton 42 70 39 79
3 Brighton & Hove Albion Brighton 42 63 38 78
4 Tottenham Hotspur Tottenham 42 83 49 76
5 Blackburn Rovers Blackburn 42 56 60 61
6 Sunderland Sunderland 42 67 59 58
7 Stoke City Stoke City 42 53 49 58
8 Sheffield United Sheffield 42 62 73 56
9 Fulham Fulham 42 49 49 55
10 Oldham Athletic AFC Oldham 42 54 58 55
11 Burnley Burnley 42 56 64 55
12 Crystal Palace Crystal 42 50 47 54
13 Luton Town Luton Town 42 54 52 52
14 Charlton Athletic Charlton 42 55 68 51
15 Bristol Rovers Bristol 42 61 77 51
16 Cardiff City Cardiff City 42 51 71 51
17 Millwall Millwall 42 49 57 50
18 Blackpool Blackpool 42 59 60 49
19 Notts County Notts County 42 54 62 49
20 Leyton Orient Leyton 42 43 49 48
21 Mansfield Town Mansfield 42 49 69 41
22 Hull City Hull City 42 34 52 36
TEMPORADA 1972/1973
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Burnley Burnley 42 72 35 86
2 Queens Park Rangers Queens Park 42 81 37 85
3 Aston Villa Aston Villa 42 51 47 68
4 Oxford United Oxford 42 52 43 64
5 Blackpool Blackpool 42 56 51 64
6 Middlesbrough Middlesbroug 42 46 43 64
7 Bristol City Bristol City 42 63 51 63
8 Sunderland Sunderland 42 59 49 63
9 Sheffield Wednesday Sheffield 42 59 55 61
10 Fulham Fulham 42 58 49 60
11 Millwall Millwall 42 55 47 58
12 Luton Town Luton Town 42 44 53 56
13 Hull City Hull City 42 64 59 54
14 Nottingham Forest Nottingham 42 47 52 54
15 Leyton Orient Leyton 42 49 53 48
16 Portsmouth Portsmouth 42 42 59 47
17 Swindon Town Swindon Town 42 46 60 46
18 Carlisle United Carlisle 42 50 52 45
19 Preston North End Preston 42 37 64 45
20 Cardiff City Cardiff City 42 43 58 44
21 Huddersfield Town Huddersfield 42 36 56 41
22 Brighton & Hove Albion Brighton 42 46 83 37
TEMPORADA 1961/1962
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 42 99 43 89
2 Leyton Orient Leyton 42 69 40 76
3 Sunderland Sunderland 42 85 50 75
4 Scunthorpe United Scunthorpe 42 86 71 70
5 Plymouth Argyle Plymouth 42 75 75 65
6 Southampton Southampton 42 77 62 63
7 Huddersfield Town Huddersfield 42 67 59 60
8 Stoke City Stoke City 42 55 57 59
9 Rotherham United Rotherham 42 70 76 57
10 Luton Town Luton Town 42 69 71 56
11 Bury Bury 42 52 76 56
12 Middlesbrough Middlesbroug 42 76 72 55
13 Preston North End Preston 42 55 57 55
14 Newcastle Newcastle 42 64 58 54
15 Charlton Athletic Charlton 42 69 75 54
16 Walsall Walsall 42 70 75 53
17 Derby County Derby County 42 68 75 53
18 Norwich City Norwich City 42 61 70 53
19 Leeds United Leeds United 42 50 61 48
20 Swansea City Swansea City 42 61 83 48
21 Bristol Rovers Bristol 42 53 81 46
22 Brighton & Hove Albion Brighton 42 42 86 41
TEMPORADA 1960/1961
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Ipswich Town Ipswich Town 42 100 55 85
2 Sheffield United Sheffield 42 81 51 84
3 Liverpool Liverpool 42 87 58 73
4 Norwich City Norwich City 42 70 53 69
5 Middlesbrough Middlesbroug 42 83 74 66
6 Swansea City Swansea City 42 77 73 65
7 Sunderland Sunderland 42 75 60 64
8 Southampton Southampton 42 84 81 62
9 Charlton Athletic Charlton 42 97 90 59
10 Plymouth Argyle Plymouth 42 81 82 59
11 Scunthorpe United Scunthorpe 42 69 64 57
12 Derby County Derby County 42 80 80 55
13 Luton Town Luton Town 42 70 79 54
14 Leeds United Leeds United 42 75 83 52
15 Bristol Rovers Bristol 42 73 92 52
16 Brighton & Hove Albion Brighton 42 61 75 51
17 Leyton Orient Leyton 42 55 78 50
18 Rotherham United Rotherham 42 65 64 49
19 Stoke City Stoke City 42 51 59 48
20 Huddersfield Town Huddersfield 42 62 71 48
21 Portsmouth Portsmouth 42 64 91 44
22 Lincoln City Lincoln City 42 48 95 32
TEMPORADA 1959/1960
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Aston Villa Aston Villa 42 89 43 84
2 Cardiff City Cardiff City 42 90 62 81
3 Liverpool Liverpool 42 90 66 70
4 Sheffield United Sheffield 42 68 51 69
5 Middlesbrough Middlesbroug 42 90 64 67
6 Huddersfield Town Huddersfield 42 73 52 66
7 Bristol Rovers Bristol 42 72 78 65
8 Charlton Athletic Charlton 42 90 87 64
9 Rotherham United Rotherham 42 61 60 64
10 Ipswich Town Ipswich Town 42 78 68 63
11 Leyton Orient Leyton 42 76 61 59
12 Swansea City Swansea City 42 82 84 55
13 Lincoln City Lincoln City 42 75 78 55
14 Brighton & Hove Albion Brighton 42 67 76 51
15 Scunthorpe United Scunthorpe 42 57 71 49
16 Derby County Derby County 42 61 77 49
17 Stoke City Stoke City 42 66 83 49
18 Sunderland Sunderland 42 52 65 48
19 Plymouth Argyle Plymouth 42 61 89 48
20 Portsmouth Portsmouth 42 59 77 42
21 Hull City Hull City 42 48 76 40
22 Bristol City Bristol City 42 60 97 38
TEMPORADA 1958/1959
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Sheffield Wednesday Sheffield 42 106 48 90
2 Fulham Fulham 42 96 61 87
3 Liverpool Liverpool 42 87 62 77
4 Sheffield United Sheffield 42 82 48 76
5 Stoke City Stoke City 42 72 58 70
6 Derby County Derby County 42 74 71 68
7 Bristol Rovers Bristol 42 80 64 66
8 Charlton Athletic Charlton 42 92 90 61
9 Cardiff City Cardiff City 42 65 65 61
10 Bristol City Bristol City 42 74 70 58
11 Swansea City Swansea City 42 79 81 57
12 Ipswich Town Ipswich Town 42 62 77 57
13 Huddersfield Town Huddersfield 42 62 55 56
14 Sunderland Sunderland 42 64 75 56
15 Brighton & Hove Albion Brighton 42 74 90 56
16 Middlesbrough Middlesbroug 42 87 71 55
17 Leyton Orient Leyton 42 71 78 50
18 Scunthorpe United Scunthorpe 42 55 84 45
19 Lincoln City Lincoln City 42 63 93 40
20 Rotherham United Rotherham 42 42 82 39
21 Grimsby Town Grimsby Town 42 62 90 37
22 Barnsley Barnsley 42 55 91 37

  USO DE MEMORIA  
8,528,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6833
Total Execution Time  0.6846
  CADENA URL  
/historico/Brighton-Amp-Hov/1990
  GET DATOS  
$_GET['/historico/Brighton-Amp-Hov/1990']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0141  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Brighton-Amp-Hov' AND l.year = 1990 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5652 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5652 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5652 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5652 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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 = 22826
0.0131  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 = 14682
0.0130  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 = 23234
0.0181  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '5652' AND l.year = 1990 ORDER BY l.year DESC,cat.coefficient DESC
0.0139  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 = '5652' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 22826 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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 = 23234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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 = 14682 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  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=5652 AND l.year in (1989,1990,1991) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (23236,22827,14683) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 22827 AND teamId = 5652
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 14683 AND teamId = 5652
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 23236 AND teamId = 5652
0.0138  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1990` 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 = 22826 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 events1990 e ON e.player_id = p.id AND e.league_id = 22826 WHERE rp.league_id = 22826 AND rp.teamId = 5652 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.0128  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 events1990 e ON e.player_id = p.id AND e.league_id = 22826 WHERE rp.league_id = 22826 AND rp.teamId = 5652 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events1990 e ON e.player_id = p.id AND e.league_id = 22826 WHERE rp.league_id = 22826 AND rp.teamId = 5652 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 5652 AND l.year <= 1990 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132  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 `tables1990` 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 = 22826 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables1989` 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 = 22827 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables1987` 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 = 23274 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables1986` 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 = 23273 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 `tables1984` 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 = 23265 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables1983` 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 = 5693 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables1982` 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 = 5692 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 `tables1981` 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 = 5691 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 `tables1980` 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 = 5690 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 `tables1979` 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 = 23322 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables1978` 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 = 23321 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables1973` 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 = 23316 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables1962` 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 = 23305 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 `tables1961` 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 = 23304 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables1960` 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 = 23303 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 23302 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 22826 ORDER BY nameShow LIMIT 100