4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al-Shaab Sharjah
TEMPORADA 2014/2015
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Dibba Al Fujairah Dibba 20 41 18 50
2 Al-Shaab Sharjah Al-Shaab 20 38 15 47
3 Dubai Dubai 20 51 15 46
4 Hatta Club Hatta Club 20 39 29 32
5 Masafi Masafi 20 23 26 23
6 Al Urooba Al Urooba 20 36 44 23
7 Dibba Al Hisn Dibba Hisn 20 36 38 22
8 Al Dhaid Al Dhaid 20 26 32 21
9 Khorfakkan Khorfakkan 20 20 36 21
10 Ras Al Khaima Khaima 20 16 34 16
11 Al Taawon SC Taawon 20 27 66 9
TEMPORADA 2013/2014
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Ahli Dubai Ahli Dubai 26 56 28 64
2 Al-Wahda Al-Wahda 26 53 33 48
3 Al-Jazira Al-Jazira 26 46 35 45
4 Al Shabab Dubai Shabab Dubai 26 42 28 44
5 Al Nasr Dubai Nasr Dubai 26 43 32 44
6 Al-Ain Al-Ain 26 52 33 43
7 Sharjah FC Sharjah FC 26 29 25 40
8 Al Dhafra Al Dhafra 26 44 45 35
9 Baniyas Baniyas 26 43 42 31
10 Ajman Ajman 26 39 46 28
11 Emirates Club Emirates 26 40 53 25
12 Al-Wasl Al-Wasl 26 32 47 25
13 Dubai Dubai 26 24 63 15
14 Al-Shaab Sharjah Al-Shaab 26 28 61 13
TEMPORADA 2012/2013
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Ain Al-Ain 26 74 26 62
2 Al Ahli Dubai Ahli Dubai 26 62 33 51
3 Al-Jazira Al-Jazira 26 56 37 47
4 Baniyas Baniyas 26 50 37 47
5 Al-Shaab Sharjah Al-Shaab 26 48 39 42
6 Al Nasr Dubai Nasr Dubai 26 51 40 39
7 Al-Wahda Al-Wahda 26 44 41 39
8 Al Dhafra Al Dhafra 26 37 46 36
9 Al-Wasl Al-Wasl 26 41 45 32
10 Ajman Ajman 26 48 58 30
11 Dubai Dubai 26 32 53 27
12 Al Shabab Dubai Shabab Dubai 26 37 49 25
13 Dibba Al Fujairah Dibba 26 30 55 21
14 Al Ittihad Kalba Ittihad 26 24 75 11
TEMPORADA 2008/2009
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Ahli Dubai Ahli Dubai 22 54 25 55
2 Al-Jazira Al-Jazira 22 57 17 54
3 Al-Ain Al-Ain 22 40 20 43
4 Al-Wahda Al-Wahda 22 40 39 34
5 Al Shabab Dubai Shabab Dubai 22 34 37 28
6 Al Nasr Dubai Nasr Dubai 22 37 40 26
7 Al-Wasl Al-Wasl 22 38 46 26
8 Al Dhafra Al Dhafra 22 32 32 24
9 Ajman Ajman 22 21 39 24
10 Sharjah FC Sharjah FC 22 31 45 22
11 Al-Shaab Sharjah Al-Shaab 22 23 37 18
12 Khorfakkan Khorfakkan 22 21 51 14
TEMPORADA 2007/2008
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Shabab Dubai Shabab Dubai 22 44 30 42
2 Al-Jazira Al-Jazira 22 46 31 39
3 Al Ahli Dubai Ahli Dubai 22 47 27 37
4 Sharjah FC Sharjah FC 22 35 35 33
5 Al-Shaab Sharjah Al-Shaab 22 39 44 33
6 Al-Ain Al-Ain 22 41 37 30
7 Al-Wasl Al-Wasl 22 39 37 30
8 Al-Wahda Al-Wahda 22 42 42 30
9 Al Nasr Dubai Nasr Dubai 22 37 39 28
10 Al Dhafra Al Dhafra 22 34 41 25
11 Emirates Club Emirates 22 37 54 17
12 Hatta Club Hatta Club 22 23 47 16
TEMPORADA 2006/2007
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Wasl Al-Wasl 22 45 24 47
2 Al-Wahda Al-Wahda 22 40 34 43
3 Al-Jazira Al-Jazira 22 40 24 41
4 Sharjah FC Sharjah FC 22 37 33 32
5 Al-Shaab Sharjah Al-Shaab 22 40 37 31
6 Al Shabab Dubai Shabab Dubai 22 37 34 31
7 Al Ahli Dubai Ahli Dubai 22 33 34 30
8 Al Nasr Dubai Nasr Dubai 22 30 32 28
9 Al-Ain Al-Ain 22 22 26 28
10 Emirates Club Emirates 22 29 40 23
11 Dibba Al Fujairah Dibba 22 27 41 19
12 Dubai Dubai 22 31 52 16
TEMPORADA 2005/2006
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Wahda Al-Wahda 22 64 30 47
2 Al Ahli Dubai Ahli Dubai 22 44 24 47
3 Al-Jazira Al-Jazira 22 43 35 45
4 Al-Ain Al-Ain 22 42 23 41
5 Al Nasr Dubai Nasr Dubai 22 50 35 35
6 Al Shabab Dubai Shabab Dubai 22 40 39 34
7 Sharjah FC Sharjah FC 22 52 41 30
8 Al-Wasl Al-Wasl 22 33 32 29
9 Al-Shaab Sharjah Al-Shaab 22 30 39 25
10 Emirates Club Emirates 22 21 48 18
11 Baniyas Baniyas 22 24 56 13
12 Dibba Al Hisn Dibba Hisn 22 24 65 8
TEMPORADA 2004/2005
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Wahda Al-Wahda 26 75 35 62
2 Al-Ain Al-Ain 26 54 26 57
3 Al-Jazira Al-Jazira 26 62 41 53
4 Al Nasr Dubai Nasr Dubai 26 48 33 46
5 Sharjah FC Sharjah FC 26 59 44 42
6 Al Shabab Dubai Shabab Dubai 26 43 44 40
7 Al Ahli Dubai Ahli Dubai 26 58 40 39
8 Al-Wasl Al-Wasl 26 36 36 34
9 Al-Shaab Sharjah Al-Shaab 26 37 44 34
10 Emirates Club Emirates 26 26 47 26
11 Dubai Dubai 27 31 54 25
12 Khorfakkan Khorfakkan 26 36 62 19
13 Al Ittihad Kalba Ittihad 26 27 55 19
14 Al Dhafra Al Dhafra 26 36 67 13
15 Al Husun Al Husun 1 1 1 1
TEMPORADA 2003/2004
LIGA EMIRATOS GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Ain Al-Ain 10 17 7 21
2 Al Shabab Dubai Shabab Dubai 10 14 9 19
3 Al-Jazira Al-Jazira 10 16 10 18
4 Al Nasr Dubai Nasr Dubai 10 13 17 12
5 Khorfakkan Khorfakkan 10 10 20 8
6 Sharjah FC Sharjah FC 10 10 17 6
7 Al Ahli Dubai Ahli Dubai 10 25 14 21
8 Al-Wasl Al-Wasl 10 18 8 20
9 Al-Wahda Al-Wahda 10 19 12 20
10 Al-Shaab Sharjah Al-Shaab 10 14 13 13
11 Al Ittihad Kalba Ittihad 10 13 20 10
12 Emirates Club Emirates 10 10 32 3
TEMPORADA 2002/2003
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Ain Al-Ain 22 51 20 48
2 Al-Wahda Al-Wahda 22 50 29 43
3 Al Ahli Dubai Ahli Dubai 22 47 36 34
4 Al Nasr Dubai Nasr Dubai 22 36 25 34
5 Al-Shaab Sharjah Al-Shaab 22 39 31 32
6 Al-Jazira Al-Jazira 22 33 32 31
7 Sharjah FC Sharjah FC 22 28 42 25
8 Al-Wasl Al-Wasl 22 27 36 23
9 Al Shabab Dubai Shabab Dubai 22 30 38 22
10 Al Ittihad Kalba Ittihad 22 22 31 22
11 Dubai Dubai 22 36 56 17
12 Al Dhafra Al Dhafra 22 29 52 17
TEMPORADA 2001/2002
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Ain Al-Ain 22 44 23 47
2 Al-Jazira Al-Jazira 22 50 33 38
3 Al-Shaab Sharjah Al-Shaab 22 40 26 37
4 Al-Wahda Al-Wahda 22 55 38 36
5 Al Ahli Dubai Ahli Dubai 22 42 35 30
6 Al-Wasl Al-Wasl 22 34 31 30
7 Sharjah FC Sharjah FC 22 44 44 28
8 Al Nasr Dubai Nasr Dubai 22 43 43 28
9 Al Ittihad Kalba Ittihad 22 28 36 26
10 Al Shabab Dubai Shabab Dubai 22 29 39 19
11 Khorfakkan Khorfakkan 22 35 61 18
12 Baniyas Baniyas 22 22 57 16
TEMPORADA 2000/2001
LIGA EMIRATOS GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Wahda Al-Wahda 22 62 34 50
2 Al Ahli Dubai Ahli Dubai 22 47 36 42
3 Al-Jazira Al-Jazira 22 47 33 38
4 Al-Ain Al-Ain 22 33 27 34
5 Al-Wasl Al-Wasl 22 42 32 32
6 Al-Shaab Sharjah Al-Shaab 22 32 26 32
7 Al Nasr Dubai Nasr Dubai 22 40 41 31
8 Al Shabab Dubai Shabab Dubai 22 33 36 29
9 Al Ittihad Kalba Ittihad 22 29 39 28
10 Emirates Club Emirates 22 29 38 22
11 Sharjah FC Sharjah FC 22 27 38 22
12 Al Fujairah Al Fujairah 22 15 56 6

  USO DE MEMORIA  
5,819,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.6562
Total Execution Time  0.6585
  CADENA URL  
/historico/Al-Shaab-62/2016
  GET DATOS  
$_GET['/historico/Al-Shaab-62/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0153  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-Shaab-62' AND l.year = 2016 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=15588 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=15588 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 16626
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15588 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1491 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1491 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  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 (777816,773928,694939,400432,106647) ORDER BY n.cover_points DESC, update_date DESC
0.0147  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 = '15588' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '15588' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = '15588' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 16626 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=15588 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (43958,16626,9345) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 9345 AND teamId = 15588
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 16626 AND teamId = 15588
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 43958 AND teamId = 15588
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 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 = 16626 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0156  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 events2016 e ON e.player_id = p.id AND e.league_id = 16626 WHERE rp.league_id = 16626 AND rp.teamId = 15588 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.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 events2016 e ON e.player_id = p.id AND e.league_id = 16626 WHERE rp.league_id = 16626 AND rp.teamId = 15588 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2016 e ON e.player_id = p.id AND e.league_id = 16626 WHERE rp.league_id = 16626 AND rp.teamId = 15588 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 15588 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 9345 AND t.round = 22 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 = 3251 AND t.round = 26 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 `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 = 2216 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 463 AND t.round = 22 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 `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 = 271 AND t.round = 22 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 `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 = 10395 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 14652 AND t.round = 22 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 `tables2005` 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 = 23803 AND t.round = 27 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 `tables2004` 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 = 23823 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 `tables2003` 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 = 23815 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 `tables2002` 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 = 23816 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 `tables2001` 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 = 23818 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 16626 ORDER BY nameShow LIMIT 100