4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Boca Juniors II Boca Juniors 25 63 23 52
2 Colón II Colón II 25 28 16 47
3 Rosario Central II Rosario 25 49 30 45
4 Gimnasia La Plata II Gimnasia 25 44 32 45
5 Platense II Platense II 25 42 31 42
6 Argentinos Juniors II Argentinos 25 33 26 40
7 Estudiantes La Plata II Estudiantes 25 38 34 39
8 Lanús II Lanús II 25 36 31 36
9 Vélez Sarsfield II Vélez 24 31 29 36
10 Newells Old Boys II Newells Boys 25 31 28 35
11 Atl. Tucumán II Atl. 25 27 25 32
12 San Lorenzo II Lorenzo 25 29 31 32
13 Independiente II Independient 25 23 25 32
14 Sarmiento II Sarmiento 25 34 39 32
15 River Plate II River Plate 25 30 35 32
16 Talleres Córdoba II Talleres 24 26 27 30
17 Arsenal de Sarandí II Arsenal 25 23 27 30
18 Godoy Cruz II Godoy Cruz 25 25 32 30
19 Banfield II Banfield II 25 27 36 30
20 Defensa y Justicia II Defensa 25 28 37 29
21 Racing Club II Racing Club 25 29 35 27
22 Aldosivi II Aldosivi II 25 25 33 27
23 CA Huracán II Huracán 25 20 30 27
24 Patronato II Patronato 25 29 42 26
25 Unión Santa Fe II Unión Santa 25 21 33 23
26 Central Cordoba SdE II Central 25 21 45 19
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Lanús II Lanús II 23 41 25 46
2 Independiente II Independient 23 32 20 41
3 River Plate II River Plate 23 42 20 40
4 Estudiantes La Plata II Estudiantes 23 29 21 40
5 Boca Juniors II Boca Juniors 23 32 18 39
6 Vélez Sarsfield II Vélez 23 38 27 39
7 Arsenal de Sarandí II Arsenal 23 29 26 35
8 Gimnasia La Plata II Gimnasia 23 29 27 35
9 San Lorenzo II Lorenzo 23 31 25 33
10 Defensa y Justicia II Defensa 23 25 25 30
11 Banfield II Banfield II 23 31 32 30
12 Argentinos Juniors II Argentinos 23 28 32 30
13 Godoy Cruz II Godoy Cruz 23 28 26 29
14 Patronato II Patronato 23 26 27 29
15 Racing Club II Racing Club 23 18 27 29
16 Unión Santa Fe II Unión Santa 23 25 27 27
17 Talleres Córdoba II Talleres 23 27 33 27
18 Newells Old Boys II Newells Boys 23 30 32 26
19 CA Huracán II Huracán 23 30 34 26
20 Central Cordoba SdE II Central 23 30 38 26
21 Rosario Central II Rosario 23 24 35 26
22 Colón II Colón II 23 29 31 25
23 Atl. Tucumán II Atl. 23 21 35 17
24 Aldosivi II Aldosivi II 23 16 48 14
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 San Lorenzo II Lorenzo 25 55 13 62
2 Boca Juniors II Boca Juniors 25 42 21 52
3 Unión Santa Fe II Unión Santa 25 44 23 49
4 Newells Old Boys II Newells Boys 25 36 22 48
5 Vélez Sarsfield II Vélez 25 38 31 46
6 Estudiantes La Plata II Estudiantes 25 31 25 41
7 CA Huracán II Huracán 25 31 20 40
8 Banfield II Banfield II 24 36 30 40
9 River Plate II River Plate 25 42 27 39
10 Godoy Cruz II Godoy Cruz 25 30 26 39
11 Belgrano II Belgrano II 25 35 29 37
12 Lanús II Lanús II 25 41 38 35
13 Argentinos Juniors II Argentinos 25 31 30 34
14 Racing Club II Racing Club 25 43 42 33
15 Talleres Córdoba II Talleres 25 36 39 33
16 Tigre II Tigre II 25 20 26 30
17 Rosario Central II Rosario 25 28 36 30
18 Independiente II Independient 25 22 28 26
19 San Martín Tucumán II Martín 25 30 39 26
20 Colón II Colón II 25 20 27 26
21 Atl. Tucumán II Atl. 25 29 41 25
22 Gimnasia La Plata II Gimnasia 25 22 33 23
23 San Martín San Juan II Martín Juan 25 25 61 22
24 Patronato II Patronato 25 20 44 22
25 Aldosivi II Aldosivi II 25 31 38 21
26 Defensa y Justicia II Defensa 24 16 45 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Talleres Córdoba II Talleres 27 63 28 52
2 San Lorenzo II Lorenzo 27 53 38 51
3 Unión Santa Fe II Unión Santa 27 34 26 49
4 Boca Juniors II Boca Juniors 26 36 23 48
5 Tigre II Tigre II 27 34 36 47
6 Independiente II Independient 27 38 28 44
7 Rosario Central II Rosario 25 40 25 43
8 River Plate II River Plate 26 41 27 42
9 Estudiantes La Plata II Estudiantes 25 41 32 41
10 Racing Club II Racing Club 25 34 32 39
11 Lanús II Lanús II 27 32 34 39
12 Defensa y Justicia II Defensa 23 35 25 38
13 Patronato II Patronato 26 37 40 38
14 Belgrano II Belgrano II 26 37 30 35
15 Newells Old Boys II Newells Boys 27 39 38 34
16 Gimnasia La Plata II Gimnasia 26 31 35 34
17 Colón II Colón II 27 27 31 34
18 Vélez Sarsfield II Vélez 26 26 30 34
19 Argentinos Juniors II Argentinos 27 43 44 32
20 Banfield II Banfield II 24 34 35 31
21 Godoy Cruz II Godoy Cruz 25 24 27 30
22 San Martín San Juan II Martín Juan 25 34 52 28
23 Atl. Tucumán II Atl. 24 26 38 27
24 Olimpo II Olimpo II 25 35 47 24
25 CA Huracán II Huracán 27 27 38 23
26 Temperley II Temperley 24 20 39 21
27 Arsenal de Sarandí II Arsenal 23 17 31 20
28 Chacarita Juniors II Chacarita 26 19 48 18
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Talleres Córdoba II Talleres 30 55 32 59
2 Newells Old Boys II Newells Boys 30 56 34 57
3 Lanús II Lanús II 30 34 19 56
4 Boca Juniors II Boca Juniors 29 40 23 53
5 Rosario Central II Rosario 30 47 33 50
6 CA Huracán II Huracán 31 37 37 49
7 Unión Santa Fe II Unión Santa 29 45 35 48
8 Belgrano II Belgrano II 30 45 38 45
9 Banfield II Banfield II 27 41 29 44
10 Independiente II Independient 27 40 28 44
11 Vélez Sarsfield II Vélez 29 39 31 44
12 Estudiantes La Plata II Estudiantes 27 43 32 43
13 Racing Club II Racing Club 25 38 32 40
14 River Plate II River Plate 28 31 30 38
15 Sarmiento II Sarmiento 28 31 39 38
16 San Lorenzo II Lorenzo 28 30 25 37
17 Godoy Cruz II Godoy Cruz 28 41 48 36
18 Olimpo II Olimpo II 28 35 37 35
19 Colón II Colón II 29 36 39 35
20 Atlético Rafaela II Atlético 30 38 43 33
21 Arsenal de Sarandí II Arsenal 28 28 30 32
22 Quilmes II Quilmes II 29 28 42 32
23 Aldosivi II Aldosivi II 25 31 33 31
24 Patronato II Patronato 30 29 41 30
25 Tigre II Tigre II 28 26 40 30
26 Gimnasia La Plata II Gimnasia 29 32 43 28
27 Defensa y Justicia II Defensa 25 28 35 27
28 Temperley II Temperley 28 24 43 27
29 Atl. Tucumán II Atl. 24 24 46 22
30 San Martín San Juan II Martín Juan 27 29 64 20
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 River Plate II River Plate 16 27 16 35
2 Vélez Sarsfield II Vélez 16 30 18 33
3 San Lorenzo II Lorenzo 16 27 15 26
4 Godoy Cruz II Godoy Cruz 15 25 27 26
5 Belgrano II Belgrano II 14 17 16 22
6 Quilmes II Quilmes II 14 12 13 22
7 Independiente II Independient 13 22 14 19
8 Olimpo II Olimpo II 15 17 18 19
9 Banfield II Banfield II 14 19 24 18
10 Gimnasia La Plata II Gimnasia 14 23 20 17
11 Rosario Central II Rosario 14 22 22 17
12 Patronato II Patronato 13 15 22 15
13 Arsenal de Sarandí II Arsenal 13 7 12 10
14 Colón II Colón II 13 13 24 9
15 Sarmiento II Sarmiento 14 18 30 8
16 Newells Old Boys II Newells Boys 16 30 15 32
17 Lanús II Lanús II 16 27 12 32
18 Racing Club II Racing Club 16 32 13 31
19 Unión Santa Fe II Unión Santa 16 26 16 30
20 CA Huracán II Huracán 16 27 21 29
21 Boca Juniors II Boca Juniors 16 28 15 27
22 Estudiantes La Plata II Estudiantes 15 23 19 25
23 Defensa y Justicia II Defensa 16 26 33 18
24 Tigre II Tigre II 15 22 23 17
25 Argentinos Juniors II Argentinos 14 15 18 15
26 Atl. Tucumán II Atl. 16 18 37 14
27 San Martín San Juan II Martín Juan 15 18 29 13
28 Aldosivi II Aldosivi II 15 9 21 12
29 Atlético Rafaela II Atlético 13 15 26 10
30 Temperley II Temperley 13 5 26 9
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 San Lorenzo II Lorenzo 28 39 15 60
2 Independiente II Independient 28 55 23 58
3 Racing Club II Racing Club 27 52 32 51
4 Boca Juniors II Boca Juniors 27 45 26 47
5 Belgrano II Belgrano II 26 40 19 46
6 Newells Old Boys II Newells Boys 26 48 23 44
7 Gimnasia La Plata II Gimnasia 28 41 25 44
8 Rosario Central II Rosario 27 29 16 44
9 River Plate II River Plate 28 41 28 42
10 Estudiantes La Plata II Estudiantes 25 27 24 38
11 Tigre II Tigre II 26 35 35 38
12 Atlético Rafaela II Atlético 25 34 26 36
13 Defensa y Justicia II Defensa 28 36 38 36
14 Unión Santa Fe II Unión Santa 25 29 32 34
15 Vélez Sarsfield II Vélez 27 31 36 34
16 Banfield II Banfield II 28 32 44 34
17 Argentinos Juniors II Argentinos 27 24 31 33
18 Nueva Chicago II Nueva 24 31 36 32
19 CA Huracán II Huracán 24 19 27 31
20 Lanús II Lanús II 26 32 36 30
21 Colón II Colón II 26 33 44 30
22 Aldosivi II Aldosivi II 23 28 35 26
23 Godoy Cruz II Godoy Cruz 25 28 42 25
24 Arsenal de Sarandí II Arsenal 22 27 36 21
25 Sarmiento II Sarmiento 24 24 46 18
26 San Martín San Juan II Martín Juan 21 25 51 15
27 Quilmes II Quilmes II 19 13 37 12
28 Olimpo II Olimpo II 24 16 51 11
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
6,923,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4503
Total Execution Time  0.4522
  CADENA URL  
/torneo_de_reserva2021/grupo1/historico
  GET DATOS  
$_GET['/torneo_de_reserva2021/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0106  SELECT type FROM routes WHERE alias = 'torneo_de_reserva2021'
0.0219  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_de_reserva' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1901 AND type_rel = 3
0.0118  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1901 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0122  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 (1228159,1219370,1218920,1168607,1167481) ORDER BY n.cover_points DESC, update_date DESC
0.0110  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1901 ORDER BY order_id ASC
0.0113  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1901 GROUP BY l.categoryId
0.0115  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1901 GROUP BY l.year ORDER BY l.year DESC
0.0120  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 = 63375 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1901 AND group_code = 1 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0113  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 = 63375 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 50798 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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 `tables2019` 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 = 44792 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 `tables2018` 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 = 39734 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124  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 `tables2017` 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 = 36433 AND t.round = 30 ORDER BY team.conference 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 `tables2016` 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 = 47367 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2015` 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 = 47369 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 `tables2014` 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 = 47370 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 `tables2013` 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 = 47371 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 01:28:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 01:28:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 01:28:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 01:28:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0121  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_de_reserva' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0246  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 events2021 e ON e.player_id = p.id AND e.league_id = 63375 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63375 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.0111  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 events2021 e ON e.player_id = p.id AND e.league_id = 63375 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63375 AND (e.action = 4 or e.action = 5) 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 events2021 e ON e.player_id = p.id AND e.league_id = 63375 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63375 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0177  SELECT *,(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 = 63375 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC