4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Sariyer Sariyer 18 26 19 31
2 Eyupspor Eyupspor 18 24 16 29
3 Kucukkoyspor Istanbul Kucukkoyspor 18 21 19 29
4 Turanspor Turanspor 18 27 22 28
5 Inegolspor Inegolspor 18 30 22 26
6 Canakkale Dardanelspor Canakkale 18 21 24 24
7 İstanbul Güngörenspor İstanbul 18 20 23 24
8 Yalovaspor Yalovaspor 18 22 23 20
9 Fatih Karagümrük Fatih 18 14 22 19
10 Yeşil Bursa Yeşil Bursa 18 14 29 13
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Kasımpaşa Kasımpaşa 20 40 20 40
2 Kartalspor Kartalspor 20 27 8 40
3 Pendikspor Pendikspor 20 27 18 35
4 İstanbul Güngörenspor İstanbul 20 31 20 34
5 Sariyer Sariyer 20 27 25 33
6 Eyupspor Eyupspor 20 22 20 28
7 Fatih Karagümrük Fatih 20 22 18 25
8 Maltepespor Maltepespor 20 18 21 25
9 Kucukkoyspor Istanbul Kucukkoyspor 20 14 24 23
10 Kartal Belediyespor Kartal 20 16 36 17
11 Bagcilarspor Bagcilarspor 20 12 46 2
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Usakspor Usakspor 32 56 20 78
2 Alanyaspor Alanyaspor 32 64 34 57
3 Inegolspor Inegolspor 32 62 35 55
4 İstanbul Güngörenspor İstanbul 32 60 37 54
5 Muğlaspor Muğlaspor 32 48 45 50
6 Yeşil Bursa Yeşil Bursa 32 51 38 48
7 Nazilli Belediyespor Nazilli 32 44 48 46
8 Izmirspor Izmirspor 32 47 43 45
9 Marmaris Belediyespor Marmaris 32 51 41 44
10 Pendikspor Pendikspor 31 44 51 44
11 Bucaspor Bucaspor 32 45 50 43
12 Bursa Merinosspor Bursa 32 46 46 41
13 Yildirim Bosna Yildirim 32 38 44 38
14 Kucukkoyspor Istanbul Kucukkoyspor 32 28 39 35
15 Aydinspor Aydinspor 32 29 44 32
16 Göztepe Göztepe 32 35 60 25
17 Corluspor Corluspor 31 20 93 10
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Fatih Karagümrük Fatih 32 60 37 63
2 Bucaspor Bucaspor 32 52 30 59
3 Usakspor Usakspor 31 45 33 49
4 Nazilli Belediyespor Nazilli 32 39 30 47
5 Marmaris Belediyespor Marmaris 32 50 47 46
6 Eskişehirspor Eskişehirsp 32 40 41 46
7 Yildirim Bosna Yildirim 32 46 45 45
8 İstanbul Güngörenspor İstanbul 32 42 40 43
9 Bursa Merinosspor Bursa 32 48 48 43
10 Kucukkoyspor Istanbul Kucukkoyspor 31 35 36 41
11 Corluspor Corluspor 32 48 51 41
12 Turanspor Turanspor 32 38 35 39
13 Muğlaspor Muğlaspor 32 41 44 38
14 Aydinspor Aydinspor 32 41 43 35
15 Inegolspor Inegolspor 32 36 43 35
16 Sidespor Sidespor 32 38 70 31
17 Mustafakemalpasaspor Mustafakemal 32 31 57 30
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Karsiyaka Karsiyaka 34 50 20 74
2 Bursa Merinosspor Bursa 34 57 31 65
3 Aydinspor Aydinspor 34 62 43 65
4 Marmaris Belediyespor Marmaris 34 61 43 65
5 Bucaspor Bucaspor 34 49 40 55
6 Inegolspor Inegolspor 34 48 30 49
7 Yildirim Bosna Yildirim 34 56 49 49
8 Nazilli Belediyespor Nazilli 34 50 45 45
9 Muğlaspor Muğlaspor 34 42 48 45
10 Eskişehirspor Eskişehirsp 34 48 46 41
11 Kucukkoyspor Istanbul Kucukkoyspor 34 33 45 40
12 Fatih Karagümrük Fatih 34 34 49 39
13 Mustafakemalpasaspor Mustafakemal 34 36 41 38
14 Sidespor Sidespor 34 36 50 38
15 İstanbul Güngörenspor İstanbul 34 42 52 37
16 Usakspor Usakspor 34 28 55 35
17 Gaziosmanpasaspor Gaziosmanpas 34 39 58 34
18 Kütahyaspor Kütahyaspor 34 38 64 26
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Mersin İdmanyurdu Mersin 17 34 15 35
2 Gaziantep Gaziantep 18 35 17 32
3 Kartalspor Kartalspor 18 32 18 32
4 Eskişehirspor Eskişehirsp 18 22 20 30
5 Mezitlispor Mezitlispor 18 28 32 22
6 Maltepespor Maltepespor 18 29 35 21
7 Kartal Belediyespor Kartal 17 24 25 20
8 Kucukkoyspor Istanbul Kucukkoyspor 18 25 40 18
9 Sapancaspor Sapancaspor 18 17 30 16
10 Zeytinburnuspor Zeytinburnus 18 20 34 13
Ver
TEMPORADA 1999/2000
Equipo PJ GF GC Puntos
1 Cizrespor 2010 Cizrespor 32 59 26 73
2 Mardinspor Mardinspor 32 67 13 72
3 Hakkari Spor Hakkari Spor 32 66 35 61
4 Amedspor Amedspor 32 44 34 59
5 72 Batman Spor Batman Spor 32 60 32 56
6 Elazigspor Elazigspor 32 37 27 49
7 Kayapınar Belediyespor Kayapınar 32 39 34 47
8 Muş Spor Muş Spor 32 46 36 43
9 Yüksekova Belediye Yüksekova 32 25 30 43
10 Silopi Cudispor Silopi 32 44 45 42
11 Nusaybin Demirspor Nusaybin 32 44 42 40
12 Batman Karşıyakaspor Batman 32 37 44 39
13 Kurtalanspor Kurtalanspor 32 51 68 39
14 Genç Muratspor Genç 32 40 55 35
15 Bismil Belediyespor Bismil 32 37 47 34
16 Diyarbakır İÖİ Ayspor Diyarbakır 32 26 60 19
17 Bingölspor Bingölspor 32 8 102 4
Ver
TEMPORADA 1998/1999
Equipo PJ GF GC Puntos
1 Siirtspor Siirtspor 32 119 27 87
2 Mardinspor Mardinspor 32 73 22 70
3 Hakkari Spor Hakkari Spor 32 53 29 67
4 Cizrespor 2010 Cizrespor 32 49 42 50
5 72 Batman Spor Batman Spor 32 33 27 45
6 Bismil Belediyespor Bismil 32 39 43 44
7 Nusaybin Demirspor Nusaybin 31 51 47 43
8 Kurtalanspor Kurtalanspor 32 34 43 42
9 Amedspor Amedspor 32 31 45 40
10 Silopi Cudispor Silopi 32 40 75 39
11 Bingölspor Bingölspor 32 41 46 38
12 Kayapınar Belediyespor Kayapınar 32 36 50 38
13 Yüksekova Belediye Yüksekova 32 39 49 37
14 Genç Muratspor Genç 32 25 46 36
15 Bitlisspor Bitlisspor 32 40 64 34
16 Diyarbakır İÖİ Ayspor Diyarbakır 31 36 55 33
17 Ergani Spor Kulübü Ergani Spor 32 38 67 20
Ver
TEMPORADA 1997/1998
Equipo PJ GF GC Puntos
1 Ağrıspor Ağrıspor 30 59 17 71
2 Silopi Cudispor Silopi 30 53 26 57
3 Bingölspor Bingölspor 30 62 26 56
4 Mardinspor Mardinspor 30 52 37 47
5 Cizrespor 2010 Cizrespor 30 45 37 46
6 Bismil Belediyespor Bismil 30 33 38 39
7 Kurtalanspor Kurtalanspor 30 28 38 36
8 Genç Muratspor Genç 30 25 50 36
9 72 Batman Spor Batman Spor 30 39 41 35
10 Nusaybin Demirspor Nusaybin 30 27 33 35
11 Diyarbakır İÖİ Ayspor Diyarbakır 30 39 47 35
12 Bitlisspor Bitlisspor 30 34 53 35
13 Yüksekova Belediye Yüksekova 30 19 39 35
14 Hakkari Spor Hakkari Spor 30 31 43 34
15 Kızıltepespor Kızıltepes 30 35 38 33
16 Muş Spor Muş Spor 30 29 47 29
Ver
TEMPORADA 1996/1997
Equipo PJ GF GC Puntos
1 Batman Petrolspor Batman 34 100 23 83
2 Ağrıspor Ağrıspor 34 67 20 67
3 72 Batman Spor Batman Spor 34 41 27 51
4 Kızıltepespor Kızıltepes 34 42 42 47
5 Yüksekova Belediye Yüksekova 34 40 46 47
6 Genç Muratspor Genç 34 33 39 46
7 Amedspor Amedspor 34 42 36 45
8 Bismil Belediyespor Bismil 34 25 31 45
9 Kayapınar Belediyespor Kayapınar 34 36 45 45
10 Hakkari Spor Hakkari Spor 34 46 47 44
11 Silopi Cudispor Silopi 34 30 37 44
12 Bitlisspor Bitlisspor 34 45 56 44
13 Mardinspor Mardinspor 34 38 38 42
14 Cizrespor 2010 Cizrespor 34 38 55 42
15 Muş Spor Muş Spor 34 36 48 41
16 Kurtalanspor Kurtalanspor 34 31 46 41
17 Silvanspor Silvanspor 34 44 65 40
18 Doğu Gücüspor Doğu 34 35 68 27
Ver
TEMPORADA 1995/1996
Equipo PJ GF GC Puntos
1 Bingölspor Bingölspor 26 46 15 60
2 Batman Petrolspor Batman 26 48 25 49
3 Kurtalanspor Kurtalanspor 26 39 29 45
4 Mardinspor Mardinspor 26 28 25 35
5 Muş Spor Muş Spor 26 34 35 35
6 Yüksekova Belediye Yüksekova 26 28 39 33
7 Kızıltepespor Kızıltepes 26 21 33 33
8 Bitlisspor Bitlisspor 26 27 28 32
9 72 Batman Spor Batman Spor 25 27 30 32
10 Cizrespor 2010 Cizrespor 25 32 37 31
11 Doğu Gücüspor Doğu 26 26 39 31
12 Genç Muratspor Genç 26 22 25 30
13 Van DSİ Spor DSİ Spor 26 30 35 30
14 Tunceli Belediyespor Tunceli 26 30 43 23
Ver
TEMPORADA 1994/1995
Equipo PJ GF GC Puntos
1 Elazigspor Elazigspor 26 45 14 59
2 Batman Petrolspor Batman 26 62 24 52
3 Bingölspor Bingölspor 26 47 26 48
4 Ağrıspor Ağrıspor 26 37 30 44
5 Kızıltepespor Kızıltepes 26 30 31 36
6 Bitlisspor Bitlisspor 26 28 38 35
7 Yüksekova Belediye Yüksekova 25 37 41 34
8 Van DSİ Spor DSİ Spor 26 32 32 32
9 Ağrı Köy Hizmetlerispor Ağrı Köy 26 21 34 32
10 Amedspor Amedspor 26 34 29 30
11 Muş Spor Muş Spor 26 28 31 30
12 Bismil Belediyespor Bismil 26 31 42 29
13 Kurtalanspor Kurtalanspor 25 19 37 28
14 Ercişspor Ercişspor 26 14 56 10
Ver
TEMPORADA 1993/1994
Equipo PJ GF GC Puntos
1 72 Batman Spor Batman Spor 24 49 18 52
2 Sanliurfaspor Sanliurfaspo 24 46 30 49
3 Batman Petrolspor Batman 24 53 27 48
4 Elazigspor Elazigspor 24 43 28 44
5 Bingölspor Bingölspor 24 41 31 39
6 Van DSİ Spor DSİ Spor 24 26 21 33
7 Bismil Belediyespor Bismil 24 29 28 30
8 Ercişspor Ercişspor 24 23 25 30
9 Yüksekova Belediye Yüksekova 24 25 35 30
10 Bitlisspor Bitlisspor 23 23 37 26
11 Kızıltepespor Kızıltepes 23 31 45 24
12 Mardinspor Mardinspor 24 23 44 24
13 Cizrespor 2010 Cizrespor 24 11 54 11
Ver
TEMPORADA 1992/1993
Equipo PJ GF GC Puntos
1 Adiyamanspor Adiyamanspor 30 71 19 74
2 Sanliurfaspor Sanliurfaspo 30 75 22 64
3 Bingölspor Bingölspor 30 70 26 59
4 Batman Petrolspor Batman 30 65 50 50
5 Elazigspor Elazigspor 30 53 29 46
6 Mardinspor Mardinspor 30 49 41 45
7 Bitlisspor Bitlisspor 29 50 39 44
8 Van DSİ Spor DSİ Spor 30 39 37 41
9 Kızıltepespor Kızıltepes 30 48 42 40
10 Ercişspor Ercişspor 30 33 55 39
11 Cizrespor 2010 Cizrespor 30 31 37 38
12 Yüksekova Belediye Yüksekova 30 39 50 37
13 Silvanspor Silvanspor 30 26 52 32
14 Hakkari Spor Hakkari Spor 30 41 69 29
15 Tuncelispor Tuncelispor 30 44 57 27
16 Tatvanspor Tatvanspor 29 16 125 7
Ver
TEMPORADA 1991/1992
Equipo PJ GF GC Puntos
1 Akçaabat Sebatspor Akçaabat 38 78 25 88
2 Giresunspor Giresunspor 38 87 29 85
3 Bulancakspor Bulancakspor 38 75 35 73
4 Kadıköyspor Kadıköyspo 38 61 42 71
5 Trabzon Telekomspor Trabzon 38 61 40 66
6 Bayburtspor Bayburtspor 38 70 46 62
7 Çayelispor Çayelispor 38 60 58 62
8 Artvin Hopaspor Artvin 38 57 49 56
9 Kanunispor Kanunispor 38 49 45 53
10 Köy Hizmetleri Sinopspor Köy 38 47 59 47
11 Pazarspor Pazarspor 38 43 57 47
12 Gumushanespor Gumushanespo 38 41 48 42
13 Erbaaspor Erbaaspor 38 42 51 42
14 Fatsa Belediye Fatsa 38 40 57 39
15 Ardeşenspor Ardeşenspor 38 46 78 39
16 Vezirköprüspor Vezirköprü 38 27 57 38
17 Çarşambaspor Çarşambasp 38 42 69 37
18 Aras 12 Martspor Aras 38 35 68 36
19 Artvinspor Artvinspor 38 40 65 33
20 Suluovaspor Suluovaspor 38 32 55 24
Ver
TEMPORADA 1990/1991
Equipo PJ GF GC Puntos
1 Bafraspor Bafraspor 32 85 12 86
2 Merzifonspor Merzifonspor 32 49 29 57
3 Bulancakspor Bulancakspor 31 39 26 52
4 Artvin Hopaspor Artvin 32 37 27 49
5 Bayburtspor Bayburtspor 32 38 39 45
6 Artvinspor Artvinspor 32 37 43 44
7 Erbaaspor Erbaaspor 31 35 36 42
8 Aras 12 Martspor Aras 32 35 38 42
9 Trabzon Telekomspor Trabzon 32 42 45 41
10 Kanunispor Kanunispor 32 26 35 41
11 Fatsa Belediye Fatsa 32 38 52 39
12 Gumushanespor Gumushanespo 32 31 39 38
13 Çarşambaspor Çarşambasp 32 31 39 36
14 Suluovaspor Suluovaspor 32 31 44 35
15 Köy Hizmetleri Sinopspor Köy 32 42 53 34
16 Çayelispor Çayelispor 32 37 56 31
17 Görelespor Görelespor 32 18 38 29
Ver
TEMPORADA 1989/1990
Equipo PJ GF GC Puntos
1 Unyespor Unyespor 27 50 15 65
2 Bafraspor Bafraspor 28 57 26 60
3 Trabzonspor II Trabzonspor 28 46 24 50
4 Görelespor Görelespor 28 33 24 44
5 Bayburtspor Bayburtspor 28 36 39 43
6 Aras 12 Martspor Aras 28 38 36 37
7 Trabzon Telekomspor Trabzon 28 27 39 35
8 Tokatspor Tokatspor 28 35 31 33
9 Artvinspor Artvinspor 28 27 32 33
10 Fatsa Belediye Fatsa 28 27 35 33
11 Merzifonspor Merzifonspor 28 31 36 31
12 Kanunispor Kanunispor 28 25 33 31
13 Turhalspor Turhalspor 28 32 45 31
14 Artvin Hopaspor Artvin 27 24 34 28
15 Çayelispor Çayelispor 28 16 55 16
Ver
TEMPORADA 1988/1989
Equipo PJ GF GC Puntos
1 Bulancakspor Bulancakspor 30 45 20 60
2 Tokatspor Tokatspor 30 44 19 60
3 Unyespor Unyespor 30 43 25 51
4 Fatsa Belediye Fatsa 29 35 30 45
5 Turhalspor Turhalspor 30 46 40 41
6 Artvin Hopaspor Artvin 30 29 28 40
7 Kanunispor Kanunispor 30 32 33 40
8 Bayburtspor Bayburtspor 30 26 28 37
9 Artvinspor Artvinspor 30 25 32 37
10 Çayelispor Çayelispor 29 24 35 37
11 Aras 12 Martspor Aras 30 20 33 36
12 Merzifonspor Merzifonspor 30 19 25 34
13 Bafraspor Bafraspor 30 25 31 33
14 Görelespor Görelespor 30 27 43 32
15 Erbaaspor Erbaaspor 30 32 37 31
16 SinopSpor SinopSpor 30 21 34 31
Ver
TEMPORADA 1987/1988
Equipo PJ GF GC Puntos
1 Giresunspor Giresunspor 28 52 21 59
2 Bafraspor Bafraspor 28 52 27 55
3 Kanunispor Kanunispor 28 37 39 44
4 Fatsa Belediye Fatsa 28 39 31 39
5 Turhalspor Turhalspor 28 31 30 39
6 Sivasspor Sivasspor 28 36 33 37
7 Artvin Hopaspor Artvin 28 31 27 36
8 Artvinspor Artvinspor 28 25 28 36
9 Aras 12 Martspor Aras 28 27 26 35
10 Ağrıspor Ağrıspor 28 28 47 35
11 Çayelispor Çayelispor 28 32 42 34
12 Görelespor Görelespor 28 41 39 33
13 Bulancakspor Bulancakspor 28 44 44 33
14 Karsspor Karsspor 28 31 54 33
15 Gumushanespor Gumushanespo 28 29 47 32
Ver
TEMPORADA 1986/1987
Equipo PJ GF GC Puntos
1 Trabzonspor II Trabzonspor 32 55 21 64
2 Unyespor Unyespor 32 53 19 62
3 Artvin Hopaspor Artvin 32 41 16 62
4 Giresunspor Giresunspor 32 42 30 51
5 Tokatspor Tokatspor 32 43 24 50
6 Sivas Demirspor Sivas 32 41 37 46
7 Bafraspor Bafraspor 32 35 28 45
8 Bulancakspor Bulancakspor 32 36 32 45
9 Çayelispor Çayelispor 32 37 37 41
10 Artvinspor Artvinspor 32 30 32 40
11 Fatsa Belediye Fatsa 32 34 33 39
12 Görelespor Görelespor 32 25 33 39
13 Karsspor Karsspor 32 31 41 37
14 Ağrıspor Ağrıspor 32 31 47 37
15 Gumushanespor Gumushanespo 32 25 41 36
16 Iğdırspor Iğdırspor 32 18 57 24
17 Palandökenspor Palandökens 32 29 78 16
Ver
TEMPORADA 1985/1986
Equipo PJ GF GC Puntos
1 Bayburtspor Bayburtspor 18 27 11 39
2 Bulancakspor Bulancakspor 18 28 7 36
3 Unyespor Unyespor 18 20 12 34
4 Iğdırspor Iğdırspor 18 25 21 31
5 Artvinspor Artvinspor 18 16 22 24
6 Ağrıspor Ağrıspor 18 24 23 20
7 Fatsa Belediye Fatsa 18 14 15 19
8 Gumushanespor Gumushanespo 18 21 26 18
9 Karsspor Karsspor 18 10 25 14
10 Palandökenspor Palandökens 18 11 34 11
Ver
TEMPORADA 1984/1985
Equipo PJ GF GC Puntos
1 Yalovaspor Yalovaspor 30 48 18 65
2 Golcukspor Golcukspor 29 36 12 64
3 Pendikspor Pendikspor 30 51 26 60
4 Kocaeli BB Kağıtspor Kocaeli 30 57 32 54
5 Erdemir Ereğlispor Erdemir 30 35 22 53
6 Beykozspor Beykozspor 30 38 29 47
7 Anadolu Hisarı Anadolu 30 26 21 41
8 Kartalspor Kartalspor 30 32 36 38
9 İstanbul THY İstanbul 30 25 37 33
10 Galatasaray II Galatasaray 29 26 26 32
11 Taksim Taksim 30 29 49 32
12 Çengelköyspor Çengelköys 30 40 49 31
13 Umraniyespor Umraniyespor 30 30 51 30
14 Gebzespor Gebzespor 30 23 42 24
15 Sakarya Karadenizspor Sakarya 30 27 53 23
16 Beylerbeyispor Beylerbeyisp 30 28 48 19

  USO DE MEMORIA  
7,374,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1406
Total Execution Time  0.1424
  CADENA URL  
/2_lig_turquia2007/grupo1/historico
  GET DATOS  
$_GET['/2_lig_turquia2007/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0017  SELECT type FROM routes WHERE alias = '2_lig_turquia2007'
0.0039  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=359 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 359 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  SELECT /*53 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 (1307337,1244348,1234831,1117729,1085507) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=359 ORDER BY order_id ASC
0.0020  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 = 50668 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 359 AND group_code = 1 and tables = 1 AND year <= 2007 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 50668 AND t.round = 18 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 `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 = 50677 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50689 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 `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 = 50692 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 `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 = 50695 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 `tables2002` 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 = 50698 AND t.round = 18 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 `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 = 50707 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50727 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 `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 = 50761 AND t.round = 30 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 `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 = 50770 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 `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 = 50800 AND t.round = 26 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 `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 = 50811 AND t.round = 26 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 `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 = 50827 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 `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 = 50834 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50844 AND t.round = 38 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 `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 = 50863 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 `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 = 50865 AND t.round = 30 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 `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 = 50882 AND t.round = 30 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 `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 = 50891 AND t.round = 30 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 `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 = 50907 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 `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 = 50925 AND t.round = 18 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 `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 = 50938 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 06:22:01' 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-28 06:22:01' 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-28 06:22:01' 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=3 AND last_update > '2024-04-28 06:22:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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 events2007 e ON e.player_id = p.id AND e.league_id = 50668 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50668 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.0019  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 events2007 e ON e.player_id = p.id AND e.league_id = 50668 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50668 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2007 e ON e.player_id = p.id AND e.league_id = 50668 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50668 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  SELECT *,(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 = 50668 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC