4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Santos de Guápiles - Limón
Jornada 20
FINALIZADO
42
52
577 Pts. Elo
2º

399 Pts. Elo
11º

3-2
Lunes, 26 Abril 2021, 03:00
0 - 1
 12' J. Vizcaino
O. Rodríguez 30'
1 - 1
D. López 42'
2 - 1
2 - 2
 45' J. Vizcaino
J. East 94'
3 - 2

Eventos del partido

Goles

minuto 12'J. VizcainoGol de J. Vizcaino
O. RodríguezGol de
O. Rodríguez
minuto 30'
D. LópezGol de
D. López
minuto 42'
minuto 45'J. VizcainoGol de J. Vizcaino
J. EastGol de
J. East
minuto 94'

Tarjetas

C. MenesesTarjeta Roja a
C. Meneses
minuto 10'
J. IngramT. Amarilla
J. Ingram
minuto 15'
minuto 29'C. VillegasT. Amarilla C. Villegas
minuto 33'K. McleanT. Amarilla K. Mclean
P. ArboineT. Amarilla
P. Arboine
minuto 33'
minuto 45'C. VillegasTarjeta Roja a C. Villegas
J. EastT. Amarilla
J. East
minuto 68'
minuto 72'L. PérezT. Amarilla L. Pérez
minuto 85'K. Mclean2a Amarilla y Roja K. Mclean
P. Arboine2a Amarilla y Roja
P. Arboine
minuto 85'
minuto 86'D. ArayaT. Amarilla D. Araya

Cambios

A. BennettSale del partido
A. Bennett
minuto 13'
J. IngramEntra en el partido
J. Ingram
minuto 13'
minuto 62'M. EsquivelSale del partido M. Esquivel
minuto 62'A. FrancisEntra en el partido A. Francis
minuto 62'K. ColeSale del partido K. Cole
minuto 62'D. ArayaEntra en el partido D. Araya
Brayan LópezSale del partido
Brayan López
minuto 72'
M. BarqueroEntra en el partido
M. Barquero
minuto 72'
E. MéndezEntra en el partido
E. Méndez
minuto 75'
Kenny CunninghamSale del partido
Kenny Cunningham
minuto 75'
minuto 77'Kevin CunninghamSale del partido Kevin Cunningham
minuto 77'J. GordonEntra en el partido J. Gordon
minuto 89'J. VizcainoSale del partido J. Vizcaino
minuto 89'J. HernándezEntra en el partido J. Hernández

Alineaciones

Santos de Guápiles

Santos de Guápiles

4-5-1
Alineación Inicial
Suplentes
Limón

Limón

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

Santos de Guápiles Santos Limón Limón
3
Goles
 2
4
Tarjetas Amarillas
 5
2
Tarjetas Rojas
 2
3
Sustituciones
 3


  USO DE MEMORIA  
6,715,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3039
Total Execution Time  0.3049
  CADENA URL  
/partido/Santos-Guapiles/Limon/2011?section=legal
  GET DATOS  
$_GET['/partido/Santos-Guapiles/Limon/2011']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0028   SELECT c.*, c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Santos-Guapiles' AND dt2.basealias = 'Limon'
0.0042   SELECT c.*, c.stadium as real_stadium, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Santos-Guapiles' AND dt2.basealias = 'Limon'
0.0022   SELECT c.*, c.stadium as real_stadium, 2023 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2023 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Santos-Guapiles' AND dt2.basealias = 'Limon'
0.0023   SELECT c.*, c.stadium as real_stadium, 2022 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2022 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Santos-Guapiles' AND dt2.basealias = 'Limon'
0.0018  SELECT data1 FROM stats2021 t WHERE league_id = 60632 AND teamId = 6418821 and type = 33
0.0017  SELECT data1 FROM stats2021 t WHERE league_id = 60632 AND teamId = 6418818 and type = 33
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '220158' and rp.type = 2021 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 220158 AND year = 2021 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 220158 AND year = 2021 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='220158' AND `active` = 1 AND year = 2021
0.0039  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='60632' AND relp.team_id=6418821 WHERE relp.in_squad=1 and mp.`match_id` = '220158' AND mp.year='2021' ORDER BY mp.`team` ASC, p.`role` ASC
0.0031  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='60632' AND relp.team_id=6418818 WHERE relp.in_squad=1 and mp.`match_id` = '220158' AND mp.year='2021' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=220158 AND extraId = 60632 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 220158 AND league_id = 60632 AND year = 2021