4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hapoel Bnei Fureidis
TEMPORADA 2023/2024
CUARTA ISRAEL GRUPO 6
Equipo PJ GF GC Puntos
1 Hapoel Bnei Bi'ina Hapoel Bnei 21 62 38 33
2 Maccabi Bnei Jadeidi Maccabi Bnei 22 39 42 30
3 Maccabi Ahva Shaab Maccabi Ahva 21 41 43 28
4 Ironi Bnei Kabul Ironi Bnei. 22 32 40 23
5 Ahva Kafr Manda Ahva Kafr M. 22 38 57 22
6 Ahi Acre FC Ahi Acre FC 21 26 50 17
7 Maccabi Ironi Tamra Maccabi 21 17 83 10
8 Maccabi Ironi Yafia Maccabi 22 15 106 3
9 Hapoel Tirat HaCarmel Hapoel Tirat 21 51 17 42
10 Hapoel Bnei Ar'ara 'Ara Hapoel Bnei 22 35 33 32
11 Ihud Bnei Baka Ihud Bnei B. 22 41 43 29
12 Hapoel Qalansawe Hapoel 21 43 45 28
13 Bnei Qalansawe Bnei 22 48 60 22
14 Maccabi Achva Fureidis Maccabi 22 26 57 13
15 Hapoel Bnei Fureidis Hapoel Bnei 20 21 79 12
16 Ihud Bnei Kfar Kara FC Ihud Bnei K. 22 19 55 9
17 Beitar Ramat Gan Beitar Ramat 22 30 35 31
18 Ironi Beit Dagan Ironi Beit. 22 33 27 29
19 Hapoel Mahane Yehuda Hapoel 22 31 32 29
20 Beitar Petah Tikva Beitar Petah 22 35 35 26
21 Hakoah Maccabi Ramat Gan Hakoah 22 26 28 25
22 Beitar Tel Aviv Bat Yam Beitar Aviv 22 25 35 23
23 Sporting Tel Aviv Sporting 22 16 41 15
24 Inter Aly'aa Tel Aviv Inter Aly'aa 22 20 68 11
25 Shikun HaMizrah Shikun 20 17 23 28
26 Hapoel Bnei Ashdod Hapoel Bnei 20 33 35 26
27 Ramla Ramla 20 32 40 25
28 Maccabi Kiryat Gat FC Maccabi 20 36 37 23
29 Maccabi Stars Ramla Maccabi 20 30 34 22
30 Hapoel Gedera Hapoel 20 23 51 17
31 Hapoel Shimshon Ashkelon Hapoel 20 18 51 10
TEMPORADA 2022/2023
CUARTA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Tzeirei Umm Al-Fahm Tzeirei 30 67 15 72
2 FC Tirat HaCarmel Tirat 30 61 18 67
3 Hapoel Bnei Musmus Hapoel Bnei 29 54 22 63
4 Maccabi Ahi Iksal Maccabi 29 50 24 53
5 Ihud Bnei Kfar Kara FC Ihud Bnei K. 30 58 33 51
6 Hapoel Beit Shean Hapoel Beit 29 39 39 40
7 Hapoel Bnei Ar'ara 'Ara Hapoel Bnei 29 35 41 40
8 Maccabi Achva Fureidis Maccabi 29 44 48 37
9 Maccabi Neve Sha'anan Maccabi Neve 29 32 43 33
10 Ihud Bnei Baka Ihud Bnei B. 29 35 44 31
11 Hapoel Bnei Fureidis Hapoel Bnei 29 36 54 30
12 Hapoel Tirat HaCarmel Hapoel Tirat 29 27 48 30
13 Beitar Haifa Jacob Beitar Haifa 29 31 44 29
14 Hapoel Sandala Gilboa Hapoel 29 31 62 29
15 Pardes Hanna-Karkur Pardes 29 25 50 24
16 Ahva Reineh Ahva Reineh 18 11 51 9
TEMPORADA 2021/2022
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Ironi Tiberias Ironi 34 60 24 72
2 FC Tira FC Tira 34 66 50 58
3 Tzeirey Taibe Tzeirey 34 50 29 57
4 Hapoel Herzliya Hapoel 34 59 41 56
5 Hapoel Bueine Hapoel 34 46 34 55
6 Maccabi Ironi Tamra Maccabi 34 46 41 54
7 Hapoel Bnei Zalafa Hapoel Bnei 34 52 39 54
8 Ironi Baka El Garbiya Ironi Baka. 34 52 39 52
9 Maccabi Kiryat Ata Bialik Maccabi 34 43 33 50
10 Hapoel Kfar Kana Hapoel Kfar 34 56 54 48
11 Tzeirei Kfar Kanna Tzeirei Kfar 34 69 52 48
12 Ironi Nesher Ironi Nesher 34 48 37 46
13 Hapoel Kaukab Hapoel 34 62 50 45
14 Hapoel Migdal Hapoel 34 41 49 42
15 Hapoel Bnei Fureidis Hapoel Bnei 34 41 67 36
16 Hapoel Bnei Ar'ara 'Ara Hapoel Bnei 34 38 66 26
17 Hapoel Iksal Hapoel Iksal 34 26 94 26
18 Rubi Shapira Rubi Shapira 34 34 90 24
TEMPORADA 2020/2021
TERCERA ISRAEL GRUPO 7
Equipo PJ GF GC Puntos
1 Maccabi Kiryat Ata Bialik Maccabi 6 15 3 14
2 Ironi Tiberias Ironi 6 11 5 12
3 Hapoel Herzliya Hapoel 6 13 4 11
4 Hapoel Bnei Fureidis Hapoel Bnei 6 11 11 8
5 Hapoel Kfar Kana Hapoel Kfar 6 12 13 8
6 Hapoel Bueine Hapoel 6 8 12 6
7 Ihud Bnei Mejdek Krum Ihud Bnei M. 6 3 25 0

  USO DE MEMORIA  
5,513,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0944
Total Execution Time  0.0957
  CADENA URL  
/historico/Hapoel-Bnei-Fureidis
  GET DATOS  
$_GET['/historico/Hapoel-Bnei-Fureidis']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0029  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-Bnei-Fureidis' 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.0018  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=121842 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=121842 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=121842 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=121842 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 74116
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 = 75648
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121842 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2439 AND type_rel = 3
0.0021  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 = '121842' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '121842' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '121842' 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 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=121842 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (75648,73841) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75648 AND teamId = 121842
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73841 AND teamId = 121842
0.0021  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 = '121842' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '121842' and rp.type = 4
0.0020  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 = '121842' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 74116 WHERE rp.league_id = 74116 AND rp.teamId = 121842 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.0020  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 = 74116 WHERE rp.league_id = 74116 AND rp.teamId = 121842 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 74116 WHERE rp.league_id = 74116 AND rp.teamId = 121842 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 121842 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74116 AND t.round = 15 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 `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 = 75648 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.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 = 69272 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.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 `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 = 64365 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.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 = 59150 AND t.round = 18 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 `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 = 62213 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