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

Isloch

Entrenador: Dmitriy Komarovskiy

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Slavia Mozyr Slavia Mozyr 6 14 5 16
2 Torpedo Zhodino Torpedo 6 6 1 13
3 Dinamo Brest Dinamo Brest 6 15 5 12
4 Dinamo Minsk Dinamo Minsk 6 10 2 12
5 Neman Grodno Neman Grodno 6 8 6 12
6 Vitebsk Vitebsk 6 7 5 10
7 Gomel Gomel 6 10 8 8
8 Isloch Isloch 6 7 6 8
9 Arsenal Dzyarzhynsk Arsenal 6 5 5 8
10 Naftan Novopolotsk Naftan 6 7 8 5
11 BATE Borisov BATE Borisov 6 3 7 5
12 Dnepr Mogilev Dnepr 6 2 7 5
13 FK Smorgon FK Smorgon 6 7 16 5
14 Slutsk Slutsk 6 4 9 4
15 Minsk Minsk 6 3 10 2
16 Shakhtyor Soligorsk Shakhtyor 6 3 11 -16
TEMPORADA 2022/2023
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Dinamo Minsk Dinamo Minsk 28 72 21 69
2 Neman Grodno Neman Grodno 28 60 22 62
3 Torpedo Zhodino Torpedo 28 33 18 49
4 Isloch Isloch 28 40 29 47
5 BATE Borisov BATE Borisov 28 49 32 47
6 Gomel Gomel 28 45 48 41
7 Slavia Mozyr Slavia Mozyr 28 32 30 40
8 Slutsk Slutsk 28 38 40 35
9 Minsk Minsk 28 21 26 33
10 Dinamo Brest Dinamo Brest 28 33 50 30
11 FK Smorgon FK Smorgon 28 28 59 24
12 Naftan Novopolotsk Naftan 28 28 57 23
13 Shakhtyor Soligorsk Shakhtyor 28 50 40 9
14 Energetik-BGU Energetik-BG 28 25 42 4
15 Belshina Bobruisk Belshina 28 21 61 3
TEMPORADA 2021/2022
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Shakhtyor Soligorsk Shakhtyor 30 55 17 65
2 Energetik-BGU Energetik-BG 30 50 27 60
3 BATE Borisov BATE Borisov 30 51 21 59
4 Dinamo Minsk Dinamo Minsk 30 50 25 59
5 Isloch Isloch 30 51 33 54
6 Minsk Minsk 30 47 43 44
7 Gomel Gomel 30 36 37 43
8 Torpedo Zhodino Torpedo 30 35 32 43
9 Neman Grodno Neman Grodno 30 39 36 40
10 Slavia Mozyr Slavia Mozyr 30 42 46 37
11 Slutsk Slutsk 30 26 41 32
12 Belshina Bobruisk Belshina 30 37 50 30
13 Dinamo Brest Dinamo Brest 30 29 43 27
14 Arsenal Dzyarzhynsk Arsenal 30 18 42 23
15 Vitebsk Vitebsk 30 28 49 22
16 Dnepr Mogilev Dnepr 30 21 73 12
TEMPORADA 2020/2021
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Shakhtyor Soligorsk Shakhtyor 30 62 18 75
2 BATE Borisov BATE Borisov 30 61 27 65
3 Dinamo Minsk Dinamo Minsk 30 55 20 62
4 Gomel Gomel 30 57 23 59
5 Rukh Brest Rukh Brest 30 52 28 58
6 Dinamo Brest Dinamo Brest 30 32 32 38
7 Vitebsk Vitebsk 30 37 41 37
8 Torpedo Zhodino Torpedo 30 38 43 36
9 Slutsk Slutsk 30 36 44 35
10 Isloch Isloch 30 38 47 34
11 Neman Grodno Neman Grodno 30 36 36 34
12 Minsk Minsk 30 32 52 33
13 Energetik-BGU Energetik-BG 30 35 42 33
14 Slavia Mozyr Slavia Mozyr 30 42 50 32
15 FK Smorgon FK Smorgon 30 26 66 21
16 Sputnik Rechitsa Sputnik 30 12 82 7
TEMPORADA 2019/2020
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Shakhtyor Soligorsk Shakhtyor 30 57 21 59
2 BATE Borisov BATE Borisov 30 65 32 58
3 Torpedo Zhodino Torpedo 30 55 37 56
4 Dinamo Brest Dinamo Brest 30 63 40 54
5 Neman Grodno Neman Grodno 30 41 29 53
6 Dinamo Minsk Dinamo Minsk 30 38 25 52
7 Isloch Isloch 30 47 46 45
8 Rukh Brest Rukh Brest 30 57 38 44
9 Slavia Mozyr Slavia Mozyr 30 41 49 39
10 Energetik-BGU Energetik-BG 30 43 46 38
11 Minsk Minsk 30 45 57 38
12 Vitebsk Vitebsk 30 30 38 36
13 FK Gorodeya FK Gorodeya 30 30 48 31
14 Slutsk Slutsk 29 31 55 27
15 Belshina Bobruisk Belshina 30 34 71 21
16 Smolevichy Smolevichy 29 27 72 14
TEMPORADA 2018/2019
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Dinamo Brest Dinamo Brest 30 70 22 75
2 BATE Borisov BATE Borisov 30 61 21 70
3 Shakhtyor Soligorsk Shakhtyor 30 59 21 65
4 Dinamo Minsk Dinamo Minsk 30 43 39 50
5 Isloch Isloch 30 42 36 47
6 Torpedo Zhodino Torpedo 30 41 36 45
7 FK Gorodeya FK Gorodeya 30 31 29 44
8 Slavia Mozyr Slavia Mozyr 30 35 40 37
9 Minsk Minsk 30 36 44 36
10 Neman Grodno Neman Grodno 30 28 37 36
11 Slutsk Slutsk 30 29 46 34
12 Energetik-BGU Energetik-BG 30 52 66 33
13 Vitebsk Vitebsk 30 24 39 31
14 Dnyapro Dnyapro 30 32 42 30
15 Gomel Gomel 30 44 50 29
16 Torpedo Minsk Torpedo 30 4 63 6
TEMPORADA 2017/2018
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 30 55 24 73
2 Shakhtyor Soligorsk Shakhtyor 30 45 14 64
3 Dinamo Minsk Dinamo Minsk 30 41 17 63
4 Vitebsk Vitebsk 30 47 20 62
5 Torpedo Zhodino Torpedo 30 36 18 55
6 Dinamo Brest Dinamo Brest 30 52 30 52
7 Neman Grodno Neman Grodno 30 31 32 43
8 Slutsk Slutsk 30 26 36 36
9 FK Gorodeya FK Gorodeya 30 31 33 34
10 Isloch Isloch 30 20 37 33
11 Minsk Minsk 30 34 42 30
12 Gomel Gomel 30 16 36 28
13 Luch Minsk Luch Minsk 30 24 44 24
14 Torpedo Minsk Torpedo 30 20 41 24
15 Smolevichy Smolevichy 30 21 39 24
16 Dnepr Mogilev Dnepr 30 17 53 16
TEMPORADA 2016/2017
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 30 61 19 68
2 Dinamo Minsk Dinamo Minsk 30 46 15 68
3 Shakhtyor Soligorsk Shakhtyor 30 52 22 65
4 Dinamo Brest Dinamo Brest 30 47 26 51
5 Torpedo Zhodino Torpedo 30 43 27 51
6 Neman Grodno Neman Grodno 30 42 32 49
7 Slutsk Slutsk 30 30 34 44
8 Vitebsk Vitebsk 30 35 38 43
9 FK Gorodeya FK Gorodeya 30 37 35 38
10 Gomel Gomel 30 24 25 35
11 Isloch Isloch 30 27 46 27
12 Dnepr Mogilev Dnepr 30 27 48 26
13 Krumkachy Krumkachy 30 26 47 25
14 Minsk Minsk 30 19 39 23
15 Slavia Mozyr Slavia Mozyr 30 26 50 20
16 Naftan Novopolotsk Naftan 30 18 57 13
TEMPORADA 2015/2016
LIGA BIELORRUSIA
Equipo PJ GF GC Puntos
1 BATE Borisov BATE Borisov 30 73 25 70
2 Shakhtyor Soligorsk Shakhtyor 30 46 20 59
3 Dinamo Minsk Dinamo Minsk 30 46 28 55
4 Minsk Minsk 30 49 24 53
5 Torpedo Zhodino Torpedo 30 47 33 48
6 Vitebsk Vitebsk 30 30 26 42
7 Isloch Isloch 30 35 40 41
8 Dinamo Brest Dinamo Brest 30 39 40 40
9 FK Gorodeya FK Gorodeya 30 36 39 38
10 Slavia Mozyr Slavia Mozyr 30 33 49 35
11 Krumkachy Krumkachy 30 24 39 33
12 Slutsk Slutsk 30 22 34 30
13 Neman Grodno Neman Grodno 30 21 36 29
14 Naftan Novopolotsk Naftan 30 25 46 29
15 Belshina Bobruisk Belshina 30 34 45 25
16 Granit Mikashevichi Granit 30 20 56 25
TEMPORADA 2014/2015
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Isloch Isloch 30 76 24 69
2 FK Gorodeya FK Gorodeya 30 73 25 68
3 Krumkachy Krumkachy 30 67 45 60
4 Dnepr Mogilev Dnepr 30 48 21 56
5 FK Smorgon FK Smorgon 30 60 41 53
6 FK Lida FK Lida 30 60 53 50
7 Smolevichy Smolevichy 30 47 37 47
8 Lokomotiv Gomel Lokomotiv 30 45 39 44
9 FC Slonim FC Slonim 30 41 55 41
10 Energetik-BGU Energetik-BG 30 47 47 40
11 Byaroza Byaroza 30 39 43 34
12 Khimik Svetlogorsk Khimik 30 42 50 34
13 Baranovichi Baranovichi 30 36 49 32
14 FK Orsha FK Orsha 30 24 70 17
15 FC Kobrin FC Kobrin 30 23 77 15
16 Rechytsa Rechytsa 30 14 66 11
TEMPORADA 2013/2014
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Granit Mikashevichi Granit 30 46 16 64
2 Slavia Mozyr Slavia Mozyr 30 55 38 60
3 Vitebsk Vitebsk 30 44 30 50
4 FK Smorgon FK Smorgon 30 42 32 46
5 Rechytsa Rechytsa 30 41 36 46
6 FK Gorodeya FK Gorodeya 30 42 26 45
7 Isloch Isloch 30 39 35 45
8 Khimik Svetlogorsk Khimik 30 34 36 43
9 Energetik-BGU Energetik-BG 30 50 48 40
10 Smolevichy Smolevichy 30 37 41 40
11 Lokomotiv Gomel Lokomotiv 30 33 38 36
12 Minsk II Minsk II 30 41 45 33
13 Byaroza Byaroza 30 37 48 33
14 FK Lida FK Lida 30 46 64 31
15 FC Slonim FC Slonim 30 32 50 30
16 Volna Pinsk Volna Pinsk 30 26 62 20
TEMPORADA 2012/2013
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Slutsk Slutsk 30 54 19 66
2 FK Gorodeya FK Gorodeya 30 68 32 60
3 Vitebsk Vitebsk 30 40 29 55
4 FK Lida FK Lida 30 53 38 52
5 FC Bereza 2010 Bereza 2010 30 44 30 50
6 FK Smorgon FK Smorgon 30 45 35 46
7 Granit Mikashevichi Granit 30 42 31 45
8 Smolevichy Smolevichy 30 50 37 44
9 Isloch Isloch 30 39 37 41
10 Khimik Svetlogorsk Khimik 30 37 36 41
11 Rechytsa Rechytsa 30 47 36 39
12 Volna Pinsk Volna Pinsk 30 30 41 39
13 FC Slonim FC Slonim 30 38 45 34
14 Dinamo Minsk II Dinamo Minsk 30 32 49 26
15 SKVICH Minsk SKVICH Minsk 30 21 63 12
16 Polotsk Polotsk 30 10 92 10
TEMPORADA 2011/2012
TERCERA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Smolevichy Smolevichy 36 113 22 87
2 Beltransgaz Beltransgaz 36 95 35 78
3 Isloch Isloch 36 61 30 70
4 Lokomotiv Gomel Lokomotiv 36 64 27 69
5 Minsk II Minsk II 36 60 33 68
6 Dinamo Minsk II Dinamo Minsk 36 52 44 60
7 Energetik-BGU Energetik-BG 36 54 41 58
8 FC Slonim FC Slonim 36 61 55 55
9 BelCard Grodno BelCard 36 54 45 53
10 Zhlobin Zhlobin 36 53 66 51
11 Neman Mosty Neman Mosty 36 50 54 46
12 Dnepr Mogilev II Dnepr 36 49 60 43
13 Baranovichi Baranovichi 36 33 42 40
14 Krutogorye Dzerzhinsk Krutogorye 36 47 72 39
15 Molodechno Molodechno 36 45 86 38
16 Miory Miory 36 47 82 35
17 FK Orsha FK Orsha 36 30 72 35
18 Osipovichy Osipovichy 36 47 74 33
19 Vitebsk II Vitebsk II 36 24 99 10
20 Klechesk Klechesk 0 0 0 0

  USO DE MEMORIA  
6,728,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6176
Total Execution Time  0.6188
  CADENA URL  
/historico/Isloch-363
  GET DATOS  
$_GET['/historico/Isloch-363']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0147  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 = 'Isloch-363' 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.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=14237 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=14237 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=14237 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=14237 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 = 74849
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14237 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 14237 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131  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 (686899,808326,812670,820853,834870) ORDER BY n.cover_points DESC, update_date DESC
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 = '14237' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '14237' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 74849 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=14237 AND l.year in (2023,2024,2025) 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 (74849,71518,71432) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 74849 AND teamId = 14237
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71518 AND teamId = 14237
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 14237
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 = '14237' 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 = '14237' 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 = '14237' 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 events2024 e ON e.player_id = p.id AND e.league_id = 74849 WHERE rp.league_id = 74849 AND rp.teamId = 14237 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.0161  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 = 74849 WHERE rp.league_id = 74849 AND rp.teamId = 14237 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 = 74849 WHERE rp.league_id = 74849 AND rp.teamId = 14237 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 14237 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0142  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 = 74849 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 70895 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.0145  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 = 66797 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.0142  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 = 61109 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.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 = 55492 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.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 = 49072 AND t.round = 30 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 `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 = 42965 AND t.round = 30 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 `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 = 37943 AND t.round = 30 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 `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 = 21241 AND t.round = 30 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 = 12778 AND t.round = 30 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 = 4168 AND t.round = 30 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 `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 = 2830 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0252  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 = 16296 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC