4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Columbus Crew Columbus 28 44 43 38
2 New England Revolution England 28 49 49 38
3 Chicago Fire Chicago Fire 28 43 38 37
4 New York RB New York RB 28 41 47 35
5 DC United DC United 28 31 40 32
6 LA Galaxy LA Galaxy 28 44 33 51
7 San Jose Earthquakes Jose 28 45 35 45
8 FC Dallas FC Dallas 28 44 43 43
9 Colorado Rapids Colorado 28 43 48 43
10 Sporting Kansas City Sporting 28 37 45 36
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Miami Fusion Miami Fusion 26 57 36 53
2 New York RB New York RB 26 38 35 42
3 New England Revolution England 27 35 52 27
4 DC United DC United 26 42 50 26
5 Chicago Fire Chicago Fire 27 50 30 53
6 Columbus Crew Columbus 26 49 36 45
7 FC Dallas FC Dallas 26 48 47 35
8 Tampa Bay Mutiny Tampa Mutiny 27 32 68 14
9 LA Galaxy LA Galaxy 26 52 36 47
10 San Jose Earthquakes Jose 26 47 29 45
11 Sporting Kansas City Sporting 27 33 53 36
12 Colorado Rapids Colorado 26 36 47 23
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 New York RB New York RB 32 64 56 54
2 New England Revolution England 32 47 49 45
3 Miami Fusion Miami Fusion 32 54 56 41
4 DC United DC United 32 44 63 30
5 Chicago Fire Chicago Fire 32 67 51 57
6 Tampa Bay Mutiny Tampa Mutiny 32 62 50 52
7 FC Dallas FC Dallas 32 54 54 46
8 Columbus Crew Columbus 32 48 58 38
9 Sporting Kansas City Sporting 32 47 29 57
10 LA Galaxy LA Galaxy 32 47 37 50
11 Colorado Rapids Colorado 32 43 59 43
12 San Jose Earthquakes Jose 32 35 50 29
Ver
TEMPORADA 1998/1999
Equipo PJ GF GC Puntos
1 DC United DC United 32 65 43 60
2 LA Galaxy LA Galaxy 32 49 29 58
3 FC Dallas FC Dallas 32 54 35 57
4 Chicago Fire Chicago Fire 32 51 36 53
5 Colorado Rapids Colorado 32 38 39 51
6 Columbus Crew Columbus 32 48 39 49
7 San Jose Earthquakes Jose 32 48 49 40
8 Tampa Bay Mutiny Tampa Mutiny 32 51 50 39
9 New England Revolution England 32 38 53 33
10 Miami Fusion Miami Fusion 32 42 59 33
11 Sporting Kansas City Sporting 32 33 53 26
12 New York RB New York RB 32 32 64 20
Ver
TEMPORADA 1997/1998
Equipo PJ GF GC Puntos
1 LA Galaxy LA Galaxy 32 85 44 70
2 DC United DC United 32 74 48 61
3 Chicago Fire Chicago Fire 32 62 45 57
4 Columbus Crew Columbus 32 67 56 50
5 Colorado Rapids Colorado 32 62 69 46
6 New York RB New York RB 32 54 63 39
7 Tampa Bay Mutiny Tampa Mutiny 32 46 57 39
8 FC Dallas FC Dallas 32 43 59 39
9 San Jose Earthquakes Jose 32 48 60 38
10 Sporting Kansas City Sporting 32 45 50 36
11 Miami Fusion Miami Fusion 32 46 68 35
12 New England Revolution England 32 53 66 33
Ver
TEMPORADA 1996/1997
Equipo PJ GF GC Puntos
1 DC United DC United 32 70 53 59
2 Tampa Bay Mutiny Tampa Mutiny 32 55 60 47
3 Columbus Crew Columbus 32 42 41 43
4 New England Revolution England 32 40 53 41
5 New York RB New York RB 32 43 53 37
6 Sporting Kansas City Sporting 32 57 51 51
7 LA Galaxy LA Galaxy 32 55 44 48
8 FC Dallas FC Dallas 32 55 49 44
9 Colorado Rapids Colorado 32 50 59 41
10 San Jose Earthquakes Jose 32 55 59 36
Ver
TEMPORADA 1995/1996
Equipo PJ GF GC Puntos
1 Tampa Bay Mutiny Tampa Mutiny 32 66 51 61
2 DC United DC United 32 62 56 49
3 Columbus Crew Columbus 32 59 60 42
4 New York RB New York RB 32 45 47 41
5 New England Revolution England 32 43 56 35
6 LA Galaxy LA Galaxy 32 59 49 53
7 San Jose Earthquakes Jose 32 50 50 45
8 FC Dallas FC Dallas 32 50 48 44
9 Sporting Kansas City Sporting 32 61 63 43
10 Colorado Rapids Colorado 32 44 59 33

  USO DE MEMORIA  
5,390,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1445
Total Execution Time  0.1463
  CADENA URL  
/usa2002/grupo1/historico
  GET DATOS  
$_GET['/usa2002/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0020  SELECT type FROM routes WHERE alias = 'usa2002'
0.0047  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usa' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=69 ORDER BY order_id ASC
0.0025  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 13971 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 69 AND group_code = 1 and tables = 1 AND year <= 2002 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0032  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 `tables2002` 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 = 13971 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 13972 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 13973 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0087  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 = 20670 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 20709 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 23093 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 23095 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 03:18:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 03:18:45' 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-04-28 03:18:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 03:18:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0260  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 events2002 e ON e.player_id = p.id AND e.league_id = 13971 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13971 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.0189  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 events2002 e ON e.player_id = p.id AND e.league_id = 13971 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13971 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0066  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 events2002 e ON e.player_id = p.id AND e.league_id = 13971 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13971 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 13971 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC