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 2023/2024
TEMPORADA 2023/2024
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 29 66 25 73
2 Slavia Praha Slavia Praha 29 60 22 69
3 Viktoria Plzeň Viktoria 29 64 33 59
4 Baník Ostrava Baník 29 46 37 44
5 Mladá Boleslav Mladá 29 49 45 43
6 Slovácko Slovácko 29 37 38 40
7 Slovan Liberec Slovan 29 44 44 39
8 Sigma Olomouc Sigma 29 39 41 37
9 Hradec Králové Hradec 29 31 36 37
10 Teplice Teplice 29 31 37 36
11 Bohemians 1905 Bohemians 29 27 39 32
12 Jablonec Jablonec 29 34 44 29
13 Pardubice Pardubice 29 28 40 28
14 FC Trinity Zlín Trinity 29 36 60 25
15 České Budějovice České 29 32 60 23
16 Karviná Karviná 29 29 52 22
TEMPORADA 2022/2023
LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 35 76 33 78
2 Slavia Praha Slavia Praha 35 98 31 78
3 Viktoria Plzeň Viktoria 35 60 38 61
4 Bohemians 1905 Bohemians 35 56 58 52
5 Slovácko Slovácko 35 40 46 50
6 Sigma Olomouc Sigma 35 53 47 48
TEMPORADA 2021/2022
LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 35 63 21 85
2 Slavia Praha Slavia Praha 35 80 27 78
3 Sparta Praha Sparta Praha 35 72 40 73
4 Slovácko Slovácko 35 59 38 68
5 Baník Ostrava Baník 35 60 48 55
6 Hradec Králové Hradec 35 44 52 44
TEMPORADA 2020/2021
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 34 85 20 86
2 Sparta Praha Sparta Praha 34 82 43 74
3 Jablonec Jablonec 34 59 33 69
4 Slovácko Slovácko 34 58 33 63
5 Viktoria Plzeň Viktoria 34 60 45 58
6 Slovan Liberec Slovan 34 44 32 52
7 Pardubice Pardubice 34 41 42 52
8 Baník Ostrava Baník 34 48 38 49
9 Sigma Olomouc Sigma 34 40 40 45
10 Bohemians 1905 Bohemians 34 40 37 43
11 Mladá Boleslav Mladá 34 49 54 39
12 Karviná Karviná 34 37 49 39
13 České Budějovice České 34 33 47 38
14 FC Trinity Zlín Trinity 34 30 50 32
15 Teplice Teplice 34 34 66 30
16 Zbrojovka Brno Zbrojovka 34 33 57 26
17 Pribram Pribram 34 26 65 25
18 SFC Opava SFC Opava 34 23 71 17
TEMPORADA 2019/2020
LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 5 11 2 85
2 Viktoria Plzeň Viktoria 5 8 2 76
3 Sparta Praha Sparta Praha 5 11 5 60
4 Slovan Liberec Slovan 5 5 13 51
5 Jablonec Jablonec 5 2 11 51
6 Baník Ostrava Baník 5 5 9 47
TEMPORADA 2018/2019
LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 5 7 3 83
2 Viktoria Plzeň Viktoria 5 10 5 78
3 Sparta Praha Sparta Praha 5 7 6 66
4 Jablonec Jablonec 5 5 6 57
5 Baník Ostrava Baník 5 1 7 47
6 Slovan Liberec Slovan 5 1 4 46
TEMPORADA 2017/2018
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 55 23 66
2 Slavia Praha Slavia Praha 30 50 19 59
3 Jablonec Jablonec 30 49 27 56
4 Sigma Olomouc Sigma 30 41 22 55
5 Sparta Praha Sparta Praha 30 43 25 53
6 Slovan Liberec Slovan 30 37 35 46
7 Bohemians 1905 Bohemians 30 30 29 38
8 Mladá Boleslav Mladá 30 31 43 34
9 Teplice Teplice 30 32 40 34
10 FC Trinity Zlín Trinity 30 31 48 33
11 FK Dukla Praha Dukla Praha 30 32 55 32
12 Slovácko Slovácko 30 23 32 31
13 Baník Ostrava Baník 30 36 43 31
14 Karviná Karviná 30 32 40 30
15 Vysocina Jihlava Vysocina 30 30 48 30
16 Zbrojovka Brno Zbrojovka 30 20 43 24
TEMPORADA 2016/2017
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 65 22 69
2 Viktoria Plzeň Viktoria 30 47 21 67
3 Sparta Praha Sparta Praha 30 47 26 57
4 Mladá Boleslav Mladá 30 47 37 49
5 Teplice Teplice 30 38 25 48
6 FC Trinity Zlín Trinity 30 34 35 41
7 FK Dukla Praha Dukla Praha 30 39 35 40
8 Jablonec Jablonec 30 43 38 39
9 Slovan Liberec Slovan 30 31 28 39
10 Karviná Karviná 30 39 49 34
11 Slovácko Slovácko 30 29 38 32
12 Zbrojovka Brno Zbrojovka 30 32 45 32
13 Bohemians 1905 Bohemians 30 22 39 28
14 Vysocina Jihlava Vysocina 30 26 47 27
15 Hradec Králové Hradec 30 29 51 27
16 Pribram Pribram 30 29 61 22
TEMPORADA 2015/2016
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 57 25 71
2 Sparta Praha Sparta Praha 30 61 24 64
3 Slovan Liberec Slovan 30 51 35 58
4 Mladá Boleslav Mladá 30 63 37 57
5 Slavia Praha Slavia Praha 30 48 26 52
6 Zbrojovka Brno Zbrojovka 30 37 38 47
7 Jablonec Jablonec 30 46 39 41
8 Slovácko Slovácko 30 37 51 40
9 Bohemians 1905 Bohemians 30 35 37 37
10 FK Dukla Praha Dukla Praha 30 44 41 35
11 Vysocina Jihlava Vysocina 30 31 54 31
12 Teplice Teplice 30 37 52 30
13 FC Trinity Zlín Trinity 30 34 50 30
14 Sigma Olomouc Sigma 30 35 49 27
15 Pribram Pribram 30 33 53 27
16 Baník Ostrava Baník 30 27 65 14
TEMPORADA 2014/2015
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 70 24 72
2 Sparta Praha Sparta Praha 30 57 20 67
3 Jablonec Jablonec 30 58 22 64
4 Mladá Boleslav Mladá 30 43 34 46
5 Pribram Pribram 30 40 45 43
6 FK Dukla Praha Dukla Praha 30 34 40 41
7 Teplice Teplice 30 41 37 38
8 Bohemians 1905 Bohemians 30 35 41 38
9 Slovácko Slovácko 30 43 46 37
10 Vysocina Jihlava Vysocina 30 33 38 36
11 Slavia Praha Slavia Praha 30 40 45 34
12 Slovan Liberec Slovan 30 39 43 33
13 Zbrojovka Brno Zbrojovka 30 34 45 33
14 Baník Ostrava Baník 30 23 41 33
15 Hradec Králové Hradec 30 26 52 25
16 České Budějovice České 30 29 72 22
TEMPORADA 2013/2014
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 78 19 79
2 Viktoria Plzeň Viktoria 30 64 21 66
3 Mladá Boleslav Mladá 30 54 38 50
4 Slovan Liberec Slovan 30 37 46 48
5 Teplice Teplice 30 51 35 46
6 Slovácko Slovácko 30 43 40 40
7 FK Dukla Praha Dukla Praha 30 35 37 38
8 Vysocina Jihlava Vysocina 30 45 50 37
9 Zbrojovka Brno Zbrojovka 30 32 42 37
10 Baník Ostrava Baník 30 33 43 35
11 Jablonec Jablonec 30 43 53 34
12 Pribram Pribram 30 34 49 34
13 Slavia Praha Slavia Praha 30 24 51 30
14 Bohemians 1905 Bohemians 30 26 40 30
15 Sigma Olomouc Sigma 30 42 60 29
16 Znojmo Znojmo 30 32 49 27
TEMPORADA 2012/2013
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 54 21 65
2 Sparta Praha Sparta Praha 30 55 23 63
3 Slovan Liberec Slovan 30 46 34 54
4 Jablonec Jablonec 30 49 41 49
5 Sigma Olomouc Sigma 30 38 29 47
6 FK Dukla Praha Dukla Praha 30 48 37 46
7 Slavia Praha Slavia Praha 30 41 33 42
8 Mladá Boleslav Mladá 30 34 43 38
9 Slovácko Slovácko 30 37 41 37
10 Vysocina Jihlava Vysocina 30 36 42 36
11 Teplice Teplice 30 36 47 32
12 Pribram Pribram 30 27 39 32
13 Zbrojovka Brno Zbrojovka 30 34 53 32
14 Baník Ostrava Baník 30 34 44 29
15 České Budějovice České 30 24 49 26
16 Hradec Králové Hradec 30 27 44 25
TEMPORADA 2011/2012
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slovan Liberec Slovan 30 68 29 66
2 Sparta Praha Sparta Praha 30 51 25 64
3 Viktoria Plzeň Viktoria 30 66 33 63
4 Mladá Boleslav Mladá 30 49 34 50
5 Teplice Teplice 30 36 30 46
6 FK Dukla Praha Dukla Praha 30 42 35 42
7 Slovácko Slovácko 30 29 32 41
8 Jablonec Jablonec 30 54 43 40
9 Pribram Pribram 30 44 56 39
10 České Budějovice České 30 30 51 35
11 Sigma Olomouc Sigma 30 42 38 34
12 Slavia Praha Slavia Praha 30 28 34 34
13 Hradec Králové Hradec 30 22 38 31
14 Baník Ostrava Baník 30 31 48 28
15 Bohemians 1905 Bohemians 30 20 54 24
16 Viktoria Žižkov Viktoria 30 23 55 19
TEMPORADA 2010/2011
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 70 28 69
2 Sparta Praha Sparta Praha 30 54 21 68
3 Jablonec Jablonec 30 65 34 58
4 Sigma Olomouc Sigma 30 47 29 47
5 Mladá Boleslav Mladá 30 49 40 46
6 Slovan Liberec Slovan 30 45 36 43
7 Bohemians 1905 Bohemians 30 33 33 43
8 Hradec Králové Hradec 30 26 36 41
9 Slavia Praha Slavia Praha 30 41 36 40
10 Teplice Teplice 30 39 46 39
11 České Budějovice České 30 30 48 33
12 Pribram Pribram 30 22 36 31
13 Slovácko Slovácko 30 27 43 31
14 Baník Ostrava Baník 30 31 46 30
15 Zbrojovka Brno Zbrojovka 30 33 55 24
16 FK Viagem Ústí nad Labem Viagem 30 22 67 19
TEMPORADA 2009/2010
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 42 14 62
2 Jablonec Jablonec 30 42 24 61
3 Baník Ostrava Baník 30 47 25 60
4 Teplice Teplice 30 44 25 55
5 Viktoria Plzeň Viktoria 30 42 33 48
6 Sigma Olomouc Sigma 30 49 36 47
7 Slavia Praha Slavia Praha 30 37 35 41
8 Mladá Boleslav Mladá 30 47 41 39
9 Slovan Liberec Slovan 30 34 39 37
10 Pribram Pribram 30 35 41 36
11 Zbrojovka Brno Zbrojovka 30 31 40 35
12 Bohemians 1905 Bohemians 30 21 29 34
13 České Budějovice České 30 24 35 31
14 Slovácko Slovácko 30 28 42 30
15 SK Kladno SK Kladno 30 24 50 25
16 FK Bohemians (Střížkov) Bohemians 30 27 65 0
TEMPORADA 2008/2009
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 57 25 62
2 Sparta Praha Sparta Praha 30 48 25 56
3 Slovan Liberec Slovan 30 41 28 52
4 Sigma Olomouc Sigma 30 39 36 48
5 Jablonec Jablonec 30 43 37 46
6 Mladá Boleslav Mladá 30 39 38 46
7 Teplice Teplice 30 33 25 43
8 Viktoria Plzeň Viktoria 30 45 38 43
9 Baník Ostrava Baník 30 38 36 39
10 České Budějovice České 30 30 37 36
11 Zbrojovka Brno Zbrojovka 30 32 36 35
12 Pribram Pribram 30 30 40 34
13 FK Bohemians (Střížkov) Bohemians 30 33 46 34
14 SK Kladno SK Kladno 30 21 41 31
15 FC Trinity Zlín Trinity 30 26 49 29
16 Viktoria Žižkov Viktoria 30 27 45 22

  USO DE MEMORIA  
7,300,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.7282
Total Execution Time  0.7303
  CADENA URL  
/historico/Sparta-Praha
  GET DATOS  
$_GET['/historico/Sparta-Praha']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10050 AND type_rel = 2
0.0408  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10050 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0161  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 (2898,6745,8526,8917,28406) ORDER BY n.cover_points DESC, update_date DESC
0.2352  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.1303  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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0217  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 `tables2024` 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 = 72209 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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 = 68036 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 = 71575 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0200  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 = 63006 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 67402 AND t.round = 5 ORDER BY team.conference ASC,t.position 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 `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 = 49964 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 56778 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168  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 = 43592 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053  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 = 49595 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 38696 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0187  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 = 33331 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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 = 15408 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0197  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 `tables2015` 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 = 3883 AND t.round = 30 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 `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 = 2481 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 2041 AND t.round = 30 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 `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 = 1355 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 = 1083 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 = 865 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0100  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 = 243 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC