4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Garde Nationale
TEMPORADA 2023/2024
LIGA MAURITANIA
Equipo PJ GF GC Puntos
1 Nouadhibou Nouadhibou 21 40 11 54
2 AC Douane AC Douane 22 47 13 51
3 Tevragh-Zeïne Tevragh-Zeï 22 37 14 40
4 Gendrim Gendrim 22 22 23 34
5 Nouakchott King Nouakchott 22 34 29 30
6 Chemal Chemal 22 24 22 27
7 Inter Nouakchott Inter 22 23 28 26
8 Kaédi Kaédi 21 25 32 26
9 Ksar Ksar 22 16 26 25
10 SNIM SNIM 22 18 28 24
11 AS Pompiers AS Pompiers 22 18 31 21
12 Garde Nationale Garde 22 19 29 20
13 Concorde Concorde 22 15 29 18
14 AS Entou de Kiffa Entou Kiffa 22 25 48 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 3
Equipo PJ GF GC Puntos
1 SNIM SNIM 8 10 4 24
2 Trarza AC Trarza AC 8 6 10 23
3 ASC Police ASC Police 8 17 5 21
4 Armée Armée 8 12 6 20
5 Garde Nationale Garde 8 4 6 20
6 Kédia Kédia 8 7 6 19
7 JAHE JAHE 8 9 20 12
8 Inter Nouakchott Inter 8 2 10 8
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 2013/2014
LIGA MAURITANIA GRUPO 3
Equipo PJ GF GC Puntos
1 Tidjikja Tidjikja 6 9 7 13
2 Moderne Kaédi Moderne 6 7 8 10
3 Garde Nationale Garde 6 11 6 9
4 Trarza Nadi Sporting Trarza Nadi 6 1 7 2
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 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  
5,844,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1141
Total Execution Time  0.1153
  CADENA URL  
/historico/Garde-Nationale
  GET DATOS  
$_GET['/historico/Garde-Nationale']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0027  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 = 'Garde-Nationale' 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=65189 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=65189 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65189 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1535 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1535 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1097457,397975) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '65189' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '65189' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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.0023  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=65189 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 (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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73189 AND teamId = 65189
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 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.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 = '65189' 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 = '65189' 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 = '65189' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 65189 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 = 73189 WHERE rp.league_id = 73189 AND rp.teamId = 65189 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 = 73189 WHERE rp.league_id = 73189 AND rp.teamId = 65189 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 65189 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 = 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.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 `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.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 `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.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 `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.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 `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 = 62413 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.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 = 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.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 = 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.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 `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.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 `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.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 `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.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 = 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.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 `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 = 16213 AND t.round = 6 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 = 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.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 `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.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 `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.0019  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