4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tractor Sazi
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
SEGUNDA IRÁN GRUPO 2
Equipo PJ GF GC Puntos
1 Tractor Sazi Tractor Sazi 26 41 18 54
2 Shahin Bushehr Shahin 26 33 20 53
3 Mes Rafsanjan Rafsanjan 26 42 20 46
4 Gahar Zagros Gahar Zagros 26 26 19 40
5 Tarbiat Novin Yazd Tarbiat 26 32 26 38
6 Niroye Zamini Niroye 26 25 19 38
7 Rahian Kermanshah Rahian 26 30 25 36
8 Payam Mokhaberat Payam 26 33 30 34
9 Etka Gorgan FC Etka Gorgan 26 37 30 33
10 Aluminium Hormozgan Aluminium 26 30 24 33
11 Shemushack Noshahr Shemushack 26 20 25 27
12 Shahin Ahvaz Shahin Ahvaz 26 20 55 21
13 Machine Sazi Machine Sazi 26 21 49 20
14 Deyhim Ahvaz Deyhim Ahvaz 26 20 50 18
TEMPORADA 2007/2008
SEGUNDA IRÁN GRUPO 1
Equipo PJ GF GC Puntos
1 Steel Azin Steel Azin 22 41 28 38
2 Payam Mashhad Payam 22 29 21 38
3 Niroye Zamini Niroye 22 26 19 37
4 Sorkhpoushan Sorkhpoushan 22 19 19 32
5 Tractor Sazi Tractor Sazi 22 23 19 31
6 Gol Gohar Sirjan Gohar Sirjan 22 26 24 31
7 Shahrdari Bandar Abbas Shahrdari 22 26 21 29
8 Gahar Zagros Gahar Zagros 22 24 26 28
9 Shahdari Zanjan Shahdari 22 18 18 26
10 Moghavemat Mersad Moghavemat 22 22 25 26
11 Shemushack Noshahr Shemushack 22 19 28 25
12 Shahin Ahvaz Shahin Ahvaz 22 20 45 14
TEMPORADA 2001/2002
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 26 36 23 49
2 FC Esteghlal Esteghlal 26 38 21 48
3 Foolad Khuzestan Foolad 26 32 23 45
4 Pas Tehran Pas Tehran 26 39 24 43
5 Aboomoslem Aboomoslem 26 40 31 40
6 Zob Ahan Zob Ahan 26 30 25 39
7 Paykan Paykan 26 28 22 38
8 Bargh Shiraz Bargh Shiraz 26 28 25 37
9 Sepahan Sepahan 26 22 22 32
10 Fajr Sepasi Fajr Sepasi 26 15 20 27
11 Saipa Saipa 26 24 30 27
12 Malavan Malavan 26 20 36 27
13 Sepidrood Rasht Sepidrood 26 18 44 16
14 Tractor Sazi Tractor Sazi 26 12 36 15
TEMPORADA 2000/2001
LIGA IRÁN
Equipo PJ GF GC Puntos
1 FC Esteghlal Esteghlal 22 52 21 50
2 Persepolis Persepolis 22 36 16 46
3 Saipa Saipa 22 29 27 33
4 Zob Ahan Zob Ahan 22 30 22 30
5 Paykan Paykan 22 19 29 28
6 Pas Tehran Pas Tehran 22 25 23 27
7 Sepahan Sepahan 22 19 23 26
8 Foolad Khuzestan Foolad 22 23 27 25
9 Fajr Sepasi Fajr Sepasi 22 20 25 24
10 Sepidrood Rasht Sepidrood 22 23 43 24
11 Bargh Shiraz Bargh Shiraz 22 23 26 21
12 Tractor Sazi Tractor Sazi 22 18 35 17

  USO DE MEMORIA  
7,712,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  2.8451
Total Execution Time  2.8466
  CADENA URL  
/historico/Tractor-Sazi
  GET DATOS  
$_GET['/historico/Tractor-Sazi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0042  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 = 72329
0.0027  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4519 AND type_rel = 2
1.9957  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4519 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0420  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 (443874,489981,508946,585541,691802) ORDER BY n.cover_points DESC, update_date DESC
0.0853  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 = '4519' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0033  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 = 72329 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0169  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.0077  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.0605  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=4519 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0042  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,72329,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.0533  SELECT count(id) as num_players from rel_players WHERE league_id = 72290 AND teamId = 4519
0.0504  SELECT count(id) as num_players from rel_players WHERE league_id = 72329 AND teamId = 4519
0.0423  SELECT count(id) as num_players from rel_players WHERE league_id = 75135 AND teamId = 4519
0.0445  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4519
0.0042  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 = '4519' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0062  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4519' and rp.type = 4
0.0024  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 = '4519' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0476  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 = 4519 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.0529  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 = 4519 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0265  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 = 4519 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0377  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 = 4519 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.0066  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.0100  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.0109  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.0096  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.0122  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.0088  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.0125  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.0118  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.0124  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.0095  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.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 `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.0089  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.0093  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 = 16163 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0056  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 = 16165 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0094  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 27692 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  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 `tables2001` 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 = 27696 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC