4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2005/2006
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 30 49 16 64
2 FC Rapid Bucuresti Rapid 30 47 23 59
3 Dinamo Bucureşti Dinamo 30 56 32 56
4 Sportul Studenţesc Sportul 30 54 35 56
5 CFR Cluj CFR Cluj 30 36 27 50
6 Progresul Bucureşti Progresul 30 32 37 46
7 FC Farul Constanta Farul 30 39 38 45
8 Politehnica Timisoara Politehnica 30 34 31 40
9 Oțelul Galați Oțelul 30 35 37 39
10 ACF Gloria Bistrita Gloria 30 27 34 39
11 FC Politehnica Iasi Politehnica 30 28 31 39
12 Argeş Piteşti Argeş 30 27 37 32
13 Jiul Petrosani Jiul 30 28 39 30
14 FC Vaslui FC Vaslui 30 23 37 29
15 Pandurii Pandurii 30 22 44 25
16 FC Municipal Bacău Municipal 30 16 55 14
TEMPORADA 2004/2005
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 30 47 18 63
2 Dinamo Bucureşti Dinamo 30 60 30 62
3 FC Rapid Bucuresti Rapid 30 51 27 57
4 Progresul Bucureşti Progresul 30 50 33 57
5 FC Farul Constanta Farul 30 42 28 52
6 Politehnica Timisoara Politehnica 30 37 34 45
7 Sportul Studenţesc Sportul 30 37 27 45
8 Oțelul Galați Oțelul 30 31 32 40
9 FC Politehnica Iasi Politehnica 30 28 41 38
10 Argeş Piteşti Argeş 30 32 37 36
11 CFR Cluj CFR Cluj 30 33 44 36
12 FC Municipal Bacău Municipal 30 20 28 33
13 ACF Gloria Bistrita Gloria 30 38 46 32
14 FC Unirea Alba Iulia Unirea Alba 30 28 62 26
15 FC Brasov FC Brasov 30 28 45 21
16 FC Universitatea Craiova Universitate 30 24 54 20
TEMPORADA 2003/2004
LIGA RUMANA
Equipo PJ GF GC Puntos
1 Dinamo Bucureşti Dinamo 30 71 30 70
2 FCSB FCSB 30 60 20 64
3 FC Rapid Bucuresti Rapid 30 51 32 55
4 FC Universitatea Craiova Universitate 30 38 34 44
5 Oțelul Galați Oțelul 30 30 26 43
6 FC Unirea Alba Iulia Unirea Alba 30 32 47 41
7 Progresul Bucureşti Progresul 30 36 39 39
8 Politehnica Timisoara Politehnica 30 30 40 39
9 FC Farul Constanta Farul 30 39 42 37
10 Argeş Piteşti Argeş 30 31 35 36
11 FC Brasov FC Brasov 30 40 42 36
12 ACF Gloria Bistrita Gloria 30 36 48 35
13 FC Municipal Bacău Municipal 30 29 43 31
14 FC Ceahlaul Piatra Neamt Ceahlaul 30 34 50 30
15 Petrolul Ploiesti Petrolul 30 38 55 27
16 Bihor Oradea Bihor Oradea 30 38 50 24
TEMPORADA 2002/2003
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FC Rapid Bucuresti Rapid 30 59 25 63
2 FCSB FCSB 30 42 27 56
3 ACF Gloria Bistrita Gloria 30 32 33 45
4 FC Brasov FC Brasov 30 37 33 45
5 FC Ceahlaul Piatra Neamt Ceahlaul 30 43 33 44
6 Dinamo Bucureşti Dinamo 30 49 46 44
7 FC Universitatea Craiova Universitate 30 36 37 44
8 Progresul Bucureşti Progresul 30 41 36 43
9 FC Astra Giurgiu Astra 30 42 42 42
10 FC Farul Constanta Farul 30 35 47 40
11 Argeş Piteşti Argeş 30 37 41 38
12 FC Municipal Bacău Municipal 30 31 31 38
13 Oțelul Galați Oțelul 30 25 37 36
14 Politehnica Timisoara Politehnica 30 37 52 35
15 Sportul Studenţesc Sportul 30 44 55 31
16 UTA Arad UTA Arad 30 37 52 30
TEMPORADA 1996/1997
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 87 40 73
2 Progresul Bucureşti Progresul 34 69 36 68
3 Dinamo Bucureşti Dinamo 34 56 34 59
4 Oțelul Galați Oțelul 34 54 39 58
5 FC Municipal Bacău Municipal 34 43 41 53
6 FC Ceahlaul Piatra Neamt Ceahlaul 34 51 50 52
7 Argeş Piteşti Argeş 34 46 37 50
8 FC Rapid Bucuresti Rapid 34 45 41 48
9 Petrolul Ploiesti Petrolul 34 48 43 46
10 FC Farul Constanta Farul 34 46 52 46
11 FC Universitatea Craiova Universitate 34 48 52 43
12 Sportul Studenţesc Sportul 34 36 52 42
13 ACF Gloria Bistrita Gloria 34 38 45 41
14 Jiul Petrosani Jiul 34 33 61 41
15 Universitatea Cluj Universitate 34 52 67 39
16 Chindia Chindia 34 32 55 38
17 Politehnica Timisoara Politehnica 34 45 65 35
18 FC Brasov FC Brasov 34 42 61 32
TEMPORADA 1995/1996
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 79 30 71
2 Progresul Bucureşti Progresul 34 60 44 60
3 FC Rapid Bucuresti Rapid 34 59 33 59
4 FC Universitatea Craiova Universitate 34 45 30 57
5 Dinamo Bucureşti Dinamo 34 40 37 52
6 Petrolul Ploiesti Petrolul 34 44 38 51
7 Politehnica Timisoara Politehnica 34 58 47 49
8 FC Farul Constanta Farul 34 56 49 49
9 Universitatea Cluj Universitate 34 41 40 48
10 FC Brasov FC Brasov 34 38 60 46
11 ACF Gloria Bistrita Gloria 34 41 38 45
12 Oțelul Galați Oțelul 34 42 46 45
13 FC Municipal Bacău Municipal 34 40 58 45
14 Sportul Studenţesc Sportul 34 33 35 43
15 FC Ceahlaul Piatra Neamt Ceahlaul 34 34 46 43
16 Argeş Piteşti Argeş 34 39 52 42
17 Inter Sibiu Inter Sibiu 34 29 48 37
18 FC Politehnica Iasi Politehnica 34 27 74 30
TEMPORADA 1993/1994
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 63 19 53
2 FC Universitatea Craiova Universitate 34 64 46 40
3 Dinamo Bucureşti Dinamo 34 65 40 39
4 FC Rapid Bucuresti Rapid 34 43 32 38
5 Petrolul Ploiesti Petrolul 34 34 30 38
6 FC Farul Constanta Farul 34 42 38 37
7 ACF Gloria Bistrita Gloria 34 47 43 35
8 Inter Sibiu Inter Sibiu 34 40 41 34
9 Progresul Bucureşti Progresul 34 44 42 32
10 FC Ceahlaul Piatra Neamt Ceahlaul 34 27 40 32
11 UTA Arad UTA Arad 34 35 49 32
12 Universitatea Cluj Universitate 34 39 42 31
13 FC Brasov FC Brasov 34 38 52 31
14 Extensiv Craiova Extensiv 34 25 34 30
15 Oțelul Galați Oțelul 34 38 47 29
16 Sportul Studenţesc Sportul 34 30 45 29
17 Politehnica Timisoara Politehnica 34 39 53 28
18 Brăila Brăila 34 33 53 24
TEMPORADA 1992/1993
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 84 22 57
2 Dinamo Bucureşti Dinamo 34 81 24 53
3 FC Universitatea Craiova Universitate 34 50 36 42
4 FC Rapid Bucuresti Rapid 34 40 33 39
5 ACF Gloria Bistrita Gloria 34 45 41 35
6 Extensiv Craiova Extensiv 34 35 32 35
7 Sportul Studenţesc Sportul 34 40 43 34
8 Inter Sibiu Inter Sibiu 34 41 47 33
9 FC Farul Constanta Farul 34 57 66 32
10 Oțelul Galați Oțelul 34 40 49 32
11 Universitatea Cluj Universitate 34 43 51 30
12 FC Brasov FC Brasov 34 36 45 30
13 Politehnica Timisoara Politehnica 34 34 46 29
14 Progresul Bucureşti Progresul 34 38 53 29
15 Brăila Brăila 34 36 51 29
16 Petrolul Ploiesti Petrolul 34 47 50 27
17 FC Municipal Bacău Municipal 34 24 44 25
18 FCM Reșița Reșița 34 34 72 21
TEMPORADA 1991/1992
LIGA RUMANA
Equipo PJ GF GC Puntos
1 Dinamo Bucureşti Dinamo 34 76 23 55
2 FCSB FCSB 34 68 31 48
3 Extensiv Craiova Extensiv 34 43 28 39
4 FC Universitatea Craiova Universitate 34 38 28 39
5 Politehnica Timisoara Politehnica 34 36 34 39
6 Brăila Brăila 34 39 37 35
7 FC Rapid Bucuresti Rapid 34 34 37 35
8 Oțelul Galați Oțelul 34 38 46 35
9 FC Brasov FC Brasov 34 53 49 34
10 Petrolul Ploiesti Petrolul 34 37 49 34
11 ACF Gloria Bistrita Gloria 34 46 40 33
12 Inter Sibiu Inter Sibiu 34 42 43 33
13 FC Farul Constanta Farul 34 40 43 32
14 FC Municipal Bacău Municipal 34 32 54 29
15 Sportul Studenţesc Sportul 34 37 47 28
16 Argeş Piteşti Argeş 34 38 52 24
17 ASA Târgu Mureş Târgu 34 31 55 21
18 CS Hunedoara Hunedoara 34 35 67 19
TEMPORADA 1990/1991
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FC Universitatea Craiova Universitate 34 74 26 50
2 FCSB FCSB 34 67 28 50
3 Dinamo Bucureşti Dinamo 34 54 27 43
4 Inter Sibiu Inter Sibiu 34 56 46 38
5 ACF Gloria Bistrita Gloria 34 51 38 37
6 Politehnica Timisoara Politehnica 34 45 45 35
7 Petrolul Ploiesti Petrolul 34 48 49 35
8 Argeş Piteşti Argeş 34 49 42 34
9 FC Brasov FC Brasov 34 47 45 34
10 FC Farul Constanta Farul 34 40 40 34
11 FC Rapid Bucuresti Rapid 34 44 45 32
12 Sportul Studenţesc Sportul 34 45 53 32
13 CS Hunedoara Hunedoara 34 47 62 32
14 Brăila Brăila 34 33 49 31
15 FC Municipal Bacău Municipal 34 32 42 29
16 Jiul Petrosani Jiul 34 46 65 28
17 Bihor Oradea Bihor Oradea 34 40 75 22
18 Universitatea Cluj Universitate 34 26 67 16
TEMPORADA 1989/1990
LIGA RUMANA
Equipo PJ GF GC Puntos
1 Dinamo Bucureşti Dinamo 34 96 23 57
2 FCSB FCSB 34 89 30 56
3 FC Universitatea Craiova Universitate 34 56 27 44
4 Politehnica Timisoara Politehnica 34 65 40 41
5 Petrolul Ploiesti Petrolul 34 56 40 41
6 Inter Sibiu Inter Sibiu 34 52 42 36
7 FC Brasov FC Brasov 34 42 57 35
8 CS Hunedoara Hunedoara 34 37 56 32
9 FC Farul Constanta Farul 34 54 54 31
10 Bihor Oradea Bihor Oradea 34 61 61 30
11 Sportul Studenţesc Sportul 34 43 57 30
12 Argeş Piteşti Argeş 34 38 45 29
13 FC Municipal Bacău Municipal 34 43 56 29
14 Jiul Petrosani Jiul 34 41 54 29
15 Universitatea Cluj Universitate 34 40 60 29
16 Flacara Moreni Flacara 34 37 48 28
17 Victoria Bucuresti Victoria 33 24 64 21
18 Olt Scornicesti Scornicesti 33 16 76 12
TEMPORADA 1987/1988
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 114 18 64
2 Dinamo Bucureşti Dinamo 34 107 25 63
3 Victoria Bucuresti Victoria 34 58 41 40
4 Oțelul Galați Oțelul 34 49 46 39
5 FC Universitatea Craiova Universitate 34 61 51 36
6 Flacara Moreni Flacara 34 40 48 33
7 CS Hunedoara Hunedoara 34 54 63 30
8 FC Brasov FC Brasov 34 47 51 29
9 Argeş Piteşti Argeş 34 41 47 29
10 Universitatea Cluj Universitate 34 39 54 29
11 ASA Târgu Mureş Târgu 34 49 66 29
12 FC Municipal Bacău Municipal 34 37 54 29
13 FC Rapid Bucuresti Rapid 34 36 58 29
14 Sportul Studenţesc Sportul 34 43 50 28
15 Olt Scornicesti Scornicesti 34 38 63 28
16 Politehnica Timisoara Politehnica 34 35 53 26
17 Petrolul Ploiesti Petrolul 34 25 52 26
18 CSM Suceava CSM Suceava 34 36 69 25
TEMPORADA 1985/1986
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 79 25 57
2 Sportul Studenţesc Sportul 34 87 41 48
3 FC Universitatea Craiova Universitate 34 65 36 46
4 Dinamo Bucureşti Dinamo 34 49 27 46
5 CS Hunedoara Hunedoara 34 84 50 37
6 Argeş Piteşti Argeş 34 39 41 36
7 Universitatea Cluj Universitate 34 51 52 33
8 FC Rapid Bucuresti Rapid 34 41 56 33
9 Petrolul Ploiesti Petrolul 34 34 41 31
10 FC Municipal Bacău Municipal 34 45 50 30
11 FC Brasov FC Brasov 34 35 58 30
12 Victoria Bucuresti Victoria 34 36 47 29
13 Olt Scornicesti Scornicesti 34 42 57 29
14 Chimia Râmnicu-Vâlcea Chimia 34 36 53 29
15 FC Buzău FC Buzău 34 45 61 28
16 Politehnica Timisoara Politehnica 34 48 56 27
17 ASA Târgu Mureş Târgu 34 30 50 26
18 Bihor Oradea Bihor Oradea 34 26 71 17
TEMPORADA 1984/1985
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 71 24 54
2 Dinamo Bucureşti Dinamo 34 59 31 52
3 Sportul Studenţesc Sportul 34 71 28 48
4 FC Universitatea Craiova Universitate 34 61 46 39
5 FC Buzău FC Buzău 34 51 51 34
6 ASA Târgu Mureş Târgu 34 32 32 33
7 Argeş Piteşti Argeş 34 44 35 32
8 CS Hunedoara Hunedoara 34 51 52 32
9 Politehnica Timisoara Politehnica 34 35 52 32
10 Bihor Oradea Bihor Oradea 34 39 43 31
11 FC Rapid Bucuresti Rapid 34 36 43 30
12 FC Brasov FC Brasov 34 33 41 30
13 Olt Scornicesti Scornicesti 34 34 52 30
14 Chimia Râmnicu-Vâlcea Chimia 34 26 50 29
15 FC Municipal Bacău Municipal 34 36 41 28
16 Jiul Petrosani Jiul 34 36 58 28
17 FC Baia Mare Baia Mare 34 30 46 26
18 FC Politehnica Iasi Politehnica 34 36 56 24
TEMPORADA 1982/1983
LIGA RUMANA
Equipo PJ GF GC Puntos
1 Dinamo Bucureşti Dinamo 34 62 25 49
2 FC Universitatea Craiova Universitate 34 66 29 46
3 Sportul Studenţesc Sportul 34 48 29 44
4 Argeş Piteşti Argeş 34 50 37 40
5 FCSB FCSB 34 47 41 38
6 CS Hunedoara Hunedoara 34 46 38 34
7 Olt Scornicesti Scornicesti 34 47 36 33
8 ASA Târgu Mureş Târgu 34 41 42 33
9 Jiul Petrosani Jiul 34 35 43 33
10 FC Politehnica Iasi Politehnica 34 37 40 32
11 Bihor Oradea Bihor Oradea 34 56 62 32
12 Petrolul Ploiesti Petrolul 34 38 55 32
13 FC Municipal Bacău Municipal 34 43 47 31
14 FCM Târgovişte Târgovişte 34 36 44 31
15 Chimia Râmnicu-Vâlcea Chimia 34 33 43 31
16 FC Brasov FC Brasov 34 41 51 29
17 Politehnica Timisoara Politehnica 34 35 64 24
18 FC Farul Constanta Farul 34 30 65 20
TEMPORADA 1981/1982
LIGA RUMANA
Equipo PJ GF GC Puntos
1 Dinamo Bucureşti Dinamo 34 62 31 47
2 FC Universitatea Craiova Universitate 34 67 28 45
3 CS Hunedoara Hunedoara 34 64 42 39
4 Olt Scornicesti Scornicesti 34 48 41 39
5 Sportul Studenţesc Sportul 34 36 36 38
6 FCSB FCSB 34 41 33 37
7 FC Municipal Bacău Municipal 34 40 47 33
8 Chimia Râmnicu-Vâlcea Chimia 34 37 48 33
9 FCM Târgovişte Târgovişte 34 30 43 33
10 Argeş Piteşti Argeş 34 36 34 32
11 Politehnica Timisoara Politehnica 34 40 41 32
12 Jiul Petrosani Jiul 34 40 43 32
13 FC Brasov FC Brasov 34 31 40 32
14 FC Farul Constanta Farul 34 38 46 31
15 ASA Târgu Mureş Târgu 34 45 47 30
16 Universitatea Cluj Universitate 34 34 49 30
17 UTA Arad UTA Arad 34 33 40 29
18 Progresul Bucureşti Progresul 34 29 62 20
TEMPORADA 1980/1981
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FC Universitatea Craiova Universitate 34 72 33 46
2 Dinamo Bucureşti Dinamo 34 57 34 43
3 Argeş Piteşti Argeş 34 63 39 42
4 FCSB FCSB 34 50 45 38
5 Sportul Studenţesc Sportul 34 54 35 36
6 CS Hunedoara Hunedoara 34 72 48 35
7 Olt Scornicesti Scornicesti 34 44 49 35
8 FC Brasov FC Brasov 34 35 41 34
9 Chimia Râmnicu-Vâlcea Chimia 34 51 60 34
10 Jiul Petrosani Jiul 34 44 41 33
11 FC Municipal Bacău Municipal 34 46 51 33
12 Politehnica Timisoara Politehnica 34 33 46 33
13 ASA Târgu Mureş Târgu 34 50 56 32
14 Universitatea Cluj Universitate 34 47 57 32
15 Progresul Bucureşti Progresul 34 39 50 32
16 FC Politehnica Iasi Politehnica 34 44 53 30
17 FC Baia Mare Baia Mare 34 37 62 26
18 Dunărea Galaţi Dunărea 34 34 72 18
TEMPORADA 1979/1980
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FC Universitatea Craiova Universitate 34 66 31 44
2 FCSB FCSB 34 74 44 44
3 Argeş Piteşti Argeş 34 51 38 39
4 FC Baia Mare Baia Mare 34 57 51 39
5 Dinamo Bucureşti Dinamo 34 50 37 37
6 Sportul Studenţesc Sportul 34 44 34 37
7 FC Municipal Bacău Municipal 34 40 47 35
8 FC Politehnica Iasi Politehnica 34 47 45 34
9 Chimia Râmnicu-Vâlcea Chimia 34 42 49 34
10 Politehnica Timisoara Politehnica 34 47 50 33
11 Jiul Petrosani Jiul 34 26 39 33
12 Universitatea Cluj Universitate 34 44 43 32
13 Olt Scornicesti Scornicesti 34 46 55 32
14 Dunărea Galaţi Dunărea 34 50 61 32
15 ASA Târgu Mureş Târgu 34 45 46 31
16 FCM Târgovişte Târgovişte 34 48 53 31
17 FC Olimpia Satu Mare Olimpia Satu 34 35 50 30
18 FC Buzău FC Buzău 34 22 61 15
TEMPORADA 1978/1979
LIGA RUMANA
Equipo PJ GF GC Puntos
1 Argeş Piteşti Argeş 34 54 29 45
2 Dinamo Bucureşti Dinamo 34 51 28 41
3 FCSB FCSB 34 57 32 40
4 FC Universitatea Craiova Universitate 34 40 25 38
5 FC Baia Mare Baia Mare 34 42 38 38
6 Sportul Studenţesc Sportul 34 42 41 35
7 FCM Târgovişte Târgovişte 34 38 38 35
8 FC Municipal Bacău Municipal 34 37 38 34
9 ASA Târgu Mureş Târgu 34 49 59 32
10 FC Olimpia Satu Mare Olimpia Satu 34 38 52 32
11 Politehnica Timisoara Politehnica 34 35 37 31
12 FC Politehnica Iasi Politehnica 34 37 44 31
13 FC Buzău FC Buzău 34 34 46 31
14 Jiul Petrosani Jiul 34 38 51 31
15 Chimia Râmnicu-Vâlcea Chimia 34 38 54 31
16 CS Hunedoara Hunedoara 34 45 50 30
17 UTA Arad UTA Arad 34 45 46 29
18 Bihor Oradea Bihor Oradea 34 37 49 28
TEMPORADA 1977/1978
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 75 49 41
2 Argeş Piteşti Argeş 34 60 49 41
3 Politehnica Timisoara Politehnica 34 48 38 38
4 Sportul Studenţesc Sportul 34 49 42 38
5 Dinamo Bucureşti Dinamo 34 50 40 36
6 FC Universitatea Craiova Universitate 34 43 34 35
7 Jiul Petrosani Jiul 34 53 49 34
8 CS Hunedoara Hunedoara 34 44 43 34
9 FCM Târgovişte Târgovişte 34 28 33 34
10 UTA Arad UTA Arad 34 49 55 34
11 FC Municipal Bacău Municipal 34 47 55 34
12 ASA Târgu Mureş Târgu 34 48 40 33
13 FC Olimpia Satu Mare Olimpia Satu 34 41 47 33
14 Bihor Oradea Bihor Oradea 34 39 56 33
15 FC Politehnica Iasi Politehnica 34 43 39 32
16 FC Farul Constanta Farul 34 42 49 32
17 Petrolul Ploiesti Petrolul 34 41 46 30
18 FCM Reșița Reșița 34 29 65 20

  USO DE MEMORIA  
7,874,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2815
Total Execution Time  0.2836
  CADENA URL  
/historico/Timisoara/2006
  GET DATOS  
$_GET['/historico/Timisoara/2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0229  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 = 'Timisoara' AND l.year = 2006 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=2496 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=2496 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=2496 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 225
0.0029  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 = 20725
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2496 AND type_rel = 2
0.0189  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 = '2496' AND l.year = 2006 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '2496' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = '2496' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 20725 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = 225 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0064  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=2496 AND l.year in (2005,2006,2007) ORDER BY l.id DESC, l.year DESC ;
0.0026  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 (20726,226) 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.0047  SELECT count(id) as num_players from rel_players WHERE league_id = 226 AND teamId = 2496
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 20726 AND teamId = 2496
0.0044  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 225 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0111  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 events2006 e ON e.player_id = p.id AND e.league_id = 225 WHERE rp.league_id = 225 AND rp.teamId = 2496 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.0070  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 events2006 e ON e.player_id = p.id AND e.league_id = 225 WHERE rp.league_id = 225 AND rp.teamId = 2496 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0086  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 events2006 e ON e.player_id = p.id AND e.league_id = 225 WHERE rp.league_id = 225 AND rp.teamId = 2496 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0082  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 = 2496 AND l.year <= 2006 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0041  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 = 225 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 226 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables2004` 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 = 227 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 228 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  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 = 234 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 235 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 10517 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 10516 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 10515 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables1991` 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 = 10514 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables1990` 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 = 10513 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 `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 = 10511 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 10509 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables1985` 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 = 10508 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 `tables1983` 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 = 10506 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 `tables1982` 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 = 10505 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 `tables1981` 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 = 10504 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 `tables1980` 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 = 10503 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 10534 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 10533 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 dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 225 ORDER BY nameShow LIMIT 100