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

Hapoel Hadera

Entrenador: Haim Silvas

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Hapoel Jerusalén Hapoel 27 30 33 34
2 Maccabi Petah Tikva Maccabi 27 31 49 30
3 Hapoel Hadera Hapoel 27 22 39 29
4 Beitar Jerusalem Beitar 27 37 34 28
5 Maccabi Netanya Maccabi 27 29 44 28
6 Hapoel Tel Aviv Hapoel Aviv 27 29 39 26
7 FC Ashdod FC Ashdod 27 21 42 25
8 Hapoel Petah Tikva Hapoel Petah 27 21 40 20
TEMPORADA 2022/2023
LIGA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Hapoel Haifa Hapoel Haifa 33 35 35 41
2 Beitar Jerusalem Beitar 33 52 58 40
3 Bnei Sakhnin Bnei Sakhnin 33 39 44 37
4 Hapoel Tel Aviv Hapoel Aviv 33 37 51 37
5 Maccabi Bnei Reineh Maccabi Bnei 33 32 54 35
6 Hapoel Hadera Hapoel 33 35 53 34
7 Ironi Kiryat Shmona Ironi Kiryat 33 40 49 32
8 Sektzia Ness Ziona Sektzia Ness 33 31 56 25
TEMPORADA 2021/2022
LIGA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Ironi Kiryat Shmona Ironi Kiryat 33 48 39 50
2 Hapoel Hadera Hapoel 33 34 43 42
3 FC Ashdod FC Ashdod 33 37 52 39
4 Beitar Jerusalem Beitar 33 35 43 37
5 Hapoel Haifa Hapoel Haifa 33 36 47 35
6 Hapoel Jerusalén Hapoel 33 25 41 33
7 Hapoel Nof HaGalil Hapoel 33 25 53 27
8 Maccabi Petah Tikva Maccabi 33 34 49 27
TEMPORADA 2020/2021
LIGA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Maccabi Haifa Maccabi 26 52 20 59
2 Maccabi Tel Aviv Maccabi Aviv 26 48 21 58
3 FC Ashdod FC Ashdod 26 37 25 43
4 Ironi Kiryat Shmona Ironi Kiryat 26 26 28 38
5 Hapoel Beer Sheva Hapoel Beer 26 31 29 37
6 Maccabi Petah Tikva Maccabi 26 24 23 37
7 Maccabi Netanya Maccabi 26 35 30 34
8 Beitar Jerusalem Beitar 26 31 32 32
9 Hapoel Hadera Hapoel 26 26 28 32
10 Hapoel Haifa Hapoel Haifa 26 30 37 30
11 Bnei Sakhnin Bnei Sakhnin 26 15 36 29
12 Hapoel Tel Aviv Hapoel Aviv 26 17 28 27
13 Hapoel Kfar Saba Hapoel Kfar 26 19 33 23
14 Bnei Yehuda Tel Aviv Bnei Yehuda 26 15 36 22
TEMPORADA 2019/2020
LIGA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Bnei Yehuda Tel Aviv Bnei Yehuda 7 17 4 49
2 FC Ashdod FC Ashdod 7 18 14 41
3 Maccabi Netanya Maccabi 7 12 14 40
4 Hapoel Hadera Hapoel 7 9 14 40
5 Hapoel Kfar Saba Hapoel Kfar 7 6 3 38
6 Sektzia Ness Ziona Sektzia Ness 7 6 6 32
7 Ironi Kiryat Shmona Ironi Kiryat 7 6 8 32
8 Hapoel Raanana Hapoel 7 7 18 17
TEMPORADA 2018/2019
LIGA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Maccabi Tel Aviv Maccabi Aviv 10 20 5 89
2 Maccabi Haifa Maccabi 10 12 14 58
3 Hapoel Beer Sheva Hapoel Beer 10 12 14 55
4 Maccabi Netanya Maccabi 10 11 18 53
5 Bnei Yehuda Tel Aviv Bnei Yehuda 10 17 16 51
6 Hapoel Hadera Hapoel 10 13 18 42
TEMPORADA 2017/2018
SEGUNDA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Hapoel Tel Aviv Hapoel Aviv 7 13 9 76
2 Hapoel Hadera Hapoel 7 5 3 65
3 Hapoel Rishon LeZion Hapoel 7 8 4 64
4 Beitar Tel Aviv Bat Yam Beitar Aviv 7 16 5 60
5 Hapoel Jerusalén Hapoel 7 7 10 55
6 Maccabi Ahi Nazareth Maccabi 7 5 13 53
7 Hapoel Nof HaGalil Hapoel 7 7 11 49
8 Hapoel Afula Hapoel Afula 7 6 12 48
TEMPORADA 2016/2017
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Hadera Hapoel 28 58 18 64
2 Rubi Shapira Rubi Shapira 28 51 24 55
3 Hapoel Iksal Hapoel Iksal 28 49 28 54
4 Ironi Tiberias Ironi 28 34 24 48
5 Hapoel Herzliya Hapoel 28 38 32 42
6 Hapoel Beit Shean Hapoel Beit 28 34 30 42
7 Maccabi Kiryat Ata Maccabi 28 38 32 37
8 Hapoel Migdal Hapoel 28 23 30 31
9 Hapoel Asi Gilboa Hapoel 28 20 37 30
10 Maccabi Kiryat Ata Bialik Maccabi 28 34 45 29
11 FC Tira FC Tira 28 22 35 29
12 Maccabi Daliyat Maccabi 28 34 51 29
13 Ironi Baka El Garbiya Ironi Baka. 28 23 44 28
14 Hapoel Kfar Kana Hapoel Kfar 28 22 30 27
15 Tzeirey Kfar Kana Tzeirey Kfar 28 20 40 25
16 Karmiel Safed Karmiel 0 0 0 0
TEMPORADA 2015/2016
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Ironi Nesher Ironi Nesher 30 52 18 64
2 Hapoel Hadera Hapoel 30 49 32 53
3 Ironi Tiberias Ironi 30 35 20 51
4 Hapoel Herzliya Hapoel 30 46 29 49
5 Maccabi Kiryat Ata Maccabi 30 35 23 45
6 Hapoel Kfar Kana Hapoel Kfar 30 30 31 43
7 Ironi Baka El Garbiya Ironi Baka. 30 34 29 42
8 Karmiel Safed Karmiel 30 36 43 39
9 Hapoel Migdal Hapoel 30 33 40 38
10 Hapoel Beit Shean Hapoel Beit 30 26 35 38
11 Hapoel Iksal Hapoel Iksal 30 32 33 37
12 Hapoel Asi Gilboa Hapoel 30 34 31 36
13 Maccabi Kiryat Ata Bialik Maccabi 30 28 37 36
14 Maccabi Daliyat Maccabi 30 33 36 29
15 Maccabi Ma'alot Tarshiha Maccabi 30 25 52 28
16 Hapoel Mejdel Krum Hapoel 30 16 55 17
TEMPORADA 2014/2015
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Jerusalén Hapoel 30 74 23 69
2 Ironi Nesher Ironi Nesher 30 52 15 63
3 Hapoel Herzliya Hapoel 30 67 28 62
4 Hapoel Beit Shean Hapoel Beit 30 57 29 53
5 Hapoel Migdal Hapoel 30 46 35 49
6 Giv'at Olga Giv'at Olga 30 35 24 48
7 Maccabi Kiryat Ata Maccabi 30 49 37 46
8 Maccabi Daliyat Maccabi 30 40 33 39
9 Hapoel Hadera Hapoel 30 39 38 37
10 Maccabi Ma'alot Tarshiha Maccabi 30 40 52 36
11 Maccabi Kiryat Ata Bialik Maccabi 30 25 49 35
12 Karmiel Safed Karmiel 30 33 37 34
13 Hapoel Mejdel Krum Hapoel 30 31 40 33
14 Hapoel Asi Gilboa Hapoel 30 22 32 30
15 Beitar Nahariya Beitar 30 35 39 29
16 Maccabi Umm al-Fahm Maccabi 30 12 146 0
TEMPORADA 2013/2014
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Kfar Saba Hapoel Kfar 30 57 21 63
2 Ironi Tiberias Ironi 30 43 26 54
3 Karmiel Safed Karmiel 30 42 35 51
4 Hapoel Migdal Hapoel 30 42 29 50
5 Maccabi Daliyat Maccabi 30 46 35 49
6 Hapoel Herzliya Hapoel 30 42 34 45
7 Hapoel Hadera Hapoel 30 46 45 44
8 Hapoel Beit Shean Hapoel Beit 30 54 42 43
9 Beitar Nahariya Beitar 30 40 37 43
10 Hapoel Asi Gilboa Hapoel 30 44 35 40
11 Giv'at Olga Giv'at Olga 30 34 34 38
12 Maccabi Kiryat Ata Bialik Maccabi 30 36 44 34
13 Maccabi Kiryat Ata Maccabi 30 33 44 30
14 Hapoel Daliyat Al Karmel Hapoel 30 37 58 29
15 Maccabi Kafar Kana Maccabi 30 33 56 25
16 Ahva Arraba FC Ahva Arraba 30 28 82 18
TEMPORADA 2012/2013
TERCERA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Hapoel Afula Hapoel Afula 30 65 17 70
2 Maccabi Daliyat Maccabi 30 45 22 60
3 Hapoel Migdal Hapoel 30 45 25 56
4 Hapoel Asi Gilboa Hapoel 30 38 27 47
5 Hapoel Herzliya Hapoel 30 40 32 46
6 Ironi Tiberias Ironi 30 35 25 43
7 Hapoel Hadera Hapoel 30 42 40 37
8 Maccabi Kiryat Ata Bialik Maccabi 30 30 39 37
9 Maccabi Kiryat Ata Maccabi 30 25 35 37
10 Karmiel Safed Karmiel 30 31 33 34
11 Ahva Arraba FC Ahva Arraba 30 22 39 33
12 Hapoel Daliyat Al Karmel Hapoel 30 31 53 33
13 Giv'at Olga Giv'at Olga 30 30 38 32
14 Maccabi Kafar Kana Maccabi 30 19 31 32
15 Hapoel Kfar Kana Hapoel Kfar 30 25 36 31
16 Maccabi Ma'alot Tarshiha Maccabi 30 34 65 20
TEMPORADA 2011/2012
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Asi Gilboa Hapoel 30 65 18 72
2 Ironi Tiberias Ironi 30 72 27 58
3 Hapoel Afula Hapoel Afula 30 55 39 53
4 Maccabi Ma'alot Tarshiha Maccabi 30 54 50 49
5 Maccabi Daliyat Maccabi 30 54 33 46
6 Maccabi Kiryat Ata Bialik Maccabi 30 47 38 45
7 Giv'at Olga Giv'at Olga 30 44 40 45
8 Hapoel Daliyat Al Karmel Hapoel 30 32 43 40
9 Maccabi Kiryat Ata Maccabi 30 38 45 38
10 Karmiel Safed Karmiel 30 46 32 36
11 Maccabi Kafar Kana Maccabi 30 43 56 34
12 Ahva Arraba FC Ahva Arraba 30 29 40 33
13 Hapoel Kfar Kana Hapoel Kfar 30 27 50 33
14 Hapoel Hadera Hapoel 30 34 48 32
15 Maccabi Tamra Maccabi 30 27 46 29
16 Ahi Acre FC Ahi Acre FC 30 33 95 15

  USO DE MEMORIA  
6,474,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9577
Total Execution Time  0.9589
  CADENA URL  
/historico/Hapoel-Eran-Hadera
  GET DATOS  
$_GET['/historico/Hapoel-Eran-Hadera']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (55)  
0.0158  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-Eran-Hadera' 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.0151  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=60717 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=60717 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=60717 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=60717 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=60717 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=60717 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0153  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=60717 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0173  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 = 75692
0.0152  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 = 73841
0.0153  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 = 72198
0.0151  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 = 72199
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60717 AND type_rel = 2
0.0155  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 60717 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151  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 (635390) ORDER BY n.cover_points DESC, update_date DESC
0.0191  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 = '60717' ORDER BY l.year DESC,cat.coefficient DESC
0.0176  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 = '60717' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0161  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 = '60717' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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 = 73841 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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 = 72211 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 = 72198 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0159  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=60717 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0151  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 (75692,73841,72199,71432) 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.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 75692 AND teamId = 60717
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 73841 AND teamId = 60717
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 72199 AND teamId = 60717
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 60717
0.0149  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 = 75692 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '60717' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60717' and rp.type = 4
0.0146  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 = '60717' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0153  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 = 75692 WHERE rp.league_id = 75692 AND rp.teamId = 60717 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.0151  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 = 75692 WHERE rp.league_id = 75692 AND rp.teamId = 60717 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 75692 WHERE rp.league_id = 75692 AND rp.teamId = 60717 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 60717 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0148  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 = 75692 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 67819 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.0148  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 = 71237 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.0148  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 = 63077 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.0147  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 = 66961 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.0148  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 = 61921 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.0148  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 = 57089 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.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 `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 = 49943 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.0164  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 = 55619 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.0161  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 = 43879 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 49278 AND t.round = 10 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 `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 = 38846 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 43314 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 36093 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15640 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 9315 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 24861 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 24872 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 24876 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 75692 ORDER BY nameShow LIMIT 100