4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bnei Yehuda Tel Aviv Sub 19
TEMPORADA 2023/2024
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Petah Tikva Sub 19 Maccabi 27 52 13 69
2 Maccabi Haifa Sub 19 Maccabi 27 64 32 49
3 Bnei Sakhnin Sub 19 Bnei Sakhnin 27 38 26 46
4 Hapoel Tel Aviv Sub 19 Hapoel Aviv 27 45 38 43
5 Maccabi Netanya Sub 19 Maccabi 27 37 29 41
6 Maccabi Tel Aviv Sub 19 Maccabi Aviv 27 46 32 40
7 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 26 36 33 38
8 Ashdod Sub 19 Ashdod 26 36 37 36
9 Hapoel Raanana Sub 19 Hapoel 27 35 59 35
10 Hapoel Kfar Saba Sub 19 Hapoel Kfar 27 39 34 34
11 Hapoel Haifa Sub 19 Hapoel Haifa 27 20 39 32
12 Hapoel Rishon LeZion Sub 19 Hapoel 27 34 43 30
13 Hapoel Hadera Sub 19 Hapoel 27 28 41 30
14 Hapoel Beer Sheva Sub 19 Hapoel Beer 26 28 42 28
15 Hap Ramat Hasharon Sub 19 Ramat 27 27 47 24
16 Ironi Kiryat Shmona Sub 19 Ironi Kiryat 26 21 41 19
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 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
TEMPORADA 2017/2018
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 65 24 67
2 Maccabi Netanya Sub 19 Maccabi 30 53 34 59
3 Maccabi Haifa Sub 19 Maccabi 30 53 27 56
4 Hapoel Raanana Sub 19 Hapoel 30 45 31 55
5 Ashdod Sub 19 Ashdod 30 37 28 52
6 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 51 48 48
7 Maccabi Petah Tikva Sub 19 Maccabi 30 42 32 47
8 Hapoel Kiryat Shmona Sub 19 Hapoel 30 39 41 39
9 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 30 30 35 39
10 Bnei Sakhnin Sub 19 Bnei Sakhnin 30 34 39 37
11 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 46 47 35
12 Beitar Jerusalem Sub 19 Beitar 30 36 47 34
13 Hap Ramat Hasharon Sub 19 Ramat 30 35 52 34
14 Hapoel Rishon LeZion Sub 19 Hapoel 30 29 46 28
15 Hapoel Petah Tikva Sub 19 Hapoel Petah 30 36 47 25
16 Hapoel Ashkelon Sub 19 Hapoel 30 17 70 11
TEMPORADA 2016/2017
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 30 59 16 72
2 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 53 24 58
3 Hapoel Raanana Sub 19 Hapoel 30 39 33 55
4 Maccabi Petah Tikva Sub 19 Maccabi 30 65 39 46
5 Hapoel Kiryat Shmona Sub 19 Hapoel 30 45 32 46
6 Maccabi Netanya Sub 19 Maccabi 30 41 41 44
7 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 30 38 47 43
8 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 38 38 42
9 Bnei Sakhnin Sub 19 Bnei Sakhnin 30 55 50 39
10 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 39 36 39
11 Hap Ramat Hasharon Sub 19 Ramat 30 52 45 38
12 Hapoel Rishon LeZion Sub 19 Hapoel 30 37 46 34
13 Ashdod Sub 19 Ashdod 30 26 46 32
14 Beitar Nes Tubruk Sub 19 Beitar 30 25 46 24
15 Hapoel Haifa Sub 19 Hapoel Haifa 30 26 48 23
16 Hapoel Ashkelon Sub 19 Hapoel 30 26 77 23
TEMPORADA 2015/2016
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 30 71 21 70
2 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 36 31 52
3 Hapoel Kiryat Shmona Sub 19 Hapoel 30 52 31 50
4 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 50 39 49
5 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 49 36 47
6 Hapoel Raanana Sub 19 Hapoel 30 44 31 47
7 Bnei Sakhnin Sub 19 Bnei Sakhnin 30 51 38 43
8 Beitar Nes Tubruk Sub 19 Beitar 30 32 33 42
9 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 30 44 44 40
10 Hapoel Haifa Sub 19 Hapoel Haifa 30 42 45 39
11 Hapoel Rishon LeZion Sub 19 Hapoel 30 36 41 39
12 Ashdod Sub 19 Ashdod 30 41 45 37
13 Maccabi Netanya Sub 19 Maccabi 30 38 40 35
14 Maccabi Petah Tikva Sub 19 Maccabi 30 45 54 32
15 Beitar Jerusalem Sub 19 Beitar 30 23 57 23
16 Sektzia Nes Tziona Sub 19 Sektzia 30 23 91 12
TEMPORADA 2013/2014
LIGA ISRAEL SUB 19
Equipo PJ GF GC Puntos
1 Maccabi Haifa Sub 19 Maccabi 30 59 27 62
2 Maccabi Tel Aviv Sub 19 Maccabi Aviv 30 60 27 60
3 Maccabi Petah Tikva Sub 19 Maccabi 30 51 35 52
4 Beitar Nes Tubruk Sub 19 Beitar 30 54 36 51
5 Hapoel Kiryat Shmona Sub 19 Hapoel 30 49 36 49
6 Maccabi Netanya Sub 19 Maccabi 30 42 36 45
7 Hapoel Tel Aviv Sub 19 Hapoel Aviv 30 46 46 41
8 Hapoel Haifa Sub 19 Hapoel Haifa 30 44 44 41
9 Hapoel Beer Sheva Sub 19 Hapoel Beer 30 39 51 38
10 Hapoel Rishon LeZion Sub 19 Hapoel 30 36 46 37
11 Ashdod Sub 19 Ashdod 30 56 49 35
12 Beitar Jerusalem Sub 19 Beitar 30 35 43 35
13 Hapoel Raanana Sub 19 Hapoel 30 33 49 35
14 Hapoel Ramat Gan Sub 19 Hapoel Ramat 30 31 40 34
15 Bnei Yehuda Tel Aviv Sub 19 Bnei Yehuda 30 34 58 34
16 Hap Ramat Hasharon Sub 19 Ramat 30 25 71 16

  USO DE MEMORIA  
5,643,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4535
Total Execution Time  0.4548
  CADENA URL  
/historico/Bnei-Yehuda-Tel-Aviv-Sub-19
  GET DATOS  
$_GET['/historico/Bnei-Yehuda-Tel-Aviv-Sub-19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0135  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 = 'Bnei-Yehuda-Tel-Aviv-Sub-19' 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.0125  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=80636 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=80636 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0288  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=80636 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1557 AND type_rel = 3
0.0131  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 = '80636' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '80636' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '80636' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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.0130  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=80636 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73243 AND teamId = 80636
0.0128  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 = '80636' 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 = '80636' and rp.type = 4
0.0126  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 = '80636' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142  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 = 80636 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.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 = 73243 WHERE rp.league_id = 73243 AND rp.teamId = 80636 AND (e.action = 4 or e.action = 5) 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 = 80636 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 80636 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0134  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.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 = 48976 AND t.round = 30 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 = 37184 AND t.round = 30 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 = 15642 AND t.round = 30 ORDER BY team.conference 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 `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 = 24942 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC