4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tekirdağspor
TEMPORADA 2020/2021
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Nazilli Belediyespor Nazilli 32 63 29 63
2 Belediye Kütahyaspor Belediye 32 61 35 62
3 Fethiyespor Fethiyespor 32 59 29 58
4 Yomraspor Yomraspor 32 42 33 50
5 İskenderunspor İskenderuns 31 38 40 50
6 Halide Edip Adivar Halide Edip 32 41 36 49
7 Mardin Fosfat Mardin 31 39 31 48
8 Tepecik Belediyespor Tepecik 32 48 37 44
9 Darica Genclerbirligi Darica 32 29 27 43
10 Ceyhanspor Adana Ceyhanspor 32 48 69 41
11 Kahta 02 Spor Kahta Spor 32 40 36 38
12 Karaman FK Karaman FK 32 40 39 37
13 Ağrı Spor Ağrı Spor 30 26 39 36
14 Çengelköyspor Çengelköys 32 35 44 34
15 Tekirdağspor Tekirdağspo 32 41 54 30
16 Tokatspor Tokatspor 32 22 65 25
17 Yozgatspor Yozgatspor 32 28 57 19
TEMPORADA 2017/2018
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Usakspor Usakspor 33 54 26 65
2 Tarsus Idman Yurdu Tarsus Idman 34 60 36 61
3 Sultanbeyli Belediyespor Sultanbeyli 34 52 34 58
4 Kizilcabolukspor Kizilcaboluk 34 54 39 56
5 23 Elazig 23 Elazig 34 43 40 52
6 Tepecik Belediyespor Tepecik 34 39 40 52
7 Corum FK Corum FK 34 51 39 48
8 Cizrespor 2010 Cizrespor 34 39 46 46
9 Karaköprü Bld. Karaköprü 34 46 33 45
10 1461 Trabzon FK 1461 Trabzon 34 48 50 45
11 Karacabey Birlikspor Karacabey 34 28 32 42
12 Payas Payas 34 37 46 41
13 Kocaelispor Kocaelispor 34 35 42 40
14 Çankaya FK Çankaya FK 34 32 40 38
15 Osmaniyespor Kulübü Osmaniyespor 34 37 49 38
16 Aydinspor Aydinspor 34 28 50 32
17 Tekirdağspor Tekirdağspo 34 42 64 30
18 Arsinspor Arsinspor 33 22 41 29
TEMPORADA 2016/2017
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Sancaktepe Belediye Istanbu Sancaktepe 36 52 22 72
2 Altay Altay 36 67 41 64
3 Ankara Demirspor Ankara 36 54 35 64
4 Kocaelispor Kocaelispor 36 55 35 61
5 Corum FK Corum FK 36 46 29 58
6 Golcukspor Golcukspor 36 48 41 56
7 Kizilcabolukspor Kizilcaboluk 36 42 37 52
8 Erzincanspor Erzincanspor 36 42 36 48
9 Vanspor FK Vanspor FK 36 36 42 48
10 Bayburt Bayburt 36 41 41 47
11 Kozanspor Kozanspor 36 41 44 45
12 İskenderunspor İskenderuns 36 43 53 45
13 Cizre Basra Spor Cizre Basra 36 32 43 42
14 Bursa Niluferspor Bursa 36 59 61 40
15 Kartalspor Kartalspor 36 33 47 39
16 Tekirdağspor Tekirdağspo 36 32 47 39
17 Beylerbeyi A.S. Beylerbeyi 36 46 57 38
18 Kütahyaspor Kütahyaspor 36 38 63 35
19 Manavgatspor Manavgatspor 36 27 60 25
TEMPORADA 2015/2016
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Erzurumspor Erzurumspor 36 67 32 74
2 Kizilcabolukspor Kizilcaboluk 36 52 34 68
3 Buca FK Buca FK 36 53 38 63
4 Zonguldak Kömürspor Zonguldak 36 55 42 60
5 1461 Trabzon FK 1461 Trabzon 36 46 34 60
6 İskenderunspor İskenderuns 36 55 37 58
7 Yeşil Bursa Yeşil Bursa 36 47 32 56
8 Tekirdağspor Tekirdağspo 36 44 44 47
9 Kirikhanspor Kirikhanspor 36 35 40 47
10 Maltepespor Maltepespor 36 38 31 46
11 Altay Altay 36 45 45 45
12 Bursa Niluferspor Bursa 36 37 46 45
13 Düzcespor Düzcespor 36 41 47 44
14 Silivrispor Kulübü Silivrispor 36 36 41 43
15 Kozanspor Kozanspor 36 44 52 42
16 Arsinspor Arsinspor 36 38 47 42
17 Gölbaşispor Gölbaşispo 36 36 49 38
18 Turgutluspor Turgutluspor 36 33 48 38
19 Cizre Basra Spor Cizre Basra 36 16 79 16
TEMPORADA 2003/2004
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Pendikspor Pendikspor 31 58 30 64
2 Beykozspor Beykozspor 30 47 21 57
3 Beylerbeyispor Beylerbeyisp 30 51 31 52
4 Kastamonuspor Kastamonuspo 31 38 44 45
5 Bakırköyspor Bakırköysp 30 46 37 44
6 Zeytinburnuspor Zeytinburnus 30 40 33 44
7 Alibeykoyspor Alibeykoyspo 30 39 33 44
8 Yeni Ereğlispor Yeni 30 49 44 44
9 Gebzespor Gebzespor 30 36 36 44
10 Kasımpaşa Kasımpaşa 30 45 37 43
11 Boluspor Boluspor 31 55 47 42
12 Gaziosmanpasaspor Gaziosmanpas 30 35 39 41
13 Yeniköyspor Yeniköyspor 30 36 45 40
14 Bilecikspor Bilecikspor 30 37 41 37
15 Sapancaspor Sapancaspor 30 31 55 34
16 Tekirdağspor Tekirdağspo 30 28 63 19
17 Eskişehir Şekerspor Eskişehir 29 28 63 17
TEMPORADA 2002/2003
3. LIG GRUPO 5
Equipo PJ GF GC Puntos
1 Corluspor Corluspor 26 51 20 55
2 Zeytinburnuspor Zeytinburnus 26 59 29 54
3 Gebzespor Gebzespor 26 36 23 45
4 Bakırköyspor Bakırköysp 26 38 26 45
5 Pendikspor Pendikspor 26 37 26 45
6 Tekirdağspor Tekirdağspo 26 35 33 41
7 Kastamonuspor Kastamonuspo 26 38 30 40
8 Alibeykoyspor Alibeykoyspo 26 44 37 36
9 Beylerbeyispor Beylerbeyisp 26 35 32 36
10 Beykozspor Beykozspor 26 26 31 36
11 Kasımpaşa Kasımpaşa 26 29 26 35
12 Golcukspor Golcukspor 26 30 38 28
13 İzmitspor İzmitspor 26 36 36 27
14 Edirnespor Edirnespor 27 38 48 24
15 Kirklarelispor Kirklarelisp 27 11 108 1
TEMPORADA 1999/2000
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Kirklarelispor Kirklarelisp 31 63 23 70
2 İstanbul Güngörenspor İstanbul 32 63 36 57
3 Alibeykoyspor Alibeykoyspo 32 41 33 53
4 Gebzespor Gebzespor 31 45 39 47
5 Kucukkoyspor Istanbul Kucukkoyspor 31 33 30 46
6 Kartal Belediyespor Kartal 32 48 47 40
7 Bandirmaspor Bandirmaspor 32 33 38 40
8 Tepecikspor Tepecikspor 32 36 50 40
9 Çanspor Çanspor 32 38 35 39
10 Edirnespor Edirnespor 32 45 43 39
11 Tekirdağspor Tekirdağspo 32 34 44 39
12 Beşyüzevlerspor Beşyüzevle 32 31 37 38
13 Lüleburgazspor Lüleburgazs 32 29 37 38
14 Nişantaşıspor Nişantaşı 32 35 47 38
15 Vefa SK Vefa SK 32 42 55 38
16 Altıntepsi Makelspor Altıntepsi 31 42 49 35
17 Cerkezköy Belediyespor Cerkezköy 32 40 55 34
TEMPORADA 1998/1999
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Gaziosmanpasaspor Gaziosmanpas 34 61 24 78
2 Eyupspor Eyupspor 34 75 34 77
3 İstanbul Güngörenspor İstanbul 34 60 33 70
4 Tepecikspor Tepecikspor 34 52 38 52
5 Kirklarelispor Kirklarelisp 34 48 33 47
6 Tekirdağspor Tekirdağspo 34 45 48 45
7 Nişantaşıspor Nişantaşı 34 40 45 44
8 Bandirmaspor Bandirmaspor 34 50 41 43
9 Altıntepsi Makelspor Altıntepsi 34 32 33 43
10 Kucukkoyspor Istanbul Kucukkoyspor 34 43 49 42
11 Çanspor Çanspor 34 38 51 42
12 Vefa SK Vefa SK 34 45 56 41
13 Ayazağaspor Ayazağaspor 34 39 53 40
14 Gönenspor Gönenspor 34 39 54 40
15 Cerkezköy Belediyespor Cerkezköy 34 34 44 38
16 Lüleburgazspor Lüleburgazs 34 33 48 37
17 Küçükçekmecespor Küçükçek 34 31 52 37
18 Bigaspor Bigaspor 34 29 58 26
TEMPORADA 1997/1998
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Corluspor Corluspor 32 57 29 69
2 Çanspor Çanspor 32 65 26 63
3 Gönenspor Gönenspor 31 55 37 63
4 Tepecikspor Tepecikspor 32 50 35 60
5 İstanbul Güngörenspor İstanbul 31 44 32 56
6 Tekirdağspor Tekirdağspo 32 34 29 51
7 Kirklarelispor Kirklarelisp 32 38 38 44
8 Ayvalikgucu Belediyespor Ayvalikgucu 31 42 49 42
9 Eyupspor Eyupspor 32 39 42 41
10 Kucukkoyspor Istanbul Kucukkoyspor 32 32 40 41
11 Cerkezköy Belediyespor Cerkezköy 32 34 43 40
12 Küçükçekmecespor Küçükçek 32 39 45 36
13 Altıntepsi Makelspor Altıntepsi 32 34 40 33
14 Lüleburgazspor Lüleburgazs 31 30 40 32
15 Bigaspor Bigaspor 32 25 37 30
16 Kepezspor Kepezspor 32 35 54 28
17 Keşanspor Keşanspor 32 33 70 20
TEMPORADA 1996/1997
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Kasımpaşa Kasımpaşa 33 58 27 66
2 Kirklarelispor Kirklarelisp 34 64 39 61
3 Keşanspor Keşanspor 34 51 33 58
4 Tekirdağspor Tekirdağspo 34 54 45 57
5 Tepecikspor Tepecikspor 34 58 40 54
6 İstanbul Güngörenspor İstanbul 34 47 30 54
7 Bandirmaspor Bandirmaspor 34 57 41 51
8 Cerkezköy Belediyespor Cerkezköy 34 52 42 51
9 Corluspor Corluspor 33 46 39 51
10 Kepezspor Kepezspor 34 46 33 50
11 Gönenspor Gönenspor 34 48 46 48
12 Çanspor Çanspor 34 47 36 47
13 Kucukkoyspor Istanbul Kucukkoyspor 34 36 38 47
14 Eyupspor Eyupspor 34 43 55 40
15 Lüleburgazspor Lüleburgazs 34 45 58 38
16 Küçükçekmecespor Küçükçek 34 36 56 38
17 Dikilitaşspor Dikilitaşsp 34 30 58 31
18 Edirne DSİ Spor Edirne DSİ 34 0 102 0
TEMPORADA 1995/1996
2. LIG GRUPO 9
Equipo PJ GF GC Puntos
1 Nişantaşıspor Nişantaşı 26 48 16 59
2 Cerkezköy Belediyespor Cerkezköy 26 41 24 51
3 Tepecikspor Tepecikspor 26 42 18 47
4 Küçükçekmecespor Küçükçek 26 32 23 45
5 Tekirdağspor Tekirdağspo 26 40 25 44
6 İstanbul Güngörenspor İstanbul 26 30 22 43
7 Kucukkoyspor Istanbul Kucukkoyspor 26 28 25 43
8 Bandirmaspor Bandirmaspor 26 35 25 39
9 Çanspor Çanspor 26 26 43 28
10 Kirklarelispor Kirklarelisp 26 27 38 26
11 Keşanspor Keşanspor 26 25 40 25
12 Edirne DSİ Spor Edirne DSİ 26 18 37 22
13 Babaeskispor Babaeskispor 26 26 50 22
14 Uzunköprüspor Uzunköprüs 26 24 56 12
TEMPORADA 1994/1995
2. LIG GRUPO 9
Equipo PJ GF GC Puntos
1 Lüleburgazspor Lüleburgazs 26 50 21 55
2 Eyupspor Eyupspor 26 54 25 54
3 İstanbul Güngörenspor İstanbul 26 42 25 50
4 Tekirdağspor Tekirdağspo 26 45 33 43
5 Cerkezköy Belediyespor Cerkezköy 26 18 23 38
6 Babaeskispor Babaeskispor 26 33 36 36
7 Kasımpaşa Kasımpaşa 26 38 35 35
8 Küçükçekmecespor Küçükçek 26 42 33 34
9 Kucukkoyspor Istanbul Kucukkoyspor 25 32 23 34
10 Tepecikspor Tepecikspor 26 43 35 34
11 Uzunköprüspor Uzunköprüs 26 27 41 24
12 Malkara Belediyespor Malkara 26 19 37 24
13 Keşanspor Keşanspor 25 16 34 24
14 Özel İdare İhtisas Özel İdare 26 16 74 8
TEMPORADA 1992/1993
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Corluspor Corluspor 29 47 25 58
2 Fatih Karagümrük Fatih 30 48 29 51
3 Çengelköyspor Çengelköys 30 46 38 50
4 Kucukkoyspor Istanbul Kucukkoyspor 29 42 39 49
5 Tekirdağspor Tekirdağspo 30 37 36 46
6 Edirnespor Edirnespor 30 45 41 44
7 İstanbul Güngörenspor İstanbul 30 30 31 42
8 Babaeskispor Babaeskispor 29 43 43 41
9 Uzunköprüspor Uzunköprüs 30 51 48 40
10 Silivrispor Kulübü Silivrispor 30 34 29 39
11 Lüleburgazspor Lüleburgazs 30 38 41 39
12 Bayrampasaspor Bayrampasasp 30 40 46 37
13 Malkara Belediyespor Malkara 29 36 38 36
14 Nişantaşıspor Nişantaşı 30 25 41 34
15 Yücespor Yücespor 30 34 47 31
16 Kirklarelispor Kirklarelisp 30 33 57 26
TEMPORADA 1991/1992
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Istanbulspor AS Istanbulspor 34 70 17 84
2 Tekirdağspor Tekirdağspo 34 67 20 83
3 Bayrampasaspor Bayrampasasp 34 31 32 54
4 Feriköy Feriköy 34 31 26 51
5 Corluspor Corluspor 34 50 45 50
6 Edirnespor Edirnespor 34 27 38 46
7 Keşanspor Keşanspor 34 40 36 44
8 Galata Galata 34 40 50 44
9 İstanbul Başakşehir İstanbul 34 35 37 43
10 Lüleburgazspor Lüleburgazs 34 48 46 42
11 Uzunköprüspor Uzunköprüs 34 45 42 41
12 Malkara Belediyespor Malkara 34 34 37 39
13 İstanbul Güngörenspor İstanbul 34 38 47 39
14 Silivrispor Kulübü Silivrispor 34 33 47 39
15 Vefa SK Vefa SK 34 34 49 39
16 Babaeskispor Babaeskispor 34 34 47 38
17 Kirklarelispor Kirklarelisp 34 34 52 34
18 İstanbul THY İstanbul 34 29 52 29
TEMPORADA 1990/1991
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Küçükçekmecespor Küçükçek 34 57 24 75
2 Galata Galata 34 42 24 62
3 Lüleburgazspor Lüleburgazs 34 52 28 60
4 Silivrispor Kulübü Silivrispor 34 47 30 60
5 Istanbulspor AS Istanbulspor 34 50 33 59
6 Feriköy Feriköy 34 41 25 55
7 Nişantaşıspor Nişantaşı 34 34 26 48
8 Corluspor Corluspor 34 36 45 47
9 Edirnespor Edirnespor 34 39 35 40
10 Keşanspor Keşanspor 34 36 37 39
11 İstanbul Güngörenspor İstanbul 34 31 37 39
12 Kirklarelispor Kirklarelisp 34 32 43 39
13 Vefa SK Vefa SK 34 32 43 36
14 Tekirdağspor Tekirdağspo 34 27 43 35
15 Beylerbeyispor Beylerbeyisp 34 27 42 34
16 Malkara Belediyespor Malkara 34 36 52 34
17 Uzunköprüspor Uzunköprüs 34 36 63 34
18 Erdekspor Erdekspor 34 27 52 33
TEMPORADA 1989/1990
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Gaziosmanpasaspor Gaziosmanpas 30 58 20 70
2 Galatasaray II Galatasaray 30 57 26 60
3 Vefa SK Vefa SK 30 49 38 52
4 Feriköy Feriköy 30 35 20 49
5 Lüleburgazspor Lüleburgazs 30 49 40 49
6 Silivrispor Kulübü Silivrispor 30 50 36 47
7 Istanbulspor AS Istanbulspor 30 38 38 41
8 Kirklarelispor Kirklarelisp 30 31 33 38
9 Tekirdağspor Tekirdağspo 30 37 47 36
10 Yücespor Yücespor 30 31 38 35
11 Küçükçekmecespor Küçükçek 30 28 37 33
12 Uzunköprüspor Uzunköprüs 30 39 59 33
13 Pendikspor Pendikspor 30 30 40 32
14 Galata Galata 30 22 37 32
15 Corluspor Corluspor 30 37 56 32
16 Babaeskispor Babaeskispor 30 30 56 23
TEMPORADA 1988/1989
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Kasımpaşa Kasımpaşa 32 48 14 71
2 Galatasaray II Galatasaray 32 57 18 70
3 Gaziosmanpasaspor Gaziosmanpas 32 61 30 63
4 Lüleburgazspor Lüleburgazs 32 43 43 53
5 Feriköy Feriköy 31 29 21 49
6 Istanbulspor AS Istanbulspor 32 31 35 45
7 Küçükçekmecespor Küçükçek 32 41 37 44
8 Kirklarelispor Kirklarelisp 31 37 35 43
9 Galata Galata 32 30 35 42
10 Tekirdağspor Tekirdağspo 32 35 33 39
11 İstanbul THY İstanbul 32 30 30 38
12 Silivrispor Kulübü Silivrispor 32 30 45 38
13 Bayrampasaspor Bayrampasasp 32 32 44 35
14 Vefa SK Vefa SK 32 33 41 33
15 İstanbul Güngörenspor İstanbul 32 40 58 30
16 Alibeykoyspor Alibeykoyspo 32 34 62 25
17 Yedikule GSK Yedikule 32 21 51 19
TEMPORADA 1987/1988
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Uzunköprüspor Uzunköprüs 34 61 31 73
2 Tekirdağspor Tekirdağspo 34 68 27 72
3 Bayrampasaspor Bayrampasasp 34 49 35 55
4 Silivrispor Kulübü Silivrispor 34 44 40 50
5 Kasımpaşa Kasımpaşa 34 39 39 47
6 Lüleburgazspor Lüleburgazs 34 40 42 46
7 Galatasaray II Galatasaray 34 49 39 44
8 Feriköy Feriköy 34 37 36 44
9 Alibeykoyspor Alibeykoyspo 34 36 38 41
10 Malkara Belediyespor Malkara 34 32 36 41
11 Golcukspor Golcukspor 34 31 36 41
12 Keşanspor Keşanspor 34 39 43 40
13 Istanbulspor AS Istanbulspor 34 29 42 40
14 Galata Galata 34 33 45 38
15 Pendikspor Pendikspor 34 32 39 36
16 Yedikule GSK Yedikule 34 43 52 36
17 Tekirdağ Sarayspor Tekirdağ 34 24 47 35
18 Hayraboluspor Hayraboluspo 34 32 51 32
TEMPORADA 1986/1987
2. LIG GRUPO 9
Equipo PJ GF GC Puntos
1 Eyupspor Eyupspor 32 48 17 72
2 Tekirdağspor Tekirdağspo 32 57 26 64
3 Uzunköprüspor Uzunköprüs 31 41 24 52
4 Gaziosmanpasaspor Gaziosmanpas 32 31 21 49
5 Keşanspor Keşanspor 32 48 35 48
6 Beylerbeyispor Beylerbeyisp 32 30 25 46
7 İstanbul THY İstanbul 31 33 28 45
8 Lüleburgazspor Lüleburgazs 32 46 38 44
9 Malkara Belediyespor Malkara 32 34 35 41
10 Yedikule GSK Yedikule 32 30 36 41
11 Tekirdağ Sarayspor Tekirdağ 32 33 42 39
12 Bayrampasaspor Bayrampasasp 32 37 34 38
13 Hayraboluspor Hayraboluspo 31 24 36 38
14 Istanbulspor AS Istanbulspor 32 26 42 38
15 Küçükçekmecespor Küçükçek 32 32 39 37
16 Yeşildirek SK Yeşildirek 32 31 51 28
17 Davutpaşa Davutpaşa 31 13 65 8
TEMPORADA 1985/1986
1. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Antalyaspor Antalyaspor 33 57 19 71
2 Adanaspor Adanaspor 34 73 30 66
3 Türk Telekom Türk 33 52 35 58
4 Edirnespor Edirnespor 34 49 49 50
5 Üsküdar Anadolu Üsküdar 34 37 37 49
6 Inegolspor Inegolspor 34 32 35 47
7 Fatih Karagümrük Fatih 34 34 29 46
8 Düzcespor Düzcespor 34 44 49 45
9 Babaeskispor Babaeskispor 34 35 39 43
10 Karabükspor Karabükspor 34 31 41 43
11 Vefa SK Vefa SK 34 37 34 42
12 Bakırköyspor Bakırköysp 34 38 41 41
13 Mersin İdmanyurdu Mersin 34 21 28 40
14 Kirklarelispor Kirklarelisp 34 33 42 40
15 Tekirdağspor Tekirdağspo 34 26 45 39
16 Galata Galata 34 25 41 38
17 Lüleburgazspor Lüleburgazs 34 27 42 34
18 Golcukspor Golcukspor 34 22 37 31

  USO DE MEMORIA  
7,855,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  1.6299
Total Execution Time  1.6312
  CADENA URL  
/historico/Tekirdagspor
  GET DATOS  
$_GET['/historico/Tekirdagspor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (100)  
0.0137  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 = 'Tekirdagspor' 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.0338  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 = 'Tekirdagspor' 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.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0154  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0154  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0139  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=65751 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0142  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 = 58626
0.0145  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 = 59354
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65751 AND type_rel = 2
0.0139  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 = '65751' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '65751' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '65751' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = '65751' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 58626 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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=65751 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0132  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 (59354,58626) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 58626 AND teamId = 65751
0.0171  SELECT count(id) as num_players from rel_players WHERE league_id = 59354 AND teamId = 65751
0.0126  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 = '65751' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65751' and rp.type = 4
0.0127  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 = '65751' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138  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 events2021 e ON e.player_id = p.id AND e.league_id = 58626 WHERE rp.league_id = 58626 AND rp.teamId = 65751 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.0140  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 events2021 e ON e.player_id = p.id AND e.league_id = 58626 WHERE rp.league_id = 58626 AND rp.teamId = 65751 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 events2021 e ON e.player_id = p.id AND e.league_id = 58626 WHERE rp.league_id = 58626 AND rp.teamId = 65751 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 65751 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0141  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 = 58626 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.0147  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 = 38980 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 33913 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 15823 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 `tables2004` 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 = 50244 AND t.round = 32 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 `tables2003` 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 = 50250 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 `tables2000` 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 = 50714 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 `tables1999` 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 = 50734 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 `tables1998` 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 = 50768 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0926  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 `tables1997` 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 = 50777 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 `tables1996` 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 = 50808 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 `tables1995` 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 = 50819 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1993` 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 = 50841 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables1992` 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 = 50851 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables1991` 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 = 50861 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables1990` 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 = 50872 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables1989` 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 = 50889 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0315  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 `tables1988` 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 = 50901 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0411  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 `tables1987` 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 = 50915 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 50490 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC