4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1971/1972
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Derby County Derby County 42 69 33 58
2 Leeds United Leeds United 42 73 31 57
3 Liverpool Liverpool 42 64 30 57
4 Manchester City Manchester 42 77 45 57
5 Arsenal Arsenal 42 58 40 52
6 Tottenham Hotspur Tottenham 42 63 42 51
7 Chelsea Chelsea 42 58 49 48
8 Manchester United Manchester 42 69 61 48
9 Wolves Wolves 42 65 57 47
10 Sheffield United Sheffield 42 61 60 46
11 Newcastle Newcastle 42 49 52 41
12 Leicester Leicester 42 41 46 39
13 Ipswich Town Ipswich Town 42 39 53 38
14 West Ham West Ham 42 47 51 36
15 Everton Everton 42 37 48 36
16 West Bromwich Albion West 42 42 54 35
17 Stoke City Stoke City 42 39 56 35
18 Coventry City Coventry 42 44 67 33
19 Southampton Southampton 42 52 80 31
20 Crystal Palace Crystal 42 39 65 29
21 Nottingham Forest Nottingham 42 47 81 25
22 Huddersfield Town Huddersfield 42 27 59 25
TEMPORADA 1970/1971
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Arsenal Arsenal 42 71 29 65
2 Leeds United Leeds United 42 72 30 64
3 Tottenham Hotspur Tottenham 42 54 33 52
4 Wolves Wolves 42 64 54 52
5 Liverpool Liverpool 42 42 24 51
6 Chelsea Chelsea 42 52 42 51
7 Southampton Southampton 42 56 44 46
8 Manchester United Manchester 42 65 66 43
9 Derby County Derby County 42 56 54 42
10 Coventry City Coventry 42 37 38 42
11 Manchester City Manchester 42 47 42 41
12 Newcastle Newcastle 42 44 46 41
13 Stoke City Stoke City 42 44 48 37
14 Everton Everton 42 54 60 37
15 Huddersfield Town Huddersfield 42 40 49 36
16 Nottingham Forest Nottingham 42 42 61 36
17 West Bromwich Albion West 42 58 75 35
18 Crystal Palace Crystal 42 39 57 35
19 Ipswich Town Ipswich Town 42 42 48 34
20 West Ham West Ham 42 47 60 34
21 Burnley Burnley 42 29 63 27
22 Blackpool Blackpool 42 34 66 23
TEMPORADA 1969/1970
PREMIER LEAGUE
Equipo PJ GF GC Puntos
1 Everton Everton 42 72 34 66
2 Leeds United Leeds United 42 84 49 57
3 Chelsea Chelsea 42 70 50 55
4 Derby County Derby County 42 64 37 53
5 Liverpool Liverpool 42 65 42 51
6 Coventry City Coventry 42 58 48 49
7 Newcastle Newcastle 42 57 35 47
8 Manchester United Manchester 42 66 61 45
9 Stoke City Stoke City 42 56 52 45
10 Manchester City Manchester 42 55 48 43
11 Tottenham Hotspur Tottenham 42 54 55 43
12 Arsenal Arsenal 42 51 49 42
13 Wolves Wolves 42 55 57 40
14 Burnley Burnley 42 56 61 39
15 Nottingham Forest Nottingham 42 50 71 38
16 West Bromwich Albion West 42 58 66 37
17 West Ham West Ham 42 51 60 36
18 Ipswich Town Ipswich Town 42 40 63 31
19 Southampton Southampton 42 46 67 29
20 Crystal Palace Crystal 42 34 68 27
21 Sunderland Sunderland 42 30 68 26
22 Sheffield Wednesday Sheffield 42 40 71 25
TEMPORADA 1968/1969
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Derby County Derby County 42 65 32 89
2 Crystal Palace Crystal 42 70 47 78
3 Charlton Athletic Charlton 42 61 52 68
4 Middlesbrough Middlesbroug 42 58 49 68
5 Cardiff City Cardiff City 42 67 54 67
6 Huddersfield Town Huddersfield 42 53 46 63
7 Birmingham City Birmingham 42 73 59 62
8 Millwall Millwall 42 57 49 60
9 Sheffield United Sheffield 42 61 50 59
10 Carlisle United Carlisle 42 46 49 58
11 Blackpool Blackpool 42 51 41 57
12 Hull City Hull City 42 59 52 55
13 Norwich City Norwich City 42 53 56 55
14 Preston North End Preston 42 38 44 51
15 Portsmouth Portsmouth 42 58 58 50
16 Blackburn Rovers Blackburn 42 52 63 50
17 Aston Villa Aston Villa 42 37 48 50
18 Bolton Wanderers Bolton 42 55 67 50
19 Bristol City Bristol City 42 46 53 49
20 Oxford United Oxford 42 34 55 45
21 Bury Bury 42 51 80 41
22 Fulham Fulham 42 40 81 32
TEMPORADA 1967/1968
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Queens Park Rangers Queens Park 42 67 36 83
2 Blackpool Blackpool 42 71 43 82
3 Ipswich Town Ipswich Town 42 79 44 81
4 Birmingham City Birmingham 42 83 51 71
5 Portsmouth Portsmouth 42 68 55 67
6 Middlesbrough Middlesbroug 42 60 54 63
7 Millwall Millwall 42 62 50 59
8 Blackburn Rovers Blackburn 42 56 49 59
9 Norwich City Norwich City 42 60 65 59
10 Carlisle United Carlisle 42 58 52 55
11 Crystal Palace Crystal 42 56 56 53
12 Bolton Wanderers Bolton 42 60 63 52
13 Aston Villa Aston Villa 42 54 64 52
14 Cardiff City Cardiff City 42 60 66 51
15 Huddersfield Town Huddersfield 42 46 61 51
16 Charlton Athletic Charlton 42 63 68 49
17 Derby County Derby County 42 71 78 49
18 Bristol City Bristol City 42 48 62 49
19 Hull City Hull City 42 58 73 49
20 Preston North End Preston 42 43 65 47
21 Rotherham United Rotherham 42 42 76 41
22 Plymouth Argyle Plymouth 42 38 72 36
TEMPORADA 1966/1967
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Wolves Wolves 42 88 48 83
2 Coventry City Coventry 42 74 43 82
3 Carlisle United Carlisle 42 71 54 75
4 Blackburn Rovers Blackburn 42 56 46 70
5 Huddersfield Town Huddersfield 42 58 46 69
6 Ipswich Town Ipswich Town 42 70 54 67
7 Crystal Palace Crystal 42 61 55 67
8 Millwall Millwall 42 49 58 63
9 Bolton Wanderers Bolton 42 64 58 56
10 Birmingham City Birmingham 42 70 66 56
11 Hull City Hull City 42 77 72 55
12 Preston North End Preston 42 65 67 55
13 Norwich City Norwich City 42 49 55 53
14 Portsmouth Portsmouth 42 59 70 52
15 Plymouth Argyle Plymouth 42 59 58 51
16 Bristol City Bristol City 42 56 62 50
17 Rotherham United Rotherham 42 61 70 49
18 Derby County Derby County 42 68 72 48
19 Charlton Athletic Charlton 42 49 53 48
20 Cardiff City Cardiff City 42 61 87 45
21 Northampton Northampton 42 47 84 42
22 Bury Bury 42 49 83 39
TEMPORADA 1965/1966
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Manchester City Manchester 42 76 44 81
2 Southampton Southampton 42 85 56 76
3 Coventry City Coventry 42 73 53 73
4 Wolves Wolves 42 87 61 70
5 Huddersfield Town Huddersfield 42 62 36 70
6 Bristol City Bristol City 42 63 48 68
7 Rotherham United Rotherham 42 75 74 62
8 Derby County Derby County 42 71 68 59
9 Bolton Wanderers Bolton 42 62 59 57
10 Birmingham City Birmingham 42 70 75 57
11 Carlisle United Carlisle 42 60 63 56
12 Portsmouth Portsmouth 42 74 78 56
13 Crystal Palace Crystal 42 47 52 55
14 Ipswich Town Ipswich Town 42 58 66 54
15 Norwich City Norwich City 42 52 52 51
16 Charlton Athletic Charlton 42 61 70 50
17 Plymouth Argyle Plymouth 42 54 63 49
18 Bury Bury 42 62 76 49
19 Preston North End Preston 42 62 70 48
20 Cardiff City Cardiff City 42 71 91 46
21 Middlesbrough Middlesbroug 42 58 86 43
22 Leyton Orient Leyton 42 38 80 28
TEMPORADA 1964/1965
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Newcastle Newcastle 42 81 45 81
2 Northampton Northampton 42 66 50 76
3 Bolton Wanderers Bolton 42 80 58 70
4 Norwich City Norwich City 42 61 57 67
5 Southampton Southampton 42 83 63 65
6 Ipswich Town Ipswich Town 42 74 67 62
7 Crystal Palace Crystal 42 55 51 61
8 Huddersfield Town Huddersfield 42 53 51 61
9 Coventry City Coventry 42 72 70 60
10 Derby County Derby County 42 84 79 59
11 Manchester City Manchester 42 63 62 57
12 Plymouth Argyle Plymouth 42 63 79 56
13 Preston North End Preston 42 76 81 55
14 Rotherham United Rotherham 42 70 69 54
15 Cardiff City Cardiff City 42 64 57 53
16 Bury Bury 42 60 66 52
17 Middlesbrough Middlesbroug 42 70 76 48
18 Charlton Athletic Charlton 42 64 75 48
19 Swindon Town Swindon Town 42 63 81 47
20 Leyton Orient Leyton 42 50 72 47
21 Portsmouth Portsmouth 42 56 77 46
22 Swansea City Swansea City 42 62 84 43
TEMPORADA 1924/1925
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Leicester Leicester 42 90 32 83
2 Manchester United Manchester 42 57 23 80
3 Derby County Derby County 42 71 36 77
4 Wolves Wolves 42 55 51 66
5 Chelsea Chelsea 42 51 37 63
6 Portsmouth Portsmouth 42 58 50 63
7 Port Vale Port Vale 42 48 56 59
8 Southampton Southampton 42 40 36 57
9 Hull City Hull City 42 50 49 56
10 Fulham Fulham 42 41 56 55
11 Leyton Orient Leyton 42 42 42 54
12 South Shields South 42 42 38 53
13 Sheffield Wednesday Sheffield 42 50 56 53
14 Blackpool Blackpool 42 65 61 51
15 Barnsley Barnsley 42 46 59 51
16 Bradford City Bradford 42 37 50 51
17 Oldham Athletic AFC Oldham 42 35 51 50
18 Stockport County Stockport 42 37 57 50
19 Middlesbrough Middlesbroug 42 36 44 49
20 Stoke City Stoke City 42 34 46 47
21 Crystal Palace Crystal 42 38 54 46
22 Coventry City Coventry 42 45 84 42
TEMPORADA 1923/1924
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Leeds United Leeds United 42 61 35 75
2 Derby County Derby County 42 75 42 72
3 Bury Bury 42 63 35 72
4 Blackpool Blackpool 42 72 47 67
5 Southampton Southampton 42 52 31 65
6 South Shields South 42 49 50 61
7 Sheffield Wednesday Sheffield 42 54 51 60
8 Stoke City Stoke City 42 44 42 60
9 Leicester Leicester 42 64 54 59
10 Barnsley Barnsley 42 57 61 59
11 Oldham Athletic AFC Oldham 42 45 52 59
12 Leyton Orient Leyton 42 40 36 57
13 Stockport County Stockport 42 44 52 55
14 Manchester United Manchester 42 52 44 53
15 Crystal Palace Crystal 42 53 65 52
16 Port Vale Port Vale 42 50 66 51
17 Bradford City Bradford 42 35 48 48
18 Hull City Hull City 42 46 51 47
19 Coventry City Coventry 42 52 68 46
20 Fulham Fulham 42 45 56 44
21 Nelson Nelson 42 40 74 43
22 Bristol City Bristol City 42 32 65 36
TEMPORADA 1921/1922
CHAMPIONSHIP
Equipo PJ GF GC Puntos
1 Nottingham Forest Nottingham 42 51 30 78
2 Barnsley Barnsley 42 67 52 74
3 Stoke City Stoke City 42 60 44 70
4 West Ham West Ham 42 52 39 68
5 Hull City Hull City 42 51 41 67
6 Fulham Fulham 42 57 38 63
7 South Shields South 42 43 38 63
8 Leeds United Leeds United 42 48 38 61
9 Leicester Leicester 42 39 34 59
10 Sheffield Wednesday Sheffield 42 47 50 59
11 Bury Bury 42 54 55 55
12 Derby County Derby County 42 60 64 54
13 Leyton Orient Leyton 42 43 50 54
14 Rotherham United Rotherham 42 32 43 53
15 Crystal Palace Crystal 42 45 51 52
16 Notts County Notts County 42 47 51 51
17 Wolves Wolves 42 44 49 50
18 Blackpool Blackpool 42 44 57 50
19 Port Vale Port Vale 42 43 57 50
20 Coventry City Coventry 42 51 60 46
21 Bradford Park Avenue Bradford 42 46 62 45
22 Bristol City Bristol City 42 37 58 45

  USO DE MEMORIA  
6,921,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5825
Total Execution Time  0.5837
  CADENA URL  
/historico/Crystal-Palace-Fc/1972
  GET DATOS  
$_GET['/historico/Crystal-Palace-Fc/1972']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0168  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 = 'Crystal-Palace-Fc' AND l.year = 1972 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.0146  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=860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292  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 = 5682
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=860 AND type_rel = 2
0.0166  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 860 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (1254444,2190,3300,4711,1312842) ORDER BY n.cover_points DESC, update_date DESC
0.0157  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 = '860' AND l.year = 1972 ORDER BY l.year DESC,cat.coefficient DESC
0.0159  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 = '860' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 5682 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0174  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=860 AND l.year in (1971,1972,1973) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (23206,5683) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 5683 AND teamId = 860
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 23206 AND teamId = 860
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 FROM `tables1972` 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 = 5682 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0159  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 events1972 e ON e.player_id = p.id AND e.league_id = 5682 WHERE rp.league_id = 5682 AND rp.teamId = 860 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.0151  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 events1972 e ON e.player_id = p.id AND e.league_id = 5682 WHERE rp.league_id = 5682 AND rp.teamId = 860 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 events1972 e ON e.player_id = p.id AND e.league_id = 5682 WHERE rp.league_id = 5682 AND rp.teamId = 860 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 860 AND l.year <= 1972 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0154  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 `tables1972` 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 = 5682 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 `tables1971` 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 = 5681 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1970` 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 = 5680 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1969` 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 = 23312 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1968` 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 = 23311 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 `tables1967` 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 = 23310 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 `tables1965` 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 = 23308 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1925` 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 = 23331 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1924` 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 = 23330 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1922` 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 = 23328 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC