4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
13 Ene 07 SantacruceñaSantacruce 1 - 1 Pérez ZeledónPérez ...
14 Ene 07 CS CartaginésCartaginés 2 - 0 CarmelitaCarmelita ...
14 Ene 07 Puntarenas FCPuntarenas 1 - 1 San CarlosSan Carlos ...
20 Ene 07 Pérez ZeledónPérez 1 - 1 Deportivo SaprissaDeportivo ...
20 Ene 07 Santos de GuápilesSantos 0 - 2 Puntarenas FCPuntarenas ...
21 Ene 07 San CarlosSan Carlos 1 - 1 LD AlajuelenseAlajuelense ...
Ver jornada
Jornada 2
21 Ene 07 Municipal LiberiaMunicipal 0 - 1 Brujas FCBrujas FC ...
21 Ene 07 CarmelitaCarmelita 1 - 4 SantacruceñaSantacruce ...
21 Ene 07 CS HeredianoHerediano 0 - 1 CS CartaginésCartaginés ...
24 Ene 07 LD AlajuelenseAlajuelense 1 - 1 Municipal LiberiaMunicipal ...
28 Ene 07 Puntarenas FCPuntarenas 2 - 1 Pérez ZeledónPérez ...
28 Ene 07 CS HeredianoHerediano 1 - 1 CarmelitaCarmelita ...
Ver jornada
Jornada 3
28 Ene 07 CS CartaginésCartaginés 1 - 0 Municipal LiberiaMunicipal ...
28 Ene 07 LD AlajuelenseAlajuelense 1 - 1 Santos de GuápilesSantos ...
29 Ene 07 Brujas FCBrujas FC 3 - 1 San CarlosSan Carlos ...
03 Feb 07 Pérez ZeledónPérez 1 - 2 Municipal LiberiaMunicipal ...
03 Feb 07 Santos de GuápilesSantos 1 - 1 Brujas FCBrujas FC ...
03 Feb 07 SantacruceñaSantacruce 1 - 1 Puntarenas FCPuntarenas ...
Ver jornada
Jornada 4
04 Feb 07 CarmelitaCarmelita 1 - 2 Deportivo SaprissaDeportivo ...
04 Feb 07 San CarlosSan Carlos 2 - 0 CS CartaginésCartaginés ...
07 Feb 07 Deportivo SaprissaDeportivo 1 - 0 SantacruceñaSantacruce ...
11 Feb 07 CS CartaginésCartaginés 1 - 0 Santos de GuápilesSantos ...
11 Feb 07 Brujas FCBrujas FC 1 - 0 Pérez ZeledónPérez ...
11 Feb 07 Municipal LiberiaMunicipal 1 - 2 CarmelitaCarmelita ...
Ver jornada
Jornada 5
14 Feb 07 Deportivo SaprissaDeportivo 3 - 1 Santos de GuápilesSantos ...
17 Feb 07 Santos de GuápilesSantos 4 - 2 San CarlosSan Carlos ...
21 Feb 07 Pérez ZeledónPérez 0 - 0 LD AlajuelenseAlajuelense ...
21 Feb 07 Municipal LiberiaMunicipal 1 - 1 CS HeredianoHerediano ...
24 Feb 07 Pérez ZeledónPérez 1 - 0 CarmelitaCarmelita ...
24 Feb 07 CS CartaginésCartaginés 2 - 0 Brujas FCBrujas FC ...
Ver jornada
Jornada 6
24 Feb 07 Santos de GuápilesSantos 3 - 0 SantacruceñaSantacruce ...
25 Feb 07 Municipal LiberiaMunicipal 0 - 1 Puntarenas FCPuntarenas ...
25 Feb 07 CS HeredianoHerediano 3 - 0 LD AlajuelenseAlajuelense ...
25 Feb 07 San CarlosSan Carlos 1 - 1 Deportivo SaprissaDeportivo ...
28 Feb 07 LD AlajuelenseAlajuelense 2 - 0 SantacruceñaSantacruce ...
28 Feb 07 Brujas FCBrujas FC 1 - 3 CS HeredianoHerediano ...
Ver jornada
Jornada 7
28 Feb 07 Deportivo SaprissaDeportivo 1 - 2 CS CartaginésCartaginés ...
03 Mar 07 Pérez ZeledónPérez 2 - 0 Santos de GuápilesSantos ...
03 Mar 07 Deportivo SaprissaDeportivo 1 - 1 Municipal LiberiaMunicipal ...
03 Mar 07 SantacruceñaSantacruce 1 - 2 San CarlosSan Carlos ...
04 Mar 07 CarmelitaCarmelita 1 - 1 Brujas FCBrujas FC ...
04 Mar 07 Puntarenas FCPuntarenas 2 - 1 CS HeredianoHerediano ...
Ver jornada
Jornada 8
04 Mar 07 LD AlajuelenseAlajuelense 1 - 0 CS CartaginésCartaginés ...
07 Mar 07 CarmelitaCarmelita 2 - 3 LD AlajuelenseAlajuelense ...
07 Mar 07 CS HeredianoHerediano 2 - 0 San CarlosSan Carlos ...
07 Mar 07 Puntarenas FCPuntarenas 3 - 1 Deportivo SaprissaDeportivo ...
10 Mar 07 CS CartaginésCartaginés 0 - 0 Puntarenas FCPuntarenas ...
10 Mar 07 Municipal LiberiaMunicipal 2 - 0 SantacruceñaSantacruce ...
Ver jornada
Jornada 9
10 Mar 07 San CarlosSan Carlos 0 - 1 Pérez ZeledónPérez ...
10 Mar 07 Santos de GuápilesSantos 2 - 3 CarmelitaCarmelita ...
11 Mar 07 Brujas FCBrujas FC 0 - 1 LD AlajuelenseAlajuelense ...
11 Mar 07 CS HeredianoHerediano 0 - 0 Deportivo SaprissaDeportivo ...
14 Mar 07 SantacruceñaSantacruce 0 - 2 CS HeredianoHerediano ...
17 Mar 07 Deportivo SaprissaDeportivo 3 - 0 LD AlajuelenseAlajuelense ...
Ver jornada
Jornada 10
17 Mar 07 SantacruceñaSantacruce 0 - 1 Brujas FCBrujas FC ...
18 Mar 07 CarmelitaCarmelita 1 - 3 Puntarenas FCPuntarenas ...
18 Mar 07 Pérez ZeledónPérez 3 - 2 CS CartaginésCartaginés ...
18 Mar 07 Santos de GuápilesSantos 2 - 1 CS HeredianoHerediano ...
18 Mar 07 San CarlosSan Carlos 2 - 1 Municipal LiberiaMunicipal ...
24 Mar 07 Municipal LiberiaMunicipal 0 - 4 Santos de GuápilesSantos ...
Ver jornada
Jornada 11
25 Mar 07 CarmelitaCarmelita 2 - 1 San CarlosSan Carlos ...
25 Mar 07 CS CartaginésCartaginés 0 - 0 SantacruceñaSantacruce ...
28 Mar 07 Brujas FCBrujas FC 4 - 2 Puntarenas FCPuntarenas ...
31 Mar 07 LD AlajuelenseAlajuelense 1 - 1 Pérez ZeledónPérez ...
31 Mar 07 SantacruceñaSantacruce 2 - 2 Municipal LiberiaMunicipal ...
01 Abr 07 Deportivo SaprissaDeportivo 0 - 0 CS HeredianoHerediano ...
Ver jornada
Jornada 12
01 Abr 07 San CarlosSan Carlos 2 - 2 Puntarenas FCPuntarenas ...
01 Abr 07 CarmelitaCarmelita 0 - 2 CS CartaginésCartaginés ...
01 Abr 07 Brujas FCBrujas FC 0 - 0 Santos de GuápilesSantos ...
04 Abr 07 CS HeredianoHerediano 3 - 2 Pérez ZeledónPérez ...
04 Abr 07 Puntarenas FCPuntarenas 0 - 0 LD AlajuelenseAlajuelense ...
05 Abr 07 Brujas FCBrujas FC 0 - 1 Deportivo SaprissaDeportivo ...
Ver jornada
Jornada 13
07 Abr 07 San CarlosSan Carlos 1 - 2 SantacruceñaSantacruce ...
08 Abr 07 Municipal LiberiaMunicipal 1 - 3 Deportivo SaprissaDeportivo ...
08 Abr 07 Santos de GuápilesSantos 2 - 0 CS CartaginésCartaginés ...
08 Abr 07 CS HeredianoHerediano 2 - 0 Puntarenas FCPuntarenas ...
08 Abr 07 LD AlajuelenseAlajuelense 3 - 1 CarmelitaCarmelita ...
11 Abr 07 Municipal LiberiaMunicipal 2 - 1 San CarlosSan Carlos ...
Ver jornada
Jornada 14
11 Abr 07 Santos de GuápilesSantos 0 - 2 LD AlajuelenseAlajuelense ...
11 Abr 07 CS HeredianoHerediano 3 - 1 SantacruceñaSantacruce ...
11 Abr 07 Brujas FCBrujas FC 0 - 0 CS CartaginésCartaginés ...
11 Abr 07 CarmelitaCarmelita 1 - 2 Pérez ZeledónPérez ...
11 Abr 07 Deportivo SaprissaDeportivo 1 - 0 Puntarenas FCPuntarenas ...
15 Abr 07 CarmelitaCarmelita 0 - 3 Santos de GuápilesSantos ...
Ver jornada
Jornada 15
15 Abr 07 San CarlosSan Carlos 1 - 0 CS HeredianoHerediano ...
15 Abr 07 LD AlajuelenseAlajuelense 2 - 1 Brujas FCBrujas FC ...
15 Abr 07 CS CartaginésCartaginés 1 - 1 Pérez ZeledónPérez ...
15 Abr 07 SantacruceñaSantacruce 0 - 3 Deportivo SaprissaDeportivo ...
15 Abr 07 Puntarenas FCPuntarenas 1 - 0 Municipal LiberiaMunicipal ...
18 Abr 07 Pérez ZeledónPérez 2 - 2 Brujas FCBrujas FC ...
Ver jornada
Jornada 16
22 Abr 07 Santos de GuápilesSantos 1 - 2 Pérez ZeledónPérez ...
22 Abr 07 CS CartaginésCartaginés 0 - 4 LD AlajuelenseAlajuelense ...
22 Abr 07 CS HeredianoHerediano 0 - 0 Municipal LiberiaMunicipal ...
22 Abr 07 Puntarenas FCPuntarenas 3 - 1 SantacruceñaSantacruce ...
22 Abr 07 Brujas FCBrujas FC 2 - 0 CarmelitaCarmelita ...
22 Abr 07 Deportivo SaprissaDeportivo 6 - 1 San CarlosSan Carlos ...

Clasificación

Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 16 28 12 32
2 Puntarenas FC Puntarenas 16 23 16 29
3 CS Herediano Herediano 16 22 12 26
4 San Carlos San Carlos 16 19 29 16
5 Municipal Liberia Municipal 16 14 22 14
6 Santacruceña Santacruceñ 16 13 28 10
7 LD Alajuelense Alajuelense 16 22 14 30
8 CS Cartaginés Cartaginés 16 14 14 25
9 Pérez Zeledón Pérez 16 21 18 24
10 Brujas FC Brujas FC 16 18 16 23
11 Santos de Guápiles Santos 16 24 20 21
12 Carmelita Carmelita 16 16 33 11

  USO DE MEMORIA  
5,359,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2926
Total Execution Time  0.2945
  CADENA URL  
/verano_costa_rica2007/grupo1/calendario
  GET DATOS  
$_GET['/verano_costa_rica2007/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0128  SELECT type FROM routes WHERE alias = 'verano_costa_rica2007'
0.0262  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'verano_costa_rica' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0127  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 = 14993 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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 calendars2007 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 14993 ORDER BY round ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 21:35:52' 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 21:35:52' 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 21:35:52' 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 21:35:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'verano_costa_rica' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2007 e ON e.player_id = p.id AND e.league_id = 14993 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14993 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 events2007 e ON e.player_id = p.id AND e.league_id = 14993 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14993 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 events2007 e ON e.player_id = p.id AND e.league_id = 14993 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14993 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0134  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 14993 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC