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
  • Northampton
  • Gillingham
  • Bristol Rovers
  • Chesterfield
  • Blackpool
  • Wrexham AFC
  • Wigan Athletic
  • Oldham Athletic AFC
  • AFC Bournemouth
  • Wycombe Wanderers
  • York City
  • Walsall
  • Preston North End
  • Plymouth Argyle
  • Burnley
  • Brentford
  • Millwall
  • Carlisle United
  • Southend United
  • Luton Town
  • League One

League One 1998

La temporada finalizó el Lunes, 18 Mayo 1998.
 
21 Abr 98
Finalizado
Carlisle United Carlisle United 0-1 Grimsby Town Grimsby Town más información ...
 
24 Abr 98
Finalizado
Wigan Athletic Wigan Athletic 0-0 Millwall Millwall más información ...
 
25 Abr 98
Finalizado
Carlisle United Carlisle United 1-2 York City York City más información ...
 
25 Abr 98
Finalizado
AFC Bournemouth AFC Bournemouth 2-1 Burnley Burnley más información ...
 
25 Abr 98
Finalizado
Blackpool Blackpool 1-0 Bristol Rovers Bristol Rovers más información ...
 
25 Abr 98
Finalizado
Oldham Athletic AFC Oldham Athletic AFC 2-0 Southend United Southend United más información ...
 
25 Abr 98
Finalizado
Wrexham AFC Wrexham AFC 0-0 Preston North End Preston North End más información ...
 
25 Abr 98
Finalizado
Watford Watford 0-0 Grimsby Town Grimsby Town más información ...
 
28 Abr 98
Finalizado
Watford Watford 2-1 AFC Bournemouth AFC Bournemouth más información ...
 
28 Abr 98
Finalizado
Oldham Athletic AFC Oldham Athletic AFC 3-3 Burnley Burnley más información ...
 
02 May 98
Finalizado
Fulham Fulham 1-2 Watford Watford más información ...
 
02 May 98
Finalizado
Chesterfield Chesterfield 1-1 Blackpool Blackpool más información ...
Equipos Puntos J. G. E. P. F. C.
1 Watford Watford 86 43 24 14 5 66 38
2 Bristol City Bristol City 73 39 21 10 8 58 31
3 Grimsby Town Grimsby Town 68 41 18 14 9 51 29
4 Fulham Fulham 64 37 19 7 11 49 31
5 Northampton Northampton 60 40 15 15 10 46 34
6 Gillingham Gillingham 60 39 16 12 11 47 38
7 Bristol Rovers Bristol Rovers 58 39 17 7 15 55 50
8 Chesterfield Chesterfield 55 38 13 16 9 40 33
9 Blackpool Blackpool 55 42 15 10 17 53 62
10 Wrexham AFC Wrexham AFC 54 40 13 15 12 46 48
11 Wigan Athletic Wigan Athletic 52 41 14 10 17 57 63
12 Oldham Athletic AFC Oldham Athletic 50 40 12 14 14 49 46
13 AFC Bournemouth AFC Bournemouth 50 36 13 11 12 42 39
14 Wycombe Wanderers Wycombe 48 39 11 15 13 47 51
15 York City York City 48 37 11 15 11 42 46
16 Walsall Walsall 48 39 12 12 15 38 44
17 Preston North End Preston North 46 38 11 13 14 45 48
18 Plymouth Argyle Plymouth Argyle 46 41 11 13 17 51 61
19 Burnley Burnley 43 41 10 13 18 49 60
20 Brentford Brentford 43 38 10 13 15 40 59
21 Millwall Millwall 42 37 10 12 15 31 43
22 Carlisle United Carlisle United 41 39 11 8 20 52 58
23 Southend United Southend United 38 39 10 8 21 36 63
24 Luton Town Luton Town 31 33 6 13 14 38 53
Playoff Ascenso: Watford, Bristol City, Grimsby Town, Fulham
Descenso: Carlisle United, Southend United, 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,558,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.0662
Total Execution Time  0.0687
  CADENA URL  
/league_one1998/grupo1/jornada39
  GET DATOS  
$_GET['/league_one1998/grupo1/jornada39']  
  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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 07:34:15' 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 07:34:15' 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 07:34:15' 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 07:34:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  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=39
0.0023  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` = 39 ORDER BY shedule ASC LIMIT 200
0.0020  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 (5508,5509,5510,5511,5512,5513,5514,5515,5516,5517,5518,5519) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0020  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 = 39 AND e.real_date IS NOT NULL AND e.league_id = 486 ORDER BY total DESC LIMIT 40
0.0022  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 = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  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 = 39 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/04/01' AND shedule < '1998/05/01' ORDER BY shedule ASC
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=87
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=87 AND year=1998