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

Maccabi Haifa

Entrenador: Messay Dego

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Maccabi Tel Aviv Maccabi Aviv 28 58 21 66
2 Maccabi Haifa Maccabi 28 57 21 56
3 Hapoel Beer Sheva Hapoel Beer 28 47 21 52
4 Hapoel Haifa Hapoel Haifa 28 40 36 47
5 Maccabi Bnei Reineh Maccabi Bnei 28 30 27 40
6 Bnei Sakhnin Bnei Sakhnin 28 28 34 36
TEMPORADA 2022/2023
LIGA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Maccabi Haifa Maccabi 36 76 34 84
2 Hapoel Beer Sheva Hapoel Beer 36 65 29 77
3 Maccabi Tel Aviv Maccabi Aviv 36 69 23 73
4 Hapoel Jerusalén Hapoel 36 38 44 45
5 Maccabi Netanya Maccabi 36 44 58 45
6 FC Ashdod FC Ashdod 36 41 46 43
TEMPORADA 2021/2022
LIGA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Maccabi Haifa Maccabi 36 79 27 78
2 Hapoel Beer Sheva Hapoel Beer 36 53 30 70
3 Maccabi Tel Aviv Maccabi Aviv 36 63 38 69
4 Maccabi Netanya Maccabi 36 47 41 52
5 Hapoel Tel Aviv Hapoel Aviv 36 44 47 50
6 Bnei Sakhnin Bnei Sakhnin 36 33 43 49
TEMPORADA 2020/2021
LIGA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Maccabi Haifa Maccabi 36 72 29 79
2 Maccabi Tel Aviv Maccabi Aviv 36 65 33 75
3 FC Ashdod FC Ashdod 36 48 39 54
4 Hapoel Beer Sheva Hapoel Beer 36 45 43 48
5 Maccabi Petah Tikva Maccabi 36 32 38 46
6 Ironi Kiryat Shmona Ironi Kiryat 36 37 45 46
TEMPORADA 2019/2020
LIGA ISRAEL GRUPO 2
Equipo PJ GF GC Puntos
1 Maccabi Tel Aviv Maccabi Aviv 10 15 3 87
2 Maccabi Haifa Maccabi 10 15 12 73
3 Beitar Jerusalem Beitar 10 9 10 59
4 Hapoel Beer Sheva Hapoel Beer 10 11 10 55
5 Hapoel Tel Aviv Hapoel Aviv 10 7 19 48
6 Hapoel Haifa Hapoel Haifa 10 13 16 47
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
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 1
Equipo PJ GF GC Puntos
1 Hapoel Beer Sheva Hapoel Beer 26 54 13 59
2 Maccabi Tel Aviv Maccabi Aviv 26 45 19 56
3 Maccabi Petah Tikva Maccabi 26 36 23 48
4 Beitar Jerusalem Beitar 26 34 27 40
5 Bnei Sakhnin Bnei Sakhnin 26 26 26 39
6 Maccabi Haifa Maccabi 26 30 25 38
7 Ironi Kiryat Shmona Ironi Kiryat 26 35 33 35
8 Hapoel Haifa Hapoel Haifa 26 29 36 28
9 FC Ashdod FC Ashdod 26 15 26 28
10 Hapoel Raanana Hapoel 26 14 29 28
11 Bnei Yehuda Tel Aviv Bnei Yehuda 26 20 32 25
12 Hapoel Kfar Saba Hapoel Kfar 26 17 34 21
13 Hapoel Ashkelon Hapoel 26 15 39 18
14 Hapoel Tel Aviv Hapoel Aviv 26 18 26 17
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 1
Equipo PJ GF GC Puntos
1 Maccabi Tel Aviv Maccabi Aviv 26 54 21 54
2 Hapoel Beer Sheva Hapoel Beer 26 47 24 49
3 Ironi Kiryat Shmona Ironi Kiryat 26 40 27 47
4 Beitar Jerusalem Beitar 26 38 29 40
5 Maccabi Petah Tikva Maccabi 26 28 30 39
6 Maccabi Haifa Maccabi 26 38 29 37
7 Hapoel Raanana Hapoel 26 24 23 34
8 Maccabi Netanya Maccabi 26 37 45 33
9 Bnei Sakhnin Bnei Sakhnin 26 32 37 30
10 Hapoel Tel Aviv Hapoel Aviv 26 28 34 29
11 FC Ashdod FC Ashdod 26 29 41 27
12 Hapoel Haifa Hapoel Haifa 26 20 41 26
13 Hapoel Petah Tikva Hapoel Petah 26 28 43 23
14 Hapoel Acre Hapoel Acre 26 20 39 22

  USO DE MEMORIA  
6,548,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.4590
Total Execution Time  0.4602
  CADENA URL  
/historico/Maccabi-Haifa-Fc
  GET DATOS  
$_GET['/historico/Maccabi-Haifa-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0259  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 = 74792
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1609 AND type_rel = 2
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1609 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130  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 (1494,3003,15842,73522,102943) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = '1609' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153  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 = 1609 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133  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 = 72211 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.0132  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 = 75691 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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.0130  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 = 71236 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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.0130  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 = 66960 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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.0130  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 = 61920 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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.0130  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 = 55618 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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.0131  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.0132  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 = 38707 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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.0131  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 = 38078 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 33688 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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.0135  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.0131  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 = 11082 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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