4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ksar
TEMPORADA 2023/2024
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 20 39 11 51
2 AC Douane AC Douane 21 45 11 50
3 Tevragh-Zeïne Tevragh-Zeï 21 34 14 37
4 Gendrim Gendrim 21 20 18 34
5 Nouakchott King Nouakchott 21 33 28 29
6 Chemal Chemal 21 22 19 27
7 SNIM SNIM 21 18 25 24
8 Ksar Ksar 21 14 24 24
9 Kaédi Kaédi 20 22 30 23
10 Inter Nouakchott Inter 21 18 26 23
11 Garde Nationale Garde 22 19 29 20
12 AS Pompiers AS Pompiers 21 17 30 20
13 Concorde Concorde 22 15 29 18
14 AS Entou de Kiffa Entou Kiffa 21 25 47 17
TEMPORADA 2022/2023
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 26 59 16 69
2 Chemal Chemal 26 35 23 50
3 Tevragh-Zeïne Tevragh-Zeï 26 31 17 48
4 AC Douane AC Douane 26 32 23 41
5 Kaédi Kaédi 26 31 32 41
6 Nouakchott King Nouakchott 26 30 26 37
7 Concorde Concorde 26 28 29 33
8 Garde Nationale Garde 26 29 33 32
9 Gendrim Gendrim 26 16 24 29
10 Inter Nouakchott Inter 26 23 27 28
11 Ksar Ksar 26 21 29 28
12 SNIM SNIM 26 20 24 27
13 Trarza AC Trarza AC 26 23 53 21
14 ASC Police ASC Police 26 13 35 17
TEMPORADA 2021/2022
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 26 46 16 56
2 Tevragh-Zeïne Tevragh-Zeï 26 46 18 51
3 SNIM SNIM 26 33 19 47
4 Concorde Concorde 26 41 34 44
5 ASC Police ASC Police 26 24 20 40
6 Tidjikja Tidjikja 26 30 21 38
7 Garde Nationale Garde 26 33 29 38
8 AC Douane AC Douane 26 28 22 35
9 Nouakchott King Nouakchott 26 32 30 32
10 Trarza AC Trarza AC 26 21 28 29
11 Kaédi Kaédi 26 17 30 27
12 Ksar Ksar 26 29 48 24
13 Armée Armée 26 23 40 23
14 Gourel Sangue Gourel 26 17 65 15
TEMPORADA 2020/2021
LIGA MAURITANIA GRUPO 2
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 8 14 1 35
2 Tevragh-Zeïne Tevragh-Zeï 8 12 9 22
3 Ksar Ksar 8 11 11 20
4 Nouakchott King Nouakchott 8 12 7 18
5 Tidjikja Tidjikja 8 9 11 18
6 Concorde Concorde 8 6 10 16
7 Kaédi Kaédi 8 3 12 14
8 Sahel Sahel 8 3 9 12
TEMPORADA 2019/2020
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 26 40 16 57
2 Tevragh-Zeïne Tevragh-Zeï 26 31 15 52
3 Concorde Concorde 26 35 22 46
4 Kédia Kédia 26 25 16 46
5 Nouakchott King Nouakchott 26 38 25 44
6 ASC Police ASC Police 26 23 21 39
7 Tidjikja Tidjikja 26 38 29 37
8 SNIM SNIM 26 21 19 34
9 Trarza AC Trarza AC 26 24 31 34
10 Kaédi Kaédi 26 30 24 32
11 Garde Nationale Garde 26 27 26 30
12 Sahel Sahel 26 24 38 27
13 JAHE JAHE 26 17 57 13
14 Ksar Ksar 26 6 40 9
TEMPORADA 2018/2019
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 26 47 11 59
2 Concorde Concorde 26 47 31 47
3 Kédia Kédia 26 30 21 44
4 Nouakchott King Nouakchott 26 35 26 43
5 Tevragh-Zeïne Tevragh-Zeï 26 32 27 40
6 JAHE JAHE 26 24 21 40
7 Garde Nationale Garde 26 27 22 36
8 ASC Police ASC Police 26 29 25 33
9 Tidjikja Tidjikja 26 31 32 32
10 Ksar Ksar 26 27 36 28
11 Kaédi Kaédi 26 26 35 28
12 SNIM SNIM 26 21 30 25
13 Armée Armée 26 20 44 18
14 Deuz Deuz 26 20 55 13
TEMPORADA 2017/2018
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 26 46 13 60
2 Kédia Kédia 26 43 25 48
3 Tidjikja Tidjikja 26 40 23 48
4 Concorde Concorde 26 39 26 48
5 Tevragh-Zeïne Tevragh-Zeï 26 51 21 46
6 Nouakchott King Nouakchott 26 33 28 34
7 SNIM SNIM 26 26 26 34
8 Garde Nationale Garde 26 31 26 33
9 Deuz Deuz 26 29 37 31
10 ASC Police ASC Police 26 28 48 28
11 Kaédi Kaédi 26 23 49 28
12 Ksar Ksar 26 36 50 26
13 AJ Riadh AJ Riadh 26 20 38 25
14 Teïssir d'Atar Teïssir 26 20 55 13
TEMPORADA 2016/2017
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Concorde Concorde 26 54 27 56
2 Tevragh-Zeïne Tevragh-Zeï 26 48 14 55
3 Deuz Deuz 26 34 20 51
4 Tidjikja Tidjikja 26 33 15 45
5 Nouadhibou Nouadhibou 26 46 24 41
6 Ksar Ksar 26 35 34 38
7 Garde Nationale Garde 26 27 29 37
8 ASC Police ASC Police 26 21 28 34
9 SNIM SNIM 26 34 39 27
10 Kédia Kédia 26 25 33 27
11 Nouakchott King Nouakchott 26 17 23 26
12 AJ Riadh AJ Riadh 26 33 54 25
13 Toujounine Toujounine 26 24 46 23
14 Armée Armée 26 16 61 14
TEMPORADA 2015/2016
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Tevragh-Zeïne Tevragh-Zeï 24 50 15 61
2 Nouadhibou Nouadhibou 24 54 11 55
3 Concorde Concorde 24 42 23 44
4 Tidjikja Tidjikja 24 32 27 42
5 Ksar Ksar 24 31 24 40
6 Garde Nationale Garde 24 31 26 36
7 SNIM SNIM 24 28 25 33
8 Nouakchott King Nouakchott 24 27 25 31
9 ASC Police ASC Police 24 27 27 30
10 Toujounine Toujounine 24 21 39 19
11 Armée Armée 24 16 35 15
12 Kédia Kédia 24 17 47 14
13 Ittihad Assaba Ittihad 24 13 65 7
TEMPORADA 2014/2015
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Tevragh-Zeïne Tevragh-Zeï 26 52 14 60
2 SNIM SNIM 26 54 19 59
3 Ksar Ksar 26 54 13 56
4 Concorde Concorde 26 48 20 51
5 Nouadhibou Nouadhibou 26 44 17 48
6 Tidjikja Tidjikja 26 36 32 39
7 Armée Armée 26 35 34 33
8 Kédia Kédia 26 26 42 29
9 Gueumeul Gueumeul 26 23 27 27
10 Ittihad Assaba Ittihad 26 17 34 27
11 Nouakchott King Nouakchott 26 18 33 26
12 ASC Police ASC Police 26 32 45 24
13 Moderne Kaédi Moderne 26 20 58 16
14 Sélibaby Sélibaby 26 14 85 6
TEMPORADA 2013/2014
LIGA MAURITANIA GRUPO 2
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 10 17 4 24
2 Concorde Concorde 10 15 14 19
3 Ksar Ksar 10 14 16 14
4 Tevragh-Zeïne Tevragh-Zeï 10 13 14 12
5 Kédia Kédia 10 12 16 10
6 SNIM SNIM 10 5 12 6
TEMPORADA 2012/2013
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 26 67 16 60
2 Ksar Ksar 26 39 11 57
3 Concorde Concorde 26 52 19 51
4 Tevragh-Zeïne Tevragh-Zeï 26 41 15 49
5 Tidjikja Tidjikja 26 41 27 40
6 Ittihad Assaba Ittihad 26 25 34 34
7 SNIM SNIM 26 33 34 31
8 Trarza Nadi Sporting Trarza Nadi 26 19 25 27
9 Garde Nationale Garde 26 22 39 26
10 Kédia Kédia 26 17 35 26
11 Nouakchott King Nouakchott 26 27 40 24
12 Armée Armée 26 22 43 24
13 ASC Police ASC Police 26 17 42 23
14 Imraguens Imraguens 26 13 55 13
TEMPORADA 2011/2012
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Tevragh-Zeïne Tevragh-Zeï 26 59 19 62
2 Nouadhibou Nouadhibou 26 45 17 58
3 SNIM SNIM 26 44 19 51
4 Concorde Concorde 26 54 23 50
5 Tidjikja Tidjikja 26 40 26 45
6 Kédia Kédia 26 18 22 40
7 Armée Armée 26 30 45 33
8 Ksar Ksar 26 27 34 25
9 Imraguens Imraguens 26 25 38 25
10 ASC Police ASC Police 26 29 46 25
11 Teyarett Teyarett 26 24 41 22
12 Trarza Rosso Trarza Rosso 26 18 35 22
13 Entente Sebkha Entente 26 21 43 18
14 Lasa De Nouadhibou Lasa 26 21 47 18
TEMPORADA 2010/2011
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 16 25 6 38
2 Tevragh-Zeïne Tevragh-Zeï 16 25 7 38
3 Concorde Concorde 16 26 16 28
4 SNIM SNIM 16 22 16 28
5 Ksar Ksar 16 20 23 23
6 Kédia Kédia 16 10 17 19
7 Imraguens Imraguens 16 13 27 14
8 Tidjikja Tidjikja 16 11 19 12
9 ASC Police ASC Police 16 5 26 5
TEMPORADA 2009/2010
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 SNIM SNIM 22 30 13 46
2 Tevragh-Zeïne Tevragh-Zeï 22 48 14 45
3 Concorde Concorde 22 39 22 40
4 Ksar Ksar 22 23 14 35
5 Nouadhibou Nouadhibou 22 21 17 33
6 Kédia Kédia 22 27 30 33
7 ASC Nasr Sebkha Nasr Sebkha 22 32 27 32
8 ASC Mauritel Mauritel 22 26 27 31
9 Tidjikja Tidjikja 22 14 22 23
10 Teyarett Teyarett 22 19 32 22
11 Dar el Barka Barka 22 18 46 14
12 Dar Naim Dar Naim 22 10 43 9
TEMPORADA 2008/2009
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 SNIM SNIM 22 24 9 44
2 Concorde Concorde 22 38 12 43
3 Kédia Kédia 22 27 14 40
4 Ksar Ksar 22 25 17 39
5 Tidjikja Tidjikja 22 25 18 35
6 Tevragh-Zeïne Tevragh-Zeï 22 23 15 33
7 ASC Nasr Sebkha Nasr Sebkha 22 24 18 29
8 Nouadhibou Nouadhibou 22 12 25 20
9 ASC Mauritel Mauritel 22 19 27 19
10 Dar Naim Dar Naim 22 19 42 18
11 Trarza Rosso Trarza Rosso 22 16 35 15
12 Garde Nationale Garde 22 15 35 15
TEMPORADA 2007/2008
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Concorde Concorde 22 26 4 50
2 Ksar Ksar 22 36 14 42
3 Tidjikja Tidjikja 22 27 18 40
4 ASC Mauritel Mauritel 21 23 10 35
5 ASC Nasr Sebkha Nasr Sebkha 22 25 14 35
6 SNIM SNIM 22 26 21 33
7 Nouadhibou Nouadhibou 22 21 22 29
8 Tevragh-Zeïne Tevragh-Zeï 22 20 30 25
9 Garde Nationale Garde 21 17 29 20
10 Trarza Nadi Sporting Trarza Nadi 20 15 28 18
11 ASC Police ASC Police 22 12 32 15
12 Armée Armée 22 10 36 10

  USO DE MEMORIA  
6,276,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6756
Total Execution Time  0.6769
  CADENA URL  
/historico/Ksar
  GET DATOS  
$_GET['/historico/Ksar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
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 = 'Ksar' 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.0126  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=60325 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=60325 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0258  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 = 73189
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60325 AND type_rel = 2
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 60325 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0132  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 (25662,397975) ORDER BY n.cover_points DESC, update_date DESC
0.0134  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 = '60325' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '60325' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '60325' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 73189 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=60325 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0132  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 (73189) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73189 AND teamId = 60325
0.0144  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 = 73189 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  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 = '60325' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60325' and rp.type = 4
0.0136  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 = '60325' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137  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 = 73189 WHERE rp.league_id = 73189 AND rp.teamId = 60325 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.0137  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 = 73189 WHERE rp.league_id = 73189 AND rp.teamId = 60325 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 73189 WHERE rp.league_id = 73189 AND rp.teamId = 60325 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 60325 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 73189 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.0137  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 = 70026 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.0132  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 = 64642 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.0135  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 = 60248 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.0128  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 = 62412 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.0130  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 = 51220 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.0131  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 = 45907 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 40652 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 36064 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 15625 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 9227 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16211 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 16212 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16214 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16215 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 16216 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 16217 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 16218 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 16219 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73189 ORDER BY nameShow LIMIT 100