4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1928/1929
LIGA BELGA
Equipo PJ GF GC Puntos
1 Antwerp Antwerp 27 52 24 59
2 K Beerschot VAC Beerschot 27 62 33 55
3 Racing Mechelen Racing 26 58 56 45
4 Cercle Brugge Cercle 26 50 39 42
5 KRC Gent KRC Gent 26 60 49 39
6 Racing de Bruxelles Racing 26 48 44 36
7 KV Mechelen KV Mechelen 26 62 45 35
8 Berchem Sport Berchem 26 48 41 35
9 Daring Molenbeek Daring 26 38 45 34
10 Standard de Liège Standard 26 38 55 32
11 Lierse SK Lierse SK 26 40 47 31
12 Union Saint-Gilloise Union 26 53 65 29
13 KAA Gent KAA Gent 26 53 76 24
14 Tilleur-Saint-Gilles Tilleur-Sain 26 36 79 13
TEMPORADA 1927/1928
LIGA BELGA
Equipo PJ GF GC Puntos
1 K Beerschot VAC Beerschot 26 85 26 71
2 Standard de Liège Standard 26 90 55 54
3 Cercle Brugge Cercle 26 69 55 50
4 Berchem Sport Berchem 26 49 45 39
5 Lierse SK Lierse SK 26 48 54 38
6 KAA Gent KAA Gent 26 58 58 34
7 Union Saint-Gilloise Union 26 46 52 33
8 KRC Gent KRC Gent 26 49 60 33
9 Antwerp Antwerp 26 52 64 33
10 Racing Mechelen Racing 26 59 65 32
11 Club Brugge Club Brugge 26 43 59 31
12 Racing de Bruxelles Racing 26 53 58 30
13 Daring Molenbeek Daring 26 44 58 30
14 Anderlecht Anderlecht 26 46 82 14
TEMPORADA 1926/1927
LIGA BELGA
Equipo PJ GF GC Puntos
1 K Beerschot VAC Beerschot 26 53 31 47
2 Cercle Brugge Cercle 26 63 44 47
3 Standard de Liège Standard 26 85 58 46
4 Daring Molenbeek Daring 26 49 46 43
5 Berchem Sport Berchem 26 51 43 40
6 Union Saint-Gilloise Union 26 55 47 39
7 KAA Gent KAA Gent 26 59 65 38
8 Club Brugge Club Brugge 26 51 56 36
9 KRC Gent KRC Gent 26 58 57 34
10 Racing Mechelen Racing 26 59 45 32
11 Antwerp Antwerp 26 41 55 30
12 Racing de Bruxelles Racing 26 40 60 28
13 KV Mechelen KV Mechelen 26 46 62 24
14 Forestoise Forestoise 26 42 83 18
TEMPORADA 1925/1926
LIGA BELGA
Equipo PJ GF GC Puntos
1 K Beerschot VAC Beerschot 26 80 29 58
2 Standard de Liège Standard 26 77 48 47
3 Daring Molenbeek Daring 26 59 33 47
4 Union Saint-Gilloise Union 26 53 34 47
5 Cercle Brugge Cercle 26 59 27 45
6 Berchem Sport Berchem 26 68 45 41
7 Antwerp Antwerp 26 49 41 39
8 Racing Mechelen Racing 26 65 73 39
9 Club Brugge Club Brugge 26 49 52 36
10 KAA Gent KAA Gent 26 52 56 36
11 KRC Gent KRC Gent 26 63 71 32
12 Anderlecht Anderlecht 26 39 64 27
13 Verviers Verviers 26 34 102 14
14 Tilleur-Saint-Gilles Tilleur-Sain 26 29 101 11
TEMPORADA 1924/1925
LIGA BELGA
Equipo PJ GF GC Puntos
1 K Beerschot VAC Beerschot 26 55 22 58
2 Antwerp Antwerp 26 39 21 47
3 Union Saint-Gilloise Union 26 41 29 45
4 KRC Gent KRC Gent 26 36 38 39
5 Berchem Sport Berchem 26 46 35 38
6 Daring Molenbeek Daring 26 31 23 37
7 Cercle Brugge Cercle 26 25 24 37
8 Anderlecht Anderlecht 26 37 29 36
9 Standard de Liège Standard 26 36 39 35
10 Club Brugge Club Brugge 26 33 44 30
11 KAA Gent KAA Gent 26 24 38 30
12 Racing de Bruxelles Racing 26 25 37 27
13 KV Mechelen KV Mechelen 26 34 47 23
14 White Star Woluwé White Star. 26 17 53 19
TEMPORADA 1923/1924
LIGA BELGA
Equipo PJ GF GC Puntos
1 K Beerschot VAC Beerschot 26 52 21 53
2 Union Saint-Gilloise Union 26 43 20 51
3 Racing de Bruxelles Racing 26 47 30 47
4 Cercle Brugge Cercle 26 47 26 46
5 Standard de Liège Standard 26 43 32 45
6 KRC Gent KRC Gent 26 43 41 43
7 Antwerp Antwerp 26 43 32 33
8 Daring Molenbeek Daring 26 31 32 31
9 Club Brugge Club Brugge 26 38 37 30
10 KAA Gent KAA Gent 27 35 42 28
11 Berchem Sport Berchem 26 31 43 28
12 Racing Mechelen Racing 27 30 70 25
13 Verviers Verviers 26 28 59 20
14 RFC Liège RFC Liège 26 17 43 16
TEMPORADA 1922/1923
LIGA BELGA
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 26 55 19 60
2 K Beerschot VAC Beerschot 27 67 28 56
3 Cercle Brugge Cercle 26 42 21 52
4 Antwerp Antwerp 26 54 37 50
5 Daring Molenbeek Daring 26 46 23 48
6 Racing de Bruxelles Racing 26 58 52 41
7 Standard de Liège Standard 26 47 48 35
8 Club Brugge Club Brugge 27 47 56 32
9 KAA Gent KAA Gent 26 42 53 28
10 Racing Mechelen Racing 26 30 56 26
11 Berchem Sport Berchem 26 36 67 26
12 Verviers Verviers 26 40 57 23
13 Anderlecht Anderlecht 26 31 49 20
14 Léopold Uccle-Woluwé Léopold 26 30 59 17
TEMPORADA 1921/1922
LIGA BELGA
Equipo PJ GF GC Puntos
1 K Beerschot VAC Beerschot 26 54 23 56
2 Union Saint-Gilloise Union 26 51 17 54
3 Antwerp Antwerp 26 52 31 52
4 Racing de Bruxelles Racing 26 45 28 43
5 Standard de Liège Standard 26 45 33 39
6 Cercle Brugge Cercle 26 43 39 39
7 Racing Mechelen Racing 26 41 43 36
8 Daring Molenbeek Daring 26 28 31 35
9 Club Brugge Club Brugge 26 39 42 34
10 KAA Gent KAA Gent 26 30 50 26
11 Verviers Verviers 26 27 47 25
12 Anderlecht Anderlecht 26 27 42 22
13 KRC Gent KRC Gent 26 27 47 22
14 KV Mechelen KV Mechelen 26 33 69 17
TEMPORADA 1920/1921
LIGA BELGA
Equipo PJ GF GC Puntos
1 Daring Molenbeek Daring 22 40 10 50
2 Union Saint-Gilloise Union 22 46 18 43
3 K Beerschot VAC Beerschot 22 51 28 40
4 Club Brugge Club Brugge 22 47 29 37
5 Cercle Brugge Cercle 22 41 32 37
6 Racing de Bruxelles Racing 22 43 40 30
7 KAA Gent KAA Gent 22 28 33 30
8 KRC Gent KRC Gent 22 30 45 28
9 Antwerp Antwerp 22 29 37 26
10 Racing Mechelen Racing 22 22 42 19
11 Verviers Verviers 22 34 51 16
12 Léopold Uccle-Woluwé Léopold 22 17 63 9
TEMPORADA 1919/1920
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 22 61 27 49
2 Union Saint-Gilloise Union 22 71 22 46
3 Daring Molenbeek Daring 22 45 28 44
4 Antwerp Antwerp 22 52 35 38
5 K Beerschot VAC Beerschot 22 44 35 36
6 Racing Mechelen Racing 22 37 40 34
7 KRC Gent KRC Gent 22 34 45 31
8 Cercle Brugge Cercle 22 38 38 26
9 Verviers Verviers 22 40 64 22
10 Léopold Uccle-Woluwé Léopold 22 28 58 17
11 Racing de Bruxelles Racing 22 40 59 15
12 KAA Gent KAA Gent 22 28 67 13
TEMPORADA 1913/1914
LIGA BELGA
Equipo PJ GF GC Puntos
1 Daring Molenbeek Daring 22 69 16 52
2 Union Saint-Gilloise Union 22 60 28 48
3 Cercle Brugge Cercle 22 48 27 43
4 Club Brugge Club Brugge 22 42 31 40
5 Racing de Bruxelles Racing 22 53 33 39
6 Verviers Verviers 22 38 39 30
7 K Beerschot VAC Beerschot 22 34 42 27
8 KRC Gent KRC Gent 22 31 44 27
9 Antwerp Antwerp 22 37 54 24
10 KAA Gent KAA Gent 23 29 53 21
11 Standard de Liège Standard 23 21 57 19
12 Léopold Uccle-Woluwé Léopold 22 32 70 13
TEMPORADA 1912/1913
LIGA BELGA
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 23 84 19 59
2 Daring Molenbeek Daring 23 82 14 56
3 Racing de Bruxelles Racing 22 61 23 44
4 K Beerschot VAC Beerschot 22 52 32 37
5 Cercle Brugge Cercle 22 48 29 36
6 Verviers Verviers 22 49 47 28
7 Club Brugge Club Brugge 22 41 46 28
8 Antwerp Antwerp 22 39 57 27
9 KAA Gent KAA Gent 22 31 36 25
10 Standard de Liège Standard 22 26 64 23
11 RFC Liège RFC Liège 22 15 88 13
12 Royal Excelsior Royal 22 11 84 2
TEMPORADA 1911/1912
LIGA BELGA
Equipo PJ GF GC Puntos
1 Daring Molenbeek Daring 22 79 15 56
2 Union Saint-Gilloise Union 22 83 24 53
3 Racing de Bruxelles Racing 22 72 27 42
4 Club Brugge Club Brugge 22 47 25 40
5 Cercle Brugge Cercle 22 56 29 38
6 Antwerp Antwerp 22 33 57 29
7 KAA Gent KAA Gent 22 26 45 22
8 Royal Excelsior Royal 22 23 61 21
9 Standard de Liège Standard 22 29 85 21
10 K Beerschot VAC Beerschot 22 20 60 19
11 Racing Mechelen Racing 22 24 42 16
12 Léopold Uccle-Woluwé Léopold 22 24 46 13
TEMPORADA 1908/1909
LIGA BELGA
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 22 101 13 60
2 Daring Molenbeek Daring 22 63 27 49
3 Club Brugge Club Brugge 22 63 26 48
4 Racing de Bruxelles Racing 22 59 21 44
5 K Beerschot VAC Beerschot 22 62 45 33
6 Royal Excelsior Royal 22 41 40 31
7 Cercle Brugge Cercle 22 57 45 30
8 Antwerp Antwerp 22 48 57 28
9 Kortrijk Kortrijk 22 27 86 18
10 RFC Liège RFC Liège 22 22 84 16
11 Léopold Uccle-Woluwé Léopold 22 30 70 12
12 KAA Gent KAA Gent 22 19 78 10

  USO DE MEMORIA  
6,320,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6089
Total Execution Time  0.6101
  CADENA URL  
/historico/Kaa-Gent/1929
  GET DATOS  
$_GET['/historico/Kaa-Gent/1929']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0296  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 = 25561
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1431 AND type_rel = 2
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1431 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0150  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 (8774,8790,11964,12268,12941) ORDER BY n.cover_points DESC, update_date DESC
0.0235  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 = '1431' 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 = 25561 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0228  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=1431 AND l.year in (1928,1929,1930) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (25566) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 25566 AND teamId = 1431
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 FROM `tables1929` 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 = 25561 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '1431' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1431' and rp.type = 4
0.0145  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 = '1431' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  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 events1929 e ON e.player_id = p.id AND e.league_id = 25561 WHERE rp.league_id = 25561 AND rp.teamId = 1431 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.0146  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 events1929 e ON e.player_id = p.id AND e.league_id = 25561 WHERE rp.league_id = 25561 AND rp.teamId = 1431 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 events1929 e ON e.player_id = p.id AND e.league_id = 25561 WHERE rp.league_id = 25561 AND rp.teamId = 1431 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0172  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 = 1431 AND l.year <= 1929 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1929` 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 = 25561 AND t.round = 27 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 `tables1928` 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 = 25566 AND t.round = 26 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 `tables1927` 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 = 25569 AND t.round = 26 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 `tables1926` 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 = 25573 AND t.round = 26 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 `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 = 25577 AND t.round = 26 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 `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 = 25582 AND t.round = 27 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 `tables1923` 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 = 25584 AND t.round = 27 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 `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 = 25585 AND t.round = 26 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 `tables1921` 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 = 25587 AND t.round = 22 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 `tables1920` 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 = 25588 AND t.round = 22 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 `tables1914` 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 = 25590 AND t.round = 23 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 `tables1913` 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 = 25591 AND t.round = 23 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 `tables1912` 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 = 25598 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 `tables1909` 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 = 25603 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC