4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al-Orubah FC
TEMPORADA 2023/2024
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al Qadsiah FC Qadsiah 29 52 24 60
2 Al-Orubah FC Al-Orubah 29 44 29 54
3 Al-Kholood Al-Kholood 29 42 25 51
4 Al-Arabi SC Al-Arabi SC 29 53 32 49
5 Al-Adalah Club Al-Adalah 29 44 35 49
6 Al-Faisaly FC Al-Faisaly 29 44 40 47
7 Al-Batin Al-Batin 29 37 34 45
8 Al-Jabalain FC Al-Jabalain 29 37 34 43
9 Al-Najma FC Al-Najma FC 29 47 42 41
10 Al-Safa Al-Safa 29 39 42 39
11 Al Jandal Al Jandal 29 27 38 36
12 Al-Ain FC Al-Ain FC 29 35 39 35
13 Jeddah Club Jeddah Club 29 38 49 34
14 Al Bukayriyah Bukayriyah 29 28 36 33
15 Ohod Ohod 29 30 33 32
16 Al-Qaisumah FC Al-Qaisumah 29 35 52 23
17 Hajer FC Hajer FC 29 25 46 23
18 Al Taraji Al Taraji 29 24 51 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
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Khaleej Al-Khaleej 38 51 36 66
2 Al-Adalah Club Al-Adalah 38 42 32 66
3 Al-Wehda Al-Wehda 38 51 29 65
4 Hajer FC Hajer FC 38 44 31 63
5 Al-Jabalain FC Al-Jabalain 38 48 39 61
6 Ohod Ohod 38 51 42 59
7 Al Qadsiah FC Qadsiah 38 40 32 55
8 Al-Kholood Al-Kholood 38 40 36 54
9 Najran Najran 38 38 33 52
10 Al-Orubah FC Al-Orubah 38 45 44 52
11 Al-Ain FC Al-Ain FC 38 38 41 49
12 Al-Sahel Al-Sahel 38 50 43 48
13 Al-Shoalah FC Al-Shoalah 38 40 34 48
14 Al-Okhdood Al-Okhdood 38 43 44 48
15 Jeddah Club Jeddah Club 38 35 39 47
16 Al Jeel Al Jeel 38 37 51 47
17 Al-Diriyah Al-Diriyah 38 38 56 42
18 Al-Nahdha Al-Nahdha 38 37 52 38
19 Al-Kawkab Al-Kawkab 38 30 54 27
20 Bisha Bisha 38 27 57 25
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
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Hajer FC Hajer FC 22 42 8 54
2 Al-Sahel Al-Sahel 22 31 15 46
3 Al-Okhdood Al-Okhdood 22 29 20 38
4 Al Jandal Al Jandal 22 26 26 36
5 Al Rawdhah Al Rawdhah 22 23 24 29
6 Wej SC Wej SC 22 21 28 27
7 Al-Washm Al-Washm 22 28 24 25
8 Al Sadd Al Sadd 22 24 32 23
9 Al Entesar Al Entesar 22 20 30 23
10 AFIF AFIF 22 23 36 23
11 Al Jubail Al Jubail 22 19 26 20
12 Al Suqoor Al Suqoor 22 16 33 15
13 Arar Arar 22 30 17 40
14 Al-Diriyah Al-Diriyah 22 31 20 40
15 Al-Kholood Al-Kholood 22 39 30 37
16 Al-Safa Al-Safa 22 25 25 31
17 Al-Riyadh SC Al-Riyadh 22 25 21 30
18 Al Hjazz Al Hjazz 22 28 32 29
19 Al-Arabi SC Al-Arabi SC 22 31 29 28
20 Al-Qaisumah FC Al-Qaisumah 22 24 23 28
21 Al Sharq Al Sharq 22 27 33 27
22 Al-Orubah FC Al-Orubah 22 29 27 26
23 Al Anwar Al Anwar 22 27 36 23
24 Al Drae Al Drae 22 20 43 13
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
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
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Nassr Al-Nassr 26 62 20 64
2 Al-Ahli SFC Al-Ahli SFC 26 59 22 60
3 Al-Hilal SFC Al-Hilal 26 46 17 54
4 Al-Ittihad Al-Ittihad 26 44 33 52
5 Al-Shabab Al-Shabab 26 37 31 40
6 Al-Fateh SC Al-Fateh SC 26 35 43 33
7 Al-Faisaly FC Al-Faisaly 26 31 42 30
8 Al-Khaleej Al-Khaleej 26 35 41 29
9 Al-Taawoun Al-Taawoun 26 42 46 28
10 Hajer FC Hajer FC 26 29 56 28
11 Al-Raed Al-Raed 26 33 45 26
12 Najran Najran 26 28 41 24
13 Al-Shoalah FC Al-Shoalah 26 26 48 21
14 Al-Orubah FC Al-Orubah 26 21 43 17
TEMPORADA 2013/2014
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Nassr Al-Nassr 26 60 21 65
2 Al-Hilal SFC Al-Hilal 26 60 24 63
3 Al-Ahli SFC Al-Ahli SFC 26 48 24 45
4 Al-Shabab Al-Shabab 26 42 38 37
5 Al-Taawoun Al-Taawoun 26 33 28 35
6 Al-Ittihad Al-Ittihad 26 45 46 32
7 Al-Faisaly FC Al-Faisaly 26 28 35 32
8 Al-Orubah FC Al-Orubah 26 24 33 29
9 Al-Raed Al-Raed 26 21 33 29
10 Al-Fateh SC Al-Fateh SC 26 33 39 28
11 Najran Najran 26 32 43 28
12 Al-Ettifaq Al-Ettifaq 26 30 41 26
13 Al-Shoalah FC Al-Shoalah 26 30 42 26
14 Al-Nahdha Al-Nahdha 26 29 68 16
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
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Najma FC Al-Najma FC 26 53 22 55
2 Al Jeel Al Jeel 26 44 28 49
3 Jeddah Club Jeddah Club 26 42 31 44
4 Al-Nahdha Al-Nahdha 26 37 27 43
5 Al-Orubah FC Al-Orubah 26 37 37 43
6 Al-Jabalain FC Al-Jabalain 26 37 29 41
7 Sdoos Club Sdoos Club 26 35 33 41
8 Al-Batin Al-Batin 26 36 39 34
9 Al-Arabi SC Al-Arabi SC 26 33 39 30
10 Al Hamadah Al Hamadah 26 30 33 29
11 Al-Fayha Al-Fayha 26 31 42 29
12 Najd Najd 26 23 46 28
13 Al-Okhdood Al-Okhdood 26 29 33 27
14 Al-Diriyah Al-Diriyah 26 18 46 12
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,175,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5857
Total Execution Time  0.5870
  CADENA URL  
/historico/Al-Orubah
  GET DATOS  
$_GET['/historico/Al-Orubah']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0142  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-Orubah' 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.0109  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=18067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108  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=18067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=18067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0217  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 = 72504
0.0113  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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18067 AND type_rel = 2
0.0112  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 = '18067' ORDER BY l.year DESC,cat.coefficient DESC
0.0110  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 = '18067' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0110  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 = '18067' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0110  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.0108  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 = 72504 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0119  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=18067 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0111  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,72504) 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.0122  SELECT count(id) as num_players from rel_players WHERE league_id = 72504 AND teamId = 18067
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73198 AND teamId = 18067
0.0114  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 = '18067' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0110  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18067' and rp.type = 4
0.0116  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 = '18067' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0149  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 = 72504 WHERE rp.league_id = 72504 AND rp.teamId = 18067 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.0126  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 = 72504 WHERE rp.league_id = 72504 AND rp.teamId = 18067 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0122  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 = 72504 WHERE rp.league_id = 72504 AND rp.teamId = 18067 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  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 = 18067 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0115  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 = 72504 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.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 `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.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 `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 = 64123 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.0121  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.0123  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 = 51427 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121  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.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 `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.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 `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.0127  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.0120  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 = 3879 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 3254 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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.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 `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.0120  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.0126  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 = 27939 AND t.round = 26 ORDER BY team.conference 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 `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