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

Hapoel Ramat HaSharon

Entrenador: Yaron Hochenboim

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Ironi Kiryat Shmona Ironi Kiryat 32 52 20 64
2 Bnei Yehuda Tel Aviv Bnei Yehuda 32 58 39 62
3 Ironi Tiberias Ironi 32 51 29 60
4 Hapoel Nof HaGalil Hapoel 32 54 35 53
5 Maccabi Kabilio Jaffa Maccabi 32 62 47 50
6 Hapoel Ramat HaSharon Hapoel Ramat 32 60 53 48
7 Maccabi Herzliya Maccabi 32 37 48 45
8 Hapoel Umm al-Fahm Hapoel 32 39 38 42
TEMPORADA 2022/2023
SEGUNDA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Hapoel Ramat Gan Hapoel Ramat 37 50 49 50
2 Hapoel Afula Hapoel Afula 37 49 51 46
3 Hapoel Ramat HaSharon Hapoel Ramat 37 45 47 46
4 Hapoel Rishon LeZion Hapoel 37 45 48 44
5 Hapoel Nof HaGalil Hapoel 37 42 59 42
6 Kafr Qasim Kafr Qasim 37 43 47 42
7 Maccabi Ahi Nazareth Maccabi 37 37 55 38
8 Agudat Sport Ashdod Agudat Sport 37 26 78 10
TEMPORADA 2021/2022
SEGUNDA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Maccabi Ahi Nazareth Maccabi 37 41 45 50
2 Hapoel Afula Hapoel Afula 37 39 57 47
3 Hapoel Ramat Gan Hapoel Ramat 37 43 47 46
4 Hapoel Acre Hapoel Acre 37 38 34 46
5 Hapoel Ramat HaSharon Hapoel Ramat 37 39 40 45
6 Hapoel Rishon LeZion Hapoel 37 42 46 43
7 Hapoel Raanana Hapoel 37 40 50 42
8 Beitar Tel Aviv Bat Yam Beitar Aviv 37 39 55 33
TEMPORADA 2020/2021
SEGUNDA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Hapoel Jerusalén Hapoel 7 15 4 17
2 Hapoel Nof HaGalil Hapoel 7 18 6 15
3 Sektzia Ness Ziona Sektzia Ness 7 9 8 13
4 Hapoel Rishon LeZion Hapoel 7 9 8 11
5 Hapoel Ramat Gan Hapoel Ramat 7 11 10 8
6 Beitar Tel Aviv Bat Yam Beitar Aviv 7 11 12 7
7 Hapoel Ramat HaSharon Hapoel Ramat 7 5 7 4
8 Hapoel Iksal Hapoel Iksal 7 2 25 1
TEMPORADA 2019/2020
SEGUNDA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Bnei Sakhnin Bnei Sakhnin 7 14 2 19
2 Hapoel Ramat Gan Hapoel Ramat 7 14 7 16
3 Kafr Qasim Kafr Qasim 7 12 8 12
4 Hapoel Jerusalén Hapoel 7 5 3 10
5 Beitar Tel Aviv Bat Yam Beitar Aviv 7 11 14 9
6 Maccabi Petah Tikva Maccabi 7 4 9 7
7 Hapoel Rishon LeZion Hapoel 7 6 14 4
8 Hapoel Ramat HaSharon Hapoel Ramat 7 8 17 3
TEMPORADA 2018/2019
SEGUNDA ISRAEL
Equipo PJ GF GC Puntos
1 Hapoel Nof HaGalil Hapoel 30 42 25 54
2 Hapoel Jerusalén Hapoel 30 40 33 48
3 Sektzia Ness Ziona Sektzia Ness 30 48 35 47
4 Hapoel Afula Hapoel Afula 30 38 28 47
5 Hapoel Ashkelon Hapoel 30 34 35 44
6 Beitar Tel Aviv Bat Yam Beitar Aviv 29 40 37 42
7 Hapoel Kfar Saba Hapoel Kfar 30 40 37 42
8 Hapoel Ramat Gan Hapoel Ramat 30 35 35 39
9 Maccabi Ahi Nazareth Maccabi 30 33 38 39
10 Hapoel Acre Hapoel Acre 30 27 31 35
11 Hapoel Petah Tikva Hapoel Petah 29 39 30 34
12 Hapoel Rishon LeZion Hapoel 30 34 43 34
13 Hapoel Marmorek Hapoel 30 29 47 33
14 Hapoel Bnei Lod Hapoel Bnei 30 31 40 32
15 Hapoel Ramat HaSharon Hapoel Ramat 30 32 38 31
16 Hapoel Iksal Hapoel Iksal 30 33 43 30
TEMPORADA 2017/2018
SEGUNDA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Hapoel Petah Tikva Hapoel Petah 7 14 5 55
2 Hapoel Bnei Lod Hapoel Bnei 7 12 12 54
3 Hapoel Ramat HaSharon Hapoel Ramat 7 9 9 50
4 Hapoel Marmorek Hapoel 7 6 4 48
5 Hapoel Ramat Gan Hapoel Ramat 7 11 8 47
6 Hapoel Kfar Saba Hapoel Kfar 7 9 10 47
7 Maccabi Herzliya Maccabi 7 13 8 37
8 Ironi Nesher Ironi Nesher 7 4 22 14
TEMPORADA 2016/2017
SEGUNDA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Maccabi Netanya Maccabi 30 65 32 54
2 Hapoel Acre Hapoel Acre 30 50 30 54
3 Hapoel Ramat Gan Hapoel Ramat 30 46 28 52
4 Beitar Tel Aviv Bat Yam Beitar Aviv 30 49 35 44
5 Hapoel Petah Tikva Hapoel Petah 30 39 38 42
6 Hapoel Jerusalén Hapoel 30 40 46 42
7 Maccabi Ahi Nazareth Maccabi 30 37 30 40
8 Hapoel Bnei Lod Hapoel Bnei 30 39 52 39
9 Hapoel Afula Hapoel Afula 30 42 46 38
10 Hapoel Rishon LeZion Hapoel 30 28 29 36
11 Maccabi Herzliya Maccabi 30 37 44 35
12 Ironi Nesher Ironi Nesher 30 22 32 34
13 Hapoel Ramat HaSharon Hapoel Ramat 30 27 38 33
14 Hapoel Nof HaGalil Hapoel 30 25 43 31
15 Hapoel Jerusalem Hapoel 30 22 38 29
16 Maccabi Sha'araim Maccabi 30 28 35 28
TEMPORADA 2015/2016
SEGUNDA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Beitar Tel Aviv Bat Yam Beitar Aviv 7 18 4 19
2 Hapoel Nof HaGalil Hapoel 7 18 7 16
3 Hapoel Ramat HaSharon Hapoel Ramat 7 14 11 10
4 Hapoel Jerusalem Hapoel 7 13 13 9
5 Hapoel Afula Hapoel Afula 7 10 14 9
6 Hapoel Rishon LeZion Hapoel 7 9 10 7
7 Ironi Kiryat Gat Ironi Kiryat 7 10 23 7
8 Maccabi Yavne Maccabi 7 7 17 3
TEMPORADA 2014/2015
SEGUNDA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Hapoel Jerusalem Hapoel 7 10 6 50
2 Hapoel Rishon LeZion Hapoel 7 10 8 48
3 Hapoel Ramat HaSharon Hapoel Ramat 7 6 7 48
4 Beitar Tel Aviv Bat Yam Beitar Aviv 7 14 8 47
5 Maccabi Herzliya Maccabi 7 5 11 44
6 Hapoel Nof HaGalil Hapoel 7 7 7 39
7 Ironi Tiberias Ironi 7 10 10 37
8 Hakoah Maccabi Ramat Gan Hakoah 7 5 10 22
TEMPORADA 2013/2014
LIGA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Maccabi Tel Aviv Maccabi Aviv 26 58 18 66
2 Hapoel Beer Sheva Hapoel Beer 26 48 19 59
3 Ironi Kiryat Shmona Ironi Kiryat 26 38 26 44
4 Maccabi Haifa Maccabi 26 39 30 44
5 Bnei Sakhnin Bnei Sakhnin 26 30 25 40
6 Hapoel Tel Aviv Hapoel Aviv 26 51 38 39
7 FC Ashdod FC Ashdod 26 28 35 31
8 Hapoel Haifa Hapoel Haifa 26 27 34 31
9 Beitar Jerusalem Beitar 26 21 28 30
10 Hapoel Acre Hapoel Acre 26 24 37 27
11 Hapoel Raanana Hapoel 26 20 33 26
12 Maccabi Petah Tikva Maccabi 26 28 45 23
13 Bnei Yehuda Tel Aviv Bnei Yehuda 26 26 39 20
14 Hapoel Ramat HaSharon Hapoel Ramat 26 21 52 20

  USO DE MEMORIA  
6,097,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1140
Total Execution Time  0.1160
  CADENA URL  
/historico/Hapoel-Nir-Ramat-Hasharon
  GET DATOS  
$_GET['/historico/Hapoel-Nir-Ramat-Hasharon']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0043  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 = 75858
0.0024  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 = 72213
0.0026  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.0023  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 = 72227
0.0024  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 = 73555
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64361 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=370 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 370 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1283612,992067,974879,913858,841957) ORDER BY n.cover_points DESC, update_date DESC
0.0031  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 = '64361' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72227 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 75858 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  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 = 64361 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72213 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.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 `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 = 75858 AND t.round = 3 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 `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 = 67845 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.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 `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 = 71294 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.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 `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 = 63161 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.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 `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 = 67027 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.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 `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 = 58423 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.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 = 62045 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.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 `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 = 50129 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.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 `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 = 56758 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.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 `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 = 44217 AND t.round = 30 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 `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.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 `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 = 43315 AND t.round = 7 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 `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 = 38541 AND t.round = 7 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 `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 = 34063 AND t.round = 30 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 `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 = 15461 AND t.round = 30 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 `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 = 23948 AND t.round = 7 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 `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 = 4183 AND t.round = 30 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 `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 = 12955 AND t.round = 7 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 = 2850 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC