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

FC Saturn

Entrenador: Oleg Kononov

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Dinamo Moskva II Dinamo 4 12 3 10
2 Baltika II Baltika II 4 11 3 10
3 Chertanovo Chertanovo 4 8 3 8
4 Rodina Moskva III Rodina 4 6 3 8
5 Spartak Moskva II Spartak 4 5 3 8
6 Znamya Znamya 4 5 7 7
7 Torpedo Vladimir Torpedo 4 9 6 6
8 Zenit II Zenit II 4 7 5 6
9 Dynamo St Petersburg Dynamo 4 7 6 6
10 Dinamo Vologda Dinamo 4 3 3 5
11 Tver Tver 4 6 7 4
12 FC Saturn FC Saturn 3 3 8 3
13 Luki-Energiya Luki-Energiy 4 2 8 3
14 Irkutsk Irkutsk 3 2 8 1
15 Zvezda St. Petersburg Zvezda 4 1 7 1
16 Yenisey II Yenisey II 4 1 8 0
TEMPORADA 2022/2023
SEGUNDA B RUSIA - TRANSICIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Kaluga Kaluga 17 50 6 39
2 Sakhalinets Sakhalinets 17 38 21 36
3 Spartak Tambov Spartak 17 26 22 33
4 Dinamo Vladivostok Dinamo 17 30 21 30
5 Arsenal Tula II Arsenal Tula 17 24 16 30
6 Kompositum Kompositum 17 28 20 29
7 FC Saturn FC Saturn 17 30 18 29
8 SKA Khabarovsk II Khabarovsk 17 30 29 25
9 Zenit Penza Zenit Penza 17 22 26 25
10 Sakhalin Yuzhno-Sakhalinsk Sakhalin 17 16 19 23
11 Kosmos Dolgoprudny Kosmos 17 24 28 23
12 Kvant Kvant 17 19 27 23
13 Znamya Noginsk Znamya 17 18 26 22
14 Khimki II Khimki II 17 20 28 19
15 FK Ryazan FK Ryazan 17 24 27 15
16 Strogino Strogino 17 28 36 14
17 Kolomna Kolomna 17 17 41 8
18 Peresvet Podolsk Peresvet 17 21 54 7
TEMPORADA 2021/2022
SEGUNDA B RUSIA GRUPO 8
Equipo PJ GF GC Puntos
1 Zenit Penza Zenit Penza 10 18 7 36
2 Sakhalin Yuzhno-Sakhalinsk Sakhalin 10 18 13 32
3 Kaluga Kaluga 10 23 7 31
4 Arsenal Tula II Arsenal Tula 10 14 20 30
5 Znamya Noginsk Znamya 10 13 10 27
6 Kvant Kvant 10 10 9 27
7 FC Saturn FC Saturn 10 15 19 25
8 Fakel II Fakel II 10 15 13 18
9 Metallurg Vidnoye Metallurg 10 15 22 17
10 Kolomna Kolomna 10 7 28 15
TEMPORADA 2020/2021
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Metallurg Lipetsk Metallurg 29 59 25 63
2 FK Ryazan FK Ryazan 30 57 33 59
3 Salyut Belgorod Salyut 30 56 25 56
4 FC Saturn FC Saturn 29 60 29 55
5 Sokol Saratov Sokol 30 44 21 55
6 Strogino Strogino 30 51 42 48
7 Kaluga Kaluga 30 50 37 47
8 Khimik Novomoskovsk Khimik 30 45 41 43
9 Znamya Noginsk Znamya 29 41 38 40
10 Krasnyy Smolensk Krasnyy 30 40 49 40
11 Avangard Kursk Avangard 30 35 41 36
12 Khimki II Khimki II 30 42 65 32
13 Kvant Kvant 30 31 54 28
14 Metallurg Vidnoye Metallurg 30 32 76 25
15 Fakel II Fakel II 30 22 64 20
16 Sakhalin Yuzhno-Sakhalinsk Sakhalin 29 26 51 19
TEMPORADA 2019/2020
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dinamo Bryansk Dinamo 17 28 11 39
2 Sokol Saratov Sokol 17 37 10 37
3 Metallurg Lipetsk Metallurg 17 30 9 37
4 Khimik Novomoskovsk Khimik 17 27 20 26
5 Salyut Belgorod Salyut 17 23 23 26
6 FK Ryazan FK Ryazan 17 29 26 24
7 Zorkiy Krasnogorsk Zorkiy 16 31 32 23
8 FC Ararat Moscow Ararat 17 34 36 23
9 Kaluga Kaluga 17 24 23 22
10 FC Saturn FC Saturn 17 32 32 22
11 Khimki II Khimki II 17 23 32 18
12 Strogino Strogino 17 15 28 17
13 Rotor Volgograd II Rotor 16 14 33 8
14 Kvant Kvant 17 8 40 8
TEMPORADA 2018/2019
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Torpedo Moscow Torpedo 26 48 17 65
2 Sokol Saratov Sokol 26 49 18 58
3 Metallurg Lipetsk Metallurg 26 47 25 51
4 Dinamo Bryansk Dinamo 26 40 21 48
5 Zorkiy Krasnogorsk Zorkiy 26 40 34 36
6 Kaluga Kaluga 26 30 29 36
7 Khimik Novomoskovsk Khimik 26 24 33 32
8 Kvant Kvant 26 35 36 31
9 Salyut Belgorod Salyut 26 26 30 31
10 FK Ryazan FK Ryazan 26 26 31 31
11 Rotor Volgograd II Rotor 26 30 47 30
12 FC Saturn FC Saturn 26 23 40 23
13 Strogino Strogino 26 21 45 17
14 Khimki II Khimki II 26 22 55 14
TEMPORADA 2017/2018
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Ararat Moscow Ararat 26 52 17 63
2 Energomash Energomash 26 43 21 53
3 FC Spartak Ryazan Spartak 26 37 23 46
4 Metallurg Lipetsk Metallurg 26 35 32 43
5 Torpedo Moscow Torpedo 26 44 22 42
6 Zorkiy Krasnogorsk Zorkiy 25 39 26 40
7 Sokol Saratov Sokol 26 36 38 39
8 FC Saturn FC Saturn 26 37 34 37
9 Strogino Strogino 26 38 37 36
10 Dinamo Bryansk Dinamo 26 33 29 34
11 Khimik Novomoskovsk Khimik 26 31 35 31
12 Kaluga Kaluga 26 20 37 21
13 Rotor Volgograd II Rotor 26 19 51 11
14 Zenit Penza Zenit Penza 25 12 74 11
TEMPORADA 2016/2017
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Avangard Kursk Avangard 24 28 16 45
2 Torpedo Moscow Torpedo 24 36 19 42
3 FC Saturn FC Saturn 24 32 20 42
4 Energomash Energomash 24 47 24 41
5 Vityaz Podolsk Vityaz 24 43 35 40
6 Chertanovo Chertanovo 24 36 33 34
7 FK Ryazan FK Ryazan 24 29 25 31
8 Metallurg Lipetsk Metallurg 24 27 29 31
9 Dinamo Bryansk Dinamo 24 22 19 30
10 Kaluga Kaluga 24 25 28 30
11 Zenit Penza Zenit Penza 24 31 43 27
12 Arsenal Tula II Arsenal Tula 24 24 52 17
13 FK Orel FK Orel 24 13 50 15
TEMPORADA 2014/2015
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Spartak Moskva II Spartak 30 65 26 65
2 Zenit II Zenit II 30 78 41 57
3 FK Khimki FK Khimki 30 42 26 54
4 Strogino Strogino 30 39 29 54
5 Tekstilshchik Tekstilshchi 30 51 29 53
6 FSC Dolgoprudniy Dolgoprudniy 30 45 39 51
7 FC Saturn FC Saturn 30 42 31 50
8 Torpedo Vladimir Torpedo 30 41 36 48
9 Pskov 747 Pskov 747 30 39 38 42
10 Domodedovo Domodedovo 30 48 50 38
11 Volga Tver Volga Tver 30 36 54 32
12 Spartak Kostroma Spartak 30 26 39 28
13 Dnepr Smolensk Dnepr 30 32 49 28
14 Solaris Solaris 30 39 59 28
15 Kolomna Kolomna 30 28 67 23
16 Znamya Znamya 30 21 59 18
TEMPORADA 2011/2012
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Dynamo St Petersburg Dynamo 45 80 27 93
2 Tekstilshchik Kamyshin Tekstilshchi 45 68 26 89
3 Spartak Kostroma Spartak 45 62 30 89
4 Dnepr Smolensk Dnepr 45 77 36 84
5 Lokomotiv Moskva II Lokomotiv 45 72 44 81
6 Volga Tver Volga Tver 45 60 35 77
7 Pskov 747 Pskov 747 45 61 53 73
8 Sheksna Sheksna 45 51 49 67
9 Istra Istra 45 54 47 64
10 Dinamo Vologda Dinamo 45 62 63 60
11 Sever Murmansk Sever 45 62 77 52
12 Karelia Karelia 45 58 83 49
13 FC Saturn FC Saturn 45 54 78 48
14 Dinamo Kostroma Dinamo 45 33 73 29
15 Znamya Znamya 45 29 99 21
16 Volochanin-Ratmir Volochanin-R 45 26 89 20

  USO DE MEMORIA  
6,127,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1400
Total Execution Time  0.1418
  CADENA URL  
/historico/Saturn-Ramenskoye
  GET DATOS  
$_GET['/historico/Saturn-Ramenskoye']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0037  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 = 'Saturn-Ramenskoye' 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.0020  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=19938 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=19938 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=19938 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=19938 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0046  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 = 75689
0.0035  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 = 73402
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19938 AND type_rel = 2
0.0040  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 = '19938' ORDER BY l.year DESC,cat.coefficient DESC
0.0037  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 = '19938' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0041  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 = '19938' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 73402 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 = 75689 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=19938 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 (75689,73402,72436,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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75689 AND teamId = 19938
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72436 AND teamId = 19938
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 19938
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19938
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 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 = 75689 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '19938' 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 = '19938' 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 = '19938' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 = 75689 WHERE rp.league_id = 75689 AND rp.teamId = 19938 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.0026  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 = 75689 WHERE rp.league_id = 75689 AND rp.teamId = 19938 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 75689 WHERE rp.league_id = 75689 AND rp.teamId = 19938 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 19938 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 = 75689 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.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 `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 = 68282 AND t.round = 22 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 = 71395 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 72436 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 63369 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 67130 AND t.round = 10 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 `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 = 57803 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 `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 = 50461 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 44473 AND t.round = 26 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 = 38854 AND t.round = 26 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 = 33931 AND t.round = 26 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 `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 = 4366 AND t.round = 30 ORDER BY team.conference 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 `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 = 25107 AND t.round = 48 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 75689 ORDER BY nameShow LIMIT 100