4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 General Lamadrid General 38 57 34 75
2 Argentino Merlo Argentino 38 49 33 71
3 Talleres R. Escalada Talleres 38 58 40 69
4 Central Córdoba Rosario Central 38 51 28 64
5 Laferrere Laferrere 38 51 33 64
6 Liniers Liniers 38 53 43 64
7 UAI Urquiza UAI Urquiza 38 51 35 58
8 Excursionistas Excursionist 38 33 27 56
9 Berazategui Berazategui 38 42 39 55
10 JJ Urquiza JJ Urquiza 38 37 41 50
11 Luján Luján 38 26 37 49
12 Def. Unidos Def. Unidos 38 44 54 48
13 Villa Dálmine Villa 38 48 47 46
14 CA San Miguel Miguel 38 32 40 40
15 Defensores de Cambaceres Defensores 38 23 35 38
16 El Porvenir El Porvenir 38 35 56 37
17 Midland Midland 38 25 38 35
18 Leandro Nicéforo Alem Leandro 38 32 48 32
19 Sacachispas Sacachispas 38 27 47 32
20 Fénix Bs As Fénix 38 27 46 30
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Barracas Central Barracas 38 55 24 73
2 Excursionistas Excursionist 38 57 28 73
3 Def. Unidos Def. Unidos 38 59 43 65
4 Sacachispas Sacachispas 38 52 52 58
5 Talleres R. Escalada Talleres 38 46 40 57
6 JJ Urquiza JJ Urquiza 38 45 41 55
7 Arg. Rosario Arg. Rosario 38 50 42 54
8 El Porvenir El Porvenir 38 39 43 53
9 Midland Midland 38 27 32 53
10 CA San Miguel Miguel 38 36 37 52
11 Laferrere Laferrere 38 41 38 50
12 Berazategui Berazategui 38 34 38 48
13 Defensores de Cambaceres Defensores 38 40 54 48
14 Leandro Nicéforo Alem Leandro 38 38 42 46
15 Fénix Bs As Fénix 38 45 50 46
16 General Lamadrid General 38 41 52 43
17 Argentino Merlo Argentino 38 30 40 42
18 Villa Dálmine Villa 38 27 39 40
19 Luján Luján 38 35 45 37
20 Sportivo Barracas Sportivo 38 27 44 37
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Villa San Carlos Villa Carlos 38 55 32 73
2 Berazategui Berazategui 38 54 26 68
3 Excursionistas Excursionist 38 51 28 68
4 Villa Dálmine Villa 38 48 31 66
5 JJ Urquiza JJ Urquiza 38 55 40 58
6 Laferrere Laferrere 38 46 38 57
7 Leandro Nicéforo Alem Leandro 38 45 33 56
8 General Lamadrid General 38 43 42 56
9 Arg. Rosario Arg. Rosario 38 51 43 55
10 Barracas Central Barracas 38 46 40 51
11 Defensores de Cambaceres Defensores 38 47 52 50
12 Luján Luján 38 32 44 46
13 Def. Unidos Def. Unidos 38 43 46 45
14 El Porvenir El Porvenir 38 36 41 45
15 Argentino Merlo Argentino 38 45 51 45
16 Sacachispas Sacachispas 38 29 44 40
17 CA San Miguel Miguel 38 36 45 38
18 Fénix Bs As Fénix 38 32 57 35
19 Sportivo Barracas Sportivo 38 31 58 33
20 Cañuelas Cañuelas 38 23 57 25
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Colegiales Colegiales 38 59 32 75
2 Fénix Bs As Fénix 38 52 33 70
3 Laferrere Laferrere 38 56 37 68
4 Luján Luján 38 51 35 65
5 Barracas Central Barracas 38 47 37 62
6 El Porvenir El Porvenir 38 42 40 60
7 Argentino Merlo Argentino 38 51 40 58
8 Leandro Nicéforo Alem Leandro 38 45 34 58
9 Villa San Carlos Villa Carlos 38 38 34 56
10 CA San Miguel Miguel 38 37 33 55
11 Sacachispas Sacachispas 38 49 53 51
12 Sportivo Barracas Sportivo 38 57 52 49
13 Excursionistas Excursionist 38 38 49 44
14 JJ Urquiza JJ Urquiza 38 32 48 43
15 Cañuelas Cañuelas 38 39 45 42
16 Villa Dálmine Villa 38 30 36 41
17 General Lamadrid General 38 46 64 40
18 San Martín Burzaco Martín 38 34 53 34
19 Dock Sud Dock Sud 38 35 51 31
20 Arg. Rosario Arg. Rosario 38 30 62 27
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Acassuso Acassuso 20 26 12 43
2 JJ Urquiza JJ Urquiza 19 35 15 38
3 Barracas Central Barracas 19 30 16 35
4 Fénix Bs As Fénix 19 26 22 31
5 Cañuelas Cañuelas 18 27 15 30
6 Luján Luján 19 23 18 29
7 Laferrere Laferrere 19 24 22 29
8 Sacachispas Sacachispas 20 22 27 29
9 Colegiales Colegiales 19 25 19 27
10 Arg. Rosario Arg. Rosario 19 18 19 27
11 Villa San Carlos Villa Carlos 19 26 25 26
12 San Martín Burzaco Martín 19 14 20 26
13 Villa Dálmine Villa 19 19 19 23
14 Dock Sud Dock Sud 19 19 32 22
15 CA San Miguel Miguel 19 19 21 20
16 Sportivo Barracas Sportivo 19 23 33 20
17 General Lamadrid General 19 19 21 18
18 Ituzaingó Ituzaingó 19 13 26 18
19 Argentino Merlo Argentino 19 11 26 15
20 Excursionistas Excursionist 18 13 24 10
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Deportivo Merlo Deportivo 19 42 16 42
2 Luján Luján 19 30 20 37
3 Colegiales Colegiales 19 24 15 32
4 Argentino Merlo Argentino 19 24 14 31
5 CA San Miguel Miguel 19 21 18 29
6 Sportivo Barracas Sportivo 19 25 20 27
7 Sacachispas Sacachispas 19 22 20 27
8 Fénix Bs As Fénix 19 18 17 27
9 Excursionistas Excursionist 19 27 20 26
10 Acassuso Acassuso 19 18 12 26
11 Dock Sud Dock Sud 19 15 17 26
12 JJ Urquiza JJ Urquiza 19 18 19 23
13 San Martín Burzaco Martín 19 22 28 23
14 Arg. Rosario Arg. Rosario 19 19 18 22
15 General Lamadrid General 19 16 18 22
16 Cañuelas Cañuelas 19 20 23 22
17 Barracas Central Barracas 19 18 33 18
18 Villa San Carlos Villa Carlos 19 20 34 15
19 Villa Dálmine Villa 19 13 31 15
20 Arg. Quilmes Arg. Quilmes 19 11 30 9

  USO DE MEMORIA  
5,941,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0871
Total Execution Time  0.0890
  CADENA URL  
/primera_c_metropolitana2011/grupo1/historico
  GET DATOS  
$_GET['/primera_c_metropolitana2011/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0017  SELECT type FROM routes WHERE alias = 'primera_c_metropolitana2011'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_c_metropolitana' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=208 AND type_rel = 3
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 208 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1217126,1190853,1162930,1088584,1060413) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = 26830 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 208 AND group_code = 1 and tables = 1 AND year <= 2011 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 `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 = 26830 AND t.round = 38 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 `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 = 26829 AND t.round = 38 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 `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 = 26833 AND t.round = 38 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 `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 = 26836 AND t.round = 38 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 `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 = 26838 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 27682 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 21:29:26' 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-05-09 21:29:26' 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 21:29:26' 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=3 AND last_update > '2024-05-09 21:29:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_c_metropolitana' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2011 e ON e.player_id = p.id AND e.league_id = 26830 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26830 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.0019  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 events2011 e ON e.player_id = p.id AND e.league_id = 26830 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26830 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 events2011 e ON e.player_id = p.id AND e.league_id = 26830 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 26830 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051  SELECT *,(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 = 26830 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC