4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lokomotiv Gomel
TEMPORADA 2023/2024
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Molodechno Molodechno 4 8 3 10
2 FK Lida FK Lida 4 6 2 10
3 Volna Pinsk Volna Pinsk 4 9 3 9
4 Belshina Bobruisk Belshina 4 7 4 9
5 BATE Reservas BATE 4 9 7 9
6 Niva Dolbizno Niva 4 7 5 7
7 Ostrovets Ostrovets 4 5 4 7
8 Bumprom Bumprom 4 11 5 6
9 Maxline Vitebsk Maxline 4 6 4 5
10 Dinamo Minsk Reservas Dinamo Minsk 4 3 4 4
11 Energetik-BGU Energetik-BG 4 3 4 4
12 FC Slonim FC Slonim 4 5 7 4
13 Baranovichi Baranovichi 4 3 5 4
14 Torpedo Zhodino Reservas Torpedo 4 8 12 4
15 ABFF Sub 17 ABFF Sub 17 4 2 9 3
16 Lokomotiv Gomel Lokomotiv 4 3 7 2
17 FK Orsha FK Orsha 4 5 10 2
18 Shakhtyor Petrikov Shakhtyor 4 1 6 1
TEMPORADA 2022/2023
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Arsenal Dzyarzhynsk Arsenal 32 86 30 81
2 Dnepr Mogilev Dnepr 32 75 24 73
3 Vitebsk Vitebsk 32 68 22 73
4 Lokomotiv Gomel Lokomotiv 32 55 40 62
5 Maxline Vitebsk Maxline 32 84 52 61
6 Baranovichi Baranovichi 32 46 49 48
7 Zhodino Yuzhnoe Zhodino 32 62 52 46
8 Volna Pinsk Volna Pinsk 32 41 49 43
9 FK Lida FK Lida 32 44 48 41
10 Niva Dolbizno Niva 32 53 66 41
11 Molodechno Molodechno 32 51 56 41
12 Ostrovets Ostrovets 32 54 62 39
13 Bumprom Bumprom 32 45 62 38
14 FK Orsha FK Orsha 32 50 62 31
15 FC Slonim FC Slonim 32 26 63 22
16 Shakhtyor Petrikov Shakhtyor 32 33 72 22
17 Osipovichy Osipovichy 32 21 85 5
TEMPORADA 2021/2022
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Naftan Novopolotsk Naftan 24 55 19 53
2 FK Smorgon FK Smorgon 24 46 27 52
3 Shakhtyor Petrikov Shakhtyor 24 69 20 45
4 Maxline Vitebsk Maxline 24 45 34 41
5 Ostrovets Ostrovets 24 42 34 40
6 Lokomotiv Gomel Lokomotiv 24 39 24 39
7 Volna Pinsk Volna Pinsk 24 44 35 36
8 Molodechno Molodechno 24 30 45 29
9 FK Orsha FK Orsha 24 33 52 27
10 FK Lida FK Lida 24 35 43 26
11 FC Slonim FC Slonim 24 24 53 18
12 Osipovichy Osipovichy 24 21 53 13
13 Baranovichi Baranovichi 24 25 69 12
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
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Slavia Mozyr Slavia Mozyr 28 69 13 70
2 Energetik-BGU Energetik-BG 28 70 20 70
3 Belshina Bobruisk Belshina 28 59 23 59
4 FK Lida FK Lida 28 42 19 55
5 Naftan Novopolotsk Naftan 28 28 24 41
6 Lokomotiv Gomel Lokomotiv 28 44 29 40
7 FC Slonim FC Slonim 28 37 37 36
8 Granit Mikashevichi Granit 28 28 34 35
9 Khimik Svetlogorsk Khimik 28 32 40 32
10 Yua-Stroy Yua-Stroy 28 23 38 28
11 FK Smorgon FK Smorgon 28 19 44 28
12 FK Orsha FK Orsha 28 33 53 27
13 Volna Pinsk Volna Pinsk 28 23 49 25
14 Baranovichi Baranovichi 28 17 42 19
15 Čist́ Čist́ 28 30 89 10
TEMPORADA 2016/2017
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Luch Minsk Luch Minsk 30 73 22 73
2 Smolevichy Smolevichy 30 46 22 58
3 Torpedo Minsk Torpedo 30 57 29 55
4 Lokomotiv Gomel Lokomotiv 29 45 37 51
5 Belshina Bobruisk Belshina 30 56 30 49
6 Granit Mikashevichi Granit 30 42 37 46
7 Energetik-BGU Energetik-BG 30 39 27 45
8 Volna Pinsk Volna Pinsk 30 48 48 43
9 FK Orsha FK Orsha 30 48 48 37
10 Khimik Svetlogorsk Khimik 30 35 42 37
11 FC Slonim FC Slonim 30 33 46 37
12 Baranovichi Baranovichi 29 34 44 31
13 FK Smorgon FK Smorgon 30 34 50 29
14 FK Lida FK Lida 30 28 39 28
15 Osipovichy Osipovichy 30 30 62 25
16 Kronon Kronon 30 28 93 16
TEMPORADA 2015/2016
SEGUNDA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Dnepr Mogilev Dnepr 26 61 19 64
2 Gomel Gomel 26 48 11 63
3 Luch Minsk Luch Minsk 26 44 29 45
4 Lokomotiv Gomel Lokomotiv 26 31 27 41
5 FK Smorgon FK Smorgon 26 40 39 38
6 FK Lida FK Lida 26 26 33 38
7 FK Orsha FK Orsha 26 43 34 37
8 Smolevichy Smolevichy 26 38 29 34
9 Torpedo Minsk Torpedo 26 35 36 33
10 Energetik-BGU Energetik-BG 26 33 41 33
11 FC Slonim FC Slonim 26 36 49 24
12 Khimik Svetlogorsk Khimik 26 26 49 23
13 Baranovichi Baranovichi 26 33 52 20
14 Oshmyany Oshmyany 26 19 65 9
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
TERCERA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Lokomotiv Gomel Lokomotiv 24 60 17 63
2 Neman Mosty Neman Mosty 24 64 29 51
3 Energetik-BGU Energetik-BG 24 45 16 49
4 Zhlobin Zhlobin 24 47 48 41
5 Baranovichi Baranovichi 24 37 33 36
6 FK Orsha FK Orsha 24 41 25 35
7 FC Kobrin FC Kobrin 24 41 42 35
8 Krutogorye Dzerzhinsk Krutogorye 24 25 44 26
9 Osipovichy Osipovichy 24 28 35 23
10 Molodechno Molodechno 24 32 51 22
11 Partizan Minsk Partizan 24 26 46 22
12 Luch Minsk Luch Minsk 24 24 41 20
13 Vitebsk II Vitebsk II 24 22 65 11
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
TEMPORADA 2010/2011
TERCERA BIELORRUSIA
Equipo PJ GF GC Puntos
1 Byaroza Byaroza 30 77 28 73
2 FK Lida FK Lida 30 60 21 73
3 Beltransgaz Beltransgaz 30 84 29 64
4 Molodechno Molodechno 30 58 38 58
5 FC Slonim FC Slonim 30 51 27 54
6 Lokomotiv Gomel Lokomotiv 30 49 28 51
7 Energetik-BGU Energetik-BG 30 40 32 42
8 Krutogorye Dzerzhinsk Krutogorye 30 35 39 42
9 Neman Mosty Neman Mosty 30 31 54 37
10 Partizan Minsk II Partizan 30 54 56 35
11 Smolevichy Smolevichy 30 45 48 32
12 Dinamo Minsk II Dinamo Minsk 30 45 58 32
13 Zhlobin Zhlobin 30 38 74 24
14 Vertykal Vertykal 30 27 61 22
15 FK Orsha FK Orsha 30 31 86 21
16 Osipovichy Osipovichy 30 39 85 20
TEMPORADA 2009/2010
TERCERA BIELORRUSIA
Equipo PJ GF GC Puntos
1 FK Gorodeya FK Gorodeya 34 112 29 84
2 Slutsk Slutsk 34 79 30 81
3 Klechesk Klechesk 34 91 35 76
4 Molodechno Molodechno 34 69 52 57
5 Energetik-BGU Energetik-BG 34 76 47 55
6 Byaroza Byaroza 34 57 55 54
7 Lokomotiv Gomel Lokomotiv 34 63 58 52
8 Osipovichy Osipovichy 34 51 64 50
9 Neman Mosty Neman Mosty 34 54 50 48
10 Spartak Shklov Spartak 33 52 58 45
11 Smolevichy Smolevichy 34 32 41 41
12 Beltransgaz Beltransgaz 34 46 55 40
13 Gomel II Gomel II 33 36 46 36
14 Zhlobin Zhlobin 34 48 74 34
15 FK Orsha FK Orsha 34 40 75 33
16 Vertykal Vertykal 34 42 67 32
17 Krutogorye Dzerzhinsk Krutogorye 34 25 81 21
18 DSK Gomel II Gomel 34 19 75 17

  USO DE MEMORIA  
6,890,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1278
Total Execution Time  0.1291
  CADENA URL  
/historico/Gomelzheldortrans
  GET DATOS  
$_GET['/historico/Gomelzheldortrans']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
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 = 'Gomelzheldortrans' 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=19161 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=19161 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=19161 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=19161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19161 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=363 AND type_rel = 3
0.0029  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 = '19161' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '19161' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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.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 = 75651 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=19161 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 (75651,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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 75651 AND teamId = 19161
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 71518 AND teamId = 19161
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19161
0.0023  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 = '19161' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19161' 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 = '19161' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0027  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 = 75651 WHERE rp.league_id = 75651 AND rp.teamId = 19161 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.0025  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 = 75651 WHERE rp.league_id = 75651 AND rp.teamId = 19161 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 75651 WHERE rp.league_id = 75651 AND rp.teamId = 19161 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 = 19161 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 75651 AND t.round = 5 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 `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 = 71426 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.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 `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 = 67261 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.0020  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.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 `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.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 = 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.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 `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 = 43238 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 38085 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 `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 = 23627 AND t.round = 26 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 `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.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 `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.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 `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 = 16292 AND t.round = 26 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 = 16296 AND t.round = 38 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 `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 = 16294 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 `tables2010` 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 = 16295 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC