4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kuşadasıspor

Kuşadasıspor

Entrenador: Koray Palaz

Temporada 2023/2024
TEMPORADA 2023/2024
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Karaköprü Bld. Karaköprü 28 51 24 60
2 Erbaaspor Erbaaspor 28 55 21 57
3 Silivrispor Kulübü Silivrispor 28 38 22 51
4 Viven Bornova FK Viven 28 47 33 50
5 Kuşadasıspor Kuşadasısp 28 36 28 45
6 Belediye Kütahyaspor Belediye 28 40 25 44
7 Ağrı Spor Ağrı Spor 28 36 35 39
8 Tepecikspor Tepecikspor 28 29 30 39
9 Fatsa Belediye Fatsa 28 24 27 37
10 Osmaniyespor Kulübü Osmaniyespor 28 29 34 29
11 1922 Konyaspor 1922 28 25 30 28
12 Bayburt Bayburt 28 18 38 28
13 Darica Genclerbirligi Darica 28 18 33 25
14 Akhisar Belediyespor Akhisar 28 25 67 19
15 Sivas Belediyespor Sivas 28 22 46 17
TEMPORADA 2022/2023
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 76 Iğdır 76 Iğdır 32 70 21 71
2 Alanya Kestelspor Alanya 32 59 23 69
3 Orduspor 1967 Orduspor 32 63 29 66
4 Karaman FK Karaman FK 32 52 24 65
5 Ayvalikgucu Belediyespor Ayvalikgucu 32 46 26 54
6 Kuşadasıspor Kuşadasısp 32 43 31 51
7 Eynesil Eynesil 32 32 42 41
8 Kartal Bulvarspor Kartal 32 36 36 40
9 Gumushanespor Gumushanespo 32 25 33 37
10 23 Elazig 23 Elazig 32 43 58 37
11 MKE Kırıkkalespor Kırıkkales 32 39 49 36
12 Turgutluspor Turgutluspor 32 32 45 34
13 Darica Genclerbirligi Darica 32 29 43 32
14 Ergene Velimese Spor Ergene 32 29 43 32
15 Bayrampasaspor Bayrampasasp 32 22 44 29
16 Ofspor Ofspor 32 24 45 24
17 Kahramanmarasspor Kahramanmara 32 11 63 12
TEMPORADA 2021/2022
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Düzcespor Düzcespor 36 59 30 78
2 İskenderunspor İskenderuns 36 72 31 74
3 76 Iğdır 76 Iğdır 36 64 39 72
4 68 Aksaray Belediyespor Aksaray 36 49 43 59
5 52 Orduspor 52 Orduspor 36 48 41 58
6 Kestel Belediyespor Kestel 36 46 34 57
7 Kuşadasıspor Kuşadasısp 36 42 48 47
8 Sile Yildizspor Sile 36 39 46 47
9 Bayrampasaspor Bayrampasasp 36 41 33 45
10 Kalecik FK Kalecik FK 36 41 48 45
11 23 Elazig 23 Elazig 36 40 36 43
12 Halide Edip Adivar Halide Edip 36 33 39 41
13 Yomraspor Yomraspor 36 35 45 41
14 Siirt İl Özel İdaresi Siirt Özel 36 38 57 41
15 Darica Genclerbirligi Darica 36 33 46 38
16 Kizilcabolukspor Kizilcaboluk 36 41 51 37
17 Yeşilyurt Belediyespor Yeşilyurt 36 31 44 36
18 Çarşambaspor Çarşambasp 36 32 52 34
19 Hacettepe SK Hacettepe 36 24 45 31
TEMPORADA 1998/1999
1. LIG GRUPO 9
Equipo PJ GF GC Puntos
1 Kartalspor Kartalspor 14 25 11 27
2 Ankaraspor Ankaraspor 14 24 14 25
3 Pendikspor Pendikspor 14 24 18 23
4 Kasımpaşa Kasımpaşa 14 16 16 19
5 Corluspor Corluspor 14 21 22 19
6 Kuşadasıspor Kuşadasısp 14 19 23 16
7 Fenerspor Fenerspor 14 18 28 12
8 Edirnespor Edirnespor 14 13 28 10
TEMPORADA 1997/1998
1. LIG GRUPO 9
Equipo PJ GF GC Puntos
1 Kartalspor Kartalspor 14 21 14 29
2 Edirnespor Edirnespor 14 26 19 26
3 Kuşadasıspor Kuşadasısp 14 28 21 23
4 Göztepe Göztepe 14 17 13 21
5 Kasımpaşa Kasımpaşa 14 20 25 19
6 Fenerspor Fenerspor 14 15 20 18
7 Düzcespor Düzcespor 14 10 18 13
8 Beylerbeyispor Beylerbeyisp 14 16 23 10
TEMPORADA 1996/1997
1. LIG GRUPO 6
Equipo PJ GF GC Puntos
1 Karabükspor Karabükspor 18 29 13 39
2 Kayseri Kayseri 18 31 17 35
3 Fenerspor Fenerspor 18 30 28 32
4 Mersin İdmanyurdu Mersin 18 19 14 29
5 Adanaspor Adanaspor 18 19 20 25
6 Karsiyaka Karsiyaka 18 19 21 24
7 Diyarbakirspor Diyarbakirsp 18 24 24 20
8 Erzurumspor Erzurumspor 18 12 22 17
9 Rizespor Rizespor 18 13 27 16
10 Kuşadasıspor Kuşadasısp 18 14 24 14
TEMPORADA 1995/1996
2. LIG GRUPO 7
Equipo PJ GF GC Puntos
1 Kuşadasıspor Kuşadasısp 26 63 15 68
2 Izmirspor Izmirspor 26 52 21 60
3 Manisaspor Manisaspor 26 36 24 40
4 Sökespor Sökespor 26 29 35 38
5 Petkimspor Petkimspor 26 27 26 36
6 Göztepe Göztepe 25 37 30 34
7 Akhisar Belediyespor Akhisar 26 35 39 34
8 Selçuk Efesspor Selçuk 26 27 43 32
9 Edremit Belediyespor Edremit 26 36 42 30
10 Yeşilovaspor Yeşilovaspo 26 24 37 29
11 Gönenspor Gönenspor 26 25 41 29
12 Ayvalikgucu Belediyespor Ayvalikgucu 26 30 48 29
13 Yeni Bornovaspor Yeni 26 32 37 28
14 Altinordu Altinordu 25 33 48 18
TEMPORADA 1994/1995
2. LIG GRUPO 7
Equipo PJ GF GC Puntos
1 Fethiyespor Fethiyespor 25 33 16 48
2 Kuşadasıspor Kuşadasısp 26 34 20 47
3 Yeni Milasspor Yeni 26 29 22 45
4 Seydişehir Eti Alüminyum Seydişehir 26 28 27 38
5 Antalya Köy Hizmetleri Antalya Köy 26 32 28 36
6 Karamanspor Karamanspor 25 23 19 35
7 Nazilli Belediyespor Nazilli 26 31 28 35
8 Marmaris Belediyespor Marmaris 25 26 25 33
9 Sökespor Sökespor 26 24 29 33
10 Yeşilovaspor Yeşilovaspo 26 18 24 28
11 Selçuk Efesspor Selçuk 26 25 32 28
12 Mobellaspor Mobellaspor 26 25 36 28
13 Sarayköy 1926 Sarayköy 26 29 34 26
14 Ödemisspor Ödemisspor 25 23 40 25
TEMPORADA 1993/1994
2. LIG GRUPO 5
Equipo PJ GF GC Puntos
1 Antalya Köy Hizmetleri Antalya Köy 24 29 15 47
2 Kemerspor Kemerspor 23 41 18 46
3 Marmaris Belediyespor Marmaris 24 37 28 38
4 Fethiyespor Fethiyespor 24 30 33 37
5 Seydişehir Eti Alüminyum Seydişehir 24 33 28 35
6 Kuşadasıspor Kuşadasısp 24 36 33 35
7 Ödemisspor Ödemisspor 24 23 30 32
8 Yeşilovaspor Yeşilovaspo 24 25 26 31
9 Nazilli Belediyespor Nazilli 24 24 32 30
10 Karamanspor Karamanspor 23 32 27 29
11 Yeni Milasspor Yeni 24 29 35 29
12 Ormanspor Ormanspor 23 23 33 26
13 Torbalispor Torbalispor 23 24 48 12
TEMPORADA 1992/1993
2. LIG GRUPO 10
Equipo PJ GF GC Puntos
1 Turgutluspor Turgutluspor 30 64 20 73
2 Soma Linyitspor Soma 30 55 37 60
3 Petkimspor Petkimspor 30 63 37 53
4 Manisa Mensucatspor Manisa 30 49 31 53
5 Bergama Belediyespor Bergama 29 51 26 52
6 Yeşilovaspor Yeşilovaspo 30 58 36 45
7 Torbalispor Torbalispor 30 41 41 44
8 Kuşadasıspor Kuşadasısp 30 53 41 43
9 Altinordu Altinordu 30 50 42 43
10 Akhisar Belediyespor Akhisar 30 35 41 40
11 Soma Sotesspor Soma 30 38 44 38
12 Ödemisspor Ödemisspor 29 30 40 32
13 Selçuk Efesspor Selçuk 30 39 53 32
14 Tarişspor Tarişspor 29 29 49 23
15 Tirespor Tirespor 29 24 84 19
16 Alasehir Belediyespor Alasehir 30 15 72 14
TEMPORADA 1991/1992
2. LIG GRUPO 6
Equipo PJ GF GC Puntos
1 Kütahyaspor Kütahyaspor 34 64 21 75
2 Turgutluspor Turgutluspor 34 58 25 75
3 Tavsanlı Linyitspor Tavsanlı 34 47 29 62
4 Usakspor Usakspor 34 57 39 59
5 Petkimspor Petkimspor 34 53 34 58
6 Kuşadasıspor Kuşadasısp 34 48 40 57
7 Akhisar Belediyespor Akhisar 34 40 43 43
8 Tarişspor Tarişspor 33 39 43 43
9 Soma Linyitspor Soma 34 51 45 42
10 Alasehir Belediyespor Alasehir 34 32 46 41
11 Yeşilovaspor Yeşilovaspo 34 47 55 40
12 Soma Sotesspor Soma 34 35 47 40
13 Torbalispor Torbalispor 33 40 47 39
14 Ödemisspor Ödemisspor 34 38 43 36
15 Selçuk Efesspor Selçuk 33 32 43 33
16 Buldan Belediyespor Buldan 34 45 73 31
17 Tirespor Tirespor 34 33 58 30
18 Çeşmespor Çeşmespor 33 42 70 24
TEMPORADA 1990/1991
1. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Altay Altay 34 76 23 84
2 Göztepe Göztepe 34 81 30 79
3 Denizlispor Denizlispor 34 56 27 61
4 Bandirmaspor Bandirmaspor 34 44 48 51
5 Ayvalikgucu Belediyespor Ayvalikgucu 34 45 52 48
6 Izmirspor Izmirspor 34 66 63 47
7 Inegolspor Inegolspor 34 51 47 46
8 Muğlaspor Muğlaspor 34 61 56 44
9 Yeni Salihlispor Yeni 34 42 61 44
10 Alanyaspor Alanyaspor 34 54 53 43
11 Bucaspor Bucaspor 34 38 38 41
12 Altinordu Altinordu 34 39 50 39
13 Sökespor Sökespor 34 38 57 39
14 Antalyaspor Antalyaspor 34 39 65 39
15 Gönenspor Gönenspor 34 45 55 38
16 Kütahyaspor Kütahyaspor 34 44 58 38
17 Kuşadasıspor Kuşadasısp 34 50 63 36
18 Afjet Afyonspor Afjet 34 30 53 34
TEMPORADA 1989/1990
1. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Aydinspor Aydinspor 32 66 24 74
2 Göztepe Göztepe 32 58 32 63
3 Antalyaspor Antalyaspor 31 57 34 59
4 Denizlispor Denizlispor 32 45 31 53
5 Alanyaspor Alanyaspor 32 44 43 46
6 Sökespor Sökespor 32 41 40 46
7 Ayvalikgucu Belediyespor Ayvalikgucu 31 45 32 44
8 Kuşadasıspor Kuşadasısp 32 41 46 44
9 Bandirmaspor Bandirmaspor 32 43 49 44
10 Izmirspor Izmirspor 32 43 52 43
11 Altinordu Altinordu 32 45 43 42
12 Inegolspor Inegolspor 32 44 50 38
13 Yeni Salihlispor Yeni 32 38 49 37
14 Muğlaspor Muğlaspor 32 27 38 36
15 Edirnespor Edirnespor 32 38 54 32
16 Menemenspor Menemenspor 32 25 49 25
17 Ispartaspor Ispartaspor 32 29 63 22
TEMPORADA 1988/1989
1. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Zeytinburnuspor Zeytinburnus 33 77 23 82
2 Denizlispor Denizlispor 33 52 26 66
3 Kuşadasıspor Kuşadasısp 34 57 38 62
4 Antalyaspor Antalyaspor 34 72 42 60
5 Göztepe Göztepe 34 46 31 56
6 Edirnespor Edirnespor 34 48 40 50
7 Kocaelispor Kocaelispor 34 40 38 50
8 Yeni Salihlispor Yeni 34 42 41 49
9 Altinordu Altinordu 34 43 47 49
10 Menemenspor Menemenspor 34 34 47 46
11 Ayvalikgucu Belediyespor Ayvalikgucu 34 41 34 45
12 Aydinspor Aydinspor 34 33 39 45
13 Eyupspor Eyupspor 34 47 51 40
14 Muğlaspor Muğlaspor 34 42 48 37
15 Babaeskispor Babaeskispor 34 41 64 34
16 Corluspor Corluspor 34 39 67 33
17 Düzcespor Düzcespor 34 32 69 26
18 Uzunköprüspor Uzunköprüs 34 24 65 19
TEMPORADA 1987/1988
1. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Konyaspor Konyaspor 32 49 27 65
2 Zeytinburnuspor Zeytinburnus 32 64 36 60
3 Bakırköyspor Bakırköysp 32 40 27 51
4 Kuşadasıspor Kuşadasısp 32 48 31 48
5 Göztepe Göztepe 32 52 49 48
6 Altinordu Altinordu 32 42 36 45
7 Beykozspor Beykozspor 32 35 30 44
8 Babaeskispor Babaeskispor 32 40 53 43
9 Eyupspor Eyupspor 32 40 36 42
10 Aydinspor Aydinspor 31 35 49 41
11 Menemenspor Menemenspor 31 40 55 39
12 Muğlaspor Muğlaspor 32 37 41 38
13 Edirnespor Edirnespor 32 35 39 38
14 Izmirspor Izmirspor 32 39 42 36
15 Corluspor Corluspor 31 37 39 35
16 Fatih Karagümrük Fatih 32 29 40 35
17 Kirklarelispor Kirklarelisp 31 30 62 27
TEMPORADA 1986/1987
1. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Sakaryaspor Sakaryaspor 34 77 26 81
2 Konyaspor Konyaspor 34 62 14 79
3 Kuşadasıspor Kuşadasısp 34 36 24 55
4 Bakırköyspor Bakırköysp 34 34 31 55
5 Sönmez Filamentspor Sönmez 34 47 36 54
6 Corluspor Corluspor 34 24 25 47
7 Tarsus Idman Yurdu Tarsus Idman 34 31 35 44
8 Karabükspor Karabükspor 34 43 48 42
9 Kirklarelispor Kirklarelisp 34 34 36 41
10 Fatih Karagümrük Fatih 34 30 38 41
11 Düzcespor Düzcespor 34 34 36 40
12 Edirnespor Edirnespor 34 33 35 40
13 Beykozspor Beykozspor 34 27 34 39
14 Babaeskispor Babaeskispor 34 34 44 39
15 Üsküdar Anadolu Üsküdar 34 29 36 36
16 Canakkale Dardanelspor Canakkale 34 32 54 36
17 Vefa SK Vefa SK 34 23 45 35
18 Silivrispor Kulübü Silivrispor 34 25 58 24
TEMPORADA 1985/1986
2. LIG GRUPO 7
Equipo PJ GF GC Puntos
1 Kuşadasıspor Kuşadasısp 24 53 10 58
2 Menemenspor Menemenspor 23 45 18 51
3 Yeşilovaspor Yeşilovaspo 23 36 18 45
4 Torbalispor Torbalispor 24 36 28 39
5 Turgutluspor Turgutluspor 24 36 23 38
6 Tarişspor Tarişspor 24 27 22 36
7 Alasehir Belediyespor Alasehir 24 32 33 32
8 Yeni Bornovaspor Yeni 24 21 31 27
9 Bucaspor Bucaspor 24 19 26 26
10 Ödemisspor Ödemisspor 24 18 32 26
11 Tirespor Tirespor 24 22 44 23
12 Ülküspor Ülküspor 24 21 30 21
13 Kemalpaşaspor Kemalpaşasp 24 10 61 5

  USO DE MEMORIA  
7,230,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.7733
Total Execution Time  0.7746
  CADENA URL  
/historico/Kusadasi-Genclik-Spor-Kulubu
  GET DATOS  
$_GET['/historico/Kusadasi-Genclik-Spor-Kulubu']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0144  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 = 'Kusadasi-Genclik-Spor-Kulubu' 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.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=120309 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=120309 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=120309 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=120309 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0267  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 = 73221
0.0132  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 = 75950
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=120309 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=360 AND type_rel = 3
0.0125  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 360 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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,30416) ORDER BY n.cover_points DESC, update_date DESC
0.0131  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 = '120309' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '120309' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '120309' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 75950 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 73221 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140  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=120309 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (75950,74094,73221) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 73221 AND teamId = 120309
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 120309
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 75950 AND teamId = 120309
0.0137  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 = '120309' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '120309' and rp.type = 4
0.0135  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 = '120309' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0200  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73221 WHERE rp.league_id = 73221 AND rp.teamId = 120309 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.0194  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73221 WHERE rp.league_id = 73221 AND rp.teamId = 120309 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0177  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73221 WHERE rp.league_id = 73221 AND rp.teamId = 120309 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 120309 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0143  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73221 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68888 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.0136  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63655 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 50301 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 50307 AND t.round = 14 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 `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 = 50316 AND t.round = 18 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 `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 = 50322 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 50327 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 50331 AND t.round = 18 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 `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 = 50806 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 50817 AND t.round = 26 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 `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 = 50831 AND t.round = 26 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 `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 = 50843 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 50849 AND t.round = 34 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 `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 = 50393 AND t.round = 34 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 `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 = 50396 AND t.round = 34 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 = 50407 AND t.round = 34 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 `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 = 50411 AND t.round = 34 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 `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 = 50415 AND t.round = 34 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 `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 = 50931 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC