4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hatta Club

Hatta Club

Entrenador: Fabio Viviani

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Wasl Al-Wasl 20 52 18 52
2 Shabab Al Ahli Dubai Shabab Ahli 20 50 25 43
3 Al-Ain Al-Ain 19 45 26 36
4 Al-Wahda Al-Wahda 21 37 27 35
5 Al Nasr Dubai Nasr Dubai 21 35 29 35
6 Sharjah FC Sharjah FC 20 41 30 31
7 Al Bataeh Al Bataeh 19 29 31 26
8 Al-Jazira Al-Jazira 20 41 40 24
9 Baniyas Baniyas 19 25 35 22
10 Al Ittihad Kalba Ittihad 21 33 42 21
11 Khorfakkan Khorfakkan 20 28 42 21
12 Ajman Ajman 19 29 44 21
13 Emirates Club Emirates 19 21 44 11
14 Hatta Club Hatta Club 20 16 49 6
TEMPORADA 2022/2023
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Hatta Club Hatta Club 32 75 37 75
2 Emirates Club Emirates 32 85 33 71
3 Dibba Al Hisn Dibba Hisn 32 72 37 67
4 Masfut Masfut 32 49 40 56
5 Al Hamriyah Al Hamriyah 32 53 45 49
6 Al Arabi SC Al Arabi SC 32 55 42 48
7 Masafi Masafi 32 46 43 47
8 Gulf Heroes Gulf Heroes 32 51 60 44
9 Al Fujairah Al Fujairah 32 48 39 43
10 Al Jazira Al Hamra Jazira Hamra 32 66 64 43
11 Al Taawon SC Taawon 32 44 48 42
12 Al Dhaid Al Dhaid 32 39 50 40
13 Al Urooba Al Urooba 32 51 49 39
14 Al Ramms Al Ramms 32 39 51 32
15 Dubai City Dubai City 32 31 57 24
16 Fursan Hispania Fursan 32 26 81 19
17 Baynounah Baynounah 32 33 87 15
TEMPORADA 2021/2022
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Dibba Al Fujairah Dibba 28 73 15 75
2 Al Bataeh Al Bataeh 28 58 21 67
3 Dibba Al Hisn Dibba Hisn 28 56 26 63
4 Al Arabi SC Al Arabi SC 28 48 24 63
5 Al Hamriyah Al Hamriyah 28 56 34 52
6 Hatta Club Hatta Club 28 44 38 47
7 Al Fujairah Al Fujairah 28 38 32 43
8 Masfut Masfut 28 34 38 35
9 Al Jazira Al Hamra Jazira Hamra 28 41 57 30
10 Masafi Masafi 28 30 42 27
11 Gulf Heroes Gulf Heroes 28 39 64 24
12 Al Ramms Al Ramms 28 29 65 20
13 Al Taawon SC Taawon 28 32 52 19
14 Al Dhaid Al Dhaid 28 28 52 19
15 Dubai City Dubai City 28 26 72 12
TEMPORADA 2020/2021
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Jazira Al-Jazira 26 64 29 57
2 Baniyas Baniyas 26 50 22 54
3 Shabab Al Ahli Dubai Shabab Ahli 26 52 30 50
4 Sharjah FC Sharjah FC 26 48 29 48
5 Al Nasr Dubai Nasr Dubai 26 47 33 46
6 Al-Ain Al-Ain 26 39 33 41
7 Al-Wahda Al-Wahda 26 48 33 40
8 Al Ittihad Kalba Ittihad 26 29 39 39
9 Al-Wasl Al-Wasl 26 49 47 37
10 Khorfakkan Khorfakkan 26 35 50 25
11 Al Dhafra Al Dhafra 26 31 58 21
12 Ajman Ajman 26 24 57 18
13 Al Fujairah Al Fujairah 26 31 57 15
14 Hatta Club Hatta Club 26 19 49 12
TEMPORADA 2019/2020
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Shabab Al Ahli Dubai Shabab Ahli 19 41 13 43
2 Al-Ain Al-Ain 19 46 21 37
3 Al-Jazira Al-Jazira 19 29 17 36
4 Al-Wahda Al-Wahda 19 33 30 35
5 Sharjah FC Sharjah FC 19 38 23 35
6 Al Nasr Dubai Nasr Dubai 19 24 19 31
7 Al-Wasl Al-Wasl 19 31 33 29
8 Al Dhafra Al Dhafra 19 25 24 29
9 Baniyas Baniyas 19 21 27 23
10 Ajman Ajman 19 25 39 18
11 Al Ittihad Kalba Ittihad 19 24 39 16
12 Khorfakkan Khorfakkan 19 18 32 15
13 Hatta Club Hatta Club 19 15 32 13
14 Al Fujairah Al Fujairah 19 15 36 12
TEMPORADA 2018/2019
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Hatta Club Hatta Club 18 35 14 38
2 Khorfakkan Khorfakkan 18 26 13 38
3 Al Urooba Al Urooba 18 27 16 37
4 Al Hamriyah Al Hamriyah 18 28 17 32
5 Dibba Al Hisn Dibba Hisn 18 29 26 29
6 Masafi Masafi 18 19 33 25
7 Al Dhaid Al Dhaid 18 22 22 21
8 Al Arabi SC Al Arabi SC 18 25 39 14
9 Al Taawon SC Taawon 18 21 35 14
10 Masfut Masfut 18 13 30 5
TEMPORADA 2017/2018
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Ain Al-Ain 22 65 23 53
2 Al-Wahda Al-Wahda 22 50 29 46
3 Al-Wasl Al-Wasl 22 42 27 41
4 Al Nasr Dubai Nasr Dubai 22 30 24 37
5 Shabab Al Ahli Dubai Shabab Ahli 22 25 18 31
6 Sharjah FC Sharjah FC 22 26 30 29
7 Al-Jazira Al-Jazira 22 34 36 28
8 Ajman Ajman 22 25 36 26
9 Dibba Al Fujairah Dibba 22 21 36 21
10 Al Dhafra Al Dhafra 22 24 42 18
11 Emirates Club Emirates 22 22 41 17
12 Hatta Club Hatta Club 22 30 52 16
TEMPORADA 2016/2017
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Jazira Al-Jazira 26 72 15 68
2 Al-Wasl Al-Wasl 26 55 26 57
3 Al Ahli Dubai Ahli Dubai 26 50 18 56
4 Al-Ain Al-Ain 26 58 37 55
5 Al-Wahda Al-Wahda 26 54 40 39
6 Al Nasr Dubai Nasr Dubai 26 42 32 36
7 Al Dhafra Al Dhafra 26 40 46 35
8 Al Shabab Dubai Shabab Dubai 26 24 44 30
9 Sharjah FC Sharjah FC 26 31 47 26
10 Hatta Club Hatta Club 26 24 47 25
11 Dibba Al Fujairah Dibba 26 25 54 20
12 Emirates Club Emirates 26 33 51 20
13 Al Ittihad Kalba Ittihad 26 30 44 19
14 Baniyas Baniyas 26 33 70 15
TEMPORADA 2015/2016
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Hatta Club Hatta Club 16 39 21 39
2 Al Ittihad Kalba Ittihad 16 43 17 37
3 Ajman Ajman 16 46 19 35
4 Dubai Dubai 16 27 14 34
5 Al Urooba Al Urooba 16 28 35 16
6 Dibba Al Hisn Dibba Hisn 16 19 28 15
7 Al Dhaid Al Dhaid 16 25 41 14
8 Khorfakkan Khorfakkan 16 16 35 13
9 Ras Al Khaima Khaima 16 18 51 6
TEMPORADA 2014/2015
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Dibba Al Fujairah Dibba 20 41 18 50
2 Al-Shaab Sharjah Al-Shaab 20 38 15 47
3 Dubai Dubai 20 51 15 46
4 Hatta Club Hatta Club 20 39 29 32
5 Masafi Masafi 20 23 26 23
6 Al Urooba Al Urooba 20 36 44 23
7 Dibba Al Hisn Dibba Hisn 20 36 38 22
8 Al Dhaid Al Dhaid 20 26 32 21
9 Khorfakkan Khorfakkan 20 20 36 21
10 Ras Al Khaima Khaima 20 16 34 16
11 Al Taawon SC Taawon 20 27 66 9
TEMPORADA 2013/2014
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Ittihad Kalba Ittihad 24 58 16 59
2 Al Fujairah Al Fujairah 24 64 25 55
3 Dibba Al Fujairah Dibba 24 60 27 55
4 Al Dhaid Al Dhaid 24 52 33 47
5 Dibba Al Hisn Dibba Hisn 24 44 31 42
6 Khorfakkan Khorfakkan 24 32 32 27
7 Al Jazira Al Hamra Jazira Hamra 24 38 52 26
8 Hatta Club Hatta Club 24 48 53 25
9 Al Urooba Al Urooba 24 30 35 24
10 Masafi Masafi 24 25 46 19
11 Al Arabi SC Al Arabi SC 24 34 58 19
12 Al Taawon SC Taawon 24 25 65 19
13 Al Ramms Al Ramms 24 28 65 18
TEMPORADA 2012/2013
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Emirates Club Emirates 26 81 36 59
2 Sharjah FC Sharjah FC 26 58 25 59
3 Hatta Club Hatta Club 26 62 51 46
4 Al Fujairah Al Fujairah 26 63 35 45
5 Dibba Al Hisn Dibba Hisn 26 56 32 43
6 Al Urooba Al Urooba 26 60 36 42
7 Al Dhaid Al Dhaid 26 48 38 39
8 Khorfakkan Khorfakkan 26 44 49 36
9 Al Arabi SC Al Arabi SC 26 43 54 36
10 Masafi Masafi 26 36 39 29
11 Al Taawon SC Taawon 26 36 64 25
12 Al Jazira Al Hamra Jazira Hamra 26 33 65 25
13 Al Ramms Al Ramms 26 37 65 19
14 Masfut Masfut 26 29 97 7
TEMPORADA 2009/2010
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Ittihad Kalba Ittihad 14 30 24 27
2 Dubai Dubai 14 32 20 25
3 Al Shaab CSC Shaab 14 21 18 24
4 Al Fujairah Al Fujairah 14 25 21 20
5 Al Urooba Al Urooba 14 23 23 19
6 Khorfakkan Khorfakkan 14 23 25 19
7 Hatta Club Hatta Club 14 20 24 15
8 Dibba Al Hisn Dibba Hisn 14 17 36 7
TEMPORADA 2008/2009
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Baniyas Baniyas 30 80 25 70
2 Emirates Club Emirates 30 84 39 62
3 Al Fujairah Al Fujairah 30 64 50 61
4 Al Urooba Al Urooba 30 54 33 55
5 Al Ittihad Kalba Ittihad 30 63 37 52
6 Hatta Club Hatta Club 30 59 43 52
7 Dubai Dubai 30 56 48 51
8 Dibba Al Hisn Dibba Hisn 30 50 47 43
9 Al Jazira Al Hamra Jazira Hamra 30 45 46 42
10 Ras Al Khaima Khaima 30 51 62 37
11 Al Dhaid Al Dhaid 30 40 51 31
12 Al Ramms Al Ramms 30 43 54 30
13 Dibba Al Fujairah Dibba 30 40 63 29
14 Al Arabi SC Al Arabi SC 30 39 72 29
15 Masafi Masafi 30 28 60 18
16 Al Hamriyah Al Hamriyah 30 33 99 15
TEMPORADA 2007/2008
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Shabab Dubai Shabab Dubai 22 44 30 42
2 Al-Jazira Al-Jazira 22 46 31 39
3 Al Ahli Dubai Ahli Dubai 22 47 27 37
4 Sharjah FC Sharjah FC 22 35 35 33
5 Al-Shaab Sharjah Al-Shaab 22 39 44 33
6 Al-Ain Al-Ain 22 41 37 30
7 Al-Wasl Al-Wasl 22 39 37 30
8 Al-Wahda Al-Wahda 22 42 42 30
9 Al Nasr Dubai Nasr Dubai 22 37 39 28
10 Al Dhafra Al Dhafra 22 34 41 25
11 Emirates Club Emirates 22 37 54 17
12 Hatta Club Hatta Club 22 23 47 16

  USO DE MEMORIA  
6,639,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6309
Total Execution Time  0.6322
  CADENA URL  
/historico/Hatta-Dubai
  GET DATOS  
$_GET['/historico/Hatta-Dubai']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0138  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 = 'Hatta-Dubai' 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.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=1300 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=1300 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=1300 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=1300 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=1300 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1300 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1300 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0126  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 (155849) ORDER BY n.cover_points DESC, update_date DESC
0.0133  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 = '1300' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '1300' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '1300' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136  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=1300 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (74207,73163,72286,71432,69435) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72286 AND teamId = 1300
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 69435 AND teamId = 1300
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73163 AND teamId = 1300
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 74207 AND teamId = 1300
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1300
0.0127  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 = '1300' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1300' and rp.type = 4
0.0126  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 = '1300' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0143  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 = 72286 WHERE rp.league_id = 72286 AND rp.teamId = 1300 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 = 72286 WHERE rp.league_id = 72286 AND rp.teamId = 1300 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 72286 WHERE rp.league_id = 72286 AND rp.teamId = 1300 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 1300 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72286 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.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 `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 = 69435 AND t.round = 34 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 `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 = 65184 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 56840 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.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 `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 = 49876 AND t.round = 19 ORDER BY team.conference ASC,t.position 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 `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 = 46465 AND t.round = 18 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 `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 = 38722 AND t.round = 22 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 = 29627 AND t.round = 26 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 `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 = 15870 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 `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 = 9345 AND t.round = 22 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 `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 = 15231 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 `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 = 15232 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 `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 = 15235 AND t.round = 14 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 `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 = 15236 AND t.round = 30 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 `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 = 271 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC