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 Manchester City Manchester 6 16 4 14
2 Atalanta Atalanta 6 8 12 7
3 Shakhtar Donetsk Shakhtar 6 8 13 6
4 Dinamo Zagreb Dinamo 6 10 13 5
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 PSG PSG 6 17 9 11
2 Liverpool Liverpool 6 9 7 9
3 Napoli Napoli 6 7 5 9
4 Crvena Zvezda Crvena 6 5 17 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Roma Roma 6 9 6 11
2 Chelsea Chelsea 6 16 8 11
3 Atlético Atlético 6 5 4 7
4 Qarabağ Qarabağ 6 2 14 2
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 6 20 4 15
2 Manchester City Manchester 6 12 10 9
3 B. Mönchengladbach Mönchenglad 6 5 12 5
4 Celtic Celtic 6 5 16 3
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Atlético Atlético 6 11 3 13
2 Benfica Benfica 6 10 8 10
3 Galatasaray SK Galatasaray 6 6 10 5
4 Astana Astana 6 5 11 4
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Monaco Monaco 6 4 1 11
2 B. Leverkusen Leverkusen 6 7 4 10
3 Zenit Zenit 6 4 6 7
4 Benfica Benfica 6 2 6 5
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 PSG PSG 6 16 5 13
2 Olympiacos Piraeus Olympiacos 6 10 8 10
3 Benfica Benfica 6 8 8 10
4 Anderlecht Anderlecht 6 4 17 1
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Málaga Málaga 6 12 5 12
2 Milan Milan 6 7 6 8
3 Zenit Zenit 6 6 9 7
4 Anderlecht Anderlecht 6 4 9 5
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Benfica Benfica 6 8 4 12
2 Basel Basel 6 11 10 11
3 Manchester United Manchester 6 11 8 9
4 Oțelul Galați Oțelul 6 3 11 0
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Manchester United Manchester 6 7 1 14
2 Valencia Valencia 6 15 4 11
3 Rangers FC Rangers FC 6 3 6 6
4 Bursaspor Bursaspor 6 2 16 1
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 6 15 7 13
2 Milan Milan 6 8 7 9
3 Olympique Marseille Olympique 6 10 10 7
4 Zurich Zurich 6 5 14 4
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 6 18 8 13
2 Sporting CP Sporting CP 6 8 8 12
3 Shakhtar Donetsk Shakhtar 6 11 7 9
4 Basel Basel 6 2 16 1
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 6 13 9 11
2 Olympiacos Piraeus Olympiacos 6 11 7 11
3 Werder Bremen Werder 6 8 13 6
4 Lazio Lazio 6 8 11 5
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Liverpool Liverpool 6 11 5 13
2 PSV PSV 6 6 6 10
3 Girondins Bordeaux Girondins 6 6 7 7
4 Galatasaray SK Galatasaray 6 7 12 4
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 6 16 2 16
2 Werder Bremen Werder 6 12 12 7
3 Udinese Udinese 6 10 12 7
4 Panathinaikos Panathinaiko 6 4 16 4
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Juventus Juventus 6 6 1 16
2 Bayern München Bayern 6 12 5 10
3 Ajax Ajax 6 6 10 4
4 Maccabi Tel Aviv Maccabi Aviv 6 4 12 4
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Monaco Monaco 6 15 6 11
2 RC Deportivo Deportivo 6 12 12 10
3 PSV PSV 6 8 7 10
4 AEK Athens AEK Athens 6 1 11 2
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 6 15 7 9
2 Roma Roma 6 3 4 9
3 AEK Athens AEK Athens 6 7 7 6
4 Genk Genk 6 2 9 4
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 6 8 3 12
2 Arsenal Arsenal 6 9 9 9
3 Mallorca Mallorca 6 4 9 9
4 Schalke 04 Schalke 04 6 9 9 6
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Valencia Valencia 6 7 4 13
2 Olympique Lyonnais Olympique 6 8 6 9
3 Olympiacos Piraeus Olympiacos 6 6 5 9
4 Heerenveen Heerenveen 6 3 9 4
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Rosenborg BK Rosenborg 6 12 5 11
2 Feyenoord Feyenoord 6 7 6 8
3 B. Dortmund B. Dortmund 6 7 9 6
4 Boavista Boavista 6 4 10 5
Ver
TEMPORADA 1998/1999
Equipo PJ GF GC Puntos
1 Inter Inter 6 9 5 13
2 Real Madrid Real Madrid 6 17 8 12
3 Spartak Moskva Spartak 6 7 6 8
4 Sturm Graz Sturm Graz 6 2 16 1

  USO DE MEMORIA  
5,117,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.5532
Total Execution Time  0.5564
  CADENA URL  
/champions2020/grupo3/historico
  GET DATOS  
$_GET['/champions2020/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0147  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 = 51185 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 107 AND group_code = 3 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0146  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 = 51185 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.0147  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 = 44984 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 39618 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 34710 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 16730 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 4232 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 2827 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 2143 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 1445 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 1243 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 942 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 728 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 3617 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 9603 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 9612 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 9620 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 9630 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 9640 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 9655 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 9670 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 9683 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1999` 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 = 9696 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 18:37:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 18:37:14' 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-04-28 18:37:14' 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-04-28 18:37:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0155  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 = 51185 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