4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Unión Magdalena Unión 18 25 12 33
2 Deportivo Rionegro Deportivo 18 31 21 33
3 Real Cundinamarca Real 18 21 18 30
4 La Sabana La Sabana 18 17 19 27
5 Real Cartagena Real 18 24 23 24
6 Real Santander Real 18 17 20 20
7 Barranquilla Barranquilla 18 12 17 20
8 Águilas Doradas Águilas 18 13 21 17
9 Alianza FC Alianza FC 18 17 31 14
10 Bogotá Bogotá 18 31 11 36
11 Atlético Fútbol Club Atlético 18 25 19 29
12 Centauros Centauros 18 24 21 28
13 Fortaleza Fortaleza 18 19 17 28
14 Patriotas Boyacá Patriotas 18 22 27 23
15 Sucre FC Sucre FC 18 24 24 21
16 Tigres FC Tigres FC 18 16 23 20
17 Academia Academia 18 21 25 19
18 Internacional de Palmira Internaciona 18 15 25 11
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Envigado Envigado 18 27 15 31
2 Bogotá Bogotá 18 27 19 30
3 Real Cundinamarca Real 18 23 19 30
4 Academia Academia 18 21 14 29
5 Unión Magdalena Unión 18 17 13 29
6 Patriotas Boyacá Patriotas 18 27 18 28
7 Deportivo Rionegro Deportivo 18 25 25 28
8 Barranquilla Barranquilla 18 24 15 27
9 Atlético Bello Atlético 18 25 16 26
10 Águilas Doradas Águilas 18 26 29 24
11 Atlético Fútbol Club Atlético 18 15 21 24
12 Internacional de Palmira Internaciona 18 15 15 23
13 Real Santander Real 18 17 18 23
14 Centauros Centauros 18 21 25 23
15 La Sabana La Sabana 18 17 18 22
16 Tigres FC Tigres FC 18 20 24 20
17 Sucre FC Sucre FC 18 15 20 20
18 Alianza FC Alianza FC 18 13 51 6
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Unión Magdalena Unión 18 27 9 40
2 La Equidad La Equidad 18 24 15 36
3 Academia Academia 18 29 13 34
4 Atlético Fútbol Club Atlético 18 23 19 30
5 Real Cundinamarca Real 18 17 18 30
6 Patriotas Boyacá Patriotas 18 28 17 29
7 Internacional de Palmira Internaciona 18 26 23 29
8 Águilas Doradas Águilas 18 17 19 27
9 La Sabana La Sabana 18 19 22 23
10 Alianza FC Alianza FC 18 19 17 22
11 Tigres FC Tigres FC 18 18 19 22
12 Centauros Centauros 18 12 15 21
13 Deportivo Rionegro Deportivo 18 14 21 19
14 Sucre FC Sucre FC 18 21 28 17
15 Atlético Bello Atlético 18 13 23 16
16 Barranquilla Barranquilla 18 17 21 15
17 Bogotá Bogotá 18 12 26 14
18 Pumas de Casanare Pumas 18 22 33 13

  USO DE MEMORIA  
5,331,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.3311
Total Execution Time  0.3337
  CADENA URL  
/apertura_primera_b_colombia2008/grupo1/historico
  GET DATOS  
$_GET['/apertura_primera_b_colombia2008/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0114  SELECT type FROM routes WHERE alias = 'apertura_primera_b_colombia2008'
0.0222  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_b_colombia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0111  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=196 AND type_rel = 3
0.0114  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 196 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0120  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 (1280990,1223665,1162446,1152331,1076557) ORDER BY n.cover_points DESC, update_date DESC
0.0113  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=196 ORDER BY l.group_code ASC
0.0106  SELECT id,name,alias,stepParent FROM categories WHERE parentId=196 ORDER BY order_id ASC
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 = 13579 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 196 AND group_code = 1 and tables = 1 AND year <= 2008 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 13579 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 13573 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 13568 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 10:31:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 10:31:22' 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=4 AND last_update > '2024-05-05 10:31:22' 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=3 AND last_update > '2024-05-05 10:31:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_b_colombia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2008 e ON e.player_id = p.id AND e.league_id = 13579 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13579 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.0109  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 events2008 e ON e.player_id = p.id AND e.league_id = 13579 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13579 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0110  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 events2008 e ON e.player_id = p.id AND e.league_id = 13579 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 13579 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0151  SELECT *,(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 = 13579 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC