4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
26 Feb 95 BelgranoBelgrano 1 - 3 Rosario CentralRosario ...
26 Feb 95 BanfieldBanfield 0 - 2 Boca JuniorsBoca ...
26 Feb 95 Dep. EspañolDep. 0 - 1 PlatensePlatense ...
26 Feb 95 Gimnasia JujuyGimnasia 0 - 2 Vélez SarsfieldVélez ...
26 Feb 95 Ferro Carril OesteFerro 1 - 0 Racing ClubRacing Club ...
26 Feb 95 CD MandiyúMandiyú 0 - 0 CA HuracánHuracán ...
26 Feb 95 IndependienteIndependien 3 - 0 Argentinos JuniorsArgentinos ...
26 Feb 95 San LorenzoLorenzo 1 - 1 Gimnasia La PlataGimnasia ...
26 Feb 95 River PlateRiver Plate 2 - 3 LanúsLanús ...
26 Feb 95 Newell's Old BoysNewell's 1 - 1 Talleres CórdobaTalleres ...
Jornada 2
05 Mar 95 Talleres CórdobaTalleres 1 - 0 CD MandiyúMandiyú ...
05 Mar 95 Boca JuniorsBoca 2 - 0 Newell's Old BoysNewell's ...
05 Mar 95 Argentinos JuniorsArgentinos 2 - 0 San LorenzoLorenzo ...
05 Mar 95 CA HuracánHuracán 1 - 1 Dep. EspañolDep. ...
05 Mar 95 Ferro Carril OesteFerro 0 - 2 IndependienteIndependien ...
05 Mar 95 Gimnasia La PlataGimnasia 4 - 0 BelgranoBelgrano ...
05 Mar 95 LanúsLanús 3 - 0 Gimnasia JujuyGimnasia ...
05 Mar 95 Vélez SarsfieldVélez 2 - 0 BanfieldBanfield ...
05 Mar 95 Rosario CentralRosario 3 - 0 River PlateRiver Plate ...
05 Mar 95 Racing ClubRacing Club 1 - 0 PlatensePlatense ...
Jornada 3
12 Mar 95 BanfieldBanfield 1 - 0 LanúsLanús ...
12 Mar 95 BelgranoBelgrano 1 - 0 Argentinos JuniorsArgentinos ...
12 Mar 95 Gimnasia JujuyGimnasia 1 - 1 Rosario CentralRosario ...
12 Mar 95 Dep. EspañolDep. 2 - 0 Talleres CórdobaTalleres ...
12 Mar 95 River PlateRiver Plate 1 - 1 Gimnasia La PlataGimnasia ...
12 Mar 95 San LorenzoLorenzo 2 - 0 Ferro Carril OesteFerro ...
12 Mar 95 IndependienteIndependien 0 - 0 Racing ClubRacing Club ...
12 Mar 95 PlatensePlatense 0 - 0 CA HuracánHuracán ...
12 Mar 95 Newell's Old BoysNewell's 0 - 3 Vélez SarsfieldVélez ...
12 Mar 95 CD MandiyúMandiyú 0 - 0 Boca JuniorsBoca ...
Jornada 4
19 Mar 95 Talleres CórdobaTalleres 0 - 0 PlatensePlatense ...
19 Mar 95 Boca JuniorsBoca 4 - 1 Dep. EspañolDep. ...
19 Mar 95 Argentinos JuniorsArgentinos 2 - 4 River PlateRiver Plate ...
19 Mar 95 Ferro Carril OesteFerro 1 - 0 BelgranoBelgrano ...
19 Mar 95 Gimnasia La PlataGimnasia 1 - 1 Gimnasia JujuyGimnasia ...
19 Mar 95 LanúsLanús 3 - 1 Newell's Old BoysNewell's ...
19 Mar 95 CA HuracánHuracán 2 - 2 Racing ClubRacing Club ...
19 Mar 95 Vélez SarsfieldVélez 1 - 0 CD MandiyúMandiyú ...
19 Mar 95 Rosario CentralRosario 1 - 0 BanfieldBanfield ...
19 Mar 95 IndependienteIndependien 0 - 1 San LorenzoLorenzo ...
Jornada 5
26 Mar 95 BelgranoBelgrano 0 - 2 IndependienteIndependien ...
26 Mar 95 BanfieldBanfield 1 - 0 Gimnasia La PlataGimnasia ...
26 Mar 95 CA HuracánHuracán 1 - 1 Talleres CórdobaTalleres ...
26 Mar 95 Gimnasia JujuyGimnasia 1 - 1 Argentinos JuniorsArgentinos ...
26 Mar 95 Dep. EspañolDep. 2 - 0 Vélez SarsfieldVélez ...
26 Mar 95 Newell's Old BoysNewell's 1 - 1 Rosario CentralRosario ...
26 Mar 95 River PlateRiver Plate 1 - 1 Ferro Carril OesteFerro ...
26 Mar 95 Racing ClubRacing Club 1 - 2 San LorenzoLorenzo ...
26 Mar 95 PlatensePlatense 2 - 2 Boca JuniorsBoca ...
26 Mar 95 CD MandiyúMandiyú 1 - 2 LanúsLanús ...
Jornada 6
02 Abr 95 Talleres CórdobaTalleres 2 - 2 Racing ClubRacing Club ...
02 Abr 95 Argentinos JuniorsArgentinos 1 - 4 BanfieldBanfield ...
02 Abr 95 Boca JuniorsBoca 2 - 1 CA HuracánHuracán ...
02 Abr 95 Gimnasia La PlataGimnasia 3 - 1 Newell's Old BoysNewell's ...
02 Abr 95 Ferro Carril OesteFerro 2 - 2 Gimnasia JujuyGimnasia ...
02 Abr 95 LanúsLanús 2 - 0 Dep. EspañolDep. ...
02 Abr 95 IndependienteIndependien 1 - 4 River PlateRiver Plate ...
02 Abr 95 Vélez SarsfieldVélez 1 - 1 PlatensePlatense ...
02 Abr 95 San LorenzoLorenzo 1 - 0 BelgranoBelgrano ...
02 Abr 95 Rosario CentralRosario 2 - 3 CD MandiyúMandiyú ...
Jornada 7
24 May 95 Gimnasia JujuyGimnasia 2 - 0 IndependienteIndependien ...
09 Abr 95 BanfieldBanfield 1 - 1 Ferro Carril OesteFerro ...
09 Abr 95 Talleres CórdobaTalleres 2 - 2 Boca JuniorsBoca ...
09 Abr 95 CA HuracánHuracán 0 - 2 Vélez SarsfieldVélez ...
09 Abr 95 Dep. EspañolDep. 2 - 0 Rosario CentralRosario ...
09 Abr 95 Racing ClubRacing Club 1 - 1 BelgranoBelgrano ...
09 Abr 95 River PlateRiver Plate 3 - 2 San LorenzoLorenzo ...
09 Abr 95 CD MandiyúMandiyú 1 - 3 Gimnasia La PlataGimnasia ...
09 Abr 95 PlatensePlatense 0 - 1 LanúsLanús ...
09 Abr 95 Newell's Old BoysNewell's 4 - 0 Argentinos JuniorsArgentinos ...
Jornada 8
16 Abr 95 BelgranoBelgrano 1 - 0 River PlateRiver Plate ...
16 Abr 95 Argentinos JuniorsArgentinos 2 - 2 CD MandiyúMandiyú ...
16 Abr 95 Boca JuniorsBoca 0 - 1 Racing ClubRacing Club ...
16 Abr 95 Ferro Carril OesteFerro 2 - 1 Newell's Old BoysNewell's ...
16 Abr 95 Rosario CentralRosario 0 - 0 PlatensePlatense ...
16 Abr 95 San LorenzoLorenzo 2 - 1 Gimnasia JujuyGimnasia ...
16 Abr 95 Gimnasia La PlataGimnasia 1 - 0 Dep. EspañolDep. ...
16 Abr 95 Vélez SarsfieldVélez 2 - 1 Talleres CórdobaTalleres ...
16 Abr 95 LanúsLanús 0 - 1 CA HuracánHuracán ...
16 Abr 95 IndependienteIndependien 0 - 1 BanfieldBanfield ...
Jornada 9
23 Abr 95 Boca JuniorsBoca 1 - 0 Vélez SarsfieldVélez ...
23 Abr 95 BanfieldBanfield 0 - 3 San LorenzoLorenzo ...
23 Abr 95 Talleres CórdobaTalleres 3 - 1 LanúsLanús ...
23 Abr 95 Dep. EspañolDep. 3 - 0 Argentinos JuniorsArgentinos ...
23 Abr 95 Racing ClubRacing Club 1 - 3 River PlateRiver Plate ...
23 Abr 95 PlatensePlatense 0 - 1 Gimnasia La PlataGimnasia ...
23 Abr 95 Newell's Old BoysNewell's 0 - 0 IndependienteIndependien ...
23 Abr 95 Gimnasia JujuyGimnasia 1 - 0 BelgranoBelgrano ...
23 Abr 95 CD MandiyúMandiyú 0 - 0 Ferro Carril OesteFerro ...
23 Abr 95 CA HuracánHuracán 2 - 5 Rosario CentralRosario ...
Jornada 10
30 Abr 95 BelgranoBelgrano 2 - 2 BanfieldBanfield ...
30 Abr 95 Argentinos JuniorsArgentinos 1 - 1 PlatensePlatense ...
30 Abr 95 Gimnasia La PlataGimnasia 2 - 1 CA HuracánHuracán ...
30 Abr 95 Ferro Carril OesteFerro 0 - 2 Dep. EspañolDep. ...
30 Abr 95 IndependienteIndependien 2 - 3 CD MandiyúMandiyú ...
30 Abr 95 Rosario CentralRosario 4 - 0 Talleres CórdobaTalleres ...
30 Abr 95 Vélez SarsfieldVélez 1 - 1 Racing ClubRacing Club ...
30 Abr 95 San LorenzoLorenzo 3 - 0 Newell's Old BoysNewell's ...
30 Abr 95 River PlateRiver Plate 0 - 1 Gimnasia JujuyGimnasia ...
30 Abr 95 LanúsLanús 1 - 1 Boca JuniorsBoca ...
Jornada 11
06 May 95 Boca JuniorsBoca 2 - 2 Rosario CentralRosario ...
06 May 95 Talleres CórdobaTalleres 1 - 2 Gimnasia La PlataGimnasia ...
06 May 95 BanfieldBanfield 1 - 1 River PlateRiver Plate ...
06 May 95 CA HuracánHuracán 2 - 2 Argentinos JuniorsArgentinos ...
06 May 95 Dep. EspañolDep. 0 - 0 IndependienteIndependien ...
06 May 95 CD MandiyúMandiyú 1 - 2 San LorenzoLorenzo ...
06 May 95 Newell's Old BoysNewell's 3 - 0 BelgranoBelgrano ...
06 May 95 Vélez SarsfieldVélez 2 - 1 LanúsLanús ...
06 May 95 Racing ClubRacing Club 0 - 0 Gimnasia JujuyGimnasia ...
06 May 95 PlatensePlatense 0 - 0 Ferro Carril OesteFerro ...
Jornada 12
09 May 95 BelgranoBelgrano 1 - 1 CD MandiyúMandiyú ...
09 May 95 Argentinos JuniorsArgentinos 1 - 1 Talleres CórdobaTalleres ...
09 May 95 Gimnasia JujuyGimnasia 1 - 1 BanfieldBanfield ...
09 May 95 Ferro Carril OesteFerro 1 - 2 CA HuracánHuracán ...
09 May 95 San LorenzoLorenzo 1 - 0 Dep. EspañolDep. ...
09 May 95 River PlateRiver Plate 1 - 0 Newell's Old BoysNewell's ...
09 May 95 Gimnasia La PlataGimnasia 0 - 0 Boca JuniorsBoca ...
09 May 95 Rosario CentralRosario 1 - 1 Vélez SarsfieldVélez ...
09 May 95 LanúsLanús 1 - 2 Racing ClubRacing Club ...
09 May 95 IndependienteIndependien 1 - 2 PlatensePlatense ...
Jornada 13
17 May 95 Boca JuniorsBoca 2 - 3 Argentinos JuniorsArgentinos ...
17 May 95 Talleres CórdobaTalleres 0 - 1 Ferro Carril OesteFerro ...
17 May 95 LanúsLanús 1 - 1 Rosario CentralRosario ...
17 May 95 CA HuracánHuracán 1 - 3 IndependienteIndependien ...
17 May 95 Dep. EspañolDep. 4 - 0 BelgranoBelgrano ...
17 May 95 Vélez SarsfieldVélez 1 - 2 Gimnasia La PlataGimnasia ...
17 May 95 CD MandiyúMandiyú 1 - 2 River PlateRiver Plate ...
17 May 95 Racing ClubRacing Club 1 - 1 BanfieldBanfield ...
17 May 95 PlatensePlatense 1 - 1 San LorenzoLorenzo ...
17 May 95 Newell's Old BoysNewell's 1 - 0 Gimnasia JujuyGimnasia ...
Jornada 14
21 May 95 BelgranoBelgrano 0 - 0 PlatensePlatense ...
21 May 95 BanfieldBanfield 0 - 1 Newell's Old BoysNewell's ...
21 May 95 Argentinos JuniorsArgentinos 0 - 2 Vélez SarsfieldVélez ...
21 May 95 Gimnasia JujuyGimnasia 1 - 1 CD MandiyúMandiyú ...
21 May 95 Ferro Carril OesteFerro 0 - 1 Boca JuniorsBoca ...
21 May 95 Gimnasia La PlataGimnasia 1 - 0 LanúsLanús ...
21 May 95 San LorenzoLorenzo 3 - 0 CA HuracánHuracán ...
21 May 95 Rosario CentralRosario 0 - 2 Racing ClubRacing Club ...
21 May 95 River PlateRiver Plate 0 - 2 Dep. EspañolDep. ...
21 May 95 IndependienteIndependien 3 - 1 Talleres CórdobaTalleres ...
Jornada 15
28 May 95 Talleres CórdobaTalleres 1 - 3 San LorenzoLorenzo ...
28 May 95 Boca JuniorsBoca 5 - 0 IndependienteIndependien ...
28 May 95 CD MandiyúMandiyú 1 - 0 BanfieldBanfield ...
28 May 95 LanúsLanús 0 - 0 Argentinos JuniorsArgentinos ...
28 May 95 Dep. EspañolDep. 1 - 1 Gimnasia JujuyGimnasia ...
28 May 95 CA HuracánHuracán 0 - 2 BelgranoBelgrano ...
28 May 95 Rosario CentralRosario 1 - 1 Gimnasia La PlataGimnasia ...
28 May 95 Vélez SarsfieldVélez 3 - 0 Ferro Carril OesteFerro ...
28 May 95 PlatensePlatense 0 - 0 River PlateRiver Plate ...
28 May 95 Racing ClubRacing Club 2 - 0 Newell's Old BoysNewell's ...
Jornada 16
04 Jun 95 San LorenzoLorenzo 2 - 0 Boca JuniorsBoca ...
04 Jun 95 Newell's Old BoysNewell's 3 - 0 CD MandiyúMandiyú ...
04 Jun 95 IndependienteIndependien 2 - 2 Vélez SarsfieldVélez ...
04 Jun 95 Gimnasia La PlataGimnasia 2 - 1 Racing ClubRacing Club ...
04 Jun 95 River PlateRiver Plate 3 - 1 CA HuracánHuracán ...
04 Jun 95 Gimnasia JujuyGimnasia 2 - 0 PlatensePlatense ...
04 Jun 95 Ferro Carril OesteFerro 0 - 0 LanúsLanús ...
04 Jun 95 Argentinos JuniorsArgentinos 1 - 1 Rosario CentralRosario ...
04 Jun 95 BanfieldBanfield 1 - 2 Dep. EspañolDep. ...
04 Jun 95 BelgranoBelgrano 1 - 1 Talleres CórdobaTalleres ...
Jornada 17
11 Jun 95 PlatensePlatense 2 - 0 BanfieldBanfield ...
11 Jun 95 Racing ClubRacing Club 1 - 1 CD MandiyúMandiyú ...
11 Jun 95 LanúsLanús 2 - 1 IndependienteIndependien ...
11 Jun 95 Vélez SarsfieldVélez 1 - 0 San LorenzoLorenzo ...
11 Jun 95 Rosario CentralRosario 1 - 1 Ferro Carril OesteFerro ...
11 Jun 95 Dep. EspañolDep. 3 - 1 Newell's Old BoysNewell's ...
11 Jun 95 Gimnasia La PlataGimnasia 3 - 1 Argentinos JuniorsArgentinos ...
11 Jun 95 CA HuracánHuracán 2 - 1 Gimnasia JujuyGimnasia ...
11 Jun 95 Boca JuniorsBoca 0 - 1 BelgranoBelgrano ...
11 Jun 95 Talleres CórdobaTalleres 2 - 1 River PlateRiver Plate ...
Jornada 18
18 Jun 95 CD MandiyúMandiyú 0 - 0 Dep. EspañolDep. ...
18 Jun 95 River PlateRiver Plate 2 - 4 Boca JuniorsBoca ...
18 Jun 95 San LorenzoLorenzo 1 - 0 LanúsLanús ...
18 Jun 95 IndependienteIndependien 3 - 2 Rosario CentralRosario ...
18 Jun 95 Newell's Old BoysNewell's 1 - 1 PlatensePlatense ...
18 Jun 95 Gimnasia JujuyGimnasia 2 - 2 Talleres CórdobaTalleres ...
18 Jun 95 Ferro Carril OesteFerro 0 - 1 Gimnasia La PlataGimnasia ...
18 Jun 95 BanfieldBanfield 3 - 1 CA HuracánHuracán ...
18 Jun 95 Argentinos JuniorsArgentinos 0 - 1 Racing ClubRacing Club ...
18 Jun 95 BelgranoBelgrano 0 - 2 Vélez SarsfieldVélez ...
Jornada 19
25 Jun 95 Racing ClubRacing Club 0 - 2 Dep. EspañolDep. ...
25 Jun 95 Rosario CentralRosario 0 - 1 San LorenzoLorenzo ...
25 Jun 95 Vélez SarsfieldVélez 3 - 1 River PlateRiver Plate ...
25 Jun 95 PlatensePlatense 4 - 2 CD MandiyúMandiyú ...
25 Jun 95 Gimnasia La PlataGimnasia 0 - 1 IndependienteIndependien ...
25 Jun 95 LanúsLanús 0 - 1 BelgranoBelgrano ...
25 Jun 95 CA HuracánHuracán 2 - 2 Newell's Old BoysNewell's ...
25 Jun 95 Argentinos JuniorsArgentinos 1 - 1 Ferro Carril OesteFerro ...
25 Jun 95 Boca JuniorsBoca 3 - 1 Gimnasia JujuyGimnasia ...
25 Jun 95 Talleres CórdobaTalleres 0 - 0 BanfieldBanfield ...

Clasificación

Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 19 31 12 44
2 Gimnasia La Plata Gimnasia 19 29 13 41
3 Vélez Sarsfield Vélez 19 31 13 40
4 Dep. Español Dep. 19 27 13 34
5 Boca Juniors Boca Juniors 19 33 19 33
6 Racing Club Racing Club 19 20 19 26
7 Lanús Lanús 19 21 19 25
8 River Plate River Plate 19 29 30 25
9 Independiente Independient 19 24 26 25
10 Rosario Central Rosario 19 29 23 24
11 Platense Platense 19 15 14 23
12 Gimnasia Jujuy Gimnasia 19 19 23 21
13 Banfield Banfield 19 17 22 21
14 Newell's Old Boys Newell's 19 21 27 20
15 Ferro Carril Oeste Ferro Carril 19 12 20 20
16 Belgrano Belgrano 19 12 26 20
17 Talleres Córdoba Talleres 19 20 29 18
18 CD Mandiyú CD Mandiyú 19 18 27 17
19 CA Huracán CA Huracán 19 20 35 16
20 Argentinos Juniors Argentinos 19 18 36 14

  USO DE MEMORIA  
6,420,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1101
Total Execution Time  0.1120
  CADENA URL  
/torneo_final1995/grupo1/calendario
  GET DATOS  
$_GET['/torneo_final1995/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0018  SELECT type FROM routes WHERE alias = 'torneo_final1995'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_final' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1995 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
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 = 8416 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0044  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, dt1.stadium as stadium_name FROM calendars1995 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 8416 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 12:49:04' 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=2 AND last_update > '2024-05-08 12:49:04' 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-08 12:49:04' 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-08 12:49:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_final' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1995 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0030  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 events1995 e ON e.player_id = p.id AND e.league_id = 8416 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8416 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.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 events1995 e ON e.player_id = p.id AND e.league_id = 8416 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8416 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0021  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 events1995 e ON e.player_id = p.id AND e.league_id = 8416 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8416 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 `tables1995` 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 = 8416 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC