4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hapoel Kaukab
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
TERCERA ISRAEL GRUPO 5
Equipo PJ GF GC Puntos
1 Maccabi Bnei Reineh Maccabi Bnei 6 8 8 10
2 FC Tira FC Tira 6 6 4 9
3 Hapoel Kaukab Hapoel 6 6 5 8
4 Maccabi Ironi Tamra Maccabi 6 6 9 5
TEMPORADA 2019/2020
TERCERA ISRAEL GRUPO 1
Equipo PJ GF GC Puntos
1 Hapoel Iksal Hapoel Iksal 21 39 12 47
2 Hapoel Kaukab Hapoel 22 37 16 46
3 FC Tira FC Tira 22 31 19 40
4 Rubi Shapira Rubi Shapira 21 26 18 37
5 Maccabi Ironi Tamra Maccabi 21 28 22 31
6 Maccabi Kiryat Ata Bialik Maccabi 22 27 26 28
7 Ironi Baka El Garbiya Ironi Baka. 21 25 25 28
8 Hapoel Bnei Zalafa Hapoel Bnei 21 27 31 28
9 Hapoel Herzliya Hapoel 22 25 32 26
10 Hapoel Kfar Kana Hapoel Kfar 22 22 30 24
11 Hapoel Bnei Ar'ara 'Ara Hapoel Bnei 22 20 27 22
12 Daburiyya Osama Daburiyya 21 18 32 20
13 Ironi Tiberias Ironi 22 17 29 19
14 Hapoel Migdal Hapoel 21 24 29 18
15 Maccabi Kiryat Ata Maccabi 21 18 36 15
16 Hapoel Asi Gilboa Hapoel 0 0 0 0
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

  USO DE MEMORIA  
5,505,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0664
Total Execution Time  0.0677
  CADENA URL  
/historico/Hapoel-Kaukab
  GET DATOS  
$_GET['/historico/Hapoel-Kaukab']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=107892 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1570 AND type_rel = 3
0.0021  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 = '107892' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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=107892 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 (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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73895 AND teamId = 107892
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73841 AND teamId = 107892
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 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 = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = 107892 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.0019  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 = 107892 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 107892 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 107892 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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 = 59151 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 = 62211 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.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 `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 = 51096 AND t.round = 23 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 `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