4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Argentino Merlo Argentino 18 32 16 39
2 Dep. Español Dep. 18 23 10 38
3 Claypole Claypole 18 27 19 32
4 Real Pilar Real Pilar 18 24 14 31
5 Excursionistas Excursionist 18 26 18 31
6 Puerto Nuevo Puerto Nuevo 18 16 15 29
7 Laferrere Laferrere 18 20 16 28
8 Sportivo Italiano Sportivo 18 19 14 27
9 CA Atlas CA Atlas 18 17 16 27
10 Berazategui Berazategui 18 27 25 26
11 Central Córdoba Rosario Central 18 20 18 25
12 Luján Luján 18 18 23 21
13 Liniers Liniers 18 21 24 20
14 Midland Midland 18 17 22 19
15 San Martín Burzaco Martín 18 12 19 16
16 General Lamadrid General 18 16 24 16
17 Leandro Nicéforo Alem Leandro 18 11 26 14
18 Victoriano Arenas Victoriano 18 13 26 13
19 El Porvenir El Porvenir 18 13 27 12
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Berazategui Berazategui 18 31 19 37
2 Ituzaingó Ituzaingó 18 23 12 37
3 Dep. Español Dep. 18 21 12 33
4 Sportivo Italiano Sportivo 18 21 11 29
5 Laferrere Laferrere 18 21 21 28
6 Excursionistas Excursionist 18 25 23 27
7 Claypole Claypole 18 19 18 26
8 Central Córdoba Rosario Central 18 15 14 26
9 Argentino Merlo Argentino 18 32 26 25
10 Dock Sud Dock Sud 18 19 21 25
11 Real Pilar Real Pilar 18 16 10 23
12 General Lamadrid General 18 21 23 22
13 San Martín Burzaco Martín 18 17 23 21
14 CA Atlas CA Atlas 18 20 26 20
15 Luján Luján 18 18 20 19
16 Victoriano Arenas Victoriano 18 26 30 18
17 Midland Midland 18 16 22 17
18 Leandro Nicéforo Alem Leandro 18 9 21 16
19 El Porvenir El Porvenir 18 10 28 6
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Deportivo Merlo Deportivo 9 17 7 20
2 Excursionistas Excursionist 8 12 8 16
3 Real Pilar Real Pilar 9 12 7 15
4 Luján Luján 9 9 8 15
5 Dock Sud Dock Sud 8 11 10 14
6 Midland Midland 8 10 9 13
7 Victoriano Arenas Victoriano 8 14 9 12
8 Ituzaingó Ituzaingó 8 10 8 12
9 Laferrere Laferrere 9 9 9 12
10 Argentino Merlo Argentino 9 13 14 12
11 Leandro Nicéforo Alem Leandro 9 11 13 12
12 San Martín Burzaco Martín 9 8 10 12
13 General Lamadrid General 8 8 7 11
14 Central Córdoba Rosario Central 8 7 5 9
15 Sportivo Italiano Sportivo 9 7 8 9
16 El Porvenir El Porvenir 9 5 12 9
17 Berazategui Berazategui 8 11 13 7
18 Cañuelas Cañuelas 9 5 14 5
19 Dep. Español Dep. 8 4 12 3
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Acassuso Acassuso 19 25 9 36
2 General Lamadrid General 19 29 20 35
3 JJ Urquiza JJ Urquiza 19 35 23 34
4 Sportivo Barracas Sportivo 19 32 23 34
5 Villa Dálmine Villa 19 21 18 30
6 Barracas Central Barracas 19 23 15 29
7 Colegiales Colegiales 19 27 25 29
8 Arg. Rosario Arg. Rosario 19 32 28 28
9 Laferrere Laferrere 19 19 19 28
10 Argentino Merlo Argentino 19 27 23 27
11 Sacachispas Sacachispas 19 20 21 25
12 Luján Luján 19 24 28 24
13 CA San Miguel Miguel 19 22 23 23
14 Dock Sud Dock Sud 19 20 26 23
15 Villa San Carlos Villa Carlos 19 20 26 22
16 Ituzaingó Ituzaingó 19 16 24 22
17 San Martín Burzaco Martín 19 17 23 20
18 Excursionistas Excursionist 19 23 31 20
19 Fénix Bs As Fénix 19 20 24 19
20 Cañuelas Cañuelas 19 10 33 11
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Deportivo Merlo Deportivo 9 22 14 19
2 Excursionistas Excursionist 9 14 10 17
3 Villa Dálmine Villa 9 13 10 17
4 Sacachispas Sacachispas 9 19 15 15
5 Barracas Central Barracas 9 13 11 14
6 San Martín Burzaco Martín 9 15 16 11
7 Dock Sud Dock Sud 9 9 7 10
8 General Lamadrid General 9 13 17 8
9 Colegiales Colegiales 9 10 14 7
10 CA San Miguel Miguel 9 5 19 5

Equipos de esta liga

2

  USO DE MEMORIA  
4,872,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3458
Total Execution Time  0.3478
  CADENA URL  
/primera_c_metropolitana2023/grupo2/historico
  GET DATOS  
$_GET['/primera_c_metropolitana2023/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0254  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 = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=208 AND type_rel = 3
0.0136  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.0143  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.0133  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 = 74321 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 208 AND group_code = 2 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0144  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 `tables2022` 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 = 67783 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2021` 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 = 62712 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 50704 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 26840 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 27683 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 04:38:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 04:38:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-06 04:38:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-06 04:38:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  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 events2023 e ON e.player_id = p.id AND e.league_id = 74321 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74321 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.0131  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 events2023 e ON e.player_id = p.id AND e.league_id = 74321 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74321 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0132  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 events2023 e ON e.player_id = p.id AND e.league_id = 74321 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74321 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10