4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fovu Club
TEMPORADA 2023/2024
LIGA CAMERÚN GRUPO 3
Equipo PJ GF GC Puntos
1 Fortuna Mfou Fortuna Mfou 8 15 12 15
2 Fauve Azur Elite Fauve Azur. 8 9 6 14
3 PWD Bamenda PWD Bamenda 9 10 9 14
4 Les Astres Les Astres 8 15 13 13
5 Union Douala Union Douala 8 5 3 13
6 Bamboutos Bamboutos 8 7 6 11
7 APEJES Academy APEJES 8 8 9 11
8 UMS de Loum UMS de Loum 8 10 10 9
9 Aigle Royal Aigle Royal 9 11 14 9
10 Avion Academy Avion 8 6 9 5
11 Fovu Club Fovu Club 8 10 15 5
TEMPORADA 2022/2023
LIGA CAMERÚN GRUPO 1
Equipo PJ GF GC Puntos
1 Canon Yaoundé Canon 20 31 14 38
2 UMS de Loum UMS de Loum 20 23 19 37
3 Cotonsport Cotonsport 20 21 13 36
4 PWD Bamenda PWD Bamenda 20 18 18 25
5 Stade Renard Stade Renard 20 15 17 24
6 Aigle Royal Aigle Royal 20 16 22 24
7 Djiko FC Djiko FC 20 20 21 23
8 Colombe Sportive Colombe 20 17 19 23
9 Eding Sport Eding Sport 20 12 15 23
10 Renaissance Renaissance 20 18 24 22
11 Avion Academy Avion 20 21 30 22
12 Gazelle Gazelle 20 27 18 35
13 Bamboutos Bamboutos 20 21 12 34
14 APEJES Academy APEJES 20 32 24 34
15 Fovu Club Fovu Club 20 24 19 31
16 Union Douala Union Douala 20 18 17 27
17 Fauve Azur Elite Fauve Azur. 20 23 23 27
18 Les Astres Les Astres 20 23 29 27
19 Fortuna Mfou Fortuna Mfou 20 25 29 26
20 Young Sport Academy Young Sport 20 20 21 24
21 Yafoot Yafoot 20 24 30 22
22 Dragon de Yaoundé Dragon 20 19 34 10
TEMPORADA 2021/2022
LIGA CAMERÚN GRUPO 1
Equipo PJ GF GC Puntos
1 Les Astres Les Astres 26 40 22 54
2 Canon Yaoundé Canon 25 35 21 48
3 Colombe Sportive Colombe 25 49 30 41
4 Union Douala Union Douala 25 32 27 39
5 Stade Renard Stade Renard 25 35 28 37
6 Djiko FC Djiko FC 24 29 27 36
7 APEJES Academy APEJES 23 26 29 34
8 Fortuna Mfou Fortuna Mfou 24 44 43 32
9 Young Sport Academy Young Sport 25 24 29 29
10 Fauve Azur Elite Fauve Azur. 24 37 42 28
11 Panthère Panthère 25 29 37 28
12 Racing de Bafoussam Racing 26 25 42 17
13 Tonnerre Tonnerre 25 18 46 17
14 Eding Sport Eding Sport 23 30 12 50
15 Cotonsport Cotonsport 23 39 14 45
16 PWD Bamenda PWD Bamenda 22 26 22 33
17 Fovu Club Fovu Club 22 20 19 33
18 Bamboutos Bamboutos 22 24 21 32
19 UMS de Loum UMS de Loum 22 24 19 31
20 Avion Academy Avion 22 20 20 27
21 Dragon de Yaoundé Dragon 22 25 35 23
22 Renaissance Renaissance 22 20 30 23
23 Yafoot Yafoot 23 21 27 22
24 New Star New Star 23 17 30 21
25 OFTA OFTA 22 16 33 19
TEMPORADA 2020/2021
LIGA CAMERÚN GRUPO 1
Equipo PJ GF GC Puntos
1 Fortuna Mfou Fortuna Mfou 22 32 19 43
2 Stade Renard Stade Renard 22 23 12 39
3 Fovu Club Fovu Club 22 32 21 38
4 Bamboutos Bamboutos 22 30 20 37
5 PWD Bamenda PWD Bamenda 20 22 14 33
6 Avion Academy Avion 22 20 23 24
7 Djiko FC Djiko FC 22 25 29 24
8 Eding Sport Eding Sport 22 23 28 23
9 Union Douala Union Douala 21 13 22 21
10 Dragon de Yaoundé Dragon 22 24 40 17
11 Yafoot Yafoot 22 12 35 11
12 Les Astres Les Astres 37 34 33 51
13 Cotonsport Cotonsport 18 32 13 32
14 Young Sport Academy Young Sport 18 24 13 27
15 Canon Yaoundé Canon 18 18 15 27
16 APEJES Academy APEJES 18 18 17 27
17 UMS de Loum UMS de Loum 18 13 11 25
18 Colombe Sportive Colombe 18 21 20 23
19 Tonnerre Tonnerre 18 15 20 21
20 Panthère Panthère 18 18 25 21
21 New Star New Star 18 11 30 16
TEMPORADA 2019/2020
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 PWD Bamenda PWD Bamenda 28 36 28 47
2 Cotonsport Cotonsport 29 39 29 46
3 Colombe Sportive Colombe 28 33 27 45
4 Bamboutos Bamboutos 28 30 22 41
5 Djiko FC Djiko FC 28 31 27 41
6 Young Sport Academy Young Sport 28 39 37 40
7 Fovu Club Fovu Club 28 29 28 40
8 Union Douala Union Douala 28 30 27 39
9 UMS de Loum UMS de Loum 28 23 19 38
10 Eding Sport Eding Sport 29 30 43 38
11 APEJES Academy APEJES 28 30 33 37
12 Canon Yaoundé Canon 28 30 30 36
13 Stade Renard Stade Renard 28 28 24 35
14 Fortuna Mfou Fortuna Mfou 28 29 25 34
15 Panthère Panthère 28 18 24 33
16 Avion Academy Avion 28 24 35 33
17 Tonnerre Tonnerre 28 19 22 32
18 Dragon de Yaoundé Dragon 28 25 43 28
TEMPORADA 2018/2019
LIGA CAMERÚN GRUPO 3
Equipo PJ GF GC Puntos
1 Fovu Club Fovu Club 5 7 3 10
2 Les Astres Les Astres 5 4 1 10
3 Union Douala Union Douala 5 3 2 8
4 PWD Bamenda PWD Bamenda 5 4 3 7
5 New Star New Star 5 6 7 4
6 Unisport Bafang Unisport 5 1 9 1
TEMPORADA 2017/2018
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 Cotonsport Cotonsport 34 59 24 69
2 UMS de Loum UMS de Loum 34 25 16 55
3 Bamboutos Bamboutos 34 32 21 53
4 New Star New Star 34 29 31 49
5 Fovu Club Fovu Club 34 30 32 48
6 Young Sport Academy Young Sport 34 20 15 47
7 Union Douala Union Douala 34 35 34 46
8 Eding Sport Eding Sport 34 37 35 46
9 Colombe Sportive Colombe 34 29 25 45
10 Djiko FC Djiko FC 34 33 39 45
11 Dragon de Yaoundé Dragon 34 42 45 44
12 APEJES Academy APEJES 34 43 42 44
13 Fortuna Mfou Fortuna Mfou 34 36 41 42
14 Les Astres Les Astres 34 31 29 42
15 Stade Renard Stade Renard 34 27 29 42
16 Unisport Bafang Unisport 34 24 29 40
17 Aigle Royal Aigle Royal 34 26 42 32
18 Yafoot Yafoot 34 17 46 26
TEMPORADA 2016/2017
SEGUNDA CAMERÚN
Equipo PJ GF GC Puntos
1 Yafoot Yafoot 34 47 27 60
2 Fortuna Mfou Fortuna Mfou 34 41 23 60
3 Fovu Club Fovu Club 34 42 27 58
4 Panthère Panthère 34 36 22 57
5 Bang Bullet Bang Bullet 34 29 22 55
6 Renaissance Renaissance 34 44 38 51
7 Avion Academy Avion 34 37 31 50
8 Dynamo de Douala Dynamo 34 32 31 49
9 Tonnerre Tonnerre 34 30 31 44
10 National Polytechnic National 34 29 30 42
11 Cosmos de Bafia Cosmos Bafia 34 25 29 42
12 Universite Ngaoundere Universite 34 36 49 42
13 Etoa Meki Etoa Meki 34 35 36 38
14 PWD Bamenda PWD Bamenda 34 15 22 36
15 AS Matelots AS Matelots 34 29 46 36
16 Panthère Security Panthère 34 31 46 35
17 Botafogo de Douala Botafogo 34 34 46 34
18 Douala AC Douala AC 34 24 40 30
TEMPORADA 2014/2015
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 Cotonsport Cotonsport 34 43 25 65
2 Union Douala Union Douala 34 42 24 61
3 New Star New Star 34 41 23 58
4 Botafogo FC Botafogo FC 34 35 25 58
5 APEJES Academy APEJES 34 33 24 49
6 Panthère Panthère 34 32 27 49
7 Unisport Bafang Unisport 34 33 28 48
8 Young Sport Academy Young Sport 34 34 33 48
9 Dragon de Yaoundé Dragon 34 30 33 46
10 Bamboutos Bamboutos 34 29 31 44
11 Lion Blessé Lion Blessé 34 29 30 42
12 UMS de Loum UMS de Loum 34 28 30 42
13 Les Astres Les Astres 34 35 36 41
14 Cosmos de Bafia Cosmos Bafia 34 21 28 41
15 Fovu Club Fovu Club 34 32 36 40
16 Canon Yaoundé Canon 34 33 43 38
17 Njalla Quan Njalla Quan 34 19 38 31
18 Tonnerre Tonnerre 34 13 48 18
TEMPORADA 2013/2014
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 Cotonsport Cotonsport 36 57 18 75
2 Cosmos de Bafia Cosmos Bafia 36 45 33 66
3 Unisport Bafang Unisport 36 32 21 65
4 UMS de Loum UMS de Loum 36 32 30 60
5 APEJES Academy APEJES 36 45 40 59
6 Les Astres Les Astres 36 47 41 57
7 New Star New Star 36 39 28 56
8 Bamboutos Bamboutos 36 34 30 55
9 Fovu Club Fovu Club 36 31 27 50
10 Union Douala Union Douala 36 41 35 47
11 Panthère Panthère 36 33 29 47
12 Young Sport Academy Young Sport 36 25 30 45
13 Canon Yaoundé Canon 36 34 42 42
14 Tonnerre Tonnerre 36 39 41 41
15 Njalla Quan Njalla Quan 36 26 32 39
16 Renaissance Renaissance 36 36 46 39
17 Scorpion de Bé Scorpion 36 35 61 39
18 Sable Batié Sable Batié 36 23 48 32
19 Douala AC Douala AC 36 30 52 20
TEMPORADA 2012/2013
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 Cotonsport Cotonsport 26 45 20 46
2 Les Astres Les Astres 26 29 20 44
3 Union Douala Union Douala 26 35 22 41
4 Unisport Bafang Unisport 26 17 15 40
5 Canon Yaoundé Canon 26 24 28 35
6 Njalla Quan Njalla Quan 26 29 25 34
7 Fovu Club Fovu Club 26 25 23 34
8 Young Sport Academy Young Sport 26 17 23 34
9 Renaissance Renaissance 26 25 33 32
10 Douala AC Douala AC 26 26 26 31
11 New Star New Star 26 23 29 30
12 Panthère Panthère 26 18 27 29
13 Tonnerre Tonnerre 26 19 30 26
14 Sable Batié Sable Batié 26 12 23 26
TEMPORADA 2009/2010
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 Cotonsport Cotonsport 26 50 20 57
2 Les Astres Les Astres 26 37 21 47
3 Tiko United Tiko United 26 29 21 45
4 Panthère Panthère 26 28 24 41
5 Young Sport Academy Young Sport 26 26 17 36
6 Unisport Bafang Unisport 26 26 25 36
7 Union Douala Union Douala 26 33 29 32
8 Canon Yaoundé Canon 26 27 25 32
9 Renaissance Renaissance 26 23 30 32
10 Universite Ngaoundere Universite 26 18 25 32
11 Sable Batié Sable Batié 26 18 27 32
12 Fovu Club Fovu Club 26 23 26 31
13 AS Matelots AS Matelots 26 22 42 25
14 Roumde Adjia Roumde Adjia 26 21 49 15
TEMPORADA 2008/2009
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 Tiko United Tiko United 25 30 19 48
2 Cotonsport Cotonsport 26 38 21 45
3 Union Douala Union Douala 26 31 23 45
4 Les Astres Les Astres 26 31 25 42
5 Fovu Club Fovu Club 26 29 27 36
6 Panthère Panthère 26 26 24 35
7 Unisport Bafang Unisport 26 28 28 35
8 Canon Yaoundé Canon 26 32 26 34
9 AS Matelots AS Matelots 26 24 26 34
10 Universite Ngaoundere Universite 26 23 25 32
11 Sable Batié Sable Batié 26 25 29 32
12 Aigle Royal Aigle Royal 26 19 24 30
13 Mount Cameroon Mount 26 23 40 19
14 Danay FC Danay FC 25 17 39 19
TEMPORADA 2007/2008
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 Cotonsport Cotonsport 30 42 16 58
2 Canon Yaoundé Canon 30 30 21 51
3 Union Douala Union Douala 30 28 20 45
4 Les Astres Les Astres 30 29 27 44
5 Fovu Club Fovu Club 30 28 22 43
6 Tiko United Tiko United 30 34 34 41
7 Universite Ngaoundere Universite 30 20 23 40
8 Unisport Bafang Unisport 30 20 18 39
9 Aigle Royal Aigle Royal 30 20 24 38
10 Mount Cameroon Mount 30 23 28 38
11 Caiman Douala Caiman 30 30 29 37
12 Sable Batié Sable Batié 30 20 27 37
13 Foudre Foudre 30 17 28 37
14 Esperance de Guider Esperance 30 24 27 35
15 Tonnerre Tonnerre 30 26 30 31
16 Lion Ngoma Lion Ngoma 30 24 41 26
TEMPORADA 2006/2007
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 Cotonsport Cotonsport 34 55 11 75
2 Union Douala Union Douala 34 50 23 70
3 Mount Cameroon Mount 34 47 23 66
4 Canon Yaoundé Canon 34 37 26 57
5 Fovu Club Fovu Club 34 33 24 54
6 Les Astres Les Astres 34 42 34 51
7 Aigle Royal Aigle Royal 34 29 27 49
8 Tonnerre Tonnerre 34 28 24 47
9 Lion Ngoma Lion Ngoma 34 26 32 47
10 Universite Ngaoundere Universite 34 40 36 43
11 Foudre Foudre 34 32 37 42
12 Sable Batié Sable Batié 34 31 37 42
13 Bamboutos Bamboutos 34 31 39 42
14 Esperance de Guider Esperance 34 23 31 42
15 AS Cetef AS Cetef 34 35 43 36
16 Sahel FC Sahel FC 34 24 43 31
17 Federal Sporting Federal 34 26 50 26
18 CPSA CPSA 34 17 66 10
TEMPORADA 2005/2006
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 Cotonsport Cotonsport 30 50 22 53
2 Les Astres Les Astres 30 36 24 47
3 Canon Yaoundé Canon 29 35 21 46
4 Fovu Club Fovu Club 30 29 17 45
5 Esperance de Guider Esperance 30 28 30 41
6 Aigle Royal Aigle Royal 30 28 35 40
7 Foudre Foudre 30 27 30 39
8 Sable Batié Sable Batié 30 27 26 38
9 Bamboutos Bamboutos 30 25 28 38
10 Sahel FC Sahel FC 30 34 39 38
11 Union Douala Union Douala 30 23 22 37
12 Federal Sporting Federal 30 29 39 37
13 Impots FC Impots FC 30 37 36 36
14 Mount Cameroon Mount 29 26 31 35
15 Racing de Bafoussam Racing 29 23 31 27
16 Academy de Douala Academy 29 15 41 19
TEMPORADA 2004/2005
LIGA CAMERÚN
Equipo PJ GF GC Puntos
1 Cotonsport Cotonsport 34 47 18 71
2 Fovu Club Fovu Club 34 39 32 54
3 Sahel FC Sahel FC 34 38 37 52
4 Canon Yaoundé Canon 34 38 29 51
5 Les Astres Les Astres 34 47 41 51
6 Foudre Foudre 34 43 33 50
7 Aigle Royal Aigle Royal 33 34 29 50
8 Sable Batié Sable Batié 34 37 29 49
9 Esperance de Guider Esperance 34 30 34 45
10 Bamboutos Bamboutos 34 31 27 44
11 Racing de Bafoussam Racing 34 23 30 44
12 Academy de Douala Academy 33 45 52 42
13 Union Douala Union Douala 33 43 41 41
14 PWD Bamenda PWD Bamenda 34 22 37 40
15 Tonnerre Tonnerre 34 32 40 39
16 Mount Cameroon Mount 33 26 28 37
17 Universite Ngaoundere Universite 34 23 40 33
18 Unisport Bafang Unisport 34 27 48 29

  USO DE MEMORIA  
7,062,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1440
Total Execution Time  0.1452
  CADENA URL  
/historico/Fovu-Club
  GET DATOS  
$_GET['/historico/Fovu-Club']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0039  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 = 75600
0.0026  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 = 74208
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11557 AND type_rel = 2
0.0022  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 = '11557' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 75600 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=11557 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (75600,74233) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75600 AND teamId = 11557
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74233 AND teamId = 11557
0.0021  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 = '11557' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11557' and rp.type = 4
0.0020  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 = '11557' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 75600 WHERE rp.league_id = 75600 AND rp.teamId = 11557 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.0020  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 = 75600 WHERE rp.league_id = 75600 AND rp.teamId = 11557 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 75600 WHERE rp.league_id = 75600 AND rp.teamId = 11557 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 11557 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74208 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 75600 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 70081 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 66992 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045  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 = 60033 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 48789 AND t.round = 19 ORDER BY team.conference 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 `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 = 49724 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 42712 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 49262 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 9544 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 = 3751 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 9050 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 9047 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 9046 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 9045 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 9044 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 9043 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 9042 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC