4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Enerhiya Nova Kakhovka
TEMPORADA 2014/2015
TERCERA UCRANIA
Equipo PJ GF GC Puntos
1 Cherkashchyna-Akademiya Cherkashchyn 27 53 12 65
2 Obolon Obolon 27 47 19 64
3 Kremin Kremin 27 50 30 48
4 Real Pharma Real Pharma 27 40 29 42
5 Skala Stryi Skala Stryi 27 29 34 38
6 Krystal Krystal 27 39 37 36
7 Shakhtar Donetsk III Shakhtar 27 38 43 30
8 Makiyivvuhillya Makiyivvuhil 27 23 45 21
9 Arsenal Bila Tserkva Arsenal Bila 27 14 40 20
10 Enerhiya Nova Kakhovka Enerhiya 27 25 69 15
TEMPORADA 2013/2014
TERCERA UCRANIA
Equipo PJ GF GC Puntos
1 Hirnyk-Sport Hirnyk-Sport 36 68 31 75
2 Stal Dniprodzerzhynsk Stal 36 81 32 73
3 Ternopil' Ternopil' 36 56 27 67
4 Hirnyk Hirnyk 36 49 36 64
5 Kremin Kremin 36 54 28 62
6 Shakhtar Sverdlovsk Shakhtar 36 48 29 61
7 Obolon Obolon 36 51 34 56
8 Cherkashchyna-Akademiya Cherkashchyn 35 46 33 56
9 Shakhtar Donetsk III Shakhtar 35 47 50 48
10 Myr Myr 35 32 27 47
11 Krystal Krystal 36 51 48 47
12 Enerhiya Mykolajiv Enerhiya 34 24 28 42
13 Karlivka Karlivka 35 31 45 38
14 Real Pharma Real Pharma 35 27 57 38
15 Nikopol Nikopol 35 33 47 36
16 Arsenal Bila Tserkva Arsenal Bila 36 27 57 32
17 Dynamo Khmelnytskyi Dynamo 35 18 52 25
18 Enerhiya Nova Kakhovka Enerhiya 36 38 85 25
19 Skala Stryi Skala Stryi 35 22 57 21
TEMPORADA 2012/2013
TERCERA UCRANIA GRUPO 2
Equipo PJ GF GC Puntos
1 UkrAhroKom Holovkivka UkrAhroKom 24 38 17 50
2 Shakhtar Donetsk III Shakhtar 24 57 22 48
3 Shakhtar Sverdlovsk Shakhtar 24 33 18 45
4 Karlivka Karlivka 24 29 15 44
5 Kremin Kremin 24 39 21 43
6 Myr Myr 24 37 33 42
7 Hirnyk Hirnyk 24 35 26 37
8 Stal Dniprodzerzhynsk Stal 24 47 30 33
9 Sevastopol II Sevastopol 24 25 44 23
10 Enerhiya Nova Kakhovka Enerhiya 24 25 50 21
11 Hirnyk-Sport Hirnyk-Sport 24 25 50 18
12 Nikopol Nikopol 24 21 58 17
13 Zhemchuzhyna Yalta Zhemchuzhyna 24 21 48 13
TEMPORADA 2011/2012
TERCERA UCRANIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sumy Sumy 26 51 13 62
2 Desna Chernihiv Desna 26 48 19 57
3 Cherkashchyna-Akademiya Cherkashchyn 26 36 16 51
4 Enerhiya Nova Kakhovka Enerhiya 26 51 18 50
5 UkrAhroKom Holovkivka UkrAhroKom 26 43 25 44
6 FC Prykarpattia Prykarpattia 26 40 32 32
7 Real Pharma Real Pharma 26 28 41 31
8 Chornomorets II Chornomorets 25 19 20 29
9 Krystal Krystal 26 30 32 28
10 Skala Stryi Skala Stryi 26 26 36 24
11 Dynamo Khmelnytskyi Dynamo 26 23 50 18
12 Nyva Ternopil Nyva 26 30 41 16
13 SKAD-Yalpuh SKAD-Yalpuh 25 10 54 16
14 Yednist Yednist 26 19 57 13
TEMPORADA 2010/2011
TERCERA UCRANIA GRUPO 1
Equipo PJ GF GC Puntos
1 MFK Mykolaiv Mykolaiv 22 29 12 46
2 Sumy Sumy 22 38 13 45
3 Enerhiya Nova Kakhovka Enerhiya 22 38 17 42
4 Bastion Bastion 22 38 16 41
5 Desna Chernihiv Desna 22 38 24 40
6 Chornomorets II Chornomorets 22 27 17 34
7 Skala Stryi Skala Stryi 22 26 19 33
8 Yednist Yednist 22 39 26 32
9 Dynamo Khmelnytskyi Dynamo 22 19 29 20
10 Nyva Ternopil Nyva 22 17 51 12
11 Ros Bila Tserkva Bila Tserkva 22 20 58 8
12 Veres Rivne Veres Rivne 22 4 51 4
TEMPORADA 1995/1996
TERCERA UCRANIA GRUPO 1
Equipo PJ GF GC Puntos
1 CSKA Kyiv CSKA Kyiv 37 61 27 80
2 Krystal Krystal 36 78 30 70
3 Khurtovyk Tysmenytsia Khurtovyk 37 66 33 69
4 Obolon Obolon 38 64 35 69
5 Kalush Kalush 38 64 31 68
6 Desna Chernihiv Desna 38 55 30 66
7 Borisfen Borisfen 37 59 36 64
8 Haray Zhovkva Haray 35 49 35 58
9 Inter Boyarka Inter 38 34 31 57
10 Hazovyk Komarno Hazovyk 38 47 38 56
11 Zhydachiv Zhydachiv 37 44 44 56
12 Karpaty Karpaty 38 42 35 53
13 Halychyna (Drohobych) Halychyna 37 41 40 47
14 Keramik Baranivka Keramik 36 38 41 47
15 Slavutych Slavutych 37 43 51 46
16 Energya Yuzhnoukrainsk Energya 38 34 67 37
17 Ros Bila Tserkva Bila Tserkva 36 28 61 30
18 Ahrotekhservis Sumy Ahrotekhserv 37 28 78 27
19 Skify Lviv Skify Lviv 20 20 28 23
20 Enerhiya Nova Kakhovka Enerhiya 19 11 49 12
21 Dynamo Khmelnytskyi Dynamo 41 14 100 9
TEMPORADA 1994/1995
TERCERA UCRANIA
Equipo PJ GF GC Puntos
1 Shakhtar Shakhtarsk Shakhtar 62 74 73 94
2 Spartak Sumy Spartak Sumy 42 71 30 93
3 FC Lviv FC Lviv 40 73 39 87
4 Dynamo Luhansk Dynamo 41 72 46 83
5 Dynamo Saky Dynamo Saky 42 63 33 80
6 Portovik Kerch Portovik 81 96 128 80
7 Tytan Armyansk Tytan 42 68 36 76
8 Halychyna (Drohobych) Halychyna 40 49 29 74
9 Hazovyk Komarno Hazovyk 41 66 39 69
10 Enerhiya Nova Kakhovka Enerhiya 40 49 40 66
11 Berdiansk Berdiansk 42 40 43 59
12 Desna Chernihiv Desna 42 44 43 58
13 FC Mariupol FC Mariupol 42 37 55 57
14 Chaika Chaika 42 42 45 56
15 Ros Bila Tserkva Bila Tserkva 41 41 63 49
16 FC Kryvbas FC Kryvbas 39 40 57 45
17 Artaniya Ochakiv Artaniya 40 30 58 41
18 Shakhtar Donetsk II Shakhtar 60 53 96 41
19 Chornomorets Odessa II Chornomorets 41 19 48 26
20 Krystal Krystal 21 16 28 22
21 Zhovti Vody Zhovti Vody 21 19 33 18
TEMPORADA 1993/1994
TERCERA UCRANIA
Equipo PJ GF GC Puntos
1 Borisfen Borisfen 41 84 28 91
2 Bazhanovets Bazhanovets 42 83 44 82
3 Zirka Kirovohrad Zirka 42 60 41 82
4 Naftokhymyk Naftokhymyk 42 69 41 79
5 Spartak Sumy Spartak Sumy 42 63 36 76
6 Shakhtar Shakhtarsk Shakhtar 63 62 69 74
7 Enerhiya Nova Kakhovka Enerhiya 42 56 37 66
8 Dynamo Luhansk Dynamo 42 47 40 64
9 Halychyna (Drohobych) Halychyna 42 46 43 57
10 FC Mariupol FC Mariupol 42 43 58 55
11 Druzhba Berdiansk Druzhba 42 42 60 54
12 Krystal Krystal 42 44 49 52
13 Chornomorets Odessa II Chornomorets 41 43 55 52
14 Tytan Armyansk Tytan 42 47 38 51
15 Chaika Chaika 42 49 60 51
16 Hazovyk Komarno Hazovyk 42 43 46 50
17 Metalurh Zaporizhya II Metalurh 42 41 58 48
18 Portovik Kerch Portovik 42 50 69 47
19 Ros Bila Tserkva Bila Tserkva 41 35 52 45
20 Shakhtar Donetsk II Shakhtar 42 29 58 39
21 Dnister Zalishchyky Dnister 40 29 62 39
22 Vahonobudivnyk (Stahanov) Vahonobudivn 20 21 42 16
TEMPORADA 1992/1993
TERCERA UCRANIA
Equipo PJ GF GC Puntos
1 Dnipro Dnipropetrovsk Dnipro 34 59 33 69
2 Khimik Krasnoperekopsk Khimik 32 51 26 68
3 Spartak Sumy Spartak Sumy 34 42 27 58
4 Zirka Kirovohrad Zirka 34 50 33 57
5 Enerhiya Nova Kakhovka Enerhiya 34 45 37 57
6 Chaika Chaika 34 57 45 49
7 Hazovyk Komarno Hazovyk 34 37 47 47
8 Halychyna (Drohobych) Halychyna 34 42 40 45
9 Makiivvuhillya Makiivvuhill 34 38 45 44
10 Shakhtar Donetsk II Shakhtar 34 33 30 42
11 Vahonobudivnyk (Stahanov) Vahonobudivn 34 39 44 41
12 FC Mariupol FC Mariupol 34 34 47 38
13 Dnister Zalishchyky Dnister 34 30 45 38
14 Tytan Armyansk Tytan 34 42 54 36
15 Berdiansk Berdiansk 34 30 49 36
16 Chornomorets Odessa II Chornomorets 34 36 43 35
17 CSKA Kyiv CSKA Kyiv 34 27 50 34
18 Krystal Krystal 17 17 24 13
TEMPORADA 1991/1992
TERCERA UCRANIA GRUPO 2
Equipo PJ GF GC Puntos
1 Makiivvuhillya Makiivvuhill 16 25 8 33
2 Tytan Armyansk Tytan 16 19 10 29
3 Enerhiya Nova Kakhovka Enerhiya 16 21 16 29
4 Shakhtar Shakhtarsk Shakhtar 16 27 10 28
5 Berdiansk Berdiansk 16 17 8 26
6 Portovik Kerch Portovik 16 16 10 23
7 FC Kryvbas FC Kryvbas 16 10 33 13
8 Antratsyt Kirovske Antratsyt 15 15 32 9
9 More Feodosia More 15 2 25 3

  USO DE MEMORIA  
5,945,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5524
Total Execution Time  0.5536
  CADENA URL  
/historico/Enerhiya-Nova-Kakhovka/2015
  GET DATOS  
$_GET['/historico/Enerhiya-Nova-Kakhovka/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0135  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 = 'Enerhiya-Nova-Kakhovka' 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.0125  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=60317 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=60317 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 9214
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60317 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1530 AND type_rel = 3
0.0129  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 = '60317' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '60317' AND l.year = 2015 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 = '60317' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = '60317' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 9214 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=60317 AND l.year in (2014,2015,2016) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (16403,16268) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 16268 AND teamId = 60317
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 16403 AND teamId = 60317
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 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 = 9214 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '60317' 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 = '60317' 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 = '60317' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  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 = 9214 WHERE rp.league_id = 9214 AND rp.teamId = 60317 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.0138  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 = 9214 WHERE rp.league_id = 9214 AND rp.teamId = 60317 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 9214 WHERE rp.league_id = 9214 AND rp.teamId = 60317 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 60317 AND l.year <= 2015 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 9214 AND t.round = 27 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 `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 = 16268 AND t.round = 38 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 `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 = 16270 AND t.round = 26 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 `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 = 16271 AND t.round = 26 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 = 16273 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 `tables1996` 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 = 27650 AND t.round = 44 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 `tables1995` 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 = 27649 AND t.round = 44 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 `tables1994` 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 = 27648 AND t.round = 44 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 `tables1993` 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 = 27647 AND t.round = 36 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 `tables1992` 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 = 27644 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 9214 ORDER BY nameShow LIMIT 100