4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al-Hazem SC

Al-Hazem SC

Entrenador: Daniel Carreño

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 28 86 18 80
2 Al-Nassr Al-Nassr 29 84 35 71
3 Al-Ahli SFC Al-Ahli SFC 28 54 30 52
4 Al-Taawoun Al-Taawoun 29 48 31 51
5 Al-Ittihad Al-Ittihad 29 55 40 50
6 Al-Ettifaq Al-Ettifaq 29 35 30 41
7 Al-Fateh SC Al-Fateh SC 29 48 44 40
8 Damac FC Damac FC 29 40 35 38
9 Al-Shabab Al-Shabab 29 39 36 38
10 Al-Fayha Al-Fayha 29 38 46 38
11 Al-Khaleej Al-Khaleej 29 32 40 35
12 Al-Wehda Al-Wehda 29 41 49 32
13 Al-Raed Al-Raed 29 38 45 31
14 Al-Riyadh SC Al-Riyadh 29 26 51 28
15 Al-Okhdood Al-Okhdood 29 27 47 27
16 Al-Tai SC Al-Tai SC 29 29 57 26
17 Abha Abha 29 31 78 25
18 Al-Hazem SC Al-Hazem SC 29 29 68 19
TEMPORADA 2022/2023
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Ahli SFC Al-Ahli SFC 34 48 24 72
2 Al-Okhdood Al-Okhdood 34 65 35 68
3 Al-Hazem SC Al-Hazem SC 34 55 29 68
4 Al-Riyadh SC Al-Riyadh 34 52 37 63
5 Al-Faisaly FC Al-Faisaly 34 45 32 58
6 Al-Arabi SC Al-Arabi SC 34 43 43 49
7 Al-Kholood Al-Kholood 34 33 31 43
8 Hajer FC Hajer FC 34 36 41 43
9 Ohod Ohod 34 29 38 42
10 Al-Jabalain FC Al-Jabalain 34 42 43 41
11 Al-Orubah FC Al-Orubah 34 35 41 40
12 Al Qadsiah FC Qadsiah 34 29 34 40
13 Al-Qaisumah FC Al-Qaisumah 34 35 44 40
14 Al-Ain FC Al-Ain FC 34 34 46 39
15 Jeddah Club Jeddah Club 34 34 40 38
16 Najran Najran 34 36 55 36
17 Al-Sahel Al-Sahel 34 36 51 32
18 Al-Shoalah FC Al-Shoalah 34 23 46 23
TEMPORADA 2021/2022
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 30 63 28 67
2 Al-Ittihad Al-Ittihad 30 62 29 65
3 Al-Nassr Al-Nassr 30 58 36 61
4 Al-Shabab Al-Shabab 30 52 36 55
5 Damac FC Damac FC 30 38 44 44
6 Al-Tai SC Al-Tai SC 30 33 45 37
7 Al-Raed Al-Raed 30 35 45 36
8 Al-Fateh SC Al-Fateh SC 30 45 41 35
9 Abha Abha 30 27 43 35
10 Al-Fayha Al-Fayha 30 21 24 35
11 Al-Ettifaq Al-Ettifaq 30 40 47 34
12 Al-Taawoun Al-Taawoun 30 43 48 34
13 Al-Batin Al-Batin 30 31 41 33
14 Al-Faisaly FC Al-Faisaly 30 28 37 33
15 Al-Ahli SFC Al-Ahli SFC 30 38 43 32
16 Al-Hazem SC Al-Hazem SC 30 23 50 17
TEMPORADA 2020/2021
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hazem SC Al-Hazem SC 38 77 27 91
2 Al-Fayha Al-Fayha 38 72 27 81
3 Al-Tai SC Al-Tai SC 38 58 33 77
4 Al-Jabalain FC Al-Jabalain 38 53 27 76
5 Hajer FC Hajer FC 38 49 37 55
6 Ohod Ohod 38 51 52 54
7 Al-Khaleej Al-Khaleej 38 42 47 52
8 Al-Shoalah FC Al-Shoalah 38 37 33 51
9 Jeddah Club Jeddah Club 38 49 53 51
10 Al-Kawkab Al-Kawkab 38 46 49 49
11 Al-Diriyah Al-Diriyah 38 34 39 48
12 Al-Adalah Club Al-Adalah 38 44 39 46
13 Al-Sahel Al-Sahel 38 34 48 46
14 Al Jeel Al Jeel 38 37 52 44
15 Najran Najran 38 43 47 43
16 Al-Nahdha Al-Nahdha 38 37 45 42
17 Al Bukayriyah Bukayriyah 38 29 48 40
18 Al-Thqba Al-Thqba 38 45 60 37
19 Arar Arar 38 28 62 26
20 Al Najoom Al Najoom 38 27 67 23
TEMPORADA 2019/2020
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 30 74 26 72
2 Al-Nassr Al-Nassr 30 60 26 64
3 Al-Ahli SFC Al-Ahli SFC 30 49 36 50
4 Al-Wehda Al-Wehda 30 45 40 49
5 Al-Faisaly FC Al-Faisaly 30 41 36 48
6 Al-Raed Al-Raed 30 41 50 46
7 Al-Shabab Al-Shabab 30 38 37 43
8 Al-Ettifaq Al-Ettifaq 30 46 38 42
9 Abha Abha 30 41 52 38
10 Damac FC Damac FC 30 37 52 35
11 Al-Ittihad Al-Ittihad 30 42 41 35
12 Al-Taawoun Al-Taawoun 30 33 40 35
13 Al-Fateh SC Al-Fateh SC 30 42 49 33
14 Al-Fayha Al-Fayha 30 34 44 32
15 Al-Hazem SC Al-Hazem SC 30 40 61 27
16 Al-Adalah Club Al-Adalah 30 27 62 21
TEMPORADA 2018/2019
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Nassr Al-Nassr 30 69 27 70
2 Al-Hilal SFC Al-Hilal 30 66 33 69
3 Al-Taawoun Al-Taawoun 30 61 31 56
4 Al-Ahli SFC Al-Ahli SFC 30 68 41 55
5 Al-Shabab Al-Shabab 30 39 25 54
6 Al-Faisaly FC Al-Faisaly 30 51 47 43
7 Al-Wehda Al-Wehda 30 41 41 42
8 Al-Raed Al-Raed 30 38 48 38
9 Al-Fateh SC Al-Fateh SC 30 32 45 35
10 Al-Ittihad Al-Ittihad 30 44 45 34
11 Al-Ettifaq Al-Ettifaq 30 40 55 33
12 Al-Fayha Al-Fayha 30 36 52 32
13 Al-Hazem SC Al-Hazem SC 30 33 50 31
14 Al Qadsiah FC Qadsiah 30 34 51 28
15 Al-Batin Al-Batin 30 29 53 25
16 Ohod Ohod 30 25 62 21
TEMPORADA 2017/2018
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Wehda Al-Wehda 30 49 32 58
2 Al-Hazem SC Al-Hazem SC 30 50 32 53
3 Al-Tai SC Al-Tai SC 30 52 35 52
4 Al-Kawkab Al-Kawkab 30 52 33 50
5 Hajer FC Hajer FC 30 39 35 50
6 Al-Shoalah FC Al-Shoalah 30 42 43 43
7 Al-Khaleej Al-Khaleej 30 45 40 41
8 Al-Qaisumah FC Al-Qaisumah 30 52 54 40
9 Damac FC Damac FC 30 49 43 39
10 Al-Orubah FC Al-Orubah 30 36 39 38
11 Al-Nahdha Al-Nahdha 30 35 50 35
12 Al Najoom Al Najoom 30 34 41 33
13 Al Mojzel Al Mojzel 30 39 52 33
14 Najran Najran 30 39 51 33
15 Al Watani Al Watani 30 33 48 27
16 Jeddah Club Jeddah Club 30 43 61 25
TEMPORADA 2016/2017
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Fayha Al-Fayha 30 50 35 50
2 Ohod Ohod 30 42 30 48
3 Al-Nahdha Al-Nahdha 30 38 32 46
4 Najran Najran 30 38 34 46
5 Al-Qaisumah FC Al-Qaisumah 30 44 50 41
6 Al-Shoalah FC Al-Shoalah 30 35 33 41
7 Al-Orubah FC Al-Orubah 30 34 32 41
8 Damac FC Damac FC 30 33 39 40
9 Hajer FC Hajer FC 30 38 36 40
10 Al Najoom Al Najoom 30 39 37 39
11 Al-Hazem SC Al-Hazem SC 30 36 30 38
12 Al-Tai SC Al-Tai SC 30 34 42 37
13 Al Watani Al Watani 30 27 37 37
14 Al-Adalah Club Al-Adalah 30 31 41 36
15 Al Jeel Al Jeel 30 45 46 34
16 Wajj Wajj 30 37 47 30
TEMPORADA 2015/2016
PRIMERA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Ettifaq Al-Ettifaq 31 47 22 55
2 Al-Batin Al-Batin 31 50 32 54
3 Al Mojzel Al Mojzel 30 46 32 54
4 Al-Orubah FC Al-Orubah 30 49 32 51
5 Al Jeel Al Jeel 32 46 42 48
6 Damac FC Damac FC 31 36 34 46
7 Al-Shoalah FC Al-Shoalah 30 33 33 43
8 Al-Tai SC Al-Tai SC 30 38 36 42
9 Ohod Ohod 30 29 33 37
10 Al-Fayha Al-Fayha 30 33 41 37
11 Al Watani Al Watani 30 29 29 36
12 Al Najoom Al Najoom 31 35 40 35
13 Al-Hazem SC Al-Hazem SC 30 32 42 33
14 Al-Nahdha Al-Nahdha 30 35 46 32
15 Al-Riyadh SC Al-Riyadh 30 34 44 28
16 Al-Diriyah Al-Diriyah 30 22 56 14
TEMPORADA 2014/2015
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al Qadsiah FC Qadsiah 30 49 21 63
2 Al-Wehda Al-Wehda 30 60 27 62
3 Al-Nahdha Al-Nahdha 30 50 31 61
4 Al-Ettifaq Al-Ettifaq 30 50 32 52
5 Al-Tai SC Al-Tai SC 30 47 42 49
6 Al Jeel Al Jeel 30 42 40 42
7 Al Watani Al Watani 30 35 31 40
8 Al-Riyadh SC Al-Riyadh 30 41 44 40
9 Al-Hazem SC Al-Hazem SC 30 42 42 39
10 Al-Batin Al-Batin 30 37 34 36
11 Al-Fayha Al-Fayha 30 30 42 34
12 Al Mojzel Al Mojzel 30 35 43 32
13 Al-Diriyah Al-Diriyah 30 29 54 30
14 Al-Safa Al-Safa 30 29 46 29
15 Abha Abha 30 36 56 25
16 Hottain Hottain 30 25 52 20
TEMPORADA 2013/2014
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Hajer FC Hajer FC 30 45 28 57
2 Al-Khaleej Al-Khaleej 30 57 27 55
3 Al-Wehda Al-Wehda 30 48 28 52
4 Al-Tai SC Al-Tai SC 30 35 29 46
5 Al-Riyadh SC Al-Riyadh 30 52 44 45
6 Al Qadsiah FC Qadsiah 30 31 23 45
7 Al-Hazem SC Al-Hazem SC 30 37 35 44
8 Al-Diriyah Al-Diriyah 30 42 43 41
9 Al-Batin Al-Batin 30 39 38 40
10 Abha Abha 30 41 40 39
11 Al Jeel Al Jeel 30 37 42 38
12 Al Watani Al Watani 30 36 41 35
13 Hottain Hottain 30 35 56 30
14 Ohod Ohod 30 35 51 28
15 Al-Ansar FC Al-Ansar FC 30 27 50 27
16 Al-Kawkab Al-Kawkab 30 39 61 24
TEMPORADA 2012/2013
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Orubah FC Al-Orubah 30 51 30 59
2 Al-Nahdha Al-Nahdha 30 50 32 55
3 Al-Khaleej Al-Khaleej 30 49 37 55
4 Al-Riyadh SC Al-Riyadh 30 40 30 55
5 Al Qadsiah FC Qadsiah 30 43 32 45
6 Hottain Hottain 30 52 44 43
7 Al-Tai SC Al-Tai SC 30 42 40 42
8 Abha Abha 30 40 45 41
9 Al-Ansar FC Al-Ansar FC 30 33 37 38
10 Al-Batin Al-Batin 30 42 41 36
11 Al Watani Al Watani 30 34 44 36
12 Al-Hazem SC Al-Hazem SC 30 30 38 35
13 Al Jeel Al Jeel 30 36 42 34
14 Sdoos Club Sdoos Club 30 37 43 30
15 Al-Najma FC Al-Najma FC 30 28 47 29
16 Jeddah Club Jeddah Club 30 28 53 25
TEMPORADA 2011/2012
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Shoalah FC Al-Shoalah 30 48 34 55
2 Al-Wehda Al-Wehda 30 59 37 54
3 Al-Nahdha Al-Nahdha 30 39 24 52
4 Abha Abha 30 36 28 49
5 Al-Hazem SC Al-Hazem SC 30 39 28 48
6 Al-Tai SC Al-Tai SC 30 42 26 47
7 Al Jeel Al Jeel 30 32 28 47
8 Al-Khaleej Al-Khaleej 30 41 41 43
9 Hottain Hottain 30 53 52 38
10 Al-Orubah FC Al-Orubah 30 24 38 37
11 Al Watani Al Watani 30 31 45 36
12 Al-Riyadh SC Al-Riyadh 30 27 23 34
13 Al-Batin Al-Batin 30 39 50 34
14 Ohod Ohod 30 30 42 28
15 Damac FC Damac FC 30 33 51 26
16 Al Suqoor Al Suqoor 30 28 54 23
TEMPORADA 2010/2011
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 26 52 18 64
2 Al-Ittihad Al-Ittihad 26 49 23 51
3 Al-Ettifaq Al-Ettifaq 26 45 30 48
4 Al-Shabab Al-Shabab 26 42 30 46
5 Al-Nassr Al-Nassr 26 44 34 43
6 Al-Ahli SFC Al-Ahli SFC 26 48 41 37
7 Al-Faisaly FC Al-Faisaly 26 39 47 35
8 Al-Taawoun Al-Taawoun 26 37 31 32
9 Al-Fateh SC Al-Fateh SC 26 27 35 31
10 Al-Raed Al-Raed 26 31 40 30
11 Najran Najran 26 33 52 26
12 Al Qadsiah FC Qadsiah 26 31 39 23
13 Al-Wehda Al-Wehda 26 43 44 21
14 Al-Hazem SC Al-Hazem SC 26 13 70 6
TEMPORADA 2009/2010
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 22 56 18 56
2 Al-Ittihad Al-Ittihad 22 46 30 45
3 Al-Nassr Al-Nassr 22 38 23 43
4 Al-Shabab Al-Shabab 22 36 23 40
5 Al-Wehda Al-Wehda 22 34 27 28
6 Al-Ahli SFC Al-Ahli SFC 22 28 29 28
7 Al-Hazem SC Al-Hazem SC 22 29 38 24
8 Al-Fateh SC Al-Fateh SC 22 26 38 24
9 Al-Ettifaq Al-Ettifaq 22 24 30 22
10 Al Qadsiah FC Qadsiah 22 20 40 20
11 Al-Raed Al-Raed 22 18 35 16
12 Najran Najran 22 22 46 16
TEMPORADA 2008/2009
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Ittihad Al-Ittihad 22 57 21 55
2 Al-Hilal SFC Al-Hilal 22 41 9 50
3 Al-Ahli SFC Al-Ahli SFC 22 33 20 40
4 Al-Shabab Al-Shabab 22 37 29 35
5 Al-Nassr Al-Nassr 22 24 22 34
6 Al-Ettifaq Al-Ettifaq 22 23 20 29
7 Al-Wehda Al-Wehda 22 33 39 26
8 Al-Hazem SC Al-Hazem SC 22 25 31 25
9 Najran Najran 22 22 42 21
10 Al-Raed Al-Raed 22 28 43 19
11 Abha Abha 22 19 40 19
12 Al Watani Al Watani 22 22 48 12
TEMPORADA 2007/2008
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Ittihad Al-Ittihad 22 39 16 48
2 Al-Hilal SFC Al-Hilal 22 36 13 48
3 Al-Shabab Al-Shabab 22 39 21 42
4 Al-Ettifaq Al-Ettifaq 22 34 25 35
5 Al-Nassr Al-Nassr 22 34 35 33
6 Al-Wehda Al-Wehda 22 29 27 29
7 Al-Hazem SC Al-Hazem SC 22 25 27 27
8 Al-Ahli SFC Al-Ahli SFC 22 30 31 26
9 Al Watani Al Watani 22 20 32 25
10 Najran Najran 22 29 44 21
11 Al-Tai SC Al-Tai SC 22 20 37 13
12 Al Qadsiah FC Qadsiah 22 17 44 12
TEMPORADA 2006/2007
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 22 38 15 53
2 Al-Ittihad Al-Ittihad 22 52 25 48
3 Al-Wehda Al-Wehda 22 41 25 47
4 Al-Shabab Al-Shabab 22 45 27 44
5 Al-Ahli SFC Al-Ahli SFC 22 29 33 29
6 Al-Ettifaq Al-Ettifaq 22 34 34 25
7 Al-Tai SC Al-Tai SC 22 32 37 23
8 Al-Hazem SC Al-Hazem SC 22 28 38 21
9 Al-Nassr Al-Nassr 22 24 37 21
10 Al Qadsiah FC Qadsiah 22 22 36 20
11 Al-Faisaly FC Al-Faisaly 22 23 42 18
12 Al-Khaleej Al-Khaleej 22 21 40 18
TEMPORADA 2005/2006
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Shabab Al-Shabab 22 47 22 45
2 Al-Hilal SFC Al-Hilal 22 41 21 44
3 Al-Ittihad Al-Ittihad 22 47 27 42
4 Al-Ahli SFC Al-Ahli SFC 22 44 23 36
5 Al-Ettifaq Al-Ettifaq 22 31 25 33
6 Al-Nassr Al-Nassr 22 32 32 30
7 Al-Hazem SC Al-Hazem SC 22 32 37 29
8 Al Qadsiah FC Qadsiah 22 23 32 29
9 Al-Wehda Al-Wehda 22 35 37 28
10 Al-Tai SC Al-Tai SC 22 24 37 18
11 Abha Abha 22 23 57 13
12 Al-Ansar FC Al-Ansar FC 22 16 45 9

  USO DE MEMORIA  
7,498,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7710
Total Execution Time  0.7722
  CADENA URL  
/historico/Al-Hazm-Rass
  GET DATOS  
$_GET['/historico/Al-Hazm-Rass']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0158  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 = 'Al-Hazm-Rass' 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.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=108 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=108 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=108 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=108 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294  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 = 73198
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=108 AND type_rel = 2
0.0151  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 108 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0153  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 (488407,781601,1194221,1268409,1276340) ORDER BY n.cover_points DESC, update_date DESC
0.0168  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 = '108' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0168  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 = '108' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0160  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 = 73198 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0177  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=108 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0156  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 (73198,72207,71432,68577) 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.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 72207 AND teamId = 108
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 68577 AND teamId = 108
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 73198 AND teamId = 108
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 108
0.0157  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 = 72207 WHERE rp.league_id = 72207 AND rp.teamId = 108 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.0155  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 = 72207 WHERE rp.league_id = 72207 AND rp.teamId = 108 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 72207 WHERE rp.league_id = 72207 AND rp.teamId = 108 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 108 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72207 AND t.round = 29 ORDER BY team.conference ASC,t.position 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 `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 = 68577 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.0164  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 = 63430 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.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 `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 = 59698 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 `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 = 50041 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.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 `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 = 43671 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 `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 = 39088 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 `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 = 33686 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 `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 = 15470 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 `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 = 3878 AND t.round = 30 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 `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 = 3553 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 `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 = 8881 AND t.round = 30 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 `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 = 8880 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 1593 AND t.round = 26 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 `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 = 1054 AND t.round = 22 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 = 1053 AND t.round = 22 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 = 270 AND t.round = 22 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 `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 = 8870 AND t.round = 22 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 `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 = 8868 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC