4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Vital'O
TEMPORADA 2023/2024
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Vital'O Vital'O 29 49 11 69
2 Flambeau du Centre Flambeau 29 49 18 66
3 Musongati Musongati 29 41 15 60
4 Rukinzo Rukinzo 29 50 30 57
5 Aigle Noir Aigle Noir 29 39 25 53
6 Le Messager Ngozi Messager 29 38 26 51
7 Olympic Star Olympic Star 29 32 24 42
8 Bumamuru Bumamuru 29 40 33 41
9 Dynamik Dynamik 29 45 46 36
10 LLB Académic Académic 29 27 33 32
11 Moso Sugar Moso Sugar 29 28 37 28
12 Kayanza Kayanza 29 28 41 28
13 Telaviv Telaviv 29 32 64 26
14 Inter Star Inter Star 29 23 46 24
15 Tigre Noir Tigre Noir 29 16 37 22
16 Magara Young Boys Magara Young 29 25 76 8
TEMPORADA 2022/2023
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Bumamuru Bumamuru 30 71 21 68
2 Flambeau du Centre Flambeau 30 55 27 67
3 Le Messager Ngozi Messager 30 44 19 56
4 Vital'O Vital'O 30 42 30 54
5 Aigle Noir Aigle Noir 30 34 24 53
6 Rukinzo Rukinzo 30 29 32 42
7 Kayanza Kayanza 30 34 39 40
8 Musongati Musongati 30 33 34 37
9 Olympic Star Olympic Star 30 30 35 37
10 Tigre Noir Tigre Noir 30 34 34 34
11 Magara Young Boys Magara Young 30 38 50 34
12 Dynamik Dynamik 30 21 39 29
13 Inter Star Inter Star 30 25 47 29
14 Bujumbura City Bujumbura 30 30 43 27
15 New Oil New Oil 30 28 50 27
16 TOP Junior TOP Junior 30 15 39 19
TEMPORADA 2021/2022
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Flambeau du Centre Flambeau 30 40 24 53
2 New Oil New Oil 30 35 22 52
3 Bumamuru Bumamuru 30 40 27 51
4 TOP Junior TOP Junior 30 37 29 51
5 Aigle Noir Aigle Noir 30 41 32 46
6 Olympic Star Olympic Star 30 31 25 46
7 Le Messager Ngozi Messager 30 27 21 46
8 Dynamik Dynamik 30 35 33 46
9 Musongati Musongati 30 27 22 44
10 Rukinzo Rukinzo 30 26 26 39
11 Vital'O Vital'O 30 32 39 39
12 Bujumbura City Bujumbura 30 35 37 37
13 Kayanza Kayanza 30 34 38 33
14 Les Crocos Les Crocos 30 20 30 24
15 Flambeau de l'Est Flambeau 30 18 54 23
16 Royal de Muramvya Royal 30 24 43 22
TEMPORADA 2020/2021
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Le Messager Ngozi Messager 30 42 26 55
2 Kayanza Kayanza 30 50 35 55
3 Flambeau du Centre Flambeau 30 43 26 54
4 Aigle Noir Aigle Noir 30 49 33 53
5 Musongati Musongati 30 48 30 50
6 Rukinzo Rukinzo 30 41 35 50
7 Vital'O Vital'O 30 34 33 44
8 Olympic Star Olympic Star 30 35 30 42
9 Royal de Muramvya Royal 30 36 32 42
10 Dynamik Dynamik 30 24 27 41
11 Bumamuru Bumamuru 30 33 39 39
12 Athlético Olympic Athlético 30 35 42 37
13 Bujumbura City Bujumbura 30 38 45 36
14 Inter Star Inter Star 30 31 42 31
15 Les Eléphants Eléphants 30 30 58 25
16 Muzinga Muzinga 30 15 51 12
TEMPORADA 2019/2020
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Le Messager Ngozi Messager 30 51 18 64
2 Musongati Musongati 30 45 26 56
3 Aigle Noir Aigle Noir 30 56 39 48
4 Dynamik Dynamik 30 32 25 48
5 Flambeau du Centre Flambeau 30 44 40 48
6 Vital'O Vital'O 30 41 33 44
7 Bujumbura City Bujumbura 30 47 41 43
8 Olympic Star Olympic Star 30 54 48 39
9 Rukinzo Rukinzo 30 40 44 39
10 Bumamuru Bumamuru 30 41 37 38
11 Inter Star Inter Star 30 29 32 38
12 Kayanza Kayanza 30 35 39 37
13 Athlético Olympic Athlético 30 46 44 36
14 LLB Académic Académic 30 23 41 35
15 Ngozi City Ngozi City 30 28 62 22
16 Les Lierres Les Lierres 30 26 69 20
TEMPORADA 2018/2019
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Aigle Noir Aigle Noir 26 66 23 61
2 Musongati Musongati 26 48 28 48
3 Vital'O Vital'O 26 28 17 46
4 Le Messager Ngozi Messager 26 36 28 43
5 Bujumbura City Bujumbura 27 32 28 39
6 Bumamuru Bumamuru 26 25 28 36
7 Ngozi City Ngozi City 26 23 33 36
8 Rukinzo Rukinzo 26 30 25 35
9 Les Lierres Les Lierres 27 26 32 33
10 Kayanza Kayanza 26 24 29 30
11 Flambeau du Centre Flambeau 26 32 35 30
12 Olympic Star Olympic Star 26 28 41 30
13 Le Messager de Bujumbura Messager 28 29 46 30
14 Athlético Olympic Athlético 26 22 32 29
15 Flambeau de l'Est Flambeau 26 15 25 26
16 LLB Académic Académic 28 25 39 26
TEMPORADA 2017/2018
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Le Messager Ngozi Messager 30 52 24 70
2 LLB Académic Académic 30 57 22 69
3 Aigle Noir Aigle Noir 30 66 32 59
4 Vital'O Vital'O 30 34 9 59
5 Olympic Star Olympic Star 30 55 26 58
6 Bujumbura City Bujumbura 30 32 30 44
7 Les Lierres Les Lierres 30 38 35 40
8 Musongati Musongati 30 38 31 39
9 Flambeau du Centre Flambeau 30 43 45 39
10 Flambeau de l'Est Flambeau 30 30 32 37
11 Athlético Olympic Athlético 30 34 44 33
12 Ngozi City Ngozi City 30 24 35 30
13 Le Messager de Bujumbura Messager 30 32 48 30
14 Inter Star Inter Star 30 22 41 26
15 Jeunes Athlétiques Jeunes 30 22 63 20
16 Delta Star Delta Star 30 13 75 9
TEMPORADA 2016/2017
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 LLB Académic Académic 30 58 16 68
2 Athlético Olympic Athlético 30 43 15 60
3 Vital'O Vital'O 30 46 15 57
4 Aigle Noir Aigle Noir 30 32 16 55
5 Musongati Musongati 30 49 27 49
6 Le Messager Ngozi Messager 30 33 25 47
7 Olympic Star Olympic Star 30 22 31 39
8 Bujumbura City Bujumbura 30 28 31 37
9 Les Lierres Les Lierres 30 33 40 34
10 Le Messager de Bujumbura Messager 30 26 35 33
11 Flambeau de l'Est Flambeau 30 27 35 32
12 Ngozi City Ngozi City 30 19 33 32
13 Inter Star Inter Star 30 20 47 29
14 Nyanza United Nyanza 30 32 47 27
15 Rusizi Rusizi 30 31 54 26
16 Muzinga Muzinga 30 14 46 23
TEMPORADA 2015/2016
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Vital'O Vital'O 31 73 17 77
2 Le Messager Ngozi Messager 31 43 21 60
3 Muzinga Muzinga 30 41 21 53
4 Aigle Noir Aigle Noir 30 33 21 47
5 LLB Académic Académic 30 43 29 46
6 Bujumbura City Bujumbura 31 31 19 46
7 Athlético Olympic Athlético 32 38 36 42
8 Olympic Star Olympic Star 30 26 26 41
9 Flambeau de l'Est Flambeau 31 31 36 37
10 Le Messager de Bujumbura Messager 32 29 45 37
11 Olympic Muremera Olympic 30 24 40 34
12 Nyanza United Nyanza 30 32 44 31
13 Inter Star Inter Star 31 22 36 30
14 Jeunes Athlétiques Jeunes 32 24 51 30
15 Les Crocos Les Crocos 31 18 36 29
16 Les Eléphants Eléphants 30 23 53 21
TEMPORADA 2014/2015
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Vital'O Vital'O 30 66 13 72
2 LLB Académic Académic 30 47 18 59
3 Bujumbura City Bujumbura 30 39 25 53
4 Le Messager Ngozi Messager 29 43 23 50
5 Athlético Olympic Athlético 30 28 20 47
6 Inter Star Inter Star 30 34 30 44
7 Muzinga Muzinga 30 32 30 40
8 Rusizi Rusizi 30 25 25 40
9 Olympic Star Olympic Star 30 28 23 39
10 Flambeau de l'Est Flambeau 30 34 32 39
11 Le Messager de Bujumbura Messager 30 25 28 33
12 Jeunes Athlétiques Jeunes 30 24 41 31
13 Volontaires Volontaires 30 26 41 30
14 Prince Louis Prince Louis 30 32 51 30
15 Nyanza United Nyanza 29 21 35 29
16 Académie Tchité Académie 30 18 87 17
TEMPORADA 2013/2014
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Flambeau de l'Est Flambeau 26 51 10 60
2 LLB Académic Académic 26 45 9 59
3 Inter Star Inter Star 25 53 18 48
4 Le Messager Ngozi Messager 26 44 27 47
5 Vital'O Vital'O 26 31 18 44
6 Athlético Olympic Athlético 26 24 20 40
7 Prince Louis Prince Louis 26 32 28 39
8 Guêpiers du Lac Guêpiers 25 31 22 36
9 Muzinga Muzinga 26 30 35 28
10 Académie Tchité Académie 26 18 29 28
11 Jeunes Athlétiques Jeunes 26 22 41 27
12 Volontaires Volontaires 26 15 51 23
13 Espoir Mutimbuzi Espoir 26 13 52 10
14 Flamengo Ngagara Flamengo 26 12 61 8
TEMPORADA 2012/2013
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Flambeau de l'Est Flambeau 22 29 6 47
2 Athlético Olympic Athlético 22 41 18 43
3 LLB Académic Académic 22 35 17 43
4 Vital'O Vital'O 22 45 22 42
5 Le Messager Ngozi Messager 22 25 24 31
6 Muzinga Muzinga 22 30 29 30
7 Inter Star Inter Star 22 29 28 30
8 Jeunes Athlétiques Jeunes 22 22 23 29
9 Académie Tchité Académie 22 18 29 27
10 Prince Louis Prince Louis 22 20 40 22
11 Flamengo Ngagara Flamengo 22 24 41 17
12 Espoir Mutimbuzi Espoir 22 6 47 6
TEMPORADA 2011/2012
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Vital'O Vital'O 22 54 14 53
2 Athlético Olympic Athlético 22 45 12 50
3 LLB Académic Académic 22 37 17 44
4 Flambeau de l'Est Flambeau 22 23 17 35
5 Inter Star Inter Star 22 33 25 32
6 Muzinga Muzinga 22 26 32 29
7 Jeunes Athlétiques Jeunes 22 24 23 28
8 Académie Tchité Académie 22 17 31 18
9 Espoir Mutimbuzi Espoir 22 10 29 18
10 Kamenge FC Kamenge FC 22 20 44 17
11 Flamengo Ngagara Flamengo 22 19 45 17
12 Union Sporting Union 22 17 36 14
TEMPORADA 2010/2011
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Athlético Olympic Athlético 22 45 6 58
2 LLB Académic Académic 22 50 15 49
3 Vital'O Vital'O 22 42 12 46
4 Inter Star Inter Star 22 36 20 43
5 Jeunes Athlétiques Jeunes 22 30 36 30
6 Union Sporting Union 22 32 36 27
7 Muzinga Muzinga 22 26 40 26
8 Académie Tchité Académie 22 16 27 25
9 Espoir Mutimbuzi Espoir 22 20 31 23
10 Prince Louis Prince Louis 22 30 34 19
11 Flamengo Ngagara Flamengo 22 20 33 19
12 Maniema Fantastique Maniema 22 15 72 4

  USO DE MEMORIA  
6,556,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.6253
Total Execution Time  0.6268
  CADENA URL  
/historico/Vital-O-Fc
  GET DATOS  
$_GET['/historico/Vital-O-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
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 = 'Vital-O-Fc' 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.0129  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=58981 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=58981 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=58981 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=58981 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 73193
0.0133  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 = 75952
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=58981 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=331 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 331 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (389309,821541,820545,820131,817945) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '58981' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '58981' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 73193 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 75952 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=58981 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75952,73193,71432) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73193 AND teamId = 58981
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 75952 AND teamId = 58981
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 58981
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 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 = 73193 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = 73193 WHERE rp.league_id = 73193 AND rp.teamId = 58981 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.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 = 73193 WHERE rp.league_id = 73193 AND rp.teamId = 58981 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 = 73193 WHERE rp.league_id = 73193 AND rp.teamId = 58981 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 58981 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 73193 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 68728 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.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 `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 = 63883 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.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 `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 = 58403 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.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 `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 = 51030 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.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 `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 = 44926 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 40147 AND t.round = 30 ORDER BY team.conference 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 `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 = 34813 AND t.round = 30 ORDER BY team.conference 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 `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 = 15788 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 `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 = 8580 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 16354 AND t.round = 26 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 `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 = 16355 AND t.round = 22 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 `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 = 16356 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 16357 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC