4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Deportivo Cali Deportivo 17 30 17 33
2 Cúcuta Deportivo Cúcuta 17 28 16 33
3 Millonarios Millonarios 18 26 17 30
4 Boyacá Chicó Boyacá 18 20 16 30
5 At. Nacional Nacional 17 30 20 29
6 Santa Fe Santa Fe 18 23 21 29
7 Independiente Medellín Independient 17 30 28 28
8 Atlético Huila Atlético 18 24 23 28
9 Atlético Bucaramanga Atlético 18 23 21 27
10 Deportivo Pasto Deportivo 18 19 21 23
11 Junior Junior 18 22 26 23
12 Deportes Tolima Deportes 18 26 28 20
13 América de Cali América 18 24 35 19
14 Once Caldas Once Caldas 18 18 25 18
15 Deportes Quindío Deportes 18 14 22 18
16 Deportivo Pereira Deportivo 17 14 19 15
17 Real Cartagena Real 17 13 22 14
18 La Equidad La Equidad 18 21 28 13
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Cúcuta Deportivo Cúcuta 18 29 14 37
2 Once Caldas Once Caldas 17 29 13 36
3 Deportes Tolima Deportes 18 36 19 32
4 At. Nacional Nacional 18 27 19 30
5 Deportivo Pereira Deportivo 18 20 15 29
6 Millonarios Millonarios 18 27 23 28
7 Deportivo Cali Deportivo 18 20 17 28
8 Deportivo Pasto Deportivo 18 27 21 27
9 Deportes Quindío Deportes 18 17 15 27
10 América de Cali América 18 20 25 27
11 Envigado Envigado 18 20 22 22
12 Atlético Bucaramanga Atlético 18 16 23 21
13 Santa Fe Santa Fe 18 24 32 20
14 Atlético Huila Atlético 18 17 32 20
15 Boyacá Chicó Boyacá 17 17 21 17
16 Junior Junior 17 22 29 16
17 Independiente Medellín Independient 17 14 26 14
18 Real Cartagena Real 18 14 30 7
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 América de Cali América 0 0 0 0
2 At. Nacional Nacional 0 0 0 0
3 Atlético Bucaramanga Atlético 0 0 0 0
4 Atlético Huila Atlético 0 0 0 0
5 Boyacá Chicó Boyacá 0 0 0 0
6 Deportes Quindío Deportes 0 0 0 0
7 Deportes Tolima Deportes 0 0 0 0
8 Deportivo Cali Deportivo 0 0 0 0
9 Deportivo Pasto Deportivo 0 0 0 0
10 Deportivo Pereira Deportivo 0 0 0 0
11 Envigado Envigado 0 0 0 0
12 Independiente Medellín Independient 0 0 0 0
13 Junior Junior 0 0 0 0
14 Millonarios Millonarios 0 0 0 0
15 Once Caldas Once Caldas 0 0 0 0
16 Real Cartagena Real 0 0 0 0
17 Santa Fe Santa Fe 0 0 0 0
18 Unión Magdalena Unión 0 0 0 0
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 América de Cali América 18 30 17 37
2 Deportivo Cali Deportivo 18 23 15 34
3 At. Nacional Nacional 18 30 23 33
4 Once Caldas Once Caldas 18 23 14 31
5 Independiente Medellín Independient 18 20 19 29
6 Junior Junior 17 23 15 27
7 Boyacá Chicó Boyacá 18 25 24 27
8 Deportivo Pasto Deportivo 18 18 19 27
9 Deportivo Pereira Deportivo 18 21 18 26
10 Deportes Tolima Deportes 18 20 17 26
11 Millonarios Millonarios 17 22 22 23
12 Atlético Bucaramanga Atlético 18 22 25 21
13 Atlético Huila Atlético 17 20 24 19
14 Internacional de Palmira Internaciona 18 27 32 19
15 Santa Fe Santa Fe 18 16 24 17
16 Deportes Quindío Deportes 18 11 23 15
17 Envigado Envigado 18 19 26 14
18 Unión Magdalena Unión 17 15 28 10
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Once Caldas Once Caldas 18 24 14 33
2 América de Cali América 17 30 20 31
3 Millonarios Millonarios 18 23 14 31
4 Centauros Centauros 18 24 21 29
5 Deportivo Cali Deportivo 18 27 22 28
6 Junior Junior 18 19 18 27
7 Atlético Huila Atlético 18 22 22 26
8 Independiente Medellín Independient 18 29 23 25
9 Unión Magdalena Unión 17 22 22 25
10 Deportivo Pereira Deportivo 17 21 24 25
11 Atlético Bucaramanga Atlético 18 19 19 23
12 Envigado Envigado 18 20 23 22
13 At. Nacional Nacional 18 16 18 21
14 Deportes Tolima Deportes 17 22 24 19
15 Deportivo Pasto Deportivo 18 15 18 19
16 Santa Fe Santa Fe 18 15 23 18
17 Internacional de Palmira Internaciona 18 15 24 15
18 Deportes Quindío Deportes 18 12 26 14
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Deportivo Cali Deportivo 22 44 24 39
2 Santa Fe Santa Fe 22 26 13 38
3 At. Nacional Nacional 22 24 18 38
4 Envigado Envigado 22 21 18 36
5 Deportivo Pasto Deportivo 22 29 27 34
6 América de Cali América 22 27 22 33
7 Atlético Bucaramanga Atlético 22 24 22 33
8 Unión Magdalena Unión 22 27 27 33
9 Once Caldas Once Caldas 22 36 29 32
10 Deportivo Pereira Deportivo 22 20 16 32
11 Deportes Quindío Deportes 22 24 30 30
12 Junior Junior 22 19 25 26
13 Millonarios Millonarios 22 17 21 23
14 Atlético Huila Atlético 22 21 32 22
15 Independiente Medellín Independient 22 26 32 21
16 Internacional de Palmira Internaciona 22 16 25 21
17 Real Cartagena Real 22 17 25 20
18 Deportes Tolima Deportes 22 18 30 18

  USO DE MEMORIA  
5,770,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3770
Total Execution Time  0.3790
  CADENA URL  
/apertura_colombia2007/grupo1/historico
  GET DATOS  
$_GET['/apertura_colombia2007/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0110  SELECT type FROM routes WHERE alias = 'apertura_colombia2007'
0.0223  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_colombia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=42 AND type_rel = 3
0.0320  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 42 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0121  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1314553,1314394,1314044,1313813,1313677) ORDER BY n.cover_points DESC, update_date DESC
0.0110  SELECT id,name,alias,stepParent FROM categories WHERE parentId=42 ORDER BY order_id ASC
0.0114  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 = 12998 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 42 AND group_code = 1 and tables = 1 AND year <= 2007 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0115  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 = 12998 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 12993 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 12988 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 12984 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 12981 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 23447 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 02:30:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 02:30:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 02:30:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 02:30:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0118  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_colombia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0111  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 12998 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12998 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 LIMIT 10
0.0108  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 12998 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12998 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0108  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 12998 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12998 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0129  SELECT *,(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 = 12998 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC