4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información
  • Nombre del equipo Nykøbing FC
  • Nombre completo Nykøbing FC
  • Nombre corto LFA
  • País Dinamarca
  • Ciudad Nykøbing
  • URL del equipo en RF //m.resultados-futbol.com/Lfa
Otros Datos
  • Año de Fundación 1994
Internet

Información sobre el estadio

  • Nombre del estadio Scandic Live Arena
  • Capacidad 10000
  • Dirección Poul Martin Møllersvej 6 A 4800 Nykøbing Falster
  • Teléfono +45 5482 1994
  • Fax +45 5482 1995
Scandic Live Arena

Partidos del Nykøbing FC

Ir al LIVESCORE
03 Mar 24  Finalizado Nykøbing FC
1 - 1
Fremad Amager 0
22 Feb 24  Finalizado Brønshøj
2 - 2
Nykøbing FC 7
27 Ene 24  Finalizado Næstved
0 - 1
Nykøbing FC 0
20 Ene 24  Finalizado HB Køge
1 - 1
Nykøbing FC 1
13 Ene 24  Finalizado Nykøbing FC
1 - 5
Hvidovre IF 1
15 Jun 24  en 1 mes Esbjerg
14:00
Nykøbing FC 0
09 Jun 24  en 1 mes Nykøbing FC
15:00
Middelfart 0
31 May 24  en 1 mes Roskilde
19:00
Nykøbing FC 0
25 May 24  en 1 mes Nykøbing FC
15:00
Aarhus Fremad 0
17 May 24  en 1 mes Akademisk Boldklub
19:00
Nykøbing FC 0
11 May 24  en 24 días Middelfart
14:00
Nykøbing FC 0
03 May 24  en 17 días Nykøbing FC
19:00
Esbjerg 0
26 Abr 24  en 10 días Nykøbing FC
19:00
Akademisk Boldklub 0
20 Abr 24  en 3 días Aarhus Fremad
14:00
Nykøbing FC 0
12 Abr 24  Finalizado Nykøbing FC
0 - 5
Roskilde 0
06 Abr 24  Finalizado Aarhus Fremad
5 - 0
Nykøbing FC 0
01 Abr 24  Finalizado Nykøbing FC
1 - 0
FA 2000 0
28 Mar 24  Finalizado Akademisk Boldklub
2 - 3
Nykøbing FC 0
23 Mar 24  Finalizado Roskilde
3 - 0
Nykøbing FC 0
16 Mar 24  Finalizado Nykøbing FC
2 - 3
Skive 0
09 Mar 24  Finalizado Tarjeta RojaNykøbing FC
1 - 0
Hellerup IKTarjeta Roja 0

Noticias de Segunda Dinamarca

Ver últimas noticias

Increíble, pero cierto: ¡se retiró un jugador con 20 años!

Alexander Hjaelmhof, con apenas 20 años, ha decidido poner punto y final a su carrera deportiva "al perder la pasión por el fútbol". 'Ekstra Bladet' apunta que el ya ex futbolista trabajará en una Escuela de Negocios de Copenhague.

El arrepentimiento más sincero de un árbitro: su reacción no tiene precio

Los árbitros son humanos y también se equivocan. Algunos lo reconocen y otros como Nils Heer piden perdón incluso de rodillas por sus fallos. Ocurrió en un partido de Primera de Dinamarca y su reacción se hizo viral.

Chequia, Dinamarca, Rumanía, Suiza y Lituania también paran

Ante la crisis provocada por el COVID-19, el fútbol también se ha visto paralizado en la República Checa, Dinamarca, Rumanía, Suiza y Lituania.

El golazo de falta de un portero que se vio en Tercera de Dinamarca

Oliver Børner se convirtió en uno de los futbolistas del fútbol danés. El cancerbero del AB Copenhagen marcó un golazo de falta que no le sirvió para conseguir un punto ante el Veljby en la Tercera División de Dinamarca.




  USO DE MEMORIA  
5,074,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3611
Total Execution Time  0.3629
  CADENA URL  
/lfa
  GET DATOS  
$_GET['/lfa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7437 AND type_rel = 2
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=234 AND type_rel = 3
0.0119  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 234 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0120  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1082955,1034242,808298,717751) ORDER BY n.cover_points DESC, update_date DESC
0.0159  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 = '7437' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0117  (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 = 7437 or c.datateam2 = 7437) 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.0112  (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 = 7437 or c.datateam2 = 7437) 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.0109  (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 = 7437 or c.datateam2 = 7437) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0113  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=7437 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0110  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 (75799,72646,71432,71292) 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.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 71292 AND teamId = 7437
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 75799 AND teamId = 7437
0.0121  SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 7437
0.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7437
0.0117  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 = 75799 WHERE rp.league_id = 75799 AND rp.teamId = 7437 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.0117  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 = 75799 WHERE rp.league_id = 75799 AND rp.teamId = 7437 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120  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 = 75799 WHERE rp.league_id = 75799 AND rp.teamId = 7437 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118  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 = 7437 AND rp.league_id = 75799 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0114  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 = 7437 AND rp.league_id = 75799 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1