4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ironi Nesher
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
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
CUARTA ISRAEL GRUPO 7
Equipo PJ GF GC Puntos
1 Ironi Nesher Ironi Nesher 6 17 3 16
2 FC Tirat HaCarmel Tirat 6 9 3 13
3 Hapoel Tirat HaCarmel Hapoel Tirat 6 7 16 2
4 Maccabi Neve Sha'anan Maccabi Neve 6 8 19 2
TEMPORADA 2018/2019
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Umm al-Fahm Hapoel 28 55 19 63
2 Ironi Baka El Garbiya Ironi Baka. 28 52 31 48
3 Hapoel Herzliya Hapoel 28 40 34 46
4 Hapoel Kaukab Hapoel 28 44 41 46
5 FC Tira FC Tira 28 41 32 39
6 Hapoel Kfar Kana Hapoel Kfar 28 41 51 37
7 Rubi Shapira Rubi Shapira 28 39 28 36
8 Hapoel Bnei Zalafa Hapoel Bnei 28 31 34 34
9 Maccabi Kiryat Ata Maccabi 28 28 31 34
10 Hapoel Asi Gilboa Hapoel 28 35 43 34
11 Hapoel Migdal Hapoel 28 28 38 34
12 Ironi Tiberias Ironi 28 29 42 34
13 Maccabi Kiryat Ata Bialik Maccabi 28 26 31 33
14 Ironi Nesher Ironi Nesher 28 31 44 33
15 Hapoel Jerusalem Hapoel 28 32 53 31
16 Hapoel Shfara'am Hapoel 0 0 0 0
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 3
Equipo PJ GF GC Puntos
1 Hapoel Ramat HaSharon Hapoel Ramat 7 11 4 14
2 Hapoel Rishon LeZion Hapoel 7 10 10 10
3 Hapoel Jerusalem Hapoel 7 7 6 9
4 Ironi Nesher Ironi Nesher 7 4 3 9
5 Hapoel Nof HaGalil Hapoel 7 7 10 9
6 Maccabi Sha'araim Maccabi 7 12 15 8
7 Maccabi Herzliya Maccabi 7 8 11 8
8 Hapoel Afula Hapoel Afula 7 13 13 7
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

  USO DE MEMORIA  
5,855,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1358
Total Execution Time  0.1377
  CADENA URL  
/historico/Ironi-Nesher
  GET DATOS  
$_GET['/historico/Ironi-Nesher']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0027  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 = 'Ironi-Nesher' 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.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=60711 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=60711 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=60711 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60711 AND type_rel = 2
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1570 AND type_rel = 3
0.0026  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 = '60711' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '60711' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '60711' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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=60711 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0026  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) 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.0038  SELECT count(id) as num_players from rel_players WHERE league_id = 73895 AND teamId = 60711
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73841 AND teamId = 60711
0.0023  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 = '60711' 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 = '60711' and rp.type = 4
0.0021  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 = '60711' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 = 60711 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.0036  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 = 60711 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 60711 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 60711 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 = 73895 AND t.round = 29 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 `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.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 = 61907 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.0059  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 = 62596 AND t.round = 6 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 `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 = 44793 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.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 `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.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 `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.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.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 `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.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 = 9315 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC