TEMPORADA 2023/2024
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 30 68 20 81
2 Fenerbahçe Fenerbahçe 30 79 25 79
3 Trabzonspor Trabzonspor 30 51 40 49
4 Beşiktaş Beşiktaş 30 40 36 46
5 Kasımpaşa Kasımpaşa 30 53 55 43
6 İstanbul Başakşehir İstanbul 30 38 35 42
7 Rizespor Rizespor 30 36 47 42
8 Antalyaspor Antalyaspor 30 35 33 41
9 Adana Demirspor Adana 30 46 39 39
10 Alanyaspor Alanyaspor 30 38 42 39
11 Sivasspor Sivasspor 30 36 43 38
12 Samsunspor Samsunspor 30 35 41 36
13 Kayserispor Kayserispor 30 36 43 36
14 Ankaragücü Ankaragücü 30 36 39 33
15 Hatayspor Hatayspor 30 36 40 33
16 Konyaspor Konyaspor 30 31 42 33
17 Gaziantep Gaziantep 30 34 44 31
18 Fatih Karagümrük Fatih 30 34 38 30
19 Pendikspor Pendikspor 30 34 61 29
20 Istanbulspor AS Istanbulspor 30 22 55 13
TEMPORADA 2022/2023
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 36 83 27 88
2 Fenerbahçe Fenerbahçe 36 87 42 80
3 Beşiktaş Beşiktaş 36 78 36 78
4 Adana Demirspor Adana 36 76 45 69
5 İstanbul Başakşehir İstanbul 36 54 37 62
6 Trabzonspor Trabzonspor 36 64 54 57
7 Fatih Karagümrük Fatih 36 75 63 51
8 Konyaspor Konyaspor 36 49 41 51
9 Kayserispor Kayserispor 36 55 61 47
10 Kasımpaşa Kasımpaşa 36 45 61 43
11 Ankaragücü Ankaragücü 36 43 53 42
12 Istanbulspor AS Istanbulspor 36 47 63 41
13 Antalyaspor Antalyaspor 36 46 55 41
14 Sivasspor Sivasspor 36 46 54 41
15 Alanyaspor Alanyaspor 36 54 70 41
16 Giresunspor Giresunspor 36 42 60 40
17 Umraniyespor Umraniyespor 36 47 64 30
18 Gaziantep Gaziantep 36 31 72 25
19 Hatayspor Hatayspor 36 19 83 23
TEMPORADA 2021/2022
LIGA TURCA
Equipo PJ GF GC Puntos
1 Trabzonspor Trabzonspor 38 69 36 81
2 Fenerbahçe Fenerbahçe 38 73 38 73
3 Konyaspor Konyaspor 38 66 45 68
4 İstanbul Başakşehir İstanbul 38 56 36 65
5 Alanyaspor Alanyaspor 38 67 58 64
6 Beşiktaş Beşiktaş 38 56 48 59
7 Antalyaspor Antalyaspor 38 54 47 59
8 Fatih Karagümrük Fatih 38 47 52 57
9 Adana Demirspor Adana 38 60 47 55
10 Sivasspor Sivasspor 38 52 50 54
11 Kasımpaşa Kasımpaşa 38 67 57 53
12 Hatayspor Hatayspor 38 56 60 53
13 Galatasaray SK Galatasaray 38 51 53 52
14 Kayserispor Kayserispor 38 54 61 47
15 Gaziantep Gaziantep 38 48 56 46
16 Giresunspor Giresunspor 38 41 47 45
17 Rizespor Rizespor 38 44 71 36
18 Altay Altay 38 39 57 34
19 Göztepe Göztepe 38 40 77 28
20 Yeni Malatyaspor Yeni 38 27 71 20
TEMPORADA 2020/2021
LIGA TURCA
Equipo PJ GF GC Puntos
1 Beşiktaş Beşiktaş 40 89 44 84
2 Galatasaray SK Galatasaray 40 80 36 84
3 Fenerbahçe Fenerbahçe 40 72 41 82
4 Trabzonspor Trabzonspor 40 50 37 71
5 Sivasspor Sivasspor 40 54 43 65
6 Hatayspor Hatayspor 40 62 53 61
7 Alanyaspor Alanyaspor 40 58 45 60
8 Fatih Karagümrük Fatih 40 64 52 60
9 Gaziantep Gaziantep 40 59 51 58
10 Göztepe Göztepe 40 59 59 51
11 Konyaspor Konyaspor 40 49 48 50
12 İstanbul Başakşehir İstanbul 40 43 55 48
13 Rizespor Rizespor 40 53 69 48
14 Kasımpaşa Kasımpaşa 40 47 57 46
15 Yeni Malatyaspor Yeni 40 49 53 45
16 Antalyaspor Antalyaspor 40 41 55 44
17 Kayserispor Kayserispor 40 35 52 41
18 Erzurumspor Erzurumspor 40 44 68 40
19 Ankaragücü Ankaragücü 40 46 65 38
20 Gençlerbirliği SK Gençlerbirl 40 44 76 38
21 Denizlispor Denizlispor 40 38 77 28
TEMPORADA 2019/2020
LIGA TURCA
Equipo PJ GF GC Puntos
1 İstanbul Başakşehir İstanbul 34 65 34 69
2 Trabzonspor Trabzonspor 34 76 42 65
3 Beşiktaş Beşiktaş 34 59 40 62
4 Sivasspor Sivasspor 34 55 38 60
5 Alanyaspor Alanyaspor 34 61 37 57
6 Galatasaray SK Galatasaray 34 55 37 56
7 Fenerbahçe Fenerbahçe 34 58 46 53
8 Gaziantep Gaziantep 34 49 50 46
9 Antalyaspor Antalyaspor 34 41 52 45
10 Kasımpaşa Kasımpaşa 34 53 58 43
11 Göztepe Göztepe 34 44 49 42
12 Konyaspor Konyaspor 34 36 52 36
13 Gençlerbirliği SK Gençlerbirl 34 39 56 36
14 Denizlispor Denizlispor 34 31 48 35
15 Rizespor Rizespor 34 38 57 35
16 Yeni Malatyaspor Yeni 34 44 51 32
17 Ankaragücü Ankaragücü 34 31 56 32
18 Kayserispor Kayserispor 34 40 72 32
TEMPORADA 2018/2019
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 34 72 36 69
2 İstanbul Başakşehir İstanbul 34 49 22 67
3 Beşiktaş Beşiktaş 34 72 46 65
4 Trabzonspor Trabzonspor 34 64 46 63
5 Yeni Malatyaspor Yeni 34 47 46 47
6 Fenerbahçe Fenerbahçe 34 44 44 46
7 Antalyaspor Antalyaspor 34 39 55 45
8 Konyaspor Konyaspor 34 40 38 44
9 Alanyaspor Alanyaspor 34 37 43 44
10 Rizespor Rizespor 34 48 50 41
11 Sivasspor Sivasspor 34 49 54 41
12 Kayserispor Kayserispor 34 35 50 41
13 Ankaragücü Ankaragücü 34 38 53 40
14 Kasımpaşa Kasımpaşa 34 53 62 39
15 Göztepe Göztepe 34 37 42 38
16 Bursaspor Bursaspor 34 28 37 37
17 Erzurumspor Erzurumspor 34 36 43 35
18 Akhisar Belediyespor Akhisar 34 33 54 27
TEMPORADA 2017/2018
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 34 75 33 75
2 Fenerbahçe Fenerbahçe 34 78 36 72
3 İstanbul Başakşehir İstanbul 34 62 34 72
4 Beşiktaş Beşiktaş 34 69 30 71
5 Trabzonspor Trabzonspor 34 63 51 55
6 Göztepe Göztepe 34 49 50 49
7 Sivasspor Sivasspor 34 45 53 49
8 Kasımpaşa Kasımpaşa 34 57 58 46
9 Kayserispor Kayserispor 34 44 55 44
10 Yeni Malatyaspor Yeni 34 38 45 43
11 Akhisar Belediyespor Akhisar 34 44 53 42
12 Alanyaspor Alanyaspor 34 55 59 40
13 Bursaspor Bursaspor 34 43 48 39
14 Antalyaspor Antalyaspor 34 40 59 38
15 Konyaspor Konyaspor 34 38 42 36
16 Ankaraspor Ankaraspor 34 49 60 33
17 Gençlerbirliği SK Gençlerbirl 34 37 54 33
18 Karabükspor Karabükspor 34 20 86 12
TEMPORADA 2016/2017
LIGA TURCA
Equipo PJ GF GC Puntos
1 Beşiktaş Beşiktaş 34 73 30 77
2 İstanbul Başakşehir İstanbul 34 63 28 73
3 Fenerbahçe Fenerbahçe 34 60 32 64
4 Galatasaray SK Galatasaray 34 65 40 64
5 Antalyaspor Antalyaspor 34 47 40 58
6 Trabzonspor Trabzonspor 34 39 34 51
7 Akhisar Belediyespor Akhisar 34 46 42 48
8 Gençlerbirliği SK Gençlerbirl 34 33 34 46
9 Konyaspor Konyaspor 34 40 45 43
10 Kasımpaşa Kasımpaşa 34 46 50 43
11 Karabükspor Karabükspor 34 38 48 43
12 Alanyaspor Alanyaspor 34 54 65 40
13 Ankaraspor Ankaraspor 34 37 45 38
14 Bursaspor Bursaspor 34 34 58 38
15 Kayserispor Kayserispor 34 47 58 38
16 Rizespor Rizespor 34 44 53 36
17 Gaziantepspor Gaziantepspo 34 30 65 26
18 Adanaspor Adanaspor 34 33 62 25
TEMPORADA 2015/2016
LIGA TURCA
Equipo PJ GF GC Puntos
1 Beşiktaş Beşiktaş 34 75 35 79
2 Fenerbahçe Fenerbahçe 34 60 27 74
3 Konyaspor Konyaspor 34 44 33 66
4 İstanbul Başakşehir İstanbul 34 54 36 59
5 Ankaraspor Ankaraspor 34 52 36 52
6 Galatasaray SK Galatasaray 34 69 49 51
7 Kasımpaşa Kasımpaşa 34 50 40 50
8 Akhisar Belediyespor Akhisar 34 42 41 46
9 Antalyaspor Antalyaspor 34 53 52 45
10 Gençlerbirliği SK Gençlerbirl 34 42 42 45
11 Bursaspor Bursaspor 34 47 55 44
12 Trabzonspor Trabzonspor 34 40 59 40
13 Rizespor Rizespor 34 39 48 37
14 Gaziantepspor Gaziantepspo 34 31 50 36
15 Kayserispor Kayserispor 34 25 41 34
16 Sivasspor Sivasspor 34 34 48 31
17 Eskişehirspor Eskişehirsp 34 39 64 30
18 Mersin Mersin 34 31 71 21
TEMPORADA 2014/2015
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 34 60 35 77
2 Fenerbahçe Fenerbahçe 34 60 29 74
3 Beşiktaş Beşiktaş 34 55 32 69
4 İstanbul Başakşehir İstanbul 34 49 30 59
5 Bursaspor Bursaspor 34 69 44 57
6 Trabzonspor Trabzonspor 34 58 48 57
7 Mersin Mersin 34 54 48 47
8 Konyaspor Konyaspor 34 30 39 46
9 Gençlerbirliği SK Gençlerbirl 34 46 44 40
10 Gaziantepspor Gaziantepspo 34 31 48 40
11 Eskişehirspor Eskişehirsp 34 45 52 39
12 Akhisar Belediyespor Akhisar 34 41 51 38
13 Kasımpaşa Kasımpaşa 34 56 73 37
14 Sivasspor Sivasspor 34 43 50 36
15 Rizespor Rizespor 34 41 55 36
16 Karabükspor Karabükspor 34 44 64 28
17 Kayseri Kayseri 34 43 62 27
18 Balikesirspor Balikesirspo 34 48 69 27
TEMPORADA 2013/2014
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 34 72 33 74
2 Galatasaray SK Galatasaray 34 59 32 65
3 Beşiktaş Beşiktaş 34 53 33 62
4 Trabzonspor Trabzonspor 34 53 39 53
5 Sivasspor Sivasspor 34 60 55 53
6 Kasımpaşa Kasımpaşa 34 56 39 51
7 Karabükspor Karabükspor 34 33 34 50
8 Bursaspor Bursaspor 34 40 46 46
9 Gençlerbirliği SK Gençlerbirl 34 39 43 45
10 Akhisar Belediyespor Akhisar 34 44 55 44
11 Konyaspor Konyaspor 34 48 45 42
12 Eskişehirspor Eskişehirsp 34 33 35 42
13 Rizespor Rizespor 34 43 43 42
14 Kayseri Kayseri 34 34 50 37
15 Gaziantepspor Gaziantepspo 34 38 58 37
16 Elazigspor Elazigspor 34 38 62 34
17 Antalyaspor Antalyaspor 34 34 47 31
18 Kayserispor Kayserispor 34 30 58 29
TEMPORADA 2012/2013
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 34 66 35 71
2 Fenerbahçe Fenerbahçe 34 56 39 61
3 Beşiktaş Beşiktaş 34 63 49 58
4 Bursaspor Bursaspor 34 52 41 55
5 Kayserispor Kayserispor 34 48 45 52
6 Kasımpaşa Kasımpaşa 34 48 37 50
7 Antalyaspor Antalyaspor 34 50 52 47
8 Eskişehirspor Eskişehirsp 34 48 40 46
9 Trabzonspor Trabzonspor 34 39 40 46
10 Gaziantepspor Gaziantepspo 34 42 49 46
11 Gençlerbirliği SK Gençlerbirl 34 46 47 45
12 Sivasspor Sivasspor 34 42 46 44
13 Elazigspor Elazigspor 34 31 46 43
14 Akhisar Belediyespor Akhisar 34 36 44 42
15 Karabükspor Karabükspor 34 41 53 40
16 İstanbul Başakşehir İstanbul 34 43 50 36
17 Orduspor 1967 Orduspor 34 35 51 29
18 Mersin Mersin 34 31 53 22
TEMPORADA 2011/2012
LIGA TURCA GRUPO 2
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 6 9 6 51
2 Fenerbahçe Fenerbahçe 6 9 4 47
3 Beşiktaş Beşiktaş 6 5 8 33
4 Trabzonspor Trabzonspor 6 5 10 33
TEMPORADA 2010/2011
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 34 84 34 82
2 Trabzonspor Trabzonspor 34 69 23 82
3 Bursaspor Bursaspor 34 48 29 61
4 Gaziantepspor Gaziantepspo 34 44 31 59
5 Beşiktaş Beşiktaş 34 53 36 54
6 Kayserispor Kayserispor 34 46 44 51
7 Eskişehirspor Eskişehirsp 34 41 40 47
8 Galatasaray SK Galatasaray 34 41 46 46
9 Karabükspor Karabükspor 34 46 53 44
10 Manisaspor Manisaspor 34 49 52 43
11 Antalyaspor Antalyaspor 34 41 48 42
12 İstanbul Başakşehir İstanbul 34 40 45 42
13 Ankaragücü Ankaragücü 34 52 62 41
14 Gençlerbirliği SK Gençlerbirl 34 43 51 40
15 Sivasspor Sivasspor 34 43 57 35
16 Bucaspor Bucaspor 34 37 65 26
17 Konyaspor Konyaspor 34 28 49 24
18 Kasımpaşa Kasımpaşa 34 31 71 23
TEMPORADA 2009/2010
LIGA TURCA
Equipo PJ GF GC Puntos
1 Bursaspor Bursaspor 34 65 26 75
2 Fenerbahçe Fenerbahçe 34 61 28 74
3 Galatasaray SK Galatasaray 34 60 35 64
4 Beşiktaş Beşiktaş 34 47 25 64
5 Trabzonspor Trabzonspor 34 53 32 57
6 İstanbul Başakşehir İstanbul 34 47 44 56
7 Eskişehirspor Eskişehirsp 34 44 34 55
8 Kayserispor Kayserispor 34 45 37 51
9 Antalyaspor Antalyaspor 34 49 38 49
10 Gençlerbirliği SK Gençlerbirl 34 38 35 47
11 Kasımpaşa Kasımpaşa 34 50 53 41
12 Ankaragücü Ankaragücü 34 39 40 41
13 Gaziantepspor Gaziantepspo 34 38 39 40
14 Manisaspor Manisaspor 34 27 34 37
15 Sivasspor Sivasspor 34 42 59 34
16 Diyarbakirspor Diyarbakirsp 34 28 54 27
17 Denizlispor Denizlispor 34 30 49 26
18 Ankaraspor Ankaraspor 34 0 101 0
TEMPORADA 2008/2009
LIGA TURCA
Equipo PJ GF GC Puntos
1 Beşiktaş Beşiktaş 34 60 30 71
2 Sivasspor Sivasspor 34 54 28 66
3 Trabzonspor Trabzonspor 34 54 34 65
4 Fenerbahçe Fenerbahçe 34 60 36 61
5 Galatasaray SK Galatasaray 34 57 39 61
6 Bursaspor Bursaspor 34 47 36 58
7 Kayserispor Kayserispor 34 38 26 50
8 Gaziantepspor Gaziantepspo 34 46 48 47
9 İstanbul Başakşehir İstanbul 34 37 46 42
10 Ankaraspor Ankaraspor 34 36 42 41
11 Eskişehirspor Eskişehirsp 34 45 49 40
12 Antalyaspor Antalyaspor 34 34 42 40
13 Ankaragücü Ankaragücü 34 36 47 39
14 Gençlerbirliği SK Gençlerbirl 34 38 50 38
15 Denizlispor Denizlispor 34 39 52 38
16 Konyaspor Konyaspor 34 35 46 38
17 Kocaelispor Kocaelispor 34 47 73 29
18 Hacettepe SK Hacettepe 34 24 63 22
TEMPORADA 2007/2008
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 34 64 23 79
2 Fenerbahçe Fenerbahçe 34 72 37 73
3 Beşiktaş Beşiktaş 34 58 32 73
4 Sivasspor Sivasspor 34 57 29 73
5 Kayserispor Kayserispor 34 50 31 55
6 Trabzonspor Trabzonspor 34 44 39 49
7 Denizlispor Denizlispor 34 48 48 45
8 Ankaragücü Ankaragücü 34 36 44 43
9 Gaziantepspor Gaziantepspo 34 36 45 43
10 Ankaraspor Ankaraspor 34 35 38 41
11 Hacettepe SK Hacettepe 34 30 36 40
12 İstanbul Başakşehir İstanbul 34 44 47 38
13 Bursaspor Bursaspor 34 31 40 38
14 Konyaspor Konyaspor 34 37 64 36
15 Gençlerbirliği SK Gençlerbirl 34 44 51 35
16 Manisaspor Manisaspor 34 42 62 29
17 Rizespor Rizespor 34 32 64 29
18 Kasımpaşa Kasımpaşa 34 26 56 29
TEMPORADA 2006/2007
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 34 65 31 70
2 Beşiktaş Beşiktaş 34 43 32 61
3 Galatasaray SK Galatasaray 34 58 37 56
4 Trabzonspor Trabzonspor 34 54 44 52
5 Kayserispor Kayserispor 34 54 43 51
6 Gençlerbirliği SK Gençlerbirl 34 43 42 48
7 Sivasspor Sivasspor 34 41 44 48
8 Ankaraspor Ankaraspor 34 43 38 47
9 Konyaspor Konyaspor 34 42 44 45
10 Bursaspor Bursaspor 34 36 42 45
11 Gaziantepspor Gaziantepspo 34 31 39 43
12 Manisaspor Manisaspor 34 41 45 42
13 Ankaragücü Ankaragücü 34 32 39 42
14 Denizlispor Denizlispor 34 33 40 41
15 Rizespor Rizespor 34 34 40 40
16 Antalyaspor Antalyaspor 34 32 36 39
17 Kayseri Kayseri 34 29 49 37
18 Sakaryaspor Sakaryaspor 34 25 51 22
TEMPORADA 2005/2006
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 34 82 34 83
2 Fenerbahçe Fenerbahçe 34 90 34 81
3 Beşiktaş Beşiktaş 34 52 39 54
4 Trabzonspor Trabzonspor 34 51 42 52
5 Kayserispor Kayserispor 34 59 42 51
6 Gençlerbirliği SK Gençlerbirl 34 47 39 51
7 Konyaspor Konyaspor 34 37 43 46
8 Sivasspor Sivasspor 34 34 44 43
9 Rizespor Rizespor 34 35 44 41
10 Kayseri Kayseri 34 36 47 40
11 Gaziantepspor Gaziantepspo 34 34 50 40
12 Manisaspor Manisaspor 34 52 61 40
13 Ankaragücü Ankaragücü 34 43 48 39
14 Ankaraspor Ankaraspor 34 44 51 39
15 Denizlispor Denizlispor 34 41 50 37
16 Malatyaspor Malatyaspor 34 34 50 36
17 Samsunspor Samsunspor 34 45 62 36
18 Diyarbakirspor Diyarbakirsp 34 31 67 29
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
8,691,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2516
Total Execution Time  0.2529
  CADENA URL  
/historico/Galatasaray-Sk
  GET DATOS  
$_GET['/historico/Galatasaray-Sk']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.0046  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 = 2024 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.0022  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.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.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.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.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.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.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.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.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.0028  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 = 72225
0.0027  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 = 74406
0.0027  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 = 74094
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1192 AND type_rel = 2
0.0047  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.0023  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 (1308316,481,633,688,1231) ORDER BY n.cover_points DESC, update_date DESC
0.0067  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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0056  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.0019  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 = 73856 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 72225 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  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 = 74406 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0074  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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (74791,74406,74094,73856,72225,72097,71432) 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.0055  SELECT count(id) as num_players from rel_players WHERE league_id = 72225 AND teamId = 1192
0.0038  SELECT count(id) as num_players from rel_players WHERE league_id = 73856 AND teamId = 1192
0.0049  SELECT count(id) as num_players from rel_players WHERE league_id = 74791 AND teamId = 1192
0.0042  SELECT count(id) as num_players from rel_players WHERE league_id = 72097 AND teamId = 1192
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 74406 AND teamId = 1192
0.0041  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 1192
0.0172  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1192
0.0067  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 events2024 e ON e.player_id = p.id AND e.league_id = 74791 WHERE rp.league_id = 74791 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.0061  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 events2024 e ON e.player_id = p.id AND e.league_id = 74791 WHERE rp.league_id = 74791 AND rp.teamId = 1192 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 events2024 e ON e.player_id = p.id AND e.league_id = 74791 WHERE rp.league_id = 74791 AND rp.teamId = 1192 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0089  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 <= 2024 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 `tables2024` 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 = 72225 AND t.round = 31 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 67815 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `tables2022` 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 = 62817 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 58565 AND t.round = 42 ORDER BY team.conference ASC,t.position 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 `tables2019` 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 = 43610 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 `tables2018` 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 = 38677 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 `tables2017` 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 = 30997 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 `tables2016` 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 = 15571 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 `tables2015` 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 = 3824 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 `tables2014` 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 = 2490 AND t.round = 34 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 `tables2013` 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 = 2044 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 `tables2012` 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 = 1551 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 `tables2012` 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 = 10896 AND t.round = 6 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 `tables2011` 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 = 1140 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 `tables2010` 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 = 818 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 `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 248 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 `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 411 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 `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 412 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 `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 = 413 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC