4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2018
Temporada Siguiente »
Torneo Proyección 2018
2017/2018

torneo reserva, torneo reserva argentina, torneo de reserva, torneo proyección, proyección Argentina, División de reserva de Argentina, División Reserva

Torneo Proyección 2018

  • Talleres Córdoba II
  • San Lorenzo II
  • Unión Santa Fe II
  • Boca Juniors II
  • Tigre II
  • Independiente II
  • Rosario Central II
  • River Plate II
  • Estudiantes La Plata II
  • Racing Club II
  • Lanús II
  • Defensa y Justicia II
  • Patronato II
  • Belgrano II
  • Newells Old Boys II
  • Gimnasia La Plata II
  • Colón II
  • Vélez Sarsfield II
  • Argentinos Juniors II
  • Banfield II
  • Godoy Cruz II
  • San Martín San Juan II
  • Atl. Tucumán II
  • Olimpo II
  • CA Huracán II
  • Temperley II
  • Arsenal de Sarandí II
  • Chacarita Juniors II
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,182,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.1002
Total Execution Time  0.1026
  CADENA URL  
/torneo_de_reserva2018/grupo1/historico
  GET DATOS  
$_GET['/torneo_de_reserva2018/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0019  SELECT type FROM routes WHERE alias = 'torneo_de_reserva2018'
0.0042  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 = 2018 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=1901 AND type_rel = 3
0.0023  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.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 (1228159,1219370,1218920,1168607,1167481) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1901 ORDER BY order_id ASC
0.0021  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 = 39734 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1901 AND group_code = 1 and tables = 1 AND year <= 2018 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0029  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.0034  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.0040  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.0038  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.0020  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.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 `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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 15:03:18' 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-01 15:03:18' 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-01 15:03:18' 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-01 15:03:18' 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 = 'torneo_de_reserva' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 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 events2018 e ON e.player_id = p.id AND e.league_id = 39734 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39734 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 events2018 e ON e.player_id = p.id AND e.league_id = 39734 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39734 AND (e.action = 4 or e.action = 5) 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 events2018 e ON e.player_id = p.id AND e.league_id = 39734 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39734 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0050  SELECT *,(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