4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1997
Temporada Siguiente »
Publicidad 600x120.gif
League Two 1997
1996/1997

League Two 1997

  • Fulham
  • Wigan Athletic
  • Carlisle United
  • Chester City FC
  • Swansea City
  • Colchester United
  • Cardiff City
  • Scarborough
  • Cambridge United
  • Lincoln City
  • Scunthorpe United
  • Northampton
  • Mansfield Town
  • Barnet
  • Leyton Orient
  • Doncaster Rovers
  • Hull City
  • Torquay United
  • Exeter City
  • Hereford United
  • Rochdale
  • Darlington FC
  • Brighton & Hove Albion
  • Hartlepool United
  • League Two

League Two 1997

La temporada finalizó el Sábado, 03 Mayo 1997.
Resultados
« Jornada Anterior
Jornada 38
Jornada Siguiente »
 
05 Abr 97
Finalizado 		Darlington FC Darlington FC 0-3 Doncaster Rovers Doncaster Rovers más información ...
 
05 Abr 97
Finalizado 		Scunthorpe United Scunthorpe United 1-0 Brighton & Hove Albion Brighton & Hove Albion más información ...
 
08 Abr 97
Finalizado 		Darlington FC Darlington FC 2-1 Carlisle United Carlisle United más información ...
 
08 Abr 97
Finalizado 		Wigan Athletic Wigan Athletic 1-0 Colchester United Colchester United más información ...
 
08 Abr 97
Finalizado 		Doncaster Rovers Doncaster Rovers 3-3 Cardiff City Cardiff City más información ...
 
08 Abr 97
Finalizado 		Barnet Barnet 1-1 Scunthorpe United Scunthorpe United más información ...
 
08 Abr 97
Finalizado 		Cambridge United Cambridge United 0-0 Northampton Northampton más información ...
 
08 Abr 97
Finalizado 		Mansfield Town Mansfield Town 0-0 Fulham Fulham más información ...
 
11 Abr 97
Finalizado 		Colchester United Colchester United 3-1 Swansea City Swansea City más información ...
 
11 Abr 97
Finalizado 		Mansfield Town Mansfield Town 0-0 Carlisle United Carlisle United más información ...
 
12 Abr 97
Finalizado 		Scunthorpe United Scunthorpe United 2-2 Hull City Hull City más información ...
 
12 Abr 97
Finalizado 		Fulham Fulham 0-1 Northampton Northampton más información ...
Clasificación
« Jornada Anterior
Jornada 38
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C.
1 Fulham Fulham 77 41 22 11 8 67 36
2 Wigan Athletic Wigan Athletic 75 40 22 9 9 72 46
3 Carlisle United Carlisle United 64 37 18 10 9 54 39
4 Chester City FC Chester City FC 61 39 15 16 8 46 35
5 Swansea City Swansea City 61 40 18 7 15 53 48
6 Colchester United Colchester 57 40 14 15 11 49 45
7 Cardiff City Cardiff City 57 37 17 6 14 48 46
8 Scarborough Scarborough 57 39 15 12 12 61 61
9 Cambridge United Cambridge United 57 38 16 9 13 47 48
10 Lincoln City Lincoln City 55 38 15 10 13 56 51
11 Scunthorpe United Scunthorpe 55 38 16 7 15 55 54
12 Northampton Northampton 54 37 15 9 13 51 36
13 Mansfield Town Mansfield Town 53 37 13 14 10 36 31
14 Barnet Barnet 49 38 12 13 13 38 39
15 Leyton Orient Leyton Orient 46 38 12 10 16 40 48
16 Doncaster Rovers Doncaster Rovers 45 36 12 9 15 45 52
17 Hull City Hull City 43 37 9 16 12 31 38
18 Torquay United Torquay United 42 39 11 9 19 37 50
19 Exeter City Exeter City 42 39 11 9 19 39 56
20 Hereford United Hereford United 41 38 10 11 17 43 55
21 Rochdale Rochdale 40 36 9 13 14 40 49
22 Darlington FC Darlington FC 40 37 10 10 17 50 65
23 Brighton & Hove Albion Brighton Hove A. 37 37 10 7 20 45 58
24 Hartlepool United Hartlepool 36 36 10 6 20 37 54
Playoff Ascenso: Fulham, Wigan Athletic, Carlisle United, Chester City FC
Descenso: Darlington FC, Brighton Hove A., Hartlepool

INFORMACIÓN

La Football League Two, o League Two (que por razones de patrocinio es llamada en el Reino Unido Coca-Cola Football League 2) es la tercera competición futbolística de la Football League, y la cuarta de la Liga inglesa de fútbol (abajo de la Football League One).

La Football League Two fue introducida para la temporada 2004-05, y reemplazó a la Football League Third Division.
TOP colaboradores para esta liga
Lorenzo
Lorenzo
1 pts
jose lopez
jose lopez
1 pts
vallejos
vallejos
1 pts
Más colaboradores en esta liga (8)
¿Quieres ser colaborador? haz click aquí

  USO DE MEMORIA  
5,577,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.3978
Total Execution Time  0.4006
  CADENA URL  
/league_two1997/grupo1/jornada38
  GET DATOS  
$_GET['/league_two1997/grupo1/jornada38']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88 AND type_rel = 3
0.0150  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 88 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (1304327,1303359,1298118,1278470,1274833) ORDER BY n.cover_points DESC, update_date DESC
0.0148  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=88 ORDER BY l.group_code ASC
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 17:13:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 17:13:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 17:13:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 17:13:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0154  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=502 AND rel.round=38
0.0177  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1997` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 502 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0168  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events1997 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1997 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 502 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (5185,5186,5187,5188,5189,5190,5191,5192,5193,5194,5195,5196) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0152  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1997` e INNER JOIN calendars1997 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 38 AND e.real_date IS NOT NULL AND e.league_id = 502 ORDER BY total DESC LIMIT 40
0.0160  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 502 AND t.round = 37 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0350  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 502 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0185  SELECT distinct(shedule), round FROM `calendars1997` as c WHERE c.`league_id` = 502 AND shedule >= '1997/04/01' AND shedule < '1997/05/01' ORDER BY shedule ASC
0.0147  SELECT data1, data2 FROM services_tags WHERE categoryId=88
0.0148  SELECT group_code, extraName from `leagues` WHERE categoryId=88 AND year=1997