4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
28 Jul 23 CS CartaginésCartaginés 1 - 0 GuanacastecaGuanacastec 223
26 Jul 23 Municipal LiberiaMunicipal 1 - 4 CS HeredianoHerediano 38
26 Jul 23 Pérez ZeledónPérez 1 - 0 Puntarenas FCPuntarenas 93
28 Jul 23 San CarlosSan Carlos 3 - 0 Municipal GreciaMunicipal 46
27 Jul 23 Santos de GuápilesSantos 0 - 1 LD AlajuelenseAlajuelense 14
27 Jul 23 Deportivo SaprissaDeportivo 2 - 1 Sporting FCSporting 45
Ver jornada
Jornada 2
30 Jul 23 GuanacastecaGuanacastec 0 - 1 Deportivo SaprissaDeportivo 36
30 Jul 23 LD AlajuelenseAlajuelense 3 - 3 Municipal LiberiaMunicipal 87
31 Jul 23 Municipal GreciaMunicipal 3 - 4 CS CartaginésCartaginés 38
30 Jul 23 CS HeredianoHerediano 4 - 0 Pérez ZeledónPérez 53
30 Jul 23 Puntarenas FCPuntarenas 0 - 0 Santos de GuápilesSantos 15
31 Jul 23 Sporting FCSporting 1 - 0 San CarlosSan Carlos 51
Ver jornada
Jornada 3
05 Ago 23 GuanacastecaGuanacastec 0 - 0 San CarlosSan Carlos 12
06 Ago 23 CS CartaginésCartaginés 1 - 0 Puntarenas FCPuntarenas 18
06 Ago 23 Municipal LiberiaMunicipal 3 - 0 Pérez ZeledónPérez 11
06 Ago 23 Santos de GuápilesSantos 2 - 0 Municipal GreciaMunicipal 18
07 Ago 23 Deportivo SaprissaDeportivo 1 - 2 CS HeredianoHerediano 53
06 Ago 23 Sporting FCSporting 0 - 0 LD AlajuelenseAlajuelense 35
Ver jornada
Jornada 4
12 Ago 23 Municipal GreciaMunicipal 0 - 1 Sporting FCSporting 22
13 Ago 23 CS HeredianoHerediano 0 - 1 GuanacastecaGuanacastec 81
14 Ago 23 Puntarenas FCPuntarenas 2 - 4 Deportivo SaprissaDeportivo 41
14 Ago 23 Pérez ZeledónPérez 1 - 2 LD AlajuelenseAlajuelense 27
12 Ago 23 San CarlosSan Carlos 1 - 1 CS CartaginésCartaginés 40
13 Ago 23 Santos de GuápilesSantos 3 - 3 Municipal LiberiaMunicipal 41
Ver jornada
Jornada 5
20 Ago 23 GuanacastecaGuanacastec 3 - 1 Sporting FCSporting 9
19 Ago 23 LD AlajuelenseAlajuelense 3 - 0 San CarlosSan Carlos 49
21 Ago 23 Municipal LiberiaMunicipal 1 - 1 Municipal GreciaMunicipal 18
21 Ago 23 Puntarenas FCPuntarenas 3 - 2 CS HeredianoHerediano 83
20 Ago 23 Pérez ZeledónPérez 1 - 1 Santos de GuápilesSantos 26
20 Ago 23 Deportivo SaprissaDeportivo 2 - 1 CS CartaginésCartaginés 27
Ver jornada
Jornada 6
27 Ago 23 GuanacastecaGuanacastec 3 - 2 Puntarenas FCPuntarenas 10
26 Ago 23 CS CartaginésCartaginés 1 - 0 Santos de GuápilesSantos 45
26 Ago 23 Municipal GreciaMunicipal 2 - 2 Pérez ZeledónPérez 6
28 Ago 23 CS HeredianoHerediano 2 - 3 LD AlajuelenseAlajuelense 88
27 Ago 23 San CarlosSan Carlos 1 - 2 Deportivo SaprissaDeportivo 26
27 Ago 23 Sporting FCSporting 3 - 4 Municipal LiberiaMunicipal 6
Ver jornada
Jornada 7
04 Sep 23 LD AlajuelenseAlajuelense 2 - 1 Deportivo SaprissaDeportivo 33
03 Sep 23 CS HeredianoHerediano 3 - 0 Municipal GreciaMunicipal 16
03 Sep 23 Municipal LiberiaMunicipal 2 - 1 CS CartaginésCartaginés 27
02 Sep 23 Puntarenas FCPuntarenas 1 - 0 San CarlosSan Carlos 9
02 Sep 23 Pérez ZeledónPérez 1 - 2 Sporting FCSporting 14
03 Sep 23 Santos de GuápilesSantos 1 - 0 GuanacastecaGuanacastec 23
Ver jornada
Jornada 8
09 Sep 23 GuanacastecaGuanacastec 1 - 2 Pérez ZeledónPérez 28
10 Sep 23 CS CartaginésCartaginés 1 - 1 CS HeredianoHerediano 55
11 Sep 23 Municipal GreciaMunicipal 1 - 2 LD AlajuelenseAlajuelense 105
10 Sep 23 San CarlosSan Carlos 2 - 2 Santos de GuápilesSantos 24
10 Sep 23 Deportivo SaprissaDeportivo 2 - 0 Municipal LiberiaMunicipal 10
10 Sep 23 Sporting FCSporting 0 - 3 Puntarenas FCPuntarenas 48
Ver jornada
Jornada 9
14 Sep 23 LD AlajuelenseAlajuelense 2 - 0 CS CartaginésCartaginés 72
13 Sep 23 Municipal GreciaMunicipal 1 - 2 GuanacastecaGuanacastec 101
14 Sep 23 CS HeredianoHerediano 2 - 1 San CarlosSan Carlos 64
14 Sep 23 Puntarenas FCPuntarenas 1 - 0 Municipal LiberiaMunicipal 42
13 Sep 23 Pérez ZeledónPérez 2 - 2 Deportivo SaprissaDeportivo 66
13 Sep 23 Santos de GuápilesSantos 0 - 0 Sporting FCSporting 95
Ver jornada
Jornada 10
17 Sep 23 LD AlajuelenseAlajuelense 2 - 0 Puntarenas FCPuntarenas 102
17 Sep 23 CS CartaginésCartaginés 2 - 1 Sporting FCSporting 8
16 Sep 23 Municipal LiberiaMunicipal 0 - 1 GuanacastecaGuanacastec 65
17 Sep 23 Pérez ZeledónPérez 2 - 2 San CarlosSan Carlos 15
17 Sep 23 Santos de GuápilesSantos 1 - 1 CS HeredianoHerediano 17
16 Sep 23 Deportivo SaprissaDeportivo 7 - 0 Municipal GreciaMunicipal 28
Ver jornada
Jornada 11
19 Sep 23 GuanacastecaGuanacastec 3 - 2 LD AlajuelenseAlajuelense 109
21 Sep 23 CS CartaginésCartaginés 4 - 0 Pérez ZeledónPérez 27
22 Sep 23 Municipal GreciaMunicipal 1 - 1 Puntarenas FCPuntarenas 104
21 Sep 23 San CarlosSan Carlos 2 - 1 Municipal LiberiaMunicipal 44
20 Sep 23 Deportivo SaprissaDeportivo 2 - 0 Santos de GuápilesSantos 184
21 Sep 23 Sporting FCSporting 1 - 3 CS HeredianoHerediano 45
Ver jornada
Jornada 12
23 Sep 23 GuanacastecaGuanacastec 1 - 2 CS CartaginésCartaginés 16
24 Sep 23 LD AlajuelenseAlajuelense 4 - 0 Santos de GuápilesSantos 38
25 Sep 23 Municipal GreciaMunicipal 1 - 0 San CarlosSan Carlos 65
24 Sep 23 CS HeredianoHerediano 2 - 2 Municipal LiberiaMunicipal 219
24 Sep 23 Puntarenas FCPuntarenas 2 - 0 Pérez ZeledónPérez 18
25 Sep 23 Sporting FCSporting 1 - 2 Deportivo SaprissaDeportivo 80
Ver jornada
Jornada 13
01 Oct 23 CS CartaginésCartaginés 4 - 1 Municipal GreciaMunicipal 26
01 Oct 23 Municipal LiberiaMunicipal 3 - 3 LD AlajuelenseAlajuelense 121
01 Oct 23 Pérez ZeledónPérez 1 - 4 CS HeredianoHerediano 22
01 Oct 23 San CarlosSan Carlos 2 - 2 Sporting FCSporting 15
01 Oct 23 Santos de GuápilesSantos 2 - 1 Puntarenas FCPuntarenas 11
02 Oct 23 Deportivo SaprissaDeportivo 4 - 0 GuanacastecaGuanacastec 33
Ver jornada
Jornada 14
09 Oct 23 LD AlajuelenseAlajuelense 1 - 2 Sporting FCSporting 138
07 Oct 23 Municipal GreciaMunicipal 0 - 0 Santos de GuápilesSantos 108
08 Oct 23 CS HeredianoHerediano 2 - 0 Deportivo SaprissaDeportivo 77
08 Oct 23 Puntarenas FCPuntarenas 0 - 4 CS CartaginésCartaginés 24
08 Oct 23 Pérez ZeledónPérez 3 - 2 Municipal LiberiaMunicipal 20
09 Oct 23 San CarlosSan Carlos 0 - 1 GuanacastecaGuanacastec 81
Ver jornada
Jornada 15
15 Nov 23 GuanacastecaGuanacastec 0 - 1 CS HeredianoHerediano 105
19 Oct 23 LD AlajuelenseAlajuelense 2 - 0 Pérez ZeledónPérez 138
19 Oct 23 CS CartaginésCartaginés 4 - 3 San CarlosSan Carlos 146
17 Oct 23 Municipal LiberiaMunicipal 1 - 1 Santos de GuápilesSantos 128
18 Oct 23 Deportivo SaprissaDeportivo 4 - 1 Puntarenas FCPuntarenas 67
18 Oct 23 Sporting FCSporting 2 - 1 Municipal GreciaMunicipal 13
Ver jornada
Jornada 16
22 Oct 23 CS CartaginésCartaginés 0 - 4 Deportivo SaprissaDeportivo 23
23 Oct 23 Municipal GreciaMunicipal 2 - 3 Municipal LiberiaMunicipal 22
22 Oct 23 CS HeredianoHerediano 2 - 1 Puntarenas FCPuntarenas 130
22 Oct 23 San CarlosSan Carlos 0 - 1 LD AlajuelenseAlajuelense 52
23 Oct 23 Santos de GuápilesSantos 2 - 0 Pérez ZeledónPérez 17
22 Oct 23 Sporting FCSporting 1 - 1 GuanacastecaGuanacastec 36
Ver jornada
Jornada 17
29 Oct 23 LD AlajuelenseAlajuelense 1 - 0 CS HeredianoHerediano 105
28 Oct 23 Municipal LiberiaMunicipal 2 - 1 Sporting FCSporting 64
28 Oct 23 Puntarenas FCPuntarenas 1 - 2 GuanacastecaGuanacastec 25
29 Oct 23 Pérez ZeledónPérez 0 - 2 Municipal GreciaMunicipal 61
28 Oct 23 Santos de GuápilesSantos 1 - 0 CS CartaginésCartaginés 62
29 Oct 23 Deportivo SaprissaDeportivo 2 - 1 San CarlosSan Carlos 154
Ver jornada
Jornada 18
04 Nov 23 GuanacastecaGuanacastec 1 - 0 Santos de GuápilesSantos 7
05 Nov 23 CS CartaginésCartaginés 3 - 2 Municipal LiberiaMunicipal 3
05 Nov 23 Municipal GreciaMunicipal 0 - 0 CS HeredianoHerediano 46
04 Nov 23 San CarlosSan Carlos 2 - 1 Puntarenas FCPuntarenas 35
05 Nov 23 Deportivo SaprissaDeportivo 1 - 0 LD AlajuelenseAlajuelense 113
05 Nov 23 Sporting FCSporting 4 - 0 Pérez ZeledónPérez 6
Ver jornada
Jornada 19
09 Nov 23 LD AlajuelenseAlajuelense 2 - 0 Municipal GreciaMunicipal 23
09 Nov 23 CS HeredianoHerediano 1 - 0 CS CartaginésCartaginés 94
10 Nov 23 Municipal LiberiaMunicipal 1 - 2 Deportivo SaprissaDeportivo 126
09 Nov 23 Puntarenas FCPuntarenas 4 - 0 Sporting FCSporting 52
08 Nov 23 Pérez ZeledónPérez 0 - 0 GuanacastecaGuanacastec 65
09 Nov 23 Santos de GuápilesSantos 0 - 2 San CarlosSan Carlos 29
Ver jornada
Jornada 20
11 Nov 23 GuanacastecaGuanacastec 0 - 0 Municipal GreciaMunicipal 17
12 Nov 23 CS CartaginésCartaginés 1 - 1 LD AlajuelenseAlajuelense 7
12 Nov 23 Municipal LiberiaMunicipal 0 - 0 Puntarenas FCPuntarenas 59
12 Nov 23 San CarlosSan Carlos 2 - 1 CS HeredianoHerediano 34
12 Nov 23 Deportivo SaprissaDeportivo 4 - 0 Pérez ZeledónPérez 23
13 Nov 23 Sporting FCSporting 1 - 0 Santos de GuápilesSantos 13
Ver jornada
Jornada 21
22 Nov 23 GuanacastecaGuanacastec 4 - 2 Municipal LiberiaMunicipal 31
23 Nov 23 Municipal GreciaMunicipal 1 - 2 Deportivo SaprissaDeportivo 130
23 Nov 23 CS HeredianoHerediano 3 - 0 Santos de GuápilesSantos 89
23 Nov 23 Puntarenas FCPuntarenas 1 - 2 LD AlajuelenseAlajuelense 103
24 Nov 23 San CarlosSan Carlos 1 - 0 Pérez ZeledónPérez 33
22 Nov 23 Sporting FCSporting 1 - 1 CS CartaginésCartaginés 36
Ver jornada
Jornada 22
26 Nov 23 LD AlajuelenseAlajuelense 3 - 4 GuanacastecaGuanacastec 179
26 Nov 23 CS HeredianoHerediano 3 - 0 Sporting FCSporting 57
27 Nov 23 Municipal LiberiaMunicipal 0 - 1 San CarlosSan Carlos 24
26 Nov 23 Puntarenas FCPuntarenas 1 - 2 Municipal GreciaMunicipal 20
26 Nov 23 Pérez ZeledónPérez 1 - 0 CS CartaginésCartaginés 57
26 Nov 23 Santos de GuápilesSantos 1 - 2 Deportivo SaprissaDeportivo 68

Clasificación

Equipo PJ GF GC Puntos
1 Deportivo Saprissa Deportivo 22 53 19 55
2 LD Alajuelense Alajuelense 22 42 23 46
3 CS Herediano Herediano 22 43 20 43
4 CS Cartaginés Cartaginés 22 36 28 37
5 Guanacasteca Guanacasteca 22 28 25 37
6 San Carlos San Carlos 22 26 28 26
7 Sporting FC Sporting FC 22 26 35 26
8 Santos de Guápiles Santos 22 17 26 23
9 Municipal Liberia Municipal 22 36 43 22
10 Puntarenas FC Puntarenas 22 26 34 18
11 Pérez Zeledón Pérez 22 17 46 17
12 Municipal Grecia Municipal 22 19 42 15

  USO DE MEMORIA  
5,804,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.3636
Total Execution Time  0.3659
  CADENA URL  
/invierno_costa_rica2024/grupo1/calendario
  GET DATOS  
$_GET['/invierno_costa_rica2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0124  SELECT type FROM routes WHERE alias = 'invierno_costa_rica2024'
0.0251  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 = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=147 AND type_rel = 3
0.0132  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.0127  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.0126  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 = 72174 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 72174 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:48:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 22:48:29' 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-04-27 22:48:29' 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-04-27 22:48:29' 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 = 'invierno_costa_rica' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0184  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 events2024 e ON e.player_id = p.id AND e.league_id = 72174 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72174 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.0205  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 events2024 e ON e.player_id = p.id AND e.league_id = 72174 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72174 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  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 events2024 e ON e.player_id = p.id AND e.league_id = 72174 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72174 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 72174 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC