4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
26 Ago 96 Ferro Carril OesteFerro 0 - 3 IndependienteIndependien ...
26 Ago 96 River PlateRiver Plate 0 - 0 Gimnasia La PlataGimnasia ...
26 Ago 96 ColónColón 1 - 1 Dep. EspañolDep. ...
26 Ago 96 LanúsLanús 0 - 0 CA HuracánHuracán ...
26 Ago 96 Estudiantes La PlataEstudiantes 2 - 3 Boca JuniorsBoca ...
26 Ago 96 Gimnasia JujuyGimnasia 1 - 0 PlatensePlatense ...
26 Ago 96 Huracán CorrientesHuracán 3 - 6 Unión Santa FeUnión ...
26 Ago 96 Racing ClubRacing Club 0 - 2 Rosario CentralRosario ...
26 Ago 96 Newell's Old BoysNewell's 0 - 2 Vélez SarsfieldVélez ...
26 Ago 96 San LorenzoLorenzo 0 - 1 BanfieldBanfield ...
Jornada 2
02 Sep 96 IndependienteIndependien 4 - 0 Newell's Old BoysNewell's ...
02 Sep 96 PlatensePlatense 2 - 4 Estudiantes La PlataEstudiantes ...
02 Sep 96 Unión Santa FeUnión 1 - 3 River PlateRiver Plate ...
02 Sep 96 Gimnasia JujuyGimnasia 0 - 0 Rosario CentralRosario ...
02 Sep 96 Vélez SarsfieldVélez 2 - 3 Racing ClubRacing Club ...
02 Sep 96 Dep. EspañolDep. 0 - 1 LanúsLanús ...
02 Sep 96 Gimnasia La PlataGimnasia 1 - 0 Ferro Carril OesteFerro ...
02 Sep 96 BanfieldBanfield 1 - 1 Huracán CorrientesHuracán ...
02 Sep 96 Boca JuniorsBoca 2 - 3 ColónColón ...
02 Sep 96 CA HuracánHuracán 1 - 1 San LorenzoLorenzo ...
Jornada 3
09 Sep 96 River PlateRiver Plate 2 - 0 BanfieldBanfield ...
09 Sep 96 San LorenzoLorenzo 0 - 1 Dep. EspañolDep. ...
09 Sep 96 Ferro Carril OesteFerro 2 - 2 Unión Santa FeUnión ...
09 Sep 96 Racing ClubRacing Club 0 - 0 Gimnasia JujuyGimnasia ...
09 Sep 96 Vélez SarsfieldVélez 2 - 3 IndependienteIndependien ...
09 Sep 96 Estudiantes La PlataEstudiantes 0 - 2 Rosario CentralRosario ...
09 Sep 96 Newell's Old BoysNewell's 1 - 0 Gimnasia La PlataGimnasia ...
09 Sep 96 ColónColón 1 - 1 PlatensePlatense ...
09 Sep 96 Huracán CorrientesHuracán 1 - 1 CA HuracánHuracán ...
09 Sep 96 LanúsLanús 3 - 1 Boca JuniorsBoca ...
Jornada 4
16 Sep 96 IndependienteIndependien 2 - 2 Racing ClubRacing Club ...
16 Sep 96 PlatensePlatense 0 - 0 LanúsLanús ...
16 Sep 96 BanfieldBanfield 3 - 2 Ferro Carril OesteFerro ...
16 Sep 96 CA HuracánHuracán 2 - 3 River PlateRiver Plate ...
16 Sep 96 Rosario CentralRosario 0 - 0 ColónColón ...
16 Sep 96 Gimnasia La PlataGimnasia 1 - 1 Vélez SarsfieldVélez ...
16 Sep 96 Gimnasia JujuyGimnasia 2 - 0 Estudiantes La PlataEstudiantes ...
16 Sep 96 Boca JuniorsBoca 1 - 1 San LorenzoLorenzo ...
16 Sep 96 Unión Santa FeUnión 1 - 2 Newell's Old BoysNewell's ...
16 Sep 96 Dep. EspañolDep. 1 - 0 Huracán CorrientesHuracán ...
Jornada 5
23 Sep 96 River PlateRiver Plate 3 - 1 Dep. EspañolDep. ...
23 Sep 96 Vélez SarsfieldVélez 2 - 0 Unión Santa FeUnión ...
23 Sep 96 ColónColón 0 - 0 Gimnasia JujuyGimnasia ...
23 Sep 96 Newell's Old BoysNewell's 2 - 0 BanfieldBanfield ...
23 Sep 96 San LorenzoLorenzo 1 - 0 PlatensePlatense ...
23 Sep 96 LanúsLanús 2 - 1 Rosario CentralRosario ...
23 Sep 96 Estudiantes La PlataEstudiantes 1 - 2 Racing ClubRacing Club ...
23 Sep 96 Ferro Carril OesteFerro 4 - 2 CA HuracánHuracán ...
23 Sep 96 Boca JuniorsBoca 3 - 1 Huracán CorrientesHuracán ...
23 Sep 96 IndependienteIndependien 2 - 0 Gimnasia La PlataGimnasia ...
Jornada 6
30 Sep 96 Racing ClubRacing Club 0 - 1 Gimnasia La PlataGimnasia ...
30 Sep 96 Rosario CentralRosario 1 - 2 San LorenzoLorenzo ...
30 Sep 96 Huracán CorrientesHuracán 1 - 0 PlatensePlatense ...
30 Sep 96 CA HuracánHuracán 1 - 1 Newell's Old BoysNewell's ...
30 Sep 96 Unión Santa FeUnión 0 - 1 IndependienteIndependien ...
30 Sep 96 Gimnasia JujuyGimnasia 1 - 2 LanúsLanús ...
30 Sep 96 BanfieldBanfield 1 - 3 Vélez SarsfieldVélez ...
30 Sep 96 Dep. EspañolDep. 2 - 2 Ferro Carril OesteFerro ...
30 Sep 96 Boca JuniorsBoca 3 - 2 River PlateRiver Plate 1
30 Sep 96 ColónColón 3 - 2 Estudiantes La PlataEstudiantes ...
Jornada 7
07 Oct 96 Newell's Old BoysNewell's 2 - 0 Dep. EspañolDep. ...
07 Oct 96 IndependienteIndependien 1 - 1 BanfieldBanfield ...
07 Oct 96 Vélez SarsfieldVélez 2 - 1 CA HuracánHuracán ...
07 Oct 96 Ferro Carril OesteFerro 3 - 1 Boca JuniorsBoca ...
07 Oct 96 Gimnasia La PlataGimnasia 1 - 1 Unión Santa FeUnión ...
07 Oct 96 River PlateRiver Plate 4 - 1 PlatensePlatense ...
07 Oct 96 ColónColón 0 - 2 Racing ClubRacing Club ...
07 Oct 96 San LorenzoLorenzo 1 - 0 Gimnasia JujuyGimnasia ...
07 Oct 96 LanúsLanús 0 - 0 Estudiantes La PlataEstudiantes ...
07 Oct 96 Huracán CorrientesHuracán 1 - 1 Rosario CentralRosario ...
Jornada 8
14 Oct 96 Boca JuniorsBoca 2 - 1 Newell's Old BoysNewell's ...
14 Oct 96 Estudiantes La PlataEstudiantes 1 - 0 San LorenzoLorenzo ...
14 Oct 96 IndependienteIndependien 1 - 1 CA HuracánHuracán ...
14 Oct 96 Racing ClubRacing Club 2 - 1 Unión Santa FeUnión ...
14 Oct 96 PlatensePlatense 1 - 0 Ferro Carril OesteFerro ...
14 Oct 96 BanfieldBanfield 0 - 2 Gimnasia La PlataGimnasia ...
14 Oct 96 Gimnasia JujuyGimnasia 0 - 0 Huracán CorrientesHuracán ...
14 Oct 96 Dep. EspañolDep. 1 - 2 Vélez SarsfieldVélez ...
14 Oct 96 ColónColón 0 - 1 LanúsLanús ...
14 Oct 96 Rosario CentralRosario 2 - 5 River PlateRiver Plate ...
Jornada 9
21 Oct 96 Ferro Carril OesteFerro 1 - 3 Rosario CentralRosario ...
21 Oct 96 Unión Santa FeUnión 3 - 1 BanfieldBanfield ...
21 Oct 96 Vélez SarsfieldVélez 1 - 1 Boca JuniorsBoca ...
21 Oct 96 Huracán CorrientesHuracán 2 - 2 Estudiantes La PlataEstudiantes ...
21 Oct 96 Newell's Old BoysNewell's 2 - 2 PlatensePlatense ...
21 Oct 96 San LorenzoLorenzo 4 - 1 ColónColón ...
21 Oct 96 LanúsLanús 1 - 1 Racing ClubRacing Club ...
21 Oct 96 River PlateRiver Plate 3 - 0 Gimnasia JujuyGimnasia ...
21 Oct 96 Gimnasia La PlataGimnasia 1 - 0 CA HuracánHuracán ...
21 Oct 96 IndependienteIndependien 2 - 2 Dep. EspañolDep. ...
Jornada 10
28 Oct 96 PlatensePlatense 4 - 4 Vélez SarsfieldVélez ...
28 Oct 96 Dep. EspañolDep. 1 - 2 Gimnasia La PlataGimnasia ...
28 Oct 96 Boca JuniorsBoca 0 - 1 IndependienteIndependien 1
28 Oct 96 Gimnasia JujuyGimnasia 2 - 2 Ferro Carril OesteFerro ...
28 Oct 96 CA HuracánHuracán 3 - 0 Unión Santa FeUnión ...
28 Oct 96 Rosario CentralRosario 1 - 1 Newell's Old BoysNewell's ...
28 Oct 96 LanúsLanús 3 - 1 San LorenzoLorenzo ...
28 Oct 96 Racing ClubRacing Club 1 - 0 BanfieldBanfield ...
28 Oct 96 Estudiantes La PlataEstudiantes 0 - 1 River PlateRiver Plate ...
28 Oct 96 ColónColón 1 - 1 Huracán CorrientesHuracán ...
Jornada 11
04 Nov 96 BanfieldBanfield 1 - 2 CA HuracánHuracán ...
04 Nov 96 Newell's Old BoysNewell's 3 - 1 Gimnasia JujuyGimnasia ...
04 Nov 96 Vélez SarsfieldVélez 4 - 4 Rosario CentralRosario ...
04 Nov 96 Unión Santa FeUnión 1 - 1 Dep. EspañolDep. ...
04 Nov 96 Ferro Carril OesteFerro 3 - 2 Estudiantes La PlataEstudiantes ...
04 Nov 96 River PlateRiver Plate 3 - 0 ColónColón ...
04 Nov 96 IndependienteIndependien 1 - 4 PlatensePlatense ...
04 Nov 96 Huracán CorrientesHuracán 1 - 1 LanúsLanús ...
04 Nov 96 San LorenzoLorenzo 3 - 0 Racing ClubRacing Club ...
04 Nov 96 Gimnasia La PlataGimnasia 1 - 1 Boca JuniorsBoca ...
Jornada 12
07 Nov 96 Racing ClubRacing Club 6 - 1 CA HuracánHuracán ...
07 Nov 96 Gimnasia JujuyGimnasia 1 - 1 Vélez SarsfieldVélez ...
07 Nov 96 Dep. EspañolDep. 0 - 0 BanfieldBanfield ...
07 Nov 96 Boca JuniorsBoca 2 - 0 Unión Santa FeUnión 1
07 Nov 96 Rosario CentralRosario 3 - 1 IndependienteIndependien ...
07 Nov 96 Estudiantes La PlataEstudiantes 0 - 5 Newell's Old BoysNewell's ...
07 Nov 96 PlatensePlatense 3 - 1 Gimnasia La PlataGimnasia ...
07 Nov 96 ColónColón 1 - 1 Ferro Carril OesteFerro ...
07 Nov 96 LanúsLanús 3 - 1 River PlateRiver Plate ...
07 Nov 96 San LorenzoLorenzo 4 - 2 Huracán CorrientesHuracán ...
Jornada 13
11 Nov 96 River PlateRiver Plate 4 - 0 San LorenzoLorenzo ...
11 Nov 96 Unión Santa FeUnión 0 - 1 PlatensePlatense ...
11 Nov 96 IndependienteIndependien 1 - 0 Gimnasia JujuyGimnasia ...
11 Nov 96 Newell's Old BoysNewell's 1 - 1 ColónColón ...
11 Nov 96 Vélez SarsfieldVélez 0 - 2 Estudiantes La PlataEstudiantes ...
11 Nov 96 BanfieldBanfield 3 - 1 Boca JuniorsBoca ...
11 Nov 96 Huracán CorrientesHuracán 2 - 3 Racing ClubRacing Club ...
11 Nov 96 Gimnasia La PlataGimnasia 1 - 2 Rosario CentralRosario ...
11 Nov 96 Ferro Carril OesteFerro 1 - 2 LanúsLanús ...
11 Nov 96 CA HuracánHuracán 1 - 0 Dep. EspañolDep. ...
Jornada 14
18 Nov 96 Rosario CentralRosario 1 - 3 Unión Santa FeUnión ...
18 Nov 96 San LorenzoLorenzo 2 - 2 Ferro Carril OesteFerro ...
18 Nov 96 Estudiantes La PlataEstudiantes 1 - 0 IndependienteIndependien ...
18 Nov 96 Huracán CorrientesHuracán 1 - 2 River PlateRiver Plate ...
18 Nov 96 Gimnasia JujuyGimnasia 1 - 0 Gimnasia La PlataGimnasia ...
18 Nov 96 ColónColón 2 - 1 Vélez SarsfieldVélez ...
18 Nov 96 Racing ClubRacing Club 0 - 0 Dep. EspañolDep. ...
18 Nov 96 Boca JuniorsBoca 6 - 0 CA HuracánHuracán ...
18 Nov 96 LanúsLanús 2 - 0 Newell's Old BoysNewell's ...
18 Nov 96 PlatensePlatense 2 - 0 BanfieldBanfield ...
Jornada 15
25 Nov 96 Vélez SarsfieldVélez 2 - 0 LanúsLanús ...
25 Nov 96 Newell's Old BoysNewell's 0 - 2 San LorenzoLorenzo ...
25 Nov 96 Unión Santa FeUnión 2 - 0 Gimnasia JujuyGimnasia ...
25 Nov 96 River PlateRiver Plate 4 - 3 Racing ClubRacing Club ...
25 Nov 96 IndependienteIndependien 2 - 1 ColónColón ...
25 Nov 96 CA HuracánHuracán 1 - 1 PlatensePlatense ...
25 Nov 96 BanfieldBanfield 1 - 1 Rosario CentralRosario ...
25 Nov 96 Dep. EspañolDep. 1 - 1 Boca JuniorsBoca ...
25 Nov 96 Gimnasia La PlataGimnasia 0 - 0 Estudiantes La PlataEstudiantes ...
25 Nov 96 Ferro Carril OesteFerro 5 - 1 Huracán CorrientesHuracán ...
Jornada 16
02 Dic 96 River PlateRiver Plate 5 - 1 Ferro Carril OesteFerro ...
02 Dic 96 Rosario CentralRosario 1 - 1 CA HuracánHuracán ...
02 Dic 96 PlatensePlatense 1 - 1 Dep. EspañolDep. ...
02 Dic 96 Racing ClubRacing Club 4 - 2 Boca JuniorsBoca ...
02 Dic 96 San LorenzoLorenzo 1 - 0 Vélez SarsfieldVélez ...
02 Dic 96 LanúsLanús 1 - 2 IndependienteIndependien ...
02 Dic 96 ColónColón 3 - 1 Gimnasia La PlataGimnasia ...
02 Dic 96 Gimnasia JujuyGimnasia 4 - 1 BanfieldBanfield ...
02 Dic 96 Estudiantes La PlataEstudiantes 1 - 0 Unión Santa FeUnión ...
02 Dic 96 Huracán CorrientesHuracán 4 - 1 Newell's Old BoysNewell's ...
Jornada 17
09 Dic 96 Ferro Carril OesteFerro 1 - 1 Racing ClubRacing Club ...
09 Dic 96 Dep. EspañolDep. 2 - 3 Rosario CentralRosario ...
09 Dic 96 Gimnasia La PlataGimnasia 0 - 0 LanúsLanús ...
09 Dic 96 Newell's Old BoysNewell's 1 - 3 River PlateRiver Plate ...
09 Dic 96 CA HuracánHuracán 2 - 3 Gimnasia JujuyGimnasia ...
09 Dic 96 IndependienteIndependien 2 - 0 San LorenzoLorenzo ...
09 Dic 96 Vélez SarsfieldVélez 0 - 3 Huracán CorrientesHuracán ...
09 Dic 96 Boca JuniorsBoca 4 - 1 PlatensePlatense ...
09 Dic 96 Unión Santa FeUnión 1 - 1 ColónColón ...
09 Dic 96 BanfieldBanfield 0 - 4 Estudiantes La PlataEstudiantes ...
Jornada 18
16 Dic 96 Gimnasia JujuyGimnasia 1 - 1 Dep. EspañolDep. ...
16 Dic 96 Ferro Carril OesteFerro 0 - 0 Newell's Old BoysNewell's ...
16 Dic 96 Estudiantes La PlataEstudiantes 3 - 1 CA HuracánHuracán ...
16 Dic 96 LanúsLanús 0 - 0 Unión Santa FeUnión ...
16 Dic 96 ColónColón 6 - 0 BanfieldBanfield ...
16 Dic 96 San LorenzoLorenzo 1 - 2 Gimnasia La PlataGimnasia ...
16 Dic 96 Racing ClubRacing Club 1 - 0 PlatensePlatense ...
16 Dic 96 Huracán CorrientesHuracán 3 - 2 IndependienteIndependien ...
16 Dic 96 Rosario CentralRosario 4 - 2 Boca JuniorsBoca ...
16 Dic 96 River PlateRiver Plate 3 - 0 Vélez SarsfieldVélez ...
Jornada 19
23 Dic 97 Newell's Old BoysNewell's 1 - 0 Racing ClubRacing Club ...
23 Dic 97 Unión Santa FeUnión 2 - 0 San LorenzoLorenzo ...
23 Dic 97 Vélez SarsfieldVélez 0 - 2 Ferro Carril OesteFerro ...
23 Dic 97 IndependienteIndependien 3 - 1 River PlateRiver Plate ...
23 Dic 97 PlatensePlatense 1 - 3 Rosario CentralRosario ...
23 Dic 97 Dep. EspañolDep. 2 - 2 Estudiantes La PlataEstudiantes ...
23 Dic 97 BanfieldBanfield 0 - 1 LanúsLanús ...
23 Dic 97 Boca JuniorsBoca 0 - 1 Gimnasia JujuyGimnasia ...
23 Dic 97 Gimnasia La PlataGimnasia 6 - 3 Huracán CorrientesHuracán ...
23 Dic 97 CA HuracánHuracán 0 - 1 ColónColón ...

Clasificación

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

  USO DE MEMORIA  
6,305,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4227
Total Execution Time  0.4245
  CADENA URL  
/torneo_inicial1997/grupo1/calendario
  GET DATOS  
$_GET['/torneo_inicial1997/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0124  SELECT type FROM routes WHERE alias = 'torneo_inicial1997'
0.0252  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 = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=26 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 26 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (932839,841) ORDER BY n.cover_points DESC, update_date DESC
0.0126  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 = 8406 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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 calendars1997 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 8406 ORDER BY round ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 18:55:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 18:55:00' 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-09 18:55:00' 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-09 18:55:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  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 = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 26 AND l.year = 1997
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (8406) 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.0128  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 (8406) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (27455,359736,252637,438048,446796,1211,259170,258071,258315,258448) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 26 AND l.year = 1997
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (8406) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 26 AND l.year = 1997
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (8406) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0127  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 (8406) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (261406,507577,508734,540529) ORDER BY rp.in_squad = 1 DESC
0.0139  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` 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 = 8406 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC