4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2000/2001
EERSTE DIVISIE
Equipo PJ GF GC Puntos
1 Den Bosch Den Bosch 34 64 25 75
2 Excelsior Excelsior 34 89 63 66
3 PEC Zwolle PEC Zwolle 34 73 41 64
4 Cambuur Cambuur 34 55 52 54
5 FC Volendam FC Volendam 34 58 48 53
6 Go Ahead Eagles Ahead Eagles 34 62 63 53
7 SC Telstar SC Telstar 34 47 48 53
8 Helmond Sport Helmond 34 69 50 48
9 FC Eindhoven Eindhoven 34 58 57 45
10 TOP Oss TOP Oss 34 59 67 45
11 Emmen Emmen 34 53 64 41
12 Dordrecht Dordrecht 34 58 59 40
13 MVV Maastricht Maastricht 34 47 58 40
14 SC Veendam SC Veendam 34 54 69 39
15 Heracles Heracles 34 38 56 39
16 ADO Den Haag Haag 34 51 71 36
17 HFC Haarlem Haarlem 34 46 64 34
18 VVV Venlo VVV Venlo 34 37 63 28
TEMPORADA 1999/2000
EERSTE DIVISIE
Equipo PJ GF GC Puntos
1 NAC Breda NAC Breda 34 84 36 82
2 PEC Zwolle PEC Zwolle 34 90 41 74
3 Groningen Groningen 34 81 33 74
4 Excelsior Excelsior 34 70 48 59
5 Emmen Emmen 34 53 45 58
6 RBC Roosendaal Roosendaal 34 65 49 57
7 Heracles Heracles 34 41 42 47
8 Dordrecht Dordrecht 34 55 58 45
9 FC Eindhoven Eindhoven 34 47 63 45
10 Helmond Sport Helmond 34 45 57 42
11 ADO Den Haag Haag 34 37 52 42
12 SC Veendam SC Veendam 34 50 61 41
13 SC Telstar SC Telstar 34 44 59 37
14 Go Ahead Eagles Ahead Eagles 34 56 58 36
15 VVV Venlo VVV Venlo 34 38 62 35
16 HFC Haarlem Haarlem 34 54 72 32
17 FC Volendam FC Volendam 34 40 75 31
18 TOP Oss TOP Oss 34 35 74 27
TEMPORADA 1998/1999
EERSTE DIVISIE
Equipo PJ GF GC Puntos
1 Den Bosch Den Bosch 34 80 35 77
2 Groningen Groningen 34 69 33 64
3 Emmen Emmen 34 53 37 61
4 Helmond Sport Helmond 34 55 52 55
5 PEC Zwolle PEC Zwolle 34 57 42 54
6 Excelsior Excelsior 34 74 63 54
7 Go Ahead Eagles Ahead Eagles 34 59 57 50
8 FC Volendam FC Volendam 34 63 66 49
9 FC Eindhoven Eindhoven 34 64 73 48
10 ADO Den Haag Haag 34 52 52 45
11 VVV Venlo VVV Venlo 34 59 66 42
12 RBC Roosendaal Roosendaal 34 54 65 40
13 SC Veendam SC Veendam 34 47 54 39
14 Dordrecht Dordrecht 34 51 66 38
15 HFC Haarlem Haarlem 34 45 67 38
16 TOP Oss TOP Oss 34 43 50 37
17 Heracles Heracles 34 37 58 34
18 SC Telstar SC Telstar 34 45 71 26
TEMPORADA 1997/1998
EERSTE DIVISIE
Equipo PJ GF GC Puntos
TEMPORADA 1996/1997
EERSTE DIVISIE
Equipo PJ GF GC Puntos
1 MVV Maastricht Maastricht 34 62 30 70
2 Cambuur Cambuur 34 65 33 67
3 Emmen Emmen 34 58 36 63
4 PEC Zwolle PEC Zwolle 34 52 40 55
5 VVV Venlo VVV Venlo 33 52 39 54
6 Den Bosch Den Bosch 34 55 43 54
7 Go Ahead Eagles Ahead Eagles 33 56 47 52
8 ADO Den Haag Haag 34 48 48 52
9 FC Eindhoven Eindhoven 34 53 53 50
10 SC Veendam SC Veendam 33 43 33 49
11 TOP Oss TOP Oss 34 46 50 47
12 Dordrecht Dordrecht 34 45 49 46
13 Heracles Heracles 34 51 50 37
14 Helmond Sport Helmond 33 45 61 36
15 RBC Roosendaal Roosendaal 34 41 63 35
16 SC Telstar SC Telstar 34 34 68 28
17 Excelsior Excelsior 34 37 67 24
18 HFC Haarlem Haarlem 34 34 67 22
TEMPORADA 1993/1994
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 86 26 54
2 Feyenoord Feyenoord 34 61 27 51
3 PSV PSV 34 60 36 44
4 Vitesse Vitesse 34 63 37 40
5 Twente Twente 34 57 43 39
6 Roda JC Roda JC 34 55 40 38
7 NAC Breda NAC Breda 34 61 52 38
8 Willem II Willem II 34 48 42 37
9 Sparta Rotterdam Sparta 34 58 57 32
10 MVV Maastricht Maastricht 34 49 58 32
11 FC Volendam FC Volendam 34 46 55 30
12 Go Ahead Eagles Ahead Eagles 34 44 57 28
13 Heerenveen Heerenveen 34 35 61 28
14 Groningen Groningen 34 42 65 26
15 Utrecht Utrecht 34 40 63 26
16 RKC Waalwijk Waalwijk 34 38 56 25
17 VVV Venlo VVV Venlo 34 30 62 25
18 Cambuur Cambuur 34 28 64 19
TEMPORADA 1991/1992
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 82 24 58
2 Ajax Ajax 34 83 24 55
3 Feyenoord Feyenoord 34 54 19 49
4 Vitesse Vitesse 34 47 33 40
5 Groningen Groningen 34 44 37 39
6 Twente Twente 34 53 49 35
7 MVV Maastricht Maastricht 34 42 44 35
8 Sparta Rotterdam Sparta 34 50 53 35
9 Roda JC Roda JC 34 41 45 35
10 RKC Waalwijk Waalwijk 34 50 49 34
11 Utrecht Utrecht 34 37 39 33
12 Willem II Willem II 34 44 45 31
13 FC Volendam FC Volendam 34 34 50 28
14 Fortuna Sittard Fortuna 34 36 50 25
15 Dordrecht Dordrecht 34 38 64 25
16 ADO Den Haag Haag 34 35 63 22
17 De Graafschap Graafschap 34 29 59 21
18 VVV Venlo VVV Venlo 34 32 84 12
TEMPORADA 1988/1989
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 78 31 53
2 Ajax Ajax 34 74 32 50
3 Twente Twente 34 47 25 40
4 Feyenoord Feyenoord 34 66 52 40
5 Roda JC Roda JC 34 52 38 38
6 Groningen Groningen 34 62 51 36
7 Den Bosch Den Bosch 34 48 53 36
8 Fortuna Sittard Fortuna 34 40 37 34
9 FC Volendam FC Volendam 34 42 51 33
10 HFC Haarlem Haarlem 34 37 50 33
11 RKC Waalwijk Waalwijk 34 53 61 31
12 Sparta Rotterdam Sparta 34 42 50 30
13 Utrecht Utrecht 34 49 57 29
14 MVV Maastricht Maastricht 34 41 58 29
15 Willem II Willem II 34 50 68 27
16 PEC Zwolle PEC Zwolle 34 48 70 25
17 VVV Venlo VVV Venlo 34 40 62 24
18 SC Veendam SC Veendam 34 37 60 24
TEMPORADA 1987/1988
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 117 28 59
2 Ajax Ajax 34 78 40 50
3 Twente Twente 34 63 40 41
4 Willem II Willem II 34 60 46 38
5 VVV Venlo VVV Venlo 34 43 35 38
6 Feyenoord Feyenoord 34 63 57 36
7 Den Bosch Den Bosch 34 46 46 36
8 Fortuna Sittard Fortuna 34 51 48 35
9 HFC Haarlem Haarlem 34 42 46 34
10 Utrecht Utrecht 34 41 55 33
11 Groningen Groningen 34 54 52 32
12 Sparta Rotterdam Sparta 34 44 50 32
13 PEC Zwolle PEC Zwolle 34 40 64 29
14 FC Volendam FC Volendam 34 40 66 29
15 Roda JC Roda JC 34 46 54 28
16 AZ Alkmaar AZ Alkmaar 34 44 64 28
17 ADO Den Haag Haag 34 50 72 22
18 Dordrecht Dordrecht 34 41 100 12
TEMPORADA 1986/1987
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 99 21 59
2 Ajax Ajax 34 92 30 53
3 Feyenoord Feyenoord 34 73 43 42
4 Roda JC Roda JC 34 51 45 39
5 VVV Venlo VVV Venlo 34 46 45 37
6 Utrecht Utrecht 34 62 56 36
7 Twente Twente 34 39 44 36
8 Sparta Rotterdam Sparta 34 52 48 34
9 Fortuna Sittard Fortuna 34 47 49 32
10 Den Bosch Den Bosch 34 43 52 32
11 PEC Zwolle PEC Zwolle 34 61 57 31
12 HFC Haarlem Haarlem 34 32 57 31
13 Groningen Groningen 34 43 43 30
14 ADO Den Haag Haag 34 46 64 28
15 AZ Alkmaar AZ Alkmaar 34 31 57 27
16 Go Ahead Eagles Ahead Eagles 34 23 48 23
17 SC Veendam SC Veendam 34 37 67 23
18 Excelsior Excelsior 34 40 91 19
TEMPORADA 1985/1986
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 100 22 60
2 Ajax Ajax 34 120 35 52
3 Feyenoord Feyenoord 34 74 50 44
4 Groningen Groningen 34 57 40 40
5 Roda JC Roda JC 34 76 51 39
6 Den Bosch Den Bosch 34 50 41 37
7 Sparta Rotterdam Sparta 34 54 59 37
8 Fortuna Sittard Fortuna 34 47 47 34
9 AZ Alkmaar AZ Alkmaar 34 40 55 34
10 Go Ahead Eagles Ahead Eagles 34 47 62 33
11 HFC Haarlem Haarlem 34 48 47 32
12 Utrecht Utrecht 34 40 46 32
13 VVV Venlo VVV Venlo 34 39 62 27
14 Twente Twente 34 36 69 27
15 Excelsior Excelsior 34 31 48 25
16 MVV Maastricht Maastricht 34 34 60 24
17 NEC Nijmegen Nijmegen 34 33 59 23
18 Heracles Heracles 34 26 99 12
TEMPORADA 1978/1979
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 93 31 54
2 Feyenoord Feyenoord 34 62 19 51
3 PSV PSV 34 65 23 49
4 AZ Alkmaar AZ Alkmaar 34 84 43 45
5 Roda JC Roda JC 34 58 33 44
6 Sparta Rotterdam Sparta 34 47 48 33
7 ADO Den Haag Haag 34 43 55 33
8 PEC Zwolle PEC Zwolle 34 36 46 32
9 Go Ahead Eagles Ahead Eagles 34 48 48 31
10 NAC Breda NAC Breda 34 41 51 31
11 MVV Maastricht Maastricht 34 26 45 31
12 Twente Twente 34 54 58 30
13 Utrecht Utrecht 34 43 55 30
14 Vitesse Vitesse 34 42 63 29
15 NEC Nijmegen Nijmegen 34 35 49 28
16 HFC Haarlem Haarlem 34 31 64 25
17 FC Volendam FC Volendam 34 42 63 22
18 VVV Venlo VVV Venlo 34 23 79 14
TEMPORADA 1977/1978
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 74 21 53
2 Ajax Ajax 34 85 36 49
3 AZ Alkmaar AZ Alkmaar 34 75 30 47
4 Twente Twente 34 61 32 45
5 Sparta Rotterdam Sparta 34 54 33 40
6 Roda JC Roda JC 34 41 40 36
7 FC Volendam FC Volendam 34 50 58 34
8 Utrecht Utrecht 34 40 45 33
9 Vitesse Vitesse 34 48 62 33
10 Feyenoord Feyenoord 34 52 47 32
11 NAC Breda NAC Breda 34 37 51 31
12 ADO Den Haag Haag 34 45 57 28
13 HFC Haarlem Haarlem 34 37 55 28
14 VVV Venlo VVV Venlo 34 46 66 28
15 NEC Nijmegen Nijmegen 34 39 59 28
16 Go Ahead Eagles Ahead Eagles 34 49 53 27
17 FC Amsterdam Amsterdam 34 41 73 26
18 SC Telstar SC Telstar 34 25 81 14
TEMPORADA 1976/1977
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 62 26 52
2 PSV PSV 34 64 31 47
3 AZ Alkmaar AZ Alkmaar 34 75 29 46
4 Feyenoord Feyenoord 34 65 35 44
5 Roda JC Roda JC 34 53 35 42
6 Utrecht Utrecht 34 59 66 38
7 Sparta Rotterdam Sparta 34 52 47 36
8 NAC Breda NAC Breda 34 41 53 34
9 Twente Twente 34 52 40 33
10 ADO Den Haag Haag 34 50 42 32
11 Go Ahead Eagles Ahead Eagles 34 43 63 31
12 HFC Haarlem Haarlem 34 35 47 29
13 VVV Venlo VVV Venlo 34 37 60 27
14 SC Telstar SC Telstar 34 35 57 26
15 FC Amsterdam Amsterdam 34 41 58 25
16 NEC Nijmegen Nijmegen 34 41 54 24
17 FC Eindhoven Eindhoven 34 28 63 24
18 De Graafschap Graafschap 34 29 56 22
TEMPORADA 1961/1962
EREDIVISIE
Equipo PJ GF GC Puntos
1 Feyenoord Feyenoord 34 88 35 50
2 PSV PSV 34 85 43 49
3 FC Blauw Wit Amsterdam Blauw 34 71 54 41
4 Ajax Ajax 34 80 59 39
5 NAC Breda NAC Breda 34 60 49 38
6 MVV Maastricht Maastricht 34 55 46 36
7 FC Volendam FC Volendam 34 69 76 34
8 Willem II Willem II 34 63 52 33
9 Sparta Rotterdam Sparta 34 46 50 33
10 VV Dos VV Dos 34 61 62 32
11 De Volewijckers Volewijckers 34 68 87 32
12 Fortuna 54 Fortuna 54 34 57 61 31
13 Groningen Groningen 34 48 61 30
14 SC Enschede SC Enschede 34 55 69 30
15 ADO Den Haag Haag 34 58 69 29
16 Amsterdam FC DWS Amsterdam 34 38 63 28
17 VVV Venlo VVV Venlo 34 38 62 27
18 Roda JC Roda JC 34 35 77 20
TEMPORADA 1960/1961
EREDIVISIE
Equipo PJ GF GC Puntos
1 Feyenoord Feyenoord 34 100 40 53
2 Ajax Ajax 34 102 51 51
3 VVV Venlo VVV Venlo 34 77 47 42
4 Sparta Rotterdam Sparta 34 71 54 41
5 VV Dos VV Dos 34 71 49 39
6 Groningen Groningen 34 57 51 38
7 PSV PSV 34 74 59 37
8 Amsterdam FC DWS Amsterdam 34 59 49 35
9 NAC Breda NAC Breda 34 59 64 34
10 Willem II Willem II 34 53 71 32
11 ADO Den Haag Haag 34 59 78 32
12 SC Enschede SC Enschede 34 52 63 30
13 Rapid JC Rapid JC 34 42 54 29
14 MVV Maastricht Maastricht 34 45 70 28
15 Fortuna 54 Fortuna 54 34 52 69 26
16 Elinkwijk Elinkwijk 34 43 72 25
17 AZ Alkmaar AZ Alkmaar 34 39 61 24
18 TSV NOAD Tilburg NOAD Tilburg 34 28 81 16
TEMPORADA 1959/1960
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 109 44 50
2 Feyenoord Feyenoord 34 94 32 50
3 PSV PSV 34 72 48 45
4 VV Dos VV Dos 34 75 57 40
5 NAC Breda NAC Breda 34 56 53 39
6 VVV Venlo VVV Venlo 34 57 60 36
7 Sparta Rotterdam Sparta 34 53 52 34
8 Willem II Willem II 34 65 69 33
9 SC Enschede SC Enschede 34 81 76 32
10 Amsterdam FC DWS Amsterdam 34 51 59 32
11 Rapid JC Rapid JC 34 46 55 32
12 ADO Den Haag Haag 34 62 68 31
13 MVV Maastricht Maastricht 34 60 69 31
14 Fortuna 54 Fortuna 54 34 67 81 30
15 Elinkwijk Elinkwijk 34 37 48 29
16 FC Blauw Wit Amsterdam Blauw 34 53 82 29
17 FC Volendam FC Volendam 34 54 88 23
18 Sittardia Sittardia 34 40 91 16
TEMPORADA 1958/1959
EREDIVISIE
Equipo PJ GF GC Puntos
1 Sparta Rotterdam Sparta 34 83 30 51
2 Rapid JC Rapid JC 34 64 34 48
3 Fortuna 54 Fortuna 54 34 56 47 44
4 VV Dos VV Dos 34 86 46 43
5 Feyenoord Feyenoord 34 84 54 41
6 Ajax Ajax 34 77 63 37
7 SC Enschede SC Enschede 34 67 59 37
8 MVV Maastricht Maastricht 34 64 59 37
9 VVV Venlo VVV Venlo 34 71 65 36
10 PSV PSV 34 61 60 33
11 NAC Breda NAC Breda 34 72 72 32
12 Elinkwijk Elinkwijk 34 55 57 30
13 ADO Den Haag Haag 34 63 84 28
14 FC Blauw Wit Amsterdam Blauw 34 62 79 26
15 Amsterdam FC DWS Amsterdam 34 54 80 26
16 Willem II Willem II 34 60 98 25
17 TSV NOAD Tilburg NOAD Tilburg 34 55 90 20
18 SHS Scheveningen Holland Scheveningen 34 54 111 18
TEMPORADA 1957/1958
EREDIVISIE
Equipo PJ GF GC Puntos
1 VV Dos VV Dos 34 84 52 47
2 SC Enschede SC Enschede 34 75 48 47
3 Ajax Ajax 34 62 44 42
4 Fortuna 54 Fortuna 54 34 72 53 40
5 MVV Maastricht Maastricht 34 57 50 37
6 ADO Den Haag Haag 34 68 56 35
7 VVV Venlo VVV Venlo 34 61 59 35
8 NAC Breda NAC Breda 34 69 70 35
9 Sparta Rotterdam Sparta 34 63 62 34
10 PSV PSV 34 73 70 32
11 Feyenoord Feyenoord 34 74 76 32
12 Rapid JC Rapid JC 34 56 67 31
13 FC Blauw Wit Amsterdam Blauw 34 56 59 30
14 Amsterdam FC DWS Amsterdam 34 54 63 30
15 TSV NOAD Tilburg NOAD Tilburg 34 50 76 29
16 Groningen Groningen 34 58 63 28
17 Elinkwijk Elinkwijk 34 47 71 28
18 Den Bosch Den Bosch 34 56 96 20
TEMPORADA 1956/1957
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 64 40 49
2 Fortuna 54 Fortuna 54 34 76 48 45
3 SC Enschede SC Enschede 34 81 47 41
4 MVV Maastricht Maastricht 34 53 42 40
5 PSV PSV 34 93 71 39
6 Feyenoord Feyenoord 34 79 58 39
7 VVV Venlo VVV Venlo 34 50 53 38
8 Sparta Rotterdam Sparta 34 66 59 36
9 NAC Breda NAC Breda 34 59 61 36
10 VV Dos VV Dos 34 79 75 35
11 Rapid JC Rapid JC 34 64 63 33
12 TSV NOAD Tilburg NOAD Tilburg 34 54 64 31
13 Amsterdam FC DWS Amsterdam 34 49 67 30
14 Groningen Groningen 34 52 66 28
15 Den Bosch Den Bosch 34 70 76 26
16 Elinkwijk Elinkwijk 34 52 87 24
17 Willem II Willem II 34 59 79 22
18 FC Eindhoven Eindhoven 34 39 83 20

  USO DE MEMORIA  
7,807,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1453
Total Execution Time  0.1465
  CADENA URL  
/historico/Vvv/2001
  GET DATOS  
$_GET['/historico/Vvv/2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0034  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 = 'Vvv' AND l.year = 2001 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.0019  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=2739 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=2739 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2739 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 619
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2739 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2739 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 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 (175484,266191,265496,279015,303110) ORDER BY n.cover_points DESC, update_date DESC
0.0035  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 = '2739' AND l.year = 2001 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '2739' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 619 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=2739 AND l.year in (2000,2001,2002) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (23495,620) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 620 AND teamId = 2739
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 23495 AND teamId = 2739
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 619 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0032  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 events2001 e ON e.player_id = p.id AND e.league_id = 619 WHERE rp.league_id = 619 AND rp.teamId = 2739 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.0029  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 events2001 e ON e.player_id = p.id AND e.league_id = 619 WHERE rp.league_id = 619 AND rp.teamId = 2739 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 events2001 e ON e.player_id = p.id AND e.league_id = 619 WHERE rp.league_id = 619 AND rp.teamId = 2739 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 2739 AND l.year <= 2001 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027  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 = 619 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049  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 `tables2000` 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 = 620 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 13386 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 13387 AND t.round = 35 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 13388 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 187 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1992` 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 = 5798 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1989` 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 = 5795 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1988` 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 = 5794 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1987` 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 = 5793 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1986` 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 = 5792 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1979` 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 = 5785 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1978` 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 = 5784 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1977` 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 = 5783 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1962` 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 = 5768 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1961` 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 = 5767 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1960` 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 = 5766 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1959` 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 = 5765 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1958` 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 = 5764 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1957` 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 = 5763 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC