4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1985/1986
LIGA TURCA
Equipo PJ GF GC Puntos
1 Beşiktaş Beşiktaş 36 65 21 56
2 Galatasaray SK Galatasaray 36 57 20 56
3 Samsunspor Samsunspor 36 57 25 48
4 Sariyer Sariyer 36 36 23 43
5 Fenerbahçe Fenerbahçe 36 40 32 42
6 Ankaragücü Ankaragücü 36 47 44 41
7 Trabzonspor Trabzonspor 36 37 27 37
8 Altay Altay 36 41 45 34
9 Gençlerbirliği SK Gençlerbirl 36 40 53 34
10 Eskişehirspor Eskişehirsp 36 58 59 33
11 Zonguldak Kömürspor Zonguldak 36 35 41 33
12 Denizlispor Denizlispor 36 40 39 32
13 Malatyaspor Malatyaspor 36 45 50 32
14 Kocaelispor Kocaelispor 36 37 47 32
15 Rizespor Rizespor 36 28 40 32
16 Bursaspor Bursaspor 36 36 40 31
17 Sakaryaspor Sakaryaspor 36 52 70 27
18 Orduspor 1967 Orduspor 36 30 65 22
19 Kayserispor Kayserispor 36 27 67 19
TEMPORADA 1984/1985
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 34 65 25 50
2 Beşiktaş Beşiktaş 34 49 19 50
3 Trabzonspor Trabzonspor 34 38 26 42
4 Ankaragücü Ankaragücü 34 33 27 38
5 Galatasaray SK Galatasaray 34 34 28 36
6 Sakaryaspor Sakaryaspor 34 44 39 36
7 Kocaelispor Kocaelispor 34 30 31 34
8 Sariyer Sariyer 34 47 45 33
9 Orduspor 1967 Orduspor 34 35 36 33
10 Eskişehirspor Eskişehirsp 34 39 48 32
11 Gençlerbirliği SK Gençlerbirl 34 41 45 31
12 Zonguldak Kömürspor Zonguldak 34 31 35 31
13 Bursaspor Bursaspor 34 39 47 31
14 Malatyaspor Malatyaspor 34 35 46 31
15 Altay Altay 34 34 39 30
16 Denizlispor Denizlispor 34 39 48 29
17 Antalyaspor Antalyaspor 34 33 49 28
18 Boluspor Boluspor 34 20 53 17
TEMPORADA 1983/1984
LIGA TURCA
Equipo PJ GF GC Puntos
1 Trabzonspor Trabzonspor 34 43 14 50
2 Fenerbahçe Fenerbahçe 34 46 24 45
3 Galatasaray SK Galatasaray 34 54 29 44
4 Beşiktaş Beşiktaş 34 40 21 44
5 Ankaragücü Ankaragücü 34 27 22 34
6 Sakaryaspor Sakaryaspor 34 33 34 34
7 Denizlispor Denizlispor 34 36 42 34
8 Kocaelispor Kocaelispor 34 35 32 32
9 Zonguldak Kömürspor Zonguldak 34 36 46 32
10 Bursaspor Bursaspor 34 29 33 31
11 Gençlerbirliği SK Gençlerbirl 34 28 34 31
12 Sariyer Sariyer 34 30 43 31
13 Orduspor 1967 Orduspor 34 27 44 30
14 Boluspor Boluspor 34 32 33 29
15 Antalyaspor Antalyaspor 34 34 38 29
16 Adana Demirspor Adana 34 37 54 29
17 Adanaspor Adanaspor 34 32 41 27
18 Fatih Karagümrük Fatih 34 34 49 26
TEMPORADA 1982/1983
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 34 43 20 49
2 Trabzonspor Trabzonspor 34 40 19 47
3 Galatasaray SK Galatasaray 34 50 33 44
4 Boluspor Boluspor 34 39 23 41
5 Beşiktaş Beşiktaş 34 49 30 39
6 Ankaragücü Ankaragücü 34 38 37 34
7 Adana Demirspor Adana 34 39 36 33
8 Bursaspor Bursaspor 34 36 34 33
9 Kocaelispor Kocaelispor 34 34 37 33
10 Adanaspor Adanaspor 34 32 35 32
11 Sakaryaspor Sakaryaspor 34 37 43 32
12 Sariyer Sariyer 34 35 43 31
13 Zonguldak Kömürspor Zonguldak 34 31 35 30
14 Antalyaspor Antalyaspor 34 27 40 29
15 Mersin Mersin 34 19 32 29
16 Samsunspor Samsunspor 34 37 49 28
17 Gaziantepspor Gaziantepspo 34 23 35 27
18 Altay Altay 34 27 55 21
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

  USO DE MEMORIA  
8,180,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3470
Total Execution Time  0.3489
  CADENA URL  
/historico/Galatasaray-Sk/1986
  GET DATOS  
$_GET['/historico/Galatasaray-Sk/1986']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0055  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 = 'Galatasaray-Sk' AND l.year = 1986 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=1192 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0034  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=1192 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=1192 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0066  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=1192 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 11043
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1192 AND type_rel = 2
0.0083  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1192 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0038  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 (481,633,688,1231,1512) ORDER BY n.cover_points DESC, update_date DESC
0.0079  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 = '1192' ORDER BY l.year DESC,cat.coefficient DESC
0.0043  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 = '1192' AND l.year = 1986 ORDER BY l.year DESC,cat.coefficient DESC
0.0087  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 = '1192' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0080  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 = 11043 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035  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=1192 AND l.year in (1985,1986,1987) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (49424,43649,11043,10953,9886) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 9886 AND teamId = 1192
0.0038  SELECT count(id) as num_players from rel_players WHERE league_id = 10953 AND teamId = 1192
0.0045  SELECT count(id) as num_players from rel_players WHERE league_id = 49424 AND teamId = 1192
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 43649 AND teamId = 1192
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 11043 AND teamId = 1192
0.0023  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 = '1192' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1192' and rp.type = 4
0.0024  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 = '1192' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0047  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1192' and rp.type = 4
0.0051  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 events1986 e ON e.player_id = p.id AND e.league_id = 9877 WHERE rp.league_id = 9877 AND rp.teamId = 1192 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.0048  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 events1986 e ON e.player_id = p.id AND e.league_id = 9877 WHERE rp.league_id = 9877 AND rp.teamId = 1192 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 events1986 e ON e.player_id = p.id AND e.league_id = 9877 WHERE rp.league_id = 9877 AND rp.teamId = 1192 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0056  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 = 1192 AND l.year <= 1986 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 `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 = 9877 AND t.round = 38 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 `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 = 9886 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 `tables1984` 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 = 9885 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 9884 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 `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.0031  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.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 `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.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 = 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.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 `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.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 `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.0043  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.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 `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.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 `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.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 `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.0062  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.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 `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.0033  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.0096  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