4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Platinum
TEMPORADA 2023/2024
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 Highlanders Highlanders 9 15 7 18
2 Manica Diamonds Manica 9 9 8 16
3 Bulawayo Chiefs Bulawayo 9 10 7 15
4 Chicken Inn FC Chicken 9 9 6 15
5 Simba Bhora Simba Bhora 9 10 8 14
6 FC Platinum FC Platinum 8 10 8 12
7 Bikita Minerals FC Bikita 8 8 6 12
8 Kariba Kariba 9 6 5 12
9 Green Fuel Green Fuel 9 9 10 12
10 CAPS United CAPS United 8 9 7 10
11 Dynamos Dynamos 8 7 7 10
12 TelOne TelOne 9 11 12 10
13 Yadah Yadah 9 10 12 10
14 Ngezi Platinum Ngezi 9 7 9 9
15 Chegutu Pirates Chegutu 8 3 7 8
16 Arenel Movers Arenel 9 5 10 8
17 Herentals Herentals 8 6 9 7
18 Hwange Hwange 9 5 11 6
TEMPORADA 2022/2023
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 Ngezi Platinum Ngezi 34 45 23 66
2 Manica Diamonds Manica 34 42 23 58
3 Dynamos Dynamos 34 37 16 57
4 FC Platinum FC Platinum 34 37 29 55
5 Highlanders Highlanders 34 24 22 55
6 Herentals Herentals 34 38 33 51
7 Chicken Inn FC Chicken 34 35 26 49
8 CAPS United CAPS United 34 37 32 46
9 Hwange Hwange 34 27 27 45
10 Green Fuel Green Fuel 34 27 34 43
11 Kariba Kariba 34 27 48 41
12 Simba Bhora Simba Bhora 34 29 27 40
13 Bulawayo Chiefs Bulawayo 34 37 39 40
14 Yadah Yadah 34 35 46 40
15 Black Rhinos Black Rhinos 34 27 37 38
16 Triangle FC Triangle FC 34 24 36 35
17 Sheasham Sheasham 34 23 36 35
18 Cranborne Bullets Cranborne 34 16 33 27
TEMPORADA 2020/2021
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 FC Platinum FC Platinum 34 52 14 75
2 Chicken Inn FC Chicken 34 42 28 63
3 Dynamos Dynamos 34 33 17 58
4 Ngezi Platinum Ngezi 34 46 19 55
5 Highlanders Highlanders 34 44 32 51
6 Triangle FC Triangle FC 34 39 31 50
7 Bulawayo Chiefs Bulawayo 34 32 28 49
8 Herentals Herentals 34 33 30 48
9 Black Rhinos Black Rhinos 34 35 30 46
10 Manica Diamonds Manica 34 31 28 45
11 CAPS United CAPS United 34 35 42 40
12 Kariba Kariba 34 23 29 39
13 Cranborne Bullets Cranborne 34 30 43 38
14 Yadah Yadah 34 24 31 37
15 Harare City Harare City 34 24 32 35
16 Bulawayo City Bulawayo 34 24 42 34
17 Tenax FC Tenax FC 34 19 55 30
18 Whawha FC Whawha FC 34 28 63 24
TEMPORADA 2018/2019
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 FC Platinum FC Platinum 34 34 15 62
2 Chicken Inn FC Chicken 34 49 28 59
3 CAPS United CAPS United 34 53 42 58
4 Ngezi Platinum Ngezi 34 28 23 49
5 Manica Diamonds Manica 34 35 33 47
6 Highlanders Highlanders 34 30 26 46
7 Triangle FC Triangle FC 34 44 43 46
8 Kariba Kariba 34 29 31 46
9 Dynamos Dynamos 34 28 28 44
10 Black Rhinos Black Rhinos 34 26 30 44
11 Herentals Herentals 34 31 34 41
12 Harare City Harare City 34 35 39 41
13 Bulawayo Chiefs Bulawayo 34 33 44 41
14 Yadah Yadah 34 34 46 41
15 Chapungu United Chapungu 34 32 33 40
16 TelOne TelOne 34 32 35 40
17 Hwange Hwange 34 30 40 37
18 Mushowani Stars Mushowani 34 36 49 33
TEMPORADA 2017/2018
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 FC Platinum FC Platinum 34 52 14 78
2 Ngezi Platinum Ngezi 34 50 24 65
3 Chicken Inn FC Chicken 34 42 26 57
4 Triangle FC Triangle FC 34 43 33 56
5 Highlanders Highlanders 34 34 30 51
6 Herentals Herentals 34 28 24 51
7 Black Rhinos Black Rhinos 34 38 30 49
8 CAPS United CAPS United 34 34 30 48
9 Harare City Harare City 34 28 26 48
10 Kariba Kariba 34 29 28 45
11 Dynamos Dynamos 34 28 37 42
12 Bulawayo Chiefs Bulawayo 34 31 36 41
13 Yadah Yadah 34 33 40 41
14 Chapungu United Chapungu 34 27 34 39
15 Nichrut Nichrut 34 33 40 36
16 Bulawayo City Bulawayo 34 33 43 32
17 Mutare City Mutare City 34 24 55 23
18 Shabanie Mine Shabanie 34 24 61 19
TEMPORADA 2016/2017
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 FC Platinum FC Platinum 34 40 15 72
2 Dynamos Dynamos 34 55 26 70
3 Ngezi Platinum Ngezi 34 54 30 65
4 Chicken Inn FC Chicken 34 34 22 61
5 CAPS United CAPS United 34 43 29 58
6 Highlanders Highlanders 34 35 35 47
7 Black Rhinos Black Rhinos 34 35 30 46
8 How Mine How Mine 34 30 36 46
9 Triangle FC Triangle FC 34 37 36 45
10 Kariba Kariba 34 30 32 45
11 Chapungu United Chapungu 34 25 27 44
12 Shabanie Mine Shabanie 34 29 34 42
13 Yadah Yadah 34 31 40 40
14 Bulawayo City Bulawayo 34 37 44 39
15 Harare City Harare City 34 29 29 38
16 Hwange Hwange 34 29 38 37
17 Tsholotsho Tsholotsho 34 19 44 25
18 Bantu Rovers Bantu Rovers 34 28 73 16
TEMPORADA 2015/2016
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 CAPS United CAPS United 30 42 21 63
2 FC Platinum FC Platinum 30 38 15 61
3 Highlanders Highlanders 30 41 24 56
4 Chicken Inn FC Chicken 30 31 20 47
5 Dynamos Dynamos 30 29 24 46
6 Kariba Kariba 30 23 21 45
7 Ngezi Platinum Ngezi 30 29 27 41
8 Bulawayo City Bulawayo 30 27 27 41
9 Harare City Harare City 30 32 29 39
10 How Mine How Mine 30 27 25 39
11 Triangle FC Triangle FC 30 27 32 38
12 Hwange Hwange 30 24 35 36
13 Chapungu United Chapungu 30 22 27 32
14 Mutare City Mutare City 30 25 44 29
15 Tsholotsho Tsholotsho 30 23 38 26
16 Border Strikers Border 30 10 41 15
TEMPORADA 2014/2015
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 Chicken Inn FC Chicken 30 45 23 61
2 Dynamos Dynamos 30 36 20 57
3 FC Platinum FC Platinum 30 52 23 55
4 Triangle FC Triangle FC 30 46 25 49
5 CAPS United CAPS United 30 29 23 46
6 Highlanders Highlanders 31 38 32 42
7 Harare City Harare City 30 29 27 39
8 Hwange Hwange 30 32 32 39
9 Chapungu United Chapungu 30 26 27 39
10 Kariba Kariba 30 40 37 38
11 How Mine How Mine 31 29 35 36
12 Tsholotsho Tsholotsho 30 20 30 31
13 Buffaloes FC Buffaloes 30 23 41 29
14 Flame Lilly Flame Lilly 30 24 35 26
15 Whawha FC Whawha FC 30 17 51 23
16 Dongo Dongo 30 18 43 22
TEMPORADA 2013/2014
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 Dynamos Dynamos 30 34 18 57
2 Kariba Kariba 30 42 25 56
3 CAPS United CAPS United 30 38 27 53
4 FC Platinum FC Platinum 30 34 19 51
5 Highlanders Highlanders 30 38 29 45
6 Chicken Inn FC Chicken 30 31 27 44
7 Hwange Hwange 30 38 29 42
8 How Mine How Mine 30 33 33 40
9 Triangle FC Triangle FC 30 37 39 40
10 Buffaloes FC Buffaloes 30 33 43 39
11 Harare City Harare City 30 40 44 38
12 Chapungu United Chapungu 30 30 30 37
13 Black Rhinos Black Rhinos 30 21 29 37
14 Shabanie Mine Shabanie 30 33 40 35
15 Bantu Rovers Bantu Rovers 30 28 47 25
16 Chiredzi FC Chiredzi FC 30 16 47 15
TEMPORADA 2012/2013
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 Dynamos Dynamos 30 43 22 54
2 Highlanders Highlanders 30 45 27 54
3 Harare City Harare City 30 42 26 54
4 FC Platinum FC Platinum 30 40 29 50
5 CAPS United CAPS United 30 42 34 49
6 Chicken Inn FC Chicken 30 40 34 44
7 Triangle FC Triangle FC 30 44 35 42
8 Hwange Hwange 30 37 30 42
9 Black Rhinos Black Rhinos 30 33 35 40
10 Shabanie Mine Shabanie 30 34 38 40
11 How Mine How Mine 30 27 33 40
12 Buffaloes FC Buffaloes 30 40 43 39
13 Black Mambas Black Mambas 30 34 39 38
14 Monomotapa United Monomotapa 30 25 47 26
15 Tripple B Tripple B 30 27 60 22
16 Motor Action Motor Action 30 16 37 20
TEMPORADA 2011/2012
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 Dynamos Dynamos 30 58 15 69
2 Highlanders Highlanders 30 49 15 69
3 Chicken Inn FC Chicken 30 39 23 50
4 Monomotapa United Monomotapa 30 42 33 50
5 Shabanie Mine Shabanie 30 35 30 46
6 Buffaloes FC Buffaloes 30 25 24 44
7 FC Platinum FC Platinum 30 40 39 43
8 Motor Action Motor Action 30 35 28 42
9 Harare City Harare City 30 24 24 40
10 CAPS United CAPS United 30 28 30 39
11 Hwange Hwange 30 49 47 36
12 Black Mambas Black Mambas 30 34 42 34
13 Gunners FC Gunners FC 30 27 36 34
14 WWS Rangers WWS Rangers 30 30 64 25
15 Hardbody FC Hardbody FC 30 26 48 24
16 Quelaton FC Quelaton FC 30 15 58 14
TEMPORADA 2010/2011
PREMIER LEAGUE ZIMBABUE
Equipo PJ GF GC Puntos
1 Dynamos Dynamos 30 42 15 58
2 FC Platinum FC Platinum 30 44 21 58
3 Motor Action Motor Action 30 33 18 51
4 Hwange Hwange 30 31 23 50
5 Gunners FC Gunners FC 30 37 30 44
6 CAPS United CAPS United 30 44 34 43
7 Highlanders Highlanders 30 27 24 43
8 Chicken Inn FC Chicken 30 32 20 42
9 WWS Rangers WWS Rangers 30 32 42 38
10 Monomotapa United Monomotapa 30 27 30 36
11 Black Mambas Black Mambas 30 34 40 36
12 Shabanie Mine Shabanie 30 30 43 34
13 Masvingo FC Masvingo FC 30 31 46 34
14 Zimbabwe Saints FC Zimbabwe 30 23 36 28
15 Shooting Stars FC Shooting 30 27 45 27
16 Kiglon FC Kiglon FC 30 22 49 24

  USO DE MEMORIA  
6,334,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1100
Total Execution Time  0.1112
  CADENA URL  
/historico/Fc-Platinum
  GET DATOS  
$_GET['/historico/Fc-Platinum']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0030  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 = 'Fc-Platinum' 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=16040 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=16040 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 75452
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16040 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=479 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 479 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1121480,45568) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '16040' 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 = '16040' 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 = 75452 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=16040 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 (75452) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75452 AND teamId = 16040
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 = '16040' 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 = '16040' and rp.type = 4
0.0020  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 = '16040' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 75452 WHERE rp.league_id = 75452 AND rp.teamId = 16040 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.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 = 75452 WHERE rp.league_id = 75452 AND rp.teamId = 16040 AND (e.action = 4 or e.action = 5) 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 = 75452 WHERE rp.league_id = 75452 AND rp.teamId = 16040 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 16040 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75452 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.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 `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 = 71273 AND t.round = 34 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 `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 = 62681 AND t.round = 34 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 `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 = 49263 AND t.round = 34 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 `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 = 43090 AND t.round = 34 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 `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 = 38225 AND t.round = 34 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 `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 = 21227 AND t.round = 30 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 `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 = 10874 AND t.round = 30 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 `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 = 4843 AND t.round = 30 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 `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 = 3185 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 `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 = 28235 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 `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 = 28239 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC