4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del African Stars
TEMPORADA 2023/2024
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 African Stars African 29 55 20 61
2 Ongo's Ongo's 29 46 26 58
3 Khomas Nampol Khomas 29 53 25 56
4 UNAM UNAM 29 34 25 43
5 Eeshoke Eeshoke 28 32 26 42
6 Mighty Gunners Mighty 29 29 24 42
7 Okahandj United Okahandj 29 36 39 42
8 Tigers SC Tigers SC 29 28 28 40
9 Blue Waters Blue Waters 29 30 29 39
10 Young Africans Young 29 24 26 38
11 Young Brazilians Young 28 31 45 35
12 Civics FC Civics FC 29 21 30 30
13 Julinho Sporting Julinho 29 21 35 28
14 Orlando Pirates Orlando 29 22 42 26
15 Okakarara Okakarara 29 26 47 26
16 Life Fighters Life 29 16 37 20
TEMPORADA 2022/2023
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 African Stars African 30 62 15 73
2 Blue Waters Blue Waters 30 49 29 61
3 Life Fighters Life 30 52 37 51
4 Mighty Gunners Mighty 30 45 30 50
5 UNAM UNAM 30 28 24 47
6 Okahandj United Okahandj 30 31 30 43
7 Tigers SC Tigers SC 30 40 33 42
8 Tura Magic FC Tura Magic 30 43 43 42
9 Young Africans Young 30 27 27 40
10 Civics FC Civics FC 30 34 33 37
11 Orlando Pirates Orlando 30 40 47 36
12 Young Brazilians Young 30 36 58 34
13 Julinho Sporting Julinho 30 42 53 33
14 Black Africa Black Africa 30 29 40 30
15 Eleven Arrows Eleven 30 32 44 26
16 Citizens Citizens 30 18 65 11
TEMPORADA 2019/2020
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 African Stars African 0 0 0 0
2 Black Africa Black Africa 0 0 0 0
3 Blue Waters Blue Waters 0 0 0 0
4 Citizens Citizens 0 0 0 0
5 Eleven Arrows Eleven 0 0 0 0
6 Julinho Sporting Julinho 0 0 0 0
7 Life Fighters Life 0 0 0 0
8 Mighty Gunners Mighty 0 0 0 0
9 Okahandj United Okahandj 0 0 0 0
10 Tigers SC Tigers SC 0 0 0 0
11 Tura Magic FC Tura Magic 0 0 0 0
12 UNAM UNAM 0 0 0 0
13 Young Brazilians Young 0 0 0 0
TEMPORADA 2018/2019
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 Black Africa Black Africa 14 37 10 35
2 Mighty Gunners Mighty 13 16 11 22
3 African Stars African 12 16 13 22
4 Life Fighters Life 13 19 15 21
5 Citizens Citizens 13 18 15 20
6 Tura Magic FC Tura Magic 14 15 13 20
7 UNAM UNAM 13 17 14 18
8 Julinho Sporting Julinho 13 21 23 18
9 Eleven Arrows Eleven 13 14 17 16
10 Tigers SC Tigers SC 13 11 10 15
11 Okahandj United Okahandj 14 13 15 15
12 Civics FC Civics FC 13 16 20 14
13 Young Brazilians Young 12 15 23 12
14 Blue Waters Blue Waters 13 11 21 9
15 Orlando Pirates Orlando 13 8 27 6
16 Young Africans Young 0 0 0 0
TEMPORADA 2017/2018
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 African Stars African 30 40 14 64
2 Black Africa Black Africa 30 52 29 55
3 Mighty Gunners Mighty 30 48 36 54
4 UNAM UNAM 31 46 32 51
5 Young Africans Young 30 35 25 47
6 Tigers SC Tigers SC 32 42 39 46
7 Tura Magic FC Tura Magic 30 41 36 43
8 Citizens Citizens 31 39 49 40
9 Orlando Pirates Orlando 30 39 39 39
10 Eleven Arrows Eleven 30 48 49 39
11 Life Fighters Life 30 28 39 37
12 Civics FC Civics FC 30 33 27 35
13 Blue Waters Blue Waters 30 33 43 32
14 Young Chiefs Young Chiefs 30 29 36 31
15 Rundu Chiefs FC Rundu Chiefs 30 34 55 27
16 Chief Santos Chief Santos 30 20 59 17
TEMPORADA 2015/2016
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 Tigers SC Tigers SC 30 46 25 67
2 Black Africa Black Africa 30 44 18 59
3 Tura Magic FC Tura Magic 30 45 27 51
4 African Stars African 30 33 20 48
5 Mighty Gunners Mighty 30 47 41 44
6 Blue Waters Blue Waters 30 38 32 44
7 Civics FC Civics FC 30 37 33 43
8 Orlando Pirates Orlando 30 35 34 43
9 Eleven Arrows Eleven 30 30 36 40
10 UNAM UNAM 30 38 38 36
11 Rundu Chiefs FC Rundu Chiefs 30 32 35 36
12 Young Chiefs Young Chiefs 30 32 38 32
13 Citizens Citizens 30 35 47 32
14 United Stars United Stars 30 40 55 28
15 Julinho Sporting Julinho 30 28 44 28
16 Flamingo FC Flamingo FC 30 19 56 24
TEMPORADA 2014/2015
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 African Stars African 30 52 15 68
2 Black Africa Black Africa 30 51 21 61
3 Tura Magic FC Tura Magic 30 53 28 56
4 United Africa Tigers United 30 45 24 55
5 Blue Waters Blue Waters 30 45 32 52
6 Orlando Pirates Orlando 30 40 35 50
7 Civics FC Civics FC 30 34 25 44
8 Mighty Gunners Mighty 30 40 42 39
9 Citizens Citizens 30 33 35 37
10 UNAM UNAM 30 35 44 37
11 United Stars United Stars 30 31 43 34
12 Eleven Arrows Eleven 30 39 45 33
13 Julinho Sporting Julinho 30 28 54 32
14 Touch & Go Touch & Go 30 38 50 31
15 Rebels Rebels 30 20 54 18
16 Benfica Benfica 30 20 57 14
TEMPORADA 2013/2014
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 Black Africa Black Africa 22 32 14 46
2 African Stars African 22 36 17 45
3 Orlando Pirates Orlando 22 28 19 42
4 United Africa Tigers United 22 32 26 36
5 Blue Waters Blue Waters 22 37 31 32
6 Tura Magic FC Tura Magic 22 21 19 31
7 Civics FC Civics FC 22 22 20 30
8 Ramblers Ramblers 22 24 28 26
9 United Stars United Stars 22 26 35 26
10 Eleven Arrows Eleven 22 24 36 19
11 Rundu Chiefs FC Rundu Chiefs 22 20 38 18
12 Blue Boys Blue Boys 22 20 39 16
TEMPORADA 2012/2013
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 Black Africa Black Africa 22 38 17 47
2 African Stars African 22 39 18 44
3 United Africa Tigers United 22 31 23 35
4 Orlando Pirates Orlando 22 26 24 35
5 Tura Magic FC Tura Magic 22 29 35 29
6 Ramblers Ramblers 22 26 23 27
7 Eleven Arrows Eleven 22 22 29 26
8 Rundu Chiefs FC Rundu Chiefs 22 23 33 25
9 Civics FC Civics FC 22 29 31 24
10 Blue Waters Blue Waters 22 24 29 23
11 SK Windhoek SK Windhoek 22 24 42 23
12 Mighty Gunners Mighty 22 30 37 22
TEMPORADA 2011/2012
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 Black Africa Black Africa 22 42 12 55
2 Civics FC Civics FC 22 30 17 38
3 African Stars African 22 26 17 35
4 Blue Waters Blue Waters 22 27 21 34
5 SK Windhoek SK Windhoek 22 19 14 33
6 United Africa Tigers United 22 23 21 32
7 Ramblers Ramblers 22 23 24 29
8 Mighty Gunners Mighty 22 27 30 27
9 Orlando Pirates Orlando 22 26 25 24
10 Eleven Arrows Eleven 22 18 31 20
11 United Stars United Stars 22 15 36 17
12 Hotspurs Hotspurs 22 23 51 14
TEMPORADA 2010/2011
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 Black Africa Black Africa 22 40 19 45
2 Ramblers Ramblers 22 22 15 35
3 Orlando Pirates Orlando 22 30 24 35
4 African Stars African 22 23 16 33
5 United Africa Tigers United 22 27 20 31
6 Eleven Arrows Eleven 22 28 22 31
7 SK Windhoek SK Windhoek 22 23 26 31
8 Blue Waters Blue Waters 22 27 29 29
9 Civics FC Civics FC 22 18 27 29
10 Mighty Gunners Mighty 22 24 32 26
11 Blue Boys Blue Boys 22 27 38 24
12 Oshakati City Oshakati 22 22 43 19
TEMPORADA 2009/2010
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 African Stars African 22 31 13 44
2 Orlando Pirates Orlando 22 37 24 42
3 Black Africa Black Africa 22 43 24 37
4 United Africa Tigers United 22 21 14 37
5 Eleven Arrows Eleven 22 19 15 34
6 Blue Waters Blue Waters 22 27 23 33
7 SK Windhoek SK Windhoek 22 29 33 29
8 Civics FC Civics FC 22 42 31 28
9 Oshakati City Oshakati 22 23 39 24
10 Ramblers Ramblers 22 23 37 20
11 Hotspurs Hotspurs 22 24 35 16
12 United Stars United Stars 22 26 57 15
TEMPORADA 2008/2009
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 African Stars African 22 33 19 49
2 Civics FC Civics FC 22 39 20 46
3 Black Africa Black Africa 22 44 18 45
4 SK Windhoek SK Windhoek 22 32 19 43
5 Eleven Arrows Eleven 22 45 28 39
6 Orlando Pirates Orlando 22 30 22 36
7 Ramblers Ramblers 22 29 29 27
8 Hotspurs Hotspurs 22 26 37 26
9 Oshakati City Oshakati 22 24 34 23
10 United Africa Tigers United 22 33 48 17
11 Chief Santos Chief Santos 22 15 39 12
12 Mighty Gunners Mighty 22 16 53 5
TEMPORADA 2007/2008
LIGA NAMIBIA
Equipo PJ GF GC Puntos
1 Orlando Pirates Orlando 22 35 14 41
2 Civics FC Civics FC 22 27 19 37
3 Ramblers Ramblers 22 35 25 35
4 Black Africa Black Africa 22 31 28 34
5 SK Windhoek SK Windhoek 22 20 17 34
6 Eleven Arrows Eleven 22 27 25 32
7 African Stars African 22 31 27 31
8 Oshakati City Oshakati 22 27 30 28
9 United Africa Tigers United 22 29 31 27
10 Mighty Gunners Mighty 22 20 27 20
11 Blue Waters Blue Waters 22 18 33 15
12 Fedics United Fedics 22 26 50 15

  USO DE MEMORIA  
6,377,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1176
Total Execution Time  0.1190
  CADENA URL  
/historico/African-Stars
  GET DATOS  
$_GET['/historico/African-Stars']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0031  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 = 'African-Stars' 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.0018  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=15865 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15865 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15865 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73329
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15865 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=491 AND type_rel = 3
0.0023  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 = '15865' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '15865' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 74211 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=15865 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74211,73329) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 74211 AND teamId = 15865
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73329 AND teamId = 15865
0.0024  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 = 74211 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '15865' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15865' and rp.type = 4
0.0021  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 = '15865' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 = 74211 WHERE rp.league_id = 74211 AND rp.teamId = 15865 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.0020  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 = 74211 WHERE rp.league_id = 74211 AND rp.teamId = 15865 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 74211 WHERE rp.league_id = 74211 AND rp.teamId = 15865 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 15865 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 74211 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.0022  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 = 70594 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 51598 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 47889 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 41232 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 15623 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 8452 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 3239 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 16392 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 16391 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 16390 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 16389 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 16388 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 16387 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC