4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al-Hussein SC
TEMPORADA 2023/2024
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Hussein SC Al-Hussein 17 36 3 47
2 Al-Faisaly Amman Al-Faisaly 17 43 9 42
3 Al-Wehdat Al-Wehdat 17 26 11 35
4 Al Ramtha Al Ramtha 17 22 19 28
5 Aqaba Aqaba 17 18 27 22
6 Al Salt Al Salt 17 14 21 19
7 Moghayer Al Sarhan Moghayer 17 19 26 18
8 Ma'an Ma'an 17 16 26 17
9 Shabab Al Ordon Shabab Ordon 17 12 27 16
10 Al Ahli Amman Ahli Amman 17 12 24 14
11 Al Jalil Al Jalil 17 9 19 12
12 Sahab Sahab 17 14 29 12
TEMPORADA 2021/2022
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Faisaly Amman Al-Faisaly 22 46 12 51
2 Al-Wehdat Al-Wehdat 22 33 11 50
3 Al-Hussein SC Al-Hussein 22 35 14 50
4 Shabab Al Ordon Shabab Ordon 22 32 29 33
5 Aqaba Aqaba 22 19 24 31
6 Al Ramtha Al Ramtha 22 27 25 26
7 Ma'an Ma'an 22 24 42 25
8 Al Salt Al Salt 22 22 30 24
9 Sahab Sahab 22 18 23 24
10 Moghayer Al Sarhan Moghayer 22 18 30 19
11 Al Sareeh Al Sareeh 22 20 34 17
12 Al-Jazeera Al-Jazeera 22 18 38 14
TEMPORADA 2020/2021
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 22 44 14 47
2 Al Ramtha Al Ramtha 22 38 16 47
3 Al Salt Al Salt 22 32 16 41
4 Al-Faisaly Amman Al-Faisaly 22 39 20 38
5 Shabab Al Ordon Shabab Ordon 22 28 22 33
6 Al-Hussein SC Al-Hussein 22 29 35 33
7 Al-Jazeera Al-Jazeera 22 34 33 28
8 Sahab Sahab 22 30 32 25
9 Aqaba Aqaba 22 20 29 25
10 Ma'an Ma'an 22 19 34 21
11 Al Jalil Al Jalil 22 15 32 19
12 Al Buqa'a Al Buqa'a 22 9 54 1
TEMPORADA 2019/2020
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 23 42 10 56
2 Al-Jazeera Al-Jazeera 25 40 24 53
3 Al Ramtha Al Ramtha 25 35 26 42
4 Al Salt Al Salt 24 36 26 35
5 Aqaba Aqaba 25 33 28 31
6 Al-Faisaly Amman Al-Faisaly 25 29 30 31
7 Ma'an Ma'an 25 26 28 30
8 Al-Hussein SC Al-Hussein 25 26 34 28
9 Shabab Al Ordon Shabab Ordon 25 34 42 27
10 Sahab Sahab 25 24 37 25
11 Al Sareeh Al Sareeh 23 24 36 21
12 Al Ahli Amman Ahli Amman 24 18 46 16
TEMPORADA 2018/2019
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Faisaly Amman Al-Faisaly 22 39 15 50
2 Al-Jazeera Al-Jazeera 22 41 15 49
3 Al-Wehdat Al-Wehdat 22 36 16 43
4 Shabab Al Ordon Shabab Ordon 22 30 21 39
5 Al Salt Al Salt 22 23 21 33
6 Aqaba Aqaba 22 27 28 27
7 Al Sareeh Al Sareeh 22 17 29 26
8 Al Ramtha Al Ramtha 22 26 30 23
9 Al-Hussein SC Al-Hussein 22 22 38 23
10 Al Ahli Amman Ahli Amman 22 16 31 22
11 Al Buqa'a Al Buqa'a 22 24 30 21
12 That Ras That Ras 22 12 39 9
TEMPORADA 2017/2018
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 22 45 13 53
2 Al-Faisaly Amman Al-Faisaly 22 33 18 41
3 Al-Jazeera Al-Jazeera 22 37 23 41
4 Al Ramtha Al Ramtha 22 30 16 39
5 Shabab Al Ordon Shabab Ordon 22 30 22 37
6 That Ras That Ras 22 19 22 23
7 Al Ahli Amman Ahli Amman 22 22 31 23
8 Al Buqa'a Al Buqa'a 22 21 33 23
9 Aqaba Aqaba 22 28 35 22
10 Al-Hussein SC Al-Hussein 22 20 31 22
11 Mansheyat Mansheyat 22 26 40 21
12 Al Yarmouk Al Yarmouk 22 16 43 15
TEMPORADA 2016/2017
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Faisaly Amman Al-Faisaly 22 32 11 46
2 Al-Jazeera Al-Jazeera 22 37 19 44
3 Al-Wehdat Al-Wehdat 22 32 13 42
4 Mansheyat Mansheyat 22 27 18 39
5 Al Ramtha Al Ramtha 22 22 17 33
6 Al-Hussein SC Al-Hussein 22 26 29 30
7 Al Ahli Amman Ahli Amman 22 25 26 27
8 Shabab Al Ordon Shabab Ordon 22 27 31 24
9 That Ras That Ras 22 15 27 19
10 Al Buqa'a Al Buqa'a 22 19 36 19
11 Al Sareeh Al Sareeh 22 18 34 18
12 Sahab Sahab 22 15 34 14
TEMPORADA 2015/2016
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 22 29 19 38
2 Al-Faisaly Amman Al-Faisaly 22 29 20 36
3 Al Ahli Amman Ahli Amman 22 22 21 35
4 Al-Jazeera Al-Jazeera 22 21 13 34
5 Shabab Al Ordon Shabab Ordon 22 28 25 33
6 Al Ramtha Al Ramtha 22 23 18 31
7 Al-Hussein SC Al-Hussein 22 28 27 30
8 That Ras That Ras 22 23 24 28
9 Al Buqa'a Al Buqa'a 22 21 24 28
10 Al Sareeh Al Sareeh 22 19 22 25
11 Kfarsoum Kfarsoum 22 21 30 24
12 Al Asalah Al Asalah 22 14 35 12
TEMPORADA 2014/2015
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 22 40 10 48
2 Al-Jazeera Al-Jazeera 22 26 15 43
3 Al Ramtha Al Ramtha 22 26 21 36
4 That Ras That Ras 22 24 16 33
5 Al Ahli Amman Ahli Amman 22 20 20 32
6 Al Sareeh Al Sareeh 22 21 25 28
7 Al Buqa'a Al Buqa'a 22 18 24 27
8 Al-Faisaly Amman Al-Faisaly 22 14 18 26
9 Al-Hussein SC Al-Hussein 22 23 29 26
10 Mansheyat Mansheyat 22 20 25 25
11 Shabab Al Ordon Shabab Ordon 22 16 24 25
12 Ittihad Al Ramtha Ittihad 22 16 37 6
TEMPORADA 2013/2014
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 22 31 12 46
2 Al-Faisaly Amman Al-Faisaly 22 29 18 42
3 Al-Jazeera Al-Jazeera 22 26 18 35
4 That Ras That Ras 22 26 18 34
5 Al-Baqa´a Al-Baqa´a 22 33 29 29
6 Al-Hussein SC Al-Hussein 22 28 30 29
7 Al Ramtha Al Ramtha 22 28 31 29
8 Al Sareeh Al Sareeh 22 25 26 26
9 Shabab Al Ordon Shabab Ordon 22 32 42 26
10 Mansheiat Bani Hasan Mansheiat 22 27 29 25
11 Al-Arabi Irbid Al-Arabi 22 29 36 25
12 Al Sheikh Hussein Sheikh 22 21 46 10
TEMPORADA 2010/2011
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 20 42 16 51
2 Al-Faisaly Amman Al-Faisaly 20 26 19 34
3 Shabab Al Ordon Shabab Ordon 20 38 26 33
4 Al Buqa'a Al Buqa'a 20 34 28 31
5 Mansheyat Mansheyat 20 25 26 27
6 Al Yarmouk Al Yarmouk 20 32 31 26
7 Al Ramtha Al Ramtha 20 16 24 23
8 Al-Jazeera Al-Jazeera 20 26 33 22
9 Al-Arabi Irbid Al-Arabi 20 23 29 19
10 Al-Hussein SC Al-Hussein 20 20 32 15
11 Kfarsoum Kfarsoum 20 13 31 15
12 Al Ahli Amman Ahli Amman 0 0 0 0
TEMPORADA 2009/2010
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Faisaly Amman Al-Faisaly 22 43 16 53
2 Al-Wehdat Al-Wehdat 22 39 11 52
3 Shabab Al Ordon Shabab Ordon 22 35 20 44
4 Al-Hussein SC Al-Hussein 22 29 24 29
5 Kfarsoum Kfarsoum 22 25 35 29
6 Al Buqa'a Al Buqa'a 22 22 24 26
7 Al-Jazeera Al-Jazeera 22 27 30 26
8 Al Ramtha Al Ramtha 22 31 36 25
9 Al Yarmouk Al Yarmouk 22 21 29 22
10 Al-Arabi Irbid Al-Arabi 22 31 42 21
11 Al Karmal Al Karmal 22 21 41 18
12 Ittihad Al Ramtha Ittihad 22 15 31 17
TEMPORADA 2008/2009
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 18 43 9 43
2 Shabab Al Ordon Shabab Ordon 18 37 16 41
3 Al-Faisaly Amman Al-Faisaly 18 34 13 39
4 Al-Jazeera Al-Jazeera 18 33 27 30
5 Al Buqa'a Al Buqa'a 18 23 23 26
6 Al-Arabi Irbid Al-Arabi 18 16 26 18
7 Al-Hussein SC Al-Hussein 18 12 27 16
8 Ittihad Al Ramtha Ittihad 18 16 34 16
9 Al Yarmouk Al Yarmouk 18 13 31 14
10 Shabab El Hussein Shabab 18 15 36 10
TEMPORADA 2007/2008
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 18 47 12 47
2 Al-Faisaly Amman Al-Faisaly 18 40 16 42
3 Shabab Al Ordon Shabab Ordon 18 27 15 29
4 Al-Hussein SC Al-Hussein 18 25 25 29
5 Al Buqa'a Al Buqa'a 18 28 23 25
6 Al-Arabi Irbid Al-Arabi 18 23 41 18
7 Al-Jazeera Al-Jazeera 18 25 27 16
8 Shabab El Hussein Shabab 18 21 36 16
9 Ittihad Al Ramtha Ittihad 18 18 34 12
10 Al Ahli Amman Ahli Amman 18 13 38 8
TEMPORADA 2006/2007
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 18 40 11 44
2 Al-Faisaly Amman Al-Faisaly 18 25 14 36
3 Al Buqa'a Al Buqa'a 18 25 17 34
4 Shabab Al Ordon Shabab Ordon 17 34 17 32
5 Al-Hussein SC Al-Hussein 18 26 18 26
6 Al-Jazeera Al-Jazeera 17 20 18 23
7 Al-Arabi Irbid Al-Arabi 18 17 31 15
8 Al Ramtha Al Ramtha 18 22 38 15
9 Al Yarmouk Al Yarmouk 18 15 28 14
10 Ittihad Al Ramtha Ittihad 18 10 42 4
TEMPORADA 2005/2006
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Shabab Al Ordon Shabab Ordon 18 41 20 42
2 Al-Faisaly Amman Al-Faisaly 18 35 13 40
3 Al-Wehdat Al-Wehdat 18 35 18 35
4 Al-Hussein SC Al-Hussein 18 26 20 29
5 Ittihad Al Ramtha Ittihad 18 23 28 26
6 Al Buqa'a Al Buqa'a 18 23 23 22
7 Shabab El Hussein Shabab 18 25 37 15
8 Al Yarmouk Al Yarmouk 18 17 30 15
9 Al-Jazeera Al-Jazeera 18 20 31 13
10 Kfarsoum Kfarsoum 18 17 42 10
TEMPORADA 2004/2005
LIGA JORDANIA
Equipo PJ GF GC Puntos
1 Al-Wehdat Al-Wehdat 18 41 8 50
2 Al-Hussein SC Al-Hussein 18 48 27 36
3 Al-Faisaly Amman Al-Faisaly 18 31 19 31
4 Shabab Al Ordon Shabab Ordon 18 40 27 29
5 Al Buqa'a Al Buqa'a 18 25 18 28
6 Shabab El Hussein Shabab 18 25 33 19
7 Kfarsoum Kfarsoum 18 21 34 19
8 Ittihad Al Ramtha Ittihad 18 26 38 18
9 Al Ahli Amman Ahli Amman 18 12 28 17
10 That Ras That Ras 18 19 56 7

  USO DE MEMORIA  
6,195,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4704
Total Execution Time  0.4716
  CADENA URL  
/historico/Al-Hussein-Sc
  GET DATOS  
$_GET['/historico/Al-Hussein-Sc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15504 AND type_rel = 2
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 = '15504' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '15504' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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=15504 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (73558,72223,71582) 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 = 72223 AND teamId = 15504
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73558 AND teamId = 15504
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 71582 AND teamId = 15504
0.0133  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 = 72223 WHERE rp.league_id = 72223 AND rp.teamId = 15504 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 = 72223 WHERE rp.league_id = 72223 AND rp.teamId = 15504 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 72223 WHERE rp.league_id = 72223 AND rp.teamId = 15504 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 15504 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72223 AND t.round = 17 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 `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 = 67186 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.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 `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 = 62042 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.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 `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 = 50134 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.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 `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 = 43572 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 `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 = 40070 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 `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 = 36879 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 `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 = 15701 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 `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 = 4173 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 `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 = 3256 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 `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 = 15673 AND t.round = 22 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 `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 = 15672 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 15671 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 `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 = 15670 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 `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 = 15669 AND t.round = 18 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 = 15668 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 `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 = 15667 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC