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

Inhulets

Entrenador: Vladyslav Lupashko

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA UCRANIA GRUPO 2
Equipo PJ GF GC Puntos
1 Karpaty Lviv Karpaty Lviv 25 43 14 61
2 Inhulets Inhulets 25 52 15 58
3 Livyi Bereh Livyi Bereh 25 53 16 49
4 FK Epitsentr Epitsentr 25 36 27 43
5 FC Prykarpattia Prykarpattia 25 33 26 36
6 Nyva Buzova Nyva Buzova 25 28 30 36
7 FSC Mariupol Mariupol 25 26 22 35
8 Viktoriya Mykolaivka Viktoriya 25 21 25 35
9 SC Poltava SC Poltava 25 43 39 34
10 Ahrobiznes Volochysk Ahrobiznes 25 23 24 34
TEMPORADA 2022/2023
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 30 69 21 72
2 Dnipro-1 Dnipro-1 30 61 27 67
3 Zorya Luhansk Zorya 30 61 34 64
4 Dynamo Kyiv Dynamo Kyiv 30 51 25 60
5 Vorskla Poltava Vorskla 30 38 37 45
6 Oleksandriya Oleksandriya 30 42 39 44
7 FC Kryvbas FC Kryvbas 30 26 30 41
8 Minai Minai 30 25 30 36
9 Kolos Kovalivka Kolos 30 23 36 36
10 Chornomorets Odessa Chornomorets 30 35 40 35
11 Rukh Lviv Rukh Lviv 30 31 37 32
12 Metalist 1925 Kharkiv Metalist 30 23 42 32
13 Veres Rivne Veres Rivne 30 35 45 31
14 Inhulets Inhulets 30 22 34 31
15 Metalist Kharkiv Metalist 30 27 58 22
16 FC Lviv FC Lviv 30 18 52 13
TEMPORADA 2021/2022
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 18 49 10 47
2 Dynamo Kyiv Dynamo Kyiv 18 47 9 45
3 Dnipro-1 Dnipro-1 18 35 17 40
4 Zorya Luhansk Zorya 18 37 19 36
5 Vorskla Poltava Vorskla 18 30 18 33
6 Oleksandriya Oleksandriya 18 19 16 26
7 Desna Chernihiv Desna 18 22 27 25
8 Kolos Kovalivka Kolos 18 14 23 24
9 Veres Rivne Veres Rivne 18 15 20 23
10 Metalist 1925 Kharkiv Metalist 18 17 29 19
11 Rukh Lviv Rukh Lviv 17 16 21 18
12 FC Lviv FC Lviv 18 14 30 17
13 Chornomorets Odessa Chornomorets 18 20 40 14
14 Inhulets Inhulets 17 13 28 13
15 Minai Minai 18 12 30 10
16 FC Mariupol FC Mariupol 18 21 44 8
TEMPORADA 2020/2021
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Dynamo Kyiv Dynamo Kyiv 26 59 15 65
2 Shakhtar Donetsk Shakhtar 26 54 19 54
3 Zorya Luhansk Zorya 26 44 22 50
4 Kolos Kovalivka Kolos 26 36 26 41
5 Vorskla Poltava Vorskla 26 37 30 41
6 Desna Chernihiv Desna 26 38 32 38
7 Dnipro-1 Dnipro-1 26 36 38 30
8 FC Lviv FC Lviv 26 25 51 29
9 Oleksandriya Oleksandriya 26 33 37 29
10 Rukh Lviv Rukh Lviv 26 27 39 28
11 FC Mariupol FC Mariupol 26 27 41 26
12 Inhulets Inhulets 26 24 39 26
13 Olimpik Donetsk Olimpik 26 28 48 22
14 Minai Minai 26 16 47 18
TEMPORADA 2019/2020
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Minai Minai 30 51 28 62
2 Inhulets Inhulets 30 47 22 60
3 Ahrobiznes Volochysk Ahrobiznes 30 52 30 60
4 Rukh Lviv Rukh Lviv 29 48 21 58
5 Volyn Lutsk Volyn Lutsk 30 57 36 57
6 Obolon Obolon 30 40 31 51
7 Metalist 1925 Kharkiv Metalist 30 44 34 51
8 Avanhard Kramatorsk Avanhard 30 37 40 45
9 Hirnyk-Sport Hirnyk-Sport 30 42 48 39
10 Chornomorets Odessa Chornomorets 30 40 37 39
11 MFK Mykolaiv Mykolaiv 30 45 45 34
12 FC Prykarpattia Prykarpattia 30 44 51 30
13 Kremin Kremin 30 35 57 27
14 Balkany Zorya Balkany 30 27 51 25
15 Metalurh Zaporizhya Metalurh 29 28 55 22
16 Cherkashchyna-Akademiya Cherkashchyn 30 23 74 7
TEMPORADA 2018/2019
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Dnipro-1 Dnipro-1 28 72 21 67
2 Volyn Lutsk Volyn Lutsk 28 55 30 58
3 Kolos Kovalivka Kolos 28 49 18 54
4 Metalist 1925 Kharkiv Metalist 27 35 20 48
5 Avanhard Kramatorsk Avanhard 27 44 26 45
6 Obolon Obolon 27 35 28 44
7 Inhulets Inhulets 27 35 32 39
8 MFK Mykolaiv Mykolaiv 28 36 32 37
9 Balkany Zorya Balkany 27 28 31 35
10 Rukh Lviv Rukh Lviv 28 37 36 34
11 FC Prykarpattia Prykarpattia 27 41 39 31
12 Hirnyk-Sport Hirnyk-Sport 27 24 43 24
13 Sumy Sumy 27 21 88 16
14 Ahrobiznes Volochysk Ahrobiznes 26 14 36 13
15 Zirka Kirovohrad Zirka 17 10 49 4
16 Helios Kharkiv Helios 3 1 8 0
TEMPORADA 2017/2018
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Arsenal Kyiv Arsenal Kyiv 34 59 23 75
2 Poltava Poltava 34 56 26 72
3 Desna Chernihiv Desna 34 71 25 71
4 Inhulets Inhulets 34 46 20 69
5 Kolos Kovalivka Kolos 34 39 30 61
6 Avanhard Kramatorsk Avanhard 34 44 42 52
7 Hirnyk-Sport Hirnyk-Sport 34 30 40 50
8 Rukh Lviv Rukh Lviv 33 36 30 48
9 Helios Kharkiv Helios 33 35 43 46
10 MFK Mykolaiv Mykolaiv 34 39 50 44
11 Balkany Zorya Balkany 34 30 35 40
12 Sumy Sumy 33 29 39 37
13 Volyn Lutsk Volyn Lutsk 34 31 44 36
14 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 27 42 33
15 Obolon Obolon 33 24 37 32
16 Cherkashchyna-Akademiya Cherkashchyn 34 29 49 29
17 Kremin Kremin 33 25 54 29
18 Zhemchuzhyna Odesa Zhemchuzhyna 31 33 54 27
TEMPORADA 2016/2017
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 FC Mariupol FC Mariupol 34 61 21 81
2 Desna Chernihiv Desna 34 55 23 74
3 Veres Rivne Veres Rivne 34 62 32 67
4 Helios Kharkiv Helios 34 31 22 58
5 Kolos Kovalivka Kolos 34 52 38 57
6 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 47 29 54
7 Avanhard Kramatorsk Avanhard 34 32 28 52
8 Cherkashchyna-Akademiya Cherkashchyn 34 30 29 48
9 Obolon Obolon 34 37 37 45
10 Arsenal Kyiv Arsenal Kyiv 34 38 39 45
11 Hirnyk-Sport Hirnyk-Sport 34 47 54 43
12 Poltava Poltava 34 33 43 40
13 Inhulets Inhulets 34 33 45 38
14 MFK Mykolaiv Mykolaiv 34 35 44 37
15 Sumy Sumy 34 34 44 36
16 Bukovyna Chernivtsi Bukovyna 34 27 40 33
17 Skala Stryi Skala Stryi 34 25 58 20
18 Ternopil' Ternopil' 34 17 70 15
TEMPORADA 2015/2016
TERCERA UCRANIA
Equipo PJ GF GC Puntos
1 Kolos Kovalivka Kolos 26 62 22 60
2 Veres Rivne Veres Rivne 26 41 24 52
3 Inhulets Inhulets 26 37 16 50
4 Bukovyna Chernivtsi Bukovyna 26 39 22 47
5 Skala Stryi Skala Stryi 26 41 23 46
6 Arsenal Kyiv Arsenal Kyiv 26 37 30 43
7 Real Pharma Real Pharma 26 31 29 41
8 Kremin Kremin 26 43 31 40
9 Enerhiya Nova Kakhovka Enerhiya 26 31 38 33
10 Krystal Krystal 26 31 47 28
11 Myr Myr 26 38 47 27
12 Barsa Sumy Barsa Sumy 26 14 51 18
13 Arsenal Bila Tserkva Arsenal Bila 26 24 56 17
14 Makiyivvuhillya Makiyivvuhil 26 18 51 12

  USO DE MEMORIA  
6,120,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1452
Total Execution Time  0.1464
  CADENA URL  
/historico/Inhulets
  GET DATOS  
$_GET['/historico/Inhulets']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0040  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 = 'Inhulets' 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.0019  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=65296 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=65296 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=65296 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=65296 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=65296 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 = 74779
0.0025  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 = 72651
0.0024  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 = 73212
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65296 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 65296 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (634544,918607) 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 = '65296' ORDER BY l.year DESC,cat.coefficient DESC
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 = '65296' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0042  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 = '65296' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73212 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 72651 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=65296 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 (74779,73212,71951,71432,68061) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 68061 AND teamId = 65296
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74779 AND teamId = 65296
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73212 AND teamId = 65296
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71951 AND teamId = 65296
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65296
0.0020  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 = 74779 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '65296' 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 = '65296' 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 = '65296' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 74779 WHERE rp.league_id = 74779 AND rp.teamId = 65296 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.0033  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 = 74779 WHERE rp.league_id = 74779 AND rp.teamId = 65296 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 74779 WHERE rp.league_id = 74779 AND rp.teamId = 65296 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 = 65296 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72651 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 = 74779 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 68061 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.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 `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 = 62931 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 58446 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 49999 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.0030  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 = 44344 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 38758 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 = 33937 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 `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 = 15568 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 74779 ORDER BY nameShow LIMIT 100