4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 River Plate River Plate 14 26 10 27
2 Argentinos Juniors Argentinos 14 25 14 26
3 Barracas Central Barracas 14 20 15 26
4 Vélez Sarsfield Vélez 14 14 13 25
5 Talleres Córdoba Talleres 14 24 16 24
6 Independiente Independient 14 14 10 23
7 Instituto Instituto 14 18 17 17
8 Banfield Banfield 14 14 15 17
9 CA Huracán CA Huracán 14 12 12 16
10 Gimnasia La Plata Gimnasia 14 18 23 16
11 Rosario Central Rosario 14 10 18 15
12 Dep. Riestra Dep. Riestra 14 8 16 13
13 Atl. Tucumán Atl. 14 8 23 10
14 Indep. Rivadavia Indep. 14 13 25 8
15 Godoy Cruz Godoy Cruz 14 16 6 29
16 Estudiantes La Plata Estudiantes 14 19 9 27
17 Defensa y Justicia Defensa 14 17 13 26
18 Boca Juniors Boca Juniors 14 20 12 25
19 Racing Club Racing Club 14 24 11 24
20 Lanús Lanús 14 20 14 23
21 Newell's Old Boys Newell's 14 13 15 21
22 Unión Santa Fe Unión Santa 14 16 14 20
23 Platense Platense 14 10 14 18
24 San Lorenzo San Lorenzo 14 10 14 16
25 Belgrano Belgrano 14 19 21 14
26 Central Córdoba Central 14 10 20 11
27 Sarmiento Sarmiento 14 9 19 9
28 Tigre Tigre 14 7 25 5
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 CA Huracán CA Huracán 14 19 11 26
2 River Plate River Plate 14 24 16 24
3 Banfield Banfield 14 11 6 23
4 Rosario Central Rosario 14 17 13 23
5 Independiente Independient 14 15 11 23
6 Vélez Sarsfield Vélez 14 17 14 22
7 Instituto Instituto 14 11 7 20
8 Colón Colón 14 19 17 20
9 Talleres Córdoba Talleres 14 15 15 17
10 Atl. Tucumán Atl. 14 9 12 17
11 Gimnasia La Plata Gimnasia 14 13 21 15
12 Argentinos Juniors Argentinos 14 19 23 14
13 Barracas Central Barracas 14 10 21 14
14 Arsenal de Sarandí Arsenal 14 10 15 13
15 Racing Club Racing Club 14 22 16 24
16 Godoy Cruz Godoy Cruz 14 14 9 22
17 Belgrano Belgrano 14 20 18 21
18 Platense Platense 14 13 16 20
19 Central Córdoba Central 14 11 14 19
20 Newell's Old Boys Newell's 14 14 10 18
21 Boca Juniors Boca Juniors 14 17 16 18
22 San Lorenzo San Lorenzo 14 11 11 18
23 Estudiantes La Plata Estudiantes 14 11 13 17
24 Sarmiento Sarmiento 14 8 8 16
25 Unión Santa Fe Unión Santa 14 10 13 16
26 Defensa y Justicia Defensa 14 12 16 14
27 Tigre Tigre 14 8 13 13
28 Lanús Lanús 14 9 14 12
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Racing Club Racing Club 14 25 10 30
2 River Plate River Plate 14 31 12 29
3 Defensa y Justicia Defensa 14 26 19 25
4 Argentinos Juniors Argentinos 14 21 16 25
5 Gimnasia La Plata Gimnasia 14 24 20 24
6 Newell's Old Boys Newell's 14 17 15 23
7 Sarmiento Sarmiento 14 17 24 21
8 Banfield Banfield 14 18 15 19
9 Unión Santa Fe Unión Santa 14 11 13 17
10 San Lorenzo San Lorenzo 14 15 17 15
11 Atl. Tucumán Atl. 14 13 23 11
12 Talleres Córdoba Talleres 14 9 21 11
13 Platense Platense 14 12 23 10
14 Patronato Patronato 14 10 25 10
15 Estudiantes La Plata Estudiantes 14 33 20 28
16 Boca Juniors Boca Juniors 14 19 11 27
17 Tigre Tigre 14 17 12 20
18 Aldosivi Aldosivi 14 17 16 20
19 Barracas Central Barracas 14 17 24 19
20 Vélez Sarsfield Vélez 14 13 12 18
21 CA Huracán CA Huracán 14 17 19 18
22 Arsenal de Sarandí Arsenal 14 20 19 17
23 Colón Colón 14 18 19 16
24 Independiente Independient 14 17 18 16
25 Godoy Cruz Godoy Cruz 14 21 24 16
26 Lanús Lanús 14 17 18 15
27 Central Córdoba Central 14 17 23 15
28 Rosario Central Rosario 14 16 20 14
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Colón Colón 13 23 10 25
2 Estudiantes La Plata Estudiantes 13 16 10 22
3 River Plate River Plate 13 25 11 21
4 Racing Club Racing Club 13 14 12 21
5 San Lorenzo San Lorenzo 13 16 16 21
6 Banfield Banfield 13 14 12 20
7 Argentinos Juniors Argentinos 13 14 11 19
8 Rosario Central Rosario 13 16 18 18
9 Central Córdoba Central 13 14 17 17
10 Godoy Cruz Godoy Cruz 13 18 24 15
11 Platense Platense 13 12 19 14
12 Arsenal de Sarandí Arsenal 13 11 23 12
13 Aldosivi Aldosivi 13 15 21 11
14 Vélez Sarsfield Vélez 13 23 13 31
15 Boca Juniors Boca Juniors 13 22 12 22
16 Independiente Independient 13 16 10 20
17 Talleres Córdoba Talleres 13 19 16 20
18 Lanús Lanús 13 18 18 19
19 Unión Santa Fe Unión Santa 13 12 14 19
20 Atl. Tucumán Atl. 13 24 20 18
21 Gimnasia La Plata Gimnasia 13 15 20 15
22 CA Huracán CA Huracán 13 14 17 13
23 Patronato Patronato 13 12 17 12
24 Defensa y Justicia Defensa 13 15 21 12
25 Sarmiento Sarmiento 13 10 19 12
26 Newell's Old Boys Newell's 13 14 21 11

  USO DE MEMORIA  
6,305,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3355
Total Execution Time  0.3374
  CADENA URL  
/copa_liga_profesional_argentina2024/grupo1/historico
  GET DATOS  
$_GET['/copa_liga_profesional_argentina2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0124  SELECT type FROM routes WHERE alias = 'copa_liga_profesional_argentina2024'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_liga_profesional_argentina' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2420 AND type_rel = 3
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2420 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0130  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 `tables2023` 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 = 70413 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 61219 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 09:49:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 09:49:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 09:49:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 09:49:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0212  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 events2024 e ON e.player_id = p.id AND e.league_id = 74880 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74880 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.0317  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 events2024 e ON e.player_id = p.id AND e.league_id = 74880 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74880 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  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 events2024 e ON e.player_id = p.id AND e.league_id = 74880 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74880 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0264  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 74880 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC