4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hapoel Kaukab
Información

Histórico de participación

Partidos del Hapoel Kaukab

Ir al LIVESCORE
01 May 24  en 14 h Hapoel Kaukab Hapoel Kaukab
12:30
Maccabi Ahi Nazareth Maccabi Ahi Nazareth 0
26 Abr 24  Finalizado Hapoel Kfar Kana Hapoel Kfar Kana
2 - 1
Hapoel Kaukab Hapoel Kaukab 0
19 Abr 24  Finalizado Hapoel Kaukab Hapoel Kaukab
2 - 7
Hapoel Bnei Zalafa Hapoel Bnei Zalafa 0
12 Abr 24  Finalizado Maccabi Kiryat Bialik Maccabi Kiryat Bialik
3 - 0
Hapoel Kaukab Hapoel Kaukab 2
09 Abr 24  Finalizado Hapoel Kaukab Hapoel Kaukab
0 - 2
FC Tira FC Tira 0
05 Abr 24  Finalizado Hapoel Raanana Hapoel Raanana
6 - 0
Hapoel Kaukab Hapoel Kaukab 0
29 Mar 24  Finalizado Hapoel Kaukab Hapoel Kaukab
1 - 0
Tzeirei Umm Al-Fahm Tzeirei Umm Al-Fahm 0
22 Mar 24  Finalizado Hapoel Bueine Hapoel Bueine
1 - 1
Hapoel Kaukab Hapoel Kaukab 1
16 Mar 24  Finalizado Hapoel Kaukab Hapoel Kaukab
1 - 1
Tzeirey Taibe Tzeirey Taibe 0
12 Mar 24  Finalizado Tzeirei Kfar Kanna Tzeirei Kfar Kanna
3 - 4
Hapoel Kaukab Hapoel Kaukab 5
08 Mar 24  Finalizado Hapoel Kaukab Hapoel Kaukab
0 - 1
Ironi Baka El Garbiya Ironi Baka El Garbiya 1
05 Mar 24  Finalizado Maccabi Nujeidat Ahmed Maccabi Nujeidat Ahmed
1 - 0
Hapoel Kaukab Hapoel Kaukab 2
01 Mar 24  Finalizado Kiryat Yam Kiryat Yam
2 - 0
Hapoel Kaukab Hapoel Kaukab 0
26 Feb 24  Finalizado Hapoel Migdal Hapoel Migdal
1 - 1
Hapoel Kaukab Hapoel Kaukab 1
23 Feb 24  Finalizado Hapoel Kaukab Hapoel Kaukab
1 - 1
Ironi Nesher Ironi Nesher 0
09 Feb 24  Finalizado Maccabi Ahi Nazareth Maccabi Ahi Nazareth
1 - 0
Hapoel Kaukab Hapoel Kaukab 0
06 Feb 24  Finalizado Hapoel Kaukab Hapoel Kaukab
0 - 1
Hapoel Kfar Kana Hapoel Kfar Kana 3
03 Feb 24  Finalizado Hapoel Bnei Zalafa Hapoel Bnei Zalafa
0 - 3
Hapoel Kaukab Hapoel Kaukab 0
24 Ene 24  Finalizado Hapoel Kaukab Hapoel Kaukab
0 - 1
Maccabi Kiryat Bialik Maccabi Kiryat Bialik 0
19 Ene 24  Finalizado FC Tira FC Tira
4 - 0
Hapoel Kaukab Hapoel Kaukab 2
12 Ene 24  Finalizado Hapoel Kaukab Hapoel Kaukab
1 - 2
Hapoel Raanana Hapoel Raanana 2
05 Ene 24  Finalizado Tzeirei Umm Al-Fahm Tzeirei Umm Al-Fahm
2 - 0
Hapoel Kaukab Hapoel Kaukab 0

Estadísticas

GOLEADORES

Plantilla del Hapoel Kaukab Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Centrocampista
25 il - - 2 - -
20 il - - - - -
- il - - 1 - -

Últimas noticias

Ver últimas noticias

El pasazo de Kroos, la definición de Vini: primer tiro a puerta y 0-1

El Real Madrid, en su primera aparición por el área de Manuel Neuer, mandó la pelota para dentro de la portería. Toni Kroos, que manejó el balón delante del círculo central, tuvo todo el tiempo del mundo para meter un balón medido a Vinicius, que se encargó de batir al portero con la derecha.

"Kaiser, Franz": brutal homenaje del Bayern a la leyenda con un imponente tifo

El Bayern de Múnich demostró su enorme clase en la previa del partido ante el Real Madrid. Y es que una de las gradas del Allianz Arena exhibió un tifo en honor a Franz Beckenbauer, un referente del fútbol alemán y del cuadro bávaro.

Actualidad del día en el fútbol colombiano a 30 de abril de 2024

Estas son las noticias más destacadas del día en el fútbol colombiano a 30 de abril de 2024.

El Atlético recurrirá el cierre parcial del Metropolitano por los insultos racistas a Nico

El Atlético de Madrid, según pudo saber 'EFE', va a recurrir la sanción por la que cerrarán parcialmente una de las gradas del Metropolitano debido a los insultos racistas a Nico Williams el pasado sábado ante el Athletic. El club alega que ha colaborado en todo lo posible con las autoridades pertinentes para evitar estos actos.

"Sabemos que vamos a sufrir... igual que el Bayern"

Carlo Ancelotti, entrenador del Real Madrid, pasó por los micrófonos de 'Movistar Liga de Campeones' en la previa del duelo contra el Bayern y aseguró abiertamente que sabe que tendrá que sufrir al igual que su oponente. Además, el italiano apuntó que el partido será abierto y que los detalles marcarán la diferencia.




  USO DE MEMORIA  
5,080,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  2.1479
Total Execution Time  2.1499
  CADENA URL  
/Hapoel-Kaukab
  GET DATOS  
$_GET['/Hapoel-Kaukab']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0017  SELECT type FROM routes WHERE alias = 'hapoel-kaukab'
0.0039  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 = 73895
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=107892 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1570 AND type_rel = 3
0.1719  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.0879  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 = 73841 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0318  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 = 73895 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0212  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 107892 or c.datateam2 = 107892) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.5085  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 107892 or c.datateam2 = 107892) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0181  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 107892 or c.datateam2 = 107892) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.3102  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 107892 AND rp.league_id = 73895 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.1107  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6609302 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.1081  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6609302
0.1708  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6609302 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.1114  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6609302 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0798  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6609302 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.1766   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6609302 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.2022  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6609302 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC