4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
League One 1998
  • Watford
  • Bristol City
  • Grimsby Town
  • Fulham
  • Gillingham
  • Northampton
  • Bristol Rovers
  • Oldham Athletic AFC
  • Wrexham AFC
  • Blackpool
  • Chesterfield
  • Wycombe Wanderers
  • AFC Bournemouth
  • Plymouth Argyle
  • Millwall
  • Walsall
  • York City
  • Southend United
  • Carlisle United
  • Burnley
  • Wigan Athletic
  • Preston North End
  • Brentford
  • Luton Town
  • League One

League One 1998

La temporada finalizó el Lunes, 18 Mayo 1998.
 
24 Feb 98
Finalizado
Southend United Southend United 3-0 Plymouth Argyle Plymouth Argyle más información ...
 
24 Feb 98
Finalizado
Luton Town Luton Town 1-1 Wigan Athletic Wigan Athletic más información ...
 
24 Feb 98
Finalizado
York City York City 0-1 Bristol City Bristol City más información ...
 
24 Feb 98
Finalizado
Walsall Walsall 0-0 Brentford Brentford más información ...
 
24 Feb 98
Finalizado
Gillingham Gillingham 1-0 Northampton Northampton más información ...
 
24 Feb 98
Finalizado
Grimsby Town Grimsby Town 1-0 Blackpool Blackpool más información ...
 
24 Feb 98
Finalizado
Bristol Rovers Bristol Rovers 3-1 Wycombe Wanderers Wycombe Wanderers más información ...
 
24 Feb 98
Finalizado
Preston North End Preston North End 0-3 Carlisle United Carlisle United más información ...
 
24 Feb 98
Finalizado
Chesterfield Chesterfield 2-1 Oldham Athletic AFC Oldham Athletic AFC más información ...
 
25 Feb 98
Finalizado
Millwall Millwall 1-1 Watford Watford más información ...
 
28 Feb 98
Finalizado
Watford Watford 3-2 Bristol Rovers Bristol Rovers más información ...
 
28 Feb 98
Finalizado
Bristol City Bristol City 1-0 Southend United Southend United más información ...
Equipos Puntos J. G. E. P. F. C.
1 Watford Watford 69 32 20 9 3 51 25
2 Bristol City Bristol City 62 32 18 8 6 49 24
3 Grimsby Town Grimsby Town 50 27 14 8 5 39 19
4 Fulham Fulham 48 28 14 6 8 38 23
5 Gillingham Gillingham 48 30 13 9 8 40 32
6 Northampton Northampton 45 31 11 12 8 33 26
7 Bristol Rovers Bristol Rovers 45 29 13 6 10 42 39
8 Oldham Athletic AFC Oldham Athletic 41 29 10 11 8 36 30
9 Wrexham AFC Wrexham AFC 40 29 10 10 9 35 37
10 Blackpool Blackpool 39 31 11 6 14 39 47
11 Chesterfield Chesterfield 38 29 8 14 7 29 26
12 Wycombe Wanderers Wycombe 38 31 9 11 11 39 45
13 AFC Bournemouth AFC Bournemouth 36 27 9 9 9 31 29
14 Plymouth Argyle Plymouth Argyle 35 31 8 11 12 38 43
15 Millwall Millwall 35 28 9 8 11 27 34
16 Walsall Walsall 33 26 8 9 9 28 30
17 York City York City 33 26 7 12 7 28 30
18 Southend United Southend United 33 31 9 6 16 32 53
19 Carlisle United Carlisle United 31 29 8 7 14 40 44
20 Burnley Burnley 31 31 7 10 14 36 43
21 Wigan Athletic Wigan Athletic 31 29 8 7 14 39 48
22 Preston North End Preston North 30 28 7 9 12 32 36
23 Brentford Brentford 28 28 6 10 12 26 44
24 Luton Town Luton Town 16 24 2 10 12 25 45
Playoff Ascenso: Watford, Bristol City, Grimsby Town, Fulham
Descenso: Preston North, Brentford, Luton Town

La Football League One, o League One (que por razones de patrocinio es llamada en el Reino Unido Coca-Cola Football League 1) es la segunda competición futbolística de la Football League, y la tercera del Sistema de ligas de fútbol de Inglaterra (abajo de la Football League Championship).

TOP colaboradores para esta liga
¿Quieres ser colaborador? haz click aquí

  USO DE MEMORIA  
5,557,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0723
Total Execution Time  0.0742
  CADENA URL  
/league_one1998/grupo1/jornada29
  GET DATOS  
$_GET['/league_one1998/grupo1/jornada29']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0021  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=87 ORDER BY l.group_code ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 04:48:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 04:48:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 04:48:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 04:48:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  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=486 AND rel.round=29
0.0026  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 `calendars1998` 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` = 486 AND c.`round` = 29 ORDER BY shedule ASC LIMIT 200
0.0023  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 events1998 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1998 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 486 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 (5388,5389,5390,5391,5392,5393,5394,5395,5396,5397,5398,5399) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0023  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 `events1998` e INNER JOIN calendars1998 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 = 29 AND e.real_date IS NOT NULL AND e.league_id = 486 ORDER BY total DESC LIMIT 40
0.0028  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 `tables1998` 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 = 486 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0055  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 486 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT distinct(shedule), round FROM `calendars1998` as c WHERE c.`league_id` = 486 AND shedule >= '1998/02/01' AND shedule < '1998/03/01' ORDER BY shedule ASC
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=87
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=87 AND year=1998