4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hapoel Tel Aviv Sub 19
TEMPORADA 2023/2024
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Petah Tikva Sub 19 Maccabi 23 46 11 59
2 Bnei Sakhnin Sub 19 Bnei Sakhnin 24 34 21 44
3 Maccabi Haifa Sub 19 Maccabi 23 56 27 42
4 Hapoel Tel Aviv Sub 19 Hapoel Aviv 23 40 31 39
5 Maccabi Netanya Sub 19 Maccabi 23 33 23 37
6 Maccabi Tel Aviv Sub 19 Maccabi Aviv 24 40 30 34
7 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 23 29 33 31
8 Ashdod Sub 19 Ashdod 23 32 32 30
9 Hapoel Haifa Sub 19 Hapoel Haifa 23 17 34 29
10 Hapoel Raanana Sub 19 Hapoel 23 29 49 28
11 Hapoel Rishon LeZion Sub 19 Hapoel 23 31 34 27
12 Hapoel Hadera Sub 19 Hapoel 23 25 37 26
13 Hapoel Kfar Saba Sub 19 Hapoel Kfar 23 28 30 25
14 Hap Ramat Hasharon Sub 19 Ramat 23 22 37 24
15 Hapoel Beer Sheva Sub 19 Hapoel Beer 23 22 38 21
16 Ironi Kiryat Shmona Sub 19 Ironi Kiryat 23 20 37 18
TEMPORADA 2022/2023
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 30 84 33 66
2 Maccabi Netanya Sub 19 Maccabi 30 70 34 60
3 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 61 45 51
4 Ashdod Sub 19 Ashdod 30 53 44 51
5 Maccabi Petah Tikva Sub 19 Maccabi 30 55 36 47
6 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 46 49 46
7 Bnei Sakhnin Sub 19 Bnei Sakhnin 30 47 47 45
8 Hapoel Hadera Sub 19 Hapoel 30 51 59 43
9 Hapoel Raanana Sub 19 Hapoel 30 49 54 41
10 Ironi Kiryat Shmona Sub 19 Ironi Kiryat 30 42 39 38
11 Hapoel Haifa Sub 19 Hapoel Haifa 30 38 56 37
12 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 35 54 36
13 Hap Ramat Hasharon Sub 19 Ramat 30 30 47 33
14 Hapoel Rishon LeZion Sub 19 Hapoel 30 48 59 31
15 Hapoel Ramat Gan Sub 19 Hapoel Ramat 30 32 65 28
16 Beitar Jerusalem Sub 19 Beitar 30 32 52 27
TEMPORADA 2021/2022
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Ashdod Sub 19 Ashdod 34 82 37 75
2 Maccabi Petah Tikva Sub 19 Maccabi 34 72 34 71
3 Hapoel Tel Aviv Sub 19 Hapoel Aviv 34 80 37 67
4 Maccabi Tel Aviv Sub 19 Maccabi Aviv 34 68 31 67
5 Maccabi Haifa Sub 19 Maccabi 34 73 39 64
6 Hapoel Rishon LeZion Sub 19 Hapoel 34 80 62 54
7 Hapoel Ramat Gan Sub 19 Hapoel Ramat 34 37 29 54
8 Ironi Kiryat Gat Sub 19 Ironi Kiryat 34 44 44 49
9 Maccabi Netanya Sub 19 Maccabi 34 50 43 46
10 Hapoel Raanana Sub 19 Hapoel 34 39 54 43
11 Bnei Sakhnin Sub 19 Bnei Sakhnin 34 49 71 43
12 Hapoel Beer Sheva Sub 19 Hapoel Beer 34 52 69 42
13 Hapoel Hadera Sub 19 Hapoel 34 44 50 40
14 Beitar Jerusalem Sub 19 Beitar 34 39 47 40
15 Hapoel Kfar Saba Sub 19 Hapoel Kfar 34 31 54 35
16 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 34 49 72 32
17 Sektzia Nes Tziona Sub 19 Sektzia 34 34 85 22
18 Ironi Nesher Sub 19 Ironi Nesher 34 25 90 10
TEMPORADA 2020/2021
LIGA ISRAEL SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 17 42 14 46
2 Maccabi Petah Tikva Sub 19 Maccabi 17 29 8 38
3 Maccabi Tel Aviv Sub 19 Maccabi Aviv 17 27 20 32
4 Ashdod Sub 19 Ashdod 17 41 29 31
5 Hapoel Hadera Sub 19 Hapoel 17 27 19 29
6 Hapoel Tel Aviv Sub 19 Hapoel Aviv 17 22 17 27
7 Hapoel Kiryat Shmona Sub 19 Hapoel 17 17 14 26
8 Hapoel Ramat Gan Sub 19 Hapoel Ramat 17 25 21 23
TEMPORADA 2019/2020
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 23 56 13 53
2 Hapoel Tel Aviv Sub 19 Hapoel Aviv 23 45 26 42
3 Maccabi Tel Aviv Sub 19 Maccabi Aviv 22 37 22 38
4 Maccabi Petah Tikva Sub 19 Maccabi 23 32 26 37
5 Maccabi Netanya Sub 19 Maccabi 23 32 25 34
6 Hap Ramat Hasharon Sub 19 Ramat 23 30 28 33
7 Hapoel Beer Sheva Sub 19 Hapoel Beer 23 34 36 31
8 Hapoel Kiryat Shmona Sub 19 Hapoel 23 29 33 31
9 Hapoel Raanana Sub 19 Hapoel 23 24 23 30
10 Hapoel Ramat Gan Sub 19 Hapoel Ramat 23 26 28 28
11 Beitar Jerusalem Sub 19 Beitar 22 22 26 27
12 Hapoel Rishon LeZion Sub 19 Hapoel 23 24 31 25
13 Bnei Sakhnin Sub 19 Bnei Sakhnin 23 22 33 24
14 Beitar Nes Tubruk Sub 19 Beitar 23 20 39 24
15 Hapoel Nof HaGalil Sub 19 Hapoel 23 21 39 21
16 Hapoel Hadera Sub 19 Hapoel 23 17 43 12
TEMPORADA 2018/2019
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Petah Tikva Sub 19 Maccabi 30 66 33 63
2 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 46 30 56
3 Bnei Sakhnin Sub 19 Bnei Sakhnin 30 44 36 45
4 Hap Ramat Hasharon Sub 19 Ramat 30 34 35 44
5 Hapoel Kiryat Shmona Sub 19 Hapoel 30 38 33 42
6 Hapoel Raanana Sub 19 Hapoel 30 37 36 42
7 Beitar Nes Tubruk Sub 19 Beitar 30 44 45 42
8 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 43 41 41
9 Maccabi Haifa Sub 19 Maccabi 30 43 44 37
10 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 39 44 37
11 Beitar Jerusalem Sub 19 Beitar 30 40 40 35
12 Maccabi Netanya Sub 19 Maccabi 30 39 43 35
13 Hapoel Hadera Sub 19 Hapoel 30 30 39 34
14 Hapoel Ramat Gan Sub 19 Hapoel Ramat 30 23 36 34
15 Ashdod Sub 19 Ashdod 30 31 42 31
16 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 30 33 53 24
TEMPORADA 2017/2018
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 65 24 67
2 Maccabi Netanya Sub 19 Maccabi 30 53 34 59
3 Maccabi Haifa Sub 19 Maccabi 30 53 27 56
4 Hapoel Raanana Sub 19 Hapoel 30 45 31 55
5 Ashdod Sub 19 Ashdod 30 37 28 52
6 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 51 48 48
7 Maccabi Petah Tikva Sub 19 Maccabi 30 42 32 47
8 Hapoel Kiryat Shmona Sub 19 Hapoel 30 39 41 39
9 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 30 30 35 39
10 Bnei Sakhnin Sub 19 Bnei Sakhnin 30 34 39 37
11 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 46 47 35
12 Beitar Jerusalem Sub 19 Beitar 30 36 47 34
13 Hap Ramat Hasharon Sub 19 Ramat 30 35 52 34
14 Hapoel Rishon LeZion Sub 19 Hapoel 30 29 46 28
15 Hapoel Petah Tikva Sub 19 Hapoel Petah 30 36 47 25
16 Hapoel Ashkelon Sub 19 Hapoel 30 17 70 11
TEMPORADA 2016/2017
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 30 59 16 72
2 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 53 24 58
3 Hapoel Raanana Sub 19 Hapoel 30 39 33 55
4 Maccabi Petah Tikva Sub 19 Maccabi 30 65 39 46
5 Hapoel Kiryat Shmona Sub 19 Hapoel 30 45 32 46
6 Maccabi Netanya Sub 19 Maccabi 30 41 41 44
7 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 30 38 47 43
8 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 38 38 42
9 Bnei Sakhnin Sub 19 Bnei Sakhnin 30 55 50 39
10 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 39 36 39
11 Hap Ramat Hasharon Sub 19 Ramat 30 52 45 38
12 Hapoel Rishon LeZion Sub 19 Hapoel 30 37 46 34
13 Ashdod Sub 19 Ashdod 30 26 46 32
14 Beitar Nes Tubruk Sub 19 Beitar 30 25 46 24
15 Hapoel Haifa Sub 19 Hapoel Haifa 30 26 48 23
16 Hapoel Ashkelon Sub 19 Hapoel 30 26 77 23
TEMPORADA 2015/2016
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 30 71 21 70
2 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 36 31 52
3 Hapoel Kiryat Shmona Sub 19 Hapoel 30 52 31 50
4 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 50 39 49
5 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 49 36 47
6 Hapoel Raanana Sub 19 Hapoel 30 44 31 47
7 Bnei Sakhnin Sub 19 Bnei Sakhnin 30 51 38 43
8 Beitar Nes Tubruk Sub 19 Beitar 30 32 33 42
9 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 30 44 44 40
10 Hapoel Haifa Sub 19 Hapoel Haifa 30 42 45 39
11 Hapoel Rishon LeZion Sub 19 Hapoel 30 36 41 39
12 Ashdod Sub 19 Ashdod 30 41 45 37
13 Maccabi Netanya Sub 19 Maccabi 30 38 40 35
14 Maccabi Petah Tikva Sub 19 Maccabi 30 45 54 32
15 Beitar Jerusalem Sub 19 Beitar 30 23 57 23
16 Sektzia Nes Tziona Sub 19 Sektzia 30 23 91 12
TEMPORADA 2014/2015
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 89 20 71
2 Maccabi Haifa Sub 19 Maccabi 30 71 31 68
3 Hapoel Kiryat Shmona Sub 19 Hapoel 30 52 34 56
4 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 58 36 54
5 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 47 43 53
6 Beitar Nes Tubruk Sub 19 Beitar 30 49 46 50
7 Ashdod Sub 19 Ashdod 30 48 44 46
8 Maccabi Netanya Sub 19 Maccabi 30 47 45 46
9 Hapoel Raanana Sub 19 Hapoel 30 50 54 41
10 Hapoel Haifa Sub 19 Hapoel Haifa 30 52 59 37
11 Beitar Jerusalem Sub 19 Beitar 30 35 50 36
12 Maccabi Petah Tikva Sub 19 Maccabi 30 33 48 32
13 Hapoel Rishon LeZion Sub 19 Hapoel 30 31 63 29
14 Sektzia Nes Tziona Sub 19 Sektzia 30 32 56 28
15 Hapoel Ramat Gan Sub 19 Hapoel Ramat 30 32 58 27
16 Hapoel Petah Tikva Sub 19 Hapoel Petah 30 27 66 12
TEMPORADA 2013/2014
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 30 59 27 62
2 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 60 27 60
3 Maccabi Petah Tikva Sub 19 Maccabi 30 51 35 52
4 Beitar Nes Tubruk Sub 19 Beitar 30 54 36 51
5 Hapoel Kiryat Shmona Sub 19 Hapoel 30 49 36 49
6 Maccabi Netanya Sub 19 Maccabi 30 42 36 45
7 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 46 46 41
8 Hapoel Haifa Sub 19 Hapoel Haifa 30 44 44 41
9 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 39 51 38
10 Hapoel Rishon LeZion Sub 19 Hapoel 30 36 46 37
11 Ashdod Sub 19 Ashdod 30 56 49 35
12 Beitar Jerusalem Sub 19 Beitar 30 35 43 35
13 Hapoel Raanana Sub 19 Hapoel 30 33 49 35
14 Hapoel Ramat Gan Sub 19 Hapoel Ramat 30 31 40 34
15 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 30 34 58 34
16 Hap Ramat Hasharon Sub 19 Ramat 30 25 71 16

  USO DE MEMORIA  
6,117,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5009
Total Execution Time  0.5021
  CADENA URL  
/historico/Hapoel-Tel-Aviv-Sub19
  GET DATOS  
$_GET['/historico/Hapoel-Tel-Aviv-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0165  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 = 'Hapoel-Tel-Aviv-Sub19' 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.0127  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=60665 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=60665 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=60665 AND type_rel = 2
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1557 AND type_rel = 3
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 = '60665' ORDER BY l.year DESC,cat.coefficient DESC
0.0135  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 = '60665' 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 = '60665' 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 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=60665 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (73243) 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 = 73243 AND teamId = 60665
0.0135  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 = '60665' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0133  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60665' and rp.type = 4
0.0134  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 = '60665' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0160  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 = 73243 WHERE rp.league_id = 73243 AND rp.teamId = 60665 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.0141  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 = 73243 WHERE rp.league_id = 73243 AND rp.teamId = 60665 AND (e.action = 4 or e.action = 5) 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 = 73243 WHERE rp.league_id = 73243 AND rp.teamId = 60665 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 60665 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73243 AND t.round = 27 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 `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 = 69505 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.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 `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 = 63915 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.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 = 58554 AND t.round = 17 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 `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 = 62543 AND t.round = 7 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 = 58555 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 `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 = 48975 AND t.round = 30 ORDER BY team.conference 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 `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 = 48976 AND t.round = 30 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 = 37184 AND t.round = 30 ORDER BY team.conference 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 `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 = 15642 AND t.round = 30 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 = 9303 AND t.round = 30 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 = 24942 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC