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

Clasificación

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

  USO DE MEMORIA  
5,544,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0816
Total Execution Time  0.0836
  CADENA URL  
/torneo_de_reserva2020/grupo1/resumen/23
  GET DATOS  
$_GET['/torneo_de_reserva2020/grupo1/resumen/23']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1901 AND type_rel = 3
0.0020  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.0021  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.0024  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2020` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 50798 AND c.`round` = 23 ORDER BY shedule ASC LIMIT 200
0.0038  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2020` e INNER JOIN calendars2020 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 23 AND e.real_date IS NOT NULL AND e.league_id = 50798 ORDER BY total DESC LIMIT 100
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 03:23:33' 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 03:23:33' 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 03:23:33' 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 03:23:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0123  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.0022  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.0029  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.0049  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