Jornada 1
05 Mar 22 Al-AhlyAl-Ahly 3 - 2 Al-Merreikh SCAl-Merreikh 3
11 Feb 22 Mamelodi SundownsMamelodi 1 - 0 Al-Hilal OmdurmanAl-Hilal 12
12 Feb 22 Raja CasablancaRaja 1 - 0 AmaZuluAmaZulu ...
12 Feb 22 Horoya ACHoroya AC 0 - 1 ES SetifES Setif ...
12 Feb 22 ES TunisES Tunis 4 - 0 Galaxy FCGalaxy FC ...
11 Feb 22 Etoile SahelEtoile 0 - 0 CR BelouizdadBelouizdad 12
11 Feb 22 Wydad CasablancaWydad 3 - 0 Sagrada EsperançaSagrada ...
12 Feb 22 ZamalekZamalek 2 - 2 Petro de LuandaPetro 5
Jornada 2
18 Feb 22 Al-Hilal OmdurmanAl-Hilal 0 - 0 Al-AhlyAl-Ahly 8
19 Feb 22 Al-Merreikh SCAl-Merreikh 0 - 0 Mamelodi SundownsMamelodi 1
18 Feb 22 ES SetifES Setif 0 - 1 Raja CasablancaRaja 17
18 Feb 22 AmaZuluAmaZulu 1 - 0 Horoya ACHoroya AC 1
19 Feb 22 CR BelouizdadBelouizdad 1 - 1 ES TunisES Tunis ...
19 Feb 22 Galaxy FCGalaxy FC 1 - 1 Etoile SahelEtoile ...
19 Feb 22 Petro de LuandaPetro 2 - 1 Wydad CasablancaWydad ...
19 Feb 22 Sagrada EsperançaSagrada 0 - 0 ZamalekZamalek ...
Jornada 3
25 Feb 22 Al-Merreikh SCAl-Merreikh 2 - 1 Al-Hilal OmdurmanAl-Hilal 2
26 Feb 22 Al-AhlyAl-Ahly 0 - 1 Mamelodi SundownsMamelodi 2
25 Feb 22 AmaZuluAmaZulu 1 - 0 ES SetifES Setif ...
25 Feb 22 Raja CasablancaRaja 1 - 0 Horoya ACHoroya AC 5
26 Feb 22 Galaxy FCGalaxy FC 1 - 2 CR BelouizdadBelouizdad ...
26 Feb 22 ES TunisES Tunis 0 - 0 Etoile SahelEtoile 1
26 Feb 22 Sagrada EsperançaSagrada 0 - 1 Petro de LuandaPetro ...
26 Feb 22 Wydad CasablancaWydad 3 - 1 ZamalekZamalek 1
Jornada 4
11 Mar 22 Al-Hilal OmdurmanAl-Hilal 1 - 0 Al-Merreikh SCAl-Merreikh 13
12 Mar 22 Mamelodi SundownsMamelodi 1 - 0 Al-AhlyAl-Ahly 1
12 Mar 22 ES SetifES Setif 2 - 0 AmaZuluAmaZulu ...
12 Mar 22 Horoya ACHoroya AC 2 - 1 Raja CasablancaRaja ...
11 Mar 22 CR BelouizdadBelouizdad 4 - 1 Galaxy FCGalaxy FC ...
12 Mar 22 Etoile SahelEtoile 0 - 2 ES TunisES Tunis ...
12 Mar 22 Petro de LuandaPetro 3 - 0 Sagrada EsperançaSagrada ...
11 Mar 22 ZamalekZamalek 0 - 1 Wydad CasablancaWydad 36
Jornada 5
18 Mar 22 Al-Merreikh SCAl-Merreikh 1 - 3 Al-AhlyAl-Ahly 5
19 Mar 22 Al-Hilal OmdurmanAl-Hilal 2 - 4 Mamelodi SundownsMamelodi ...
18 Mar 22 AmaZuluAmaZulu 0 - 2 Raja CasablancaRaja 2
18 Mar 22 ES SetifES Setif 3 - 2 Horoya ACHoroya AC ...
19 Mar 22 Galaxy FCGalaxy FC 0 - 3 ES TunisES Tunis ...
19 Mar 22 CR BelouizdadBelouizdad 2 - 0 Etoile SahelEtoile ...
19 Mar 22 Sagrada EsperançaSagrada 1 - 2 Wydad CasablancaWydad 4
19 Mar 22 Petro de LuandaPetro 0 - 0 ZamalekZamalek 1
Jornada 6
03 Abr 22 Al-AhlyAl-Ahly 1 - 0 Al-Hilal OmdurmanAl-Hilal 1
02 Abr 22 Mamelodi SundownsMamelodi 3 - 0 Al-Merreikh SCAl-Merreikh ...
03 Abr 22 Raja CasablancaRaja 1 - 0 ES SetifES Setif 1
01 Abr 22 Horoya ACHoroya AC 1 - 1 AmaZuluAmaZulu 6
02 Abr 22 ES TunisES Tunis 2 - 1 CR BelouizdadBelouizdad ...
01 Abr 22 Etoile SahelEtoile 3 - 2 Galaxy FCGalaxy FC 9
02 Abr 22 Wydad CasablancaWydad 5 - 1 Petro de LuandaPetro ...
01 Abr 22 ZamalekZamalek 0 - 0 Sagrada EsperançaSagrada 11
Clasificación
Equipo PJ GF GC Puntos
1 Mamelodi Sundowns Mamelodi 6 10 2 16
2 Al-Ahly Al-Ahly 6 7 5 10
3 Al-Hilal Omdurman Al-Hilal 6 4 8 4
4 Al-Merreikh SC Al-Merreikh 6 5 11 4
5 Raja Casablanca Raja 6 7 2 15
6 ES Setif ES Setif 6 6 5 9
7 AmaZulu AmaZulu 6 3 6 7
8 Horoya AC Horoya AC 6 5 8 4
9 ES Tunis ES Tunis 6 12 2 14
10 CR Belouizdad Belouizdad 6 10 5 11
11 Etoile Sahel Etoile Sahel 6 4 7 6
12 Galaxy FC Galaxy FC 6 5 17 1
13 Wydad Casablanca Wydad 6 15 5 15
14 Petro de Luanda Petro Luanda 6 9 8 11
15 Zamalek Zamalek 6 3 6 4
16 Sagrada Esperança Sagrada 6 1 9 2
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,154,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3386
Total Execution Time  0.3407
  CADENA URL  
/liga_campeones_caf2022/grupo1/calendario
  GET DATOS  
$_GET['/liga_campeones_caf2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0104  SELECT type FROM routes WHERE alias = 'liga_campeones_caf2022'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_campeones_caf' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0107  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 = 66253 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111  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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 66253 ORDER BY round ASC
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 13:00:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 13:00:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 13:00:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 13:00:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0123  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_campeones_caf' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0116  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1508 AND l.year = 2022
0.0124  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (66253,67220) 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.0128  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 (66253,67220) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (249052,179845,197967,302299,463096,667355,213646,221582,245993,297502) ORDER BY rp.in_squad = 1 DESC
0.0116  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1508 AND l.year = 2022
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (66253,67220) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0136  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 (66253,67220) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (302299,375802,396096,3144561,3203069,3274404,187640,187647,275013,288448) ORDER BY rp.in_squad = 1 DESC
0.0116  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1508 AND l.year = 2022
0.0116  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (66253,67220) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0117  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 (66253,67220) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (81194,159420,187647,273962,295505,308416,321755,328752,448416,843980) ORDER BY rp.in_squad = 1 DESC
0.0123  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66253 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC