4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
09 Abr 11 Orlando CityOrlando 3 - 0 FC New YorkYork ...
09 Abr 11 Charleston BatteryCharleston 1 - 0 Charlotte EaglesCharlotte ...
09 Abr 11 Richmond KickersRichmond 2 - 1 Pittsburgh RiverhoundsPittsburgh ...
02 Abr 11 Richmond KickersRichmond 2 - 0 Orlando CityOrlando ...
Ver jornada
Jornada 2
15 Abr 11 Richmond KickersRichmond 1 - 0 Rochester New YorkRochester ...
17 Abr 11 Wilmington HammerheadsWilmington 1 - 0 Rochester New YorkRochester ...
17 Abr 11 Antigua BarracudaAntigua 1 - 2 Orange County SCOrange ...
16 Abr 11 Dayton Dutch LionsDayton 1 - 2 Charleston BatteryCharleston ...
16 Abr 11 Charlotte EaglesCharlotte 0 - 1 Orlando CityOrlando ...
Ver jornada
Jornada 3
23 Abr 11 Richmond KickersRichmond 2 - 1 Charleston BatteryCharleston ...
23 Abr 11 Charlotte EaglesCharlotte 0 - 0 FC New YorkYork ...
23 Abr 11 Pittsburgh RiverhoundsPittsburgh 1 - 0 Penn FCPenn FC ...
23 Abr 11 Dayton Dutch LionsDayton 2 - 3 Rochester New YorkRochester ...
Ver jornada
Jornada 4
30 Abr 11 FC New YorkYork 1 - 2 Orlando CityOrlando ...
01 May 11 Orange County SCOrange 0 - 1 Antigua BarracudaAntigua ...
29 Abr 11 Charlotte EaglesCharlotte 1 - 2 Charleston BatteryCharleston ...
29 Abr 11 Wilmington HammerheadsWilmington 3 - 1 Pittsburgh RiverhoundsPittsburgh ...
30 Abr 11 Charleston BatteryCharleston 0 - 0 Pittsburgh RiverhoundsPittsburgh ...
30 Abr 11 Dayton Dutch LionsDayton 0 - 6 Richmond KickersRichmond ...
Ver jornada
Jornada 5
07 May 11 Rochester New YorkRochester 1 - 0 Charleston BatteryCharleston ...
07 May 11 Richmond KickersRichmond 2 - 1 Wilmington HammerheadsWilmington ...
06 May 11 Pittsburgh RiverhoundsPittsburgh 0 - 0 Charleston BatteryCharleston ...
10 May 11 Penn FCPenn FC 1 - 0 Rochester New YorkRochester ...
07 May 11 FC New YorkYork 1 - 1 Penn FCPenn FC ...
07 May 11 Dayton Dutch LionsDayton 0 - 1 Orlando CityOrlando ...
Ver jornada
Jornada 6
12 May 11 Orange County SCOrange 2 - 1 Charlotte EaglesCharlotte ...
13 May 11 Charleston BatteryCharleston 0 - 1 FC New YorkYork ...
14 May 11 Penn FCPenn FC 1 - 1 Richmond KickersRichmond ...
14 May 11 Rochester New YorkRochester 2 - 0 Antigua BarracudaAntigua ...
14 May 11 Wilmington HammerheadsWilmington 3 - 1 FC New YorkYork ...
14 May 11 Orlando CityOrlando 1 - 0 Pittsburgh RiverhoundsPittsburgh ...
14 May 11 Orange County SCOrange 2 - 1 Charlotte EaglesCharlotte ...
Ver jornada
Jornada 7
20 May 11 Dayton Dutch LionsDayton 1 - 1 Orange County SCOrange ...
20 May 11 Rochester New YorkRochester 0 - 0 Orlando CityOrlando ...
20 May 11 Charlotte EaglesCharlotte 2 - 0 Antigua BarracudaAntigua ...
21 May 11 Pittsburgh RiverhoundsPittsburgh 2 - 0 FC New YorkYork ...
21 May 11 Wilmington HammerheadsWilmington 3 - 0 Charleston BatteryCharleston ...
22 May 11 Penn FCPenn FC 1 - 3 Orlando CityOrlando ...
22 May 11 Pittsburgh RiverhoundsPittsburgh 0 - 3 Orange County SCOrange ...
24 May 11 Charleston BatteryCharleston 2 - 1 Richmond KickersRichmond ...
Ver jornada
Jornada 8
25 May 11 Orlando CityOrlando 2 - 0 Richmond KickersRichmond ...
27 May 11 Rochester New YorkRochester 1 - 1 Wilmington HammerheadsWilmington ...
28 May 11 Pittsburgh RiverhoundsPittsburgh 0 - 0 Wilmington HammerheadsWilmington ...
28 May 11 Richmond KickersRichmond 2 - 2 FC New YorkYork ...
28 May 11 Charleston BatteryCharleston 2 - 1 Penn FCPenn FC ...
28 May 11 Dayton Dutch LionsDayton 1 - 1 Charlotte EaglesCharlotte ...
30 May 11 FC New YorkYork 2 - 1 Rochester New YorkRochester ...
31 May 11 Penn FCPenn FC 4 - 2 Pittsburgh RiverhoundsPittsburgh ...
Ver jornada
Jornada 9
02 Jun 11 Orlando CityOrlando 0 - 0 Charlotte EaglesCharlotte ...
03 Jun 11 FC New YorkYork 1 - 1 Charleston BatteryCharleston ...
03 Jun 11 Antigua BarracudaAntigua 1 - 2 Rochester New YorkRochester ...
04 Jun 11 Penn FCPenn FC 1 - 0 Charleston BatteryCharleston ...
04 Jun 11 Dayton Dutch LionsDayton 2 - 1 Pittsburgh RiverhoundsPittsburgh ...
04 Jun 11 Wilmington HammerheadsWilmington 2 - 4 Orlando CityOrlando ...
05 Jun 11 Antigua BarracudaAntigua 2 - 2 Rochester New YorkRochester ...
08 Jun 11 Penn FCPenn FC 4 - 1 Dayton Dutch LionsDayton ...
Ver jornada
Jornada 10
10 Jun 11 FC New YorkYork 3 - 0 Dayton Dutch LionsDayton ...
10 Jun 11 Wilmington HammerheadsWilmington 3 - 1 Pittsburgh RiverhoundsPittsburgh ...
10 Jun 11 Orlando CityOrlando 1 - 2 Antigua BarracudaAntigua ...
11 Jun 11 Rochester New YorkRochester 1 - 0 Penn FCPenn FC ...
11 Jun 11 Charlotte EaglesCharlotte 3 - 0 Wilmington HammerheadsWilmington ...
12 Jun 11 FC New YorkYork 0 - 2 Richmond KickersRichmond ...
Ver jornada
Jornada 11
17 Jun 11 Richmond KickersRichmond 0 - 1 Penn FCPenn FC ...
17 Jun 11 Charleston BatteryCharleston 1 - 0 Dayton Dutch LionsDayton ...
17 Jun 11 Pittsburgh RiverhoundsPittsburgh 0 - 3 Rochester New YorkRochester ...
18 Jun 11 Orlando CityOrlando 1 - 1 Wilmington HammerheadsWilmington ...
18 Jun 11 Charlotte EaglesCharlotte 2 - 0 Dayton Dutch LionsDayton ...
Ver jornada
Jornada 12
26 Jun 11 Antigua BarracudaAntigua 1 - 2 Orlando CityOrlando ...
25 Jun 11 Charleston BatteryCharleston 0 - 2 Pittsburgh RiverhoundsPittsburgh ...
25 Jun 11 Rochester New YorkRochester 1 - 0 Dayton Dutch LionsDayton ...
24 Jun 11 Orange County SCOrange 1 - 1 Penn FCPenn FC ...
24 Jun 11 Wilmington HammerheadsWilmington 0 - 2 Charleston BatteryCharleston ...
24 Jun 11 Charlotte EaglesCharlotte 2 - 0 Pittsburgh RiverhoundsPittsburgh ...
24 Jun 11 FC New YorkYork 0 - 0 Richmond KickersRichmond ...
24 Jun 11 Antigua BarracudaAntigua 1 - 3 Orlando CityOrlando ...
26 Jun 11 Orange County SCOrange 1 - 2 Penn FCPenn FC ...
Ver jornada
Jornada 13
01 Jul 11 Pittsburgh RiverhoundsPittsburgh 0 - 0 Orlando CityOrlando ...
01 Jul 11 Charleston BatteryCharleston 0 - 0 Orange County SCOrange ...
01 Jul 11 Rochester New YorkRochester 2 - 1 Richmond KickersRichmond ...
01 Jul 11 FC New YorkYork 2 - 0 Antigua BarracudaAntigua ...
02 Jul 11 Penn FCPenn FC 4 - 0 Charlotte EaglesCharlotte ...
02 Jul 11 Wilmington HammerheadsWilmington 4 - 2 Orange County SCOrange ...
03 Jul 11 Pittsburgh RiverhoundsPittsburgh 2 - 0 Antigua BarracudaAntigua ...
03 Jul 11 Rochester New YorkRochester 0 - 1 Orlando CityOrlando ...
04 Jul 11 Richmond KickersRichmond 3 - 1 Dayton Dutch LionsDayton ...
04 Jul 11 FC New YorkYork 1 - 3 Charlotte EaglesCharlotte ...
Ver jornada
Jornada 14
08 Jul 11 Orlando CityOrlando 0 - 0 Dayton Dutch LionsDayton ...
08 Jul 11 Richmond KickersRichmond 1 - 2 Charlotte EaglesCharlotte ...
08 Jul 11 Antigua BarracudaAntigua 0 - 1 Wilmington HammerheadsWilmington ...
08 Jul 11 Rochester New YorkRochester 3 - 1 FC New YorkYork ...
09 Jul 11 Pittsburgh RiverhoundsPittsburgh 2 - 1 FC New YorkYork ...
09 Jul 11 Charleston BatteryCharleston 1 - 0 Orlando CityOrlando ...
09 Jul 11 Charlotte EaglesCharlotte 1 - 2 Richmond KickersRichmond ...
10 Jul 11 Penn FCPenn FC 2 - 2 Dayton Dutch LionsDayton ...
10 Jul 11 Antigua BarracudaAntigua 2 - 3 Wilmington HammerheadsWilmington ...
Ver jornada
Jornada 15
16 Jul 11 Wilmington HammerheadsWilmington 3 - 1 Penn FCPenn FC ...
15 Jul 11 Orange County SCOrange 1 - 1 Dayton Dutch LionsDayton ...
16 Jul 11 Richmond KickersRichmond 1 - 0 Antigua BarracudaAntigua ...
16 Jul 11 Orlando CityOrlando 2 - 1 Rochester New YorkRochester ...
14 Jul 11 Charleston BatteryCharleston 2 - 1 Wilmington HammerheadsWilmington ...
15 Jul 11 Charlotte EaglesCharlotte 1 - 1 Penn FCPenn FC ...
17 Jul 11 Orange County SCOrange 4 - 1 Dayton Dutch LionsDayton ...
16 Jul 11 FC New YorkYork 1 - 1 Pittsburgh RiverhoundsPittsburgh ...
Ver jornada
Jornada 16
20 Jul 11 Pittsburgh RiverhoundsPittsburgh 3 - 1 Dayton Dutch LionsDayton ...
20 Jul 11 Penn FCPenn FC 5 - 1 FC New YorkYork ...
22 Jul 11 Richmond KickersRichmond 1 - 2 Orange County SCOrange ...
22 Jul 11 Charlotte EaglesCharlotte 1 - 0 Wilmington HammerheadsWilmington ...
22 Jul 11 Rochester New YorkRochester 3 - 0 Pittsburgh RiverhoundsPittsburgh ...
23 Jul 11 Penn FCPenn FC 1 - 1 Orange County SCOrange ...
23 Jul 11 Dayton Dutch LionsDayton 2 - 2 Charleston BatteryCharleston ...
23 Jul 11 Wilmington HammerheadsWilmington 3 - 0 Charlotte EaglesCharlotte ...
Ver jornada
Jornada 17
27 Jul 11 Dayton Dutch LionsDayton 2 - 3 Penn FCPenn FC ...
29 Jul 11 Charlotte EaglesCharlotte 2 - 2 Rochester New YorkRochester ...
29 Jul 11 FC New YorkYork 1 - 3 Wilmington HammerheadsWilmington ...
31 Jul 11 Orange County SCOrange 2 - 1 Antigua BarracudaAntigua ...
30 Jul 11 Penn FCPenn FC 1 - 2 Wilmington HammerheadsWilmington ...
30 Jul 11 Pittsburgh RiverhoundsPittsburgh 2 - 0 Richmond KickersRichmond ...
30 Jul 11 Charleston BatteryCharleston 0 - 1 Rochester New YorkRochester ...
31 Jul 11 Dayton Dutch LionsDayton 2 - 0 FC New YorkYork ...
29 Jul 11 Orange County SCOrange 1 - 2 Antigua BarracudaAntigua ...
Ver jornada
Jornada 18
02 Ago 11 Orange County SCOrange 1 - 1 Antigua BarracudaAntigua ...
03 Ago 11 Orlando CityOrlando 1 - 0 Charleston BatteryCharleston ...
05 Ago 11 Penn FCPenn FC 0 - 0 FC New YorkYork ...
05 Ago 11 Wilmington HammerheadsWilmington 2 - 1 Orange County SCOrange ...
05 Ago 11 Rochester New YorkRochester 0 - 3 Charlotte EaglesCharlotte ...
06 Ago 11 Pittsburgh RiverhoundsPittsburgh 2 - 2 Charlotte EaglesCharlotte ...
06 Ago 11 Richmond KickersRichmond 3 - 0 Dayton Dutch LionsDayton ...
06 Ago 11 Orlando CityOrlando 2 - 1 Charleston BatteryCharleston ...
07 Ago 11 FC New YorkYork 2 - 1 Rochester New YorkRochester ...
07 Ago 11 Antigua BarracudaAntigua 3 - 0 Orange County SCOrange ...
Ver jornada
Jornada 19
10 Ago 11 Charlotte EaglesCharlotte 0 - 1 Penn FCPenn FC ...
10 Ago 11 Dayton Dutch LionsDayton 0 - 5 FC New YorkYork ...
10 Ago 11 Wilmington HammerheadsWilmington 0 - 2 Richmond KickersRichmond ...
Ver jornada
Jornada 20
12 Ago 11 Orlando CityOrlando 4 - 0 Penn FCPenn FC ...
12 Ago 11 Charleston BatteryCharleston 4 - 3 Charlotte EaglesCharlotte ...
12 Ago 11 Orange County SCOrange 0 - 0 Richmond KickersRichmond ...
13 Ago 11 Rochester New YorkRochester 1 - 0 Pittsburgh RiverhoundsPittsburgh ...
13 Ago 11 Dayton Dutch LionsDayton 1 - 2 Wilmington HammerheadsWilmington ...
14 Ago 11 Orange County SCOrange 0 - 0 Richmond KickersRichmond ...

Clasificación

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,808,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1701
Total Execution Time  0.1722
  CADENA URL  
/usl_pro_usa2011/grupo1/calendario
  GET DATOS  
$_GET['/usl_pro_usa2011/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0020  SELECT type FROM routes WHERE alias = 'usl_pro_usa2011'
0.0046  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 = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1666 AND type_rel = 3
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1666 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0028  SELECT /*53 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 (1282492,1272547,1261789,1137367,1108384) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1666 ORDER BY order_id ASC
0.0036  SELECT 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, dt1.stadium as stadium_name FROM calendars2011 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 14046 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 16:56:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 16:56:03' 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=4 AND last_update > '2024-05-01 16:56:03' 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-05-01 16:56:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0131  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 events2011 e ON e.player_id = p.id AND e.league_id = 14046 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14046 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.0144  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 events2011 e ON e.player_id = p.id AND e.league_id = 14046 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14046 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  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 events2011 e ON e.player_id = p.id AND e.league_id = 14046 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14046 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  SELECT *,(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