4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Degerfors IF

Enviar Datos
Información
Otros Datos
  • Año de Fundación 1907
  • Marca de Ropa Umbro
Internet

Información sobre el estadio

  • Nombre del estadio Stora Valla
  • Capacidad 12500
  • Dirección Stora Vallavägen 1
Stora Valla

Partidos del Degerfors IF

Ir al LIVESCORE
Partidos Amistosos Partidos Amistosos »
16 Abr 24  Finalizado Degerfors IF Degerfors IF
0 - 1
 Västerås SK Västerås SKTarjeta RojaTarjeta Roja 1
23 Mar 24  Finalizado Degerfors IF Degerfors IF
3 - 0
 IF Karlstad IF Karlstad 1
10 Feb 24  Finalizado Degerfors IF Degerfors IF
5 - 0
 Örebro Syrianska Örebro Syrianska 0
03 Feb 24  Finalizado Degerfors IF Degerfors IF
0 - 0
 Skovde AIK Skovde AIK 0
27 Ene 24  Finalizado IK Sirius IK Sirius
1 - 1
 Degerfors IF Degerfors IF 0
Copa Suecia Copa Suecia »
10 Mar 24  Finalizado Djurgårdens IF Djurgårdens IF
3 - 0
 Degerfors IF Degerfors IF 12
03 Mar 24  Finalizado IF Elfsborg IF Elfsborg
2 - 2
 Degerfors IF Degerfors IFTarjeta Roja 11
24 Feb 24  Finalizado Degerfors IF Degerfors IF
2 - 2
 GAIS GAIS 0
18 Feb 24  Finalizado Degerfors IF Degerfors IF
5 - 0
 Örgryte Örgryte 1
Segunda Suecia Segunda Suecia »
31 Ago 24  en 3 meses Degerfors IF Degerfors IF
19:00
 Östersunds FK Östersunds FK 0
24 Ago 24  en 3 meses Örgryte Örgryte
19:00
 Degerfors IF Degerfors IF 0
17 Ago 24  en 3 meses Degerfors IF Degerfors IF
19:00
 IK Brage IK Brage 0
10 Ago 24  en 3 meses Helsingborgs IF Helsingborgs IF
19:00
 Degerfors IF Degerfors IF 0
03 Ago 24  en 3 meses Degerfors IF Degerfors IF
19:00
 IK Oddevold IK Oddevold 0
27 Jul 24  en 2 meses Degerfors IF Degerfors IF
19:00
 Skovde AIK Skovde AIK 0
21 Jul 24  en 2 meses Östersunds FK Östersunds FK
13:00
 Degerfors IF Degerfors IF 0
29 Jun 24  en 1 mes Degerfors IF Degerfors IF
15:00
 Sandvikens IF Sandvikens IF 1
23 Jun 24  en 1 mes IK Oddevold IK Oddevold
15:00
 Degerfors IF Degerfors IF 1
15 Jun 24  en 1 mes Skovde AIK Skovde AIK
15:00
 Degerfors IF Degerfors IF 1
01 Jun 24  en 28 días Degerfors IF Degerfors IF
13:00
 Utsiktens BK Utsiktens BK 1
28 May 24  en 24 días Degerfors IF Degerfors IF
19:00
 Varbergs BoIS Varbergs BoIS 1
23 May 24  en 19 días IK Brage IK Brage
19:00
 Degerfors IF Degerfors IF 1
18 May 24  en 14 días Degerfors IF Degerfors IF
15:00
 Örgryte Örgryte 0
14 May 24  en 10 días Orebro SK Orebro SK
19:00
 Degerfors IF Degerfors IF 1
04 May 24  en 17 h Degerfors IF Degerfors IF
15:00
 Landskrona BoIS Landskrona BoIS 0
29 Abr 24  Finalizado Trelleborgs FF Trelleborgs FF
1 - 1
 Degerfors IF Degerfors IF 3
23 Abr 24  Finalizado Degerfors IF Degerfors IF
2 - 1
 Helsingborgs IF Helsingborgs IF 6
15 Abr 24  Finalizado Gefle Gefle
2 - 2
 Degerfors IF Degerfors IF 2
06 Abr 24  Finalizado Degerfors IF Degerfors IF
2 - 0
 GIF Sundsvall GIF SundsvallTarjeta Roja 0
02 Abr 24  Finalizado Osters IF Osters IF
1 - 1
 Degerfors IF Degerfors IF 17

Plantilla del Degerfors IF Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
26 20 se - - - - -
25 22 se - - - - -
1 22 se 189 88 - - 1
Defensa
3 27 se 180 - 1 - 2
23 20 se 187 - - - -
30 26 pt 187 - - - 1
20 26 se 180 - - - 1
2 27 gn 175 - - - 2
15 27 gh 190 80 - - 2
6 22 se - - - - -
7 31 se 186 73 - - 2
Centrocampista
16 21 se 184 - - - 1
24 18 se - - - - -
21 17 se - - - - -
4 35 se 183 72 - - -
8 22 se - - - - -
16 17 se - - - - -
17 29 no 179 74 - - -
18 22 se - - - - -
Delantero
11 20 se 195 - - - -
10 28 se 183 73 - - 1
9 22 se - - 2 - 1
19 20 se 176 60 - - -
13 29 iq 184 - 5 - -

Noticias del Degerfors IF

Ver últimas noticias

Surrealista: le lesiona un compañero... ¡en plena sustitución!

BeSoccer - Viernes, 19 Abril 2019
0 1.154

Ocurrió en el partido entre Degerfors y Oste de la Segunda División Sueca. Sale del campo Axel Lindahl y entra Mattias Ozgun, que al poner los dos pies sobre el terreno de juego nota que algo va mal y pide al árbitro parar el encuentro.

Ver más noticias del equipo»



  USO DE MEMORIA  
5,607,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.4412
Total Execution Time  0.4434
  CADENA URL  
/Degerfors/2021?section=legal
  GET DATOS  
$_GET['/Degerfors/2021']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0144  SELECT type FROM routes WHERE alias = 'degerfors'
0.0168  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 = 'Degerfors' 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.0145  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0153  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 = '12823' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  (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 = 12823 or c.datateam2 = 12823) 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.0153  (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 = 12823 or c.datateam2 = 12823) 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.0148  (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 = 12823 or c.datateam2 = 12823) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0150  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 = 12823 AND rp.league_id = 74951 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0152  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=6624762 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0148  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6624762
0.0172  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=6624762 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.0163  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=6624762 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0148  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=6624762 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0147   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=6624762 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0150  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=6624762 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC