4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al Shabab Muscat
TEMPORADA 2021/2022
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Al-Seeb Al-Seeb 26 50 17 55
2 Al-Nahda Al-Nahda 26 35 17 53
3 Dhofar Dhofar 26 39 17 48
4 Al Musannah Al Musannah 26 33 24 43
5 Al-Nasr Salalah Al-Nasr 26 28 22 42
6 Sohar Sohar 26 32 31 39
7 Al Rustaq Al Rustaq 26 25 24 35
8 Oman FC Oman FC 26 30 33 31
9 Al-Suwaiq Al-Suwaiq 26 24 28 31
10 Al Ittihad Al Ittihad 26 20 39 25
11 Bahla Bahla 26 28 35 24
12 Al Shabab Muscat Shabab 26 21 33 22
13 Saham Saham 26 19 36 20
14 Nizwa Nizwa 26 15 43 20
TEMPORADA 2020/2021
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Dhofar Dhofar 10 19 3 26
2 Al-Seeb Al-Seeb 10 21 3 22
3 Al Musannah Al Musannah 10 14 10 20
4 Al-Nasr Salalah Al-Nasr 10 11 8 18
5 Al-Suwaiq Al-Suwaiq 10 11 9 17
6 Bahla Bahla 10 10 9 15
7 Al Rustaq Al Rustaq 10 9 9 14
8 Al-Nahda Al-Nahda 10 9 9 12
9 Al Ittihad Al Ittihad 10 10 12 12
10 Oman FC Oman FC 10 6 9 11
11 Sohar Sohar 10 8 14 8
12 Nizwa Nizwa 10 8 15 7
13 Saham Saham 10 7 20 6
14 Al Shabab Muscat Shabab 10 4 17 3
TEMPORADA 2019/2020
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Al-Seeb Al-Seeb 26 38 13 57
2 Dhofar Dhofar 26 44 13 52
3 Al-Nahda Al-Nahda 26 40 34 40
4 Fanja Fanja 26 42 41 39
5 Al-Nasr Salalah Al-Nasr 26 28 31 37
6 Bahla Bahla 26 33 25 35
7 Al Shabab Muscat Shabab 26 35 35 35
8 Al-Suwaiq Al-Suwaiq 26 30 30 35
9 Al Rustaq Al Rustaq 26 33 30 33
10 Saham Saham 26 32 36 33
11 Sohar Sohar 26 28 30 32
12 Oman FC Oman FC 26 21 38 27
13 Al-Oruba Al-Oruba 26 21 33 26
14 Mrbat Mrbat 26 20 56 12
TEMPORADA 2018/2019
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Dhofar Dhofar 18 36 8 44
2 Al-Nasr Salalah Al-Nasr 19 29 20 33
3 Al-Nahda Al-Nahda 18 25 17 30
4 Mrbat Mrbat 18 19 16 27
5 Al Shabab Muscat Shabab 19 23 22 27
6 Al-Oruba Al-Oruba 19 21 13 26
7 Sohar Sohar 18 28 26 25
8 Al-Suwaiq Al-Suwaiq 18 20 19 25
9 Saham Saham 18 25 29 25
10 Al Rustaq Al Rustaq 18 17 18 21
11 Mjees FC Mjees FC 19 10 27 17
12 Al-Shabab Al-Shabab 18 21 33 16
13 Sur Club Sur Club 18 18 30 15
14 Oman FC Oman FC 18 17 31 15
TEMPORADA 2017/2018
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Al-Suwaiq Al-Suwaiq 26 50 25 63
2 Al-Shabab Al-Shabab 26 32 30 42
3 Al-Nahda Al-Nahda 26 41 34 37
4 Al-Nasr Salalah Al-Nasr 26 28 26 35
5 Al-Oruba Al-Oruba 26 22 26 34
6 Dhofar Dhofar 26 34 31 33
7 Saham Saham 26 36 35 33
8 Sohar Sohar 26 37 42 33
9 Al Shabab Muscat Shabab 26 34 39 33
10 Mrbat Mrbat 26 35 47 32
11 Oman FC Oman FC 26 31 27 31
12 Fanja Fanja 26 33 34 31
13 Al-Mudhaibi Al-Mudhaibi 26 26 34 31
14 Al Salam Al Salam 26 25 34 30
TEMPORADA 2016/2017
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Dhofar Dhofar 26 44 27 51
2 Al-Shabab Al-Shabab 26 42 27 48
3 Al-Oruba Al-Oruba 26 45 37 45
4 Al-Nasr Salalah Al-Nasr 26 31 30 39
5 Fanja Fanja 26 42 40 37
6 Al-Suwaiq Al-Suwaiq 26 35 25 36
7 Saham Saham 26 40 45 36
8 Sohar Sohar 26 36 36 35
9 Al-Nahda Al-Nahda 26 33 34 33
10 Al Shabab Muscat Shabab 26 36 36 31
11 Oman FC Oman FC 26 32 36 31
12 Al Khaboora Al Khaboora 26 28 35 30
13 Jaalan Jaalan 26 27 44 20
14 Al Rustaq Al Rustaq 26 32 51 17
TEMPORADA 2015/2016
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Fanja Fanja 26 42 20 51
2 Al-Suwaiq Al-Suwaiq 27 30 20 49
3 Al-Oruba Al-Oruba 26 38 17 47
4 Dhofar Dhofar 26 37 36 39
5 Al-Nahda Al-Nahda 26 31 26 38
6 Sohar Sohar 26 31 26 37
7 Al-Nasr Salalah Al-Nasr 26 22 24 36
8 Saham Saham 26 27 28 33
9 Al Khaboora Al Khaboora 27 27 26 31
10 Al-Shabab Al-Shabab 26 29 40 31
11 Al Shabab Muscat Shabab 26 30 33 30
12 Al Musannah Al Musannah 26 21 32 29
13 Sur Club Sur Club 26 23 34 21
14 Salalah Salalah 26 19 45 14
TEMPORADA 2010/2011
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Al-Suwaiq Al-Suwaiq 22 31 15 43
2 Al-Oruba Al-Oruba 22 31 14 40
3 Al-Nahda Al-Nahda 22 30 18 38
4 Dhofar Dhofar 22 24 22 30
5 Oman FC Oman FC 22 24 22 29
6 Al-Shabab Al-Shabab 22 25 29 28
7 Salalah Salalah 22 25 29 27
8 Al Taleea Al Taleea 22 27 27 26
9 Al Shabab Muscat Shabab 22 23 30 26
10 Saham Saham 22 18 27 26
11 Al Ahli / Sedab Ahli Sedab 22 14 23 26
12 Al-Nasr Salalah Al-Nasr 22 17 33 19
TEMPORADA 2009/2010
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Al-Suwaiq Al-Suwaiq 22 30 18 44
2 Dhofar Dhofar 22 33 26 41
3 Al-Nahda Al-Nahda 22 29 21 40
4 Al Shabab Muscat Shabab 22 26 22 30
5 Al Taleea Al Taleea 22 21 28 27
6 Saham Saham 22 19 26 27
7 Al-Nasr Salalah Al-Nasr 22 25 27 26
8 Al-Shabab Al-Shabab 22 30 25 25
9 Oman FC Oman FC 22 27 29 25
10 Al-Oruba Al-Oruba 22 18 22 25
11 Al Khaboora Al Khaboora 22 20 27 24
12 Al-Seeb Al-Seeb 22 19 26 24
TEMPORADA 2008/2009
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Al-Nahda Al-Nahda 22 32 15 45
2 Al Shabab Muscat Shabab 22 24 13 37
3 Al-Oruba Al-Oruba 22 26 14 36
4 Al Khaboora Al Khaboora 22 27 19 35
5 Saham Saham 22 30 29 30
6 Al-Shabab Al-Shabab 22 27 31 30
7 Dhofar Dhofar 22 24 33 29
8 Al Taleea Al Taleea 22 32 31 28
9 Al-Seeb Al-Seeb 22 25 24 26
10 Al-Nasr Salalah Al-Nasr 22 28 30 25
11 Sur Club Sur Club 22 20 33 21
12 Shar Shar 22 19 42 14
TEMPORADA 2007/2008
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Al-Oruba Al-Oruba 22 36 16 45
2 Dhofar Dhofar 22 32 16 38
3 Al Khaboora Al Khaboora 22 29 20 34
4 Al-Seeb Al-Seeb 22 25 20 33
5 Al-Nasr Salalah Al-Nasr 22 19 19 33
6 Sur Club Sur Club 22 28 23 31
7 Al-Nahda Al-Nahda 22 20 20 28
8 Al Shabab Muscat Shabab 22 18 27 27
9 Al Taleea Al Taleea 22 23 26 26
10 Al Wehda Al Wehda 22 25 34 25
11 Oman FC Oman FC 22 27 39 21
12 Bahla Bahla 22 23 45 13
TEMPORADA 2006/2007
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Al-Nahda Al-Nahda 22 35 20 43
2 Al-Oruba Al-Oruba 22 28 18 41
3 Dhofar Dhofar 22 31 22 36
4 Al-Nasr Salalah Al-Nasr 22 28 19 35
5 Al Shabab Muscat Shabab 22 26 18 32
6 Al Taleea Al Taleea 22 19 17 32
7 Al-Seeb Al-Seeb 22 31 29 30
8 Sur Club Sur Club 22 24 25 29
9 Bahla Bahla 22 24 32 22
10 Al Khaboora Al Khaboora 22 15 26 22
11 Mjees FC Mjees FC 22 16 32 20
12 Al Salam Al Salam 22 24 43 17
TEMPORADA 2005/2006
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Al Shabab Muscat Shabab 22 33 15 45
2 Al-Nahda Al-Nahda 22 39 18 43
3 Al Taleea Al Taleea 22 35 22 43
4 Al-Nasr Salalah Al-Nasr 22 32 27 35
5 Sur Club Sur Club 22 26 25 33
6 Al-Seeb Al-Seeb 22 24 21 32
7 Al-Oruba Al-Oruba 22 26 25 32
8 Bahla Bahla 22 27 37 25
9 Al-Suwaiq Al-Suwaiq 22 27 29 21
10 Mjees FC Mjees FC 22 22 38 21
11 Dhofar Dhofar 22 19 28 20
12 Oman FC Oman FC 22 17 42 10

  USO DE MEMORIA  
5,923,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.5095
Total Execution Time  0.5111
  CADENA URL  
/historico/Al-Shabab-Muscat
  GET DATOS  
$_GET['/historico/Al-Shabab-Muscat']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0141  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-Shabab-Muscat' 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.0125  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=19044 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=19044 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19044 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1672 AND type_rel = 3
0.0130  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 = '19044' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '19044' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0132  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=19044 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (74250) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 74250 AND teamId = 19044
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 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 = 74250 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '19044' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19044' and rp.type = 4
0.0126  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 = '19044' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 74250 WHERE rp.league_id = 74250 AND rp.teamId = 19044 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.0127  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 = 74250 WHERE rp.league_id = 74250 AND rp.teamId = 19044 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 74250 WHERE rp.league_id = 74250 AND rp.teamId = 19044 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 19044 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 = 65354 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.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 `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 = 60364 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 50034 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.0128  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 = 44749 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 39727 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 34738 AND t.round = 26 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 `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 = 15596 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 24165 AND t.round = 22 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 `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 = 24167 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 24170 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2008` 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 = 24182 AND t.round = 22 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 `tables2007` 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 = 24183 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2006` 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 = 24184 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74250 ORDER BY nameShow LIMIT 100