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

Wigan Athletic

Entrenador: Shaun Maloney

Temporada 1995/1996
TEMPORADA 1995/1996
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Preston North End Preston 43 75 31 85
2 Gillingham Gillingham 43 45 19 76
3 Plymouth Argyle Plymouth 44 64 45 75
4 Darlington FC Darlington 44 59 41 75
5 Bury Bury 42 61 43 74
6 Colchester United Colchester 43 56 46 68
7 Barnet Barnet 43 60 39 66
8 Hereford United Hereford 39 53 37 65
9 Wigan Athletic Wigan 42 57 52 63
10 Chester City FC Chester City 41 59 50 59
11 Scunthorpe United Scunthorpe 40 63 50 58
12 Northampton Northampton 39 39 42 52
13 Doncaster Rovers Doncaster 40 40 53 48
14 Mansfield Town Mansfield 40 47 55 47
15 Exeter City Exeter City 41 42 51 47
16 Lincoln City Lincoln City 42 50 63 47
17 Hartlepool United Hartlepool 42 45 60 47
18 Rochdale Rochdale 41 49 55 46
19 Cambridge United Cambridge 39 48 55 46
20 Fulham Fulham 42 47 58 46
21 Cardiff City Cardiff City 41 35 48 44
22 Scarborough Scarborough 43 37 63 39
23 Leyton Orient Leyton 40 34 57 37
24 Torquay United Torquay 44 29 81 29
TEMPORADA 1994/1995
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Walsall Walsall 32 61 29 69
2 Carlisle United Carlisle 32 50 22 66
3 Chesterfield Chesterfield 32 51 27 65
4 Mansfield Town Mansfield 33 74 49 54
5 Bury Bury 31 54 35 54
6 Preston North End Preston 32 44 30 53
7 Fulham Fulham 32 51 41 52
8 Wigan Athletic Wigan 32 45 40 48
9 Scunthorpe United Scunthorpe 32 51 50 46
10 Doncaster Rovers Doncaster 32 48 38 43
11 Lincoln City Lincoln City 32 41 42 43
12 Colchester United Colchester 32 43 48 42
13 Torquay United Torquay 32 38 43 40
14 Hereford United Hereford 31 34 45 39
15 Barnet Barnet 31 39 53 35
16 Hartlepool United Hartlepool 32 38 57 35
17 Northampton Northampton 32 35 55 35
18 Gillingham Gillingham 32 36 47 33
19 Rochdale Rochdale 32 26 50 31
20 Darlington FC Darlington 31 31 44 27
21 Scarborough Scarborough 32 39 55 24
22 Exeter City Exeter City 31 28 57 20
TEMPORADA 1993/1994
LEAGUE TWO
Equipo PJ GF GC Puntos
1 Shrewsbury Town Shrewsbury 37 59 36 71
2 Crewe Alexandra Crewe 40 76 59 67
3 Preston North End Preston 39 73 54 64
4 Chester Chester 37 61 41 63
5 Torquay United Torquay 40 63 56 63
6 Wycombe Wanderers Wycombe 39 60 50 61
7 Carlisle United Carlisle 39 51 39 58
8 Rochdale Rochdale 41 61 51 57
9 Walsall Walsall 39 47 47 57
10 Chesterfield Chesterfield 37 49 41 53
11 Bury Bury 40 53 53 52
12 Scarborough Scarborough 39 53 58 50
13 Mansfield Town Mansfield 39 49 59 49
14 Doncaster Rovers Doncaster 40 40 54 49
15 Scunthorpe United Scunthorpe 33 50 45 46
16 Colchester United Colchester 39 54 65 46
17 Gillingham Gillingham 37 36 44 44
18 Lincoln City Lincoln City 39 48 59 44
19 Darlington FC Darlington 39 40 56 41
20 Wigan Athletic Wigan 39 47 67 41
21 Hereford United Hereford 38 56 73 39
22 Northampton Northampton 36 40 59 34

  USO DE MEMORIA  
5,750,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5537
Total Execution Time  0.5549
  CADENA URL  
/historico/Wigan-Athletic/1996
  GET DATOS  
$_GET['/historico/Wigan-Athletic/1996']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0152  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 = 'Wigan-Athletic' AND l.year = 1996 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.0127  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=2753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=2753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=2753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=2753 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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 = 503
0.0129  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 = 14537
0.0130  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 = 23240
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2753 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2753 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  SELECT /*35 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 (718,982,1146,2958,3394) ORDER BY n.cover_points DESC, update_date DESC
0.0140  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 = '2753' AND l.year = 1996 ORDER BY l.year DESC,cat.coefficient DESC
0.0155  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 = '2753' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0140  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 = 23240 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  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 = 503 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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 = 14537 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0180  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=2753 AND l.year in (1995,1996,1997) ORDER BY l.id DESC, l.year DESC ;
0.0135  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 (23242,14538,504) 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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 504 AND teamId = 2753
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 14538 AND teamId = 2753
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 23242 AND teamId = 2753
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1996` 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 = 503 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0138  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2753' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2753' and rp.type = 4
0.0142  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2753' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0131  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2753' and rp.type = 4
0.0135  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 events1996 e ON e.player_id = p.id AND e.league_id = 503 WHERE rp.league_id = 503 AND rp.teamId = 2753 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.0135  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 events1996 e ON e.player_id = p.id AND e.league_id = 503 WHERE rp.league_id = 503 AND rp.teamId = 2753 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 events1996 e ON e.player_id = p.id AND e.league_id = 503 WHERE rp.league_id = 503 AND rp.teamId = 2753 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0168  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 2753 AND l.year <= 1996 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0136  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 `tables1996` 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 = 503 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 `tables1995` 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 = 504 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables1994` 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 = 505 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC