4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del İstanbul Başakşehir

İstanbul Başakşehir

Entrenador: Çagdas Atan

Temporada 2023/2024
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
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 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
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 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
1. LIG
Equipo PJ GF GC Puntos
1 İstanbul Başakşehir İstanbul 36 76 38 78
2 Balikesirspor Balikesirspo 36 56 33 73
3 Orduspor 1967 Orduspor 36 57 30 71
4 Ankaraspor Ankaraspor 36 61 35 66
5 Samsunspor Samsunspor 36 61 36 65
6 Mersin Mersin 36 56 43 60
7 Manisaspor Manisaspor 36 55 47 54
8 Karsiyaka Karsiyaka 36 51 49 49
9 Bucaspor Bucaspor 36 47 59 46
10 Denizlispor Denizlispor 36 42 56 46
11 Sanliurfaspor Sanliurfaspo 36 46 49 45
12 Adanaspor Adanaspor 36 51 55 43
13 Adana Demirspor Adana 36 58 63 43
14 Gaziantep Gaziantep 36 30 47 41
15 Boluspor Boluspor 36 34 47 40
16 Fethiyespor Fethiyespor 36 47 59 38
17 1461 Trabzon 1461 Trabzon 36 49 58 35
18 Tavsanlı Linyitspor Tavsanlı 36 39 67 34
19 Kahramanmarasspor Kahramanmara 36 31 76 14
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 1
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 34 69 24 77
2 Fenerbahçe Fenerbahçe 34 61 34 68
3 Trabzonspor Trabzonspor 34 60 39 56
4 Beşiktaş Beşiktaş 34 50 39 55
5 Eskişehirspor Eskişehirsp 34 42 41 50
6 İstanbul Başakşehir İstanbul 34 48 49 50
7 Sivasspor Sivasspor 34 57 54 50
8 Bursaspor Bursaspor 34 44 35 49
9 Gençlerbirliği SK Gençlerbirl 34 49 48 49
10 Gaziantepspor Gaziantepspo 34 39 33 48
11 Kayserispor Kayserispor 34 42 39 44
12 Karabükspor Karabükspor 34 44 56 44
13 Mersin Mersin 34 34 45 42
14 Orduspor 1967 Orduspor 34 28 34 42
15 Antalyaspor Antalyaspor 34 32 42 39
16 Samsunspor Samsunspor 34 36 47 36
17 Manisaspor Manisaspor 34 31 52 32
18 Ankaragücü Ankaragücü 34 22 77 11
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 50 29 61
4 Gaziantepspor Gaziantepspo 34 44 33 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 61 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 102 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
1. LIG
Equipo PJ GF GC Puntos
1 Hacettepe SK Hacettepe 34 48 29 66
2 İstanbul Başakşehir İstanbul 34 56 27 65
3 Malatyaspor Malatyaspor 34 66 41 61
4 Kasımpaşa Kasımpaşa 34 53 39 54
5 Diyarbakirspor Diyarbakirsp 34 37 32 51
6 Altay Altay 34 51 51 51
7 Elazigspor Elazigspor 34 52 48 50
8 Orduspor 1967 Orduspor 34 50 43 49
9 Gaziantep Gaziantep 34 47 48 44
10 Istanbulspor AS Istanbulspor 34 39 46 43
11 Samsunspor Samsunspor 34 31 38 43
12 Kocaelispor Kocaelispor 34 42 45 42
13 Karsiyaka Karsiyaka 34 35 39 40
14 Eskişehirspor Eskişehirsp 34 33 39 40
15 Mardinspor Mardinspor 34 30 44 38
16 Türk Telekom Türk 34 43 54 35
17 Akçaabat Akçaabat 34 40 66 31
18 Usakspor Usakspor 34 33 57 29
TEMPORADA 2005/2006
1. LIG
Equipo PJ GF GC Puntos
1 Bursaspor Bursaspor 34 54 26 71
2 Antalyaspor Antalyaspor 34 67 34 66
3 Altay Altay 34 54 39 64
4 Sakaryaspor Sakaryaspor 34 54 36 60
5 Istanbulspor AS Istanbulspor 34 58 35 54
6 Orduspor 1967 Orduspor 34 49 41 54
7 İstanbul Başakşehir İstanbul 34 43 31 52
8 Kocaelispor Kocaelispor 34 41 41 45
9 Türk Telekom Türk 34 40 40 45
10 Elazigspor Elazigspor 34 40 45 45
11 Mardinspor Mardinspor 34 38 41 43
12 Usakspor Usakspor 34 40 51 43
13 Karsiyaka Karsiyaka 34 47 49 41
14 Gaziantep Gaziantep 34 47 50 41
15 Akçaabat Sebatspor Akçaabat 34 37 54 34
16 Mersin Mersin 34 30 54 29
17 Yozgatspor Yozgatspor 34 29 55 25
18 Canakkale Dardanelspor Canakkale 34 23 69 20

  USO DE MEMORIA  
8,198,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1302
Total Execution Time  0.1323
  CADENA URL  
/historico/Istanbul-Bb
  GET DATOS  
$_GET['/historico/Istanbul-Bb']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1394 AND type_rel = 2
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1394 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0026  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 (6725,65281,86062,113745,127880) ORDER BY n.cover_points DESC, update_date DESC
0.0042  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 = '1394' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  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 = 74094 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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 = 1394 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 34 ORDER BY team.conference ASC,t.position 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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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 = 2802 AND t.round = 38 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 `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.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 `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 = 10897 AND t.round = 6 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 = 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 `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.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 `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.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 `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.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 `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 = 9950 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 `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 = 13094 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC