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

Sparta Praha

Entrenador: Brian Priske

Temporada 2002/2003
TEMPORADA 2002/2003
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 51 17 65
2 Slavia Praha Slavia Praha 30 65 19 64
3 Viktoria Žižkov Viktoria 30 38 33 50
4 Slovan Liberec Slovan 30 43 36 50
5 Baník Ostrava Baník 30 41 38 45
6 Teplice Teplice 30 33 32 45
7 FC Trinity Zlín Trinity 30 34 41 42
8 Synot Synot 30 39 40 40
9 Zbrojovka Brno Zbrojovka 30 35 31 39
10 Pribram Pribram 30 34 30 39
11 Sigma Olomouc Sigma 30 29 33 34
12 Jablonec Jablonec 30 29 39 34
13 České Budějovice České 30 36 54 30
14 Chmel Blšany Chmel 30 28 39 28
15 Bohemians 1905 Bohemians 30 34 56 24
16 Hradec Králové Hradec 30 23 54 22
TEMPORADA 2001/2002
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slovan Liberec Slovan 30 55 26 64
2 Sparta Praha Sparta Praha 30 55 19 63
3 Viktoria Žižkov Viktoria 30 42 20 63
4 Bohemians 1905 Bohemians 30 40 35 48
5 Slavia Praha Slavia Praha 30 45 34 47
6 Baník Ostrava Baník 30 43 36 44
7 Teplice Teplice 30 37 41 41
8 Zbrojovka Brno Zbrojovka 30 34 42 40
9 Jablonec Jablonec 30 35 33 40
10 Sigma Olomouc Sigma 30 29 31 37
11 Synot Synot 30 31 38 36
12 Hradec Králové Hradec 30 28 42 35
13 Pribram Pribram 30 27 39 34
14 Chmel Blšany Chmel 30 35 51 29
15 Drnovice Drnovice 30 31 45 26
16 SFC Opava SFC Opava 30 23 58 18
TEMPORADA 2000/2001
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 71 31 68
2 Slavia Praha Slavia Praha 30 46 32 52
3 Sigma Olomouc Sigma 30 47 33 52
4 Pribram Pribram 30 40 26 51
5 Viktoria Žižkov Viktoria 30 45 40 46
6 Slovan Liberec Slovan 30 39 31 45
7 Drnovice Drnovice 30 35 36 41
8 Bohemians 1905 Bohemians 30 33 34 40
9 Teplice Teplice 30 45 39 40
10 Chmel Blšany Chmel 30 35 35 40
11 Synot Synot 30 37 35 37
12 Jablonec Jablonec 30 26 40 32
13 Zbrojovka Brno Zbrojovka 30 24 35 30
14 Baník Ostrava Baník 30 28 45 30
15 České Budějovice České 30 32 56 26
16 Viktoria Plzeň Viktoria 30 30 65 21
TEMPORADA 1999/2000
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 81 23 76
2 Slavia Praha Slavia Praha 30 53 25 68
3 Drnovice Drnovice 30 36 32 48
4 Zbrojovka Brno Zbrojovka 30 35 33 42
5 Teplice Teplice 30 38 38 41
6 Pribram Pribram 30 33 36 40
7 Bohemians 1905 Bohemians 30 24 28 40
8 Slovan Liberec Slovan 30 21 24 38
9 Viktoria Žižkov Viktoria 30 37 41 37
10 Chmel Blšany Chmel 30 28 45 37
11 Baník Ostrava Baník 30 43 45 35
12 Sigma Olomouc Sigma 30 31 38 34
13 Jablonec Jablonec 30 24 36 32
14 České Budějovice České 30 34 49 32
15 SFC Opava SFC Opava 30 31 39 28
16 Hradec Králové Hradec 30 21 38 23
TEMPORADA 1998/1999
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 62 23 60
2 Teplice Teplice 30 55 30 55
3 Slavia Praha Slavia Praha 30 51 31 55
4 Sigma Olomouc Sigma 30 42 34 47
5 Baník Ostrava Baník 30 39 26 45
6 Chmel Blšany Chmel 30 48 44 42
7 Zbrojovka Brno Zbrojovka 30 37 33 41
8 Hradec Králové Hradec 30 33 40 39
9 Slovan Liberec Slovan 30 33 34 38
10 Viktoria Žižkov Viktoria 30 31 47 38
11 Drnovice Drnovice 30 35 44 37
12 Jablonec Jablonec 30 37 46 35
13 Pribram Pribram 30 28 41 33
14 SFC Opava SFC Opava 30 40 54 32
15 Viktoria Plzeň Viktoria 30 26 43 32
16 Karviná Karviná 30 28 55 23
TEMPORADA 1997/1998
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 53 19 71
2 Slavia Praha Slavia Praha 30 42 22 59
3 Sigma Olomouc Sigma 30 38 21 55
4 Baník Ostrava Baník 30 51 35 50
5 Slovan Liberec Slovan 30 39 32 47
6 Jablonec Jablonec 30 47 33 46
7 Teplice Teplice 30 36 30 40
8 Viktoria Žižkov Viktoria 30 26 34 39
9 Drnovice Drnovice 30 35 43 38
10 Zbrojovka Brno Zbrojovka 30 42 42 37
11 SFC Opava SFC Opava 30 33 37 34
12 Hradec Králové Hradec 30 25 36 34
13 Viktoria Plzeň Viktoria 30 37 47 33
14 Pribram Pribram 30 37 50 33
15 České Budějovice České 30 26 43 31
16 Bohdanec Bohdanec 30 18 61 11
TEMPORADA 1996/1997
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 61 20 65
2 Slavia Praha Slavia Praha 30 59 24 61
3 Jablonec Jablonec 30 40 29 56
4 Zbrojovka Brno Zbrojovka 30 44 35 52
5 Slovan Liberec Slovan 30 33 30 46
6 České Budějovice České 30 38 40 44
7 Drnovice Drnovice 30 53 44 43
8 Sigma Olomouc Sigma 30 36 30 40
9 SFC Opava SFC Opava 30 34 35 40
10 Baník Ostrava Baník 30 33 35 37
11 Viktoria Plzeň Viktoria 30 33 37 32
12 Viktoria Žižkov Viktoria 30 17 33 29
13 Teplice Teplice 30 21 37 28
14 Hradec Králové Hradec 30 22 39 28
15 Karviná Karviná 30 25 50 25
16 Bohemians 1905 Bohemians 30 22 53 19
TEMPORADA 1995/1996
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 68 28 70
2 Sigma Olomouc Sigma 30 54 33 61
3 Jablonec Jablonec 30 45 26 53
4 Sparta Praha Sparta Praha 30 56 35 49
5 Drnovice Drnovice 30 53 40 48
6 SFC Opava SFC Opava 30 40 34 46
7 Slovan Liberec Slovan 30 34 30 44
8 Zbrojovka Brno Zbrojovka 30 39 42 43
9 Viktoria Plzeň Viktoria 30 33 34 39
10 Viktoria Žižkov Viktoria 30 38 43 37
11 České Budějovice České 30 35 47 37
12 Baník Ostrava Baník 30 40 46 35
13 Union Cheb Union Cheb 30 35 47 33
14 Hradec Králové Hradec 30 28 46 29
15 FC Trinity Zlín Trinity 30 17 38 27
16 Hradiste Hradiste 30 19 65 17
TEMPORADA 1994/1995
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 64 17 70
2 Slavia Praha Slavia Praha 30 52 20 64
3 Zbrojovka Brno Zbrojovka 30 52 27 54
4 Slovan Liberec Slovan 30 49 46 51
5 Viktoria Žižkov Viktoria 30 61 38 49
6 Drnovice Drnovice 30 46 44 48
7 České Budějovice České 30 29 28 46
8 Sigma Olomouc Sigma 30 31 31 43
9 Viktoria Plzeň Viktoria 30 32 37 40
10 Jablonec Jablonec 29 36 32 38
11 Baník Ostrava Baník 30 36 41 38
12 Hradec Králové Hradec 29 34 44 35
13 Union Cheb Union Cheb 30 29 45 31
14 FC Trinity Zlín Trinity 30 21 40 30
15 Bohemians 1905 Bohemians 30 35 62 23
16 Benešov Benešov 30 23 78 12
TEMPORADA 1993/1994
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 62 21 45
2 Slavia Praha Slavia Praha 30 55 28 39
3 Baník Ostrava Baník 30 52 25 36
4 Union Cheb Union Cheb 30 31 29 36
5 Viktoria Plzeň Viktoria 30 35 23 35
6 České Budějovice České 30 33 31 35
7 Sigma Olomouc Sigma 30 44 29 34
8 Viktoria Žižkov Viktoria 30 40 28 33
9 Slovan Liberec Slovan 30 36 32 32
10 Drnovice Drnovice 30 38 36 32
11 FC Trinity Zlín Trinity 30 37 48 27
12 Zbrojovka Brno Zbrojovka 30 38 46 26
13 Hradec Králové Hradec 30 29 40 24
14 Bohemians 1905 Bohemians 30 29 54 23
15 Vitkovice Vitkovice 30 22 64 13
16 FK Dukla Praha Dukla Praha 30 21 68 10

  USO DE MEMORIA  
6,766,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.7599
Total Execution Time  0.7612
  CADENA URL  
/historico/Sparta-Praha/2003
  GET DATOS  
$_GET['/historico/Sparta-Praha/2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0182  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 = 'Sparta-Praha' 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.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=10050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=10050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=10050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=10050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=10050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=10050 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0162  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 = 10977
0.0155  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 = 8751
0.0155  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 = 40743
0.0153  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 = 40745
0.0154  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 = 27550
0.0163  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 = '10050' AND l.year = 2003 ORDER BY l.year DESC,cat.coefficient DESC
0.0174  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 = '10050' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153  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 = 40745 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  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 = 27550 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0173  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 = 10977 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  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 = 8751 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0209  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=10050 AND l.year in (2002,2003,2004) ORDER BY l.id DESC, l.year DESC ;
0.0158  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 (40745,27551,10977,9665,8752) 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.0185  SELECT count(id) as num_players from rel_players WHERE league_id = 8752 AND teamId = 10050
0.0191  SELECT count(id) as num_players from rel_players WHERE league_id = 9665 AND teamId = 10050
0.0192  SELECT count(id) as num_players from rel_players WHERE league_id = 10977 AND teamId = 10050
0.0172  SELECT count(id) as num_players from rel_players WHERE league_id = 40745 AND teamId = 10050
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 27551 AND teamId = 10050
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 FROM `tables2003` 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 = 10977 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0208  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 = 10977 WHERE rp.league_id = 10977 AND rp.teamId = 10050 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.0172  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 = 10977 WHERE rp.league_id = 10977 AND rp.teamId = 10050 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 = 10977 WHERE rp.league_id = 10977 AND rp.teamId = 10050 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161  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 = 10050 AND l.year <= 2003 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2003` 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 = 8751 AND t.round = 30 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 `tables2002` 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 = 8752 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 `tables2001` 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 = 8753 AND t.round = 30 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 `tables2000` 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 = 8754 AND t.round = 30 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 `tables1999` 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 = 8755 AND t.round = 30 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 `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 = 8756 AND t.round = 30 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 `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 = 8757 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 `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 = 8758 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 8759 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 10676 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC