4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Rochester New York Rochester 28 40 15 61
2 Louisville City Louisville 28 55 34 48
3 Charleston Battery Charleston 28 43 28 46
4 New York RB II York 28 46 45 42
5 Pittsburgh Riverhounds Pittsburgh 28 53 42 41
6 Richmond Kickers Richmond 28 41 35 41
7 Charlotte Independence Charlotte 28 38 35 40
8 Penn FC Penn FC 28 49 53 39
9 Saint Louis Saint Louis 28 30 40 33
10 FC Montreal FC Montreal 28 32 46 28
11 Toronto II Toronto II 28 26 52 23
12 Wilmington Hammerheads Wilmington 28 22 42 19
13 Colorado Springs Switchback Colorado 29 56 36 49
14 LA Galaxy II Galaxy 28 40 30 48
15 OKC Energy OKC Energy 28 44 36 47
16 Sacramento Republic Sacramento 28 43 31 46
17 Orange County SC Orange 28 37 35 44
18 Seattle Sounders II Seattle 28 45 42 42
19 FC Tulsa FC Tulsa 28 49 46 39
20 Portland Timbers II Portland 29 39 48 35
21 Austin Aztex Austin Aztex 28 32 41 33
22 Phoenix Rising Phoenix 28 31 55 32
23 Vancouver Whitecaps II Vancouver 28 39 53 30
24 Real Monarchs Real 28 32 42 29
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 LA Galaxy II Galaxy 2 4 2 4
2 Charleston Battery Charleston 2 3 3 2
3 Orlando City Orlando City 2 2 2 2
4 Richmond Kickers Richmond 1 2 2 1
5 Pittsburgh Riverhounds Pittsburgh 1 1 1 1
6 Sacramento Republic Sacramento 1 1 1 1
7 Charlotte Eagles Charlotte 0 0 0 0
8 OKC Energy OKC Energy 0 0 0 0
9 Penn FC Penn FC 0 0 0 0
10 Phoenix Rising Phoenix 0 0 0 0
11 Rochester New York Rochester 0 0 0 0
12 Wilmington Hammerheads Wilmington 0 0 0 0
13 Orange County SC Orange 1 1 3 0
14 Dayton Dutch Lions Dayton Dutch 1 0 3 0
15 FC Dallas Reservas Dallas 2 4 0 6
16 New York RB Reservas York 2 4 2 3
17 Chicago Fire Reservas Chicago Fire 1 2 1 3
18 Montreal Impact II Montreal 1 0 2 0
19 Colorado Rapid Reservas Colorado 0 0 0 0
20 Real Salt Lake Reservas Real Salt L. 0 0 0 0
21 Seattle Sounders II Seattle 0 0 0 0
22 Chivas USA Reservas Chivas 1 0 2 0
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Richmond Kickers Richmond 24 48 22 51
2 Orlando City II Orlando City 24 50 26 48
3 Penn FC Penn FC 24 52 35 41
4 Orange County SC Orange 24 48 32 39
5 Charleston Battery Charleston 24 43 28 39
6 Dayton Dutch Lions Dayton Dutch 24 38 39 36
7 Charlotte Eagles Charlotte 24 40 37 35
8 Pittsburgh Riverhounds Pittsburgh 24 34 32 34
9 VSI Tampa Bay Tampa 24 36 33 31
10 Wilmington Hammerheads Wilmington 24 32 38 31
11 Rochester New York Rochester 24 24 38 26
12 Phoenix Rising Phoenix 24 28 41 20
13 Antigua Barracuda Antigua 24 10 82 0
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Orlando City Orlando City 24 50 18 57
2 Rochester New York Rochester 24 27 23 41
3 Penn FC Penn FC 24 35 29 38
4 Wilmington Hammerheads Wilmington 24 35 32 38
5 Charlotte Eagles Charlotte 24 34 26 36
6 Richmond Kickers Richmond 24 31 28 36
7 Charleston Battery Charleston 23 33 26 35
8 Orange County SC Orange 24 26 30 28
9 Dayton Dutch Lions Dayton Dutch 24 20 29 22
10 Pittsburgh Riverhounds Pittsburgh 24 20 39 17
11 Antigua Barracuda Antigua 23 16 47 16
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Wilmington Hammerheads Wilmington 24 42 30 45
2 FC New York FC New York 24 27 37 25
3 Orlando City Orlando City 23 34 14 50
4 Richmond Kickers Richmond 24 35 21 41
5 Charleston Battery Charleston 24 24 25 35
6 Charlotte Eagles Charlotte 24 31 30 30
7 Antigua Barracuda Antigua 18 18 29 14
8 Rochester New York Rochester 24 31 23 40
9 Penn FC Penn FC 24 37 30 37
10 Orange County SC Orange 21 27 25 29
11 Pittsburgh Riverhounds Pittsburgh 24 23 32 27
12 Dayton Dutch Lions Dayton Dutch 24 21 54 12

  USO DE MEMORIA  
5,916,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1478
Total Execution Time  0.1497
  CADENA URL  
/usl_pro_usa2015/grupo1/historico
  GET DATOS  
$_GET['/usl_pro_usa2015/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0019  SELECT type FROM routes WHERE alias = 'usl_pro_usa2015'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usl_pro_usa' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  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 = 9545 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1666 AND group_code = 1 and tables = 1 AND year <= 2015 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0024  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 `tables2015` 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 = 9545 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2014` 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 = 14027 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2013` 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 = 14044 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2012` 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 = 14045 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2011` 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 = 14046 AND t.round = 20 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-30 18:32:49' 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-04-30 18:32:49' 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-30 18:32:49' 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-04-30 18:32:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0033  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usl_pro_usa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0286  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 events2015 e ON e.player_id = p.id AND e.league_id = 9545 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9545 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.0394  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 events2015 e ON e.player_id = p.id AND e.league_id = 9545 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9545 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044  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 events2015 e ON e.player_id = p.id AND e.league_id = 9545 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9545 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0055  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 9545 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC