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 3
Equipo PJ GF GC Puntos
1 CA Bizertin CA Bizertin 9 10 4 17
2 US Tataouine Tataouine 9 8 5 16
3 Olympique Béja Olympique 9 10 5 15
4 Etoile Metlaoui Etoile 9 10 9 12
5 Ben Guerdane Guerdane 9 5 8 11
6 Marsa Marsa 8 8 12 9
7 AS Soliman AS Soliman 9 7 12 9
8 EGS Gafsa EGS Gafsa 8 2 5 8
TEMPORADA 2022/2023
LIGA TUNECINA GRUPO 3
Equipo PJ GF GC Puntos
1 Stade Tunisien Stade 10 13 7 22
2 CA Bizertin CA Bizertin 10 12 5 19
3 AS Soliman AS Soliman 10 8 12 16
4 Etoile Metlaoui Etoile 10 7 13 14
5 CO Sidi Bouzid Sidi Bouzid 10 12 12 12
6 ES Hammam Sousse Hammam 10 12 15 11
TEMPORADA 2021/2022
LIGA TUNECINA GRUPO 1
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 14 20 7 27
2 CS Sfaxien CS Sfaxien 14 12 10 21
3 Ben Guerdane Guerdane 14 10 8 21
4 US Tataouine Tataouine 14 13 15 21
5 CA Bizertin CA Bizertin 14 13 15 19
6 Etoile Metlaoui Etoile 14 11 15 17
7 ES Hammam Sousse Hammam 14 11 11 16
8 Hammam-Lif Hammam-Lif 14 9 18 10
9 Club Africain Club 14 11 6 25
10 Monastir Monastir 14 8 5 23
11 Etoile Sahel Etoile Sahel 14 14 8 22
12 Rejiche Rejiche 14 10 10 20
13 AS Soliman AS Soliman 14 7 9 17
14 Olympique Béja Olympique 14 9 10 16
15 Chebba Chebba 14 6 10 13
16 Zarzis Zarzis 14 6 13 13
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 3
Equipo PJ GF GC Puntos
1 Stade Gabésien Stade 14 12 7 23
2 Gabès Gabès 14 12 7 22
3 CA Bizertin CA Bizertin 14 12 10 19
4 Zarzis Zarzis 14 10 14 18
5 JS Kairouanaise Kairouanaise 14 8 7 18
6 Marsa Marsa 14 13 11 18
7 Hammam-Lif Hammam-Lif 14 12 13 16
8 US Tataouine Tataouine 14 9 19 12
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
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 14 27 12 29
2 CA Bizertin CA Bizertin 14 18 5 29
3 Club Africain Club 14 16 8 29
4 Marsa Marsa 14 16 15 19
5 JS Kairouanaise Kairouanaise 14 10 17 15
6 Olympique Béja Olympique 14 11 16 13
7 Zarzis Zarzis 14 9 16 12
8 Olympique du Kef Olympique 14 7 25 5
9 CS Sfaxien CS Sfaxien 14 20 9 28
10 Etoile Sahel Etoile Sahel 14 23 12 25
11 Monastir Monastir 14 17 12 21
12 Stade Tunisien Stade 14 11 11 17
13 Hammam-Lif Hammam-Lif 14 11 13 17
14 Stade Gabésien Stade 14 13 19 15
15 EGS Gafsa EGS Gafsa 14 12 18 14
16 ES Hammam Sousse Hammam 14 11 24 13
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
TEMPORADA 2008/2009
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 26 50 21 60
2 Club Africain Club 26 39 14 57
3 Etoile Sahel Etoile Sahel 26 48 17 53
4 CS Sfaxien CS Sfaxien 26 33 24 43
5 Monastir Monastir 26 23 24 35
6 Stade Tunisien Stade 26 30 31 34
7 Hammam-Lif Hammam-Lif 26 28 43 30
8 ES Hammam Sousse Hammam 26 20 26 26
9 CA Bizertin CA Bizertin 26 15 25 26
10 Olympique Béja Olympique 26 13 24 25
11 EGS Gafsa EGS Gafsa 26 18 33 25
12 AS Kasserine Kasserine 26 16 26 24
13 Marsa Marsa 26 14 24 22
14 Jendouba Sports Jendouba 26 11 26 21
TEMPORADA 2007/2008
LIGA TUNECINA
Equipo PJ GF GC Puntos
1 Club Africain Club 26 37 12 63
2 Etoile Sahel Etoile Sahel 26 40 9 61
3 ES Tunis ES Tunis 26 36 18 46
4 Monastir Monastir 26 27 32 36
5 Stade Tunisien Stade 26 24 34 36
6 EGS Gafsa EGS Gafsa 26 35 31 35
7 Marsa Marsa 26 26 30 33
8 CA Bizertin CA Bizertin 26 25 30 33
9 Hammam-Lif Hammam-Lif 26 24 28 32
10 CS Sfaxien CS Sfaxien 26 28 29 29
11 Olympique Béja Olympique 26 21 26 28
12 Jendouba Sports Jendouba 26 18 30 27
13 Stade Gabésien Stade 26 21 34 23
14 Zarzis Zarzis 26 12 31 16

  USO DE MEMORIA  
6,733,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1181
Total Execution Time  0.1195
  CADENA URL  
/historico/Ca-Bizertin
  GET DATOS  
$_GET['/historico/Ca-Bizertin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0043  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 = 'Ca-Bizertin' 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=582 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=582 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=582 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=582 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=582 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 582 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (30647,808496) ORDER BY n.cover_points DESC, update_date DESC
0.0040  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 = '582' ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '582' 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 = '582' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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=582 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 (75149,75141) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75149 AND teamId = 582
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 75141 AND teamId = 582
0.0020  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 = '582' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '582' and rp.type = 4
0.0019  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 = '582' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 75149 WHERE rp.league_id = 75149 AND rp.teamId = 582 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 = 75149 WHERE rp.league_id = 75149 AND rp.teamId = 582 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 75149 WHERE rp.league_id = 75149 AND rp.teamId = 582 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 582 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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.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 `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 = 71111 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.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 `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.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 = 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.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 `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.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 = 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.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 `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.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 = 34772 AND t.round = 14 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 = 38004 AND t.round = 14 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 `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 = 274 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 `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 = 9951 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC