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

Partidos del Spjelkavik

Ir al LIVESCORE
24 Ago 24  en 3 meses Kristiansund II Kristiansund II
15:00
Spjelkavik Spjelkavik 0
19 Ago 24  en 3 meses Spjelkavik Spjelkavik
18:30
Molde FK II Molde FK II 0
10 Ago 24  en 3 meses Lokomotiv Oslo Lokomotiv Oslo
15:00
Spjelkavik Spjelkavik 0
05 Ago 24  en 3 meses Spjelkavik Spjelkavik
18:30
Aalesunds FK II Aalesunds FK II 0
27 Jul 24  en 2 meses Skjetten Skjetten
15:00
Spjelkavik Spjelkavik 0
20 Jul 24  en 2 meses Spjelkavik Spjelkavik
17:00
Funnefoss / Vormsund Funnefoss / Vormsund 0
22 Jun 24  en 1 mes IF Ready IF Ready
15:00
Spjelkavik Spjelkavik 0
15 Jun 24  en 1 mes Spjelkavik Spjelkavik
15:00
Træff Træff 0
08 Jun 24  en 1 mes Bjorkelangen Bjorkelangen
15:00
Spjelkavik Spjelkavik 0
03 Jun 24  en 1 mes Spjelkavik Spjelkavik
18:30
Kristiansund II Kristiansund II 1
25 May 24  en 23 días Gjelleråsen Gjelleråsen
15:00
Spjelkavik Spjelkavik 0
20 May 24  en 18 días Spjelkavik Spjelkavik
16:00
Lorenskog IF Lorenskog IF 0
11 May 24  en 9 días Spjelkavik Spjelkavik
15:30
Skedsmo Skedsmo 0
06 May 24  en 4 días Molde FK II Molde FK II
19:00
Spjelkavik Spjelkavik 1
27 Abr 24  Finalizado Spjelkavik Spjelkavik
1 - 1
Skjetten Skjetten 0
22 Abr 24  Finalizado Hødd II Hødd II
3 - 3
Spjelkavik Spjelkavik 1
14 Abr 24  Finalizado Spjelkavik Spjelkavik
0 - 0
Lokomotiv Oslo Lokomotiv Oslo 0
07 Abr 24  Finalizado Aalesunds FK II Aalesunds FK II
2 - 1
Spjelkavik Spjelkavik 0

Plantilla del Spjelkavik Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Centrocampista
19 no - - 1 - -
18 no - - 1 - -
Delantero
19 no - - 2 - -
20 no - - 1 - -
- no - - - - -

Noticias de Cuarta Noruega

Ver últimas noticias

¡Se cambia el nombre para ser el Leo Messi de la Cuarta Noruega!

Lionel Messi jugará la próxima temporada en el IK Junkeren de la Cuarta División de Noruega. Sin embargo, no se trata del jugador del Barcelona, sino de un futbolista de 16 años que se cambió el nombre al del astro argentino.

Soderlund 'homenajeó' a Haland con un repóker

Lo que debía ser un amistoso sin más historia se convirtió en una tarde bastante entretenida para el veterano Alexander Soderlung, quien firmó un repóker ante el Kolstad en pleno eco de la machada de Erling Haland.

Despeja un balón y acaba en tormenta eléctrica

El encuentro entre el Selbak Turn of IF y el Vestfossen de la Cuarta División de Noruega tuvo que ser suspendido algunos minutos debido a una tormenta eléctrica que se desató sobre el campo.




  USO DE MEMORIA  
5,092,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.2366
Total Execution Time  0.2386
  CADENA URL  
/Spjelkavik-Fk/2024
  GET DATOS  
$_GET['/Spjelkavik-Fk/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0253  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 = 74994
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=85799 AND type_rel = 2
0.0131  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 = '85799' 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 = 74994 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  (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 = 85799 or c.datateam2 = 85799) 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.0131  (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 = 85799 or c.datateam2 = 85799) 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.0128  (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 = 85799 or c.datateam2 = 85799) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0128  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 = 74994 WHERE rp.league_id = 74994 AND rp.teamId = 85799 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.0127  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 = 74994 WHERE rp.league_id = 74994 AND rp.teamId = 85799 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 74994 WHERE rp.league_id = 74994 AND rp.teamId = 85799 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30