4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al-Taqadom
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 2011/2012
SEGUNDA ARABIA SAUDÍ GRUPO 2
Equipo PJ GF GC Puntos
1 Sdoos Club Sdoos Club 18 41 13 45
2 Jeddah Club Jeddah Club 18 40 22 35
3 Al-Diriyah Al-Diriyah 18 28 22 27
4 Al-Jabalain FC Al-Jabalain 18 27 23 24
5 Al Ramh Al Ramh 18 33 33 24
6 Al Hamadah Al Hamadah 18 27 30 21
7 Al-Fayha Al-Fayha 18 23 36 21
8 Al Ameade Al Ameade 18 27 39 20
9 Al-Taqadom Al-Taqadom 18 22 31 19
10 Al Slam Al Slam 18 17 36 13
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

  USO DE MEMORIA  
6,404,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5646
Total Execution Time  0.5664
  CADENA URL  
/historico/Al-Taqdom-Saudi
  GET DATOS  
$_GET['/historico/Al-Taqdom-Saudi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0187  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-Taqdom-Saudi' 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.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=119240 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=119240 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0313  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 = 73649
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119240 AND type_rel = 2
0.0164  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 = '119240' ORDER BY l.year DESC,cat.coefficient DESC
0.0163  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 = '119240' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0161  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 = '119240' 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 = 73649 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0162  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=119240 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0151  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.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 73649 AND teamId = 119240
0.0162  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 = '119240' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0152  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '119240' and rp.type = 4
0.0157  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 = '119240' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73649 WHERE rp.league_id = 73649 AND rp.teamId = 119240 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 events2024 e ON e.player_id = p.id AND e.league_id = 73649 WHERE rp.league_id = 73649 AND rp.teamId = 119240 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73649 WHERE rp.league_id = 73649 AND rp.teamId = 119240 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0164  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 = 119240 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0173  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.0170  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.0175  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.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 `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.0172  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.0166  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.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 `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 = 27927 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 `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