4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA TUNECINA GRUPO 2
Equipo PJ GF GC Puntos
TEMPORADA 2022/2023
LIGA TUNECINA GRUPO 2
Equipo PJ GF GC Puntos
1 Etoile Sahel Etoile Sahel 14 19 3 34
2 ES Tunis ES Tunis 14 20 10 28
3 Club Africain Club 14 17 9 27
4 Monastir Monastir 14 23 14 26
5 Ben Guerdane Guerdane 14 18 16 21
6 CS Sfaxien CS Sfaxien 14 12 10 18
7 Olympique Béja Olympique 14 9 20 16
8 US Tataouine Tataouine 14 6 42 4
TEMPORADA 2021/2022
LIGA TUNECINA GRUPO 2
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 10 16 8 24
2 Monastir Monastir 10 16 9 22
3 CS Sfaxien CS Sfaxien 10 10 7 16
4 Club Africain Club 10 6 10 15
5 Etoile Sahel Etoile Sahel 10 13 11 13
6 Ben Guerdane Guerdane 10 3 19 3
TEMPORADA 2020/2021
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 26 37 16 60
2 Etoile Sahel Etoile Sahel 26 46 26 50
3 Ben Guerdane Guerdane 26 25 16 41
4 AS Soliman AS Soliman 26 35 34 40
5 CS Sfaxien CS Sfaxien 26 29 16 40
6 Rejiche Rejiche 26 27 23 36
7 Club Africain Club 26 26 30 33
8 US Tataouine Tataouine 26 24 30 33
9 Etoile Metlaoui Etoile 26 17 21 32
10 Monastir Monastir 26 28 29 31
11 CA Bizertin CA Bizertin 26 21 27 31
12 Olympique Béja Olympique 26 25 26 31
13 Stade Tunisien Stade 26 22 22 29
14 JS Kairouanaise Kairouanaise 26 14 60 3
TEMPORADA 2019/2020
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 26 41 12 62
2 CS Sfaxien CS Sfaxien 26 33 19 51
3 Monastir Monastir 26 36 19 45
4 Etoile Sahel Etoile Sahel 26 37 25 43
5 Club Africain Club 26 28 14 40
6 Stade Tunisien Stade 26 26 27 36
7 Ben Guerdane Guerdane 26 26 31 34
8 Chebba Chebba 26 33 33 30
9 AS Soliman AS Soliman 26 29 32 28
10 US Tataouine Tataouine 26 21 28 28
11 Etoile Metlaoui Etoile 26 23 34 25
12 CA Bizertin CA Bizertin 26 18 35 23
13 JS Kairouanaise Kairouanaise 26 19 41 22
14 Hammam-Lif Hammam-Lif 26 20 40 22
TEMPORADA 2018/2019
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 26 37 15 56
2 CS Sfaxien CS Sfaxien 26 34 15 52
3 Etoile Sahel Etoile Sahel 25 38 17 51
4 CA Bizertin CA Bizertin 26 31 27 38
5 Ben Guerdane Guerdane 26 22 21 38
6 Club Africain Club 26 22 24 37
7 Monastir Monastir 26 30 30 31
8 US Tataouine Tataouine 26 30 39 31
9 Etoile Metlaoui Etoile 26 22 26 30
10 Stade Tunisien Stade 25 27 34 28
11 Stade Gabésien Stade 26 22 30 26
12 JS Kairouanaise Kairouanaise 26 20 32 26
13 Hammam-Lif Hammam-Lif 26 17 23 25
14 Gabès Gabès 26 23 42 19
TEMPORADA 2017/2018
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 26 46 19 58
2 Etoile Sahel Etoile Sahel 26 38 17 47
3 Club Africain Club 26 36 21 47
4 CS Sfaxien CS Sfaxien 26 37 18 46
5 CA Bizertin CA Bizertin 26 40 32 37
6 Monastir Monastir 26 25 22 36
7 Etoile Metlaoui Etoile 26 30 35 34
8 JS Kairouanaise Kairouanaise 26 20 32 32
9 Stade Tunisien Stade 26 29 36 31
10 Gabès Gabès 26 25 32 29
11 Stade Gabésien Stade 26 15 21 28
12 Ben Guerdane Guerdane 26 22 34 26
13 Zarzis Zarzis 26 13 26 26
14 CO Médenine Médenine 26 12 43 17
TEMPORADA 2016/2017
LIGA TUNECINA GRUPO 2
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 10 18 2 26
2 Etoile Sahel Etoile Sahel 10 16 9 22
3 Club Africain Club 10 17 11 16
4 CS Sfaxien CS Sfaxien 10 11 10 12
5 Etoile Metlaoui Etoile 10 8 18 9
6 Ben Guerdane Guerdane 10 0 20 1
TEMPORADA 2015/2016
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 Etoile Sahel Etoile Sahel 30 57 17 77
2 ES Tunis ES Tunis 30 60 21 72
3 CS Sfaxien CS Sfaxien 30 57 21 72
4 Etoile Metlaoui Etoile 30 36 26 49
5 CA Bizertin CA Bizertin 30 21 21 43
6 Club Africain Club 30 42 38 39
7 CO Sidi Bouzid Sidi Bouzid 30 25 38 37
8 Hammam-Lif Hammam-Lif 30 27 32 36
9 JS Kairouanaise Kairouanaise 30 27 37 36
10 Marsa Marsa 30 25 35 34
11 Stade Gabésien Stade 30 28 35 33
12 Ben Guerdane Guerdane 30 21 30 33
13 Zarzis Zarzis 30 30 39 33
14 EGS Gafsa EGS Gafsa 30 31 41 30
15 AS Kasserine Kasserine 30 17 49 23
16 Stade Tunisien Stade 30 17 41 21
TEMPORADA 2014/2015
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 Club Africain Club 30 50 18 65
2 Etoile Sahel Etoile Sahel 30 47 17 64
3 ES Tunis ES Tunis 30 52 21 60
4 CS Sfaxien CS Sfaxien 30 35 21 47
5 Zarzis Zarzis 30 35 25 45
6 Stade Tunisien Stade 30 29 32 43
7 Marsa Marsa 30 33 37 43
8 CA Bizertin CA Bizertin 30 21 21 41
9 JS Kairouanaise Kairouanaise 30 32 33 38
10 Stade Gabésien Stade 30 20 28 37
11 Hammam-Lif Hammam-Lif 30 30 35 36
12 Etoile Metlaoui Etoile 30 24 40 32
13 EGS Gafsa EGS Gafsa 30 26 39 30
14 Monastir Monastir 30 20 30 25
15 Gabès Gabès 30 21 44 19
16 Sportive de Djerba Sportive 30 22 56 17
TEMPORADA 2013/2014
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 30 48 15 66
2 Etoile Sahel Etoile Sahel 30 36 15 56
3 CS Sfaxien CS Sfaxien 30 34 20 55
4 Club Africain Club 30 29 20 54
5 Marsa Marsa 30 28 25 43
6 CA Bizertin CA Bizertin 30 29 20 41
7 Stade Gabésien Stade 30 27 23 40
8 JS Kairouanaise Kairouanaise 30 26 25 35
9 Etoile Metlaoui Etoile 30 21 26 35
10 Monastir Monastir 30 28 32 34
11 Hammam-Lif Hammam-Lif 30 20 32 34
12 EGS Gafsa EGS Gafsa 30 25 39 34
13 Stade Tunisien Stade 30 19 33 32
14 Olympique Béja Olympique 30 22 32 29
15 LPTA Tozeur LPTA Tozeur 30 23 35 29
16 Grombalia Sports Grombalia 30 23 46 26
TEMPORADA 2012/2013
LIGA TUNECINA GRUPO 2
Equipo PJ GF GC Puntos
1 CS Sfaxien CS Sfaxien 6 11 7 13
2 ES Tunis ES Tunis 6 8 6 12
3 Etoile Sahel Etoile Sahel 6 6 6 9
4 Club Africain Club 6 2 8 1
TEMPORADA 2011/2012
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 30 61 22 69
2 CA Bizertin CA Bizertin 30 54 25 65
3 CS Sfaxien CS Sfaxien 30 47 26 56
4 Etoile Sahel Etoile Sahel 30 33 22 49
5 Marsa Marsa 30 39 28 47
6 Club Africain Club 30 36 26 44
7 Monastir Monastir 30 31 34 36
8 Olympique Béja Olympique 30 31 35 36
9 EGS Gafsa EGS Gafsa 30 27 38 36
10 ES Hammam Sousse Hammam 30 29 37 35
11 Stade Tunisien Stade 30 28 37 34
12 JS Kairouanaise Kairouanaise 30 29 38 33
13 Zarzis Zarzis 30 36 52 31
14 Hammam-Lif Hammam-Lif 30 29 47 31
15 ES Beni-Khalled Beni-Khalled 30 24 44 21
16 Gabès Gabès 30 22 45 20
TEMPORADA 2010/2011
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 26 50 18 64
2 Etoile Sahel Etoile Sahel 26 49 24 59
3 CS Sfaxien CS Sfaxien 26 32 23 44
4 Club Africain Club 26 32 27 35
5 CA Bizertin CA Bizertin 26 23 29 35
6 Hammam-Lif Hammam-Lif 26 23 31 34
7 EGS Gafsa EGS Gafsa 26 28 34 32
8 JS Kairouanaise Kairouanaise 26 28 29 31
9 Stade Tunisien Stade 26 25 31 31
10 Marsa Marsa 26 27 33 30
11 Olympique Béja Olympique 26 25 29 29
12 Zarzis Zarzis 26 22 24 27
13 Gabès Gabès 26 19 32 24
14 ES Hammam Sousse Hammam 26 19 38 20
TEMPORADA 2009/2010
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 26 56 24 54
2 Club Africain Club 26 28 15 50
3 Etoile Sahel Etoile Sahel 26 41 27 46
4 CA Bizertin CA Bizertin 26 36 33 40
5 Stade Tunisien Stade 26 22 16 39
6 CS Sfaxien CS Sfaxien 26 32 26 37
7 Olympique Béja Olympique 26 28 32 32
8 JS Kairouanaise Kairouanaise 26 22 34 31
9 Hammam-Lif Hammam-Lif 26 30 32 30
10 Zarzis Zarzis 26 17 26 29
11 EGS Gafsa EGS Gafsa 26 29 39 28
12 ES Hammam Sousse Hammam 26 28 36 27
13 AS Kasserine Kasserine 26 22 46 27
14 Monastir Monastir 26 25 30 26

  USO DE MEMORIA  
6,286,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1400
Total Execution Time  0.1411
  CADENA URL  
/historico/Cs-Sfaxien
  GET DATOS  
$_GET['/historico/Cs-Sfaxien']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0047  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 = 'Cs-Sfaxien' 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.0021  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=864 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=864 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=864 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=864 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0049  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 = 75148
0.0030  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 = 73429
0.0030  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 = 75141
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=864 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 864 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (8498,43891,97938,137362,153633) ORDER BY n.cover_points DESC, update_date DESC
0.0043  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 = '864' ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '864' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '864' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 75141 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 75148 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=864 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (75148,75141,71507,71471,70466,70140) 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 = 75148 AND teamId = 864
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 70140 AND teamId = 864
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71507 AND teamId = 864
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71471 AND teamId = 864
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75141 AND teamId = 864
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 70466 AND teamId = 864
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 = '864' 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 = '864' 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 = '864' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 75148 WHERE rp.league_id = 75148 AND rp.teamId = 864 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.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 = 75148 WHERE rp.league_id = 75148 AND rp.teamId = 864 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 = 75148 WHERE rp.league_id = 75148 AND rp.teamId = 864 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 864 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 73429 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 75148 AND t.round = 6 ORDER BY team.conference ASC,t.position 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 `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 = 69564 AND t.round = 14 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 `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 = 71110 AND t.round = 14 ORDER BY team.conference ASC,t.position 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 `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 = 65402 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 67437 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.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 `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 = 59840 AND t.round = 26 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 `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 = 50949 AND t.round = 26 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 = 43613 AND t.round = 26 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 `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 = 38680 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 37976 AND t.round = 10 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 `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 = 10898 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC