4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1981/1982
LIGA TURCA
Equipo PJ GF GC Puntos
1 Adana Demirspor Adana 0 0 0 0
2 Adanaspor Adanaspor 0 0 0 0
3 Altay Altay 0 0 0 0
4 Ankaragücü Ankaragücü 0 0 0 0
5 Beşiktaş Beşiktaş 0 0 0 0
6 Boluspor Boluspor 0 0 0 0
7 Bursaspor Bursaspor 0 0 0 0
8 Diyarbakirspor Diyarbakirsp 0 0 0 0
9 Eskişehirspor Eskişehirsp 0 0 0 0
10 Fenerbahçe Fenerbahçe 0 0 0 0
11 Galatasaray SK Galatasaray 0 0 0 0
12 Gaziantepspor Gaziantepspo 0 0 0 0
13 Göztepe Göztepe 0 0 0 0
14 Kocaelispor Kocaelispor 0 0 0 0
15 Sakaryaspor Sakaryaspor 0 0 0 0
16 Trabzonspor Trabzonspor 0 0 0 0
17 Zonguldak Kömürspor Zonguldak 0 0 0 0
TEMPORADA 1980/1981
LIGA TURCA
Equipo PJ GF GC Puntos
1 Trabzonspor Trabzonspor 30 41 21 39
2 Adanaspor Adanaspor 30 36 28 34
3 Galatasaray SK Galatasaray 30 28 25 34
4 Gaziantepspor Gaziantepspo 30 23 22 33
5 Beşiktaş Beşiktaş 30 27 23 31
6 Eskişehirspor Eskişehirsp 30 19 19 31
7 Zonguldak Kömürspor Zonguldak 30 36 33 30
8 Kocaelispor Kocaelispor 30 34 32 30
9 Bursaspor Bursaspor 30 30 30 30
10 Fenerbahçe Fenerbahçe 30 31 27 29
11 Altay Altay 30 29 30 29
12 Adana Demirspor Adana 30 25 26 29
13 Boluspor Boluspor 30 32 36 29
14 Rizespor Rizespor 30 35 42 29
15 Mersin Mersin 30 21 34 23
16 Orduspor 1967 Orduspor 30 19 38 20
TEMPORADA 1979/1980
LIGA TURCA
Equipo PJ GF GC Puntos
1 Trabzonspor Trabzonspor 30 25 11 39
2 Fenerbahçe Fenerbahçe 30 31 27 35
3 Zonguldak Kömürspor Zonguldak 30 26 19 33
4 Bursaspor Bursaspor 30 28 28 33
5 Rizespor Rizespor 30 37 34 32
6 Eskişehirspor Eskişehirsp 30 29 26 31
7 Orduspor 1967 Orduspor 30 26 32 30
8 Adana Demirspor Adana 30 26 23 29
9 Galatasaray SK Galatasaray 30 28 26 29
10 Adanaspor Adanaspor 30 21 21 29
11 Beşiktaş Beşiktaş 30 25 27 29
12 Altay Altay 30 28 27 28
13 Gaziantepspor Gaziantepspo 30 25 24 28
14 Göztepe Göztepe 30 27 33 27
15 Kayserispor Kayserispor 30 19 28 25
16 Diyarbakirspor Diyarbakirsp 30 21 36 23
TEMPORADA 1978/1979
LIGA TURCA
Equipo PJ GF GC Puntos
1 Trabzonspor Trabzonspor 30 34 7 42
2 Galatasaray SK Galatasaray 30 47 17 41
3 Fenerbahçe Fenerbahçe 30 41 23 38
4 Orduspor 1967 Orduspor 30 31 27 34
5 Diyarbakirspor Diyarbakirsp 30 26 31 32
6 Altay Altay 30 37 29 31
7 Eskişehirspor Eskişehirsp 30 26 24 31
8 Zonguldak Kömürspor Zonguldak 30 28 24 29
9 Beşiktaş Beşiktaş 30 33 32 29
10 Göztepe Göztepe 30 30 41 28
11 Adanaspor Adanaspor 30 33 33 27
12 Bursaspor Bursaspor 30 25 33 27
13 Adana Demirspor Adana 30 23 32 27
14 Boluspor Boluspor 30 33 32 26
15 Samsunspor Samsunspor 30 18 37 20
16 MKE Kırıkkalespor Kırıkkales 30 21 64 18
TEMPORADA 1977/1978
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 30 48 24 42
2 Trabzonspor Trabzonspor 30 42 16 41
3 Galatasaray SK Galatasaray 30 38 26 38
4 Adanaspor Adanaspor 30 28 31 35
5 Beşiktaş Beşiktaş 30 33 29 32
6 Altay Altay 30 29 28 30
7 Boluspor Boluspor 30 25 26 30
8 Zonguldak Kömürspor Zonguldak 30 33 35 30
9 Diyarbakirspor Diyarbakirsp 30 29 31 30
10 Bursaspor Bursaspor 30 26 24 28
11 Orduspor 1967 Orduspor 30 30 39 27
12 Eskişehirspor Eskişehirsp 30 24 28 25
13 Adana Demirspor Adana 30 24 36 25
14 Samsunspor Samsunspor 30 25 36 24
15 Ankaragücü Ankaragücü 30 21 31 22
16 Mersin Mersin 30 19 34 21
TEMPORADA 1976/1977
LIGA TURCA
Equipo PJ GF GC Puntos
1 Trabzonspor Trabzonspor 30 41 12 43
2 Fenerbahçe Fenerbahçe 30 31 17 39
3 Altay Altay 30 31 22 35
4 Beşiktaş Beşiktaş 30 35 24 33
5 Galatasaray SK Galatasaray 30 36 26 33
6 Bursaspor Bursaspor 30 34 30 31
7 Mersin Mersin 30 25 26 31
8 Boluspor Boluspor 30 32 34 31
9 Eskişehirspor Eskişehirsp 30 25 26 30
10 Samsunspor Samsunspor 30 19 22 28
11 Orduspor 1967 Orduspor 30 22 27 28
12 Adana Demirspor Adana 30 21 32 26
13 Zonguldak Kömürspor Zonguldak 30 21 35 26
14 Adanaspor Adanaspor 30 30 40 25
15 Göztepe Göztepe 30 21 31 25
16 Giresunspor Giresunspor 30 18 38 16
TEMPORADA 1975/1976
LIGA TURCA
Equipo PJ GF GC Puntos
1 Trabzonspor Trabzonspor 30 36 14 43
2 Fenerbahçe Fenerbahçe 30 40 18 40
3 Galatasaray SK Galatasaray 30 36 23 37
4 Adanaspor Adanaspor 30 36 27 36
5 Altay Altay 30 31 32 30
6 Giresunspor Giresunspor 30 27 27 28
7 Boluspor Boluspor 30 34 38 28
8 Adana Demirspor Adana 30 28 35 28
9 Eskişehirspor Eskişehirsp 30 29 29 27
10 Bursaspor Bursaspor 30 30 33 27
11 Beşiktaş Beşiktaş 30 25 32 27
12 Orduspor 1967 Orduspor 30 20 27 27
13 Zonguldak Kömürspor Zonguldak 30 25 25 26
14 Göztepe Göztepe 30 31 32 26
15 Ankaragücü Ankaragücü 30 33 48 25
16 Balikesirspor Balikesirspo 30 18 39 25
TEMPORADA 1974/1975
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 30 43 18 43
2 Galatasaray SK Galatasaray 30 36 24 38
3 Eskişehirspor Eskişehirsp 30 27 19 35
4 Adanaspor Adanaspor 30 38 25 33
5 Beşiktaş Beşiktaş 30 29 24 33
6 Ankaragücü Ankaragücü 30 26 23 32
7 Altay Altay 30 27 28 31
8 Adana Demirspor Adana 30 29 27 30
9 Trabzonspor Trabzonspor 30 19 17 30
10 Boluspor Boluspor 30 29 35 29
11 Zonguldak Kömürspor Zonguldak 30 27 34 27
12 Giresunspor Giresunspor 30 30 35 25
13 Bursaspor Bursaspor 30 20 27 25
14 Göztepe Göztepe 30 23 37 25
15 Samsunspor Samsunspor 30 24 31 24
16 Kayserispor Kayserispor 30 15 38 20
TEMPORADA 1973/1974
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 30 39 15 43
2 Beşiktaş Beşiktaş 30 34 19 40
3 Boluspor Boluspor 30 33 21 39
4 Eskişehirspor Eskişehirsp 30 34 24 36
5 Galatasaray SK Galatasaray 30 29 16 35
6 Altay Altay 30 25 22 31
7 Adanaspor Adanaspor 30 20 26 29
8 Samsunspor Samsunspor 30 24 30 28
9 Bursaspor Bursaspor 30 19 25 28
10 Adana Demirspor Adana 30 19 21 27
11 Kayserispor Kayserispor 30 18 24 27
12 Giresunspor Giresunspor 30 28 32 26
13 Göztepe Göztepe 30 24 28 26
14 Ankaragücü Ankaragücü 30 28 36 26
15 Mersin Mersin 30 15 27 22
16 Vefa SK Vefa SK 30 16 39 17
TEMPORADA 1972/1973
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 30 47 12 47
2 Fenerbahçe Fenerbahçe 30 42 17 42
3 Eskişehirspor Eskişehirsp 30 31 19 36
4 Ankaragücü Ankaragücü 30 24 21 34
5 Boluspor Boluspor 30 37 30 33
6 Beşiktaş Beşiktaş 30 14 18 31
7 Altay Altay 30 32 23 30
8 Göztepe Göztepe 30 33 31 30
9 Giresunspor Giresunspor 30 27 34 29
10 Bursaspor Bursaspor 30 27 29 28
11 Mersin Mersin 30 26 31 27
12 Samsunspor Samsunspor 30 21 40 26
13 Adanaspor Adanaspor 30 24 34 23
14 Vefa SK Vefa SK 30 22 35 22
15 Etimesgut Etimesgut 30 20 38 22
16 Türk Telekom Türk 30 22 37 20
TEMPORADA 1971/1972
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 30 34 14 42
2 Eskişehirspor Eskişehirsp 30 63 34 39
3 Fenerbahçe Fenerbahçe 30 37 21 39
4 Beşiktaş Beşiktaş 30 28 23 34
5 Ankaragücü Ankaragücü 30 22 22 33
6 Bursaspor Bursaspor 30 29 24 32
7 Mersin Mersin 30 35 29 30
8 Adanaspor Adanaspor 30 28 26 30
9 Göztepe Göztepe 30 32 32 29
10 Vefa SK Vefa SK 30 23 27 28
11 Altay Altay 30 29 40 27
12 Giresunspor Giresunspor 30 26 43 27
13 Samsunspor Samsunspor 30 14 21 25
14 Boluspor Boluspor 30 23 33 24
15 Istanbulspor AS Istanbulspor 30 22 35 21
16 Karsiyaka Karsiyaka 30 19 40 20
TEMPORADA 1970/1971
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 30 51 18 42
2 Fenerbahçe Fenerbahçe 30 43 23 41
3 Göztepe Göztepe 30 38 21 37
4 Eskişehirspor Eskişehirsp 30 29 24 34
5 Bursaspor Bursaspor 30 25 25 34
6 Beşiktaş Beşiktaş 30 31 20 33
7 Istanbulspor AS Istanbulspor 30 29 22 33
8 Altay Altay 30 32 22 32
9 Ankaragücü Ankaragücü 30 18 17 31
10 Samsunspor Samsunspor 30 29 33 29
11 Mersin Mersin 30 27 26 28
12 Karsiyaka Karsiyaka 30 15 27 27
13 Boluspor Boluspor 30 17 31 24
14 Vefa SK Vefa SK 30 28 48 22
15 Ankara Demirspor Ankara 30 17 37 18
16 Türk Telekom Türk 30 16 51 15
TEMPORADA 1969/1970
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 30 31 6 44
2 Eskişehirspor Eskişehirsp 30 46 26 37
3 Altay Altay 30 27 17 36
4 Mersin Mersin 30 32 27 36
5 Göztepe Göztepe 30 33 29 35
6 Samsunspor Samsunspor 30 24 28 31
7 Galatasaray SK Galatasaray 30 27 21 30
8 Bursaspor Bursaspor 30 26 20 30
9 Beşiktaş Beşiktaş 30 26 26 30
10 Istanbulspor AS Istanbulspor 30 30 27 29
11 Ankaragücü Ankaragücü 30 19 23 27
12 Ankara Demirspor Ankara 30 25 31 26
13 Vefa SK Vefa SK 30 19 28 25
14 Türk Telekom Türk 30 21 34 25
15 Gençlerbirliği SK Gençlerbirl 30 17 33 22
16 Altinordu Altinordu 30 16 43 17
TEMPORADA 1968/1969
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 30 49 14 46
2 Eskişehirspor Eskişehirsp 30 39 18 43
3 Beşiktaş Beşiktaş 30 30 20 38
4 Fenerbahçe Fenerbahçe 30 34 25 35
5 Bursaspor Bursaspor 30 32 28 32
6 Mersin Mersin 30 35 29 31
7 Göztepe Göztepe 30 30 26 30
8 Istanbulspor AS Istanbulspor 30 27 30 29
9 Türk Telekom Türk 30 28 37 28
10 Gençlerbirliği SK Gençlerbirl 30 28 26 27
11 Altay Altay 30 20 23 26
12 Ankara Demirspor Ankara 30 29 35 26
13 Vefa SK Vefa SK 30 27 37 24
14 Altinordu Altinordu 30 20 40 24
15 Etimesgut Etimesgut 30 24 44 21
16 Izmirspor Izmirspor 30 19 39 20
TEMPORADA 1967/1968
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 32 38 12 49
2 Beşiktaş Beşiktaş 32 42 24 42
3 Galatasaray SK Galatasaray 32 44 36 36
4 Göztepe Göztepe 32 46 34 35
5 Altay Altay 32 37 30 35
6 Bursaspor Bursaspor 32 37 33 33
7 Türk Telekom Türk 32 34 31 33
8 Gençlerbirliği SK Gençlerbirl 32 28 26 32
9 Eskişehirspor Eskişehirsp 32 40 36 31
10 Mersin Mersin 32 42 44 30
11 Ankara Demirspor Ankara 32 29 33 30
12 Vefa SK Vefa SK 32 31 35 29
13 Altinordu Altinordu 32 33 47 29
14 Etimesgut Etimesgut 32 32 41 28
15 Hacettepe SK Hacettepe 32 32 45 28
16 Ankaragücü Ankaragücü 32 30 47 22
17 Feriköy Feriköy 32 27 48 22
TEMPORADA 1966/1967
LIGA TURCA
Equipo PJ GF GC Puntos
1 Beşiktaş Beşiktaş 32 44 15 45
2 Fenerbahçe Fenerbahçe 32 37 20 43
3 Galatasaray SK Galatasaray 32 53 33 41
4 Göztepe Göztepe 32 47 31 38
5 Altay Altay 32 27 27 32
6 Gençlerbirliği SK Gençlerbirl 32 35 28 31
7 Türk Telekom Türk 32 34 30 31
8 Eskişehirspor Eskişehirsp 32 29 44 31
9 Ankaragücü Ankaragücü 32 29 36 30
10 Ankara Demirspor Ankara 32 27 35 30
11 Feriköy Feriköy 32 29 39 30
12 Altinordu Altinordu 32 39 42 29
13 Vefa SK Vefa SK 32 31 35 29
14 Hacettepe SK Hacettepe 32 24 33 29
15 Istanbulspor AS Istanbulspor 32 25 28 28
16 Izmirspor Izmirspor 32 21 37 25
17 Karsiyaka Karsiyaka 32 18 36 22
TEMPORADA 1965/1966
LIGA TURCA
Equipo PJ GF GC Puntos
1 Beşiktaş Beşiktaş 30 52 16 48
2 Galatasaray SK Galatasaray 30 53 20 42
3 Gençlerbirliği SK Gençlerbirl 30 32 24 38
4 Fenerbahçe Fenerbahçe 30 32 25 32
5 Göztepe Göztepe 30 33 27 32
6 Altay Altay 30 26 28 28
7 Ankaragücü Ankaragücü 30 52 52 27
8 Feriköy Feriköy 30 28 32 27
9 Türk Telekom Türk 30 30 39 27
10 Vefa SK Vefa SK 30 26 36 27
11 Ankara Demirspor Ankara 30 32 43 27
12 Izmirspor Izmirspor 30 33 46 27
13 Hacettepe SK Hacettepe 30 26 35 25
14 Istanbulspor AS Istanbulspor 30 28 45 25
15 Etimesgut Etimesgut 30 40 45 24
16 Beykozspor Beykozspor 30 22 32 24
TEMPORADA 1964/1965
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 30 52 13 47
2 Beşiktaş Beşiktaş 30 46 17 41
3 Galatasaray SK Galatasaray 30 51 31 39
4 Göztepe Göztepe 30 31 33 31
5 Istanbulspor AS Istanbulspor 30 28 29 30
6 Ankaragücü Ankaragücü 30 30 35 30
7 Türk Telekom Türk 30 37 37 27
8 Hacettepe SK Hacettepe 30 23 28 27
9 Altay Altay 30 21 27 27
10 Feriköy Feriköy 30 18 28 27
11 Ankara Demirspor Ankara 30 34 47 27
12 Beykozspor Beykozspor 30 26 36 26
13 Izmirspor Izmirspor 30 26 36 26
14 Gençlerbirliği SK Gençlerbirl 30 33 47 26
15 Etimesgut Etimesgut 30 32 39 25
16 Altinordu Altinordu 30 28 33 24
TEMPORADA 1963/1964
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 34 55 14 53
2 Beşiktaş Beşiktaş 34 57 19 52
3 Galatasaray SK Galatasaray 34 49 27 42
4 Ankaragücü Ankaragücü 34 52 38 42
5 Göztepe Göztepe 34 39 31 40
6 Istanbulspor AS Istanbulspor 34 42 36 36
7 Altay Altay 34 31 31 33
8 Feriköy Feriköy 34 29 30 33
9 Gençlerbirliği SK Gençlerbirl 34 28 38 33
10 Ankara Demirspor Ankara 34 43 37 31
11 Türk Telekom Türk 34 25 31 31
12 Altinordu Altinordu 34 28 38 30
13 Izmirspor Izmirspor 34 28 35 28
14 Hacettepe SK Hacettepe 34 26 42 28
15 Karsiyaka Karsiyaka 34 32 50 28
16 Beykozspor Beykozspor 34 25 33 27
17 Beyogluspor Beyogluspor 34 26 40 24
18 Kasımpaşa Kasımpaşa 34 16 61 21
TEMPORADA 1962/1963
LIGA TURCA GRUPO 2
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 20 41 8 34
2 Beşiktaş Beşiktaş 20 46 16 32
3 Istanbulspor AS Istanbulspor 20 24 26 21
4 Izmirspor Izmirspor 20 19 21 20
5 Kasımpaşa Kasımpaşa 20 15 24 20
6 Hacettepe SK Hacettepe 20 24 22 18
7 Ankaragücü Ankaragücü 20 24 24 18
8 Altinordu Altinordu 20 17 18 18
9 Türk Telekom Türk 20 16 22 16
10 Vefa SK Vefa SK 20 22 37 13
11 Yeşildirek SK Yeşildirek 20 11 41 10

  USO DE MEMORIA  
7,695,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1897
Total Execution Time  0.1910
  CADENA URL  
/historico/Fenerbahce/1982
  GET DATOS  
$_GET['/historico/Fenerbahce/1982']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0051  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 = 'Fenerbahce' AND l.year = 1982 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.0020  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=10066 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=10066 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=10066 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0048  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 = 49445
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10066 AND type_rel = 2
0.0040  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10066 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  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 (1362,1686,1944,2356,2596) ORDER BY n.cover_points DESC, update_date DESC
0.0036  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 = '10066' AND l.year = 1982 ORDER BY l.year DESC,cat.coefficient DESC
0.0043  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 = '10066' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 49445 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 9883 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0048  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=10066 AND l.year in (1981,1982,1983) 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 (49446,43651,10947,9901) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 9901 AND teamId = 10066
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 10947 AND teamId = 10066
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 49446 AND teamId = 10066
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 43651 AND teamId = 10066
0.0033  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 9883 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '10066' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10066' and rp.type = 4
0.0023  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '10066' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '10066' and rp.type = 4
0.0019  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 events1982 e ON e.player_id = p.id AND e.league_id = 9883 WHERE rp.league_id = 9883 AND rp.teamId = 10066 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.0021  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 events1982 e ON e.player_id = p.id AND e.league_id = 9883 WHERE rp.league_id = 9883 AND rp.teamId = 10066 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events1982 e ON e.player_id = p.id AND e.league_id = 9883 WHERE rp.league_id = 9883 AND rp.teamId = 10066 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 = 10066 AND l.year <= 1982 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 9883 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 `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 = 9901 AND t.round = 30 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 `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 = 9900 AND t.round = 30 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 `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 = 9899 AND t.round = 30 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 = 9898 AND t.round = 30 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 `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 = 9897 AND t.round = 30 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 `tables1976` 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 = 9896 AND t.round = 30 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 `tables1975` 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 = 9895 AND t.round = 30 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 `tables1974` 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 = 9894 AND t.round = 30 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 `tables1973` 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 = 9893 AND t.round = 30 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 `tables1972` 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 = 9892 AND t.round = 30 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 `tables1971` 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 = 9891 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1970` 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 = 9906 AND t.round = 30 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 `tables1969` 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 = 9905 AND t.round = 30 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 `tables1968` 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 = 9910 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 `tables1967` 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 = 9909 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 `tables1966` 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 = 9908 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1965` 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 = 9907 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 `tables1964` 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 = 9913 AND t.round = 36 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 `tables1963` 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 = 9918 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 9883 ORDER BY nameShow LIMIT 100