4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Verbroedering Geel
TEMPORADA 2023/2024
PROMOCIÓN BÉLGICA GRUPO 3
Equipo PJ GF GC Puntos
1 Eendracht Termien Eendracht 30 89 31 72
2 Berg en Dal Berg en Dal 30 78 44 61
3 Esperanza Pelt Esperanza 30 54 34 53
4 Zepperen-Brustem Zepperen-Bru 30 53 38 53
5 Wellen Wellen 30 50 36 47
6 Verbroedering Geel Verbroederin 30 43 36 47
7 KFC Nijlen KFC Nijlen 30 57 54 43
8 Sint-Lenaarts Sint-Lenaart 30 50 49 42
9 Beerschot VA B Beerschot 30 54 47 41
10 KFC Turnhout Turnhout 30 49 46 41
11 Schoonbeek-Beverst Schoonbeek-B 30 37 43 40
12 Zwarte Leeuw Zwarte Leeuw 30 39 41 36
13 Betekom Betekom 30 55 61 34
14 Diest Diest 30 38 60 27
15 Witgoor Sport Witgoor 30 38 60 23
16 KFC Eksel KFC Eksel 30 19 123 3
TEMPORADA 2007/2008
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Kortrijk Kortrijk 36 73 35 76
2 Tubize Tubize 36 49 29 66
3 OH Leuven OH Leuven 36 61 42 61
4 KVSK United KVSK United 36 51 36 60
5 Antwerp Antwerp 36 64 38 59
6 Excelsior Virton Excelsior 36 56 44 56
7 Lierse SK Lierse SK 36 47 36 53
8 VW Hamme VW Hamme 36 54 45 49
9 Tienen Tienen 36 49 51 48
10 KSK Beveren KSK Beveren 36 48 56 48
11 Tournai Tournai 36 34 37 46
12 Olympic Charleroi Olympic 36 40 53 46
13 KAS Eupen KAS Eupen 36 45 49 45
14 Red Star Waasland Star 36 46 47 43
15 Deinze Deinze 36 44 58 43
16 Union Namur Union Namur 36 51 63 42
17 KV Oostende KV Oostende 36 44 59 42
18 Union Saint-Gilloise Union 36 48 61 40
19 Verbroedering Geel Verbroederin 36 33 98 16
TEMPORADA 2006/2007
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Verbroedering Geel Verbroederin 30 66 25 65
2 Tournai Tournai 30 47 24 61
3 Diegem Sport Diegem Sport 30 47 19 59
4 Mouscron Mouscron 30 43 33 51
5 KFC Turnhout Turnhout 30 56 41 49
6 Cappellen Cappellen 30 32 23 45
7 Standaard Wetteren Standaard 30 41 40 45
8 Sint-Niklaas Sint-Niklaas 30 51 42 44
9 Londerzeel Londerzeel 30 35 34 38
10 Torhout Torhout 30 39 48 38
11 Oudenaarde Oudenaarde 30 37 42 37
12 Racing Mechelen Racing 30 35 39 34
13 Willebroek-Meerhof Willebroek-M 30 38 52 32
14 Racing Club Harelbeke Racing Club 30 28 53 22
15 Geel-Meerhout Geel-Meerhou 30 21 58 20
16 Maldegem Maldegem 30 32 75 18
TEMPORADA 2005/2006
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Mons Mons 34 64 30 69
2 Lommel SK Lommel SK 34 62 38 63
3 Kortrijk Kortrijk 34 57 41 58
4 Verbroedering Geel Verbroederin 34 49 34 57
5 SK Beveren SK Beveren 34 58 46 57
6 OH Leuven OH Leuven 34 53 37 54
7 Antwerp Antwerp 34 58 50 53
8 VW Hamme VW Hamme 34 58 47 49
9 KAS Eupen KAS Eupen 34 51 47 48
10 KV Oostende KV Oostende 34 51 47 47
11 Ronse Ronse 34 52 62 42
12 Tubize Tubize 34 47 50 41
13 KV Mechelen KV Mechelen 34 44 46 39
14 Union Saint-Gilloise Union 34 42 53 37
15 Excelsior Virton Excelsior 34 28 41 37
16 Dessel Sport Dessel Sport 34 38 50 34
17 Deinze Deinze 34 39 65 29
18 Beringen Heusden Beringen 34 24 91 26
TEMPORADA 2004/2005
SEGUNDA DIVISIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Zulte-Waregem Zulte-Warege 34 71 35 73
2 KSV Roeselare Roeselare 34 51 31 60
3 Verbroedering Geel Verbroederin 34 49 36 56
4 Antwerp Antwerp 34 48 40 50
5 SK Beveren SK Beveren 34 51 55 50
6 Kortrijk Kortrijk 34 56 48 48
7 Tubize Tubize 34 54 49 48
8 Ronse Ronse 34 42 51 48
9 Beringen Heusden Beringen 34 41 41 47
10 Deinze Deinze 34 47 59 43
11 KAS Eupen KAS Eupen 34 52 46 41
12 VW Hamme VW Hamme 34 50 47 41
13 Excelsior Virton Excelsior 34 43 54 41
14 Union Saint-Gilloise Union 34 41 53 39
15 Dessel Sport Dessel Sport 34 31 46 39
16 Visé Visé 34 52 54 37
17 Patro Eisden Patro Eisden 34 35 53 37
18 Eendracht Aalst Eendracht 34 41 57 34
TEMPORADA 2003/2004
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 RWD Molenbeek Molenbeek 34 79 29 70
2 KV Oostende KV Oostende 34 69 43 65
3 KSV Roeselare Roeselare 34 59 38 63
4 Tubize Tubize 34 60 33 58
5 Zulte-Waregem Zulte-Warege 34 58 45 52
6 Excelsior Virton Excelsior 34 38 33 51
7 Deinze Deinze 34 45 46 50
8 Patro Eisden Patro Eisden 34 47 50 49
9 Dessel Sport Dessel Sport 34 41 42 48
10 Verbroedering Geel Verbroederin 34 38 41 47
11 VW Hamme VW Hamme 34 43 44 46
12 Eendracht Aalst Eendracht 34 54 59 45
13 Visé Visé 34 48 59 44
14 KAS Eupen KAS Eupen 34 32 41 37
15 Ronse Ronse 34 27 46 32
16 Racing Club Harelbeke Racing Club 34 41 61 31
17 Tienen Tienen 34 30 64 25
18 Denderleeuw Denderleeuw 34 32 67 22
TEMPORADA 2002/2003
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Cercle Brugge Cercle 34 65 36 69
2 KAS Eupen KAS Eupen 34 54 32 64
3 Beringen Heusden Beringen 34 52 33 57
4 Zulte-Waregem Zulte-Warege 34 51 40 55
5 Denderleeuw Denderleeuw 34 56 40 53
6 Visé Visé 34 48 41 52
7 RFC Liège RFC Liège 34 46 47 48
8 Strombeek Strombeek 34 57 47 47
9 Verbroedering Geel Verbroederin 34 35 33 47
10 Excelsior Virton Excelsior 34 43 37 42
11 Ronse Ronse 34 38 42 42
12 VW Hamme VW Hamme 34 50 63 42
13 Deinze Deinze 34 37 52 40
14 Ingelmunster Ingelmunster 34 50 58 39
15 Tienen Tienen 34 37 60 39
16 Dessel Sport Dessel Sport 34 48 63 38
17 KSV Roeselare Roeselare 34 40 51 31
18 Patro Eisden Patro Eisden 34 31 63 24
TEMPORADA 2001/2002
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 KV Mechelen KV Mechelen 34 64 24 71
2 Ingelmunster Ingelmunster 34 53 32 67
3 Mons Mons 34 56 37 62
4 Beringen Heusden Beringen 34 52 34 56
5 Harelbeke Harelbeke 34 41 42 55
6 Cercle Brugge Cercle 34 40 28 52
7 Dessel Sport Dessel Sport 34 57 44 47
8 Visé Visé 34 41 50 45
9 Strombeek Strombeek 34 42 51 42
10 RFC Liège RFC Liège 34 35 42 41
11 Excelsior Virton Excelsior 34 41 47 39
12 Verbroedering Geel Verbroederin 34 39 48 38
13 Denderleeuw Denderleeuw 34 31 41 38
14 KSV Roeselare Roeselare 34 41 44 37
15 Ronse Ronse 34 37 52 37
16 Deinze Deinze 34 40 50 36
17 Tienen Tienen 34 36 51 35
18 Patro Eisden Patro Eisden 34 33 62 30
TEMPORADA 2000/2001
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 KFC Lommel KFC Lommel 34 79 27 78
2 KFC Turnhout Turnhout 34 88 44 69
3 RWD Molenbeek Molenbeek 34 62 29 61
4 Verbroedering Geel Verbroederin 34 58 36 60
5 Mons Mons 34 50 26 58
6 Ingelmunster Ingelmunster 34 61 49 55
7 Cercle Brugge Cercle 33 49 48 46
8 KSV Roeselare Roeselare 34 49 51 46
9 Denderleeuw Denderleeuw 34 42 47 41
10 Strombeek Strombeek 34 47 51 39
11 Beringen Heusden Beringen 34 39 53 38
12 Dessel Sport Dessel Sport 33 44 59 38
13 Tienen Tienen 34 42 53 37
14 Patro Eisden Patro Eisden 34 38 60 37
15 Deinze Deinze 34 34 56 36
16 RFC Liège RFC Liège 34 40 68 36
17 Eendracht Hekelgem Eendracht 34 37 69 24
18 KV Oostende KV Oostende 34 35 68 23
TEMPORADA 1999/2000
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 86 36 75
2 Club Brugge Club Brugge 34 70 32 67
3 KAA Gent KAA Gent 34 78 54 63
4 Excelsior Mouscron Excelsior 34 67 45 57
5 Standard de Liège Standard 34 66 52 56
6 KVC Westerlo Westerlo 34 73 66 56
7 Beerschot Beerschot 34 56 45 55
8 Genk Genk 34 63 59 54
9 Lierse SK Lierse SK 34 65 47 52
10 Lokeren Lokeren 34 56 58 47
11 KV Mechelen KV Mechelen 34 47 77 41
12 Harelbeke Harelbeke 34 62 70 38
13 Eendracht Aalst Eendracht 34 53 72 37
14 Sint-Truidense V.V. Sint-Truiden 34 41 65 37
15 KSK Beveren KSK Beveren 34 49 75 32
16 Charleroi Charleroi 34 42 62 31
17 Verbroedering Geel Verbroederin 34 32 60 28
18 KFC Lommel KFC Lommel 34 35 66 27

  USO DE MEMORIA  
6,230,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5778
Total Execution Time  0.5790
  CADENA URL  
/historico/Kfc-Verbroedering-Geel
  GET DATOS  
$_GET['/historico/Kfc-Verbroedering-Geel']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0139  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 = 'Kfc-Verbroedering-Geel' AND l.year = 2024 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.0125  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=1457 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=1457 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=1457 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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 = 72774
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1457 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=569 AND type_rel = 3
0.0134  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 569 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0134  SELECT /*53 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 (169732) ORDER BY n.cover_points DESC, update_date DESC
0.0143  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 = '1457' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '1457' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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 = 72774 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0143  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=1457 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (73206,72774) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 72774 AND teamId = 1457
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 1457
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 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 = 72774 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0132  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 = '1457' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1457' and rp.type = 4
0.0128  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 = '1457' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72774 WHERE rp.league_id = 72774 AND rp.teamId = 1457 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.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 = 72774 WHERE rp.league_id = 72774 AND rp.teamId = 1457 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 72774 WHERE rp.league_id = 72774 AND rp.teamId = 1457 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 1457 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 = 72774 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 `tables2008` 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 = 10160 AND t.round = 38 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 `tables2007` 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 = 24306 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables2006` 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 = 13512 AND t.round = 34 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 `tables2005` 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 = 13511 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 `tables2004` 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 = 13510 AND t.round = 34 ORDER BY team.conference 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 `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 = 13509 AND t.round = 34 ORDER BY team.conference 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 `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 = 13508 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 13507 AND t.round = 34 ORDER BY team.conference 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 `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 = 362 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72774 ORDER BY nameShow LIMIT 100