4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2015
Temporada Siguiente »
Liga Profesional Argentina 2015
2014/2015

liga argentina, superliga argentina, primera division de argentina,liga profesional argentina

Liga Profesional Argentina 2015

  • Boca Juniors
  • San Lorenzo
  • Rosario Central
  • Racing Club
  • Independiente
  • Belgrano
  • Estudiantes La Plata
  • Banfield
  • River Plate
  • Tigre
  • Quilmes
  • Gimnasia La Plata
  • Lanús
  • Unión Santa Fe
  • Aldosivi
  • Newell's Old Boys
  • San Martín San Juan
  • Olimpo
  • Colón
  • Argentinos Juniors
  • Defensa y Justicia
  • Godoy Cruz
  • CA Huracán
  • Sarmiento
  • Temperley
  • Nueva Chicago
  • Vélez Sarsfield
  • Arsenal de Sarandí
  • Atletico Rafaela
  • Crucero del Norte

Clasificación

Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 30 49 26 64
2 San Lorenzo San Lorenzo 30 44 20 61
3 Rosario Central Rosario 30 47 26 59
4 Racing Club Racing Club 30 40 23 57
5 Independiente Independient 30 44 22 54
6 Belgrano Belgrano 30 33 23 51
7 Estudiantes La Plata Estudiantes 30 34 28 51
8 Banfield Banfield 30 38 32 50
9 River Plate River Plate 30 46 33 49
10 Tigre Tigre 30 32 25 46
11 Quilmes Quilmes 30 38 37 45
12 Gimnasia La Plata Gimnasia 30 41 38 44
13 Lanús Lanús 30 33 29 42
14 Unión Santa Fe Unión Santa 30 38 37 41
15 Aldosivi Aldosivi 30 37 40 40
16 Newell's Old Boys Newell's 30 27 30 40
17 San Martín San Juan Martín Juan 30 32 34 37
18 Olimpo Olimpo 30 23 26 36
19 Colón Colón 30 26 31 34
20 Argentinos Juniors Argentinos 30 30 38 33
21 Defensa y Justicia Defensa 30 27 31 32
22 Godoy Cruz Godoy Cruz 30 32 40 32
23 CA Huracán CA Huracán 30 29 37 30
24 Sarmiento Sarmiento 30 24 34 30
25 Temperley Temperley 30 19 29 30
26 Nueva Chicago Nueva 30 29 38 29
27 Vélez Sarsfield Vélez 30 27 37 29
28 Arsenal de Sarandí Arsenal 30 25 44 27
29 Atletico Rafaela Atletico 30 29 51 23
30 Crucero del Norte Crucero 30 21 55 14

  USO DE MEMORIA  
5,953,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3242
Total Execution Time  0.3264
  CADENA URL  
/primera_division_argentina2015/grupo1/resumen/30
  GET DATOS  
$_GET['/primera_division_argentina2015/grupo1/resumen/30']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0107  SELECT id,name,alias,stepParent FROM categories WHERE parentId=675 ORDER BY order_id ASC
0.0112  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 = 8714 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114  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 `calendars2015` 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` = 8714 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0200  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 `events2015` e INNER JOIN calendars2015 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 8714 ORDER BY total DESC LIMIT 100
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 22:49:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 22:49:17' 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=4 AND last_update > '2024-04-28 22:49:17' 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-28 22:49:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0517  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 events2015 e ON e.player_id = p.id AND e.league_id = 8714 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8714 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.0470  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 events2015 e ON e.player_id = p.id AND e.league_id = 8714 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8714 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0145  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 events2015 e ON e.player_id = p.id AND e.league_id = 8714 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8714 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0225  SELECT *,(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 = 8714 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC