4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 30 63 31 70
2 Anderlecht Anderlecht 30 58 30 63
3 Antwerp Antwerp 30 55 27 52
4 Club Brugge Club Brugge 30 62 29 51
5 Genk Genk 30 51 31 47
6 KAA Gent KAA Gent 30 53 38 47
7 Cercle Brugge Cercle 30 44 34 47
8 KV Mechelen KV Mechelen 30 39 34 45
9 Sint-Truidense V.V. Sint-Truiden 30 35 46 40
10 Standard de Liège Standard 30 33 41 34
11 KVC Westerlo Westerlo 30 42 54 30
12 OH Leuven OH Leuven 30 34 47 29
13 Charleroi Charleroi 30 26 48 29
14 KAS Eupen KAS Eupen 30 24 58 24
15 Kortrijk Kortrijk 30 22 57 24
16 RWD Molenbeek Molenbeek 30 31 67 23
TEMPORADA 2022/2023
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Antwerp Antwerp 6 10 8 47
2 Genk Genk 6 10 10 46
3 Union Saint-Gilloise Union 6 8 8 46
4 Club Brugge Club Brugge 6 10 12 36
TEMPORADA 2021/2022
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 6 8 2 50
2 Union Saint-Gilloise Union 6 5 5 46
3 Anderlecht Anderlecht 6 8 7 40
4 Antwerp Antwerp 6 3 10 36
TEMPORADA 2020/2021
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 6 8 11 44
2 Genk Genk 6 15 5 44
3 Antwerp Antwerp 6 6 11 35
4 Anderlecht Anderlecht 6 9 11 33
TEMPORADA 2019/2020
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 29 58 14 70
2 KAA Gent KAA Gent 29 59 34 55
3 Charleroi Charleroi 29 49 23 54
4 Antwerp Antwerp 29 49 32 53
5 Standard de Liège Standard 29 47 32 49
6 KV Mechelen KV Mechelen 29 46 43 44
7 Genk Genk 29 45 42 44
8 Anderlecht Anderlecht 29 45 29 43
9 Zulte-Waregem Zulte-Warege 29 41 49 36
10 Mouscron Mouscron 29 38 40 36
11 Kortrijk Kortrijk 29 40 44 33
12 Sint-Truidense V.V. Sint-Truiden 29 33 50 33
13 KAS Eupen KAS Eupen 29 28 51 30
14 Cercle Brugge Cercle 29 27 54 23
15 KV Oostende KV Oostende 29 29 58 22
16 SK Beveren SK Beveren 29 21 60 20
TEMPORADA 2018/2019
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Genk Genk 10 19 8 52
2 Club Brugge Club Brugge 10 19 11 50
3 Standard de Liège Standard 10 17 16 40
4 Antwerp Antwerp 10 12 16 39
5 KAA Gent KAA Gent 10 10 15 35
6 Anderlecht Anderlecht 10 8 19 32
TEMPORADA 2017/2018
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 30 68 33 67
2 Anderlecht Anderlecht 30 49 42 55
3 Charleroi Charleroi 30 46 30 51
4 KAA Gent KAA Gent 30 45 27 50
5 Genk Genk 30 44 36 44
6 Standard de Liège Standard 30 43 41 44
7 Kortrijk Kortrijk 30 42 39 42
8 Antwerp Antwerp 30 38 40 41
9 Zulte-Waregem Zulte-Warege 30 47 52 37
10 Sint-Truidense V.V. Sint-Truiden 30 29 41 37
11 KV Oostende KV Oostende 30 42 41 36
12 SK Beveren SK Beveren 30 50 51 35
13 Lokeren Lokeren 30 33 49 31
14 Mouscron Mouscron 30 40 59 30
15 KAS Eupen KAS Eupen 30 40 57 27
16 KV Mechelen KV Mechelen 30 31 49 27
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Antwerp Antwerp 14 21 11 29
2 Lierse SK Lierse SK 14 25 11 27
3 Cercle Brugge Cercle 14 14 13 21
4 KSV Roeselare Roeselare 14 18 17 20
5 Union Saint-Gilloise Union 14 11 12 17
6 Tubize Tubize 14 19 24 17
7 OH Leuven OH Leuven 14 15 21 15
8 Lommel SK Lommel SK 14 11 25 5
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 White Star Woluwé White Star. 32 53 28 63
2 KAS Eupen KAS Eupen 32 69 34 62
3 Antwerp Antwerp 32 52 20 62
4 Tubize Tubize 32 51 34 57
5 Cercle Brugge Cercle 32 56 35 54
6 Union Saint-Gilloise Union 32 50 34 51
7 Lierse SK Lierse SK 32 53 41 51
8 Lommel SK Lommel SK 32 43 29 50
9 KSV Roeselare Roeselare 32 46 47 50
10 Dessel Sport Dessel Sport 32 38 40 48
11 RFC Seraing RFC Seraing 32 45 50 44
12 Excelsior Virton Excelsior 32 40 55 34
13 Geel-Meerhout Geel-Meerhou 32 40 56 31
14 Deinze Deinze 32 36 58 29
15 Patro Eisden Patro Eisden 32 33 63 24
16 Heist Heist 32 39 82 19
17 Coxyde Coxyde 32 29 67 16
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Sint-Truidense V.V. Sint-Truiden 34 62 28 79
2 Lommel SK Lommel SK 34 65 27 70
3 KAS Eupen KAS Eupen 34 63 30 67
4 RFC Seraing RFC Seraing 34 69 39 61
5 OH Leuven OH Leuven 34 66 39 61
6 Excelsior Virton Excelsior 34 58 35 59
7 Mons Mons 34 52 30 55
8 Tubize Tubize 34 43 40 50
9 Eendracht Aalst Eendracht 34 48 45 46
10 Antwerp Antwerp 34 41 41 42
11 KSV Roeselare Roeselare 34 44 45 42
12 WS Bruxelles Bruxelles 34 43 48 40
13 Geel-Meerhout Geel-Meerhou 34 42 62 39
14 Heist Heist 34 41 61 36
15 Dessel Sport Dessel Sport 34 36 58 31
16 Patro Eisden Patro Eisden 34 38 68 26
17 Racing Mechelen Racing 34 23 87 19
18 Woluwe Woluwe 34 30 81 15
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 KVC Westerlo Westerlo 34 67 23 78
2 KAS Eupen KAS Eupen 34 75 27 74
3 Sint-Truidense V.V. Sint-Truiden 34 47 31 67
4 Mouscron Mouscron 34 53 27 66
5 Lommel SK Lommel SK 34 56 34 59
6 Tubize Tubize 34 59 45 54
7 Antwerp Antwerp 33 44 31 46
8 RWD Molenbeek Molenbeek 34 38 41 45
9 RBD Borinage Borinage 34 45 51 45
10 Geel-Meerhout Geel-Meerhou 34 45 49 43
11 Eendracht Aalst Eendracht 34 37 49 42
12 WS Bruxelles Bruxelles 34 37 38 40
13 Excelsior Virton Excelsior 33 47 45 38
14 Dessel Sport Dessel Sport 34 37 60 35
15 KSV Roeselare Roeselare 34 41 62 35
16 Heist Heist 34 38 74 31
17 Hoogstraten Hoogstraten 34 33 61 28
18 Visé Visé 34 26 77 13
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 KV Oostende KV Oostende 34 61 27 75
2 Mouscron Mouscron 34 58 29 67
3 KVC Westerlo Westerlo 34 54 29 63
4 Sint-Truidense V.V. Sint-Truiden 34 54 36 57
5 RBD Borinage Borinage 34 44 34 55
6 White Star Woluwé White Star. 34 44 39 53
7 Lommel SK Lommel SK 34 50 48 50
8 KAS Eupen KAS Eupen 34 44 37 49
9 Tubize Tubize 34 43 42 46
10 Antwerp Antwerp 34 42 44 45
11 KSV Roeselare Roeselare 34 44 47 42
12 Dessel Sport Dessel Sport 34 35 42 41
13 Eendracht Aalst Eendracht 34 38 52 41
14 Visé Visé 34 47 57 33
15 Brussels Brussels 34 32 49 33
16 Heist Heist 34 39 57 30
17 Sint-Niklaas Sint-Niklaas 34 34 64 30
18 Oudenaarde Oudenaarde 34 31 61 30
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Charleroi Charleroi 34 64 34 74
2 KAS Eupen KAS Eupen 34 61 34 68
3 SK Beveren SK Beveren 34 61 34 68
4 KV Oostende KV Oostende 34 61 29 66
5 Lommel SK Lommel SK 34 48 42 52
6 White Star Woluwé White Star. 34 48 43 51
7 Heist Heist 34 46 46 46
8 Eendracht Aalst Eendracht 34 46 52 46
9 Visé Visé 34 44 41 44
10 Antwerp Antwerp 34 39 42 43
11 RBD Borinage Borinage 34 44 54 42
12 Tubize Tubize 34 36 55 41
13 KSV Roeselare Roeselare 34 46 51 40
14 Brussels Brussels 34 44 46 38
15 Sint-Niklaas Sint-Niklaas 34 41 54 34
16 FCV Dender FCV Dender 34 33 43 33
17 Tienen Tienen 34 34 61 33
18 Standaard Wetteren Standaard 34 19 54 21
TEMPORADA 2010/2011
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 OH Leuven OH Leuven 34 75 38 73
2 Lommel SK Lommel SK 34 73 44 65
3 Mons Mons 34 63 38 59
4 SK Beveren SK Beveren 34 51 35 56
5 Visé Visé 34 52 48 51
6 Antwerp Antwerp 34 54 53 50
7 FCV Dender FCV Dender 34 54 54 49
8 Tubize Tubize 34 46 55 47
9 KV Oostende KV Oostende 34 41 48 45
10 Heist Heist 34 57 67 43
11 Brussels Brussels 34 50 51 42
12 Standaard Wetteren Standaard 34 42 51 42
13 RBD Borinage Borinage 34 48 52 41
14 KSV Roeselare Roeselare 34 38 42 41
15 Tienen Tienen 34 35 47 41
16 KFC Turnhout Turnhout 34 48 59 40
17 Rupel Boom Rupel Boom 34 36 56 37
18 Tournai Tournai 34 38 63 24

  USO DE MEMORIA  
6,993,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5181
Total Execution Time  0.5193
  CADENA URL  
/historico/Antwerp
  GET DATOS  
$_GET['/historico/Antwerp']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0255  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 = 73865
0.0132  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 = 73206
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7512 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7512 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (147178,260603,261210,266750,278273) ORDER BY n.cover_points DESC, update_date DESC
0.0141  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 = '7512' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0141  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 = 73206 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0141  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 events2024 e ON e.player_id = p.id AND e.league_id = 73865 WHERE rp.league_id = 73865 AND rp.teamId = 7512 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.0137  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 events2024 e ON e.player_id = p.id AND e.league_id = 73865 WHERE rp.league_id = 73865 AND rp.teamId = 7512 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 73865 WHERE rp.league_id = 73865 AND rp.teamId = 7512 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 7512 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 75662 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 72090 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.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 `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 = 67769 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 71533 AND t.round = 6 ORDER BY team.conference ASC,t.position 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 `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 = 63065 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 `tables2021` 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 = 56829 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 62243 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 43914 AND t.round = 30 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 `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 = 49311 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 38639 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 33401 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 33402 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 15406 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 3908 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 2473 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 2016 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 1741 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 10154 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC