4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
06 Sep 19 GranadaGranada 2 - 1 San Cristóbal y NievesCristóbal 3
05 Sep 19 DominicaDominica 1 - 2 SurinamSurinam 3
06 Sep 19 Guayana FrancesaGuayana 3 - 0 BeliceBelice 5
06 Sep 19 NicaraguaNicaragua 1 - 1 S. Vicente y las GranadinasVicente 33
07 Sep 19 ArubaAruba 0 - 1 GuyanaGuyana 5
07 Sep 19 JamaicaJamaica 6 - 0 Antigua y BarbudaAntigua 5
07 Sep 19 MontserratMontserrat 2 - 1 República DominicanaRepública 11
08 Sep 19 El SalvadorSalvador 3 - 0 Santa LucíaSanta 17
Ver jornada
Jornada 2
09 Sep 19 BeliceBelice 1 - 2 GranadaGranada 5
08 Sep 19 S. Vicente y las GranadinasVicente 1 - 0 DominicaDominica 1
09 Sep 19 SurinamSurinam 6 - 0 NicaraguaNicaragua 16
09 Sep 19 San Cristóbal y NievesCristóbal 2 - 2 Guayana FrancesaGuayana 1
09 Sep 19 Antigua y BarbudaAntigua 2 - 1 ArubaAruba 3
10 Sep 19 GuyanaGuyana 0 - 4 JamaicaJamaica 14
10 Sep 19 MontserratMontserrat 1 - 1 Santa LucíaSanta 5
11 Sep 19 República DominicanaRepública 1 - 0 El SalvadorSalvador 53
Ver jornada
Jornada 3
11 Oct 19 BeliceBelice 0 - 4 San Cristóbal y NievesCristóbal 12
11 Oct 19 Guayana FrancesaGuayana 0 - 0 GranadaGranada 9
11 Oct 19 S. Vicente y las GranadinasVicente 2 - 2 SurinamSurinam 12
11 Oct 19 Antigua y BarbudaAntigua 2 - 1 GuyanaGuyana 22
12 Oct 19 NicaraguaNicaragua 3 - 1 DominicaDominica 12
13 Oct 19 República DominicanaRepública 3 - 0 Santa LucíaSanta 12
13 Oct 19 JamaicaJamaica 2 - 0 ArubaAruba 13
13 Oct 19 MontserratMontserrat 0 - 2 El SalvadorSalvador 28
Ver jornada
Jornada 4
14 Oct 19 San Cristóbal y NievesCristóbal 0 - 1 BeliceBelice 26
14 Oct 19 GranadaGranada 1 - 0 Guayana FrancesaGuayana 3
15 Oct 19 SurinamSurinam 0 - 1 S. Vicente y las GranadinasVicente 4
14 Oct 19 DominicaDominica 0 - 4 NicaraguaNicaragua 11
15 Oct 19 GuyanaGuyana 5 - 1 Antigua y BarbudaAntigua 9
16 Oct 19 República DominicanaRepública 0 - 0 MontserratMontserrat 12
15 Oct 19 Santa LucíaSanta 0 - 2 El SalvadorSalvador 26
16 Oct 19 ArubaAruba 0 - 6 JamaicaJamaica 17
Ver jornada
Jornada 5
14 Nov 19 San Cristóbal y NievesCristóbal 0 - 0 GranadaGranada 5
15 Nov 19 BeliceBelice 2 - 0 Guayana FrancesaGuayana 30
15 Nov 19 S. Vicente y las GranadinasVicente 1 - 0 NicaraguaNicaragua 17
16 Nov 19 Antigua y BarbudaAntigua 0 - 2 JamaicaJamaica 27
15 Nov 19 SurinamSurinam 4 - 0 DominicaDominica 1
16 Nov 19 GuyanaGuyana 4 - 2 ArubaAruba 7
17 Nov 19 Santa LucíaSanta 1 - 0 República DominicanaRepública 17
17 Nov 19 El SalvadorSalvador 1 - 0 MontserratMontserrat 41
Ver jornada
Jornada 6
18 Nov 19 GranadaGranada 3 - 2 BeliceBelice 5
17 Nov 19 Guayana FrancesaGuayana 3 - 1 San Cristóbal y NievesCristóbal 3
18 Nov 19 DominicaDominica 1 - 0 S. Vicente y las GranadinasVicente 19
19 Nov 19 ArubaAruba 2 - 3 Antigua y BarbudaAntigua 22
19 Nov 19 JamaicaJamaica 1 - 1 GuyanaGuyana 58
19 Nov 19 NicaraguaNicaragua 1 - 2 SurinamSurinam 48
19 Nov 19 El SalvadorSalvador 2 - 0 República DominicanaRepública 31
19 Nov 19 Santa LucíaSanta 0 - 1 MontserratMontserrat 26

Clasificación

Equipo PJ GF GC Puntos
1 Granada Granada 6 8 4 14
2 Guayana Francesa Guayana 6 8 6 8
3 Belice Belice 6 6 12 6
4 San Cristóbal y Nieves Cristóbal 6 8 8 5
5 El Salvador El Salvador 6 10 1 15
6 Montserrat Montserrat 6 4 5 8
7 República Dominicana República 6 5 5 7
8 Santa Lucía Santa Lucía 6 2 10 4
9 Jamaica Jamaica 6 21 1 16
10 Guyana Guyana 6 12 10 10
11 Antigua y Barbuda Antigua 6 8 17 9
12 Aruba Aruba 6 5 18 0
13 Surinam Surinam 6 16 5 13
14 S. Vicente y las Granadinas Vicente 6 6 4 11
15 Nicaragua Nicaragua 6 9 11 7
16 Dominica Dominica 6 3 14 3

  USO DE MEMORIA  
5,088,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1071
Total Execution Time  0.1090
  CADENA URL  
/liga_de_las_naciones_concacaf2019/grupo3/calendario
  GET DATOS  
$_GET['/liga_de_las_naciones_concacaf2019/grupo3/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0022  SELECT type FROM routes WHERE alias = 'liga_de_las_naciones_concacaf2019'
0.0050  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_de_las_naciones_concacaf' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0022  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2028 ORDER BY order_id ASC
0.0035  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 calendars2019 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 49343 ORDER BY round ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:32:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:32:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:32:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:32:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_de_las_naciones_concacaf' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0024  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2028 AND l.year = 2019
0.0052  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (43035,49342,49343,49344,52028) 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, e.player_id ASC LIMIT 10
0.0078  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (43035,49342,49343,49344,52028) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (410400,278799,30297,219331,272860,309129,24926,179500,210775,217983) ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2028 AND l.year = 2019
0.0035  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (43035,49342,49343,49344,52028) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0033  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (43035,49342,49343,49344,52028) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (307447,68933,126509,211188,214733,260748,274440,278362,278581,283485) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2028 AND l.year = 2019
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2019 e WHERE e.league_id IN (43035,49342,49343,49344,52028) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0032  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (43035,49342,49343,49344,52028) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (4682,68933,136041,139561,209578,211188,221403,246335,247606,278694) ORDER BY rp.in_squad = 1 DESC
0.0035  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 49343 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC