4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
31 Jul 11 Orión FCOrión FC 1 - 0 LimónLimón ...
31 Jul 11 Pérez ZeledónPérez 1 - 3 LD AlajuelenseAlajuelense ...
31 Jul 11 Puntarenas FCPuntarenas 1 - 1 CS HeredianoHerediano ...
01 Ago 11 San CarlosSan Carlos 1 - 1 CS CartaginésCartaginés ...
01 Ago 11 Belén Siglo XXIBelén 3 - 0 Santos de GuápilesSantos ...
Ver jornada
Jornada 2
04 Ago 11 Pérez ZeledónPérez 1 - 0 San CarlosSan Carlos ...
04 Ago 11 LimónLimón 2 - 1 Belén Siglo XXIBelén ...
04 Ago 11 Orión FCOrión FC 0 - 0 Puntarenas FCPuntarenas ...
05 Ago 11 Santos de GuápilesSantos 1 - 1 CS CartaginésCartaginés ...
05 Ago 11 LD AlajuelenseAlajuelense 1 - 1 Deportivo SaprissaDeportivo ...
Ver jornada
Jornada 3
07 Ago 11 Deportivo SaprissaDeportivo 0 - 1 LimónLimón ...
07 Ago 11 Belén Siglo XXIBelén 1 - 2 LD AlajuelenseAlajuelense ...
07 Ago 11 Puntarenas FCPuntarenas 3 - 2 Pérez ZeledónPérez ...
07 Ago 11 San CarlosSan Carlos 2 - 2 Orión FCOrión FC ...
10 Ago 11 CS HeredianoHerediano 1 - 0 Santos de GuápilesSantos ...
Ver jornada
Jornada 4
14 Ago 11 LimónLimón 0 - 2 Santos de GuápilesSantos ...
14 Ago 11 Orión FCOrión FC 0 - 1 CS HeredianoHerediano ...
14 Ago 11 CS CartaginésCartaginés 2 - 2 Pérez ZeledónPérez ...
14 Ago 11 Puntarenas FCPuntarenas 1 - 3 LD AlajuelenseAlajuelense ...
15 Ago 11 Deportivo SaprissaDeportivo 0 - 0 Belén Siglo XXIBelén ...
Ver jornada
Jornada 5
21 Ago 11 Santos de GuápilesSantos 3 - 0 Puntarenas FCPuntarenas ...
21 Ago 11 CS HeredianoHerediano 2 - 1 Pérez ZeledónPérez ...
21 Ago 11 LD AlajuelenseAlajuelense 3 - 1 San CarlosSan Carlos ...
21 Ago 11 CS CartaginésCartaginés 2 - 1 Deportivo SaprissaDeportivo ...
21 Ago 11 Belén Siglo XXIBelén 1 - 1 Orión FCOrión FC ...
Ver jornada
Jornada 6
25 Ago 11 San CarlosSan Carlos 2 - 1 LimónLimón ...
25 Ago 11 Pérez ZeledónPérez 2 - 2 Deportivo SaprissaDeportivo ...
25 Ago 11 Orión FCOrión FC 0 - 0 CS CartaginésCartaginés ...
31 Ago 11 LD AlajuelenseAlajuelense 0 - 2 Santos de GuápilesSantos ...
01 Sep 11 CS HeredianoHerediano 1 - 1 Belén Siglo XXIBelén ...
Ver jornada
Jornada 7
28 Ago 11 San CarlosSan Carlos 3 - 1 Santos de GuápilesSantos ...
28 Ago 11 CS CartaginésCartaginés 3 - 1 CS HeredianoHerediano ...
28 Ago 11 Pérez ZeledónPérez 0 - 1 Belén Siglo XXIBelén ...
29 Ago 11 Deportivo SaprissaDeportivo 1 - 0 Orión FCOrión FC ...
29 Ago 11 LimónLimón 3 - 3 Puntarenas FCPuntarenas ...
Ver jornada
Jornada 8
04 Sep 11 Deportivo SaprissaDeportivo 1 - 0 CS HeredianoHerediano ...
04 Sep 11 LimónLimón 0 - 2 LD AlajuelenseAlajuelense ...
04 Sep 11 Puntarenas FCPuntarenas 2 - 0 San CarlosSan Carlos ...
04 Sep 11 Belén Siglo XXIBelén 1 - 1 CS CartaginésCartaginés ...
04 Sep 11 Orión FCOrión FC 0 - 1 Pérez ZeledónPérez ...
Ver jornada
Jornada 9
08 Sep 11 Deportivo SaprissaDeportivo 1 - 1 Puntarenas FCPuntarenas ...
08 Sep 11 LD AlajuelenseAlajuelense 4 - 0 CS CartaginésCartaginés ...
08 Sep 11 LimónLimón 1 - 2 CS HeredianoHerediano ...
08 Sep 11 Pérez ZeledónPérez 2 - 1 Santos de GuápilesSantos ...
09 Sep 11 Belén Siglo XXIBelén 1 - 1 San CarlosSan Carlos ...
Ver jornada
Jornada 10
11 Sep 11 Santos de GuápilesSantos 1 - 2 Orión FCOrión FC ...
11 Sep 11 CS HeredianoHerediano 4 - 0 LD AlajuelenseAlajuelense ...
11 Sep 11 CS CartaginésCartaginés 3 - 0 LimónLimón 2
11 Sep 11 Puntarenas FCPuntarenas 3 - 0 Belén Siglo XXIBelén ...
12 Sep 11 San CarlosSan Carlos 1 - 4 Deportivo SaprissaDeportivo ...
Ver jornada
Jornada 11
18 Sep 11 CS HeredianoHerediano 5 - 0 San CarlosSan Carlos ...
18 Sep 11 CS CartaginésCartaginés 3 - 0 Puntarenas FCPuntarenas ...
18 Sep 11 Orión FCOrión FC 1 - 1 LD AlajuelenseAlajuelense ...
18 Sep 11 LimónLimón 1 - 0 Pérez ZeledónPérez ...
19 Sep 11 Deportivo SaprissaDeportivo 1 - 0 Santos de GuápilesSantos ...
Ver jornada
Jornada 12
25 Sep 11 CS HeredianoHerediano 3 - 1 Puntarenas FCPuntarenas ...
25 Sep 11 LD AlajuelenseAlajuelense 4 - 0 Pérez ZeledónPérez ...
25 Sep 11 CS CartaginésCartaginés 0 - 0 San CarlosSan Carlos ...
25 Sep 11 LimónLimón 3 - 2 Orión FCOrión FC ...
25 Sep 11 Santos de GuápilesSantos 1 - 1 Belén Siglo XXIBelén ...
Ver jornada
Jornada 13
29 Sep 11 Puntarenas FCPuntarenas 2 - 1 Orión FCOrión FC ...
29 Sep 11 Belén Siglo XXIBelén 3 - 1 LimónLimón ...
29 Sep 11 CS CartaginésCartaginés 1 - 1 Santos de GuápilesSantos ...
06 Oct 11 San CarlosSan Carlos 3 - 0 Pérez ZeledónPérez ...
10 Nov 11 Deportivo SaprissaDeportivo 2 - 2 LD AlajuelenseAlajuelense ...
Ver jornada
Jornada 14
02 Oct 11 Pérez ZeledónPérez 7 - 1 Puntarenas FCPuntarenas ...
02 Oct 11 Orión FCOrión FC 1 - 0 San CarlosSan Carlos ...
02 Oct 11 LD AlajuelenseAlajuelense 1 - 0 Belén Siglo XXIBelén ...
02 Oct 11 LimónLimón 0 - 2 Deportivo SaprissaDeportivo ...
02 Oct 11 Santos de GuápilesSantos 0 - 0 CS HeredianoHerediano ...
Ver jornada
Jornada 15
09 Oct 11 LD AlajuelenseAlajuelense 0 - 1 Puntarenas FCPuntarenas ...
09 Oct 11 CS HeredianoHerediano 1 - 0 Orión FCOrión FC ...
09 Oct 11 Belén Siglo XXIBelén 1 - 1 Deportivo SaprissaDeportivo ...
09 Oct 11 Santos de GuápilesSantos 2 - 1 LimónLimón ...
10 Oct 11 Pérez ZeledónPérez 0 - 0 CS CartaginésCartaginés ...
Ver jornada
Jornada 16
16 Oct 11 San CarlosSan Carlos 0 - 3 LD AlajuelenseAlajuelense ...
16 Oct 11 Orión FCOrión FC 3 - 1 Belén Siglo XXIBelén ...
16 Oct 11 Deportivo SaprissaDeportivo 3 - 1 CS CartaginésCartaginés ...
20 Oct 11 Puntarenas FCPuntarenas 2 - 2 Santos de GuápilesSantos ...
17 Nov 11 Pérez ZeledónPérez 2 - 1 CS HeredianoHerediano ...
Ver jornada
Jornada 17
23 Oct 11 Deportivo SaprissaDeportivo 2 - 0 Pérez ZeledónPérez ...
23 Oct 11 Santos de GuápilesSantos 0 - 3 LD AlajuelenseAlajuelense ...
23 Oct 11 LimónLimón 0 - 1 San CarlosSan Carlos ...
24 Oct 11 Belén Siglo XXIBelén 1 - 2 CS HeredianoHerediano ...
11 Nov 11 CS CartaginésCartaginés 3 - 1 Orión FCOrión FC ...
Ver jornada
Jornada 18
27 Oct 11 Puntarenas FCPuntarenas 1 - 0 LimónLimón 1
27 Oct 11 Belén Siglo XXIBelén 1 - 3 Pérez ZeledónPérez ...
27 Oct 11 CS HeredianoHerediano 6 - 3 CS CartaginésCartaginés ...
28 Oct 11 Santos de GuápilesSantos 2 - 2 San CarlosSan Carlos ...
16 Nov 11 Orión FCOrión FC 1 - 4 Deportivo SaprissaDeportivo ...
Ver jornada
Jornada 19
30 Oct 11 CS HeredianoHerediano 1 - 1 Deportivo SaprissaDeportivo ...
30 Oct 11 CS CartaginésCartaginés 3 - 2 Belén Siglo XXIBelén ...
30 Oct 11 San CarlosSan Carlos 0 - 0 Puntarenas FCPuntarenas ...
30 Oct 11 LD AlajuelenseAlajuelense 0 - 2 LimónLimón ...
31 Oct 11 Pérez ZeledónPérez 5 - 1 Orión FCOrión FC ...
Ver jornada
Jornada 20
06 Nov 11 San CarlosSan Carlos 4 - 0 Belén Siglo XXIBelén ...
06 Nov 11 CS HeredianoHerediano 1 - 1 LimónLimón ...
06 Nov 11 Puntarenas FCPuntarenas 3 - 3 Deportivo SaprissaDeportivo ...
06 Nov 11 Santos de GuápilesSantos 1 - 1 Pérez ZeledónPérez ...
06 Nov 11 CS CartaginésCartaginés 2 - 0 LD AlajuelenseAlajuelense ...
Ver jornada
Jornada 21
13 Nov 11 Deportivo SaprissaDeportivo 2 - 1 San CarlosSan Carlos ...
13 Nov 11 Orión FCOrión FC 1 - 3 Santos de GuápilesSantos ...
13 Nov 11 Belén Siglo XXIBelén 1 - 0 Puntarenas FCPuntarenas ...
13 Nov 11 LimónLimón 1 - 1 CS CartaginésCartaginés ...
13 Nov 11 LD AlajuelenseAlajuelense 2 - 2 CS HeredianoHerediano ...
Ver jornada
Jornada 22
20 Nov 11 LD AlajuelenseAlajuelense 4 - 2 Orión FCOrión FC ...
20 Nov 11 Puntarenas FCPuntarenas 2 - 1 CS CartaginésCartaginés ...
20 Nov 11 Pérez ZeledónPérez 1 - 1 LimónLimón ...
20 Nov 11 Santos de GuápilesSantos 3 - 2 Deportivo SaprissaDeportivo ...
20 Nov 11 San CarlosSan Carlos 0 - 4 CS HeredianoHerediano ...

Clasificación

Equipo PJ GF GC Puntos
1 CS Herediano Herediano 20 39 19 39
2 LD Alajuelense Alajuelense 20 38 23 37
3 Deportivo Saprissa Deportivo 20 34 21 35
4 CS Cartaginés Cartaginés 20 31 27 30
5 Puntarenas FC Puntarenas 20 27 34 28
6 Pérez Zeledón Pérez 20 31 30 26
7 Santos de Guápiles Santos 20 26 27 25
8 San Carlos San Carlos 20 22 33 21
9 Belén Siglo XXI Belén Siglo 20 21 30 19
10 Limón Limón 20 19 30 19
11 Orión FC Orión FC 20 20 34 17

  USO DE MEMORIA  
5,638,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1116
Total Execution Time  0.1135
  CADENA URL  
/invierno_costa_rica2012/grupo1/calendario
  GET DATOS  
$_GET['/invierno_costa_rica2012/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0018  SELECT type FROM routes WHERE alias = 'invierno_costa_rica2012'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'invierno_costa_rica' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=147 AND type_rel = 3
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 147 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1271255,1241828,1234222,1199797,1199445) ORDER BY n.cover_points DESC, update_date DESC
0.0019  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 = 1023 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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 calendars2012 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 1023 ORDER BY round ASC
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 01:37:40' 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-05-05 01:37:40' 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-05-05 01:37:40' 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-05-05 01:37:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'invierno_costa_rica' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2012 e ON e.player_id = p.id AND e.league_id = 1023 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1023 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.0123  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 events2012 e ON e.player_id = p.id AND e.league_id = 1023 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1023 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 events2012 e ON e.player_id = p.id AND e.league_id = 1023 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1023 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0037  SELECT *,(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 = 1023 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC