4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Emirates Club

Emirates Club

Entrenador: Walter Zenga

Temporada 2014/2015
TEMPORADA 2014/2015
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Ain Al-Ain 26 62 19 60
2 Al-Jazira Al-Jazira 26 66 46 51
3 Al Shabab Dubai Shabab Dubai 26 49 35 49
4 Al-Wahda Al-Wahda 26 44 32 47
5 Al Nasr Dubai Nasr Dubai 26 43 32 39
6 Al-Wasl Al-Wasl 26 53 45 39
7 Al Ahli Dubai Ahli Dubai 26 35 27 38
8 Baniyas Baniyas 26 42 37 35
9 Al Fujairah Al Fujairah 26 23 45 32
10 Emirates Club Emirates 26 34 45 30
11 Al Dhafra Al Dhafra 26 31 33 27
12 Sharjah FC Sharjah FC 26 36 43 26
13 Ajman Ajman 26 27 60 15
14 Al Ittihad Kalba Ittihad 26 17 63 10
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
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Emirates Club Emirates 26 81 36 59
2 Sharjah FC Sharjah FC 26 58 25 59
3 Hatta Club Hatta Club 26 62 51 46
4 Al Fujairah Al Fujairah 26 63 35 45
5 Dibba Al Hisn Dibba Hisn 26 56 32 43
6 Al Urooba Al Urooba 26 60 36 42
7 Al Dhaid Al Dhaid 26 48 38 39
8 Khorfakkan Khorfakkan 26 44 49 36
9 Al Arabi SC Al Arabi SC 26 43 54 36
10 Masafi Masafi 26 36 39 29
11 Al Taawon SC Taawon 26 36 64 25
12 Al Jazira Al Hamra Jazira Hamra 26 33 65 25
13 Al Ramms Al Ramms 26 37 65 19
14 Masfut Masfut 26 29 97 7
TEMPORADA 2011/2012
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Ain Al-Ain 22 52 16 55
2 Al Nasr Dubai Nasr Dubai 22 49 33 41
3 Al Shabab Dubai Shabab Dubai 22 39 27 38
4 Al-Jazira Al-Jazira 22 47 38 35
5 Al Ahli Dubai Ahli Dubai 22 45 42 34
6 Al-Wahda Al-Wahda 22 32 30 33
7 Ajman Ajman 22 36 35 31
8 Al-Wasl Al-Wasl 22 32 40 26
9 Baniyas Baniyas 22 34 39 24
10 Dubai Dubai 22 29 40 20
11 Emirates Club Emirates 22 28 56 17
12 Sharjah FC Sharjah FC 22 26 53 11
TEMPORADA 2010/2011
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Ajman Ajman 21 48 29 40
2 Emirates Club Emirates 21 44 31 37
3 Dibba Al Fujairah Dibba 21 36 29 32
4 Al Urooba Al Urooba 21 23 23 31
5 Al Fujairah Al Fujairah 21 25 31 31
6 Khorfakkan Khorfakkan 21 41 44 28
7 Al Shaab CSC Shaab 21 27 33 25
8 Al Dhaid Al Dhaid 21 16 40 9
TEMPORADA 2009/2010
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Wahda Al-Wahda 22 45 15 58
2 Al-Jazira Al-Jazira 22 48 26 51
3 Al-Ain Al-Ain 22 57 29 45
4 Baniyas Baniyas 22 44 37 36
5 Al-Wasl Al-Wasl 22 41 40 29
6 Sharjah FC Sharjah FC 22 37 36 28
7 Al Shabab Dubai Shabab Dubai 22 35 44 28
8 Al Ahli Dubai Ahli Dubai 22 42 43 26
9 Al Dhafra Al Dhafra 22 47 55 26
10 Al Nasr Dubai Nasr Dubai 22 37 49 23
11 Emirates Club Emirates 22 37 57 14
12 Ajman Ajman 22 29 68 8
TEMPORADA 2008/2009
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Baniyas Baniyas 30 80 25 70
2 Emirates Club Emirates 30 84 39 62
3 Al Fujairah Al Fujairah 30 64 50 61
4 Al Urooba Al Urooba 30 54 33 55
5 Al Ittihad Kalba Ittihad 30 63 37 52
6 Hatta Club Hatta Club 30 59 43 52
7 Dubai Dubai 30 56 48 51
8 Dibba Al Hisn Dibba Hisn 30 50 47 43
9 Al Jazira Al Hamra Jazira Hamra 30 45 46 42
10 Ras Al Khaima Khaima 30 51 62 37
11 Al Dhaid Al Dhaid 30 40 51 31
12 Al Ramms Al Ramms 30 43 54 30
13 Dibba Al Fujairah Dibba 30 40 63 29
14 Al Arabi SC Al Arabi SC 30 39 72 29
15 Masafi Masafi 30 28 60 18
16 Al Hamriyah Al Hamriyah 30 33 99 15
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 2000/2001
LIGA EMIRATOS GRUPO 2
Equipo PJ GF GC Puntos
1 Emirates Club Emirates 1 0 0 1
2 Sharjah FC Sharjah FC 1 0 0 1

  USO DE MEMORIA  
6,225,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7305
Total Execution Time  0.7317
  CADENA URL  
/historico/Emirates-Club-Ras-Al-Khaimah/2015
  GET DATOS  
$_GET['/historico/Emirates-Club-Ras-Al-Khaimah/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0191  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 = 'Emirates-Club-Ras-Al-Khaimah' AND l.year = 2015 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.0130  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=982 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=982 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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=982 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0135  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=982 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0266  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 = 4458
0.0154  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 = 53505
0.0154  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 = 9018
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=982 AND type_rel = 2
0.0136  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 982 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0132  SELECT /*35 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 (558,107103,113493,115304,226634) ORDER BY n.cover_points DESC, update_date DESC
0.0148  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 = '982' ORDER BY l.year DESC,cat.coefficient DESC
0.0143  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 = '982' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '982' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136  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 = 9018 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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 = 53505 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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 = 4458 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0182  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=982 AND l.year in (2014,2015,2016) ORDER BY l.id DESC, l.year DESC ;
0.0134  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 (53508,23804,15741) 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.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 15741 AND teamId = 982
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 53508 AND teamId = 982
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 23804 AND teamId = 982
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 4458 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '982' 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 = '982' and rp.type = 4
0.0127  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 = '982' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0141  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 events2015 e ON e.player_id = p.id AND e.league_id = 4458 WHERE rp.league_id = 4458 AND rp.teamId = 982 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.0147  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 events2015 e ON e.player_id = p.id AND e.league_id = 4458 WHERE rp.league_id = 4458 AND rp.teamId = 982 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 events2015 e ON e.player_id = p.id AND e.league_id = 4458 WHERE rp.league_id = 4458 AND rp.teamId = 982 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 982 AND l.year <= 2015 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 = 4458 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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.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 `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 = 15232 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 1653 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 15234 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 1651 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 `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 = 15236 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 `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.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 `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.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 `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.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 `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.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 `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.0132  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.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 `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 = 23820 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC