4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rotor Volgograd II
TEMPORADA 2022/2023
LIGA DE FÚTBOL AMATEUR DE RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Metallurg Oskol Metallurg 20 51 10 54
2 FK Orel FK Orel 20 86 21 51
3 Lokomotiv Liski Lokomotiv 20 59 9 49
4 Atom Novovoronezh Atom 20 48 17 41
5 Urozhay Urozhay 20 67 37 40
6 Rotor Volgograd II Rotor 20 41 25 30
7 Yelets Yelets 19 34 39 29
8 Dinamo Bryansk Ii Dinamo 21 32 45 27
9 Spartak Tambov II Spartak 22 25 61 14
10 Avangard Kursk Ii Avangard 20 23 81 13
11 Metallurg Lipetsk Ii Metallurg 20 23 62 11
12 BGUOR BGUOR 20 19 59 10
13 FK Kaluga II Kaluga 20 12 54 10
TEMPORADA 2021/2022
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dynamo Makhachkala Dynamo 32 62 12 80
2 SKA Rostov SKA Rostov 32 71 22 76
3 Chayka Chayka 32 88 24 70
4 Forte Taganrog Forte 32 55 31 61
5 Chernomorets Novorossisk Chernomorets 32 70 35 60
6 FC Kuban Holding Kuban 32 46 31 54
7 Anzhi Anzhi 32 46 35 48
8 Legion Makhachkala Legion 32 44 31 46
9 Biolog Novokubansk Biolog 32 50 45 44
10 Spartak Nalchik Spartak 32 32 28 40
11 Tuapse Tuapse 32 36 60 38
12 Druzhba Maykop Druzhba 32 25 44 32
13 Mashuk-KMV Mashuk-KMV 32 47 54 31
14 Dinamo Stavropol Dinamo 32 40 57 29
15 Rotor Volgograd II Rotor 32 26 74 21
16 Alania Vladikavkaz II Alania 32 32 97 12
17 Essentuki Essentuki 32 16 106 10
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 2004/2005
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Angusht Angusht 24 45 23 53
2 Mashuk-KMV Mashuk-KMV 24 44 21 51
3 FC Olimpia Volgograd Olimpia 24 54 27 45
4 Rotor Volgograd II Rotor 24 47 27 45
5 Spartak UGP Anapa Spartak 24 44 30 44
6 Avtodor Avtodor 24 36 43 33
7 FK Sochi 04 FK Sochi 04 24 25 27 32
8 Energiya Volzhskiy Energiya 24 34 28 31
9 Druzhba Maykop Druzhba 24 33 36 30
10 Krasnodar 2000 Krasnodar 24 32 35 29
11 SKA Rostov SKA Rostov 24 25 47 20
12 Astrakhan Astrakhan 24 17 44 16
13 Tekstilshchik Kamyshin Tekstilshchi 24 12 60 11
TEMPORADA 2003/2004
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Dinamo Stavropol Dinamo 64 136 51 137
2 Volgar Astrakhan Volgar 32 77 22 76
3 Mashuk-KMV Mashuk-KMV 32 73 30 69
4 Avtodor Avtodor 32 53 27 63
5 FC Olimpia Volgograd Olimpia 32 55 29 55
6 Energiya Volzhskiy Energiya 32 41 31 47
7 Vityaz Krymsk Vityaz 32 40 38 46
8 Angusht Angusht 32 50 49 46
9 Krasnodar 2000 Krasnodar 32 49 48 41
10 Tekstilshchik Kamyshin Tekstilshchi 32 36 50 40
11 Druzhba Maykop Druzhba 32 39 47 39
12 SKA Rostov SKA Rostov 32 34 47 33
13 Astrakhan Astrakhan 32 25 63 29
14 Rotor Volgograd II Rotor 32 42 70 24
15 Zhemchuzhina Budyonnovsk Zhemchuzhina 32 20 100 14
16 Slavyanskiy Slavyanskiy 32 17 85 10
TEMPORADA 1999/2000
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 Mordovia Saransk Mordovia 34 62 32 83
2 Torpedo Pavlovo Torpedo 34 56 25 72
3 Volga Ulyanovsk Volga 34 61 29 70
4 FC Metallurg Vyksa Metallurg 34 50 28 68
5 Balakovo Balakovo 34 51 34 60
6 Torpedo-Viktoriya Torpedo-Vikt 34 56 33 58
7 Energetik Uren Energetik 34 55 32 55
8 Iskra Engels Iskra Engels 34 47 45 51
9 Akademiya Tolyatti Akademiya 34 54 49 49
10 FC Olimpia Volgograd Olimpia 34 61 56 46
11 Diana Volzhsk Diana 34 50 38 45
12 Biokhimik Mordovia Biokhimik 34 38 45 44
13 Khimik Dzerzhinsk Khimik 34 38 46 37
14 Rotor Volgograd II Rotor 34 61 74 35
15 Khoper Balashov Khoper 34 24 51 33
16 Energiya Volzhskiy Energiya 34 30 77 27
17 Krylia Sovetov II Krylia 34 25 80 22
18 Salyut Saratov Salyut 34 27 72 21

  USO DE MEMORIA  
5,525,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.7353
Total Execution Time  0.7365
  CADENA URL  
/historico/Rotor-2
  GET DATOS  
$_GET['/historico/Rotor-2']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0131  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 = 'Rotor-2' 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.0143  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 = 'Rotor-2' 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=84394 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=84394 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=84394 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=84394 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=84394 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=84394 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=84394 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=84394 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=84394 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=84394 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=84394 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=84394 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=84394 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=84394 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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 = 71704
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=84394 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2354 AND type_rel = 3
0.0129  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 = '84394' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '84394' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.1036  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 = '84394' 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 = 71704 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=84394 AND l.year in (2022,2023,2024) 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 (71704,63367) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 63367 AND teamId = 84394
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 71704 AND teamId = 84394
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 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 = 71704 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '84394' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '84394' and rp.type = 4
0.0128  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 = '84394' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 events2023 e ON e.player_id = p.id AND e.league_id = 71704 WHERE rp.league_id = 71704 AND rp.teamId = 84394 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.0126  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 events2023 e ON e.player_id = p.id AND e.league_id = 71704 WHERE rp.league_id = 71704 AND rp.teamId = 84394 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events2023 e ON e.player_id = p.id AND e.league_id = 71704 WHERE rp.league_id = 71704 AND rp.teamId = 84394 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 84394 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 71704 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.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 `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 = 63367 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.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 = 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.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 `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.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 = 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.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 `tables2005` 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 = 25221 AND t.round = 26 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 `tables2004` 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 = 26518 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables2000` 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 = 26825 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC