4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2008/2009
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Vélez Sarsfield Vélez 19 29 13 40
2 CA Huracán CA Huracán 19 35 19 38
3 Lanús Lanús 19 32 26 38
4 Colón Colón 19 29 19 34
5 Racing Club Racing Club 19 23 21 30
6 Estudiantes La Plata Estudiantes 19 22 18 29
7 Gimnasia La Plata Gimnasia 19 23 21 28
8 River Plate River Plate 19 24 25 27
9 Godoy Cruz Godoy Cruz 19 23 26 26
10 Rosario Central Rosario 19 23 21 25
11 San Lorenzo San Lorenzo 19 27 26 24
12 Banfield Banfield 19 25 25 23
13 Tigre Tigre 19 24 25 23
14 Boca Juniors Boca Juniors 19 22 25 22
15 Newell's Old Boys Newell's 19 21 22 21
16 Independiente Independient 19 22 36 21
17 San Martín Tucumán Martín 19 20 23 20
18 Arsenal de Sarandí Arsenal 19 19 30 18
19 Gimnasia Jujuy Gimnasia 19 15 24 17
20 Argentinos Juniors Argentinos 19 19 32 15
TEMPORADA 2007/2008
CLAUSURA ARGENTINA
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
TEMPORADA 2006/2007
PRIMERA B NACIONAL - APERTURA
Equipo PJ GF GC Puntos
1 Olimpo Olimpo 19 36 17 40
2 Platense Platense 19 31 14 38
3 Tigre Tigre 19 23 17 35
4 San Martín San Juan Martín Juan 19 25 18 34
5 Chacarita Juniors Chacarita 19 22 14 33
6 CA Huracán CA Huracán 19 29 26 33
7 Atletico Rafaela Atletico 19 24 14 32
8 Unión Santa Fe Unión Santa 19 28 17 28
9 San Martín Tucumán Martín 19 21 20 25
10 Aldosivi Aldosivi 19 25 32 24
11 CAI CAI 19 26 27 23
12 Ferro Carril Oeste Ferro Carril 19 19 23 23
13 Instituto Instituto 19 22 29 20
14 Talleres Córdoba Talleres 19 19 23 19
15 Tiro Federal Rosario Tiro Federal 19 23 28 19
16 Defensa y Justicia Defensa 19 11 19 19
17 Almagro Almagro 19 18 31 19
18 Villa Mitre Bahia Blanca Villa Mitre 19 22 27 17
19 Huracán Tres Arroyos Huracán 19 17 33 16
20 Ben Hur Ben Hur 19 22 34 13
TEMPORADA 2005/2006
PRIMERA B NACIONAL - APERTURA
Equipo PJ GF GC Puntos
1 Godoy Cruz Godoy Cruz 19 29 14 40
2 Almagro Almagro 19 28 17 35
3 Chacarita Juniors Chacarita 19 23 9 34
4 CA Huracán CA Huracán 19 26 16 34
5 Defensa y Justicia Defensa 19 19 13 30
6 Ferro Carril Oeste Ferro Carril 19 15 15 29
7 Belgrano Belgrano 19 19 20 27
8 Tigre Tigre 19 16 13 24
9 Ben Hur Ben Hur 19 20 19 24
10 Unión Santa Fe Unión Santa 19 29 29 24
11 Huracán Tres Arroyos Huracán 19 20 24 23
12 San Martín San Juan Martín Juan 19 15 15 22
13 Talleres Córdoba Talleres 19 18 19 22
14 Atletico Rafaela Atletico 19 19 25 22
15 CAI CAI 19 20 22 21
16 Juventud Antoniana Juventud 19 13 16 21
17 Nueva Chicago Nueva 19 23 25 19
18 Aldosivi Aldosivi 19 19 29 19
19 El Porvenir El Porvenir 19 18 30 16
20 San Martín Mendoza Martín 19 13 32 13
TEMPORADA 2004/2005
PRIMERA B NACIONAL - APERTURA
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
TEMPORADA 2003/2004
PRIMERA B NACIONAL - APERTURA
Equipo PJ GF GC Puntos
1 Instituto Instituto 19 34 22 36
2 Belgrano Belgrano 19 24 18 29
3 San Martín Mendoza Martín 19 20 16 29
4 Huracán Tres Arroyos Huracán 19 29 24 28
5 C.A.I C.A.I 19 32 30 27
6 Gimnasia Jujuy Gimnasia 19 24 24 27
7 Defensa y Justicia Defensa 19 22 22 27
8 Defensores Belgrano VR Defensores 19 28 20 26
9 CA Huracán CA Huracán 19 19 21 26
10 Juventud Antoniana Juventud 19 25 28 25
11 Godoy Cruz Godoy Cruz 19 17 21 25
12 Ferro Carril Oeste Ferro Carril 19 23 18 24
13 Argentinos Juniors Argentinos 19 28 23 23
14 Tiro Federal Rosario Tiro Federal 19 26 28 23
15 Los Andes Los Andes 19 16 17 21
16 Almagro Almagro 19 22 24 21
17 Unión Santa Fe Unión Santa 19 20 23 21
18 El Porvenir El Porvenir 19 18 26 21
19 San Martín San Juan Martín Juan 19 18 27 21
20 Gimnasia Concepción Gimnasia 19 14 27 19
TEMPORADA 2002/2003
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 19 43 18 43
2 Boca Juniors Boca Juniors 19 36 23 39
3 Vélez Sarsfield Vélez 19 27 12 38
4 Rosario Central Rosario 19 40 18 37
5 Nueva Chicago Nueva 21 32 33 32
6 Olimpo Olimpo 19 22 17 31
7 Colón Colón 19 19 14 29
8 San Lorenzo San Lorenzo 19 27 28 29
9 Estudiantes La Plata Estudiantes 19 24 18 28
10 Talleres Córdoba Talleres 21 25 26 27
11 Gimnasia La Plata Gimnasia 19 21 26 26
12 Racing Club Racing Club 19 26 24 25
13 Lanús Lanús 19 27 29 25
14 Banfield Banfield 19 18 20 23
15 Arsenal de Sarandí Arsenal 19 12 13 22
16 Newell's Old Boys Newell's 19 21 26 22
17 Independiente Independient 19 13 25 18
18 Unión Santa Fe Unión Santa 19 18 29 17
19 Chacarita Juniors Chacarita 19 11 24 11
20 CA Huracán CA Huracán 19 12 46 6
TEMPORADA 2001/2002
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 19 39 13 43
2 Gimnasia La Plata Gimnasia 19 33 23 37
3 Boca Juniors Boca Juniors 19 26 17 35
4 CA Huracán CA Huracán 19 27 24 30
5 Banfield Banfield 19 21 19 30
6 Racing Club Racing Club 19 19 18 29
7 Newell's Old Boys Newell's 19 26 25 28
8 Estudiantes La Plata Estudiantes 19 34 27 27
9 Vélez Sarsfield Vélez 19 27 20 26
10 Lanús Lanús 19 20 18 26
11 San Lorenzo San Lorenzo 19 24 23 26
12 Colón Colón 19 24 23 24
13 Nueva Chicago Nueva 19 16 21 24
14 Chacarita Juniors Chacarita 19 23 24 21
15 Unión Santa Fe Unión Santa 19 20 27 21
16 Rosario Central Rosario 19 20 26 20
17 Argentinos Juniors Argentinos 19 20 32 20
18 Belgrano Belgrano 19 16 24 18
19 Talleres Córdoba Talleres 19 14 31 17
20 Independiente Independient 19 14 28 15
TEMPORADA 2000/2001
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 19 43 17 47
2 River Plate River Plate 19 48 27 41
3 Boca Juniors Boca Juniors 19 29 26 30
4 Argentinos Juniors Argentinos 19 27 22 29
5 Racing Club Racing Club 19 21 20 29
6 Chacarita Juniors Chacarita 19 21 25 29
7 CA Huracán CA Huracán 19 28 28 28
8 Vélez Sarsfield Vélez 19 25 24 27
9 Estudiantes La Plata Estudiantes 19 23 24 27
10 Almagro Almagro 19 27 27 26
11 Talleres Córdoba Talleres 19 23 23 25
12 Newell's Old Boys Newell's 19 27 28 24
13 Colón Colón 19 21 27 23
14 Lanús Lanús 19 28 30 22
15 Los Andes Los Andes 19 24 32 21
16 Unión Santa Fe Unión Santa 19 32 36 20
17 Belgrano Belgrano 19 18 26 20
18 Independiente Independient 19 18 21 19
19 Gimnasia La Plata Gimnasia 19 22 28 18
20 Rosario Central Rosario 19 24 38 17
TEMPORADA 1998/1999
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 19 35 11 44
2 River Plate River Plate 19 37 19 37
3 San Lorenzo San Lorenzo 19 33 19 36
4 Rosario Central Rosario 19 24 20 32
5 Independiente Independient 19 32 26 29
6 Unión Santa Fe Unión Santa 19 29 27 29
7 Newell's Old Boys Newell's 19 30 22 27
8 Colón Colón 19 28 21 27
9 Gimnasia La Plata Gimnasia 19 28 32 26
10 Belgrano Belgrano 19 20 20 25
11 Gimnasia Jujuy Gimnasia 19 28 37 25
12 Argentinos Juniors Argentinos 19 20 23 24
13 Vélez Sarsfield Vélez 19 21 24 22
14 Racing Club Racing Club 19 20 32 22
15 Estudiantes La Plata Estudiantes 19 18 18 21
16 Talleres Córdoba Talleres 19 23 26 20
17 Lanús Lanús 19 23 28 20
18 Platense Platense 19 16 30 17
19 Ferro Carril Oeste Ferro Carril 19 8 18 15
20 CA Huracán CA Huracán 19 15 35 12
TEMPORADA 1997/1998
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Vélez Sarsfield Vélez 19 39 14 46
2 Lanús Lanús 19 43 22 40
3 Gimnasia La Plata Gimnasia 19 42 24 37
4 Gimnasia Jujuy Gimnasia 19 23 20 32
5 San Lorenzo San Lorenzo 19 36 27 30
6 Boca Juniors Boca Juniors 19 38 30 29
7 River Plate River Plate 19 32 24 29
8 Argentinos Juniors Argentinos 19 26 17 28
9 Newell's Old Boys Newell's 19 26 22 28
10 Independiente Independient 19 26 28 26
11 Ferro Carril Oeste Ferro Carril 19 32 34 25
12 Estudiantes La Plata Estudiantes 19 16 24 23
13 Rosario Central Rosario 19 23 28 22
14 Platense Platense 19 26 27 21
15 Racing Club Racing Club 19 15 19 20
16 Colón Colón 19 23 36 18
17 Gimnasia y Tiro Gimnasia 19 17 34 16
18 CA Huracán CA Huracán 19 18 34 15
19 Unión Santa Fe Unión Santa 19 19 33 13
20 Dep. Español Dep. 19 21 44 13
TEMPORADA 1996/1997
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 19 37 20 41
2 Colón Colón 19 36 28 35
3 Newell's Old Boys Newell's 19 23 20 35
4 Independiente Independient 19 38 21 34
5 Vélez Sarsfield Vélez 19 25 18 32
6 San Lorenzo San Lorenzo 19 32 22 30
7 Racing Club Racing Club 19 24 22 27
8 Platense Platense 19 21 22 26
9 Boca Juniors Boca Juniors 19 34 32 25
10 Ferro Carril Oeste Ferro Carril 19 24 22 24
11 Lanús Lanús 19 22 21 24
12 Unión Santa Fe Unión Santa 19 31 36 24
13 Gimnasia La Plata Gimnasia 19 19 25 23
14 CA Huracán CA Huracán 19 22 33 22
15 Huracán Corrientes Huracán 19 21 28 21
16 Estudiantes La Plata Estudiantes 19 22 26 19
17 Dep. Español Dep. 19 19 25 19
18 Rosario Central Rosario 19 24 27 18
19 Banfield Banfield 19 20 32 16
20 Gimnasia Jujuy Gimnasia 19 21 35 14
TEMPORADA 1995/1996
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Vélez Sarsfield Vélez 19 40 18 40
2 Gimnasia La Plata Gimnasia 19 44 21 39
3 Lanús Lanús 19 35 24 34
4 Estudiantes La Plata Estudiantes 19 33 22 34
5 Boca Juniors Boca Juniors 19 30 26 33
6 Rosario Central Rosario 19 33 23 30
7 CA Huracán CA Huracán 19 32 29 29
8 Racing Club Racing Club 19 26 25 29
9 Colón Colón 19 20 21 26
10 Ferro Carril Oeste Ferro Carril 19 16 20 26
11 Dep. Español Dep. 19 19 19 24
12 Independiente Independient 19 22 26 23
13 Belgrano Belgrano 19 23 26 22
14 River Plate River Plate 19 32 33 21
15 Platense Platense 19 23 29 21
16 Gimnasia Jujuy Gimnasia 19 22 37 21
17 Newell's Old Boys Newell's 19 20 28 18
18 Banfield Banfield 19 20 25 17
19 San Lorenzo San Lorenzo 19 15 29 16
20 Argentinos Juniors Argentinos 19 12 36 13
TEMPORADA 1994/1995
CLAUSURA ARGENTINA
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
TEMPORADA 1993/1994
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 CA Huracán CA Huracán 19 25 22 35
2 Independiente Independient 19 32 13 34
3 Rosario Central Rosario 19 26 14 31
4 San Lorenzo San Lorenzo 19 22 15 31
5 River Plate River Plate 19 24 14 28
6 Platense Platense 19 28 23 28
7 Banfield Banfield 19 23 20 28
8 Boca Juniors Boca Juniors 19 25 19 26
9 Newell's Old Boys Newell's 19 16 18 26
10 Belgrano Belgrano 19 16 17 25
11 Lanús Lanús 19 23 26 25
12 Racing Club Racing Club 19 14 17 25
13 Argentinos Juniors Argentinos 19 23 24 21
14 Ferro Carril Oeste Ferro Carril 19 13 17 21
15 Estudiantes La Plata Estudiantes 19 23 29 21
16 Gimnasia La Plata Gimnasia 19 20 29 21
17 Dep. Español Dep. 19 13 20 20
18 Vélez Sarsfield Vélez 19 23 31 19
19 Gimnasia y Tiro Gimnasia 19 15 26 18
20 CD Mandiyú CD Mandiyú 19 17 27 16
TEMPORADA 1992/1993
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Vélez Sarsfield Vélez 19 23 7 37
2 River Plate River Plate 19 33 21 33
3 Dep. Español Dep. 19 24 18 31
4 Independiente Independient 19 23 14 30
5 San Lorenzo San Lorenzo 19 27 19 30
6 Racing Club Racing Club 19 22 17 30
7 CA Huracán CA Huracán 19 24 23 28
8 Rosario Central Rosario 19 25 19 27
9 Boca Juniors Boca Juniors 19 23 18 27
10 Gimnasia La Plata Gimnasia 19 14 15 24
11 CD Mandiyú CD Mandiyú 19 19 22 24
12 Estudiantes La Plata Estudiantes 19 23 20 23
13 Argentinos Juniors Argentinos 19 12 12 22
14 Belgrano Belgrano 19 13 22 22
15 Ferro Carril Oeste Ferro Carril 19 15 21 21
16 Lanús Lanús 19 12 15 20
17 Newell's Old Boys Newell's 19 13 19 19
18 Platense Platense 19 14 26 17
19 San Martín Tucumán Martín 19 17 30 16
20 Talleres Córdoba Talleres 19 13 31 13

  USO DE MEMORIA  
7,731,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6397
Total Execution Time  0.6409
  CADENA URL  
/historico/Ca-Huracan/2009
  GET DATOS  
$_GET['/historico/Ca-Huracan/2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0142  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Ca-Huracan' AND l.year = 2009 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 8386
0.0149  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '585' AND l.year = 2009 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '585' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 8385 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 8386 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0203  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=585 AND l.year in (2008,2009,2010) ORDER BY l.id DESC, l.year DESC ;
0.0133  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (8388,8387) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 8388 AND teamId = 585
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 8387 AND teamId = 585
0.0147  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2009` 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 = 8386 AND t.round = 19 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0144  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2009 e ON e.player_id = p.id AND e.league_id = 8386 WHERE rp.league_id = 8386 AND rp.teamId = 585 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2009 e ON e.player_id = p.id AND e.league_id = 8386 WHERE rp.league_id = 8386 AND rp.teamId = 585 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2009 e ON e.player_id = p.id AND e.league_id = 8386 WHERE rp.league_id = 8386 AND rp.teamId = 585 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 585 AND l.year <= 2009 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 8386 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 12942 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 12943 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 12945 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 12944 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 12947 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` 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 = 8400 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 8402 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 8405 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 8408 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 8410 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 8412 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 8414 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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
0.0187  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1994` 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 = 8417 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1993` 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 = 8420 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC