4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 6 11 4 14
2 Zamalek Zamalek 6 5 4 9
3 Primeiro de Agosto Primeiro 6 4 7 4
4 Zesco United Zesco United 6 5 10 3
5 Etoile Sahel Etoile Sahel 6 8 3 12
6 Al-Ahly Al-Ahly 6 7 4 11
7 Al-Hilal Omdurman Al-Hilal 6 7 6 10
8 FC Platinum FC Platinum 6 2 11 1
9 Mamelodi Sundowns Mamelodi 6 9 3 14
10 Wydad Casablanca Wydad 6 10 6 9
11 Petro de Luanda Petro Luanda 6 8 14 4
12 USM Alger USM Alger 6 6 10 3
13 ES Tunis ES Tunis 6 7 3 11
14 Raja Casablanca Raja 6 6 4 11
15 JS Kabylie JS Kabylie 6 3 7 7
16 AS Vita Club Vita Club 6 4 6 4
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Mamelodi Sundowns Mamelodi 6 9 5 10
2 Wydad Casablanca Wydad 6 8 6 10
3 Lobi Stars Lobi Stars 6 4 6 7
4 ASEC Mimosas ASEC Mimosas 6 6 10 7
5 ES Tunis ES Tunis 6 9 2 14
6 Horoya AC Horoya AC 6 6 7 10
7 Orlando Pirates Orlando 6 6 6 6
8 FC Platinum FC Platinum 6 3 9 2
9 TP Mazembe TP Mazembe 6 13 4 11
10 CS Constantine Constantine 6 8 6 10
11 Club Africain Club 6 4 10 10
12 Ismaily Ismaily 6 5 10 2
13 Al-Ahly Al-Ahly 6 11 3 10
14 Simba SC Simba SC 6 6 13 9
15 JS Saoura JS Saoura 6 6 9 8
16 AS Vita Club Vita Club 6 9 7 7
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 6 9 5 13
2 ES Tunis ES Tunis 6 8 4 11
3 KCCA FC KCCA FC 6 8 9 6
4 Township Rollers Township 6 2 9 4
5 TP Mazembe TP Mazembe 6 10 4 12
6 ES Setif ES Setif 6 7 9 8
7 Difaâ El Jadida Difaâ 6 6 7 6
8 MC Alger MC Alger 6 4 7 5
9 Wydad Casablanca Wydad 6 8 2 12
10 Horoya AC Horoya AC 6 7 7 9
11 Mamelodi Sundowns Mamelodi 6 5 6 6
12 Togo-Port Togo-Port 6 4 9 4
13 Etoile Sahel Etoile Sahel 6 10 4 12
14 Primeiro de Agosto Primeiro 6 6 5 9
15 Zesco United Zesco United 6 7 6 6
16 Mbabane Swallows Mbabane 6 3 11 4
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Etoile Sahel Etoile Sahel 6 13 4 12
2 Ferroviário Beira Ferroviário 6 6 8 8
3 Al-Merreikh SC Al-Merreikh 6 6 9 7
4 Al-Hilal Omdurman Al-Hilal 6 4 8 4
5 USM Alger USM Alger 6 12 5 11
6 Al Ahli Tripoli Ahli Tripoli 6 11 10 9
7 Zamalek Zamalek 6 6 8 6
8 CAPS United CAPS United 6 10 16 6
9 ES Tunis ES Tunis 6 11 4 12
10 Mamelodi Sundowns Mamelodi 6 6 4 9
11 AS Vita Club Vita Club 6 7 11 5
12 Kedus St George Kedus George 6 2 7 5
13 Wydad Casablanca Wydad 6 7 3 12
14 Al-Ahly Al-Ahly 6 7 3 11
15 Zanaco Zanaco 6 4 2 11
16 Cotonsport Cotonsport 6 2 12 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 6 6 3 11
2 Zesco United Zesco United 6 10 9 9
3 Al-Ahly Al-Ahly 6 6 7 6
4 ASEC Mimosas ASEC Mimosas 6 5 8 5
5 Mamelodi Sundowns Mamelodi 4 6 5 9
6 Zamalek Zamalek 4 3 3 6
7 Enyimba Enyimba 4 4 5 3
8 ES Setif ES Setif 0 0 0 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 6 8 1 11
2 Al-Hilal Omdurman Al-Hilal 6 5 3 9
3 Moghreb Tetouan Moghreb 6 6 10 8
4 Smouha SC Smouha SC 6 5 10 4
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 6 5 2 11
2 AS Vita Club Vita Club 6 6 4 11
3 Al-Hilal Omdurman Al-Hilal 6 7 9 7
4 Zamalek Zamalek 6 4 7 4
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 6 8 7 11
2 Orlando Pirates Orlando 6 8 4 8
3 Zamalek Zamalek 6 10 12 7
4 Léopards de Dolisié Léopards 6 4 7 7
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 4 6 3 9
2 Sunshine Stars Sunshine 4 4 4 6
3 Chlef Chlef 4 4 7 3
4 Etoile Sahel Etoile Sahel 0 0 0 0
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Enyimba Enyimba 6 11 5 14
2 Al-Hilal Omdurman Al-Hilal 6 6 7 8
3 Cotonsport Cotonsport 6 7 8 7
4 Raja Casablanca Raja 6 1 5 3
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 6 9 4 13
2 TP Mazembe TP Mazembe 6 8 7 11
3 ES Setif ES Setif 6 7 6 6
4 Dynamos Dynamos 6 2 9 3
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Kano Pillars Kano Pillars 6 10 8 11
2 Al-Hilal Omdurman Al-Hilal 6 7 5 10
3 Zesco United Zesco United 6 8 7 8
4 Al-Merreikh SC Al-Merreikh 6 5 10 3
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 6 9 6 12
2 Dynamos Dynamos 6 6 6 9
3 ASEC Mimosas ASEC Mimosas 6 7 6 6
4 Zamalek Zamalek 6 4 8 5
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Etoile Sahel Etoile Sahel 6 6 2 11
2 Al Ittihad Tripoli Ittihad 6 6 4 10
3 JS Kabylie JS Kabylie 6 6 8 7
4 FAR Rabat FAR Rabat 6 2 6 5
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 CS Sfaxien CS Sfaxien 6 9 7 12
2 Al-Ahly Al-Ahly 6 10 4 11
3 Asante Kotoko Asante 6 7 10 7
4 JS Kabylie JS Kabylie 6 4 9 4
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 6 7 2 14
2 Raja Casablanca Raja 6 6 5 8
3 Enyimba Enyimba 6 6 5 7
4 Cape Town Spurs Cape Town S. 6 2 9 3
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Etoile Sahel Etoile Sahel 6 8 5 11
2 Enyimba Enyimba 6 11 4 8
3 Africa Sports Africa 6 6 10 7
4 Big Bullets Big Bullets 6 5 11 6
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Enyimba Enyimba 6 14 11 12
2 Ismaily Ismaily 6 13 7 11
3 Simba SC Simba SC 6 7 10 7
4 ASEC Mimosas ASEC Mimosas 6 6 12 4
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Raja Casablanca Raja 6 10 8 13
2 TP Mazembe TP Mazembe 6 6 3 10
3 Jeanne d'Arc Jeanne d'Arc 6 7 10 6
4 Al-Ahly Al-Ahly 6 7 9 5
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 6 8 7 9
2 Mamelodi Sundowns Mamelodi 6 2 2 9
3 Berger Berger 6 6 6 7
4 TP Mazembe TP Mazembe 6 5 6 7
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 ES Tunis ES Tunis 6 12 7 12
2 Mamelodi Sundowns Mamelodi 6 11 11 12
3 Africa Sports Africa 6 12 8 10
4 Sable Batié Sable Batié 6 5 14 1

  USO DE MEMORIA  
5,875,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.1091
Total Execution Time  0.1113
  CADENA URL  
/liga_campeones_caf2020/grupo1/historico
  GET DATOS  
$_GET['/liga_campeones_caf2020/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0019  SELECT type FROM routes WHERE alias = 'liga_campeones_caf2020'
0.0042  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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0023  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1508 AND group_code = 1 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0024  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 `tables2020` 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 = 51595 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
0.0026  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 `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 = 48609 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 `tables2018` 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 = 43139 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables2017` 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 = 38329 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2016` 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 = 29517 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2015` 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 = 13785 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2014` 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 = 12420 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2013` 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 = 12417 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2012` 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 = 12414 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2011` 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 = 12412 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2010` 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 = 12408 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2009` 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 = 12273 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2008` 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 = 12318 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables2007` 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 = 12270 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2006` 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 = 12162 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2005` 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 = 12159 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2004` 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 = 27277 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables2003` 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 = 27285 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables2002` 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 = 27292 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2001` 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 = 27298 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables2000` 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 = 27308 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 10:17:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 10:17:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 10:17:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 10:17:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0029  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 51595 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