4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Carlisle United

Carlisle United

Entrenador: Paul Simpson

Información
Otros Datos
  • Año de Fundación 1903
Internet

Información sobre el estadio

  • Nombre del estadio Brunton Park
  • Capacidad 16981
  • Dirección Warwick Road
  • Año de construcción 1909
  • Tamaño 112 x 74 yardas
Brunton Park

Partidos del Carlisle United

Ir al LIVESCORE
01 May 71  Finalizado Carlisle United
3 - 0
Sheffield Wednesday 0
28 Abr 71  Finalizado Hull City
1 - 2
Carlisle United 0
24 Abr 71  Finalizado Swindon Town
0 - 0
Carlisle United 0
17 Abr 71  Finalizado Carlisle United
4 - 2
Norwich City 0
13 Abr 71  Finalizado Carlisle United
2 - 1
Watford 0
10 Abr 71  Finalizado Bolton Wanderers
0 - 3
Carlisle United 0
05 Abr 71  Finalizado Millwall
2 - 1
Carlisle United 0
03 Abr 71  Finalizado Carlisle United
0 - 1
Leicester 0
27 Mar 71  Finalizado Leyton Orient
1 - 1
Carlisle United 0
20 Mar 71  Finalizado Oxford United
1 - 1
Carlisle United 0
13 Mar 71  Finalizado Carlisle United
1 - 0
Luton Town 0
06 Mar 71  Finalizado Cardiff City
4 - 0
Carlisle United 0
27 Feb 71  Finalizado Carlisle United
1 - 0
Sheffield United 0
20 Feb 71  Finalizado Blackburn Rovers
0 - 2
Carlisle United 0
13 Feb 71  Finalizado Carlisle United
3 - 0
Queens Park Rangers 0
06 Feb 71  Finalizado Portsmouth
1 - 4
Carlisle United 0
30 Ene 71  Finalizado Carlisle United
2 - 1
Bristol City 0
16 Ene 71  Finalizado Sunderland
2 - 0
Carlisle United 0
09 Ene 71  Finalizado Carlisle United
1 - 1
Charlton Athletic 0
26 Dic 70  Finalizado Carlisle United
1 - 0
Bolton Wanderers 0
19 Dic 70  Finalizado Birmingham City
1 - 0
Carlisle United 0
12 Dic 70  Finalizado Queens Park Rangers
1 - 1
Carlisle United 0
05 Dic 70  Finalizado Carlisle United
6 - 0
Portsmouth 0
28 Nov 70  Finalizado Bristol City
2 - 1
Carlisle United 0
21 Nov 70  Finalizado Carlisle United
1 - 0
Blackburn Rovers 0
14 Nov 70  Finalizado Luton Town
3 - 3
Carlisle United 0
07 Nov 70  Finalizado Carlisle United
3 - 2
Oxford United 0
31 Oct 70  Finalizado Sheffield United
2 - 2
Carlisle United 0
24 Oct 70  Finalizado Carlisle United
1 - 1
Cardiff City 0
20 Oct 70  Finalizado Carlisle United
0 - 0
Sunderland 0
17 Oct 70  Finalizado Carlisle United
1 - 0
Middlesbrough 0
10 Oct 70  Finalizado Norwich City
1 - 1
Carlisle United 0
02 Oct 70  Finalizado Carlisle United
3 - 0
Millwall 0
29 Sep 70  Finalizado Charlton Athletic
1 - 1
Carlisle United 0
26 Sep 70  Finalizado Sheffield Wednesday
3 - 0
Carlisle United 0
19 Sep 70  Finalizado Carlisle United
2 - 1
Swindon Town 0
12 Sep 70  Finalizado Watford
0 - 0
Carlisle United 0
05 Sep 70  Finalizado Carlisle United
2 - 0
Leyton Orient 0
01 Sep 70  Finalizado Carlisle United
2 - 0
Hull City 0
29 Ago 70  Finalizado Leicester
2 - 2
Carlisle United 0
22 Ago 70  Finalizado Carlisle United
0 - 3
Birmingham City 0
15 Ago 70  Finalizado Middlesbrough
2 - 1
Carlisle United 0

Noticias del Carlisle United

Ver últimas noticias

Derek Asamoah regresa al Carlisle United

El delantero ghanés Derek Asamoah ha vuelto a formar parte de la primera plantilla del Carlisle United tras el comunicado emitido por parte del club.

Martin Smith llega cedido al Carlisle United

Martin Smith, centrocampista del Sunderland U21, ha confirmado que abandona temporalmente su club para llegar como cedido al Carlisle United.

Keith Curle renueva como técnico del Carlisle United

Keith Curle continuará en el club hasta junio de 2018. El entrenador inglés cuenta con la confianza de los dirigentes de los 'blues', incluido el presidente de la entidad, Andrew Jenkins.

Un cuarta división fuerza al Liverpool a llegar a los penaltis

El Liverpool estuvo a punto de caer con estrépito ante el humilde Carlisle United, que milita en la League Two, el cuarto nivel de Inglaterra. Sólo mediante los penaltis los de Rodgers sellaron su pase.

El Liverpool, a lavar su imagen ante el humilde Carlisle

El Liverpool recibe en Anfield al Carlisle United en la tercera ronda de la Capital One Cup. Los de Brendan Rodgers llevan cinco partidos sin conocer la victoria por lo que no pueden permitirse un nuevo tropiezo.




  USO DE MEMORIA  
5,236,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4425
Total Execution Time  0.4446
  CADENA URL  
/Carlisle-United/1971
  GET DATOS  
$_GET['/Carlisle-United/1971']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0179  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 = 'Carlisle-United' AND l.year = 1971 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=9193 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=9193 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0155  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '9193' AND l.year = 1971 ORDER BY l.year DESC,cat.coefficient 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 = '9193' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0192  (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 calendars1971 as c ON c.league_id = l.id WHERE (c.datateam1 = 9193 or c.datateam2 = 9193) AND l.year = 1971 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0201  (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 calendars1971 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 = 9193 or c.datateam2 = 9193) AND l.year = 1971 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0381  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1971 as c ON c.league_id = l.id INNER JOIN events1971 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 = 9193 or c.datateam2 = 9193) AND l.year = 1971)
0.0186  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=9193 AND l.year in (1970,1971,1972) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (23315,23205,14754) 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 = 23315 AND teamId = 9193
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 14754 AND teamId = 9193
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 23205 AND teamId = 9193
0.0157  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 events1971 e ON e.player_id = p.id AND e.league_id = 23314 WHERE rp.league_id = 23314 AND rp.teamId = 9193 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.0154  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 events1971 e ON e.player_id = p.id AND e.league_id = 23314 WHERE rp.league_id = 23314 AND rp.teamId = 9193 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 events1971 e ON e.player_id = p.id AND e.league_id = 23314 WHERE rp.league_id = 23314 AND rp.teamId = 9193 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 9193 AND rp.league_id = 23314 AND l.year= 1971 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1