4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Mardinspor Mardinspor 31 44 15 71
2 Adiyamanspor Adiyamanspor 32 49 23 66
3 Hatayspor Hatayspor 31 62 39 58
4 Gaziantep Gaziantep 32 59 43 54
5 Tarsus Idman Yurdu Tarsus Idman 32 50 34 52
6 Sanliurfaspor Sanliurfaspo 32 54 47 46
7 Aksarayspor Aksarayspor 32 39 36 45
8 Erzincanspor Erzincanspor 32 34 35 40
9 Kahramanmarasspor Kahramanmara 31 34 50 39
10 Osmaniyespor Kulübü Osmaniyespor 32 45 53 38
11 Sanliurfa Belediyespor Sanliurfa 32 34 41 37
12 Batman Petrolspor Batman 31 33 40 36
13 Cizrespor 2010 Cizrespor 32 29 40 36
14 Siirtspor Siirtspor 32 44 58 36
15 Erzurumspor Erzurumspor 32 33 46 34
16 Mezitlispor Mezitlispor 32 31 42 32
17 Iğdırspor Iğdırspor 32 25 57 24
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Kayserispor Kayserispor 32 82 29 75
2 Hatayspor Hatayspor 32 76 30 75
3 Sanliurfaspor Sanliurfaspo 31 61 20 67
4 Gaziantep Gaziantep 32 51 26 64
5 Tarsus Idman Yurdu Tarsus Idman 32 67 38 59
6 Kahramanmarasspor Kahramanmara 32 57 37 50
7 Adiyamanspor Adiyamanspor 32 46 35 46
8 Sanliurfa Belediyespor Sanliurfa 32 48 47 40
9 Batman Petrolspor Batman 32 50 67 40
10 Iğdırspor Iğdırspor 32 38 41 38
11 Mardinspor Mardinspor 32 37 45 38
12 Mezitlispor Mezitlispor 32 54 57 37
13 Erzincanspor Erzincanspor 31 34 50 37
14 Siirtspor Siirtspor 32 53 66 34
15 Cizrespor 2010 Cizrespor 32 42 62 33
16 Hakkari Spor Hakkari Spor 32 32 65 28
17 Silopi Cudispor Silopi 32 7 120 0
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Kayserispor Kayserispor 32 59 22 65
2 Kahramanmarasspor Kahramanmara 32 43 21 61
3 Adana Demirspor Adana 32 57 40 57
4 Körfez İskenderunspor Körfez 32 56 38 49
5 Gaskispor Gaskispor 32 38 34 49
6 Tarsus Idman Yurdu Tarsus Idman 32 36 34 47
7 Silifke Belediyesi Silifke 32 44 35 46
8 Niğdespor Niğdespor 32 39 44 46
9 Kayseri Elektrikspor Kayseri 31 36 31 43
10 Mezitlispor Mezitlispor 32 45 36 41
11 İskenderunspor İskenderuns 32 40 86 41
12 Nevşehir Belediyespor Nevşehir 32 34 39 38
13 Kilis Belediyespor Kilis 32 31 45 38
14 Ceyhanspor Adana Ceyhanspor 31 29 32 35
15 Kozan Belediyespor Kozan 32 33 39 33
16 Fırat Üniversitesi Fırat 32 31 43 31
17 İslahiyespor İslahiyespo 32 16 48 21
Ver
TEMPORADA 1998/1999
Equipo PJ GF GC Puntos
1 Yeni Malatyaspor Yeni 32 48 18 68
2 Ceyhanspor Adana Ceyhanspor 32 57 24 66
3 Gaskispor Gaskispor 32 50 19 66
4 Kayserispor Kayserispor 32 58 27 63
5 Kahramanmarasspor Kahramanmara 32 42 23 61
6 Tarsus Idman Yurdu Tarsus Idman 32 51 27 58
7 Kayseri Elektrikspor Kayseri 32 53 33 50
8 Körfez İskenderunspor Körfez 32 30 35 40
9 Silifke Belediyesi Silifke 32 29 38 37
10 Elazigspor Elazigspor 32 35 48 37
11 İslahiyespor İslahiyespo 32 22 39 37
12 Niğdespor Niğdespor 32 27 33 36
13 İskenderunspor İskenderuns 32 39 46 36
14 Kilis Belediyespor Kilis 32 34 41 34
15 Kozan Belediyespor Kozan 32 34 54 33
16 Siverek Belediyespor Siverek 32 32 60 32
17 Pütürge Belediyespor Pütürge 32 17 93 10
Ver
TEMPORADA 1997/1998
Equipo PJ GF GC Puntos
1 Fırat Üniversitesi Fırat 32 75 29 70
2 Kahramanmarasspor Kahramanmara 31 62 22 65
3 Kayserispor Kayserispor 32 56 22 65
4 Kayseri Elektrikspor Kayseri 32 52 33 61
5 Ceyhanspor Adana Ceyhanspor 32 59 36 54
6 Kilis Belediyespor Kilis 32 54 36 53
7 Gaskispor Gaskispor 32 44 30 46
8 Körfez İskenderunspor Körfez 32 50 43 46
9 İslahiyespor İslahiyespo 31 36 39 45
10 İskenderunspor İskenderuns 32 50 44 44
11 Pütürge Belediyespor Pütürge 32 40 44 41
12 Amedspor Amedspor 32 51 62 39
13 Elazigspor Elazigspor 32 43 47 38
14 Kayapınar Belediyespor Kayapınar 32 31 49 34
15 Siverek Belediyespor Siverek 32 36 58 34
16 Kozan Belediyespor Kozan 32 13 83 11
17 Nizipspor Nizipspor 32 23 98 11
Ver
TEMPORADA 1996/1997
Equipo PJ GF GC Puntos
1 Gaziantep Gaziantep 34 66 15 85
2 Kilis Belediyespor Kilis 34 62 30 68
3 Tarsus Idman Yurdu Tarsus Idman 34 60 33 68
4 Kayseri Elektrikspor Kayseri 34 58 27 60
5 Gaskispor Gaskispor 34 48 33 51
6 Ceyhanspor Adana Ceyhanspor 33 42 34 51
7 İslahiyespor İslahiyespo 34 36 28 49
8 Körfez İskenderunspor Körfez 34 52 46 48
9 Kahramanmarasspor Kahramanmara 34 36 40 47
10 Fırat Üniversitesi Fırat 34 42 50 45
11 Kayserispor Kayserispor 34 46 65 43
12 Pütürge Belediyespor Pütürge 34 41 57 39
13 Silifke Belediyesi Silifke 34 29 42 37
14 Siverek Belediyespor Siverek 34 31 51 37
15 Kozan Belediyespor Kozan 34 39 59 36
16 Nizipspor Nizipspor 34 42 66 36
17 Şehitkamil Belediyespor Şehitkamil 33 21 32 34
18 Osmaniyespor Kulübü Osmaniyespor 34 27 70 22
Ver
TEMPORADA 1995/1996
Equipo PJ GF GC Puntos
1 İskenderunspor İskenderuns 24 37 6 51
2 Körfez İskenderunspor Körfez 24 53 23 50
3 Gaziantep Gaziantep 24 51 26 43
4 Gaskispor Gaskispor 24 28 26 36
5 Osmaniyespor Kulübü Osmaniyespor 24 30 33 34
6 Ceyhanspor Adana Ceyhanspor 24 34 29 32
7 Kilis Belediyespor Kilis 24 25 27 32
8 Nizipspor Nizipspor 24 33 33 31
9 Amedspor Amedspor 24 32 29 30
10 Siverek Belediyespor Siverek 24 20 38 25
11 İslahiyespor İslahiyespo 24 25 35 23
12 Kayapınar Belediyespor Kayapınar 24 13 44 20
13 Yeni Samandağspor Yeni 24 25 57 14
Ver
TEMPORADA 1994/1995
Equipo PJ GF GC Puntos
1 Sanliurfaspor Sanliurfaspo 26 38 20 53
2 İskenderunspor İskenderuns 26 51 26 47
3 Ceyhanspor Adana Ceyhanspor 26 33 18 40
4 Adana Polisgücü Adana 26 28 30 38
5 Yeni Samandağspor Yeni 26 29 27 37
6 Kozan Spor FK Kozan Spor 26 28 35 36
7 Kilis Belediyespor Kilis 26 25 31 35
8 Osmaniyespor Kulübü Osmaniyespor 26 41 28 34
9 Gaziantep Gaziantep 26 24 27 34
10 Nizipspor Nizipspor 26 33 34 32
11 Gaskispor Gaskispor 26 27 34 30
12 İslahiyespor İslahiyespo 26 26 37 28
13 Adana Vefa 01 Spor Adana Vefa. 26 27 40 26
14 Mezitlispor Mezitlispor 26 24 47 23
Ver
TEMPORADA 1993/1994
Equipo PJ GF GC Puntos
1 Silifke Belediyesi Silifke 24 45 12 57
2 Kahramanmarasspor Kahramanmara 24 38 14 49
3 Gaziantep Gaziantep 24 40 17 46
4 Kayserispor Kayserispor 24 34 34 38
5 Osmaniyespor Kulübü Osmaniyespor 24 45 31 36
6 Kozan Spor FK Kozan Spor 24 44 39 32
7 Kilis Belediyespor Kilis 24 32 38 31
8 İslahiyespor İslahiyespo 24 26 34 30
9 Adana Polisgücü Adana 24 26 44 27
10 Nizipspor Nizipspor 24 29 43 26
11 Ceyhanspor Adana Ceyhanspor 23 23 27 25
12 Kirikhanspor Kirikhanspor 24 23 37 22
13 Besnispor Besnispor 23 9 44 12
Ver
TEMPORADA 1992/1993
Equipo PJ GF GC Puntos
1 Hatayspor Hatayspor 30 68 25 67
2 Kayserispor Kayserispor 30 64 37 61
3 Ceyhanspor Adana Ceyhanspor 30 57 25 59
4 Nizipspor Nizipspor 30 49 44 49
5 Niğdespor Niğdespor 30 49 40 47
6 Osmaniyespor Kulübü Osmaniyespor 30 41 33 45
7 Adana Polisgücü Adana 30 46 51 45
8 Kozan Spor FK Kozan Spor 30 51 48 42
9 Kirikhanspor Kirikhanspor 30 46 36 41
10 Kilis Belediyespor Kilis 30 44 38 39
11 Besnispor Besnispor 30 46 55 36
12 İslahiyespor İslahiyespo 30 28 44 36
13 Hatay Sahilspor Hatay 30 36 39 33
14 Elbistan Belediyespor Elbistan 30 33 45 32
15 Kadirli İdman Yurdu Kadirli 30 38 60 30
16 Adana Gençlerbirliği Adana 30 9 85 3
Ver
TEMPORADA 1991/1992
Equipo PJ GF GC Puntos
1 İskenderunspor İskenderuns 36 76 18 83
2 Aksarayspor Aksarayspor 36 57 27 74
3 Osmaniyespor Kulübü Osmaniyespor 36 65 27 73
4 Nevşehir Belediyespor Nevşehir 36 69 29 71
5 Niğdespor Niğdespor 36 56 41 59
6 Adana Polisgücü Adana 36 50 41 51
7 Adana Gençlerbirliği Adana 36 43 50 49
8 Kozan Spor FK Kozan Spor 36 42 48 47
9 Kadirli İdman Yurdu Kadirli 36 48 53 45
10 Adiyamanspor Adiyamanspor 36 46 45 44
11 Elbistan Belediyespor Elbistan 36 48 53 44
12 Nizipspor Nizipspor 36 47 63 44
13 Hatay Sahilspor Hatay 36 36 54 44
14 Ceyhanspor Adana Ceyhanspor 36 53 56 43
15 Besnispor Besnispor 36 38 46 40
16 İslahiyespor İslahiyespo 36 41 78 38
17 Kilis Belediyespor Kilis 36 37 57 37
18 Kirikhanspor Kirikhanspor 36 31 52 32
19 Reyhanlıspor Reyhanlıspo 36 35 80 27
Ver
TEMPORADA 1990/1991
Equipo PJ GF GC Puntos
1 Tarsus Idman Yurdu Tarsus Idman 33 69 12 79
2 İskenderunspor İskenderuns 34 69 27 73
3 Aksarayspor Aksarayspor 34 57 26 66
4 Adana Gençlerbirliği Adana 34 63 27 56
5 Adana Polisgücü Adana 34 46 32 54
6 Osmaniyespor Kulübü Osmaniyespor 34 46 40 50
7 Elbistan Belediyespor Elbistan 34 47 50 50
8 Kadirli İdman Yurdu Kadirli 34 58 46 46
9 Adiyamanspor Adiyamanspor 34 40 54 46
10 Hatay Sahilspor Hatay 34 47 58 43
11 Nizipspor Nizipspor 34 35 60 40
12 Reyhanlıspor Reyhanlıspo 33 39 50 39
13 İslahiyespor İslahiyespo 34 35 43 38
14 Kozan Spor FK Kozan Spor 34 34 43 38
15 Besnispor Besnispor 34 35 64 35
16 Ceyhanspor Adana Ceyhanspor 34 34 61 34
17 Kilis Belediyespor Kilis 34 29 56 34
18 Afşin Belediyespor Afşin 34 23 57 25
Ver
TEMPORADA 1989/1990
Equipo PJ GF GC Puntos
1 Hatayspor Hatayspor 31 65 20 73
2 Aksarayspor Aksarayspor 32 67 22 71
3 Kayserispor Kayserispor 32 57 35 57
4 Osmaniyespor Kulübü Osmaniyespor 32 40 28 57
5 Adana Polisgücü Adana 31 70 40 50
6 Tarsus Idman Yurdu Tarsus Idman 32 42 24 50
7 Elbistan Belediyespor Elbistan 31 34 32 41
8 Adana Gençlerbirliği Adana 32 37 43 40
9 Reyhanlıspor Reyhanlıspo 32 43 48 39
10 Nizipspor Nizipspor 32 37 56 39
11 Adiyamanspor Adiyamanspor 31 33 55 35
12 Besnispor Besnispor 32 31 54 34
13 Hatay Sahilspor Hatay 32 30 43 33
14 Kozan Spor FK Kozan Spor 32 26 47 33
15 Kilis Belediyespor Kilis 32 35 48 32
16 Kadirli İdman Yurdu Kadirli 32 28 47 32
17 İslahiyespor İslahiyespo 32 27 60 30
Ver
TEMPORADA 1988/1989
Equipo PJ GF GC Puntos
1 Niğdespor Niğdespor 30 58 20 65
2 Elbistan Belediyespor Elbistan 30 43 18 59
3 Hatayspor Hatayspor 30 67 29 57
4 Adana Polisgücü Adana 30 64 34 53
5 Tarsus Idman Yurdu Tarsus Idman 30 50 33 49
6 Kadirli İdman Yurdu Kadirli 30 31 30 47
7 Kilis Belediyespor Kilis 30 39 53 39
8 Osmaniyespor Kulübü Osmaniyespor 30 38 43 37
9 Hatay Sahilspor Hatay 30 29 42 37
10 Besnispor Besnispor 30 39 54 36
11 Reyhanlıspor Reyhanlıspo 30 32 47 32
12 Nizipspor Nizipspor 30 34 52 32
13 Kozan Spor FK Kozan Spor 30 33 49 30
14 İslahiyespor İslahiyespo 30 24 49 30
15 Kirikhanspor Kirikhanspor 30 28 43 29
16 Ceyhanspor Adana Ceyhanspor 30 32 45 28
Ver
TEMPORADA 1987/1988
Equipo PJ GF GC Puntos
1 Nevşehir Belediyespor Nevşehir 32 68 12 80
2 Hatayspor Hatayspor 32 76 15 75
3 Elbistan Belediyespor Elbistan 32 41 28 53
4 Ceyhanspor Adana Ceyhanspor 32 50 36 50
5 Kozan Spor FK Kozan Spor 32 40 35 46
6 Osmaniyespor Kulübü Osmaniyespor 32 48 46 44
7 Hatay Sahilspor Hatay 32 32 35 44
8 Reyhanlıspor Reyhanlıspo 32 29 35 43
9 Kirikhanspor Kirikhanspor 32 32 37 42
10 Kamanspor Kamanspor 32 33 34 39
11 Kadirli İdman Yurdu Kadirli 32 33 48 39
12 Sanliurfaspor Sanliurfaspo 32 32 45 37
13 Nizipspor Nizipspor 32 26 53 34
14 Kilis Belediyespor Kilis 32 27 50 32
15 İslahiyespor İslahiyespo 32 33 56 31
16 Afşin Belediyespor Afşin 32 23 35 29
17 Malatya İdman Yurdu Malatya 32 26 49 23
Ver
TEMPORADA 1986/1987
Equipo PJ GF GC Puntos
1 Niğdespor Niğdespor 32 61 26 72
2 Nevşehir Belediyespor Nevşehir 32 49 18 65
3 Elbistan Belediyespor Elbistan 32 39 26 58
4 Aksarayspor Aksarayspor 32 33 23 52
5 Hatayspor Hatayspor 32 31 21 50
6 Kozan Spor FK Kozan Spor 32 40 33 47
7 Ceyhanspor Adana Ceyhanspor 32 35 33 42
8 Kilis Belediyespor Kilis 32 29 31 42
9 Kadirli İdman Yurdu Kadirli 32 32 37 41
10 Nizipspor Nizipspor 32 29 35 39
11 Körfez İskenderunspor Körfez 32 30 33 38
12 Kirikhanspor Kirikhanspor 32 28 34 38
13 Afşin Belediyespor Afşin 32 25 28 36
14 Pazarcık Aksuspor Pazarcık 32 23 43 32
15 İslahiyespor İslahiyespo 32 25 34 31
16 İçel Demirspor İçel 32 28 52 27
17 Borspor Borspor 32 18 48 19
Ver
TEMPORADA 1985/1986
Equipo PJ GF GC Puntos
1 İslahiyespor İslahiyespo 24 29 12 49
2 Reyhanlıspor Reyhanlıspo 23 32 16 48
3 Hatayspor Hatayspor 24 40 19 45
4 Elbistan Belediyespor Elbistan 24 30 23 37
5 Kirikhanspor Kirikhanspor 24 28 24 36
6 Körfez İskenderunspor Körfez 24 32 25 35
7 Kadirli İdman Yurdu Kadirli 23 22 21 33
8 Ceyhanspor Adana Ceyhanspor 24 25 22 31
9 Pazarcık Aksuspor Pazarcık 24 21 31 28
10 İçel Demirspor İçel 24 24 34 23
11 Nizipspor Nizipspor 24 13 27 19
12 Afşin Belediyespor Afşin 24 24 43 18
13 Kilis Belediyespor Kilis 24 14 37 16
Ver
TEMPORADA 1984/1985
Equipo PJ GF GC Puntos
1 Inegolspor Inegolspor 26 46 18 54
2 Ayvalikgucu Belediyespor Ayvalikgucu 26 37 18 53
3 Canakkale Dardanelspor Canakkale 26 41 11 52
4 Tavsanlı Linyitspor Tavsanlı 26 26 14 44
5 Bigaspor Bigaspor 26 37 38 41
6 Edremit Belediyespor Edremit 26 30 26 36
7 İznikspor İznikspor 26 23 24 36
8 Kütahya Termikspor Kütahya 26 19 22 33
9 Sönmez Filamentspor Sönmez 26 18 20 32
10 Mustafakemalpasaspor Mustafakemal 26 26 28 27
11 Bursa Kültürspor Bursa 26 12 21 27
12 Erdekspor Erdekspor 26 20 39 25
13 Bursa Belediyespor Bursa 26 14 30 21
14 Bilecikspor Bilecikspor 26 11 51 14
Ver
TEMPORADA 1976/1977
Equipo PJ GF GC Puntos
1 Tekirdağspor Tekirdağspo 20 25 15 38
2 Edirnespor Edirnespor 20 28 16 37
3 Alibeykoyspor Alibeykoyspo 20 24 19 32
4 Kasımpaşa Kasımpaşa 20 20 19 32
5 Lüleburgazspor Lüleburgazs 20 23 18 30
6 Kirklarelispor Kirklarelisp 20 18 17 28
7 Istanbulspor AS Istanbulspor 20 23 17 27
8 Fatih Karagümrük Fatih 20 22 20 27
9 Galata Galata 20 28 27 27
10 Üsküdar Anadolu Üsküdar 20 11 35 11
11 Küçükçekmecespor Küçükçek 20 10 29 10
Ver
TEMPORADA 1972/1973
Equipo PJ GF GC Puntos
1 Eskişehir Demirspor Eskişehir 24 36 9 55
2 Galata Galata 23 33 8 50
3 Tekirdağspor Tekirdağspo 24 28 16 44
4 Yeşilovaspor Yeşilovaspo 24 36 30 40
5 Nazilli Belediyespor Nazilli 24 30 26 39
6 Ödemisspor Ödemisspor 24 26 21 33
7 Kasımpaşa Kasımpaşa 24 28 32 29
8 Alibeykoyspor Alibeykoyspo 24 15 22 25
9 Küçükçekmecespor Küçükçek 24 16 27 25
10 Yedikule GSK Yedikule 24 17 28 24
11 Beyogluspor Beyogluspor 24 11 18 23
12 Burdurspor Burdurspor 24 11 26 20
13 Muğlaspor Muğlaspor 23 13 37 15
Ver
TEMPORADA 1971/1972
Equipo PJ GF GC Puntos
1 Karabükspor Karabükspor 28 65 13 69
2 Corumspor Corumspor 28 51 28 59
3 Rizespor Rizespor 28 47 17 58
4 Eskişehir Demirspor Eskişehir 28 36 18 49
5 Konya Ereğlispor Konya 27 34 27 47
6 Malatyaspor Malatyaspor 28 33 24 46
7 Nevşehir Belediyespor Nevşehir 28 38 28 43
8 Erzincanspor Erzincanspor 28 31 30 39
9 Diyarbakirspor Diyarbakirsp 27 28 23 38
10 Tokatspor Tokatspor 28 30 27 37
11 Sanliurfaspor Sanliurfaspo 28 25 35 34
12 Sincan Belediyespor Sincan 28 28 46 29
13 Yenimahallespor Yenimahalles 28 22 33 28
14 Bahçeli Gençlik Bahçeli 28 19 54 15
15 Yenişehirspor Yenişehirsp 28 0 84 0
Ver
TEMPORADA 1970/1971
Equipo PJ GF GC Puntos
1 İskenderunspor İskenderuns 28 40 11 63
2 Malatyaspor Malatyaspor 28 52 16 58
3 Rizespor Rizespor 28 51 14 57
4 Karabükspor Karabükspor 28 43 22 50
5 Corumspor Corumspor 27 39 21 49
6 Nevşehir Belediyespor Nevşehir 28 32 15 48
7 Diyarbakirspor Diyarbakirsp 28 27 21 44
8 Erzincanspor Erzincanspor 28 33 30 40
9 Sanliurfaspor Sanliurfaspo 28 20 22 38
10 Konya Ereğlispor Konya 28 31 36 37
11 Tokatspor Tokatspor 28 25 36 30
12 Sincan Belediyespor Sincan 28 17 42 28
13 Yenimahallespor Yenimahalles 27 17 41 16
14 Yenişehirspor Yenişehirsp 28 15 70 10
15 Bahçeli Gençlik Bahçeli 28 8 53 7

  USO DE MEMORIA  
7,727,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0041
Controller Execution Time ( Home / Category )  0.2064
Total Execution Time  0.2105
  CADENA URL  
/2_lig_turquia2004/grupo3/historico
  GET DATOS  
$_GET['/2_lig_turquia2004/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = '2_lig_turquia2004'
0.0050  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_lig_turquia' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0023  SELECT id,name,alias,stepParent FROM categories WHERE parentId=359 ORDER BY order_id ASC
0.0035  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50694 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0050  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 359 AND group_code = 3 and tables = 1 AND year <= 2004 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0044  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 = 50709 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 50729 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050  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 = 50763 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0055  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 = 50772 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 50802 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50813 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 `tables1994` 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 = 50829 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50836 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50846 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 = 50856 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50867 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50884 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50893 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 50909 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 `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 = 50927 AND t.round = 26 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 `tables1985` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50940 AND t.round = 26 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 `tables1977` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50996 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1973` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 51007 AND t.round = 26 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 `tables1972` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 51011 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1971` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 51015 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:41:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 17:41:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:41:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:41:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0029  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_lig_turquia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0060  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2004 e ON e.player_id = p.id AND e.league_id = 50694 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50694 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0121  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2004 e ON e.player_id = p.id AND e.league_id = 50694 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50694 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0023  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2004 e ON e.player_id = p.id AND e.league_id = 50694 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50694 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0053  SELECT *,(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 = 50694 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC