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

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 2020

  • Lanús II
  • Independiente II
  • River Plate II
  • Estudiantes La Plata II
  • Boca Juniors II
  • Vélez Sarsfield II
  • Arsenal de Sarandí II
  • Gimnasia La Plata II
  • San Lorenzo II
  • Defensa y Justicia II
  • Banfield II
  • Argentinos Juniors II
  • Godoy Cruz II
  • Patronato II
  • Racing Club II
  • Unión Santa Fe II
  • Talleres Córdoba II
  • Newells Old Boys II
  • CA Huracán II
  • Central Cordoba SdE II
  • Rosario Central II
  • Colón II
  • Atl. Tucumán II
  • Aldosivi II

Cruce de partidos Torneo Proyección - Todos los partidos de la temporada

IdaVuelta
 Boca Juniors II River Plate II Estudiantes La Plata II Gimnasia La Plata II Independiente II Lanús II Vélez Sarsfield II Newells Old Boys II San Lorenzo II Godoy Cruz II Racing Club II Argentinos Juniors II Banfield II CA Huracán II Defensa y Justicia II Rosario Central II Colón II Talleres Córdoba II Unión Santa Fe II Arsenal de Sarandí II Atl. Tucumán II Aldosivi II Patronato II Central Cordoba SdE II
Boca Juniors II Boca Juniors II
River Plate II River Plate II
Estudiantes La Plata II Estudiantes La Plata II
Gimnasia La Plata II Gimnasia La Plata II
Independiente II Independiente II
Lanús II Lanús II
Vélez Sarsfield II Vélez Sarsfield II
Newells Old Boys II Newells Old Boys II
San Lorenzo II San Lorenzo II
Godoy Cruz II Godoy Cruz II
Racing Club II Racing Club II
Argentinos Juniors II Argentinos Juniors II
Banfield II Banfield II
CA Huracán II CA Huracán II
Defensa y Justicia II Defensa y Justicia II
Rosario Central II Rosario Central II
Colón II Colón II
Talleres Córdoba II Talleres Córdoba II
Unión Santa Fe II Unión Santa Fe II
Arsenal de Sarandí II Arsenal de Sarandí II
Atl. Tucumán II Atl. Tucumán II
Aldosivi II Aldosivi II
Patronato II Patronato II
Central Cordoba SdE II Central Cordoba SdE II

  USO DE MEMORIA  
6,741,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3029
Total Execution Time  0.3049
  CADENA URL  
/torneo_de_reserva2020/grupo1/cruces
  GET DATOS  
$_GET['/torneo_de_reserva2020/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1901 ORDER BY order_id ASC
0.0127  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 = 50798 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0256  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2020 AS c WHERE c.league_id='50798' ORDER BY c.id ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 09:18:36' 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=2 AND last_update > '2024-05-01 09:18:36' 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-05-01 09:18:36' 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-05-01 09:18:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0255  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 events2020 e ON e.player_id = p.id AND e.league_id = 50798 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50798 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.0130  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 events2020 e ON e.player_id = p.id AND e.league_id = 50798 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50798 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0140  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 events2020 e ON e.player_id = p.id AND e.league_id = 50798 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50798 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0259  SELECT *,(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