4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
06 Ago 95 River PlateRiver Plate 2 - 1 San LorenzoLorenzo ...
06 Ago 95 Estudiantes La PlataEstudiantes 0 - 0 ColónColón ...
18 Oct 95 Gimnasia JujuyGimnasia 1 - 2 Boca JuniorsBoca 1
06 Ago 95 Racing ClubRacing Club 2 - 0 Argentinos JuniorsArgentinos ...
06 Ago 95 Ferro Carril OesteFerro 1 - 1 IndependienteIndependien ...
06 Ago 95 PlatensePlatense 0 - 1 LanúsLanús ...
06 Ago 95 BanfieldBanfield 0 - 1 Vélez SarsfieldVélez ...
06 Ago 95 CA HuracánHuracán 2 - 2 Newell's Old BoysNewell's ...
06 Ago 95 Rosario CentralRosario 0 - 0 BelgranoBelgrano ...
06 Ago 95 Dep. EspañolDep. 1 - 1 Gimnasia La PlataGimnasia ...
Jornada 2
13 Ago 95 Gimnasia La PlataGimnasia 1 - 1 Gimnasia JujuyGimnasia ...
13 Ago 95 Argentinos JuniorsArgentinos 0 - 0 Estudiantes La PlataEstudiantes ...
13 Ago 95 ColónColón 0 - 0 Dep. EspañolDep. ...
13 Ago 95 Vélez SarsfieldVélez 1 - 0 Rosario CentralRosario ...
13 Ago 95 LanúsLanús 1 - 1 Ferro Carril OesteFerro ...
13 Ago 95 Newell's Old BoysNewell's 1 - 1 PlatensePlatense ...
13 Ago 95 San LorenzoLorenzo 1 - 0 Racing ClubRacing Club ...
13 Ago 95 BelgranoBelgrano 0 - 2 River PlateRiver Plate ...
13 Ago 95 IndependienteIndependien 1 - 1 BanfieldBanfield ...
13 Ago 95 Boca JuniorsBoca 2 - 1 CA HuracánHuracán ...
Jornada 3
20 Ago 95 LanúsLanús 2 - 1 IndependienteIndependien ...
20 Ago 95 River PlateRiver Plate 1 - 1 Vélez SarsfieldVélez ...
20 Ago 95 Estudiantes La PlataEstudiantes 1 - 1 San LorenzoLorenzo ...
20 Ago 95 Ferro Carril OesteFerro 1 - 2 Newell's Old BoysNewell's ...
20 Ago 95 Dep. EspañolDep. 0 - 0 Argentinos JuniorsArgentinos ...
20 Ago 95 Rosario CentralRosario 1 - 1 BanfieldBanfield ...
20 Ago 95 Racing ClubRacing Club 1 - 0 BelgranoBelgrano ...
20 Ago 95 PlatensePlatense 0 - 1 Boca JuniorsBoca ...
20 Ago 95 CA HuracánHuracán 1 - 1 Gimnasia La PlataGimnasia ...
20 Ago 95 Gimnasia JujuyGimnasia 1 - 0 ColónColón ...
Jornada 4
27 Ago 95 Vélez SarsfieldVélez 3 - 2 Racing ClubRacing Club ...
27 Ago 95 BanfieldBanfield 1 - 2 River PlateRiver Plate ...
27 Ago 95 Argentinos JuniorsArgentinos 4 - 0 Gimnasia JujuyGimnasia ...
27 Ago 95 BelgranoBelgrano 1 - 1 Estudiantes La PlataEstudiantes ...
27 Ago 95 Newell's Old BoysNewell's 0 - 1 LanúsLanús ...
27 Ago 95 San LorenzoLorenzo 1 - 0 Dep. EspañolDep. ...
27 Ago 95 Gimnasia La PlataGimnasia 0 - 1 PlatensePlatense ...
27 Ago 95 ColónColón 3 - 0 CA HuracánHuracán ...
27 Ago 95 IndependienteIndependien 1 - 1 Rosario CentralRosario ...
27 Ago 95 Boca JuniorsBoca 2 - 2 Ferro Carril OesteFerro ...
Jornada 5
03 Sep 95 Dep. EspañolDep. 0 - 0 BelgranoBelgrano ...
03 Sep 95 PlatensePlatense 1 - 0 ColónColón ...
03 Sep 95 Newell's Old BoysNewell's 1 - 0 IndependienteIndependien ...
03 Sep 95 Gimnasia JujuyGimnasia 4 - 3 San LorenzoLorenzo ...
03 Sep 95 Racing ClubRacing Club 1 - 0 BanfieldBanfield ...
03 Sep 95 CA HuracánHuracán 0 - 1 Argentinos JuniorsArgentinos ...
03 Sep 95 LanúsLanús 1 - 1 Boca JuniorsBoca ...
03 Sep 95 Estudiantes La PlataEstudiantes 0 - 1 Vélez SarsfieldVélez ...
03 Sep 95 River PlateRiver Plate 0 - 0 Rosario CentralRosario ...
03 Sep 95 Ferro Carril OesteFerro 0 - 1 Gimnasia La PlataGimnasia ...
Jornada 6
10 Sep 95 BanfieldBanfield 1 - 0 Estudiantes La PlataEstudiantes ...
10 Sep 95 Gimnasia La PlataGimnasia 1 - 0 LanúsLanús ...
10 Sep 95 ColónColón 0 - 2 Ferro Carril OesteFerro ...
10 Sep 95 Argentinos JuniorsArgentinos 2 - 3 PlatensePlatense ...
10 Sep 95 San LorenzoLorenzo 5 - 0 CA HuracánHuracán ...
10 Sep 95 IndependienteIndependien 0 - 0 River PlateRiver Plate ...
10 Sep 95 Vélez SarsfieldVélez 2 - 3 Dep. EspañolDep. ...
10 Sep 95 Boca JuniorsBoca 1 - 1 Newell's Old BoysNewell's ...
10 Sep 95 Rosario CentralRosario 1 - 3 Racing ClubRacing Club ...
10 Sep 95 BelgranoBelgrano 0 - 3 Gimnasia JujuyGimnasia ...
Jornada 7
24 Sep 95 Racing ClubRacing Club 1 - 1 River PlateRiver Plate ...
24 Sep 95 Estudiantes La PlataEstudiantes 1 - 2 Rosario CentralRosario ...
24 Sep 95 Ferro Carril OesteFerro 0 - 0 Argentinos JuniorsArgentinos ...
24 Sep 95 Newell's Old BoysNewell's 1 - 1 Gimnasia La PlataGimnasia ...
24 Sep 95 Dep. EspañolDep. 2 - 2 BanfieldBanfield ...
24 Sep 95 LanúsLanús 1 - 1 ColónColón ...
24 Sep 95 Gimnasia JujuyGimnasia 1 - 0 Vélez SarsfieldVélez ...
24 Sep 95 PlatensePlatense 2 - 3 San LorenzoLorenzo ...
24 Sep 95 Boca JuniorsBoca 0 - 0 IndependienteIndependien ...
24 Sep 95 CA HuracánHuracán 2 - 1 BelgranoBelgrano ...
Jornada 8
01 Oct 95 BelgranoBelgrano 0 - 0 PlatensePlatense ...
01 Oct 95 Argentinos JuniorsArgentinos 0 - 3 LanúsLanús ...
01 Oct 95 BanfieldBanfield 2 - 2 Gimnasia JujuyGimnasia ...
01 Oct 95 ColónColón 1 - 1 Newell's Old BoysNewell's ...
09 Nov 95 Gimnasia La PlataGimnasia 0 - 1 Boca JuniorsBoca ...
01 Oct 95 River PlateRiver Plate 2 - 2 Estudiantes La PlataEstudiantes ...
01 Oct 95 Vélez SarsfieldVélez 1 - 2 CA HuracánHuracán ...
01 Oct 95 San LorenzoLorenzo 1 - 1 Ferro Carril OesteFerro ...
01 Oct 95 Rosario CentralRosario 2 - 1 Dep. EspañolDep. ...
01 Oct 95 IndependienteIndependien 2 - 2 Racing ClubRacing Club ...
Jornada 9
08 Oct 95 IndependienteIndependien 0 - 0 Gimnasia La PlataGimnasia ...
08 Oct 95 LanúsLanús 1 - 3 San LorenzoLorenzo ...
08 Oct 95 CA HuracánHuracán 2 - 0 BanfieldBanfield ...
08 Oct 95 Newell's Old BoysNewell's 3 - 2 Argentinos JuniorsArgentinos ...
08 Oct 95 Estudiantes La PlataEstudiantes 2 - 3 Racing ClubRacing Club ...
08 Oct 95 Gimnasia JujuyGimnasia 4 - 2 Rosario CentralRosario ...
08 Oct 95 PlatensePlatense 1 - 2 Vélez SarsfieldVélez ...
08 Oct 95 Ferro Carril OesteFerro 4 - 2 BelgranoBelgrano ...
08 Oct 95 Dep. EspañolDep. 0 - 1 River PlateRiver Plate ...
08 Oct 95 Boca JuniorsBoca 1 - 0 ColónColón ...
Jornada 10
15 Oct 95 Racing ClubRacing Club 0 - 1 Dep. EspañolDep. ...
15 Oct 95 ColónColón 4 - 1 Gimnasia La PlataGimnasia ...
15 Oct 95 Vélez SarsfieldVélez 1 - 0 Ferro Carril OesteFerro ...
15 Oct 95 Rosario CentralRosario 0 - 0 CA HuracánHuracán ...
15 Oct 95 BanfieldBanfield 0 - 1 PlatensePlatense ...
15 Oct 95 BelgranoBelgrano 1 - 1 LanúsLanús ...
15 Oct 95 River PlateRiver Plate 1 - 0 Gimnasia JujuyGimnasia ...
15 Oct 95 Estudiantes La PlataEstudiantes 1 - 2 IndependienteIndependien ...
15 Oct 95 San LorenzoLorenzo 5 - 2 Newell's Old BoysNewell's ...
15 Oct 95 Argentinos JuniorsArgentinos 0 - 1 Boca JuniorsBoca 1
Jornada 11
22 Oct 95 CA HuracánHuracán 2 - 0 River PlateRiver Plate ...
22 Oct 95 Ferro Carril OesteFerro 3 - 3 BanfieldBanfield ...
22 Oct 95 Dep. EspañolDep. 1 - 0 Estudiantes La PlataEstudiantes ...
22 Oct 95 Newell's Old BoysNewell's 2 - 1 BelgranoBelgrano ...
22 Oct 95 LanúsLanús 0 - 0 Vélez SarsfieldVélez ...
22 Oct 95 IndependienteIndependien 1 - 2 ColónColón ...
22 Oct 95 Boca JuniorsBoca 0 - 0 San LorenzoLorenzo ...
22 Oct 95 Gimnasia JujuyGimnasia 1 - 2 Racing ClubRacing Club ...
22 Oct 95 Gimnasia La PlataGimnasia 2 - 1 Argentinos JuniorsArgentinos ...
22 Oct 95 PlatensePlatense 1 - 1 Rosario CentralRosario ...
Jornada 12
29 Oct 95 Dep. EspañolDep. 0 - 1 IndependienteIndependien ...
29 Oct 95 Rosario CentralRosario 2 - 0 Ferro Carril OesteFerro ...
29 Oct 95 Argentinos JuniorsArgentinos 2 - 0 ColónColón ...
29 Oct 95 BanfieldBanfield 0 - 2 LanúsLanús ...
29 Oct 95 Vélez SarsfieldVélez 3 - 1 Newell's Old BoysNewell's ...
29 Oct 95 San LorenzoLorenzo 0 - 2 Gimnasia La PlataGimnasia ...
29 Oct 95 River PlateRiver Plate 1 - 1 PlatensePlatense ...
29 Oct 95 BelgranoBelgrano 0 - 1 Boca JuniorsBoca ...
29 Oct 95 Estudiantes La PlataEstudiantes 4 - 1 Gimnasia JujuyGimnasia ...
29 Oct 95 Racing ClubRacing Club 1 - 1 CA HuracánHuracán ...
Jornada 13
05 Nov 95 Newell's Old BoysNewell's 1 - 1 BanfieldBanfield ...
05 Nov 95 IndependienteIndependien 2 - 0 Argentinos JuniorsArgentinos ...
05 Nov 95 Gimnasia JujuyGimnasia 2 - 1 Dep. EspañolDep. ...
05 Nov 95 LanúsLanús 3 - 0 Rosario CentralRosario ...
05 Nov 95 Ferro Carril OesteFerro 1 - 2 River PlateRiver Plate ...
05 Nov 95 PlatensePlatense 0 - 0 Racing ClubRacing Club ...
05 Nov 95 Gimnasia La PlataGimnasia 0 - 3 BelgranoBelgrano ...
05 Nov 95 Boca JuniorsBoca 1 - 0 Vélez SarsfieldVélez ...
05 Nov 95 ColónColón 0 - 2 San LorenzoLorenzo ...
05 Nov 95 CA HuracánHuracán 2 - 2 Estudiantes La PlataEstudiantes ...
Jornada 14
12 Nov 95 BelgranoBelgrano 0 - 0 ColónColón ...
12 Nov 95 Dep. EspañolDep. 0 - 4 CA HuracánHuracán ...
12 Nov 95 Vélez SarsfieldVélez 2 - 0 Gimnasia La PlataGimnasia ...
12 Nov 95 Estudiantes La PlataEstudiantes 2 - 2 PlatensePlatense ...
12 Nov 95 Rosario CentralRosario 2 - 0 Newell's Old BoysNewell's ...
12 Nov 95 San LorenzoLorenzo 0 - 2 Argentinos JuniorsArgentinos ...
12 Nov 95 Gimnasia JujuyGimnasia 1 - 0 IndependienteIndependien ...
12 Nov 95 Racing ClubRacing Club 1 - 1 Ferro Carril OesteFerro ...
12 Nov 95 BanfieldBanfield 0 - 2 Boca JuniorsBoca ...
12 Nov 95 River PlateRiver Plate 0 - 1 LanúsLanús ...
Jornada 15
19 Nov 95 Ferro Carril OesteFerro 1 - 4 Estudiantes La PlataEstudiantes ...
19 Nov 95 Argentinos JuniorsArgentinos 1 - 2 BelgranoBelgrano ...
19 Nov 95 CA HuracánHuracán 2 - 1 Gimnasia JujuyGimnasia ...
19 Nov 95 PlatensePlatense 1 - 1 Dep. EspañolDep. ...
19 Nov 95 ColónColón 1 - 2 Vélez SarsfieldVélez ...
19 Nov 95 Gimnasia La PlataGimnasia 2 - 1 BanfieldBanfield ...
19 Nov 95 Boca JuniorsBoca 0 - 0 Rosario CentralRosario ...
19 Nov 95 Newell's Old BoysNewell's 3 - 1 River PlateRiver Plate ...
19 Nov 95 LanúsLanús 0 - 3 Racing ClubRacing Club ...
19 Nov 95 IndependienteIndependien 0 - 0 San LorenzoLorenzo ...
Jornada 16
26 Nov 95 BanfieldBanfield 1 - 1 ColónColón ...
26 Nov 95 Rosario CentralRosario 2 - 0 Gimnasia La PlataGimnasia ...
26 Nov 95 Dep. EspañolDep. 0 - 1 Ferro Carril OesteFerro ...
26 Nov 95 Estudiantes La PlataEstudiantes 2 - 1 LanúsLanús ...
26 Nov 95 Gimnasia JujuyGimnasia 4 - 3 PlatensePlatense ...
26 Nov 95 CA HuracánHuracán 1 - 0 IndependienteIndependien ...
26 Nov 95 Vélez SarsfieldVélez 2 - 0 Argentinos JuniorsArgentinos ...
26 Nov 95 River PlateRiver Plate 0 - 0 Boca JuniorsBoca ...
26 Nov 95 BelgranoBelgrano 1 - 2 San LorenzoLorenzo ...
26 Nov 95 Racing ClubRacing Club 4 - 1 Newell's Old BoysNewell's ...
Jornada 17
03 Dic 95 Ferro Carril OesteFerro 1 - 1 Gimnasia JujuyGimnasia ...
03 Dic 95 Newell's Old BoysNewell's 1 - 2 Estudiantes La PlataEstudiantes ...
03 Dic 95 Argentinos JuniorsArgentinos 0 - 1 BanfieldBanfield ...
03 Dic 95 LanúsLanús 3 - 2 Dep. EspañolDep. ...
03 Dic 95 PlatensePlatense 1 - 2 CA HuracánHuracán ...
03 Dic 95 San LorenzoLorenzo 0 - 2 Vélez SarsfieldVélez ...
03 Dic 95 Gimnasia La PlataGimnasia 1 - 1 River PlateRiver Plate ...
03 Dic 95 IndependienteIndependien 1 - 0 BelgranoBelgrano ...
03 Dic 95 ColónColón 2 - 0 Rosario CentralRosario ...
03 Dic 95 Boca JuniorsBoca 4 - 6 Racing ClubRacing Club ...
Jornada 18
10 Dic 95 Dep. EspañolDep. 3 - 3 Newell's Old BoysNewell's ...
10 Dic 95 CA HuracánHuracán 1 - 0 Ferro Carril OesteFerro ...
10 Dic 95 BanfieldBanfield 2 - 5 San LorenzoLorenzo ...
10 Dic 95 Rosario CentralRosario 0 - 0 Argentinos JuniorsArgentinos ...
10 Dic 95 Vélez SarsfieldVélez 2 - 0 BelgranoBelgrano ...
10 Dic 95 Racing ClubRacing Club 2 - 0 Gimnasia La PlataGimnasia ...
10 Dic 95 Estudiantes La PlataEstudiantes 2 - 1 Boca JuniorsBoca ...
10 Dic 95 River PlateRiver Plate 3 - 2 ColónColón ...
10 Dic 95 Gimnasia JujuyGimnasia 0 - 2 LanúsLanús ...
10 Dic 95 PlatensePlatense 2 - 2 IndependienteIndependien ...
Jornada 19
17 Dic 95 Gimnasia La PlataGimnasia 0 - 3 Estudiantes La PlataEstudiantes ...
17 Dic 95 Argentinos JuniorsArgentinos 3 - 1 River PlateRiver Plate ...
17 Dic 95 BelgranoBelgrano 0 - 0 BanfieldBanfield ...
17 Dic 95 LanúsLanús 1 - 0 CA HuracánHuracán ...
17 Dic 95 Ferro Carril OesteFerro 1 - 4 PlatensePlatense ...
17 Dic 95 ColónColón 5 - 1 Racing ClubRacing Club ...
17 Dic 95 San LorenzoLorenzo 2 - 2 Rosario CentralRosario ...
17 Dic 95 Boca JuniorsBoca 2 - 2 Dep. EspañolDep. ...
17 Dic 95 Newell's Old BoysNewell's 0 - 0 Gimnasia JujuyGimnasia ...
17 Dic 95 IndependienteIndependien 0 - 3 Vélez SarsfieldVélez ...

Clasificación

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

  USO DE MEMORIA  
6,324,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3691
Total Execution Time  0.3710
  CADENA URL  
/torneo_inicial1996/grupo1/calendario
  GET DATOS  
$_GET['/torneo_inicial1996/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0105  SELECT type FROM routes WHERE alias = 'torneo_inicial1996'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_inicial' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1996 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT id,name,alias,stepParent FROM categories WHERE parentId=26 ORDER BY order_id ASC
0.0107  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 = 8409 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0120  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 calendars1996 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 8409 ORDER BY round ASC
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:59:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:59:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:59:59' 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=3 AND last_update > '2024-04-27 15:59:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_inicial' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1996 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 26 AND l.year = 1996
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (8409) 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, e.player_id ASC LIMIT 10
0.0112  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (8409) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (258964,256710,258555,508550,258247,321990,335227,406238,530253,540024) ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 26 AND l.year = 1996
0.0113  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (8409) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0119  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (8409) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (256710,257278,257923,258480,330707,530229,537745,267143,321990,513029) ORDER BY rp.in_squad = 1 DESC
0.0111  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 26 AND l.year = 1996
0.0111  SELECT e.action, count(e.action) as total, e.player_id FROM events1996 e WHERE e.league_id IN (8409) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0110  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (8409) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (257278,258480,330627,512719,537745,540202) ORDER BY rp.in_squad = 1 DESC
0.0123  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1996` 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 = 8409 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC