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

Histórico de participación

Partidos del Darwen FC

Ir al LIVESCORE
23 Abr 98  Finalizado Manchester United Manchester United
3 - 2
Darwen FC Darwen FC 0
11 Abr 98  Finalizado Luton Town Luton Town
3 - 0
Darwen FC Darwen FC 0
09 Abr 98  Finalizado Arsenal Arsenal
3 - 1
Darwen FC Darwen FC 0
08 Abr 98  Finalizado Blackpool Blackpool
1 - 0
Darwen FC Darwen FC 0
26 Mar 98  Finalizado Darwen FC Darwen FC
1 - 2
Burton Swifts Burton Swifts 0
19 Mar 98  Finalizado Darwen FC Darwen FC
2 - 3
Manchester United Manchester United 0
12 Mar 98  Finalizado Darwen FC Darwen FC
1 - 4
Arsenal Arsenal 0
05 Mar 98  Finalizado Darwen FC Darwen FC
1 - 3
Newcastle Newcastle 0
26 Feb 98  Finalizado Darwen FC Darwen FC
0 - 2
Luton Town Luton Town 0
19 Feb 98  Finalizado Burton Swifts Burton Swifts
2 - 0
Darwen FC Darwen FC 0
12 Feb 98  Finalizado Darwen FC Darwen FC
1 - 2
Walsall Walsall 0
05 Feb 98  Finalizado Leicester Leicester
0 - 1
Darwen FC Darwen FC 0
15 Ene 98  Finalizado Newcastle Newcastle
1 - 0
Darwen FC Darwen FC 0
08 Ene 98  Finalizado Loughborough Loughborough
0 - 1
Darwen FC Darwen FC 0
01 Ene 98  Finalizado Darwen FC Darwen FC
2 - 4
Gainsborough Trinity Gainsborough Trinity 0
25 Dic 97  Finalizado Birmingham City Birmingham City
5 - 1
Darwen FC Darwen FC 0
24 Dic 97  Finalizado Gainsborough Trinity Gainsborough Trinity
3 - 1
Darwen FC Darwen FC 0
18 Dic 97  Finalizado Darwen FC Darwen FC
1 - 2
Leicester Leicester 0
27 Nov 97  Finalizado Burnley Burnley
6 - 1
Darwen FC Darwen FC 0
23 Nov 97  Finalizado Manchester City Manchester City
5 - 0
Darwen FC Darwen FC 0
16 Nov 97  Finalizado Darwen FC Darwen FC
1 - 0
Grimsby Town Grimsby Town 0
13 Nov 97  Finalizado Darwen FC Darwen FC
3 - 1
Blackpool Blackpool 0
09 Nov 97  Finalizado Lincoln City Lincoln City
2 - 2
Darwen FC Darwen FC 0
06 Nov 97  Finalizado Darwen FC Darwen FC
0 - 1
Burnley Burnley 0
02 Nov 97  Finalizado Darwen FC Darwen FC
1 - 1
Birmingham City Birmingham City 0
27 Sep 97  Finalizado Walsall Walsall
5 - 0
Darwen FC Darwen FC 0
25 Sep 97  Finalizado Darwen FC Darwen FC
2 - 1
Loughborough Loughborough 0
18 Sep 97  Finalizado Darwen FC Darwen FC
3 - 2
Lincoln City Lincoln City 0
11 Sep 97  Finalizado Grimsby Town Grimsby Town
5 - 0
Darwen FC Darwen FC 0
04 Sep 97  Finalizado Darwen FC Darwen FC
2 - 4
Manchester City Manchester City 0

Noticias de Championship

Ver últimas noticias

Más cerca de la Premier

El Ipswich Town venció al Coventry City por 1-2 en la jornada 44 del Championship. Kieffer Moore y Cameron Burgess marcaron los goles que colocan al conjunto de Kieran McKenna con 2 puntos de margen sobre el Leeds United en la pelea por el ascenso directo a la Premier League.

Ha vuelto a ser el 'king'

El Leicester venció por 0-3 al Preston North End y confirmó de manera matemática el título de campeón del Championship 2023-24. Los dirigidos por Enzo Maresca, que ya habían certificado su ascenso a la Premier League, pusieron la guinda a una gran temporada.

La conexión Málaga-Mánchester que ha devuelto al Leicester a la Premier

Tras solo una temporada en el Championship, el Leicester City vuelve a ser de Premier League. El equipo de los ex malaguistas (y 'citizens') Enzo Maresca y Willy Caballero logró el ascenso matemático sin tener que jugar, ya que su perseguidor, el Leeds United, perdió con el QPR (4-0).

El Cardiff City pide 120 millones al Nantes por Sala... ¡por una IA!

El Cardiff City ha demandado al Nantes por daños y perjuicios por el fallecimiento de Emiliano Sala. Pide 120 millones de euros por los goles que habría marcado el argentino de no haber fallecido.

Así seguimos el directo del Leicester - Southampton

Vive con nosotros el apasionante Leicester-Southampton, partido clave en la lucha por el ascenso desde el Championship a la Premier League.




  USO DE MEMORIA  
4,913,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3103
Total Execution Time  0.3123
  CADENA URL  
/Darwen-Fc/1898
  GET DATOS  
$_GET['/Darwen-Fc/1898']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0145  SELECT type FROM routes WHERE alias = 'darwen-fc'
0.0291  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 = 25393
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30919 AND type_rel = 2
0.0146  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 = '30919' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = '30919' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 25393 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  (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 calendars1898 as c ON c.league_id = l.id WHERE (c.datateam1 = 30919 or c.datateam2 = 30919) AND l.year = 1898 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0154  (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 calendars1898 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 = 30919 or c.datateam2 = 30919) AND l.year = 1898 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0147  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1898 as c ON c.league_id = l.id INNER JOIN events1898 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 = 30919 or c.datateam2 = 30919) AND l.year = 1898)
0.0146  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=30919 AND l.year in (1897,1898,1899) ORDER BY l.id DESC, l.year DESC ;
0.0144  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 (25394) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 25394 AND teamId = 30919
0.0145  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 = 30919 AND rp.league_id = 25393 AND l.year= 1898 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1