4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hapoel Hadera Sub 19
TEMPORADA 2023/2024
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Petah Tikva Sub 19 Maccabi 23 46 11 59
2 Bnei Sakhnin Sub 19 Bnei Sakhnin 24 34 21 44
3 Maccabi Haifa Sub 19 Maccabi 23 56 27 42
4 Hapoel Tel Aviv Sub 19 Hapoel Aviv 23 40 31 39
5 Maccabi Netanya Sub 19 Maccabi 23 33 23 37
6 Maccabi Tel Aviv Sub 19 Maccabi Aviv 24 40 30 34
7 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 23 29 33 31
8 Ashdod Sub 19 Ashdod 23 32 32 30
9 Hapoel Haifa Sub 19 Hapoel Haifa 23 17 34 29
10 Hapoel Raanana Sub 19 Hapoel 23 29 49 28
11 Hapoel Rishon LeZion Sub 19 Hapoel 23 31 34 27
12 Hapoel Hadera Sub 19 Hapoel 23 25 37 26
13 Hapoel Kfar Saba Sub 19 Hapoel Kfar 23 28 30 25
14 Hap Ramat Hasharon Sub 19 Ramat 23 22 37 24
15 Hapoel Beer Sheva Sub 19 Hapoel Beer 23 22 38 21
16 Ironi Kiryat Shmona Sub 19 Ironi Kiryat 23 20 37 18
TEMPORADA 2022/2023
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 30 84 33 66
2 Maccabi Netanya Sub 19 Maccabi 30 70 34 60
3 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 61 45 51
4 Ashdod Sub 19 Ashdod 30 53 44 51
5 Maccabi Petah Tikva Sub 19 Maccabi 30 55 36 47
6 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 46 49 46
7 Bnei Sakhnin Sub 19 Bnei Sakhnin 30 47 47 45
8 Hapoel Hadera Sub 19 Hapoel 30 51 59 43
9 Hapoel Raanana Sub 19 Hapoel 30 49 54 41
10 Ironi Kiryat Shmona Sub 19 Ironi Kiryat 30 42 39 38
11 Hapoel Haifa Sub 19 Hapoel Haifa 30 38 56 37
12 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 35 54 36
13 Hap Ramat Hasharon Sub 19 Ramat 30 30 47 33
14 Hapoel Rishon LeZion Sub 19 Hapoel 30 48 59 31
15 Hapoel Ramat Gan Sub 19 Hapoel Ramat 30 32 65 28
16 Beitar Jerusalem Sub 19 Beitar 30 32 52 27
TEMPORADA 2021/2022
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Ashdod Sub 19 Ashdod 34 82 37 75
2 Maccabi Petah Tikva Sub 19 Maccabi 34 72 34 71
3 Hapoel Tel Aviv Sub 19 Hapoel Aviv 34 80 37 67
4 Maccabi Tel Aviv Sub 19 Maccabi Aviv 34 68 31 67
5 Maccabi Haifa Sub 19 Maccabi 34 73 39 64
6 Hapoel Rishon LeZion Sub 19 Hapoel 34 80 62 54
7 Hapoel Ramat Gan Sub 19 Hapoel Ramat 34 37 29 54
8 Ironi Kiryat Gat Sub 19 Ironi Kiryat 34 44 44 49
9 Maccabi Netanya Sub 19 Maccabi 34 50 43 46
10 Hapoel Raanana Sub 19 Hapoel 34 39 54 43
11 Bnei Sakhnin Sub 19 Bnei Sakhnin 34 49 71 43
12 Hapoel Beer Sheva Sub 19 Hapoel Beer 34 52 69 42
13 Hapoel Hadera Sub 19 Hapoel 34 44 50 40
14 Beitar Jerusalem Sub 19 Beitar 34 39 47 40
15 Hapoel Kfar Saba Sub 19 Hapoel Kfar 34 31 54 35
16 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 34 49 72 32
17 Sektzia Nes Tziona Sub 19 Sektzia 34 34 85 22
18 Ironi Nesher Sub 19 Ironi Nesher 34 25 90 10
TEMPORADA 2020/2021
LIGA ISRAEL SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 17 42 14 46
2 Maccabi Petah Tikva Sub 19 Maccabi 17 29 8 38
3 Maccabi Tel Aviv Sub 19 Maccabi Aviv 17 27 20 32
4 Ashdod Sub 19 Ashdod 17 41 29 31
5 Hapoel Hadera Sub 19 Hapoel 17 27 19 29
6 Hapoel Tel Aviv Sub 19 Hapoel Aviv 17 22 17 27
7 Hapoel Kiryat Shmona Sub 19 Hapoel 17 17 14 26
8 Hapoel Ramat Gan Sub 19 Hapoel Ramat 17 25 21 23
TEMPORADA 2019/2020
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 23 56 13 53
2 Hapoel Tel Aviv Sub 19 Hapoel Aviv 23 45 26 42
3 Maccabi Tel Aviv Sub 19 Maccabi Aviv 22 37 22 38
4 Maccabi Petah Tikva Sub 19 Maccabi 23 32 26 37
5 Maccabi Netanya Sub 19 Maccabi 23 32 25 34
6 Hap Ramat Hasharon Sub 19 Ramat 23 30 28 33
7 Hapoel Beer Sheva Sub 19 Hapoel Beer 23 34 36 31
8 Hapoel Kiryat Shmona Sub 19 Hapoel 23 29 33 31
9 Hapoel Raanana Sub 19 Hapoel 23 24 23 30
10 Hapoel Ramat Gan Sub 19 Hapoel Ramat 23 26 28 28
11 Beitar Jerusalem Sub 19 Beitar 22 22 26 27
12 Hapoel Rishon LeZion Sub 19 Hapoel 23 24 31 25
13 Bnei Sakhnin Sub 19 Bnei Sakhnin 23 22 33 24
14 Beitar Nes Tubruk Sub 19 Beitar 23 20 39 24
15 Hapoel Nof HaGalil Sub 19 Hapoel 23 21 39 21
16 Hapoel Hadera Sub 19 Hapoel 23 17 43 12
TEMPORADA 2018/2019
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Petah Tikva Sub 19 Maccabi 30 66 33 63
2 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 46 30 56
3 Bnei Sakhnin Sub 19 Bnei Sakhnin 30 44 36 45
4 Hap Ramat Hasharon Sub 19 Ramat 30 34 35 44
5 Hapoel Kiryat Shmona Sub 19 Hapoel 30 38 33 42
6 Hapoel Raanana Sub 19 Hapoel 30 37 36 42
7 Beitar Nes Tubruk Sub 19 Beitar 30 44 45 42
8 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 43 41 41
9 Maccabi Haifa Sub 19 Maccabi 30 43 44 37
10 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 39 44 37
11 Beitar Jerusalem Sub 19 Beitar 30 40 40 35
12 Maccabi Netanya Sub 19 Maccabi 30 39 43 35
13 Hapoel Hadera Sub 19 Hapoel 30 30 39 34
14 Hapoel Ramat Gan Sub 19 Hapoel Ramat 30 23 36 34
15 Ashdod Sub 19 Ashdod 30 31 42 31
16 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 30 33 53 24

  USO DE MEMORIA  
5,467,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4761
Total Execution Time  0.4780
  CADENA URL  
/historico/Hapoel-Hadera-Sub20
  GET DATOS  
$_GET['/historico/Hapoel-Hadera-Sub20']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0167  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-Hadera-Sub20' 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.0131  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=119759 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=119759 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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 = 73243
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119759 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1557 AND type_rel = 3
0.0128  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 = '119759' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '119759' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '119759' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73243 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=119759 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73243) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73243 AND teamId = 119759
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73243 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '119759' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '119759' and rp.type = 4
0.0127  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 = '119759' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  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 = 73243 WHERE rp.league_id = 73243 AND rp.teamId = 119759 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.0134  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 = 73243 WHERE rp.league_id = 73243 AND rp.teamId = 119759 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 73243 WHERE rp.league_id = 73243 AND rp.teamId = 119759 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 119759 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 73243 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 69505 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.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 = 63915 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.0129  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 = 58554 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 62543 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.0128  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 = 58555 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.0129  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 = 48975 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC