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

Paykan

Entrenador: Gholamreza Enayati

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
SEGUNDA IRÁN
Equipo PJ GF GC Puntos
1 Paykan Paykan 38 50 29 70
2 Naft Abadan Naft Abadan 38 52 38 63
3 Machine Sazi Machine Sazi 38 54 37 61
4 Fajr Sepasi Fajr Sepasi 38 40 28 61
5 Rayka Babol Rayka Babol 38 40 35 59
6 Mes Rafsanjan Rafsanjan 38 44 35 58
7 Nassaji Mazandaran FC Nassaji 38 39 40 53
8 Aluminium Arak Aluminium 38 48 41 52
9 Mes Kerman Mes Kerman 38 37 35 52
10 Arvand Khorramshahr Arvand 38 45 43 50
11 Naft Masjed Soleyman Naft Masjed 38 39 39 48
12 Gol Gohar Sirjan Gohar Sirjan 38 35 34 47
13 Foolad Yazd Foolad Yazd 38 31 38 44
14 Iranjavan FC Iranjavan 38 42 55 44
15 Parseh Tehran FC Parseh 38 44 47 42
16 Pas Hamedan Pas Hamedan 38 34 40 42
17 Shahrdari Ardabil Shahrdari 38 43 50 40
18 Giti Pasand Giti Pasand 38 26 41 39
19 Damash Gilan Damash Gilan 38 29 43 37
20 Aluminium Hormozgan Aluminium 38 30 54 31
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
SEGUNDA IRÁN GRUPO 2
Equipo PJ GF GC Puntos
1 Naft Masjed Soleyman Naft Masjed 24 31 22 43
2 Paykan Paykan 24 35 24 40
3 Parseh Tehran FC Parseh 24 27 21 39
4 Iranjavan FC Iranjavan 24 29 21 38
5 Mes Rafsanjan Rafsanjan 24 28 21 35
6 Aluminium Hormozgan Aluminium 24 28 20 31
7 Naft va Gaz Naft va Gaz 24 28 27 31
8 Rahian Kermanshah Rahian 24 23 29 31
9 Pas Hamedan Pas Hamedan 24 22 28 29
10 Tarbiat Novin Yazd Tarbiat 24 21 21 28
11 Al Badr Al Badr 24 21 30 25
12 Aboomoslem Aboomoslem 24 27 40 22
13 Persepolis Shomal Persepolis 24 26 42 19
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
SEGUNDA IRÁN GRUPO 1
Equipo PJ GF GC Puntos
1 Paykan Paykan 26 44 26 50
2 Iranjavan FC Iranjavan 26 31 16 48
3 Steel Azin Steel Azin 26 29 22 40
4 Shahrdari Bandar Abbas Shahrdari 26 26 27 38
5 Shahrdari Arak Shahrdari 26 19 17 37
6 Foolad Yazd Foolad Yazd 26 25 23 36
7 Aboomoslem Aboomoslem 26 21 18 34
8 Etka Gorgan FC Etka Gorgan 26 21 20 34
9 Persepolis Shomal Persepolis 26 26 26 33
10 Gostaresh Foulad Gostaresh 26 25 30 32
11 Parseh Tehran FC Parseh 26 20 29 28
12 Mes Rafsanjan Rafsanjan 26 22 28 26
13 Sanat Sari Sanat Sari 26 20 34 26
14 Payam Mokhaberat Payam 26 15 28 25
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 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
TEMPORADA 2003/2004
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Pas Hamedan Pas Hamedan 26 48 29 53
2 FC Esteghlal Esteghlal 26 46 31 51
3 Foolad Khuzestan Foolad 26 37 22 47
4 Zob Ahan Zob Ahan 26 32 25 40
5 Persepolis Persepolis 26 42 28 39
6 Sepahan Sepahan 26 47 36 39
7 Paykan Paykan 26 24 26 32
8 Esteghlal Ahvaz Esteghlal 26 35 43 31
9 Damash Gilan Damash Gilan 26 27 42 30
10 Aboomoslem Aboomoslem 26 25 26 29
11 Fajr Sepasi Fajr Sepasi 26 27 35 29
12 Bargh Shiraz Bargh Shiraz 26 27 47 24
13 Saipa Saipa 26 23 36 21
14 Shemushack Noshahr Shemushack 26 19 33 20

  USO DE MEMORIA  
7,748,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8061
Total Execution Time  0.8073
  CADENA URL  
/historico/Paykan
  GET DATOS  
$_GET['/historico/Paykan']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0296  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 = 72290
0.0156  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 = 75135
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4510 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 57 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (1312276,1312216,1311329,1284366,1235391) ORDER BY n.cover_points DESC, update_date DESC
0.0153  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 = '4510' 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 = '4510' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 75135 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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 = 72290 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=4510 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,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 = 4510
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 75135 AND teamId = 4510
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4510
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '4510' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4510' and rp.type = 4
0.0146  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 = '4510' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0163  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 = 4510 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.0173  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 = 4510 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 4510 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 4510 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.0158  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.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 = 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.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 `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.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 `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.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 `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.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 `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.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 `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 = 15619 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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.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 `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 = 2903 AND t.round = 26 ORDER BY team.conference 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 `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.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 = 16153 AND t.round = 26 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.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 `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.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 = 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.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 `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.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 = 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.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 `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
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 `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 = 16149 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72290 ORDER BY nameShow LIMIT 100