4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA LÍBANO GRUPO 3
Equipo PJ GF GC Puntos
1 Tadamon Sour Tadamon Sour 10 11 5 21
2 Al Sahel Shabab Sahel Shabab 11 13 7 18
3 Al Ahli Nabatiya Ahli 10 8 7 15
4 Al Ghazieh Shabab Ghazieh 11 9 12 13
5 Sagesse Sagesse 11 8 12 12
6 Tripoli Tripoli 11 7 13 8
TEMPORADA 2022/2023
LIGA LÍBANO GRUPO 3
Equipo PJ GF GC Puntos
1 Tadamon Sour Tadamon Sour 10 19 9 20
2 Tripoli Tripoli 10 15 13 18
3 Sagesse Sagesse 10 9 11 14
4 Salam Zgharta Salam 10 8 11 11
5 Safa Safa 10 10 15 10
6 Al Akhaa Al Ahli Akhaa Ahli 10 10 12 9
TEMPORADA 2021/2022
LIGA LÍBANO GRUPO 3
Equipo PJ GF GC Puntos
1 Al Nejmeh Al Nejmeh 10 16 8 19
2 Sagesse Sagesse 10 10 9 17
3 Al Akhaa Al Ahli Akhaa Ahli 10 11 12 16
4 Tripoli Tripoli 10 10 9 15
5 Safa Safa 10 14 12 13
6 Sporting Beirut Sporting 10 7 18 4
TEMPORADA 2020/2021
LIGA LÍBANO GRUPO 1
Equipo PJ GF GC Puntos
1 Al Ansar Beirut Ansar Beirut 11 28 5 27
2 Al Nejmeh Al Nejmeh 11 23 8 25
3 Al Sahel Shabab Sahel Shabab 11 13 3 24
4 Al Akhaa Al Ahli Akhaa Ahli 11 8 6 19
5 Al Ahed Al Ahed 11 13 10 17
6 Safa Safa 11 17 17 16
7 Bourj Bourj 11 12 11 14
8 Tripoli Tripoli 11 6 9 13
9 Shabab El Bourj Shabab Bourj 11 13 11 12
10 Tadamon Sour Tadamon Sour 11 3 9 7
11 Al Ghazieh Shabab Ghazieh 11 6 21 6
12 Salam Zgharta Salam 11 3 35 1
TEMPORADA 2019/2020
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Al Ansar Beirut Ansar Beirut 3 7 3 6
2 Bourj Bourj 2 3 0 6
3 Al Nejmeh Al Nejmeh 2 3 1 6
4 Al Sahel Shabab Sahel Shabab 3 4 4 4
5 Al Akhaa Al Ahli Akhaa Ahli 3 3 3 4
6 Safa Safa 3 3 4 4
7 Al Ahed Al Ahed 1 3 1 3
8 Salam Zgharta Salam 2 2 2 3
9 Tripoli Tripoli 2 2 3 3
10 Shabab El Bourj Shabab Bourj 3 3 5 3
11 Tadamon Sour Tadamon Sour 3 2 4 1
12 Al Ghazieh Shabab Ghazieh 3 2 7 0
TEMPORADA 2018/2019
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Al Ahed Al Ahed 22 40 9 59
2 Al Ansar Beirut Ansar Beirut 22 53 18 49
3 Al Nejmeh Al Nejmeh 22 36 17 48
4 Al Akhaa Al Ahli Akhaa Ahli 22 28 32 33
5 Al Sahel Shabab Sahel Shabab 22 32 32 28
6 Al Ghazieh Shabab Ghazieh 22 24 31 24
7 Tadamon Sour Tadamon Sour 22 16 21 23
8 Tripoli Tripoli 22 14 26 23
9 Safa Safa 22 16 29 22
10 Salam Zgharta Salam 22 15 30 22
11 Racing Beirut Racing 22 22 32 21
12 Al-Nabi Shayth Al-Nabi 22 19 38 13
TEMPORADA 2017/2018
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Al Ahed Al Ahed 22 50 9 54
2 Al Nejmeh Al Nejmeh 22 40 22 47
3 Safa Safa 22 31 25 36
4 Al Ansar Beirut Ansar Beirut 22 33 24 33
5 Al Akhaa Al Ahli Akhaa Ahli 22 23 19 33
6 Salam Zgharta Salam 22 30 31 32
7 Tadamon Sour Tadamon Sour 22 28 27 29
8 Tripoli Tripoli 22 28 33 25
9 Racing Beirut Racing 22 21 29 25
10 Al-Nabi Shayth Al-Nabi 22 21 35 20
11 Al Arabi Beirut Arabi Beirut 22 16 31 17
12 Al Islah Al Islah 22 14 50 11
TEMPORADA 2016/2017
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Al Ahed Al Ahed 22 41 14 49
2 Salam Zgharta Salam 22 35 29 40
3 Al Nejmeh Al Nejmeh 22 36 22 39
4 Al Ansar Beirut Ansar Beirut 22 35 40 32
5 Al-Nabi Shayth Al-Nabi 22 26 24 31
6 Safa Safa 22 32 32 30
7 Tadamon Sour Tadamon Sour 22 25 25 30
8 Racing Beirut Racing 22 26 30 30
9 Al Akhaa Al Ahli Akhaa Ahli 22 35 37 29
10 Tripoli Tripoli 22 34 31 28
11 Al Sahel Shabab Sahel Shabab 22 21 23 25
12 Al Egtmaaey trablos Egtmaaey 22 21 60 8
TEMPORADA 2015/2016
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Safa Safa 22 46 18 52
2 Al Ahed Al Ahed 22 54 14 51
3 Al Nejmeh Al Nejmeh 22 35 19 45
4 Al Ansar Beirut Ansar Beirut 22 37 20 42
5 Al Sahel Shabab Sahel Shabab 22 37 27 35
6 Al-Nabi Shayth Al-Nabi 22 31 30 29
7 Tripoli Tripoli 22 28 31 27
8 Racing Beirut Racing 22 19 27 26
9 Al Egtmaaey trablos Egtmaaey 22 29 43 23
10 Salam Zgharta Salam 22 25 44 16
11 Al Ghazieh Shabab Ghazieh 22 18 41 10
12 Sagesse Sagesse 22 17 62 9
TEMPORADA 2014/2015
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Al Ahed Al Ahed 22 42 10 51
2 Al Ansar Beirut Ansar Beirut 22 31 19 43
3 Al Nejmeh Al Nejmeh 22 26 18 39
4 Tripoli Tripoli 22 36 24 33
5 Safa Safa 22 26 28 30
6 Al-Nabi Shayth Al-Nabi 22 30 36 30
7 Salam Zgharta Salam 22 33 40 27
8 Al Sahel Shabab Sahel Shabab 22 25 28 24
9 Al Ghazieh Shabab Ghazieh 22 29 38 24
10 Racing Beirut Racing 22 18 30 23
11 Tadamon Sour Tadamon Sour 22 17 31 22
12 Al Akhaa Al Ahli Akhaa Ahli 22 18 29 20
TEMPORADA 2013/2014
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Al Nejmeh Al Nejmeh 22 48 24 44
2 Safa Safa 22 42 23 41
3 Racing Beirut Racing 22 38 31 38
4 Al Ahed Al Ahed 22 30 26 37
5 Al Akhaa Al Ahli Akhaa Ahli 22 36 26 31
6 Tripoli Tripoli 22 23 26 31
7 Al Sahel Shabab Sahel Shabab 22 40 26 30
8 Al Ansar Beirut Ansar Beirut 22 28 23 30
9 Tadamon Sour Tadamon Sour 22 22 31 22
10 Salam Zgharta Salam 22 27 46 22
11 Al-Mabarrah Al-Mabarrah 22 21 50 18
12 Al Egtmaaey trablos Egtmaaey 22 26 49 10
TEMPORADA 2012/2013
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Safa Safa 22 47 20 53
2 Al-Nejmeh Al-Nejmeh 22 47 22 45
3 Racing Beirut Racing 22 38 32 40
4 Al Akhaa Al Ahli Akhaa Ahli 22 32 22 39
5 Al Ahed Al Ahed 22 49 28 37
6 Al Sahel Shabab Sahel Shabab 22 38 30 37
7 Al Ansar Beirut Ansar Beirut 22 35 24 32
8 Tadamon Sour Tadamon Sour 22 33 38 28
9 Al Egtmaaey trablos Egtmaaey 22 36 40 26
10 Tripoli Tripoli 22 27 30 24
11 Al Ghazieh Shabab Ghazieh 22 44 67 11
12 Salam Sour Salam Sour 22 18 91 1
TEMPORADA 2011/2012
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Safa Safa 22 50 16 55
2 Al Nejmeh Al Nejmeh 22 37 16 51
3 Al Ahed Al Ahed 22 42 17 48
4 Al Ansar Beirut Ansar Beirut 22 35 24 41
5 Al Akhaa Al Ahli Akhaa Ahli 22 28 32 28
6 Shabab Sahel Shabab Sahel 22 25 26 27
7 Tripoli Tripoli 22 26 26 24
8 Racing Beirut Racing 22 18 25 23
9 Salam Sour Salam Sour 22 28 38 21
10 Tadamon Sour Tadamon Sour 22 15 26 20
11 Al-Mabarrah Al-Mabarrah 22 21 44 13
12 Al Ahli Sidon Ahli Sidon 22 18 53 10
TEMPORADA 2007/2008
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Al Ahed Al Ahed 22 41 15 49
2 Al Nejmeh Al Nejmeh 22 49 18 48
3 Al Ansar Beirut Ansar Beirut 22 41 16 48
4 Al-Mabarrah Al-Mabarrah 22 27 14 37
5 Safa Safa 22 31 30 35
6 Al Sahel Shabab Sahel Shabab 22 28 30 28
7 Tripoli Tripoli 22 26 40 23
8 Tadamon Sour Tadamon Sour 22 25 35 21
9 Racing Beirut Racing 22 23 28 20
10 Sagesse Sagesse 22 20 42 20
11 Al Ershad Al Ershad 22 25 36 16
12 Al Ahli Sidon Ahli Sidon 22 11 43 16
TEMPORADA 2006/2007
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Al Ansar Beirut Ansar Beirut 22 42 24 49
2 Safa Safa 22 47 16 45
3 Al-Mabarrah Al-Mabarrah 22 31 17 39
4 Al Nejmeh Al Nejmeh 22 51 22 36
5 Al Ahed Al Ahed 22 43 23 36
6 Sagesse Sagesse 22 39 32 35
7 Al Ahli Sidon Ahli Sidon 22 25 27 24
8 Al Sahel Shabab Sahel Shabab 22 24 37 24
9 Tadamon Sour Tadamon Sour 22 20 34 24
10 Tripoli Tripoli 22 27 33 22
11 Al Rayyan (Libano) Rayyan 22 21 45 22
12 Salam Zgharta Salam 22 8 68 3
TEMPORADA 2005/2006
LIGA LÍBANO
Equipo PJ GF GC Puntos
1 Al Ansar Beirut Ansar Beirut 18 50 14 47
2 Al Nejmeh Al Nejmeh 18 46 14 44
3 Safa Safa 18 21 21 32
4 Al-Mabarrah Al-Mabarrah 18 30 21 29
5 Al Ahed Al Ahed 18 31 18 27
6 Salam Zgharta Salam 18 17 30 20
7 Tadamon Sour Tadamon Sour 18 13 26 15
8 Tripoli Tripoli 18 7 17 14
9 Al Rayyan (Libano) Rayyan 18 10 28 14
10 Racing Beirut Racing 18 12 48 8

  USO DE MEMORIA  
6,280,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.8033
Total Execution Time  0.8053
  CADENA URL  
/historico/Tripoli
  GET DATOS  
$_GET['/historico/Tripoli']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (53)  
0.0135  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 = 'Tripoli' 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.0106  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=17357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=17357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=17357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=17357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=17357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0213  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 = 75201
0.0111  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 = 72226
0.0158  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 = 72228
0.0113  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 = 72567
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17357 AND type_rel = 2
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=477 AND type_rel = 3
0.0110  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 477 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (888022,869419,508928) ORDER BY n.cover_points DESC, update_date DESC
0.0120  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 = '17357' ORDER BY l.year DESC,cat.coefficient DESC
0.0111  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 = '17357' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '17357' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 72567 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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 = 72228 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  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 = 75201 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112  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=17357 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (75201,72567,72228) 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.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 75201 AND teamId = 17357
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 72228 AND teamId = 17357
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 72567 AND teamId = 17357
0.0109  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 = 75201 AND t.round = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '17357' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17357' and rp.type = 4
0.0107  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 = '17357' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0114  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 = 75201 WHERE rp.league_id = 75201 AND rp.teamId = 17357 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.0108  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 = 75201 WHERE rp.league_id = 75201 AND rp.teamId = 17357 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 = 75201 WHERE rp.league_id = 75201 AND rp.teamId = 17357 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110  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 = 17357 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0108  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 = 72226 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.0156  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 = 75201 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.0110  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 = 69233 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.0107  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 = 70852 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.0108  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 = 64193 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.0109  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 = 66920 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.0108  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 = 61871 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 59387 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.0119  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 = 51285 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.0111  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 = 45053 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 39907 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 36092 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 15643 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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 = 4838 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 3571 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 3107 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 24087 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 24094 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 24097 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 24098 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC