4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
12 Ago 04 Nueva ChicagoNueva 0 - 0 Tiro Federal RosarioTiro ...
14 Ago 04 SarmientoSarmiento 0 - 0 BelgranoBelgrano ...
14 Ago 04 Godoy CruzGodoy Cruz 2 - 3 Gimnasia JujuyGimnasia ...
14 Ago 04 Defensa y JusticiaDefensa 0 - 0 CAICAI ...
14 Ago 04 Def. BelgranoDef. 2 - 3 Racing CórdobaRacing ...
14 Ago 04 Talleres CórdobaTalleres 0 - 0 El PorvenirPorvenir ...
14 Ago 04 Chacarita JuniorsChacarita 0 - 0 Unión Santa FeUnión ...
15 Ago 04 San Martín San JuanMartín 1 - 1 Ferro Carril OesteFerro ...
15 Ago 04 Juventud AntonianaJuventud 1 - 2 San Martín MendozaMartín ...
16 Ago 04 Atletico RafaelaAtletico 0 - 1 CA HuracánHuracán ...
Jornada 2
19 Ago 04 Talleres CórdobaTalleres 1 - 1 SarmientoSarmiento ...
21 Ago 04 Unión Santa FeUnión 3 - 0 Def. BelgranoDef. ...
21 Ago 04 Tiro Federal RosarioTiro 0 - 0 BelgranoBelgrano ...
21 Ago 04 CA HuracánHuracán 1 - 1 Juventud AntonianaJuventud ...
21 Ago 04 Ferro Carril OesteFerro 4 - 1 Defensa y JusticiaDefensa ...
21 Ago 04 El PorvenirPorvenir 3 - 0 Atletico RafaelaAtletico ...
21 Ago 04 CAICAI 0 - 0 Godoy CruzGodoy Cruz ...
22 Ago 04 San Martín MendozaMartín 2 - 1 Chacarita JuniorsChacarita ...
22 Ago 04 Gimnasia JujuyGimnasia 2 - 1 Nueva ChicagoNueva ...
23 Ago 04 Racing CórdobaRacing 1 - 1 San Martín San JuanMartín ...
Jornada 3
26 Ago 04 Juventud AntonianaJuventud 2 - 0 El PorvenirPorvenir ...
28 Ago 04 SarmientoSarmiento 2 - 4 Tiro Federal RosarioTiro ...
28 Ago 04 Godoy CruzGodoy Cruz 0 - 1 Ferro Carril OesteFerro ...
28 Ago 04 Defensa y JusticiaDefensa 2 - 0 Racing CórdobaRacing ...
28 Ago 04 Def. BelgranoDef. 0 - 2 San Martín MendozaMartín ...
28 Ago 04 BelgranoBelgrano 1 - 0 Gimnasia JujuyGimnasia ...
28 Ago 04 Nueva ChicagoNueva 1 - 0 CAICAI ...
28 Ago 04 Atletico RafaelaAtletico 2 - 1 Talleres CórdobaTalleres ...
29 Ago 04 San Martín San JuanMartín 3 - 1 Unión Santa FeUnión ...
30 Ago 04 Chacarita JuniorsChacarita 0 - 1 CA HuracánHuracán ...
Jornada 4
02 Sep 04 Ferro Carril OesteFerro 1 - 1 Nueva ChicagoNueva ...
03 Sep 04 Atletico RafaelaAtletico 4 - 0 SarmientoSarmiento ...
04 Sep 04 CA HuracánHuracán 2 - 1 Def. BelgranoDef. ...
04 Sep 04 CAICAI 1 - 0 BelgranoBelgrano ...
05 Sep 04 Racing CórdobaRacing 3 - 1 Godoy CruzGodoy Cruz ...
05 Sep 04 Unión Santa FeUnión 2 - 0 Defensa y JusticiaDefensa ...
05 Sep 04 San Martín MendozaMartín 0 - 0 San Martín San JuanMartín ...
05 Sep 04 Gimnasia JujuyGimnasia 1 - 1 Tiro Federal RosarioTiro ...
05 Sep 04 Talleres CórdobaTalleres 2 - 0 Juventud AntonianaJuventud ...
06 Sep 04 El PorvenirPorvenir 2 - 2 Chacarita JuniorsChacarita ...
Jornada 5
09 Sep 04 San Martín San JuanMartín 1 - 0 CA HuracánHuracán ...
10 Sep 04 Juventud AntonianaJuventud 2 - 1 Atletico RafaelaAtletico ...
11 Sep 04 SarmientoSarmiento 1 - 1 Gimnasia JujuyGimnasia ...
11 Sep 04 Tiro Federal RosarioTiro 2 - 1 CAICAI ...
11 Sep 04 Godoy CruzGodoy Cruz 5 - 1 Unión Santa FeUnión ...
11 Sep 04 Defensa y JusticiaDefensa 2 - 1 San Martín MendozaMartín ...
11 Sep 04 Def. BelgranoDef. 1 - 1 El PorvenirPorvenir ...
11 Sep 04 Nueva ChicagoNueva 0 - 0 Racing CórdobaRacing ...
11 Sep 04 Chacarita JuniorsChacarita 1 - 4 Talleres CórdobaTalleres ...
13 Sep 04 BelgranoBelgrano 0 - 0 Ferro Carril OesteFerro ...
Jornada 6
16 Sep 04 Unión Santa FeUnión 0 - 1 Nueva ChicagoNueva ...
17 Sep 04 Juventud AntonianaJuventud 2 - 1 SarmientoSarmiento ...
18 Sep 04 Racing CórdobaRacing 2 - 1 BelgranoBelgrano ...
18 Sep 04 Ferro Carril OesteFerro 1 - 0 Tiro Federal RosarioTiro ...
18 Sep 04 El PorvenirPorvenir 1 - 0 San Martín San JuanMartín ...
18 Sep 04 CAICAI 1 - 2 Gimnasia JujuyGimnasia ...
19 Sep 04 San Martín MendozaMartín 1 - 0 Godoy CruzGodoy Cruz ...
19 Sep 04 CA HuracánHuracán 0 - 4 Defensa y JusticiaDefensa ...
19 Sep 04 Talleres CórdobaTalleres 0 - 3 Def. BelgranoDef. ...
20 Sep 04 Atletico RafaelaAtletico 0 - 3 Chacarita JuniorsChacarita ...
Jornada 7
24 Sep 04 San Martín San JuanMartín 1 - 0 Talleres CórdobaTalleres ...
24 Sep 04 Gimnasia JujuyGimnasia 2 - 0 Ferro Carril OesteFerro ...
25 Sep 04 SarmientoSarmiento 2 - 1 CAICAI ...
25 Sep 04 Tiro Federal RosarioTiro 2 - 1 Racing CórdobaRacing ...
25 Sep 04 Defensa y JusticiaDefensa 1 - 3 El PorvenirPorvenir ...
25 Sep 04 Def. BelgranoDef. 3 - 0 Atletico RafaelaAtletico ...
25 Sep 04 BelgranoBelgrano 2 - 1 Unión Santa FeUnión ...
25 Sep 04 Nueva ChicagoNueva 3 - 1 San Martín MendozaMartín ...
25 Sep 04 Chacarita JuniorsChacarita 1 - 1 Juventud AntonianaJuventud ...
27 Sep 04 Godoy CruzGodoy Cruz 1 - 2 CA HuracánHuracán ...
Jornada 8
30 Sep 04 San Martín MendozaMartín 0 - 0 BelgranoBelgrano ...
01 Oct 04 Racing CórdobaRacing 3 - 1 Gimnasia JujuyGimnasia ...
01 Oct 04 Juventud AntonianaJuventud 0 - 0 Def. BelgranoDef. ...
01 Oct 04 Ferro Carril OesteFerro 1 - 3 CAICAI ...
01 Oct 04 Atletico RafaelaAtletico 0 - 1 San Martín San JuanMartín ...
02 Oct 04 Unión Santa FeUnión 1 - 1 Tiro Federal RosarioTiro ...
02 Oct 04 CA HuracánHuracán 2 - 0 Nueva ChicagoNueva ...
02 Oct 04 El PorvenirPorvenir 2 - 2 Godoy CruzGodoy Cruz ...
02 Oct 04 Chacarita JuniorsChacarita 2 - 3 SarmientoSarmiento ...
04 Oct 04 Talleres CórdobaTalleres 2 - 0 Defensa y JusticiaDefensa ...
Jornada 9
07 Oct 04 Def. BelgranoDef. 1 - 2 Chacarita JuniorsChacarita ...
08 Oct 04 San Martín San JuanMartín 2 - 2 Juventud AntonianaJuventud ...
08 Oct 04 Nueva ChicagoNueva 2 - 0 El PorvenirPorvenir ...
09 Oct 04 Godoy CruzGodoy Cruz 1 - 0 Talleres CórdobaTalleres ...
10 Oct 04 Tiro Federal RosarioTiro 5 - 2 San Martín MendozaMartín ...
10 Oct 04 Gimnasia JujuyGimnasia 3 - 2 Unión Santa FeUnión ...
10 Oct 04 Defensa y JusticiaDefensa 1 - 3 Atletico RafaelaAtletico ...
10 Oct 04 CAICAI 2 - 1 Racing CórdobaRacing ...
10 Oct 04 BelgranoBelgrano 1 - 2 CA HuracánHuracán ...
11 Oct 04 SarmientoSarmiento 0 - 2 Ferro Carril OesteFerro ...
Jornada 10
15 Oct 04 Juventud AntonianaJuventud 0 - 1 Defensa y JusticiaDefensa ...
15 Oct 04 Atletico RafaelaAtletico 2 - 1 Godoy CruzGodoy Cruz ...
16 Oct 04 Unión Santa FeUnión 2 - 0 CAICAI ...
16 Oct 04 CA HuracánHuracán 1 - 4 Tiro Federal RosarioTiro ...
16 Oct 04 El PorvenirPorvenir 2 - 1 BelgranoBelgrano ...
16 Oct 04 Def. BelgranoDef. 2 - 0 SarmientoSarmiento ...
16 Oct 04 Chacarita JuniorsChacarita 2 - 1 San Martín San JuanMartín ...
17 Oct 04 San Martín MendozaMartín 1 - 1 Gimnasia JujuyGimnasia ...
17 Oct 04 Talleres CórdobaTalleres 2 - 1 Nueva ChicagoNueva ...
19 Oct 04 Racing CórdobaRacing 1 - 2 Ferro Carril OesteFerro ...
Jornada 11
21 Oct 04 Defensa y JusticiaDefensa 1 - 1 Chacarita JuniorsChacarita ...
22 Oct 04 San Martín San JuanMartín 1 - 2 Def. BelgranoDef. 1
23 Oct 04 SarmientoSarmiento 2 - 2 Racing CórdobaRacing ...
23 Oct 04 Tiro Federal RosarioTiro 0 - 0 El PorvenirPorvenir ...
23 Oct 04 Godoy CruzGodoy Cruz 0 - 2 Juventud AntonianaJuventud ...
23 Oct 04 CAICAI 2 - 0 San Martín MendozaMartín ...
23 Oct 04 BelgranoBelgrano 1 - 0 Talleres CórdobaTalleres ...
23 Oct 04 Nueva ChicagoNueva 1 - 2 Atletico RafaelaAtletico ...
24 Oct 04 Ferro Carril OesteFerro 0 - 1 Unión Santa FeUnión ...
25 Oct 04 Gimnasia JujuyGimnasia 0 - 2 CA HuracánHuracán ...
Jornada 12
28 Oct 04 Juventud AntonianaJuventud 2 - 2 Nueva ChicagoNueva ...
29 Oct 04 San Martín San JuanMartín 2 - 0 SarmientoSarmiento ...
29 Oct 04 Atletico RafaelaAtletico 4 - 1 BelgranoBelgrano ...
30 Oct 04 Unión Santa FeUnión 2 - 2 Racing CórdobaRacing ...
30 Oct 04 CA HuracánHuracán 4 - 0 CAICAI ...
30 Oct 04 El PorvenirPorvenir 1 - 0 Gimnasia JujuyGimnasia ...
30 Oct 04 Def. BelgranoDef. 0 - 1 Defensa y JusticiaDefensa ...
30 Oct 04 Chacarita JuniorsChacarita 3 - 1 Godoy CruzGodoy Cruz ...
31 Oct 04 San Martín MendozaMartín 2 - 0 Ferro Carril OesteFerro ...
01 Nov 04 Talleres CórdobaTalleres 1 - 0 Tiro Federal RosarioTiro ...
Jornada 13
04 Nov 04 Ferro Carril OesteFerro 1 - 0 CA HuracánHuracán ...
05 Nov 04 Racing CórdobaRacing 2 - 0 San Martín MendozaMartín ...
06 Nov 04 SarmientoSarmiento 2 - 5 Unión Santa FeUnión ...
06 Nov 04 Godoy CruzGodoy Cruz 5 - 0 Def. BelgranoDef. ...
06 Nov 04 Gimnasia JujuyGimnasia 1 - 1 Talleres CórdobaTalleres ...
06 Nov 04 Defensa y JusticiaDefensa 0 - 2 San Martín San JuanMartín ...
06 Nov 04 CAICAI 0 - 1 El PorvenirPorvenir ...
06 Nov 04 BelgranoBelgrano 4 - 2 Juventud AntonianaJuventud ...
06 Nov 04 Nueva ChicagoNueva 2 - 0 Chacarita JuniorsChacarita ...
08 Nov 04 Tiro Federal RosarioTiro 2 - 1 Atletico RafaelaAtletico ...
Jornada 14
11 Nov 04 Chacarita JuniorsChacarita 1 - 2 BelgranoBelgrano ...
13 Nov 04 Atletico RafaelaAtletico 3 - 2 Gimnasia JujuyGimnasia ...
14 Nov 04 San Martín San JuanMartín 0 - 0 Godoy CruzGodoy Cruz ...
14 Nov 04 San Martín MendozaMartín 1 - 1 Unión Santa FeUnión ...
14 Nov 04 Juventud AntonianaJuventud 0 - 1 Tiro Federal RosarioTiro ...
14 Nov 04 CA HuracánHuracán 4 - 1 Racing CórdobaRacing ...
14 Nov 04 El PorvenirPorvenir 1 - 1 Ferro Carril OesteFerro ...
14 Nov 04 Defensa y JusticiaDefensa 4 - 0 SarmientoSarmiento ...
14 Nov 04 Talleres CórdobaTalleres 1 - 2 CAICAI ...
15 Nov 04 Def. BelgranoDef. 0 - 1 Nueva ChicagoNueva ...
Jornada 15
18 Nov 04 Ferro Carril OesteFerro 1 - 0 Talleres CórdobaTalleres ...
19 Nov 04 Godoy CruzGodoy Cruz 0 - 0 Defensa y JusticiaDefensa ...
20 Nov 04 SarmientoSarmiento 2 - 0 San Martín MendozaMartín ...
20 Nov 04 Racing CórdobaRacing 1 - 0 El PorvenirPorvenir ...
20 Nov 04 Unión Santa FeUnión 3 - 1 CA HuracánHuracán ...
20 Nov 04 CAICAI 1 - 0 Atletico RafaelaAtletico ...
20 Nov 04 Nueva ChicagoNueva 1 - 0 San Martín San JuanMartín ...
21 Nov 04 Gimnasia JujuyGimnasia 4 - 2 Juventud AntonianaJuventud ...
21 Nov 04 BelgranoBelgrano 2 - 1 Def. BelgranoDef. ...
22 Nov 04 Tiro Federal RosarioTiro 2 - 1 Chacarita JuniorsChacarita ...
Jornada 16
25 Nov 04 El PorvenirPorvenir 3 - 1 Unión Santa FeUnión ...
26 Nov 04 San Martín San JuanMartín 0 - 0 BelgranoBelgrano ...
27 Nov 04 CA HuracánHuracán 1 - 1 San Martín MendozaMartín ...
27 Nov 04 Godoy CruzGodoy Cruz 2 - 0 SarmientoSarmiento ...
27 Nov 04 Def. BelgranoDef. 0 - 0 Tiro Federal RosarioTiro ...
27 Nov 04 Chacarita JuniorsChacarita 0 - 0 Gimnasia JujuyGimnasia ...
28 Nov 04 Juventud AntonianaJuventud 0 - 0 CAICAI ...
28 Nov 04 Defensa y JusticiaDefensa 0 - 2 Nueva ChicagoNueva ...
28 Nov 04 Talleres CórdobaTalleres 1 - 1 Racing CórdobaRacing ...
29 Nov 04 Atletico RafaelaAtletico 1 - 1 Ferro Carril OesteFerro ...
Jornada 17
02 Dic 04 Nueva ChicagoNueva 2 - 3 Godoy CruzGodoy Cruz ...
03 Dic 04 San Martín MendozaMartín 3 - 0 El PorvenirPorvenir ...
04 Dic 04 SarmientoSarmiento 0 - 0 CA HuracánHuracán ...
04 Dic 04 Ferro Carril OesteFerro 2 - 2 Juventud AntonianaJuventud ...
04 Dic 04 BelgranoBelgrano 2 - 2 Defensa y JusticiaDefensa ...
04 Dic 04 Tiro Federal RosarioTiro 1 - 2 San Martín San JuanMartín ...
04 Dic 04 Racing CórdobaRacing 3 - 3 Atletico RafaelaAtletico ...
04 Dic 04 CAICAI 2 - 1 Chacarita JuniorsChacarita ...
05 Dic 04 Gimnasia JujuyGimnasia 2 - 1 Def. BelgranoDef. ...
06 Dic 04 Unión Santa FeUnión 1 - 1 Talleres CórdobaTalleres ...
Jornada 18
09 Dic 04 Chacarita JuniorsChacarita 2 - 2 Ferro Carril OesteFerro ...
10 Dic 04 Juventud AntonianaJuventud 2 - 5 Racing CórdobaRacing ...
11 Dic 04 Nueva ChicagoNueva 3 - 1 SarmientoSarmiento ...
11 Dic 04 El PorvenirPorvenir 1 - 2 CA HuracánHuracán ...
11 Dic 04 Defensa y JusticiaDefensa 0 - 1 Tiro Federal RosarioTiro ...
11 Dic 04 Def. BelgranoDef. 2 - 0 CAICAI ...
11 Dic 04 Godoy CruzGodoy Cruz 3 - 1 BelgranoBelgrano ...
11 Dic 04 San Martín San JuanMartín 4 - 1 Gimnasia JujuyGimnasia ...
12 Dic 04 Talleres CórdobaTalleres 0 - 1 San Martín MendozaMartín ...
13 Dic 04 Atletico RafaelaAtletico 2 - 1 Unión Santa FeUnión ...
Jornada 19
16 Dic 04 Racing CórdobaRacing 2 - 0 Chacarita JuniorsChacarita ...
17 Dic 04 Unión Santa FeUnión 2 - 0 Juventud AntonianaJuventud ...
18 Dic 04 CAICAI 2 - 0 San Martín San JuanMartín ...
18 Dic 04 Gimnasia JujuyGimnasia 2 - 0 Defensa y JusticiaDefensa ...
18 Dic 04 BelgranoBelgrano 0 - 0 Nueva ChicagoNueva ...
18 Dic 04 Tiro Federal RosarioTiro 4 - 0 Godoy CruzGodoy Cruz ...
18 Dic 04 Ferro Carril OesteFerro 2 - 4 Def. BelgranoDef. ...
18 Dic 04 SarmientoSarmiento 3 - 0 El PorvenirPorvenir ...
18 Dic 04 CA HuracánHuracán 1 - 1 Talleres CórdobaTalleres ...
18 Dic 04 San Martín MendozaMartín 2 - 1 Atletico RafaelaAtletico ...

Clasificación

Equipo PJ GF GC Puntos
1 Tiro Federal Rosario Tiro Federal 19 30 15 36
2 CA Huracán CA Huracán 19 27 21 34
3 Nueva Chicago Nueva 19 24 16 32
4 San Martín San Juan Martín Juan 19 22 15 30
5 Racing Córdoba Racing 19 34 28 30
6 Gimnasia Jujuy Gimnasia 19 28 27 29
7 San Martín Mendoza Martín 19 22 22 29
8 Ferro Carril Oeste Ferro Carril 19 23 22 28
9 El Porvenir El Porvenir 19 21 22 27
10 CAI CAI 19 18 20 27
11 Unión Santa Fe Unión Santa 19 30 27 26
12 Atletico Rafaela Atletico 19 29 30 26
13 Belgrano Belgrano 19 19 21 25
14 Godoy Cruz Godoy Cruz 19 27 27 22
15 Defensa y Justicia Defensa 19 20 25 22
16 Talleres Córdoba Talleres 19 18 19 21
17 Def. Belgrano Def. 19 23 27 21
18 Juventud Antoniana Juventud 19 23 31 19
19 Chacarita Juniors Chacarita 19 23 29 18
20 Sarmiento Sarmiento 19 20 37 17

  USO DE MEMORIA  
6,339,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3428
Total Execution Time  0.3449
  CADENA URL  
/primera_b_nacional_apertura2005/grupo1/calendario
  GET DATOS  
$_GET['/primera_b_nacional_apertura2005/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0109  SELECT type FROM routes WHERE alias = 'primera_b_nacional_apertura2005'
0.0225  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional_apertura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1773 AND type_rel = 3
0.0107  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1773 ORDER BY order_id ASC
0.0108  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 = 12946 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0321  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 calendars2005 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 12946 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-30 21:04:43' 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-30 21:04:43' 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-30 21:04:43' 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-30 21:04:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional_apertura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0106  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 events2005 e ON e.player_id = p.id AND e.league_id = 12946 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12946 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.0106  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 events2005 e ON e.player_id = p.id AND e.league_id = 12946 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12946 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  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 events2005 e ON e.player_id = p.id AND e.league_id = 12946 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12946 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0222  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` 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 = 12946 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC