4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Primera Costa Rica - Apertura 2021

La temporada finalizó el Domingo, 06 Diciembre 2020.
Resultados
« Jornada Anterior
Jornada 4
Jornada Siguiente »
 
02 Sep 20
04:00 Finalizado 		LD Alajuelense LD Alajuelense 2-1 Santos de Guápiles Santos de Guápiles más información Jugadas destacadas 30
0-1 26' Brayan López
67' F. Zabala 1-1
86' J. Diaz 2-1
 
02 Sep 20
23:00 Finalizado 		Guadalupe Guadalupe 1-0 Municipal Grecia Municipal Grecia más información Jugadas destacadas 54
63' Y. Salas
80' J. Arias 1-0
 
03 Sep 20
04:00 Finalizado 		CS Herediano CS Herediano 2-1 Pérez Zeledón Pérez Zeledón más información Jugadas destacadas 17
29' J. Mcdonald 1-0
1-1 51' D. Villegas
88' J. Mcdonald 2-1
 
03 Sep 20
23:00 Finalizado 		Limón Limón 1-1 CS Cartaginés CS Cartaginés más información Jugadas destacadas 35
0-1 67' M. Hernández
73' J. Rivera 1-1
 
03 Sep 20
23:00 Finalizado 		Sporting FC Sporting FC 1-0 San Carlos San Carlos más información Jugadas destacadas 35
86' José Guillermo Mora
90' J. Valverde
95' J. Scott 1-0
 
30 Sep 20
22:00 Finalizado 		Jicaral Sercoba Jicaral Sercoba 0-1 Deportivo Saprissa Deportivo Saprissa más información Jugadas destacadas 61
0-1 87' F. Zamora
Clasificación
« Jornada Anterior
Jornada 4
Jornada Siguiente »
Grupo A Puntos J. G. E. P. F. C. Forma
1 LD Alajuelense LD Alajuelense 9 4 3 0 1 6 3
  • VICTORIA
  • Pérez Zeledón 0
  • LD Alajuelense 2
  • DERROTA
  • LD Alajuelense 0
  • Guadalupe 1
  • VICTORIA
  • CS Herediano 1
  • LD Alajuelense 2
  • VICTORIA
  • LD Alajuelense 2
  • Santos de Guápiles 1
2 CS Herediano CS Herediano 7 4 2 1 1 7 4
  • VICTORIA
  • CS Herediano 3
  • Municipal Grecia 0
  • EMPATE
  • Santos de Guápiles 1
  • CS Herediano 1
  • DERROTA
  • CS Herediano 1
  • LD Alajuelense 2
  • VICTORIA
  • CS Herediano 2
  • Pérez Zeledón 1
3 Guadalupe Guadalupe 7 4 2 1 1 6 5
  • EMPATE
  • Guadalupe 2
  • Santos de Guápiles 2
  • VICTORIA
  • LD Alajuelense 0
  • Guadalupe 1
  • DERROTA
  • Pérez Zeledón 3
  • Guadalupe 2
  • VICTORIA
  • Guadalupe 1
  • Municipal Grecia 0
4 Municipal Grecia Municipal Grecia 4 4 1 1 2 4 6
  • DERROTA
  • CS Herediano 3
  • Municipal Grecia 0
  • VICTORIA
  • Municipal Grecia 3
  • Pérez Zeledón 1
  • EMPATE
  • Santos de Guápiles 1
  • Municipal Grecia 1
  • DERROTA
  • Guadalupe 1
  • Municipal Grecia 0
5 Santos de Guápiles Santos Guápiles 3 4 0 3 1 5 6
  • EMPATE
  • Guadalupe 2
  • Santos de Guápiles 2
  • EMPATE
  • Santos de Guápiles 1
  • CS Herediano 1
  • EMPATE
  • Santos de Guápiles 1
  • Municipal Grecia 1
  • DERROTA
  • LD Alajuelense 2
  • Santos de Guápiles 1
6 Pérez Zeledón Pérez Zeledón 3 4 1 0 3 5 9
  • DERROTA
  • Pérez Zeledón 0
  • LD Alajuelense 2
  • DERROTA
  • Municipal Grecia 3
  • Pérez Zeledón 1
  • VICTORIA
  • Pérez Zeledón 3
  • Guadalupe 2
  • DERROTA
  • CS Herediano 2
  • Pérez Zeledón 1
Grupo B Puntos J. G. E. P. F. C. Forma
1 CS Cartaginés CS Cartaginés 8 4 2 2 0 10 5
  • VICTORIA
  • Sporting FC 2
  • CS Cartaginés 3
  • EMPATE
  • CS Cartaginés 2
  • Jicaral Sercoba 2
  • VICTORIA
  • Deportivo Saprissa 0
  • CS Cartaginés 4
  • EMPATE
  • Limón 1
  • CS Cartaginés 1
2 Deportivo Saprissa Deportivo 7 4 2 1 1 6 5
  • VICTORIA
  • Deportivo Saprissa 4
  • Limón 0
  • EMPATE
  • San Carlos 1
  • Deportivo Saprissa 1
  • DERROTA
  • Deportivo Saprissa 0
  • CS Cartaginés 4
  • VICTORIA
  • Jicaral Sercoba 0
  • Deportivo Saprissa 1
3 Sporting FC Sporting FC 7 4 2 1 1 5 4
  • DERROTA
  • Sporting FC 2
  • CS Cartaginés 3
  • EMPATE
  • Limón 1
  • Sporting FC 1
  • VICTORIA
  • Sporting FC 1
  • Jicaral Sercoba 0
  • VICTORIA
  • Sporting FC 1
  • San Carlos 0
4 San Carlos San Carlos 5 4 1 2 1 4 4
  • VICTORIA
  • Jicaral Sercoba 0
  • San Carlos 1
  • EMPATE
  • San Carlos 1
  • Deportivo Saprissa 1
  • EMPATE
  • San Carlos 2
  • Limón 2
  • DERROTA
  • Sporting FC 1
  • San Carlos 0
5 Limón Limón 3 4 0 3 1 4 8
  • DERROTA
  • Deportivo Saprissa 4
  • Limón 0
  • EMPATE
  • Limón 1
  • Sporting FC 1
  • EMPATE
  • San Carlos 2
  • Limón 2
  • EMPATE
  • Limón 1
  • CS Cartaginés 1
6 Jicaral Sercoba Jicaral Sercoba 1 4 0 1 3 2 5
  • DERROTA
  • Jicaral Sercoba 0
  • San Carlos 1
  • EMPATE
  • CS Cartaginés 2
  • Jicaral Sercoba 2
  • DERROTA
  • Sporting FC 1
  • Jicaral Sercoba 0
  • DERROTA
  • Jicaral Sercoba 0
  • Deportivo Saprissa 1
Series Finales : LD Alajuelense, CS Herediano, CS Cartaginés, Deportivo
Playoff Descenso : Pérez Zeledón, Jicaral Sercoba
JUGADORES DESTACADOS

INFORMACIÓN

El campeonato de Invierno representa el máximo torneo de clubes en Costa Rica. El campeonato está integrado por 12 equipos. El campeonato comienza en agosto y termina en diciembre, cada equipo en temporada regular juega 16 partidos y los primeros dos lugares de cada grupo avanzan a la siguiente ronda, los primeros dos de cada grupo clasifican mientras que el tercero y cuarto clasificaran conforme estén ubicados en la tabla general.

  USO DE MEMORIA  
5,769,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3451
Total Execution Time  0.3471
  CADENA URL  
/invierno_costa_rica2021/grupo1/jornada4
  GET DATOS  
$_GET['/invierno_costa_rica2021/grupo1/jornada4']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=147 AND type_rel = 3
0.0150  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.0148  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.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 16:06:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 16:06:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 16:06:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 16:06:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-01" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 57720 ORDER BY creation_date DESC LIMIT 0, 10
0.0151  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-01" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 57720
0.0155  SELECT c.isVideo, c.id,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,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2021` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 57720 AND c.`round` = 4 ORDER BY shedule ASC LIMIT 200
0.0147  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2021 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2021 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 57720 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (30706,30702,30700,30708,30713,30703) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0297  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 `tables2021` 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 = 57720 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 57720 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  SELECT data1, data2 FROM services_tags WHERE categoryId=147
0.0155  SELECT group_code, extraName from `leagues` WHERE categoryId=147 AND year=2021