4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2012
Temporada Siguiente »
Clausura Primera B Colombia 2012
2011/2012

torneo aguila clausura, clausura torneo aguila, primera b clausura, clausura primera b colombia, primera b colombiana clausura, segunda colombia clausura, segunda colombiana clausura,b colombiana

Clausura Primera B Colombia 2012

  • Deportivo Pereira
  • Alianza FC
  • América de Cali
  • Deportivo Rionegro
  • Universitario Popayán
  • Internacional de Palmira
  • Uniautónoma
  • Atlético Bucaramanga
  • Real Cundinamarca
  • Sucre FC
  • Bogotá
  • Unión Magdalena
  • Atlético Fútbol Club
  • Fortaleza
  • Tigres FC
  • Real Santander
  • Barranquilla
  • Llaneros
  • Primera B
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Deportivo Pereira Deportivo 18 37 14 43
2 Alianza FC Alianza FC 18 35 18 34
3 América de Cali América 18 31 18 34
4 Deportivo Rionegro Deportivo 18 25 19 31
5 Universitario Popayán Universitari 18 20 21 30
6 Internacional de Palmira Internaciona 18 27 25 29
7 Uniautónoma Uniautónoma 18 23 20 27
8 Atlético Bucaramanga Atlético 18 22 24 27
9 Real Cundinamarca Real 18 15 12 25
10 Sucre FC Sucre FC 18 19 22 25
11 Bogotá Bogotá 18 22 30 23
12 Unión Magdalena Unión 18 19 20 21
13 Atlético Fútbol Club Atlético 18 22 25 19
14 Fortaleza Fortaleza 18 14 18 19
15 Tigres FC Tigres FC 18 12 18 16
16 Real Santander Real 18 22 31 16
17 Barranquilla Barranquilla 18 22 37 15
18 Llaneros Llaneros 18 11 26 13
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Deportivo Pasto Deportivo 18 32 15 34
2 Centauros Centauros 18 28 25 31
3 Alianza FC Alianza FC 18 24 16 29
4 Bogotá Bogotá 18 26 21 29
5 Deportivo Rionegro Deportivo 18 33 23 28
6 Uniautónoma Uniautónoma 18 33 24 28
7 Tigres FC Tigres FC 18 21 15 28
8 Academia Academia 18 27 24 28
9 Real Santander Real 18 23 19 27
10 Fortaleza Fortaleza 18 20 18 26
11 Atlético Bucaramanga Atlético 18 16 18 23
12 Real Cundinamarca Real 18 22 27 23
13 Unión Magdalena Unión 18 18 22 20
14 Internacional de Palmira Internaciona 18 22 27 20
15 Patriotas Boyacá Patriotas 18 21 25 18
16 Pacífico Pacífico 18 14 28 15
17 Barranquilla Barranquilla 18 12 28 14
18 Atlético Fútbol Club Atlético 18 15 32 12
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Deportivo Pasto Deportivo 18 21 11 39
2 Águilas Doradas Águilas 18 32 18 38
3 Deportivo Rionegro Deportivo 18 35 21 33
4 Bogotá Bogotá 18 28 14 33
5 Atlético Bucaramanga Atlético 18 29 21 31
6 Unión Magdalena Unión 18 21 15 30
7 Patriotas Boyacá Patriotas 18 34 24 29
8 Academia Academia 18 24 21 29
9 Real Santander Real 18 21 23 26
10 Centauros Centauros 18 24 25 24
11 Pacífico Pacífico 18 18 17 23
12 Real Cundinamarca Real 18 20 23 23
13 Tigres FC Tigres FC 18 19 22 23
14 La Sabana La Sabana 18 13 27 15
15 Fortaleza Fortaleza 18 25 45 15
16 Barranquilla Barranquilla 18 14 26 13
17 Atlético Fútbol Club Atlético 18 16 31 13
18 Alianza FC Alianza FC 18 21 31 11
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Águilas Doradas Águilas 18 28 22 33
2 Atlético Bucaramanga Atlético 18 37 21 32
3 Bogotá Bogotá 18 28 17 28
4 Real Santander Real 18 21 21 26
5 Patriotas Boyacá Patriotas 18 23 24 24
6 Barranquilla Barranquilla 18 20 21 23
7 Real Cundinamarca Real 18 14 28 20
8 Sucre FC Sucre FC 18 17 29 19
9 Atlético Fútbol Club Atlético 18 21 26 17
10 Centauros Centauros 18 27 17 31
11 La Sabana La Sabana 18 30 21 30
12 Unión Magdalena Unión 18 34 19 29
13 Deportivo Rionegro Deportivo 18 22 21 28
14 Fortaleza Fortaleza 18 20 22 27
15 Tigres FC Tigres FC 18 18 16 26
16 Academia Academia 18 27 25 25
17 Internacional de Palmira Internaciona 18 21 22 23
18 Alianza FC Alianza FC 18 7 43 4
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Academia Academia 18 24 16 32
2 Deportivo Rionegro Deportivo 18 23 18 31
3 Unión Magdalena Unión 18 19 14 28
4 Real Cartagena Real 18 19 17 28
5 Tigres FC Tigres FC 18 15 18 27
6 Águilas Doradas Águilas 18 12 11 25
7 Internacional de Palmira Internaciona 18 22 21 21
8 Real Santander Real 18 15 20 19
9 Centauros Centauros 18 13 25 11
10 Atlético Fútbol Club Atlético 18 19 21 28
11 Barranquilla Barranquilla 18 28 21 27
12 Real Cundinamarca Real 18 25 22 26
13 Patriotas Boyacá Patriotas 18 18 19 25
14 Bogotá Bogotá 18 24 23 24
15 Sucre FC Sucre FC 18 24 24 24
16 Fortaleza Fortaleza 18 14 19 22
17 La Sabana La Sabana 18 17 19 21
18 Alianza FC Alianza FC 18 17 20 18
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Deportivo Rionegro Deportivo 18 25 14 35
2 Academia Academia 18 25 16 28
3 Unión Magdalena Unión 18 23 16 28
4 Sucre FC Sucre FC 18 14 14 24
5 Águilas Doradas Águilas 18 21 22 23
6 Internacional de Palmira Internaciona 18 21 25 23
7 La Sabana La Sabana 18 21 23 22
8 Centauros Centauros 18 16 22 20
9 Alianza FC Alianza FC 18 10 25 12
10 Bogotá Bogotá 18 22 14 29
11 Envigado Envigado 18 16 10 29
12 Atlético Fútbol Club Atlético 18 19 17 28
13 Patriotas Boyacá Patriotas 18 27 20 26
14 Tigres FC Tigres FC 18 21 18 25
15 Real Cundinamarca Real 18 19 21 25
16 Barranquilla Barranquilla 18 23 34 21
17 Atlético Bello Atlético 18 18 20 20
18 Real Santander Real 18 14 24 17
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Internacional de Palmira Internaciona 18 31 14 40
2 La Equidad La Equidad 18 30 19 35
3 Centauros Centauros 18 28 17 34
4 Barranquilla Barranquilla 18 39 26 33
5 Deportivo Rionegro Deportivo 18 24 17 29
6 Pumas de Casanare Pumas 18 28 22 29
7 Real Cundinamarca Real 18 23 18 28
8 Academia Academia 18 22 21 25
9 Águilas Doradas Águilas 18 28 25 23
10 Unión Magdalena Unión 18 23 29 23
11 Patriotas Boyacá Patriotas 18 21 21 21
12 Atlético Fútbol Club Atlético 18 17 25 21
13 Bogotá Bogotá 18 22 26 20
14 Alianza FC Alianza FC 18 16 26 19
15 La Sabana La Sabana 18 16 33 19
16 Sucre FC Sucre FC 18 25 25 18
17 Atlético Bello Atlético 18 19 35 13
18 Tigres FC Tigres FC 18 16 29 11

  USO DE MEMORIA  
6,039,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1051
Total Execution Time  0.1070
  CADENA URL  
/clausura_primera_b_colombia2012/grupo1/historico
  GET DATOS  
$_GET['/clausura_primera_b_colombia2012/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0017  SELECT type FROM routes WHERE alias = 'clausura_primera_b_colombia2012'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_primera_b_colombia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=197 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 197 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1078402,1077594,1077298,1076577,1027676) ORDER BY n.cover_points DESC, update_date DESC
0.0020  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 = 1662 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 197 AND group_code = 1 and tables = 1 AND year <= 2012 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0030  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 = 1662 AND t.round = 18 ORDER BY team.conference 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 `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 = 1392 AND t.round = 18 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 = 9747 AND t.round = 18 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 `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 = 13588 AND t.round = 18 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 `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 = 13582 AND t.round = 18 ORDER BY team.conference 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 `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 = 13576 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 13570 AND t.round = 18 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-05-09 02:08:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 02:08:08' 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-05-09 02:08:08' 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-05-09 02:08:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_primera_b_colombia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0135  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 events2012 e ON e.player_id = p.id AND e.league_id = 1662 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1662 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.0033  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 events2012 e ON e.player_id = p.id AND e.league_id = 1662 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1662 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  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 events2012 e ON e.player_id = p.id AND e.league_id = 1662 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1662 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(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 = 1662 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC