4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
08 Feb 08 San LorenzoLorenzo 0 - 2 Newell's Old BoysNewell's ...
09 Feb 08 Estudiantes La PlataEstudiantes 2 - 1 BanfieldBanfield ...
09 Feb 08 San Martín San JuanMartín 2 - 0 Argentinos JuniorsArgentinos ...
09 Feb 08 TigreTigre 2 - 1 Gimnasia La PlataGimnasia ...
09 Feb 08 Vélez SarsfieldVélez 4 - 3 ColónColón ...
10 Feb 08 Racing ClubRacing Club 1 - 1 OlimpoOlimpo ...
10 Feb 08 LanúsLanús 1 - 0 IndependienteIndependien ...
10 Feb 08 Rosario CentralRosario 1 - 1 Boca JuniorsBoca 1
10 Feb 08 Arsenal de SarandíArsenal 2 - 0 CA HuracánHuracán ...
10 Feb 08 River PlateRiver Plate 2 - 0 Gimnasia JujuyGimnasia ...
Jornada 2
15 Feb 08 BanfieldBanfield 3 - 1 Racing ClubRacing Club ...
16 Feb 08 ColónColón 3 - 0 Arsenal de SarandíArsenal ...
16 Feb 08 Gimnasia La PlataGimnasia 2 - 0 Rosario CentralRosario ...
16 Feb 08 San LorenzoLorenzo 0 - 1 San Martín San JuanMartín ...
16 Feb 08 Gimnasia JujuyGimnasia 0 - 2 Estudiantes La PlataEstudiantes ...
17 Feb 08 IndependienteIndependien 4 - 1 TigreTigre ...
17 Feb 08 OlimpoOlimpo 0 - 2 Vélez SarsfieldVélez ...
17 Feb 08 Newell's Old BoysNewell's 0 - 0 River PlateRiver Plate ...
17 Feb 08 CA HuracánHuracán 1 - 0 LanúsLanús ...
17 Feb 08 Boca JuniorsBoca 4 - 0 Argentinos JuniorsArgentinos ...
Jornada 3
22 Feb 08 Estudiantes La PlataEstudiantes 5 - 2 Newell's Old BoysNewell's ...
23 Feb 08 LanúsLanús 5 - 1 ColónColón ...
23 Feb 08 Racing ClubRacing Club 0 - 0 Gimnasia JujuyGimnasia ...
23 Feb 08 Vélez SarsfieldVélez 3 - 0 BanfieldBanfield ...
23 Feb 08 Argentinos JuniorsArgentinos 2 - 0 Gimnasia La PlataGimnasia ...
24 Feb 08 TigreTigre 1 - 2 CA HuracánHuracán ...
24 Feb 08 Rosario CentralRosario 2 - 0 IndependienteIndependien ...
24 Feb 08 River PlateRiver Plate 2 - 0 San LorenzoLorenzo ...
24 Feb 08 Arsenal de SarandíArsenal 1 - 0 OlimpoOlimpo ...
24 Feb 08 San Martín San JuanMartín 0 - 2 Boca JuniorsBoca ...
Jornada 4
29 Feb 08 CA HuracánHuracán 1 - 1 Rosario CentralRosario ...
01 Mar 08 BanfieldBanfield 1 - 3 Arsenal de SarandíArsenal ...
01 Mar 08 ColónColón 1 - 2 TigreTigre ...
01 Mar 08 Gimnasia JujuyGimnasia 0 - 0 Vélez SarsfieldVélez ...
01 Mar 08 IndependienteIndependien 2 - 0 Argentinos JuniorsArgentinos ...
02 Mar 08 OlimpoOlimpo 3 - 2 LanúsLanús ...
02 Mar 08 San LorenzoLorenzo 3 - 1 Estudiantes La PlataEstudiantes ...
02 Mar 08 Newell's Old BoysNewell's 1 - 0 Racing ClubRacing Club ...
02 Mar 08 Gimnasia La PlataGimnasia 0 - 1 Boca JuniorsBoca ...
19 Mar 08 River PlateRiver Plate 3 - 2 San Martín San JuanMartín ...
Jornada 5
07 Mar 08 Racing ClubRacing Club 0 - 1 San LorenzoLorenzo ...
08 Mar 08 Rosario CentralRosario 0 - 0 ColónColón ...
08 Mar 08 LanúsLanús 0 - 5 BanfieldBanfield 2
08 Mar 08 Argentinos JuniorsArgentinos 1 - 1 CA HuracánHuracán ...
08 Mar 08 San Martín San JuanMartín 1 - 1 Gimnasia La PlataGimnasia ...
09 Mar 08 Vélez SarsfieldVélez 1 - 0 Newell's Old BoysNewell's ...
09 Mar 08 TigreTigre 2 - 0 OlimpoOlimpo ...
09 Mar 08 Boca JuniorsBoca 1 - 1 IndependienteIndependien ...
09 Mar 08 Arsenal de SarandíArsenal 3 - 3 Gimnasia JujuyGimnasia ...
09 Mar 08 Estudiantes La PlataEstudiantes 0 - 0 River PlateRiver Plate ...
Jornada 6
14 Mar 08 OlimpoOlimpo 1 - 3 Rosario CentralRosario ...
15 Mar 08 Estudiantes La PlataEstudiantes 3 - 2 San Martín San JuanMartín ...
15 Mar 08 BanfieldBanfield 3 - 3 TigreTigre ...
16 Mar 08 ColónColón 0 - 1 Argentinos JuniorsArgentinos ...
16 Mar 08 IndependienteIndependien 3 - 1 Gimnasia La PlataGimnasia ...
16 Mar 08 River PlateRiver Plate 0 - 0 Racing ClubRacing Club ...
16 Mar 08 CA HuracánHuracán 0 - 0 Boca JuniorsBoca ...
16 Mar 08 Newell's Old BoysNewell's 4 - 1 Arsenal de SarandíArsenal ...
23 Abr 08 San LorenzoLorenzo 1 - 0 Vélez SarsfieldVélez ...
23 Abr 08 Gimnasia JujuyGimnasia 2 - 0 LanúsLanús ...
Jornada 7
21 Mar 08 Arsenal de SarandíArsenal 0 - 1 San LorenzoLorenzo ...
22 Mar 08 TigreTigre 2 - 0 Gimnasia JujuyGimnasia ...
22 Mar 08 Rosario CentralRosario 2 - 1 BanfieldBanfield ...
22 Mar 08 Argentinos JuniorsArgentinos 1 - 0 OlimpoOlimpo ...
23 Mar 08 Racing ClubRacing Club 1 - 2 Estudiantes La PlataEstudiantes ...
23 Mar 08 Vélez SarsfieldVélez 0 - 2 River PlateRiver Plate 1
23 Mar 08 Boca JuniorsBoca 2 - 1 ColónColón ...
23 Mar 08 Gimnasia La PlataGimnasia 0 - 0 CA HuracánHuracán ...
23 Mar 08 San Martín San JuanMartín 2 - 0 IndependienteIndependien ...
24 Mar 08 LanúsLanús 1 - 1 Newell's Old BoysNewell's ...
Jornada 8
28 Mar 08 Racing ClubRacing Club 1 - 2 San Martín San JuanMartín ...
29 Mar 08 ColónColón 0 - 0 Gimnasia La PlataGimnasia ...
29 Mar 08 Estudiantes La PlataEstudiantes 1 - 0 Vélez SarsfieldVélez ...
29 Mar 08 BanfieldBanfield 3 - 2 Argentinos JuniorsArgentinos ...
29 Mar 08 Gimnasia JujuyGimnasia 1 - 1 Rosario CentralRosario ...
30 Mar 08 San LorenzoLorenzo 3 - 1 LanúsLanús ...
30 Mar 08 CA HuracánHuracán 0 - 0 IndependienteIndependien ...
30 Mar 08 Newell's Old BoysNewell's 1 - 1 TigreTigre ...
30 Mar 08 River PlateRiver Plate 1 - 0 Arsenal de SarandíArsenal ...
30 Mar 08 OlimpoOlimpo 1 - 1 Boca JuniorsBoca ...
Jornada 9
05 Abr 08 San Martín San JuanMartín 2 - 0 CA HuracánHuracán ...
05 Abr 08 Vélez SarsfieldVélez 1 - 1 Racing ClubRacing Club ...
05 Abr 08 Arsenal de SarandíArsenal 0 - 0 Estudiantes La PlataEstudiantes ...
05 Abr 08 Rosario CentralRosario 0 - 1 Newell's Old BoysNewell's ...
06 Abr 08 Boca JuniorsBoca 1 - 1 BanfieldBanfield ...
06 Abr 08 IndependienteIndependien 1 - 3 ColónColón ...
06 Abr 08 Argentinos JuniorsArgentinos 1 - 1 Gimnasia JujuyGimnasia ...
06 Abr 08 Gimnasia La PlataGimnasia 4 - 2 OlimpoOlimpo ...
06 Abr 08 LanúsLanús 0 - 1 River PlateRiver Plate ...
06 Abr 08 TigreTigre 1 - 5 San LorenzoLorenzo ...
Jornada 10
12 Abr 08 Estudiantes La PlataEstudiantes 1 - 0 LanúsLanús ...
12 Abr 08 Newell's Old BoysNewell's 2 - 0 Argentinos JuniorsArgentinos ...
12 Abr 08 ColónColón 1 - 0 CA HuracánHuracán ...
12 Abr 08 BanfieldBanfield 0 - 0 Gimnasia La PlataGimnasia ...
13 Abr 08 OlimpoOlimpo 1 - 3 IndependienteIndependien ...
13 Abr 08 San LorenzoLorenzo 3 - 1 Rosario CentralRosario ...
13 Abr 08 River PlateRiver Plate 1 - 0 TigreTigre ...
13 Abr 08 Gimnasia JujuyGimnasia 1 - 2 Boca JuniorsBoca ...
13 Abr 08 Racing ClubRacing Club 1 - 0 Arsenal de SarandíArsenal ...
13 Abr 08 Vélez SarsfieldVélez 2 - 0 San Martín San JuanMartín ...
Jornada 11
19 Abr 08 IndependienteIndependien 3 - 0 BanfieldBanfield ...
19 Abr 08 CA HuracánHuracán 3 - 0 OlimpoOlimpo ...
19 Abr 08 Gimnasia La PlataGimnasia 2 - 1 Gimnasia JujuyGimnasia ...
19 Abr 08 Boca JuniorsBoca 2 - 1 Newell's Old BoysNewell's ...
20 Abr 08 LanúsLanús 3 - 3 Racing ClubRacing Club ...
20 Abr 08 Arsenal de SarandíArsenal 0 - 0 Vélez SarsfieldVélez ...
20 Abr 08 Argentinos JuniorsArgentinos 2 - 1 San LorenzoLorenzo ...
20 Abr 08 Rosario CentralRosario 2 - 1 River PlateRiver Plate ...
20 Abr 08 San Martín San JuanMartín 1 - 2 ColónColón ...
20 Abr 08 TigreTigre 1 - 1 Estudiantes La PlataEstudiantes ...
Jornada 12
26 Abr 08 Estudiantes La PlataEstudiantes 3 - 1 Rosario CentralRosario ...
26 Abr 08 BanfieldBanfield 4 - 3 CA HuracánHuracán ...
26 Abr 08 Racing ClubRacing Club 0 - 0 TigreTigre ...
26 Abr 08 Gimnasia JujuyGimnasia 1 - 2 IndependienteIndependien ...
26 Abr 08 OlimpoOlimpo 2 - 1 ColónColón ...
27 Abr 08 Vélez SarsfieldVélez 3 - 2 LanúsLanús ...
27 Abr 08 River PlateRiver Plate 4 - 2 Argentinos JuniorsArgentinos ...
27 Abr 08 San LorenzoLorenzo 1 - 0 Boca JuniorsBoca ...
27 Abr 08 Arsenal de SarandíArsenal 2 - 1 San Martín San JuanMartín ...
27 Abr 08 Newell's Old BoysNewell's 1 - 0 Gimnasia La PlataGimnasia ...
Jornada 13
03 May 08 CA HuracánHuracán 1 - 0 Gimnasia JujuyGimnasia ...
03 May 08 ColónColón 3 - 2 BanfieldBanfield ...
03 May 08 San Martín San JuanMartín 0 - 1 OlimpoOlimpo ...
03 May 08 IndependienteIndependien 3 - 0 Newell's Old BoysNewell's ...
03 May 08 LanúsLanús 2 - 6 Arsenal de SarandíArsenal ...
04 May 08 Argentinos JuniorsArgentinos 2 - 1 Estudiantes La PlataEstudiantes ...
04 May 08 Boca JuniorsBoca 1 - 0 River PlateRiver Plate ...
04 May 08 Rosario CentralRosario 3 - 2 Racing ClubRacing Club ...
05 May 08 Gimnasia La PlataGimnasia 1 - 2 San LorenzoLorenzo ...
05 May 08 TigreTigre 0 - 2 Vélez SarsfieldVélez ...
Jornada 14
10 May 08 Arsenal de SarandíArsenal 1 - 0 TigreTigre ...
10 May 08 Gimnasia JujuyGimnasia 2 - 2 ColónColón ...
10 May 08 BanfieldBanfield 2 - 1 OlimpoOlimpo ...
10 May 08 Vélez SarsfieldVélez 2 - 1 Rosario CentralRosario ...
10 May 08 San Martín San JuanMartín 1 - 2 LanúsLanús ...
11 May 08 Racing ClubRacing Club 1 - 1 Argentinos JuniorsArgentinos ...
11 May 08 Estudiantes La PlataEstudiantes 1 - 0 Boca JuniorsBoca ...
11 May 08 River PlateRiver Plate 4 - 2 Gimnasia La PlataGimnasia ...
12 May 08 Newell's Old BoysNewell's 0 - 1 CA HuracánHuracán ...
12 May 08 San LorenzoLorenzo 0 - 1 IndependienteIndependien ...
Jornada 15
17 May 08 ColónColón 1 - 1 Newell's Old BoysNewell's ...
17 May 08 BanfieldBanfield 5 - 1 San Martín San JuanMartín ...
17 May 08 Argentinos JuniorsArgentinos 2 - 0 Vélez SarsfieldVélez ...
17 May 08 Gimnasia La PlataGimnasia 1 - 2 Estudiantes La PlataEstudiantes ...
17 May 08 Boca JuniorsBoca 2 - 1 Racing ClubRacing Club ...
18 May 08 Rosario CentralRosario 3 - 0 Arsenal de SarandíArsenal ...
18 May 08 CA HuracánHuracán 0 - 0 San LorenzoLorenzo ...
18 May 08 IndependienteIndependien 0 - 0 River PlateRiver Plate ...
18 May 08 TigreTigre 1 - 4 LanúsLanús ...
18 May 08 OlimpoOlimpo 2 - 0 Gimnasia JujuyGimnasia ...
Jornada 16
24 May 08 Arsenal de SarandíArsenal 0 - 1 Argentinos JuniorsArgentinos ...
24 May 08 San Martín San JuanMartín 1 - 2 TigreTigre ...
24 May 08 River PlateRiver Plate 1 - 0 CA HuracánHuracán ...
24 May 08 Gimnasia JujuyGimnasia 1 - 1 BanfieldBanfield ...
25 May 08 Racing ClubRacing Club 1 - 1 Gimnasia La PlataGimnasia ...
25 May 08 LanúsLanús 0 - 0 Rosario CentralRosario ...
25 May 08 Vélez SarsfieldVélez 1 - 1 Boca JuniorsBoca ...
25 May 08 San LorenzoLorenzo 2 - 1 ColónColón ...
25 May 08 Estudiantes La PlataEstudiantes 1 - 1 IndependienteIndependien ...
26 May 08 Newell's Old BoysNewell's 0 - 1 OlimpoOlimpo ...
Jornada 17
31 May 08 Rosario CentralRosario 4 - 2 TigreTigre ...
31 May 08 Argentinos JuniorsArgentinos 3 - 0 LanúsLanús ...
31 May 08 IndependienteIndependien 0 - 0 Racing ClubRacing Club ...
31 May 08 Gimnasia JujuyGimnasia 3 - 1 San Martín San JuanMartín ...
01 Jun 08 BanfieldBanfield 0 - 1 Newell's Old BoysNewell's ...
01 Jun 08 ColónColón 1 - 2 River PlateRiver Plate ...
01 Jun 08 CA HuracánHuracán 1 - 1 Estudiantes La PlataEstudiantes ...
01 Jun 08 OlimpoOlimpo 3 - 2 San LorenzoLorenzo ...
01 Jun 08 Gimnasia La PlataGimnasia 2 - 1 Vélez SarsfieldVélez ...
02 Jun 08 Boca JuniorsBoca 3 - 1 Arsenal de SarandíArsenal ...
Jornada 18
07 Jun 08 Arsenal de SarandíArsenal 1 - 0 Gimnasia La PlataGimnasia ...
07 Jun 08 Newell's Old BoysNewell's 2 - 2 Gimnasia JujuyGimnasia ...
07 Jun 08 Racing ClubRacing Club 1 - 0 CA HuracánHuracán ...
07 Jun 08 San Martín San JuanMartín 0 - 0 Rosario CentralRosario ...
07 Jun 08 TigreTigre 1 - 0 Argentinos JuniorsArgentinos ...
08 Jun 08 San LorenzoLorenzo 3 - 2 BanfieldBanfield ...
08 Jun 08 Vélez SarsfieldVélez 0 - 0 IndependienteIndependien ...
08 Jun 08 River PlateRiver Plate 2 - 1 OlimpoOlimpo ...
08 Jun 08 Estudiantes La PlataEstudiantes 0 - 0 ColónColón ...
08 Jun 08 LanúsLanús 1 - 3 Boca JuniorsBoca ...
Jornada 19
21 Jun 08 Argentinos JuniorsArgentinos 2 - 1 Rosario CentralRosario ...
21 Jun 08 Gimnasia La PlataGimnasia 1 - 2 LanúsLanús ...
21 Jun 08 CA HuracánHuracán 1 - 2 Vélez SarsfieldVélez ...
21 Jun 08 Newell's Old BoysNewell's 1 - 0 San Martín San JuanMartín ...
22 Jun 08 IndependienteIndependien 1 - 1 Arsenal de SarandíArsenal ...
22 Jun 08 BanfieldBanfield 2 - 3 River PlateRiver Plate ...
22 Jun 08 Gimnasia JujuyGimnasia 2 - 2 San LorenzoLorenzo ...
22 Jun 08 OlimpoOlimpo 1 - 2 Estudiantes La PlataEstudiantes ...
22 Jun 08 ColónColón 1 - 0 Racing ClubRacing Club ...
22 Jun 08 Boca JuniorsBoca 6 - 2 TigreTigre ...

Clasificación

Equipo PJ GF GC Puntos
1 River Plate River Plate 19 29 13 43
2 Boca Juniors Boca Juniors 19 33 15 39
3 Estudiantes La Plata Estudiantes 19 29 17 39
4 San Lorenzo San Lorenzo 19 30 21 35
5 Vélez Sarsfield Vélez 19 24 17 32
6 Independiente Independient 19 25 15 31
7 Argentinos Juniors Argentinos 19 23 24 30
8 Newell's Old Boys Newell's 19 21 19 29
9 Rosario Central Rosario 19 26 23 27
10 Arsenal de Sarandí Arsenal 19 22 25 25
11 Colón Colón 19 25 27 23
12 Banfield Banfield 19 36 36 22
13 CA Huracán CA Huracán 19 15 17 22
14 Tigre Tigre 19 24 37 22
15 Olimpo Olimpo 19 21 32 20
16 Racing Club Racing Club 21 17 23 19
17 Gimnasia Jujuy Gimnasia 21 22 29 19
18 Lanús Lanús 19 26 39 18
19 Gimnasia La Plata Gimnasia 19 19 26 17
20 San Martín San Juan Martín Juan 19 20 30 17

  USO DE MEMORIA  
6,520,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3471
Total Execution Time  0.3493
  CADENA URL  
/torneo_final2008/grupo1/calendario
  GET DATOS  
$_GET['/torneo_final2008/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0108  SELECT type FROM routes WHERE alias = 'torneo_final2008'
0.0224  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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=118 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 118 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  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 (1022167,915006,831350,603751,298307) ORDER BY n.cover_points DESC, update_date DESC
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 = 8388 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116  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 calendars2008 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 8388 ORDER BY round ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 06:06:18' 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=2 AND last_update > '2024-04-28 06:06:18' 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-28 06:06:18' 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=3 AND last_update > '2024-04-28 06:06:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0203  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 events2008 e ON e.player_id = p.id AND e.league_id = 8388 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8388 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.0205  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 events2008 e ON e.player_id = p.id AND e.league_id = 8388 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8388 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0173  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 events2008 e ON e.player_id = p.id AND e.league_id = 8388 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8388 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0122  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` 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 = 8388 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC