4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
1. LIG
Equipo PJ GF GC Puntos
1 Eyupspor Eyupspor 31 70 27 69
2 Göztepe Göztepe 31 54 19 63
3 Corum FK Corum FK 31 52 31 55
4 Sakaryaspor Sakaryaspor 31 45 31 54
5 Bodrumspor Bodrumspor 31 39 21 52
6 Kocaelispor Kocaelispor 31 45 35 52
7 Bandirmaspor Bandirmaspor 31 46 27 47
8 Gençlerbirliği SK Gençlerbirl 31 37 30 47
9 Boluspor Boluspor 31 28 32 47
10 Erzurumspor Erzurumspor 31 28 27 41
11 Umraniyespor Umraniyespor 31 34 42 37
12 Manisa FK Manisa FK 31 38 37 36
13 Keciorengucu Keciorengucu 31 28 38 36
14 Sanliurfaspor Sanliurfaspo 31 28 33 34
15 Tuzlaspor Tuzlaspor 31 32 46 33
16 Adanaspor Adanaspor 31 24 44 32
17 Altay Altay 31 14 70 15
18 Giresunspor Giresunspor 31 13 65 7
TEMPORADA 2022/2023
LIGA TURCA
Equipo PJ GF GC Puntos
1 Galatasaray SK Galatasaray 36 83 27 88
2 Fenerbahçe Fenerbahçe 36 87 42 80
3 Beşiktaş Beşiktaş 36 78 36 78
4 Adana Demirspor Adana 36 76 45 69
5 İstanbul Başakşehir İstanbul 36 54 37 62
6 Trabzonspor Trabzonspor 36 64 54 57
7 Fatih Karagümrük Fatih 36 75 63 51
8 Konyaspor Konyaspor 36 49 41 51
9 Kayserispor Kayserispor 36 55 61 47
10 Kasımpaşa Kasımpaşa 36 45 61 43
11 Ankaragücü Ankaragücü 36 43 53 42
12 Istanbulspor AS Istanbulspor 36 47 63 41
13 Antalyaspor Antalyaspor 36 46 55 41
14 Sivasspor Sivasspor 36 46 54 41
15 Alanyaspor Alanyaspor 36 54 70 41
16 Giresunspor Giresunspor 36 42 60 40
17 Umraniyespor Umraniyespor 36 47 64 30
18 Gaziantep Gaziantep 36 31 72 25
19 Hatayspor Hatayspor 36 19 83 23
TEMPORADA 2021/2022
LIGA TURCA
Equipo PJ GF GC Puntos
1 Trabzonspor Trabzonspor 38 69 36 81
2 Fenerbahçe Fenerbahçe 38 73 38 73
3 Konyaspor Konyaspor 38 66 45 68
4 İstanbul Başakşehir İstanbul 38 56 36 65
5 Alanyaspor Alanyaspor 38 67 58 64
6 Beşiktaş Beşiktaş 38 56 48 59
7 Antalyaspor Antalyaspor 38 54 47 59
8 Fatih Karagümrük Fatih 38 47 52 57
9 Adana Demirspor Adana 38 60 47 55
10 Sivasspor Sivasspor 38 52 50 54
11 Kasımpaşa Kasımpaşa 38 67 57 53
12 Hatayspor Hatayspor 38 56 60 53
13 Galatasaray SK Galatasaray 38 51 53 52
14 Kayserispor Kayserispor 38 54 61 47
15 Gaziantep Gaziantep 38 48 56 46
16 Giresunspor Giresunspor 38 41 47 45
17 Rizespor Rizespor 38 44 71 36
18 Altay Altay 38 39 57 34
19 Göztepe Göztepe 38 40 77 28
20 Yeni Malatyaspor Yeni 38 27 71 20
TEMPORADA 2020/2021
1. LIG
Equipo PJ GF GC Puntos
1 Adana Demirspor Adana 34 64 27 70
2 Giresunspor Giresunspor 34 54 25 70
3 Samsunspor Samsunspor 34 58 30 70
4 Istanbulspor AS Istanbulspor 34 62 34 64
5 Altay Altay 34 66 39 63
6 Altinordu Altinordu 34 58 45 60
7 Keciorengucu Keciorengucu 34 49 28 58
8 Umraniyespor Umraniyespor 34 46 43 51
9 Tuzlaspor Tuzlaspor 34 46 53 47
10 Bursaspor Bursaspor 34 56 57 46
11 Bandirmaspor Bandirmaspor 34 48 51 42
12 Boluspor Boluspor 34 38 41 42
13 Balikesirspor Balikesirspo 34 35 53 35
14 Adanaspor Adanaspor 34 44 55 34
15 Menemenspor Menemenspor 34 38 62 34
16 Akhisar Belediyespor Akhisar 34 36 59 30
17 Ankaraspor Ankaraspor 34 33 61 26
18 Eskişehirspor Eskişehirsp 34 23 91 8
TEMPORADA 2019/2020
1. LIG
Equipo PJ GF GC Puntos
1 Hatayspor Hatayspor 34 48 28 66
2 Erzurumspor Erzurumspor 34 42 26 62
3 Adana Demirspor Adana 34 71 43 61
4 Akhisar Belediyespor Akhisar 34 46 39 57
5 Fatih Karagümrük Fatih 34 53 39 56
6 Bursaspor Bursaspor 34 49 41 56
7 Altay Altay 34 48 37 54
8 Keciorengucu Keciorengucu 34 33 28 50
9 Menemenspor Menemenspor 34 42 46 44
10 Giresunspor Giresunspor 34 39 47 44
11 Umraniyespor Umraniyespor 34 48 51 44
12 Istanbulspor AS Istanbulspor 34 45 43 40
13 Balikesirspor Balikesirspo 34 36 48 38
14 Altinordu Altinordu 34 37 44 37
15 Boluspor Boluspor 34 30 41 33
16 Ankaraspor Ankaraspor 34 41 56 30
17 Adanaspor Adanaspor 34 30 55 21
18 Eskişehirspor Eskişehirsp 34 34 60 18
TEMPORADA 2018/2019
1. LIG
Equipo PJ GF GC Puntos
1 Denizlispor Denizlispor 34 67 32 72
2 Gençlerbirliği SK Gençlerbirl 34 50 28 70
3 Hatayspor Hatayspor 34 57 22 67
4 Ankaraspor Ankaraspor 34 49 26 62
5 Gaziantep Gaziantep 34 60 31 59
6 Adana Demirspor Adana 34 50 36 58
7 Altinordu Altinordu 34 50 33 57
8 Umraniyespor Umraniyespor 34 44 37 53
9 Boluspor Boluspor 34 41 41 49
10 Altay Altay 34 52 40 47
11 Istanbulspor AS Istanbulspor 34 45 46 43
12 Balikesirspor Balikesirspo 34 36 45 40
13 Adanaspor Adanaspor 34 41 49 37
14 Giresunspor Giresunspor 34 32 41 36
15 Eskişehirspor Eskişehirsp 34 44 66 35
16 Afjet Afyonspor Afjet 34 38 55 30
17 Elazigspor Elazigspor 34 38 64 25
18 Karabükspor Karabükspor 34 10 112 0
TEMPORADA 2017/2018
1. LIG
Equipo PJ GF GC Puntos
1 Rizespor Rizespor 34 68 38 69
2 Ankaragücü Ankaragücü 34 55 34 63
3 Boluspor Boluspor 34 53 30 60
4 Umraniyespor Umraniyespor 34 49 35 59
5 Erzurumspor Erzurumspor 34 56 44 53
6 Gaziantep Gaziantep 34 57 38 53
7 Altinordu Altinordu 34 55 45 53
8 Balikesirspor Balikesirspo 34 56 46 52
9 Istanbulspor AS Istanbulspor 34 45 39 50
10 Elazigspor Elazigspor 34 53 44 48
11 Giresunspor Giresunspor 34 50 44 47
12 Adanaspor Adanaspor 34 41 56 43
13 Adana Demirspor Adana 34 44 47 41
14 Eskişehirspor Eskişehirsp 34 63 56 41
15 Denizlispor Denizlispor 34 43 47 38
16 Samsunspor Samsunspor 34 32 46 36
17 Manisaspor Manisaspor 34 31 80 12
18 Gaziantepspor Gaziantepspo 34 18 100 1
TEMPORADA 2016/2017
1. LIG
Equipo PJ GF GC Puntos
1 Sivasspor Sivasspor 34 51 27 62
2 Yeni Malatyaspor Yeni 34 47 40 61
3 Eskişehirspor Eskişehirsp 34 62 44 56
4 Boluspor Boluspor 34 56 53 54
5 Göztepe Göztepe 34 55 51 53
6 Giresunspor Giresunspor 34 40 34 53
7 Altinordu Altinordu 34 45 37 53
8 Umraniyespor Umraniyespor 34 42 38 48
9 Balikesirspor Balikesirspo 34 56 48 42
10 Elazigspor Elazigspor 34 43 35 41
11 Denizlispor Denizlispor 34 46 45 40
12 Manisaspor Manisaspor 34 47 53 39
13 Gaziantep Gaziantep 34 37 46 37
14 Adana Demirspor Adana 34 47 51 36
15 Samsunspor Samsunspor 34 27 46 36
16 Sanliurfaspor Sanliurfaspo 34 38 46 36
17 Bandirmaspor Bandirmaspor 34 43 52 35
18 Mersin Mersin 34 35 71 26
TEMPORADA 2015/2016
1. LIG
Equipo PJ GF GC Puntos
1 Adanaspor Adanaspor 34 53 36 65
2 Karabükspor Karabükspor 34 41 27 62
3 Alanyaspor Alanyaspor 34 60 38 61
4 Adana Demirspor Adana 34 53 40 54
5 Balikesirspor Balikesirspo 34 40 29 52
6 Elazigspor Elazigspor 34 45 38 52
7 Giresunspor Giresunspor 34 49 40 51
8 Gaziantep Gaziantep 34 38 33 48
9 Samsunspor Samsunspor 34 45 39 47
10 Altinordu Altinordu 34 39 43 44
11 Yeni Malatyaspor Yeni 34 35 41 43
12 Boluspor Boluspor 34 36 46 42
13 Denizlispor Denizlispor 34 41 52 39
14 Göztepe Göztepe 34 38 40 38
15 Sanliurfaspor Sanliurfaspo 34 34 45 38
16 1461 Trabzon 1461 Trabzon 34 32 53 34
17 Kayseri Kayseri 34 35 54 33
18 Karsiyaka Karsiyaka 34 33 53 27
TEMPORADA 2014/2015
1. LIG
Equipo PJ GF GC Puntos
1 Kayserispor Kayserispor 34 61 24 72
2 Ankaraspor Ankaraspor 34 64 29 66
3 Alanyaspor Alanyaspor 34 55 40 57
4 Adana Demirspor Adana 34 57 48 56
5 Samsunspor Samsunspor 34 48 30 55
6 Altinordu Altinordu 34 60 39 54
7 Sanliurfaspor Sanliurfaspo 34 42 29 53
8 Antalyaspor Antalyaspor 34 56 44 53
9 Karsiyaka Karsiyaka 34 49 57 45
10 Boluspor Boluspor 34 47 40 44
11 Giresunspor Giresunspor 34 31 36 44
12 Elazigspor Elazigspor 34 42 45 42
13 Gaziantep Gaziantep 34 38 47 41
14 Adanaspor Adanaspor 34 42 54 39
15 Denizlispor Denizlispor 34 38 51 33
16 Manisaspor Manisaspor 34 42 60 33
17 Bucaspor Bucaspor 34 39 67 32
18 Orduspor 1967 Orduspor 34 19 90 11
TEMPORADA 2013/2014
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Giresunspor Giresunspor 35 57 34 70
2 Göztepe Göztepe 35 54 30 67
3 Hatayspor Hatayspor 35 51 30 66
4 Kartalspor Kartalspor 35 52 36 59
5 Yeni Malatyaspor Yeni 35 50 35 58
6 Inegolspor Inegolspor 35 47 33 57
7 Pendikspor Pendikspor 35 43 31 57
8 Aydinspor Aydinspor 35 45 39 49
9 Turgutluspor Turgutluspor 35 44 43 46
10 Tokatspor Tokatspor 35 40 57 41
11 Gumushanespor Gumushanespo 35 31 33 40
12 Kirklarelispor Kirklarelisp 35 35 53 38
13 1922 Konyaspor 1922 35 31 40 36
14 Sariyer Sariyer 35 39 50 34
15 Tarsus Idman Yurdu Tarsus Idman 35 34 52 34
16 Canakkale Dardanelspor Canakkale 35 31 42 33
17 Gaziosmanpasaspor Gaziosmanpas 35 33 53 28
18 Cankirispor Cankirispor 35 17 43 26
TEMPORADA 2012/2013
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Kahramanmarasspor Kahramanmara 32 53 30 62
2 Hatayspor Hatayspor 32 46 26 55
3 Mamak Fk Mamak Fk 32 42 31 55
4 Tepecik Belediyespor Tepecik 32 47 36 54
5 Nazilli Belediyespor Nazilli 32 54 34 53
6 Fethiyespor Fethiyespor 32 49 32 53
7 Bandirmaspor Bandirmaspor 32 36 34 44
8 Cankirispor Cankirispor 32 36 39 43
9 Pendikspor Pendikspor 32 35 33 41
10 Bozuyukspor Bozuyukspor 32 37 38 41
11 Tarsus Idman Yurdu Tarsus Idman 32 32 35 38
12 Turgutluspor Turgutluspor 32 29 33 37
13 Sariyer Sariyer 32 37 49 35
14 İstanbul Güngörenspor İstanbul 32 23 32 34
15 Giresunspor Giresunspor 32 32 42 34
16 Unyespor Unyespor 32 18 47 25
17 Sakaryaspor Sakaryaspor 32 30 65 21
TEMPORADA 2011/2012
1. LIG
Equipo PJ GF GC Puntos
1 Akhisar Belediyespor Akhisar 34 46 28 63
2 Elazigspor Elazigspor 34 45 30 61
3 Kasımpaşa Kasımpaşa 34 50 39 59
4 Konyaspor Konyaspor 34 35 25 59
5 Rizespor Rizespor 34 52 44 59
6 Adanaspor Adanaspor 34 46 32 53
7 Boluspor Boluspor 34 40 33 51
8 Kayseri Kayseri 34 43 39 46
9 Denizlispor Denizlispor 34 51 46 45
10 Kartalspor Kartalspor 34 37 32 45
11 Tavsanlı Linyitspor Tavsanlı 34 42 39 43
12 Bucaspor Bucaspor 34 45 53 43
13 Göztepe Göztepe 34 36 43 41
14 Gaziantep Gaziantep 34 36 37 40
15 Karsiyaka Karsiyaka 34 31 37 39
16 Giresunspor Giresunspor 34 39 48 39
17 Sakaryaspor Sakaryaspor 34 31 66 21
18 İstanbul Güngörenspor İstanbul 34 24 58 17
TEMPORADA 2010/2011
1. LIG
Equipo PJ GF GC Puntos
1 Samsunspor Samsunspor 32 45 20 58
2 Mersin Mersin 32 39 29 58
3 Gaziantep Gaziantep 32 43 26 57
4 Orduspor 1967 Orduspor 32 47 29 54
5 Rizespor Rizespor 32 36 24 54
6 Tavsanlı Linyitspor Tavsanlı 32 32 28 51
7 Boluspor Boluspor 32 47 31 49
8 Kayseri Kayseri 32 40 29 48
9 Denizlispor Denizlispor 32 40 31 44
10 Karsiyaka Karsiyaka 32 26 34 41
11 Giresunspor Giresunspor 32 27 32 38
12 Adanaspor Adanaspor 32 41 42 37
13 Kartalspor Kartalspor 32 21 29 34
14 Akhisar Belediyespor Akhisar 32 27 39 33
15 İstanbul Güngörenspor İstanbul 32 19 42 33
16 Altay Altay 32 27 43 31
17 Diyarbakirspor Diyarbakirsp 32 10 59 10
TEMPORADA 2009/2010
1. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Karabükspor Karabükspor 34 74 28 77
2 Bucaspor Bucaspor 34 69 40 64
3 Adanaspor Adanaspor 34 42 30 64
4 Altay Altay 34 48 36 59
5 Karsiyaka Karsiyaka 34 48 35 56
6 Konyaspor Konyaspor 34 42 37 55
7 Giresunspor Giresunspor 34 51 42 51
8 Orduspor 1967 Orduspor 34 33 32 44
9 Boluspor Boluspor 34 48 53 43
10 Samsunspor Samsunspor 34 49 47 42
11 Gaziantep Gaziantep 34 31 38 41
12 Mersin Mersin 34 36 44 41
13 Kayseri Kayseri 34 42 53 41
14 Kartalspor Kartalspor 34 32 43 41
15 Rizespor Rizespor 34 37 53 40
16 Hacettepe SK Hacettepe 34 38 50 38
17 Canakkale Dardanelspor Canakkale 34 37 53 35
18 Kocaelispor Kocaelispor 34 23 66 14
TEMPORADA 2008/2009
1. LIG
Equipo PJ GF GC Puntos
1 Manisaspor Manisaspor 34 64 37 64
2 Diyarbakirspor Diyarbakirsp 34 39 27 62
3 Boluspor Boluspor 34 49 35 56
4 Kasımpaşa Kasımpaşa 34 45 27 55
5 Altay Altay 34 50 39 55
6 Karsiyaka Karsiyaka 34 35 29 51
7 Karabükspor Karabükspor 34 51 48 49
8 Adanaspor Adanaspor 34 38 38 48
9 Rizespor Rizespor 34 39 44 47
10 Orduspor 1967 Orduspor 34 48 44 45
11 Kayseri Kayseri 34 45 43 41
12 Kartalspor Kartalspor 34 33 37 41
13 Gaziantep Gaziantep 34 35 40 40
14 Giresunspor Giresunspor 34 35 48 40
15 Sakaryaspor Sakaryaspor 34 44 50 39
16 Samsunspor Samsunspor 34 35 47 39
17 İstanbul Güngörenspor İstanbul 34 35 56 36
18 Malatyaspor Malatyaspor 34 32 63 29
TEMPORADA 2007/2008
1. LIG
Equipo PJ GF GC Puntos
1 Kocaelispor Kocaelispor 34 59 37 64
2 Antalyaspor Antalyaspor 34 56 33 61
3 Sakaryaspor Sakaryaspor 34 55 34 58
4 Diyarbakirspor Diyarbakirsp 34 52 36 57
5 Eskişehirspor Eskişehirsp 34 52 36 57
6 Boluspor Boluspor 34 50 46 53
7 Kayseri Kayseri 34 54 41 52
8 Orduspor 1967 Orduspor 34 39 44 50
9 Karsiyaka Karsiyaka 34 44 41 47
10 Altay Altay 34 47 47 47
11 Malatyaspor Malatyaspor 34 44 43 43
12 Giresunspor Giresunspor 34 41 44 43
13 Kartalspor Kartalspor 34 52 57 42
14 Gaziantep Gaziantep 34 53 51 39
15 Samsunspor Samsunspor 34 45 61 38
16 Elazigspor Elazigspor 34 40 54 34
17 Istanbulspor AS Istanbulspor 34 26 58 26
18 Mardinspor Mardinspor 34 26 72 14
TEMPORADA 2006/2007
2. LIG GRUPO 10
Equipo PJ GF GC Puntos
1 Erzurumspor Erzurumspor 14 27 23 27
2 Giresunspor Giresunspor 14 25 17 24
3 Kirsehirspor Kirsehirspor 14 20 17 22
4 Erzincanspor Erzincanspor 14 17 14 21
5 Tokatspor Tokatspor 14 14 11 20
6 Pazarspor Pazarspor 14 18 21 15
7 Yozgatspor Yozgatspor 14 11 20 12
8 Unyespor Unyespor 14 12 21 9
TEMPORADA 2005/2006
2. LIG GRUPO 4
Equipo PJ GF GC Puntos
1 Hacettepe SK Hacettepe 18 34 15 32
2 Unyespor Unyespor 18 18 9 31
3 Boluspor Boluspor 18 20 15 28
4 Karabükspor Karabükspor 18 17 15 26
5 Cankirispor Cankirispor 18 17 22 24
6 Giresunspor Giresunspor 18 16 15 23
7 Ankara Demirspor Ankara 18 17 17 22
8 Pazarspor Pazarspor 18 11 22 18
9 Fenerspor Fenerspor 18 12 22 17
10 Erzurumspor Erzurumspor 18 17 27 16

  USO DE MEMORIA  
7,778,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.6865
Total Execution Time  0.6880
  CADENA URL  
/historico/Giresunspor
  GET DATOS  
$_GET['/historico/Giresunspor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12901 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12901 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (370894,796566,979196,1028821,1100887) ORDER BY n.cover_points DESC, update_date DESC
0.0154  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 = '12901' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156  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=12901 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (74094,72493,67815,67320) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 67815 AND teamId = 12901
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 72493 AND teamId = 12901
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 12901
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 12901
0.0146  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 = '12901' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147  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 = '12901' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0171  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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 12901 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.0190  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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 12901 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 72493 WHERE rp.league_id = 72493 AND rp.teamId = 12901 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0206  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 = 12901 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0296  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 67815 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 62817 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 58566 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.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50003 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.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 `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 43611 AND t.round = 34 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 `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 = 38966 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 33783 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 15407 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3852 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2804 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 16525 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 9934 AND t.round = 34 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 `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 9936 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 9938 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 9940 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 9942 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 50654 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 50660 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 50680 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC