4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 East Bengal Club East Bengal 22 30 9 46
2 Mohun Bagan SG Mohun Bagan 22 40 19 45
3 Churchill Brothers Churchill 22 32 25 36
4 FC Kochin FC Kochin 22 28 31 34
5 Vasco SC Vasco SC 22 13 17 27
6 Salgaocar Salgaocar 22 23 26 26
7 Mahindra United Mahindra 22 21 25 25
8 Tollygunge Tollygunge 22 14 18 24
9 JCT FC JCT FC 22 17 22 23
10 FC Indian Telephone Indian 22 15 19 22
11 Air India Air India 22 25 32 21
12 Travancore Travancore 22 24 39 20
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Mohun Bagan SG Mohun Bagan 22 36 17 47
2 Churchill Brothers Churchill 22 36 17 41
3 Salgaocar Salgaocar 22 26 15 39
4 FC Kochin FC Kochin 22 27 21 34
5 JCT FC JCT FC 22 20 18 34
6 Mahindra United Mahindra 22 26 16 33
7 East Bengal Club East Bengal 22 25 21 32
8 Tollygunge Tollygunge 22 18 27 26
9 Travancore Travancore 22 20 34 24
10 FC Indian Telephone Indian 22 18 27 18
11 Border Security Force Border 22 9 23 17
12 Dempo SC Dempo SC 22 9 34 11
Ver
TEMPORADA 1998/1999
Equipo PJ GF GC Puntos
1 East Bengal Club East Bengal 10 19 2 26
2 FC Kochin FC Kochin 10 19 12 17
3 Mohun Bagan SG Mohun Bagan 10 14 7 17
4 JCT FC JCT FC 10 12 8 17
5 Salgaocar Salgaocar 10 17 8 16
6 Churchill Brothers Churchill 10 15 10 14
7 Tollygunge Tollygunge 10 9 8 14
8 Mahindra United Mahindra 10 13 19 10
9 Dempo SC Dempo SC 10 6 11 9
10 FC Indian Telephone Indian 10 6 19 8
11 Air India Air India 10 5 17 7
12 FC Indian Bank Indian Bank 10 11 25 7
Ver
TEMPORADA 1997/1998
Equipo PJ GF GC Puntos
1 Mohun Bagan SG Mohun Bagan 18 20 10 34
2 East Bengal Club East Bengal 18 18 10 31
3 Salgaocar Salgaocar 18 19 13 30
4 FC Kochin FC Kochin 18 26 20 29
5 Air India Air India 18 18 16 26
6 Dempo SC Dempo SC 18 20 22 22
7 JCT FC JCT FC 18 19 15 21
8 FC Indian Bank Indian Bank 18 20 23 21
9 Churchill Brothers Churchill 18 20 26 19
10 Mahindra United Mahindra 18 5 30 5
Ver
TEMPORADA 1996/1997
Equipo PJ GF GC Puntos
1 JCT FC JCT FC 14 26 8 30
2 Churchill Brothers Churchill 14 20 10 29
3 East Bengal Club East Bengal 14 19 11 25
4 Dempo SC Dempo SC 14 19 17 18
5 Air India Air India 14 11 16 16
6 FC Indian Bank Indian Bank 14 14 18 15
7 Salgaocar Salgaocar 14 8 13 14
8 Mahindra United Mahindra 14 10 34 3

  USO DE MEMORIA  
5,082,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2811
Total Execution Time  0.2830
  CADENA URL  
/liga_india2001/grupo1/historico
  GET DATOS  
$_GET['/liga_india2001/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=56 ORDER BY order_id ASC
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 56 AND group_code = 1 and tables = 1 AND year <= 2001 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0129  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 `tables2001` 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 = 10428 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2000` 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 = 10429 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables1999` 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 = 22404 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 10430 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 10431 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 19:02:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 19:02:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 19:02:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 19:02:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2001 e ON e.player_id = p.id AND e.league_id = 10428 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10428 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2001 e ON e.player_id = p.id AND e.league_id = 10428 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10428 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2001 e ON e.player_id = p.id AND e.league_id = 10428 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10428 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 10428 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC