4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Panthères
TEMPORADA 2023/2024
LIGA BENÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Buffles de Borgou Buffles 7 8 4 15
2 Tonnerre FC Tonnerre FC 7 7 5 12
3 Abeilles FC Abeilles FC 7 11 8 11
4 Hodio FC Hodio FC 7 8 5 11
5 Béké Bembèrèkè Béké 7 8 6 11
6 Panthères Panthères 7 6 7 10
7 Dynamo Unacob Dynamo 7 8 10 8
8 Réal Sport Réal Sport 7 5 7 7
9 Soleil FC Soleil FC 7 7 10 5
10 Dynamique FC Dynamique 7 5 11 5
11 Jeunesse Athletique De Keto Jeunesse 7 14 7 14
12 ASVO ASVO 7 8 4 12
13 Etoile Filante Etoile 7 6 5 11
14 Adjidja FC Adjidja FC 7 7 6 10
15 AS Police AS Police 7 5 4 10
16 Aïnonvi Aïnonvi 7 6 7 10
17 JSO JSO 7 4 5 8
18 Djeffa FC Djeffa FC 7 5 7 7
19 Aziza Aziza 7 8 13 7
20 Avrankou Omnisport Avrankou 7 4 9 4
TEMPORADA 2022/2023
LIGA BENÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Tonnerre FC Tonnerre FC 10 13 4 21
2 Soleil FC Soleil FC 10 19 12 18
3 Dynamo Unacob Dynamo 10 14 10 15
4 Hodio FC Hodio FC 10 10 9 15
5 Réal Sport Réal Sport 10 8 6 13
6 Espoir FC Espoir FC 10 5 6 12
7 Dynamique FC Dynamique 10 9 13 11
8 Béké Bembèrèkè Béké 10 6 11 11
9 Panthères Panthères 10 9 14 10
10 Energie Energie 10 7 15 6
11 Djeffa FC Djeffa FC 10 15 9 17
12 AS Sobemap AS Sobemap 10 11 7 17
13 JSP JSP 10 13 10 17
14 Adjidja FC Adjidja FC 10 15 9 16
15 JSO JSO 10 9 9 15
16 Aziza Aziza 10 12 12 14
17 Avrankou Omnisport Avrankou 10 14 17 12
18 AS Police AS Police 10 6 17 11
19 Eternel FC Eternel FC 10 7 11 10
20 Sitatunga Sitatunga 10 12 13 9
TEMPORADA 2021/2022
LIGA BENÍN GRUPO 2
Equipo PJ GF GC Puntos
1 Coton Sport FC Coton Sport 24 33 17 49
2 Buffles de Borgou Buffles 24 31 12 47
3 Loto Popo Loto Popo 24 27 12 47
4 Espoir FC Espoir FC 24 34 21 46
5 ASVO ASVO 24 31 17 43
6 Dynamo Abomey Dynamo 24 33 27 42
7 Ayema Ayema 24 27 24 36
8 AS Cotonou AS Cotonou 24 29 22 33
9 Dadje FC Dadje FC 24 25 21 32
10 Panthères Panthères 24 22 29 30
11 Djeffa FC Djeffa FC 24 17 26 27
12 Béké Bembèrèkè Béké 24 15 26 24
13 JSP JSP 24 28 43 21
14 Cavaliers Cavaliers 24 23 40 21
15 Eternel FC Eternel FC 24 14 27 20
16 Adjidja FC Adjidja FC 24 14 39 12
TEMPORADA 2020/2021
LIGA BENÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Dynamo Abomey Dynamo 12 22 10 27
2 Tonnerre FC Tonnerre FC 12 17 8 25
3 Espoir FC Espoir FC 12 18 15 23
4 Dadje FC Dadje FC 12 11 8 17
5 Panthères Panthères 10 16 14 15
6 Tanéka FC Tanéka FC 10 6 8 15
7 Energie Energie 12 9 12 15
8 Cavaliers Cavaliers 10 9 10 8
9 Tukunnin Tukunnin 10 11 16 7
10 Réal Sport Réal Sport 10 3 11 4
11 Dynamique FC Dynamique 10 8 18 4
12 JSP JSP 12 16 9 26
13 AS Sobemap AS Sobemap 12 16 8 23
14 ASVO ASVO 12 16 5 22
15 Avrankou Omnisport Avrankou 12 16 8 22
16 ASPAC ASPAC 10 11 5 20
17 Djeffa FC Djeffa FC 12 8 4 18
18 AS Police AS Police 10 6 9 10
19 Aziza Aziza 10 8 20 6
20 Adjidja FC Adjidja FC 10 2 10 4
21 Jeunesse Athletique De Keto Jeunesse 10 3 13 4
22 Soleil FC Soleil FC 10 4 15 4
TEMPORADA 2019/2020
LIGA BENÍN
Equipo PJ GF GC Puntos
1 Ayema Ayema 19 29 13 36
2 ESAE ESAE 19 17 11 35
3 Buffles de Borgou Buffles 19 17 9 30
4 Dragons de l'Ouémé Dragons 19 19 12 29
5 Panthères Panthères 19 19 15 28
6 ASPAC ASPAC 19 21 16 27
7 Béké Bembèrèkè Béké 19 21 16 26
8 Tonnerre FC Tonnerre FC 19 17 17 25
9 Energie Energie 19 16 16 23
10 JSP JSP 19 16 20 23
11 Réal Sport Réal Sport 19 13 17 23
12 ASVO ASVO 19 16 18 22
13 Jeunesse Athletique De Keto Jeunesse 19 15 20 21
14 Dynamo Unacob Dynamo 19 14 20 21
15 AS Sobemap AS Sobemap 19 14 29 18
16 Aziza Aziza 19 12 27 11
TEMPORADA 2018/2019
LIGA BENÍN
Equipo PJ GF GC Puntos
1 Buffles de Borgou Buffles 27 20 12 46
2 Ayema Ayema 28 30 19 45
3 Béké Bembèrèkè Béké 28 31 21 45
4 ASPAC ASPAC 29 26 23 44
5 Panthères Panthères 29 38 37 43
6 JSP JSP 27 24 21 40
7 Dragons de l'Ouémé Dragons 27 30 25 39
8 AS Sobemap AS Sobemap 28 19 19 39
9 Tonnerre FC Tonnerre FC 28 20 19 37
10 Jeunesse Athletique De Keto Jeunesse 28 22 22 37
11 Avrankou Omnisport Avrankou 29 23 23 36
12 ESAE ESAE 27 22 23 36
13 ASOS ASOS 29 24 28 36
14 Aziza Aziza 29 26 37 36
15 Dynamo Abomey Dynamo 27 28 27 34
16 ASVO ASVO 27 19 18 34
17 Energie Energie 27 20 24 30
18 Soleil FC Soleil FC 28 25 49 19
19 AS Police AS Police 0 0 0 0
TEMPORADA 2016/2017
LIGA BENÍN
Equipo PJ GF GC Puntos
1 Béké Bembèrèkè Béké 11 11 5 22
2 Buffles de Borgou Buffles 10 12 5 19
3 Energie Energie 10 10 4 19
4 ASPAC ASPAC 11 15 7 18
5 Panthères Panthères 9 11 13 12
6 Dynamo Abomey Dynamo 10 3 8 9
7 Agonlin Agonlin 10 8 17 8
8 Tonnerre FC Tonnerre FC 8 7 10 5
9 AS Police AS Police 7 4 12 4
10 ESAE ESAE 12 10 6 20
11 Jeunesse Athletique De Keto Jeunesse 11 11 5 18
12 ASOS ASOS 10 10 4 16
13 AS Sobemap AS Sobemap 11 9 8 16
14 Ayema Ayema 12 8 8 16
15 Dragons de l'Ouémé Dragons 10 6 4 15
16 Avrankou Omnisport Avrankou 11 5 9 14
17 Soleil FC Soleil FC 11 7 6 13
18 Requins de l'Atlantique Requins 11 6 14 8
19 Mambas Noirs Mambas Noirs 11 5 13 8
TEMPORADA 2015/2016
LIGA BENÍN
Equipo PJ GF GC Puntos
1 ASPAC ASPAC 6 11 4 18
2 Energie Energie 5 6 5 9
3 Buffles de Borgou Buffles 6 7 8 7
4 Tonnerre FC Tonnerre FC 6 4 7 6
5 Mogas 90 Mogas 90 4 6 5 5
6 AS Police AS Police 4 5 6 5
7 Panthères Panthères 7 8 12 4
8 AS Sobemap AS Sobemap 10 22 6 21
9 Jeunesse Athletique De Keto Jeunesse 8 9 5 17
10 ESAE ESAE 10 7 5 16
11 Ayema Ayema 9 7 10 10
12 Requins de l'Atlantique Requins 8 6 9 10
13 Dragons de l'Ouémé Dragons 10 8 16 10
14 ASOS ASOS 9 3 11 5
TEMPORADA 2014/2015
LIGA BENÍN
Equipo PJ GF GC Puntos
1 Avrankou Omnisport Avrankou 10 14 8 19
2 Tonnerre FC Tonnerre FC 10 12 6 18
3 AS Police AS Police 10 7 2 18
4 Béké Bembèrèkè Béké 10 10 6 17
5 Energie Energie 10 9 6 16
6 Agonlin Agonlin 10 10 8 15
7 Buffles de Borgou Buffles 9 10 7 12
8 Dragons de l'Ouémé Dragons 9 10 11 12
9 ASPAC ASPAC 10 7 8 12
10 AS Sobemap AS Sobemap 8 7 9 9
11 Panthères Panthères 10 7 12 9
12 Mogas 90 Mogas 90 10 8 11 8
13 Ayema Ayema 10 5 12 5
14 ASOS ASOS 10 2 12 3
TEMPORADA 2013/2014
LIGA BENÍN
Equipo PJ GF GC Puntos
1 Panthères Panthères 24 21 11 39
2 Buffles de Borgou Buffles 24 14 12 38
3 ASPAC ASPAC 24 21 18 36
4 Ayema Ayema 24 16 13 36
5 Dragons de l'Ouémé Dragons 24 26 19 34
6 AS Police AS Police 24 20 16 34
7 Avrankou Omnisport Avrankou 24 17 12 33
8 Energie Energie 24 20 17 33
9 AS Sobemap AS Sobemap 24 19 18 32
10 Mogas 90 Mogas 90 24 15 18 32
11 Tonnerre FC Tonnerre FC 24 15 17 30
12 ASOS ASOS 24 9 18 20
13 Jeunesse Athletique De Keto Jeunesse 13 4 17 9
14 ESAE ESAE 13 5 16 7
TEMPORADA 2012/2013
LIGA BENÍN
Equipo PJ GF GC Puntos
1 Jeunesse Athletique De Keto Jeunesse 24 21 9 44
2 Panthères Panthères 24 23 21 36
3 ASOS ASOS 24 20 18 36
4 Dragons de l'Ouémé Dragons 24 23 17 35
5 Tonnerre FC Tonnerre FC 24 22 21 35
6 AS Police AS Police 24 21 19 33
7 Avrankou Omnisport Avrankou 24 13 16 32
8 ASPAC ASPAC 24 23 17 31
9 Mogas 90 Mogas 90 24 26 28 28
10 Buffles de Borgou Buffles 24 15 22 27
11 ESAE ESAE 24 14 20 26
12 AS Sobemap AS Sobemap 24 20 21 24
13 Akanke Akanke 24 13 25 21
14 Soleil FC Soleil FC 0 0 0 0
TEMPORADA 2011/2012
LIGA BENÍN
Equipo PJ GF GC Puntos
1 ASPAC ASPAC 22 34 13 51
2 Tonnerre FC Tonnerre FC 22 24 17 40
3 Jeunesse Athletique De Keto Jeunesse 22 22 16 37
4 Dragons de l'Ouémé Dragons 22 17 13 33
5 ASOS ASOS 22 24 24 30
6 Mogas 90 Mogas 90 22 17 18 27
7 Panthères Panthères 22 19 20 26
8 AS Sobemap AS Sobemap 22 24 25 25
9 Buffles de Borgou Buffles 22 13 20 23
10 Avrankou Omnisport Avrankou 22 15 25 23
11 Soleil FC Soleil FC 22 16 22 21
12 ESAE ESAE 22 9 21 13
TEMPORADA 2010/2011
LIGA BENÍN
Equipo PJ GF GC Puntos
1 Tonnerre FC Tonnerre FC 16 19 10 29
2 Soleil FC Soleil FC 16 18 15 27
3 Avrankou Omnisport Avrankou 16 14 12 26
4 CIFAS CIFAS 17 20 14 25
5 Mogas 90 Mogas 90 17 23 20 25
6 Jeunesse Athletique De Keto Jeunesse 16 12 13 25
7 AS Sobemap AS Sobemap 17 14 17 24
8 ASPAC ASPAC 16 14 10 23
9 Buffles de Borgou Buffles 16 12 13 22
10 Mambas Noirs Mambas Noirs 16 19 22 21
11 Dynamo Abomey Dynamo 17 7 8 19
12 Dragons de l'Ouémé Dragons 16 15 18 17
13 Panthères Panthères 17 14 24 16
14 Requins de l'Atlantique Requins 17 13 18 15

  USO DE MEMORIA  
6,451,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1428
Total Execution Time  0.1443
  CADENA URL  
/historico/Pantheres
  GET DATOS  
$_GET['/historico/Pantheres']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0048  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 = 'Pantheres' 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.0018  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=12023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038  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 = 75495
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12023 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=328 AND type_rel = 3
0.0027  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 = '12023' ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '12023' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '12023' 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 = 75495 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=12023 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 (75495) 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 = 75495 AND teamId = 12023
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 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 = 75495 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '12023' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12023' and rp.type = 4
0.0021  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 = '12023' 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 = 75495 WHERE rp.league_id = 75495 AND rp.teamId = 12023 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 = 75495 WHERE rp.league_id = 75495 AND rp.teamId = 12023 AND (e.action = 4 or e.action = 5) 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 = 75495 WHERE rp.league_id = 75495 AND rp.teamId = 12023 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 12023 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0028  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 = 74380 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.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 `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 = 75495 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 70484 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.0031  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 = 71172 AND t.round = 10 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 = 65691 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.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 `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 = 66924 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 61294 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.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 `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 = 62345 AND t.round = 12 ORDER BY team.conference ASC,t.position 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 `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 = 51514 AND t.round = 19 ORDER BY team.conference ASC,t.position 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 `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 = 48416 AND t.round = 32 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 `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 = 38939 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 23364 AND t.round = 14 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 `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 = 9097 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 `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 = 8958 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 `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 = 2701 AND t.round = 26 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 `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 = 8957 AND t.round = 22 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 `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 = 8956 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC