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

Al-Okhdood

Entrenador: Noureddine Zekri

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 28 83 35 68
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-Fateh SC Al-Fateh SC 29 48 44 40
7 Al-Ettifaq Al-Ettifaq 29 33 29 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 28 32 39 35
12 Al-Raed Al-Raed 29 37 43 33
13 Al-Wehda Al-Wehda 29 41 49 32
14 Al-Riyadh SC Al-Riyadh 29 26 51 28
15 Al-Okhdood Al-Okhdood 29 25 47 27
16 Al-Tai SC Al-Tai SC 29 29 57 26
17 Abha Abha 29 31 76 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
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
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 2015/2016
SEGUNDA ARABIA SAUDÍ GRUPO 2
Equipo PJ GF GC Puntos
1 Al-Qaisumah FC Al-Qaisumah 18 36 18 40
2 Al Badaya Al Badaya 18 25 13 31
3 Al-Muzahimiyyah Al-Muzahimiy 18 24 20 29
4 Sdoos Club Sdoos Club 18 30 23 28
5 Al-Kawkab Al-Kawkab 18 25 21 27
6 Al Sharq Al Sharq 18 24 24 25
7 Abha Abha 18 19 24 20
8 Al-Ansar FC Al-Ansar FC 18 25 27 19
9 Al-Okhdood Al-Okhdood 18 17 26 17
10 Al-Qalah Al-Qalah 18 10 39 7
TEMPORADA 2014/2015
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Ohod Ohod 18 30 14 38
2 Al Najoom Al Najoom 18 24 15 38
3 Wajj Wajj 18 31 20 36
4 Al-Okhdood Al-Okhdood 18 25 19 30
5 Al Badaya Al Badaya 18 22 16 29
6 Al Taraji Al Taraji 18 18 19 22
7 Al-Oyoon Al-Oyoon 18 19 24 17
8 Al-Muzahimiyyah Al-Muzahimiy 18 12 17 14
9 Al Suqoor Al Suqoor 18 15 31 14
10 Al Hamadah Al Hamadah 18 13 34 10
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 2011/2012
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Najma FC Al-Najma FC 18 36 16 35
2 Al-Kawkab Al-Kawkab 18 26 16 32
3 Al-Adalah Club Al-Adalah 18 25 15 30
4 Al-Arabi SC Al-Arabi SC 18 18 18 29
5 Al-Safa Al-Safa 18 22 22 25
6 Al-Oyoon Al-Oyoon 18 24 25 24
7 Al Taraji Al Taraji 18 22 29 22
8 Najd Najd 18 25 27 20
9 Al-Okhdood Al-Okhdood 18 19 25 14
10 Al Nakheal Al Nakheal 18 15 39 12
TEMPORADA 2010/2011
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Nahdha Al-Nahdha 18 50 16 41
2 Al-Kawkab Al-Kawkab 18 28 21 33
3 Sdoos Club Sdoos Club 18 30 19 32
4 Al-Arabi SC Al-Arabi SC 18 23 17 26
5 Al-Fayha Al-Fayha 18 23 24 24
6 Al Nakheal Al Nakheal 18 24 25 23
7 Al-Okhdood Al-Okhdood 18 27 28 22
8 Al-Taqadom Al-Taqadom 18 21 31 21
9 Al Ared Al Ared 18 25 46 17
10 Al Hait Al Hait 18 15 39 7
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
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,833,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4537
Total Execution Time  0.4557
  CADENA URL  
/historico/Al-Akhdoud-Saudi
  GET DATOS  
$_GET['/historico/Al-Akhdoud-Saudi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119238 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61 AND type_rel = 3
0.0160  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 61 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0153  SELECT /*53 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 (1312645,1312329,1312142,1274748,903768) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = '119238' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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.0148  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 = 72207 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 119238 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.0169  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 = 15564 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 9281 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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.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 `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 = 27923 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 `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 = 27930 AND t.round = 18 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 = 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.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 `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