4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 34 80 21 93
2 Fenerbahçe Fenerbahçe 33 87 30 86
3 Trabzonspor Trabzonspor 33 56 43 55
4 Beşiktaş Beşiktaş 33 44 38 51
5 İstanbul Başakşehir İstanbul 33 44 38 49
6 Rizespor Rizespor 33 43 49 48
7 Kasımpaşa Kasımpaşa 33 55 59 46
8 Antalyaspor Antalyaspor 33 38 38 45
9 Alanyaspor Alanyaspor 33 43 46 45
10 Sivasspor Sivasspor 33 40 45 45
11 Adana Demirspor Adana 34 49 47 41
12 Samsunspor Samsunspor 33 37 43 39
13 Ankaragücü Ankaragücü 33 40 43 37
14 Kayserispor Kayserispor 33 37 47 37
15 Konyaspor Konyaspor 33 34 47 36
16 Gaziantep Gaziantep 33 37 50 34
17 Hatayspor Hatayspor 33 37 46 33
18 Fatih Karagümrük Fatih 33 37 42 33
19 Pendikspor Pendikspor 33 37 68 30
20 Istanbulspor AS Istanbulspor 33 26 61 16
TEMPORADA 2022/2023
1. LIG
Equipo PJ GF GC Puntos
1 Samsunspor Samsunspor 36 70 26 78
2 Rizespor Rizespor 36 64 35 68
3 Pendikspor Pendikspor 36 65 36 67
4 Bodrumspor Bodrumspor 36 55 34 62
5 Sakaryaspor Sakaryaspor 36 59 47 62
6 Eyupspor Eyupspor 36 40 30 62
7 Göztepe Göztepe 35 45 28 60
8 Manisa FK Manisa FK 36 53 47 56
9 Keciorengucu Keciorengucu 36 59 47 56
10 Bandirmaspor Bandirmaspor 36 55 58 55
11 Boluspor Boluspor 36 44 46 52
12 Altay Altay 35 45 45 40
13 Erzurumspor Erzurumspor 36 43 48 39
14 Tuzlaspor Tuzlaspor 36 42 52 38
15 Gençlerbirliği SK Gençlerbirl 36 46 55 38
16 Altinordu Altinordu 36 41 57 35
17 Adanaspor Adanaspor 36 32 76 25
18 Denizlispor Denizlispor 36 35 67 23
19 Yeni Malatyaspor Yeni 36 22 81 16
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 Kayserispor Kayserispor 34 40 72 32
18 Ankaragücü Ankaragücü 34 31 56 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 Kayserispor Kayserispor 34 35 50 41
11 Rizespor Rizespor 34 48 50 41
12 Sivasspor Sivasspor 34 49 54 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
1. LIG
Equipo PJ GF GC Puntos
1 Rizespor Rizespor 34 68 38 69
2 Ankaragücü Ankaragücü 34 55 34 63
3 Boluspor Boluspor 34 53 30 60
4 Umraniyespor Umraniyespor 34 49 35 59
5 Erzurumspor Erzurumspor 34 56 44 53
6 Gaziantep Gaziantep 34 57 38 53
7 Altinordu Altinordu 34 55 45 53
8 Balikesirspor Balikesirspo 34 56 46 52
9 Istanbulspor AS Istanbulspor 34 45 39 50
10 Elazigspor Elazigspor 34 53 44 48
11 Giresunspor Giresunspor 34 50 44 47
12 Adanaspor Adanaspor 34 41 56 43
13 Adana Demirspor Adana 34 44 47 41
14 Eskişehirspor Eskişehirsp 34 63 56 41
15 Denizlispor Denizlispor 34 43 47 38
16 Samsunspor Samsunspor 34 32 46 36
17 Manisaspor Manisaspor 34 31 80 12
18 Gaziantepspor Gaziantepspo 34 18 100 1
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 Trabzonspor Trabzonspor 34 58 48 57
6 Bursaspor Bursaspor 34 69 44 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 Rizespor Rizespor 34 41 55 36
15 Sivasspor Sivasspor 34 43 50 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 74 33 74
2 Galatasaray SK Galatasaray 34 59 32 65
3 Beşiktaş Beşiktaş 34 53 33 62
4 Trabzonspor Trabzonspor 34 53 41 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
1. LIG
Equipo PJ GF GC Puntos
1 Kayseri Kayseri 34 59 37 63
2 Rizespor Rizespor 34 53 35 59
3 1461 Trabzon 1461 Trabzon 34 47 31 53
4 Manisaspor Manisaspor 34 41 28 53
5 Bucaspor Bucaspor 34 48 33 52
6 Konyaspor Konyaspor 34 38 35 52
7 Adana Demirspor Adana 34 54 53 51
8 Adanaspor Adanaspor 34 42 42 49
9 Karsiyaka Karsiyaka 34 37 39 47
10 Boluspor Boluspor 34 41 45 46
11 Denizlispor Denizlispor 34 35 37 43
12 Sanliurfaspor Sanliurfaspo 34 32 38 43
13 Gaziantep Gaziantep 34 37 43 41
14 Samsunspor Samsunspor 34 38 39 39
15 Tavsanlı Linyitspor Tavsanlı 34 34 47 38
16 Kartalspor Kartalspor 34 33 44 37
17 Göztepe Göztepe 34 28 40 37
18 Ankaragücü Ankaragücü 34 31 62 29
TEMPORADA 2011/2012
1. LIG
Equipo PJ GF GC Puntos
1 Akhisar Belediyespor Akhisar 34 46 28 63
2 Elazigspor Elazigspor 34 45 30 61
3 Kasımpaşa Kasımpaşa 34 50 39 59
4 Konyaspor Konyaspor 34 35 25 59
5 Rizespor Rizespor 34 52 44 59
6 Adanaspor Adanaspor 34 46 32 53
7 Boluspor Boluspor 34 40 33 51
8 Kayseri Kayseri 34 43 39 46
9 Denizlispor Denizlispor 34 51 46 45
10 Kartalspor Kartalspor 34 37 32 45
11 Tavsanlı Linyitspor Tavsanlı 34 42 39 43
12 Bucaspor Bucaspor 34 45 53 43
13 Göztepe Göztepe 34 36 43 41
14 Gaziantep Gaziantep 34 36 37 40
15 Karsiyaka Karsiyaka 34 31 37 39
16 Giresunspor Giresunspor 34 39 48 39
17 Sakaryaspor Sakaryaspor 34 31 66 21
18 İstanbul Güngörenspor İstanbul 34 24 58 17
TEMPORADA 2010/2011
1. LIG
Equipo PJ GF GC Puntos
1 Samsunspor Samsunspor 32 45 20 58
2 Mersin Mersin 32 39 29 58
3 Gaziantep Gaziantep 32 43 26 57
4 Orduspor 1967 Orduspor 32 47 29 54
5 Rizespor Rizespor 32 36 24 54
6 Tavsanlı Linyitspor Tavsanlı 32 32 28 51
7 Boluspor Boluspor 32 47 31 49
8 Kayseri Kayseri 32 40 29 48
9 Denizlispor Denizlispor 32 40 31 44
10 Karsiyaka Karsiyaka 32 26 34 41
11 Giresunspor Giresunspor 32 27 32 38
12 Adanaspor Adanaspor 32 41 42 37
13 Kartalspor Kartalspor 32 21 29 34
14 Akhisar Belediyespor Akhisar 32 27 39 33
15 İstanbul Güngörenspor İstanbul 32 19 42 33
16 Altay Altay 32 27 43 31
17 Diyarbakirspor Diyarbakirsp 32 10 59 10
TEMPORADA 2009/2010
1. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Karabükspor Karabükspor 34 74 28 77
2 Bucaspor Bucaspor 34 69 40 64
3 Adanaspor Adanaspor 34 42 30 64
4 Altay Altay 34 48 36 59
5 Karsiyaka Karsiyaka 34 48 35 56
6 Konyaspor Konyaspor 34 42 37 55
7 Giresunspor Giresunspor 34 51 42 51
8 Orduspor 1967 Orduspor 34 33 32 44
9 Boluspor Boluspor 34 48 53 43
10 Samsunspor Samsunspor 34 49 47 42
11 Gaziantep Gaziantep 34 31 38 41
12 Mersin Mersin 34 36 44 41
13 Kayseri Kayseri 34 42 53 41
14 Kartalspor Kartalspor 34 32 43 41
15 Rizespor Rizespor 34 37 53 40
16 Hacettepe SK Hacettepe 34 38 50 38
17 Canakkale Dardanelspor Canakkale 34 37 53 35
18 Kocaelispor Kocaelispor 34 23 66 14
TEMPORADA 2008/2009
1. LIG
Equipo PJ GF GC Puntos
1 Manisaspor Manisaspor 34 64 37 64
2 Diyarbakirspor Diyarbakirsp 34 39 27 62
3 Boluspor Boluspor 34 49 35 56
4 Kasımpaşa Kasımpaşa 34 45 27 55
5 Altay Altay 34 50 39 55
6 Karsiyaka Karsiyaka 34 35 29 51
7 Karabükspor Karabükspor 34 51 48 49
8 Adanaspor Adanaspor 34 38 38 48
9 Rizespor Rizespor 34 39 44 47
10 Orduspor 1967 Orduspor 34 48 44 45
11 Kayseri Kayseri 34 45 43 41
12 Kartalspor Kartalspor 34 33 37 41
13 Gaziantep Gaziantep 34 35 40 40
14 Giresunspor Giresunspor 34 35 48 40
15 Sakaryaspor Sakaryaspor 34 44 50 39
16 Samsunspor Samsunspor 34 35 47 39
17 İstanbul Güngörenspor İstanbul 34 35 56 36
18 Malatyaspor Malatyaspor 34 32 63 29
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
TEMPORADA 2004/2005
LIGA TURCA
Equipo PJ GF GC Puntos
1 Fenerbahçe Fenerbahçe 34 77 24 80
2 Trabzonspor Trabzonspor 34 73 29 77
3 Galatasaray SK Galatasaray 34 64 25 76
4 Beşiktaş Beşiktaş 34 70 39 69
5 Gençlerbirliği SK Gençlerbirl 34 52 41 51
6 Denizlispor Denizlispor 34 46 45 49
7 Ankaraspor Ankaraspor 34 52 48 48
8 Konyaspor Konyaspor 34 62 62 45
9 Gaziantepspor Gaziantepspo 34 49 55 44
10 Rizespor Rizespor 34 36 37 43
11 Malatyaspor Malatyaspor 34 47 53 43
12 Samsunspor Samsunspor 34 40 55 38
13 Ankaragücü Ankaragücü 34 37 61 38
14 Kayserispor Kayserispor 34 42 65 34
15 Diyarbakirspor Diyarbakirsp 34 31 53 34
16 Sakaryaspor Sakaryaspor 34 51 72 32
17 Istanbulspor AS Istanbulspor 34 32 59 27
18 Akçaabat Sebatspor Akçaabat 34 40 78 19

  USO DE MEMORIA  
8,300,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7788
Total Execution Time  0.7800
  CADENA URL  
/historico/Caykur-Rizespor
  GET DATOS  
$_GET['/historico/Caykur-Rizespor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0160  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 = 'Caykur-Rizespor' 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.0146  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=663 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=663 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=663 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=663 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=663 AND type_rel = 2
0.0156  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 663 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0160  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 (104651,124637,152757,572381,631991) ORDER BY n.cover_points DESC, update_date DESC
0.0188  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 = '663' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0197  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 = '663' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0182  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=663 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (74094,72225,71432,68073) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 72225 AND teamId = 663
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 68073 AND teamId = 663
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 663
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 663
0.0147  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 = '663' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '663' and rp.type = 4
0.0147  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 = '663' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0167  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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 663 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.0164  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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 663 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0174  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 = 72225 WHERE rp.league_id = 72225 AND rp.teamId = 663 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0186  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 = 663 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0167  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 = 68073 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.0163  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.0165  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.0155  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 `tables2020` 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 = 49948 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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.0154  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 = 38966 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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.0158  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.0151  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.0151  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 = 9932 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 9934 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 9936 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 9938 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 9940 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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.0153  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.0165  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
0.0167  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 = 414 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC