4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Krumkachy
TEMPORADA 2023/2024
TERCERA BIELORRUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Gazovik Vitebsk Gazovik 1 3 0 3
2 Krumkachy Krumkachy 1 3 0 3
3 Slavia II Slavia II 1 3 0 3
4 Traktor Minsk Traktor 1 3 0 3
5 Uni Minsk Uni Minsk 1 3 0 3
6 Vitebsk II Vitebsk II 0 0 0 0
7 Dnepr Mogilev II Dnepr 1 0 3 0
8 Gomel II Gomel II 1 0 3 0
9 Minsk II Minsk II 1 0 3 0
10 Naftan II Naftan II 1 0 3 0
11 Polotsk Polotsk 1 0 3 0
TEMPORADA 2022/2023
TERCERA BIELORRUSIA GRUPO 16
Equipo PJ GF GC Puntos
1 Novaya Pripyat Novaya 3 7 4 7
2 Tsentr Futbola Tsentr 3 9 1 6
3 Viktoriya Maryina Horka Viktoriya 3 7 5 4
4 Neman Belkard Neman 3 1 14 0
5 Traktor Minsk Traktor 3 14 2 9
6 FK Stenles Pinsk Stenles 3 7 6 4
7 Smena Vawkavysk Smena 3 6 10 4
8 Kolos Cherven Kolos 3 1 10 0
9 Leskhoz Leskhoz 3 15 2 9
10 Partizan Salihorsk Partizan 3 9 6 6
11 Miory Miory 3 7 5 3
12 Servolyuks Servolyuks 3 4 22 0
13 Krumkachy Krumkachy 3 10 1 7
14 Mozyr NPZ Mozyr NPZ 3 3 2 6
15 FC Gorki FC Gorki 3 4 3 4
16 Gazovik Vitebsk Gazovik 3 1 12 0
TEMPORADA 2021/2022
TERCERA BIELORRUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Uni Minsk Uni Minsk 16 41 15 39
2 Krumkachy Krumkachy 16 51 12 38
3 Torpedo Minsk Torpedo 16 29 16 33
4 Traktor Minsk Traktor 16 45 25 29
5 BGU Minsk BGU Minsk 16 32 25 22
6 Energosbyt-BSATU Energosbyt-B 15 30 32 18
7 Urozhaynaya Urozhaynaya 15 18 24 12
8 SDJuShOR BFSO Dinamo SDJuShOR 16 19 52 10
9 Serebryanka Serebryanka 16 17 81 4
10 Favorit Favorit 0 0 0 0
TEMPORADA 2020/2021
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Arsenal Dzyarzhynsk Arsenal 33 59 22 68
2 Belshina Bobruisk Belshina 33 69 42 63
3 Krumkachy Krumkachy 33 58 31 60
4 Volna Pinsk Volna Pinsk 33 49 39 56
5 Dnepr Mogilev Dnepr 33 58 38 55
6 Lokomotiv Gomel Lokomotiv 33 56 39 54
7 Shakhtyor Petrikov Shakhtyor 33 50 56 46
8 Naftan Novopolotsk Naftan 33 44 46 44
9 FK Orsha FK Orsha 33 41 60 34
10 Baranovichi Baranovichi 33 38 72 28
11 FK Lida FK Lida 33 33 75 21
12 FC Slonim FC Slonim 33 27 62 16
TEMPORADA 2019/2020
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Sputnik Rechitsa Sputnik 26 50 18 61
2 Gomel Gomel 26 60 20 54
3 Krumkachy Krumkachy 26 46 28 52
4 Arsenal Dzyarzhynsk Arsenal 26 41 28 46
5 Lokomotiv Gomel Lokomotiv 26 56 38 45
6 FK Smorgon FK Smorgon 26 29 26 36
7 FK Lida FK Lida 26 37 42 31
8 FC Slonim FC Slonim 26 22 32 30
9 Volna Pinsk Volna Pinsk 26 41 52 27
10 Oshmyany Oshmyany 26 35 43 26
11 FK Orsha FK Orsha 26 30 42 24
12 Naftan Novopolotsk Naftan 26 36 43 21
13 Granit Mikashevichi Granit 26 21 52 17
14 Khimik Svetlogorsk Khimik 26 12 52 1
TEMPORADA 2018/2019
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Belshina Bobruisk Belshina 28 74 22 68
2 Smolevichy Smolevichy 28 60 15 64
3 Rukh Brest Rukh Brest 28 69 26 56
4 Lokomotiv Gomel Lokomotiv 28 60 24 56
5 Naftan Novopolotsk Naftan 28 58 43 47
6 Sputnik Rechitsa Sputnik 28 46 36 45
7 FK Lida FK Lida 28 49 32 44
8 Krumkachy Krumkachy 28 41 38 40
9 Granit Mikashevichi Granit 28 38 40 35
10 FK Orsha FK Orsha 28 33 65 31
11 Khimik Svetlogorsk Khimik 28 26 59 26
12 Volna Pinsk Volna Pinsk 28 29 49 21
13 FC Slonim FC Slonim 28 18 47 21
14 FK Smorgon FK Smorgon 28 26 63 18
15 Baranovichi Baranovichi 28 12 80 9
16 Zhitkovichi Zhitkovichi 0 0 0 0
TEMPORADA 2017/2018
TERCERA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Rukh Brest Rukh Brest 28 87 16 73
2 Krumkachy Krumkachy 28 80 16 72
3 Sputnik Rechitsa Sputnik 28 79 21 58
4 Oshmyany Oshmyany 28 82 33 55
5 FK Uzda FK Uzda 28 62 46 46
6 Osipovichy Osipovichy 28 52 41 43
7 Ivatsevichi Ivatsevichi 28 46 45 39
8 Victoria Maryina Victoria 28 36 50 35
9 Kletsk Kletsk 28 37 54 31
10 Molodechno Molodechno 28 46 64 31
11 SMI Autotrans Autotrans 28 32 66 31
12 Kronon Kronon 28 42 92 31
13 FC Gorki FC Gorki 28 38 76 22
14 Energosbyt-BSATU Energosbyt-B 28 39 64 22
15 Bumprom Bumprom 28 20 94 8
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
TERCERA BIELORRUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 FK Uzda FK Uzda 22 69 33 48
2 Baranovichi Baranovichi 22 55 19 48
3 Krumkachy Krumkachy 22 48 34 40
4 FC Kobrin FC Kobrin 22 46 40 40
5 Neman Mosty Neman Mosty 22 39 25 37
6 Torpedo Minsk Torpedo 22 28 26 29
7 Molodechno Molodechno 22 43 41 28
8 Kletsk Kletsk 22 36 56 28
9 Krutogorye Dzerzhinsk Krutogorye 22 29 39 27
10 Kolos-Druzhba Kolos-Druzhb 22 33 58 20
11 Partizan Minsk Partizan 22 21 44 18
12 Yua-Stroy Yua-Stroy 22 21 53 15

  USO DE MEMORIA  
6,016,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.6936
Total Execution Time  0.6947
  CADENA URL  
/historico/Krumkachy
  GET DATOS  
$_GET['/historico/Krumkachy']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0155  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 = 'Krumkachy' 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.0146  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=63388 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=63388 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=63388 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0299  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 = 75769
0.0153  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 = 71518
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63388 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1758 AND type_rel = 3
0.0152  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 = '63388' ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '63388' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0154  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 = '63388' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0161  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 = 71518 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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 = 75769 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0165  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=63388 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0153  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 (75769,71518) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 75769 AND teamId = 63388
0.0175  SELECT count(id) as num_players from rel_players WHERE league_id = 71518 AND teamId = 63388
0.0159  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 = 75769 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0157  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 = '63388' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '63388' and rp.type = 4
0.0146  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 = '63388' 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 = 75769 WHERE rp.league_id = 75769 AND rp.teamId = 63388 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.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 = 75769 WHERE rp.league_id = 75769 AND rp.teamId = 63388 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 75769 WHERE rp.league_id = 75769 AND rp.teamId = 63388 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 63388 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 = 75769 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 71516 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 74314 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 67326 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.0166  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 = 62163 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 55676 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.0165  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 = 49429 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 43298 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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.0155  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.0152  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.0150  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 = 16291 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC