4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hapoel Raanana
TEMPORADA 2023/2024
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Raanana Hapoel 29 56 15 68
2 FC Tira FC Tira 29 56 28 56
3 Maccabi Kiryat Ata Bialik Maccabi 29 40 21 54
4 Kiryat Yam Kiryat Yam 29 56 31 53
5 Ironi Baka El Garbiya Ironi Baka. 29 43 24 53
6 Hapoel Bnei Zalafa Hapoel Bnei 29 46 45 38
7 Tzeirei Kfar Kanna Tzeirei Kfar 29 44 51 36
8 Maccabi Ahi Nazareth Maccabi 29 39 35 35
9 Hapoel Bueine Hapoel 29 41 39 34
10 Hapoel Migdal Hapoel 29 32 46 32
11 Tzeirei Umm Al-Fahm Tzeirei 29 38 53 32
12 Ironi Nesher Ironi Nesher 29 30 43 31
13 Hapoel Kfar Kana Hapoel Kfar 29 36 52 31
14 Maccabi Nujeidat Ahmed Maccabi 29 21 47 25
15 Tzeirey Taibe Tzeirey 29 32 45 24
16 Hapoel Kaukab Hapoel 29 22 57 16
TEMPORADA 2022/2023
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Ihud Bnei Shfaram Ihud Bnei S. 30 67 28 66
2 Tzeirei Kfar Kanna Tzeirei Kfar 30 56 24 60
3 Ironi Baka El Garbiya Ironi Baka. 30 60 22 59
4 Hapoel Raanana Hapoel 30 42 26 50
5 Hapoel Bnei Zalafa Hapoel Bnei 30 52 49 42
6 Maccabi Kiryat Ata Bialik Maccabi 30 40 40 40
7 Ironi Nesher Ironi Nesher 30 45 52 38
8 Maccabi Nujeidat Ahmed Maccabi 30 29 29 37
9 FC Tira FC Tira 30 38 42 37
10 Tzeirey Taibe Tzeirey 30 37 39 36
11 Hapoel Migdal Hapoel 30 51 61 36
12 Hapoel Kfar Kana Hapoel Kfar 30 46 61 35
13 Hapoel Kaukab Hapoel 30 33 44 34
14 Hapoel Bueine Hapoel 30 29 42 33
15 Hapoel Qalansawe Hapoel 30 24 53 31
16 Maccabi Ironi Tamra Maccabi 30 29 66 21
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 3
Equipo PJ GF GC Puntos
1 Hapoel Petah Tikva Hapoel Petah 7 5 3 14
2 Hapoel Raanana Hapoel 7 17 11 13
3 Hapoel Acre Hapoel Acre 7 12 8 11
4 Hapoel Afula Hapoel Afula 7 18 11 10
5 Hapoel Umm al-Fahm Hapoel 7 9 8 10
6 Hapoel Kfar Shalem Hapoel Kfar 7 5 12 8
7 Kafr Qasim Kafr Qasim 7 7 9 7
8 Maccabi Ahi Nazareth Maccabi 7 5 16 6
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 3
Equipo PJ GF GC Puntos
1 Beitar Jerusalem Beitar 7 11 6 43
2 Hapoel Tel Aviv Hapoel Aviv 7 14 7 42
3 Hapoel Raanana Hapoel 7 9 8 39
4 Ironi Kiryat Shmona Ironi Kiryat 7 9 7 38
5 FC Ashdod FC Ashdod 7 14 12 37
6 Hapoel Haifa Hapoel Haifa 7 2 10 37
7 Maccabi Petah Tikva Maccabi 7 7 11 36
8 Bnei Sakhnin Bnei Sakhnin 7 6 11 27
TEMPORADA 2017/2018
LIGA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Hapoel Raanana Hapoel 7 13 5 16
2 Maccabi Haifa Maccabi 7 12 6 13
3 Ironi Kiryat Shmona Ironi Kiryat 7 11 6 13
4 Maccabi Petah Tikva Maccabi 7 10 9 10
5 Bnei Sakhnin Bnei Sakhnin 7 8 12 8
6 Hapoel Acre Hapoel Acre 7 7 13 8
7 FC Ashdod FC Ashdod 7 7 9 7
8 Hapoel Ashkelon Hapoel 7 4 12 4
TEMPORADA 2016/2017
LIGA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Ironi Kiryat Shmona Ironi Kiryat 7 9 15 39
2 Hapoel Haifa Hapoel Haifa 7 10 10 37
3 FC Ashdod FC Ashdod 7 7 6 36
4 Hapoel Raanana Hapoel 7 8 11 36
5 Bnei Yehuda Tel Aviv Bnei Yehuda 7 6 7 35
6 Hapoel Ashkelon Hapoel 7 9 3 32
7 Hapoel Kfar Saba Hapoel Kfar 7 6 6 31
8 Hapoel Tel Aviv Hapoel Aviv 7 11 8 29
TEMPORADA 2015/2016
LIGA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Beer Sheva Hapoel Beer 26 48 17 64
2 Maccabi Tel Aviv Maccabi Aviv 26 59 20 61
3 Beitar Jerusalem Beitar 26 38 19 51
4 Maccabi Haifa Maccabi 26 33 25 38
5 Bnei Sakhnin Bnei Sakhnin 26 32 25 36
6 Hapoel Raanana Hapoel 26 29 31 36
7 Bnei Yehuda Tel Aviv Bnei Yehuda 26 27 35 33
8 Maccabi Petah Tikva Maccabi 26 23 30 30
9 Hapoel Kfar Saba Hapoel Kfar 26 19 31 29
10 Hapoel Acre Hapoel Acre 26 18 36 29
11 Ironi Kiryat Shmona Ironi Kiryat 26 25 31 28
12 Hapoel Tel Aviv Hapoel Aviv 26 17 31 27
13 Hapoel Haifa Hapoel Haifa 26 27 37 25
14 Maccabi Netanya Maccabi 26 10 37 11
TEMPORADA 2014/2015
LIGA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Bnei Sakhnin Bnei Sakhnin 7 11 7 44
2 Hapoel Tel Aviv Hapoel Aviv 7 9 7 42
3 Maccabi Netanya Maccabi 7 9 9 41
4 Hapoel Raanana Hapoel 7 11 13 39
5 Hapoel Acre Hapoel Acre 7 8 3 38
6 Hapoel Haifa Hapoel Haifa 7 5 6 34
7 Hapoel Petah Tikva Hapoel Petah 7 15 16 32
8 FC Ashdod FC Ashdod 7 3 10 31
TEMPORADA 2013/2014
LIGA ISRAEL GRUPO 3
Equipo PJ GF GC Puntos
1 Beitar Jerusalem Beitar 7 10 4 42
2 FC Ashdod FC Ashdod 7 7 10 39
3 Hapoel Raanana Hapoel 7 11 7 38
4 Hapoel Acre Hapoel Acre 7 6 5 35
5 Hapoel Haifa Hapoel Haifa 7 3 11 34
6 Maccabi Petah Tikva Maccabi 7 11 12 33
7 Hapoel Ramat HaSharon Hapoel Ramat 7 8 7 33
8 Bnei Yehuda Tel Aviv Bnei Yehuda 7 6 6 31

  USO DE MEMORIA  
5,916,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6008
Total Execution Time  0.6022
  CADENA URL  
/historico/Hapoel-Ra-Anana-Il
  GET DATOS  
$_GET['/historico/Hapoel-Ra-Anana-Il']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16517 AND type_rel = 2
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1570 AND type_rel = 3
0.0171  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 = '16517' ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '16517' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155  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=16517 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (73895,73841,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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 73895 AND teamId = 16517
0.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 73841 AND teamId = 16517
0.0187  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16517
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 = '16517' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147  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 = '16517' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154  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 = 73895 WHERE rp.league_id = 73895 AND rp.teamId = 16517 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.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 = 73895 WHERE rp.league_id = 73895 AND rp.teamId = 16517 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 73895 WHERE rp.league_id = 73895 AND rp.teamId = 16517 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 16517 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0155  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 = 68502 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.0153  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.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 `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.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 `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.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 `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 = 62046 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.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 `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.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 `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.0150  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.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 `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 = 49279 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 `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 = 43102 AND t.round = 7 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 `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 = 38079 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 `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 = 21199 AND t.round = 10 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 `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 = 15439 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 4152 AND t.round = 26 ORDER BY team.conference 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 `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 = 11083 AND t.round = 7 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 `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
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 `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 = 10585 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC