4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al Mojzel
TEMPORADA 2022/2023
TERCERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al Jubail Al Jubail 14 24 10 30
2 Al Watani Al Watani 14 22 11 27
3 Al Bateen Al Bateen 14 20 15 25
4 Al-Ula Al-Ula 14 17 18 21
5 Al Dahab Al Dahab 14 22 22 20
6 Al-Omran Al-Omran 14 13 16 16
7 Al Selmiyah Al Selmiyah 14 11 21 12
8 Al Waseel Al Waseel 14 12 28 4
9 Al-Noor Al-Noor 14 19 5 30
10 Al Najoom Al Najoom 14 23 9 26
11 Baish Baish 14 18 14 25
12 Al-Qalah Al-Qalah 14 23 12 24
13 Al Anwar Al Anwar 14 8 8 17
14 Al Drae Al Drae 14 19 16 16
15 Al Mojzel Al Mojzel 14 12 20 13
16 Al-Sawari Al-Sawari 14 8 46 2
17 Mudhar Mudhar 14 23 5 30
18 Al-Howrah Al-Howrah 14 22 10 29
19 Sharurah Sharurah 14 20 22 18
20 Al Shahed Al Shahed 14 18 20 15
21 Al-Khaledi Al-Khaledi 14 19 25 15
22 AlQwarah AlQwarah 14 14 18 14
23 Al-Thuqbah Al-Thuqbah 14 13 13 13
24 Ras Tanura Ras Tanura 14 12 28 12
25 AFIF AFIF 14 27 14 25
26 Al Qotah Al Qotah 14 27 15 24
27 Al-Tuhami Al-Tuhami 14 23 21 22
28 Al Qariah Olya Qariah Olya 14 12 13 20
29 Radwa Radwa 14 18 21 16
30 Al-Tasamh Al-Tasamh 14 17 29 15
31 Al-Amjad Al-Amjad 14 12 16 14
32 Al Hjazz Al Hjazz 14 11 18 11
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
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Abha Abha 40 55 40 73
2 Damac FC Damac FC 38 52 31 64
3 Al-Adalah Club Al-Adalah 38 49 39 63
4 Al-Khaleej Al-Khaleej 38 49 39 60
5 Al Jeel Al Jeel 38 52 44 57
6 Al-Tai SC Al-Tai SC 38 39 34 57
7 Najran Najran 38 47 43 52
8 Jeddah Club Jeddah Club 38 46 43 50
9 Al Najoom Al Najoom 38 46 44 50
10 Al-Qaisumah FC Al-Qaisumah 39 47 53 50
11 Al-Shoalah FC Al-Shoalah 40 44 49 49
12 Al-Nahdha Al-Nahdha 38 41 42 49
13 Al-Ain FC Al-Ain FC 38 43 45 49
14 Al-Jabalain FC Al-Jabalain 38 35 40 48
15 Al Mojzel Al Mojzel 38 41 45 48
16 Al-Kawkab Al-Kawkab 38 45 52 48
17 Al-Ansar FC Al-Ansar FC 38 39 41 47
18 Hajer FC Hajer FC 38 39 42 47
19 Al-Washm Al-Washm 39 35 52 43
20 Al-Orubah FC Al-Orubah 38 37 63 26
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
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
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
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Safa Al-Safa 18 26 9 36
2 Al Taraji Al Taraji 18 21 17 29
3 Damac FC Damac FC 18 26 18 28
4 Al Suqoor Al Suqoor 18 26 27 25
5 Al-Zulfi Al-Zulfi 18 24 29 23
6 Al-Tuhami Al-Tuhami 18 18 16 22
7 Al-Najma FC Al-Najma FC 18 19 18 22
8 Al Sharq Al Sharq 18 21 23 20
9 Jeddah Club Jeddah Club 18 15 28 19
10 Al-Arabi SC Al-Arabi SC 18 20 31 15
11 Al-Fayha Al-Fayha 18 25 16 34
12 Al Mojzel Al Mojzel 18 26 15 31
13 Al-Oyoon Al-Oyoon 18 28 24 30
14 Sdoos Club Sdoos Club 18 25 20 26
15 Al Ramh Al Ramh 18 23 20 24
16 Al-Okhdood Al-Okhdood 18 15 27 23
17 Al Najoom Al Najoom 18 22 22 21
18 Al Hamadah Al Hamadah 18 20 25 21
19 Al-Jabalain FC Al-Jabalain 18 25 31 20
20 Al-Qalah Al-Qalah 18 21 30 14
TEMPORADA 2012/2013
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Diriyah Al-Diriyah 18 31 14 40
2 Ohod Ohod 18 27 22 30
3 Al-Oyoon Al-Oyoon 18 33 22 29
4 Al-Tuhami Al-Tuhami 18 20 19 24
5 Al-Jabalain FC Al-Jabalain 18 23 26 24
6 Al Suqoor Al Suqoor 18 19 24 24
7 Al Hamadah Al Hamadah 18 22 22 21
8 Al-Qalah Al-Qalah 18 27 33 21
9 Al-Adalah Club Al-Adalah 18 22 27 19
10 Najd Najd 18 15 30 10
11 Al-Kawkab Al-Kawkab 18 33 19 39
12 Al Mojzel Al Mojzel 18 31 25 34
13 Al-Safa Al-Safa 18 22 12 31
14 Al-Fayha Al-Fayha 18 23 19 29
15 Al-Arabi SC Al-Arabi SC 18 33 26 26
16 Al Ramh Al Ramh 18 24 22 24
17 Damac FC Damac FC 18 17 23 22
18 Al Taraji Al Taraji 18 17 20 21
19 Al Ameade Al Ameade 18 20 32 15
20 Wajj Wajj 18 15 37 10
TEMPORADA 2008/2009
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Shoalah FC Al-Shoalah 26 58 32 51
2 Al-Adalah Club Al-Adalah 26 51 30 50
3 Al Hamadah Al Hamadah 26 47 37 47
4 Al-Nahdha Al-Nahdha 26 31 24 43
5 Al-Jabalain FC Al-Jabalain 26 35 28 39
6 Al-Najma FC Al-Najma FC 26 29 42 35
7 Al-Batin Al-Batin 25 36 33 33
8 Al-Okhdood Al-Okhdood 26 37 43 31
9 Jeddah Club Jeddah Club 26 39 43 29
10 Al Jeel Al Jeel 25 26 33 28
11 Al-Qaisumah FC Al-Qaisumah 26 21 26 26
12 Al-Fayha Al-Fayha 26 29 41 26
13 Al Mojzel Al Mojzel 26 29 42 24
14 Al-Diriyah Al-Diriyah 26 33 47 23

  USO DE MEMORIA  
6,609,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.9042
Total Execution Time  0.9061
  CADENA URL  
/historico/Al-Mojzel
  GET DATOS  
$_GET['/historico/Al-Mojzel']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.0150  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-Mojzel' 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.0165  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-Mojzel' 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=18061 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=18061 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=18061 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=18061 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=18061 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=18061 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=18061 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=18061 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=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=18061 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=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=18061 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=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=18061 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=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=18061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0155  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 = 70112
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18061 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2696 AND type_rel = 3
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 = '18061' ORDER BY l.year DESC,cat.coefficient DESC
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 = '18061' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '18061' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 70112 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=18061 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (70112) 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 = 70112 AND teamId = 18061
0.0154  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 = '18061' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18061' and rp.type = 4
0.0158  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 = '18061' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159  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 events2023 e ON e.player_id = p.id AND e.league_id = 70112 WHERE rp.league_id = 70112 AND rp.teamId = 18061 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.0152  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 events2023 e ON e.player_id = p.id AND e.league_id = 70112 WHERE rp.league_id = 70112 AND rp.teamId = 18061 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 events2023 e ON e.player_id = p.id AND e.league_id = 70112 WHERE rp.league_id = 70112 AND rp.teamId = 18061 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 18061 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 70112 AND t.round = 14 ORDER BY team.conference ASC,t.position 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 `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 = 44795 AND t.round = 38 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 = 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.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 = 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.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 `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.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 = 27901 AND t.round = 18 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 = 27914 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 `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 = 27942 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC