4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hottain
TEMPORADA 2023/2024
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al Suqoor Al Suqoor 30 68 29 68
2 Al-Zulfi Al-Zulfi 30 56 32 60
3 Al Jeel Al Jeel 30 50 34 53
4 Al Rawdhah Al Rawdhah 30 31 24 52
5 Al-Shoalah FC Al-Shoalah 30 45 37 48
6 Al-Washm Al-Washm 30 36 31 45
7 Najran Najran 30 50 41 42
8 Mudhar Mudhar 30 40 37 42
9 Al-Taqadom Al-Taqadom 30 38 39 41
10 Al-Kawkab Al-Kawkab 30 34 45 38
11 Al Entesar Al Entesar 30 37 54 34
12 Al-Lewaa Al-Lewaa 30 33 41 33
13 Al-Rayyan Al-Rayyan 30 37 48 31
14 Al Najoom Al Najoom 30 37 52 27
15 AFIF AFIF 30 31 51 21
16 Al Nairyah Al Nairyah 30 33 61 17
17 Al Jubail Al Jubail 30 49 25 65
18 Al Draih Al Draih 30 50 22 58
19 Jerash Jerash 30 50 34 57
20 Bisha Bisha 30 55 30 54
21 Al-Saqer Al-Saqer 30 37 30 49
22 Al-Sahel Al-Sahel 30 45 36 47
23 Wej SC Wej SC 30 35 39 42
24 Hottain Hottain 30 29 27 41
25 Arar Arar 30 26 41 40
26 Al Qous Al Qous 30 32 33 39
27 Alhowra FC Alhowra FC 30 34 44 33
28 Al Sadd Al Sadd 30 27 48 30
29 Al-Ansar FC Al-Ansar FC 30 33 43 29
30 Tuwaiq Tuwaiq 30 30 40 28
31 Al-Shoaib Al-Shoaib 30 24 36 25
32 Al-Noor Al-Noor 30 25 53 17
TEMPORADA 2022/2023
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al Taraji Al Taraji 30 48 32 56
2 Al Bukayriyah Bukayriyah 30 41 27 55
3 Al Jandal Al Jandal 30 58 44 50
4 Tuwaiq Tuwaiq 30 43 36 49
5 Al-Saqer Al-Saqer 30 36 27 47
6 Jerash Jerash 30 44 40 44
7 Arar Arar 30 35 31 42
8 Al Sadd Al Sadd 30 41 36 39
9 Al Draih Al Draih 30 28 31 38
10 Al Entesar Al Entesar 30 32 38 38
11 Al-Lewaa Al-Lewaa 30 31 36 35
12 Al-Taqadom Al-Taqadom 30 29 36 35
13 Hottain Hottain 30 32 39 32
14 Al Qous Al Qous 30 28 37 32
15 Qilwah Qilwah 30 25 42 28
16 Al-Nahdha Al-Nahdha 30 25 44 23
17 Al-Najma FC Al-Najma FC 30 46 22 64
18 Al-Safa Al-Safa 30 41 20 58
19 Bisha Bisha 30 41 21 55
20 Al-Kawkab Al-Kawkab 30 31 24 53
21 Al Nairyah Al Nairyah 30 42 32 47
22 Al-Zulfi Al-Zulfi 30 47 33 46
23 Al Rawdhah Al Rawdhah 30 43 29 44
24 Al Jeel Al Jeel 30 31 31 42
25 Al-Rayyan Al-Rayyan 30 32 36 36
26 Wej SC Wej SC 30 38 46 36
27 Al-Ansar FC Al-Ansar FC 30 32 46 31
28 Al-Washm Al-Washm 30 37 40 30
29 Al-Shoaib Al-Shoaib 30 28 46 28
30 Al Suqoor Al Suqoor 30 34 46 27
31 Al Sharq Al Sharq 30 26 46 26
32 Sajer Sajer 30 21 52 18
TEMPORADA 2021/2022
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Arabi SC Al-Arabi SC 26 42 16 57
2 Al-Riyadh SC Al-Riyadh 26 42 16 56
3 Al Entesar Al Entesar 26 40 26 38
4 Al Bukayriyah Bukayriyah 26 37 35 37
5 Al-Saqer Al-Saqer 26 26 26 35
6 Al Rawdhah Al Rawdhah 26 38 42 35
7 Al-Washm Al-Washm 26 31 34 32
8 Wej SC Wej SC 26 26 30 31
9 Tuwaiq Tuwaiq 26 23 32 30
10 Al-Lewaa Al-Lewaa 26 29 39 30
11 Al Sharq Al Sharq 26 28 32 27
12 Al Sadd Al Sadd 26 23 38 27
13 Al Dahab Al Dahab 26 24 31 26
14 Al Najoom Al Najoom 26 26 38 23
15 Al-Qaisumah FC Al-Qaisumah 26 39 23 54
16 Al Taraji Al Taraji 26 41 30 51
17 Al-Najma FC Al-Najma FC 26 47 28 49
18 Al-Zulfi Al-Zulfi 26 58 25 45
19 Al-Ansar FC Al-Ansar FC 26 38 33 38
20 Al-Taqadom Al-Taqadom 26 34 33 36
21 Hottain Hottain 26 28 35 36
22 Al Jandal Al Jandal 26 42 39 34
23 Al-Safa Al-Safa 26 22 28 34
24 Al-Rayyan Al-Rayyan 26 33 46 32
25 Arar Arar 26 38 50 27
26 Al Nairyah Al Nairyah 26 21 33 24
27 AFIF AFIF 26 33 42 23
28 Al-Thqba Al-Thqba 26 24 53 13
TEMPORADA 2020/2021
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Okhdood Al-Okhdood 26 42 22 53
2 Bisha Bisha 26 40 19 49
3 Al Jandal Al Jandal 26 35 22 48
4 Al-Qaisumah FC Al-Qaisumah 26 37 24 45
5 Al-Safa Al-Safa 26 31 32 34
6 Al Sadd Al Sadd 26 29 28 33
7 Al Entesar Al Entesar 26 26 30 33
8 Al-Ansar FC Al-Ansar FC 26 24 27 31
9 Al-Zulfi Al-Zulfi 26 29 35 31
10 Al-Arabi SC Al-Arabi SC 26 29 37 27
11 Al-Lewaa Al-Lewaa 26 30 39 27
12 Al-Taqadom Al-Taqadom 26 27 34 25
13 Al Hjazz Al Hjazz 26 28 44 25
14 Kumait Kumait 26 28 42 20
15 Al-Orubah FC Al-Orubah 26 51 28 54
16 Al-Kholood Al-Kholood 26 40 21 48
17 Al-Washm Al-Washm 26 47 28 45
18 Al-Riyadh SC Al-Riyadh 26 47 34 44
19 Al Rawdhah Al Rawdhah 26 37 37 38
20 Al-Najma FC Al-Najma FC 26 36 40 35
21 Al Taraji Al Taraji 26 31 35 35
22 Al Sharq Al Sharq 26 31 30 34
23 Wej SC Wej SC 26 36 40 34
24 Hottain Hottain 26 28 34 33
25 AFIF AFIF 26 35 47 31
26 Al Dahab Al Dahab 26 25 34 25
27 Al Mojzel Al Mojzel 26 33 46 24
28 Al Selmiyah Al Selmiyah 26 24 47 22
TEMPORADA 2019/2020
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Batin Al-Batin 38 52 28 76
2 Al Qadsiah FC Qadsiah 38 71 38 75
3 Al-Ain FC Al-Ain FC 38 57 29 72
4 Al Bukayriyah Bukayriyah 38 65 41 64
5 Al-Nahdha Al-Nahdha 38 55 47 60
6 Al-Jabalain FC Al-Jabalain 38 56 39 57
7 Ohod Ohod 38 51 42 57
8 Jeddah Club Jeddah Club 38 49 49 54
9 Al-Thqba Al-Thqba 38 61 46 53
10 Al-Tai SC Al-Tai SC 38 40 38 48
11 Najran Najran 38 49 51 48
12 Al-Shoalah FC Al-Shoalah 38 43 44 47
13 Al Jeel Al Jeel 38 38 52 46
14 Al-Kawkab Al-Kawkab 38 39 47 45
15 Al-Khaleej Al-Khaleej 38 45 50 44
16 Al Najoom Al Najoom 38 44 62 41
17 Al Mojzel Al Mojzel 38 37 64 39
18 Al-Taqadom Al-Taqadom 38 42 66 38
19 Al-Ansar FC Al-Ansar FC 38 34 62 35
20 Hottain Hottain 38 47 80 31
TEMPORADA 2018/2019
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al Bukayriyah Bukayriyah 22 37 13 48
2 Al-Taqadom Al-Taqadom 22 37 24 43
3 Al Jandal Al Jandal 22 31 16 41
4 Al Hjazz Al Hjazz 22 39 29 38
5 Al Sadd Al Sadd 22 40 25 37
6 Al-Sahel Al-Sahel 22 26 25 30
7 Al-Okhdood Al-Okhdood 22 39 34 26
8 Al-Diriyah Al-Diriyah 22 25 37 24
9 Al Suqoor Al Suqoor 22 22 37 21
10 Al-Riyadh SC Al-Riyadh 22 21 36 20
11 Al-Muzahimiyyah Al-Muzahimiy 22 22 41 17
12 Al Ghazwa Al Ghazwa 22 16 38 14
13 Hottain Hottain 22 38 19 42
14 Al-Thqba Al-Thqba 22 34 22 40
15 Al-Kholood Al-Kholood 22 30 20 35
16 Wej SC Wej SC 22 36 34 34
17 Al Sharq Al Sharq 22 24 23 30
18 Al-Arabi SC Al-Arabi SC 22 21 20 29
19 Al Drae Al Drae 22 23 31 27
20 Al Jubail Al Jubail 22 30 37 26
21 Arar Arar 22 22 24 25
22 AFIF AFIF 22 24 35 25
23 Al Hait Al Hait 22 20 29 24
24 Al Watani Al Watani 22 21 29 22
TEMPORADA 2017/2018
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Jabalain FC Al-Jabalain 19 26 11 39
2 Al-Ansar FC Al-Ansar FC 18 26 15 35
3 Al-Adalah Club Al-Adalah 18 26 27 30
4 Abha Abha 18 20 22 27
5 Hottain Hottain 18 36 25 26
6 Al-Kholood Al-Kholood 18 18 16 25
7 Al Jubail Al Jubail 18 19 20 19
8 Al-Riyadh SC Al-Riyadh 18 16 25 17
9 Al Badaya Al Badaya 19 16 29 16
10 Al-Diriyah Al-Diriyah 18 18 31 15
11 Al-Washm Al-Washm 18 29 19 35
12 Al Jeel Al Jeel 18 25 17 31
13 Al-Ain FC Al-Ain FC 18 28 22 31
14 Al-Taqadom Al-Taqadom 18 23 16 28
15 Al-Muzahimiyyah Al-Muzahimiy 18 23 16 27
16 Al Hjazz Al Hjazz 18 24 29 24
17 Al Suqoor Al Suqoor 18 21 26 20
18 Al Sharq Al Sharq 18 20 27 16
19 Al-Thqba Al-Thqba 18 22 30 16
20 Wej SC Wej SC 18 20 33 13
TEMPORADA 2016/2017
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Jeddah Club Jeddah Club 18 27 16 35
2 Al Mojzel Al Mojzel 18 27 18 33
3 Al-Muzahimiyyah Al-Muzahimiy 18 26 17 29
4 Hottain Hottain 18 25 25 28
5 Al-Diriyah Al-Diriyah 18 28 29 24
6 Al-Washm Al-Washm 18 19 22 24
7 Abha Abha 18 14 15 20
8 Al Suqoor Al Suqoor 18 25 33 19
9 Al-Trgee Al-Trgee 18 18 26 16
10 Al-Safa Al-Safa 18 15 23 16
11 Al-Kawkab Al-Kawkab 18 25 15 31
12 Al-Ansar FC Al-Ansar FC 18 25 19 30
13 Al-Jabalain FC Al-Jabalain 18 30 26 27
14 Al-Ain FC Al-Ain FC 18 27 32 25
15 Al-Riyadh SC Al-Riyadh 18 26 23 24
16 Al-Thqba Al-Thqba 18 26 27 24
17 Al Sharq Al Sharq 18 26 24 23
18 Al Badaya Al Badaya 18 19 24 20
19 Sdoos Club Sdoos Club 18 19 23 18
20 Al-Najma FC Al-Najma FC 18 17 27 18
TEMPORADA 2015/2016
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Adalah Club Al-Adalah 18 38 12 42
2 Wajj Wajj 18 39 24 34
3 Al-Jabalain FC Al-Jabalain 18 29 16 29
4 Hottain Hottain 18 21 21 26
5 Al-Washm Al-Washm 18 26 21 25
6 Al-Trgee Al-Trgee 18 24 21 23
7 Al-Safa Al-Safa 18 19 19 23
8 Al-Najma FC Al-Najma FC 18 27 33 23
9 Al-Oyoon Al-Oyoon 18 27 54 12
10 Al-Tuhami Al-Tuhami 18 11 40 8
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
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Hajer FC Hajer FC 30 51 32 63
2 Al-Ansar FC Al-Ansar FC 30 40 24 55
3 Al-Riyadh SC Al-Riyadh 30 38 29 52
4 Abha Abha 30 59 43 51
5 Al-Khaleej Al-Khaleej 30 44 36 49
6 Al Watani Al Watani 30 44 34 46
7 Al-Tai SC Al-Tai SC 30 33 33 43
8 Damac FC Damac FC 30 51 47 39
9 Ohod Ohod 30 40 46 39
10 Hottain Hottain 30 48 39 37
11 Al-Orubah FC Al-Orubah 30 44 55 37
12 Al Jeel Al Jeel 30 36 45 35
13 Al-Shoalah FC Al-Shoalah 30 36 46 34
14 Al-Adalah Club Al-Adalah 30 33 41 32
15 Jeddah Club Jeddah Club 30 37 60 22
16 Al-Najma FC Al-Najma FC 30 32 56 20
TEMPORADA 2009/2010
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Faisaly FC Al-Faisaly 26 44 12 58
2 Al-Taawoun Al-Taawoun 26 35 18 56
3 Al-Ansar FC Al-Ansar FC 26 41 26 50
4 Abha Abha 26 39 36 41
5 Al-Tai SC Al-Tai SC 26 30 25 40
6 Al-Khaleej Al-Khaleej 26 34 34 34
7 Hajer FC Hajer FC 26 34 41 33
8 Al-Adalah Club Al-Adalah 26 32 33 31
9 Al-Shoalah FC Al-Shoalah 26 36 40 29
10 Damac FC Damac FC 26 29 43 29
11 Al Watani Al Watani 26 35 44 27
12 Hottain Hottain 26 38 49 27
13 Ohod Ohod 26 32 41 25
14 Al-Riyadh SC Al-Riyadh 26 24 41 25
TEMPORADA 2008/2009
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al Qadsiah FC Qadsiah 26 41 15 54
2 Al-Fateh SC Al-Fateh SC 26 41 28 51
3 Al-Faisaly FC Al-Faisaly 26 38 26 47
4 Al-Tai SC Al-Tai SC 26 35 28 44
5 Damac FC Damac FC 26 39 36 40
6 Hajer FC Hajer FC 26 42 37 35
7 Al-Khaleej Al-Khaleej 26 36 33 35
8 Al-Taawoun Al-Taawoun 26 39 40 33
9 Ohod Ohod 26 25 30 33
10 Al-Riyadh SC Al-Riyadh 26 28 32 30
11 Al-Ansar FC Al-Ansar FC 26 24 34 28
12 Hottain Hottain 26 19 33 24
13 Al-Orubah FC Al-Orubah 26 32 49 21
14 Sdoos Club Sdoos Club 26 31 49 14

  USO DE MEMORIA  
7,436,112 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6200
Total Execution Time  0.6213
  CADENA URL  
/historico/Hottain
  GET DATOS  
$_GET['/historico/Hottain']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0154  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 = 'Hottain' 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=17267 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=17267 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17267 AND type_rel = 2
0.0149  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 = '17267' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '17267' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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=17267 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73649) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73649 AND teamId = 17267
0.0147  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 = '17267' 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 = '17267' 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 = '17267' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 73649 WHERE rp.league_id = 73649 AND rp.teamId = 17267 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.0146  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 = 73649 WHERE rp.league_id = 73649 AND rp.teamId = 17267 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 73649 WHERE rp.league_id = 73649 AND rp.teamId = 17267 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 17267 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0294  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 = 73649 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 `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 = 69722 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 `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 = 64683 AND t.round = 26 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 `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 = 60077 AND t.round = 26 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 = 50042 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 `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 = 45783 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 `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 = 39166 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 36095 AND t.round = 18 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 `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 = 15562 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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 `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.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 `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.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 `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.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 = 8878 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 `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 = 8876 AND t.round = 26 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 `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 = 8874 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC