4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sepahan

Sepahan

Entrenador: José Morais

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA IRÁN
Equipo PJ GF GC Puntos
1 FC Esteghlal Esteghlal 24 34 14 53
2 Persepolis Persepolis 24 33 13 52
3 Sepahan Sepahan 24 44 23 45
4 Tractor Sazi Tractor Sazi 24 32 21 40
5 Malavan Malavan 24 27 18 38
6 Gol Gohar Sirjan Gohar Sirjan 24 26 19 34
7 Shams Azar Qazvin Shams Azar. 24 28 25 34
8 Zob Ahan Zob Ahan 24 24 23 33
9 Mes Rafsanjan Rafsanjan 24 27 30 30
10 Aluminium Arak Aluminium 24 20 27 30
11 Havadar SC Havadar SC 24 27 34 25
12 Paykan Paykan 24 22 30 25
13 Foolad Khuzestan Foolad 24 15 34 21
14 Esteghlal Khuzestan Esteghlal 24 19 29 20
15 Nassaji Mazandaran FC Nassaji 24 15 32 19
16 Naft Abadan Naft Abadan 24 18 39 16
TEMPORADA 2022/2023
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 46 13 66
2 Sepahan Sepahan 30 49 17 65
3 FC Esteghlal Esteghlal 30 52 22 62
4 Tractor Sazi Tractor Sazi 30 42 34 52
5 Mes Rafsanjan Rafsanjan 30 29 15 47
6 Gol Gohar Sirjan Gohar Sirjan 30 40 36 45
7 Aluminium Arak Aluminium 30 20 15 40
8 Foolad Khuzestan Foolad 30 27 26 40
9 Zob Ahan Zob Ahan 30 25 24 36
10 Havadar SC Havadar SC 30 24 34 33
11 Paykan Paykan 30 12 28 28
12 Malavan Malavan 30 21 40 27
13 Nassaji Mazandaran FC Nassaji 30 26 44 26
14 Naft Abadan Naft Abadan 30 22 36 25
15 Mes Kerman Mes Kerman 30 23 37 22
16 Naft Masjed Soleyman Naft Masjed 30 22 59 20
TEMPORADA 2021/2022
LIGA IRÁN
Equipo PJ GF GC Puntos
1 FC Esteghlal Esteghlal 30 39 10 68
2 Persepolis Persepolis 30 41 21 61
3 Sepahan Sepahan 30 43 21 56
4 Gol Gohar Sirjan Gohar Sirjan 30 37 28 51
5 Foolad Khuzestan Foolad 30 30 22 49
6 Mes Rafsanjan Rafsanjan 30 39 29 45
7 Zob Ahan Zob Ahan 30 21 25 37
8 Aluminium Arak Aluminium 30 20 23 37
9 Paykan Paykan 30 26 27 36
10 Naft Abadan Naft Abadan 30 26 30 36
11 Havadar SC Havadar SC 30 18 25 34
12 Nassaji Mazandaran FC Nassaji 30 24 34 33
13 Tractor Sazi Tractor Sazi 30 26 29 32
14 Naft Masjed Soleyman Naft Masjed 30 14 35 22
15 Padideh Khorasan Padideh 30 17 43 17
16 Fajr Sepasi Fajr Sepasi 30 10 29 17
TEMPORADA 2020/2021
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 47 14 67
2 Sepahan Sepahan 30 53 24 65
3 FC Esteghlal Esteghlal 30 36 19 56
4 Tractor Sazi Tractor Sazi 30 35 29 45
5 Gol Gohar Sirjan Gohar Sirjan 30 33 32 45
6 Foolad Khuzestan Foolad 30 27 18 44
7 Paykan Paykan 30 32 30 40
8 Mes Rafsanjan Rafsanjan 30 23 29 39
9 Padideh Khorasan Padideh 30 27 31 38
10 Naft Abadan Naft Abadan 30 24 29 37
11 Aluminium Arak Aluminium 30 25 33 37
12 Nassaji Mazandaran FC Nassaji 30 27 34 33
13 Naft Masjed Soleyman Naft Masjed 30 21 29 31
14 Zob Ahan Zob Ahan 30 28 39 26
15 Saipa Saipa 30 19 34 26
16 Machine Sazi Machine Sazi 30 19 52 14
TEMPORADA 2019/2020
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 46 17 67
2 FC Esteghlal Esteghlal 30 55 31 53
3 Foolad Khuzestan Foolad 30 28 19 51
4 Tractor Sazi Tractor Sazi 30 31 23 50
5 Sepahan Sepahan 30 39 22 49
6 Padideh Khorasan Padideh 30 27 25 46
7 Naft Abadan Naft Abadan 30 29 33 41
8 Naft Masjed Soleyman Naft Masjed 30 24 22 38
9 Nassaji Mazandaran FC Nassaji 30 30 32 38
10 Gol Gohar Sirjan Gohar Sirjan 30 27 34 33
11 Machine Sazi Machine Sazi 30 28 40 31
12 Zob Ahan Zob Ahan 30 31 39 30
13 Paykan Paykan 30 38 44 29
14 Saipa Saipa 30 24 35 29
15 Pars Jonubi Pars Jonubi 30 20 30 27
16 Shahin Bushehr Shahin 30 26 57 22
TEMPORADA 2018/2019
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 36 14 61
2 Sepahan Sepahan 30 46 20 58
3 FC Esteghlal Esteghlal 30 40 13 57
4 Padideh Khorasan Padideh 30 32 16 56
5 Tractor Sazi Tractor Sazi 30 42 25 52
6 Zob Ahan Zob Ahan 30 28 28 40
7 Saipa Saipa 30 28 33 38
8 Foolad Khuzestan Foolad 30 30 39 38
9 Naft Abadan Naft Abadan 30 31 30 37
10 Nassaji Mazandaran FC Nassaji 30 29 29 36
11 Paykan Paykan 30 27 35 35
12 Pars Jonubi Pars Jonubi 30 28 33 30
13 Machine Sazi Machine Sazi 30 19 26 29
14 Naft Masjed Soleyman Naft Masjed 30 16 34 22
15 Sepidrood Rasht Sepidrood 30 24 53 20
16 Esteghlal Khuzestan Esteghlal 30 19 47 12
TEMPORADA 2017/2018
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 48 15 64
2 Zob Ahan Zob Ahan 30 46 30 55
3 FC Esteghlal Esteghlal 30 43 18 54
4 Saipa Saipa 30 40 34 54
5 Pars Jonubi Pars Jonubi 30 34 24 47
6 Paykan Paykan 30 32 26 45
7 Foolad Khuzestan Foolad 30 28 27 44
8 Naft Abadan Naft Abadan 30 36 36 40
9 Gostaresh Foulad Gostaresh 30 24 32 37
10 Tractor Sazi Tractor Sazi 30 28 33 34
11 Padideh Khorasan Padideh 30 33 33 33
12 Esteghlal Khuzestan Esteghlal 30 25 42 31
13 Sepidrood Rasht Sepidrood 30 24 39 30
14 Sepahan Sepahan 30 31 34 29
15 Naft Tehran Naft Tehran 30 23 41 24
16 Mashhad Mashhad 30 17 48 15
TEMPORADA 2016/2017
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 46 14 66
2 FC Esteghlal Esteghlal 30 45 27 57
3 Tractor Sazi Tractor Sazi 30 38 24 56
4 Zob Ahan Zob Ahan 30 39 30 46
5 Sepahan Sepahan 30 38 34 45
6 Paykan Paykan 30 39 38 44
7 Esteghlal Khuzestan Esteghlal 30 36 34 41
8 Gostaresh Foulad Gostaresh 30 26 24 38
9 Naft Tehran Naft Tehran 30 31 34 36
10 Foolad Khuzestan Foolad 30 30 32 35
11 Padideh Khorasan Padideh 30 28 36 34
12 Naft Abadan Naft Abadan 30 24 34 33
13 Saipa Saipa 30 20 30 32
14 Mashhad Mashhad 30 24 35 30
15 Saba Qom Saba Qom 30 22 33 28
16 Machine Sazi Machine Sazi 30 18 45 16
TEMPORADA 2015/2016
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Esteghlal Khuzestan Esteghlal 30 33 14 57
2 Persepolis Persepolis 30 50 34 57
3 FC Esteghlal Esteghlal 30 43 28 52
4 Tractor Sazi Tractor Sazi 30 43 27 51
5 Naft Tehran Naft Tehran 30 30 21 49
6 Zob Ahan Zob Ahan 30 38 26 46
7 Saba Qom Saba Qom 30 30 24 42
8 Saipa Saipa 30 28 31 40
9 Gostaresh Foulad Gostaresh 30 36 32 39
10 Padideh Khorasan Padideh 30 30 35 39
11 Sepahan Sepahan 30 29 30 38
12 Foolad Khuzestan Foolad 30 26 37 35
13 Mashhad Mashhad 30 23 34 27
14 Malavan Malavan 30 23 35 27
15 Rah Ahan Rah Ahan 30 24 36 25
16 Esteghlal Ahvaz Esteghlal 30 16 58 13
TEMPORADA 2014/2015
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Sepahan Sepahan 30 46 27 59
2 Tractor Sazi Tractor Sazi 30 58 34 58
3 Naft Tehran Naft Tehran 30 44 29 57
4 Zob Ahan Zob Ahan 30 46 26 52
5 Foolad Khuzestan Foolad 30 33 24 52
6 FC Esteghlal Esteghlal 30 40 34 47
7 Saipa Saipa 30 36 34 41
8 Persepolis Persepolis 30 31 35 36
9 Saba Qom Saba Qom 30 25 34 34
10 Padideh Khorasan Padideh 30 23 25 33
11 Gostaresh Foulad Gostaresh 30 30 39 31
12 Rah Ahan Rah Ahan 30 27 48 31
13 Malavan Malavan 30 26 34 30
14 Paykan Paykan 30 17 28 28
15 Esteghlal Khuzestan Esteghlal 30 35 46 27
16 Naft Masjed Soleyman Naft Masjed 30 19 39 22
TEMPORADA 2013/2014
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Foolad Khuzestan Foolad 30 36 24 57
2 Persepolis Persepolis 30 34 15 56
3 Naft Tehran Naft Tehran 30 39 23 54
4 Sepahan Sepahan 30 36 20 54
5 FC Esteghlal Esteghlal 30 33 25 52
6 Tractor Sazi Tractor Sazi 30 39 33 46
7 Malavan Malavan 30 40 33 45
8 Saipa Saipa 30 26 31 35
9 Gostaresh Foulad Gostaresh 30 31 33 33
10 Saba Qom Saba Qom 30 32 38 33
11 Rah Ahan Rah Ahan 30 25 34 31
12 Esteghlal Khuzestan Esteghlal 30 26 37 29
13 Zob Ahan Zob Ahan 30 24 36 29
14 Fajr Sepasi Fajr Sepasi 30 20 34 29
15 Damash Gilan Damash Gilan 30 30 40 27
16 Mes Kerman Mes Kerman 30 21 36 22
TEMPORADA 2012/2013
LIGA IRÁN
Equipo PJ GF GC Puntos
1 FC Esteghlal Esteghlal 34 42 18 67
2 Tractor Sazi Tractor Sazi 34 55 32 65
3 Sepahan Sepahan 34 60 33 64
4 Foolad Khuzestan Foolad 34 52 35 56
5 Naft Tehran Naft Tehran 34 42 29 55
6 Mes Kerman Mes Kerman 34 33 22 53
7 Persepolis Persepolis 34 41 31 50
8 Rah Ahan Rah Ahan 34 32 35 46
9 Saba Qom Saba Qom 34 37 33 45
10 Saipa Saipa 34 37 33 45
11 Damash Gilan Damash Gilan 34 36 43 43
12 Fajr Sepasi Fajr Sepasi 34 42 38 42
13 Malavan Malavan 34 34 39 40
14 Zob Ahan Zob Ahan 34 36 40 38
15 Aluminium Hormozgan Aluminium 34 26 40 35
16 Naft Abadan Naft Abadan 34 31 60 25
17 Paykan Paykan 34 26 66 25
18 Gahar Zagros Gahar Zagros 34 24 59 19
TEMPORADA 2011/2012
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Sepahan Sepahan 34 54 27 67
2 Tractor Sazi Tractor Sazi 34 57 32 66
3 FC Esteghlal Esteghlal 34 58 34 66
4 Saba Qom Saba Qom 34 40 38 50
5 Naft Tehran Naft Tehran 34 36 38 49
6 Zob Ahan Zob Ahan 34 29 33 45
7 Damash Gilan Damash Gilan 34 34 38 44
8 Saipa Saipa 34 50 39 43
9 Mes Kerman Mes Kerman 34 35 39 43
10 Naft Abadan Naft Abadan 34 49 57 43
11 Rah Ahan Rah Ahan 34 43 42 42
12 Persepolis Persepolis 34 50 54 42
13 Fajr Sepasi Fajr Sepasi 34 31 38 41
14 Foolad Khuzestan Foolad 34 35 37 40
15 Malavan Malavan 34 32 33 39
16 Elmoadab Tabriz Elmoadab 34 34 44 34
17 Shahin Bushehr Shahin 34 30 43 33
18 Mes Sarcheshme Sarcheshme 34 23 54 24
TEMPORADA 2010/2011
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Sepahan Sepahan 34 56 29 66
2 FC Esteghlal Esteghlal 34 55 34 65
3 Zob Ahan Zob Ahan 34 49 31 63
4 Persepolis Persepolis 34 50 36 58
5 Tractor Sazi Tractor Sazi 34 42 29 57
6 Foolad Khuzestan Foolad 34 58 36 54
7 Mes Kerman Mes Kerman 34 41 30 52
8 Malavan Malavan 34 33 32 48
9 Naft Abadan Naft Abadan 34 36 54 42
10 Saba Qom Saba Qom 34 39 40 41
11 Saipa Saipa 34 42 47 37
12 Elmoadab Tabriz Elmoadab 34 45 53 37
13 Naft Tehran Naft Tehran 34 38 44 36
14 Shahin Bushehr Shahin 34 31 37 35
15 Rah Ahan Rah Ahan 34 29 39 35
16 Pas Hamedan Pas Hamedan 34 30 48 35
17 Paykan Paykan 34 38 60 33
18 Steel Azin Steel Azin 34 30 63 28
TEMPORADA 2009/2010
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Sepahan Sepahan 34 67 30 67
2 Zob Ahan Zob Ahan 34 48 29 61
3 FC Esteghlal Esteghlal 34 49 32 59
4 Persepolis Persepolis 34 46 40 53
5 Steel Azin Steel Azin 34 55 49 52
6 Saba Qom Saba Qom 34 52 45 48
7 Tractor Sazi Tractor Sazi 34 43 42 47
8 Saipa Saipa 34 48 53 46
9 Mes Kerman Mes Kerman 34 55 56 42
10 Foolad Khuzestan Foolad 34 31 34 42
11 Paykan Paykan 34 40 44 41
12 Malavan Malavan 34 31 47 41
13 Shahin Bushehr Shahin 34 37 37 39
14 Pas Hamedan Pas Hamedan 34 36 44 38
15 Sorinet Sorinet 34 36 44 38
16 Fajr Sepasi Fajr Sepasi 34 34 45 37
17 Aboomoslem Aboomoslem 34 36 51 32
18 Esteghlal Ahvaz Esteghlal 34 38 60 30
TEMPORADA 2008/2009
LIGA IRÁN
Equipo PJ GF GC Puntos
1 FC Esteghlal Esteghlal 34 70 34 66
2 Zob Ahan Zob Ahan 34 58 42 66
3 Mes Kerman Mes Kerman 34 54 36 61
4 Sepahan Sepahan 34 46 34 56
5 Persepolis Persepolis 34 50 41 55
6 Saba Qom Saba Qom 34 49 36 53
7 Foolad Khuzestan Foolad 34 50 41 50
8 Paykan Paykan 34 43 42 47
9 Fajr Sepasi Fajr Sepasi 34 33 37 44
10 Saipa Saipa 34 43 50 42
11 Rah Ahan Rah Ahan 34 35 41 41
12 Pas Hamedan Pas Hamedan 34 40 47 40
13 Malavan Malavan 34 31 43 40
14 Esteghlal Ahvaz Esteghlal 34 37 54 37
15 Aboomoslem Aboomoslem 34 34 41 35
16 Payam Mashhad Payam 34 33 52 35
17 Damash Gilan Damash Gilan 34 40 56 31
18 Bargh Shiraz Bargh Shiraz 34 35 54 24
TEMPORADA 2007/2008
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 34 57 32 62
2 Sepahan Sepahan 34 53 38 58
3 Saba Qom Saba Qom 34 40 37 52
4 Aboomoslem Aboomoslem 34 37 37 50
5 Pas Hamedan Pas Hamedan 34 36 28 49
6 Saipa Saipa 34 32 33 48
7 Bargh Shiraz Bargh Shiraz 34 43 47 47
8 Esteghlal Ahvaz Esteghlal 34 61 51 46
9 Paykan Paykan 34 41 40 46
10 Zob Ahan Zob Ahan 34 37 34 45
11 FC Esteghlal Esteghlal 34 44 44 43
12 Rah Ahan Rah Ahan 34 44 41 42
13 Mes Kerman Mes Kerman 34 35 35 42
14 Fajr Sepasi Fajr Sepasi 34 35 41 42
15 Pegah Gilan Pegah Gilan 34 26 35 38
16 Naft Abadan Naft Abadan 34 38 45 36
17 Malavan Malavan 34 32 40 36
18 Shirin-Faraz Shirin-Faraz 34 24 57 21
TEMPORADA 2006/2007
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Saipa Saipa 30 45 31 56
2 Esteghlal Ahvaz Esteghlal 30 33 28 54
3 Persepolis Persepolis 30 49 33 53
4 FC Esteghlal Esteghlal 30 39 30 52
5 Sepahan Sepahan 30 41 28 49
6 Aboomoslem Aboomoslem 30 40 36 43
7 Paykan Paykan 30 37 42 41
8 Zob Ahan Zob Ahan 30 39 42 39
9 Mes Kerman Mes Kerman 30 35 39 36
10 Fajr Sepasi Fajr Sepasi 30 29 32 34
11 Pas Tehran Pas Tehran 30 36 36 33
12 Bargh Shiraz Bargh Shiraz 30 35 45 33
13 Saba Qom Saba Qom 30 28 31 32
14 Malavan Malavan 30 21 30 32
15 Foolad Khuzestan Foolad 30 24 33 28
16 Rah Ahan Rah Ahan 30 30 45 20
TEMPORADA 2005/2006
LIGA IRÁN
Equipo PJ GF GC Puntos
1 FC Esteghlal Esteghlal 30 44 17 59
2 Pas Hamedan Pas Hamedan 30 54 29 58
3 Saipa Saipa 30 40 20 52
4 Saba Qom Saba Qom 30 35 31 50
5 Aboomoslem Aboomoslem 30 30 22 46
6 Zob Ahan Zob Ahan 30 41 30 45
7 Sepahan Sepahan 30 37 30 43
8 Foolad Khuzestan Foolad 30 30 41 41
9 Persepolis Persepolis 30 39 40 38
10 Fajr Sepasi Fajr Sepasi 30 27 33 36
11 Malavan Malavan 30 29 38 36
12 Esteghlal Ahvaz Esteghlal 30 42 44 35
13 Rah Ahan Rah Ahan 30 25 41 34
14 Bargh Shiraz Bargh Shiraz 30 23 37 28
15 Shemushack Noshahr Shemushack 30 18 39 23
16 Ghandi Ghandi 30 21 43 19
TEMPORADA 2004/2005
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Foolad Khuzestan Foolad 30 41 20 64
2 Zob Ahan Zob Ahan 30 38 19 58
3 FC Esteghlal Esteghlal 30 51 35 58
4 Persepolis Persepolis 30 43 26 55
5 Esteghlal Ahvaz Esteghlal 30 41 35 44
6 Pas Hamedan Pas Hamedan 30 48 40 42
7 Malavan Malavan 30 34 27 41
8 Aboomoslem Aboomoslem 30 33 33 38
9 Saba Qom Saba Qom 30 38 40 35
10 Sepahan Sepahan 30 30 33 35
11 Fajr Sepasi Fajr Sepasi 30 24 32 35
12 Bargh Shiraz Bargh Shiraz 30 34 43 33
13 Saipa Saipa 30 24 34 31
14 Shemushack Noshahr Shemushack 30 27 49 31
15 Paykan Paykan 30 22 34 24
16 Damash Gilan Damash Gilan 30 17 45 20

  USO DE MEMORIA  
8,020,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.8111
Total Execution Time  0.8123
  CADENA URL  
/historico/Sepahan
  GET DATOS  
$_GET['/historico/Sepahan']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0169  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 = 'Sepahan' 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.0146  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=2306 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=2306 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=2306 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2306 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2306 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2306 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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 = 74793
0.0151  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 = 73681
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2306 AND type_rel = 2
0.0145  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2306 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (63012,86374,623750,1282528) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '2306' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '2306' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0145  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 = 73681 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=2306 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (75135,74793,72290,71432) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 72290 AND teamId = 2306
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 74793 AND teamId = 2306
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 75135 AND teamId = 2306
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2306
0.0158  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 = 72290 WHERE rp.league_id = 72290 AND rp.teamId = 2306 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.0161  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 = 72290 WHERE rp.league_id = 72290 AND rp.teamId = 2306 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 = 72290 WHERE rp.league_id = 72290 AND rp.teamId = 2306 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 = 2306 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0163  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 = 72290 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 68696 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.0167  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 = 65392 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.0162  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 = 60078 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.0163  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 = 50109 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.0165  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 = 43571 AND t.round = 30 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 `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 = 38851 AND t.round = 30 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 `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 = 33437 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 15500 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 4191 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 2046 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 3196 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 `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 = 1588 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 = 1589 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 `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 = 1065 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 `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 = 266 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 = 10597 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 `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 = 10598 AND t.round = 30 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 `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 = 16147 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 16148 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC