4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Wigan Athletic

Wigan Athletic

Entrenador: Shaun Maloney

Temporada 2002/2003
TEMPORADA 2002/2003
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Wigan Athletic Wigan 46 68 25 100
2 Crewe Alexandra Crewe 46 76 40 86
3 Bristol City Bristol City 46 79 48 83
4 Queens Park Rangers Queens Park 46 69 45 83
5 Oldham Athletic AFC Oldham 46 68 38 82
6 Cardiff City Cardiff City 46 68 43 81
7 Tranmere Rovers Tranmere 46 66 57 80
8 Plymouth Argyle Plymouth 46 63 52 65
9 Luton Town Luton Town 46 67 62 65
10 Swindon Town Swindon Town 46 59 63 60
11 Peterborough United Peterborough 46 51 54 58
12 Colchester United Colchester 46 52 56 58
13 Blackpool Blackpool 46 56 64 58
14 Stockport County Stockport 46 65 70 55
15 Notts County Notts County 46 62 70 55
16 Brentford Brentford 46 47 56 54
17 Port Vale Port Vale 46 54 70 53
18 Wycombe Wanderers Wycombe 46 59 66 52
19 Barnsley Barnsley 46 51 64 52
20 Chesterfield Chesterfield 46 43 73 50
21 Cheltenham Town Cheltenham 46 53 68 48
22 Huddersfield Town Huddersfield 46 39 61 45
23 Mansfield Town Mansfield 46 66 97 44
24 Northampton Northampton 46 40 79 39
TEMPORADA 2001/2002
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Brighton & Hove Albion Brighton 46 66 42 90
2 Reading Reading 46 70 43 84
3 Brentford Brentford 46 77 43 83
4 Cardiff City Cardiff City 46 75 50 83
5 Stoke City Stoke City 46 67 40 80
6 Huddersfield Town Huddersfield 46 65 47 78
7 Bristol City Bristol City 46 68 53 73
8 Queens Park Rangers Queens Park 46 60 49 71
9 Oldham Athletic AFC Oldham 46 77 65 70
10 Wigan Athletic Wigan 46 66 51 64
11 Wycombe Wanderers Wycombe 46 58 64 64
12 Tranmere Rovers Tranmere 46 63 60 63
13 Swindon Town Swindon Town 46 46 56 59
14 Port Vale Port Vale 46 51 62 58
15 Colchester United Colchester 46 65 76 57
16 Blackpool Blackpool 46 66 69 56
17 Peterborough United Peterborough 46 64 59 55
18 Chesterfield Chesterfield 46 53 65 52
19 Notts County Notts County 46 59 71 50
20 Northampton Northampton 46 54 79 49
21 AFC Bournemouth Bournemouth 46 56 71 44
22 Bury Bury 46 43 75 44
23 Wrexham AFC Wrexham AFC 46 56 89 43
24 Cambridge United Cambridge 46 47 93 34
TEMPORADA 2000/2001
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Millwall Millwall 46 89 38 93
2 Rotherham United Rotherham 46 79 55 91
3 Reading Reading 46 86 52 86
4 Walsall Walsall 46 79 50 81
5 Stoke City Stoke City 46 74 49 77
6 Wigan Athletic Wigan 46 53 42 75
7 AFC Bournemouth Bournemouth 46 79 55 73
8 Notts County Notts County 46 62 66 69
9 Bristol City Bristol City 46 70 56 68
10 Wrexham AFC Wrexham AFC 46 65 71 63
11 Port Vale Port Vale 46 55 49 62
12 Peterborough United Peterborough 46 61 66 59
13 Wycombe Wanderers Wycombe 46 46 53 59
14 Brentford Brentford 46 56 70 59
15 Oldham Athletic AFC Oldham 46 53 65 58
16 Bury Bury 46 45 59 58
17 Colchester United Colchester 46 55 59 57
18 Northampton Northampton 46 46 59 57
19 Cambridge United Cambridge 46 61 77 53
20 Swindon Town Swindon Town 46 47 65 52
21 Bristol Rovers Bristol 46 53 57 51
22 Luton Town Luton Town 46 52 80 40
23 Swansea City Swansea City 46 47 73 37
24 Oxford City Oxford City 46 53 100 27
TEMPORADA 1999/2000
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Preston North End Preston 46 74 37 95
2 Burnley Burnley 46 69 47 88
3 Gillingham Gillingham 46 79 48 85
4 Wigan Athletic Wigan 46 72 38 83
5 Millwall Millwall 46 76 50 82
6 Stoke City Stoke City 46 68 42 82
7 Bristol Rovers Bristol 46 69 45 80
8 Notts County Notts County 46 61 55 65
9 Bristol City Bristol City 46 59 57 64
10 Reading Reading 46 57 63 62
11 Wrexham AFC Wrexham AFC 46 52 61 62
12 Wycombe Wanderers Wycombe 46 56 53 61
13 Luton Town Luton Town 46 61 65 61
14 Oldham Athletic AFC Oldham 46 50 55 60
15 Bury Bury 46 61 64 57
16 AFC Bournemouth Bournemouth 46 59 62 57
17 Brentford Brentford 46 47 61 52
18 Colchester United Colchester 46 59 82 52
19 Cambridge United Cambridge 46 64 65 48
20 Oxford City Oxford City 46 43 73 45
21 Cardiff City Cardiff City 46 45 67 44
22 Blackpool Blackpool 46 49 77 41
23 Scunthorpe United Scunthorpe 46 40 74 39
24 Chesterfield Chesterfield 46 34 63 36
TEMPORADA 1998/1999
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Fulham Fulham 46 79 32 101
2 Walsall Walsall 46 63 47 87
3 Manchester City Manchester 46 69 33 82
4 Gillingham Gillingham 46 76 44 80
5 Preston North End Preston 46 78 50 79
6 Wigan Athletic Wigan 46 75 49 76
7 AFC Bournemouth Bournemouth 46 63 41 76
8 Stoke City Stoke City 46 59 63 69
9 Chesterfield Chesterfield 46 46 45 64
10 Millwall Millwall 46 52 59 62
11 Reading Reading 46 54 63 61
12 Luton Town Luton Town 46 51 60 58
13 Bristol Rovers Bristol 46 65 56 56
14 Blackpool Blackpool 46 44 54 56
15 Burnley Burnley 46 54 73 55
16 Notts County Notts County 46 53 61 54
17 Wrexham AFC Wrexham AFC 46 43 62 53
18 Colchester United Colchester 46 52 70 52
19 Wycombe Wanderers Wycombe 46 52 58 51
20 Oldham Athletic AFC Oldham 46 48 66 51
21 York City York City 46 56 80 50
22 Northampton Northampton 46 43 57 48
23 Lincoln City Lincoln City 46 42 74 46
24 Macclesfield Town Macclesfield 46 43 63 43
TEMPORADA 1997/1998
LEAGUE ONE
Equipo PJ GF GC Puntos
1 Watford Watford 43 66 38 86
2 Bristol City Bristol City 39 58 31 73
3 Grimsby Town Grimsby Town 42 51 31 68
4 Fulham Fulham 37 49 31 64
5 Northampton Northampton 41 46 34 61
6 Bristol Rovers Bristol 40 57 51 61
7 Gillingham Gillingham 39 47 38 60
8 Wrexham AFC Wrexham AFC 41 49 49 57
9 Chesterfield Chesterfield 38 40 33 55
10 Blackpool Blackpool 42 53 62 55
11 Oldham Athletic AFC Oldham 41 51 46 53
12 Wigan Athletic Wigan 41 57 63 52
13 Wycombe Wanderers Wycombe 40 48 51 51
14 AFC Bournemouth Bournemouth 36 42 39 50
15 York City York City 38 42 46 49
16 Walsall Walsall 40 38 45 48
17 Preston North End Preston 38 45 48 46
18 Burnley Burnley 42 51 61 46
19 Plymouth Argyle Plymouth 42 52 63 46
20 Brentford Brentford 39 41 61 43
21 Millwall Millwall 37 31 43 42
22 Carlisle United Carlisle 40 54 61 41
23 Southend United Southend 41 37 67 38
24 Luton Town Luton Town 35 42 55 37
TEMPORADA 1996/1997
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Fulham Fulham 43 70 36 83
2 Wigan Athletic Wigan 43 77 47 81
3 Carlisle United Carlisle 40 59 43 70
4 Chester City FC Chester City 43 52 38 67
5 Swansea City Swansea City 43 58 53 65
6 Colchester United Colchester 43 55 48 64
7 Cardiff City Cardiff City 42 53 51 64
8 Lincoln City Lincoln City 42 63 56 62
9 Scarborough Scarborough 43 64 65 61
10 Cambridge United Cambridge 42 50 53 61
11 Scunthorpe United Scunthorpe 42 56 57 59
12 Northampton Northampton 39 52 36 58
13 Mansfield Town Mansfield 40 40 37 56
14 Barnet Barnet 42 45 49 55
15 Leyton Orient Leyton 41 45 50 55
16 Rochdale Rochdale 40 49 52 49
17 Doncaster Rovers Doncaster 39 48 56 48
18 Brighton & Hove Albion Brighton 41 49 60 45
19 Hereford United Hereford 42 47 60 44
20 Hull City Hull City 40 32 44 43
21 Hartlepool United Hartlepool 40 45 59 43
22 Darlington FC Darlington 41 54 72 43
23 Torquay United Torquay 43 40 58 43
24 Exeter City Exeter City 42 43 66 43
TEMPORADA 1995/1996
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Preston North End Preston 43 75 31 85
2 Gillingham Gillingham 43 45 19 76
3 Plymouth Argyle Plymouth 44 64 45 75
4 Darlington FC Darlington 44 59 41 75
5 Bury Bury 42 61 43 74
6 Colchester United Colchester 43 56 46 68
7 Barnet Barnet 43 60 39 66
8 Hereford United Hereford 39 53 37 65
9 Wigan Athletic Wigan 42 57 52 63
10 Chester City FC Chester City 41 59 50 59
11 Scunthorpe United Scunthorpe 40 63 50 58
12 Northampton Northampton 39 39 42 52
13 Doncaster Rovers Doncaster 40 40 53 48
14 Mansfield Town Mansfield 40 47 55 47
15 Exeter City Exeter City 41 42 51 47
16 Lincoln City Lincoln City 42 50 63 47
17 Hartlepool United Hartlepool 42 45 60 47
18 Rochdale Rochdale 41 49 55 46
19 Cambridge United Cambridge 39 48 55 46
20 Fulham Fulham 42 47 58 46
21 Cardiff City Cardiff City 41 35 48 44
22 Scarborough Scarborough 43 37 63 39
23 Leyton Orient Leyton 40 34 57 37
24 Torquay United Torquay 44 29 81 29
TEMPORADA 1994/1995
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Walsall Walsall 32 61 29 69
2 Carlisle United Carlisle 32 50 22 66
3 Chesterfield Chesterfield 32 51 27 65
4 Mansfield Town Mansfield 33 74 49 54
5 Bury Bury 31 54 35 54
6 Preston North End Preston 32 44 30 53
7 Fulham Fulham 32 51 41 52
8 Wigan Athletic Wigan 32 45 40 48
9 Scunthorpe United Scunthorpe 32 51 50 46
10 Doncaster Rovers Doncaster 32 48 38 43
11 Lincoln City Lincoln City 32 41 42 43
12 Colchester United Colchester 32 43 48 42
13 Torquay United Torquay 32 38 43 40
14 Hereford United Hereford 31 34 45 39
15 Barnet Barnet 31 39 53 35
16 Hartlepool United Hartlepool 32 38 57 35
17 Northampton Northampton 32 35 55 35
18 Gillingham Gillingham 32 36 47 33
19 Rochdale Rochdale 32 26 50 31
20 Darlington FC Darlington 31 31 44 27
21 Scarborough Scarborough 32 39 55 24
22 Exeter City Exeter City 31 28 57 20
TEMPORADA 1993/1994
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Shrewsbury Town Shrewsbury 37 59 36 71
2 Crewe Alexandra Crewe 40 76 59 67
3 Preston North End Preston 39 73 54 64
4 Chester Chester 37 61 41 63
5 Torquay United Torquay 40 63 56 63
6 Wycombe Wanderers Wycombe 39 60 50 61
7 Carlisle United Carlisle 39 51 39 58
8 Rochdale Rochdale 41 61 51 57
9 Walsall Walsall 39 47 47 57
10 Chesterfield Chesterfield 37 49 41 53
11 Bury Bury 40 53 53 52
12 Scarborough Scarborough 39 53 58 50
13 Mansfield Town Mansfield 39 49 59 49
14 Doncaster Rovers Doncaster 40 40 54 49
15 Scunthorpe United Scunthorpe 33 50 45 46
16 Colchester United Colchester 39 54 65 46
17 Gillingham Gillingham 37 36 44 44
18 Lincoln City Lincoln City 39 48 59 44
19 Darlington FC Darlington 39 40 56 41
20 Wigan Athletic Wigan 39 47 67 41
21 Hereford United Hereford 38 56 73 39
22 Northampton Northampton 36 40 59 34

  USO DE MEMORIA  
7,163,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6267
Total Execution Time  0.6278
  CADENA URL  
/historico/Wigan-Athletic/2003
  GET DATOS  
$_GET['/historico/Wigan-Athletic/2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0163  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 = 'Wigan-Athletic' AND l.year = 2003 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.0145  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=2753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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 = 481
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2753 AND type_rel = 2
0.0154  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2753 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0154  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 (718,982,1146,2958,3394) ORDER BY n.cover_points DESC, update_date DESC
0.0246  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 = '2753' AND l.year = 2003 ORDER BY l.year DESC,cat.coefficient DESC
0.0153  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 = '2753' 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 = 481 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  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=2753 AND l.year in (2002,2003,2004) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (23226,14435,482,464) 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.0161  SELECT count(id) as num_players from rel_players WHERE league_id = 464 AND teamId = 2753
0.0214  SELECT count(id) as num_players from rel_players WHERE league_id = 482 AND teamId = 2753
0.0182  SELECT count(id) as num_players from rel_players WHERE league_id = 14435 AND teamId = 2753
0.0183  SELECT count(id) as num_players from rel_players WHERE league_id = 23226 AND teamId = 2753
0.0159  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2753' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2753' and rp.type = 4
0.0160  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2753' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0149  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2753' and rp.type = 4
0.0217  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 events2003 e ON e.player_id = p.id AND e.league_id = 481 WHERE rp.league_id = 481 AND rp.teamId = 2753 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.0230  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 events2003 e ON e.player_id = p.id AND e.league_id = 481 WHERE rp.league_id = 481 AND rp.teamId = 2753 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 events2003 e ON e.player_id = p.id AND e.league_id = 481 WHERE rp.league_id = 481 AND rp.teamId = 2753 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 2753 AND l.year <= 2003 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 `tables1998` 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 = 486 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables1997` 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 = 502 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1996` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 503 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 `tables1995` 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 = 504 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1994` 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 = 505 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC