4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA A RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 Spartak Kostroma Spartak 10 11 3 21
2 Mashuk-KMV Mashuk-KMV 10 8 7 15
3 Kaluga Kaluga 9 13 9 14
4 Khimik Dzerzhinsk Khimik 10 11 10 14
5 Avangard Kursk Avangard 10 9 11 14
6 Volga Ulyanovsk Volga 10 15 10 13
7 Torpedo Miass Torpedo 10 10 11 11
8 Tekstilshchik Tekstilshchi 10 8 10 11
9 FC Irtysh Omsk Irtysh Omsk 10 5 11 8
10 Dinamo Bryansk Dinamo 9 8 16 4
TEMPORADA 2022/2023
SEGUNDA B RUSIA GRUPO 11
Equipo PJ GF GC Puntos
1 Tyumen Tyumen 27 58 18 60
2 FC Irtysh Omsk Irtysh Omsk 27 40 22 51
3 Amkar Perm Amkar Perm 27 43 31 47
4 FC Chelyabinsk Chelyabinsk 27 38 30 41
5 FK Novosibirsk Novosibirsk 27 29 33 34
6 Torpedo Miass Torpedo 27 27 37 33
TEMPORADA 2021/2022
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 Volga Ulyanovsk Volga 28 57 20 62
2 FC Chelyabinsk Chelyabinsk 28 56 24 62
3 Tyumen Tyumen 28 79 30 60
4 Zvezda Perm Zvezda Perm 28 52 28 52
5 Amkar Perm Amkar Perm 28 43 28 52
6 FK Novosibirsk Novosibirsk 28 40 24 50
7 Ural II Ural II 28 48 39 42
8 FC Irtysh Omsk Irtysh Omsk 28 50 49 38
9 Torpedo Miass Torpedo 28 33 41 35
10 Spartak Tuymazy Spartak 28 45 67 32
11 Orenburg II Orenburg II 28 31 52 27
12 Dinamo Barnaul Dinamo 28 29 42 26
13 NoSta NoSta 28 23 54 21
14 Zenit Izhevsk Zenit 28 20 55 16
15 Lada Tolyatti Lada 28 25 78 11
TEMPORADA 2020/2021
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 Krylia Sovetov Krylia 42 100 26 101
2 FC Orenburg FC Orenburg 42 78 33 94
3 FK Nizhny Novgorod Nizhny 42 67 28 88
4 Alaniya Vladikavkaz Alaniya 42 74 40 77
5 Baltika Kaliningrad Baltika 42 49 35 73
6 Torpedo Moscow Torpedo 42 65 41 72
7 Neftekhimik Neftekhimik 42 64 44 70
8 Veles Veles 42 54 46 66
9 Fakel Fakel 42 57 43 64
10 Yenisey Yenisey 42 52 54 63
11 SKA-Khabarovsk SKA-Khabarov 42 52 47 60
12 Chayka Chayka 42 44 53 56
13 Volgar Astrakhan Volgar 42 47 45 54
14 Spartak Moskva II Spartak 42 53 77 49
15 Tekstilshchik Tekstilshchi 42 32 51 47
16 FC Krasnodar II Krasnodar 42 46 68 45
17 Akron Tolyatti Akron 42 35 54 42
18 Tom Tomsk Tom Tomsk 42 32 50 41
19 FC Irtysh Omsk Irtysh Omsk 42 33 61 35
20 Dinamo Bryansk Dinamo 42 24 66 32
21 Chertanovo Chertanovo 42 35 80 27
22 Shinnik Yaroslavl Shinnik 42 39 90 25
TEMPORADA 2019/2020
SEGUNDA B RUSIA GRUPO 5
Equipo PJ GF GC Puntos
1 FC Irtysh Omsk Irtysh Omsk 11 21 4 29
2 Sakhalin Yuzhno-Sakhalinsk Sakhalin 12 15 16 18
3 Sibir Novosibirsk Sibir 12 16 16 17
4 FK Chita FK Chita 12 13 12 15
5 Dinamo Barnaul Dinamo 11 8 15 11
6 Zenit Irkutsk Zenit 12 6 16 9
TEMPORADA 2018/2019
SEGUNDA B RUSIA GRUPO 5
Equipo PJ GF GC Puntos
1 Sakhalin Yuzhno-Sakhalinsk Sakhalin 20 41 15 47
2 FC Irtysh Omsk Irtysh Omsk 20 38 12 45
3 Zenit Irkutsk Zenit 20 21 20 28
4 Dinamo Barnaul Dinamo 20 20 27 20
5 FK Chita FK Chita 20 19 34 14
6 Sibir Novosibirsk II Sibir 20 16 47 11
TEMPORADA 2017/2018
SEGUNDA B RUSIA GRUPO 5
Equipo PJ GF GC Puntos
1 Sakhalin Yuzhno-Sakhalinsk Sakhalin 20 37 17 42
2 Smena Komsomolsk Smena 20 22 21 30
3 FK Chita FK Chita 20 20 16 27
4 Dinamo Barnaul Dinamo 20 17 19 26
5 Zenit Irkutsk Zenit 20 22 34 22
6 FC Irtysh Omsk Irtysh Omsk 20 17 28 19
TEMPORADA 2016/2017
SEGUNDA B RUSIA GRUPO 5
Equipo PJ GF GC Puntos
1 FK Chita FK Chita 20 36 14 46
2 Dinamo Barnaul Dinamo 22 33 29 42
3 Sakhalin Yuzhno-Sakhalinsk Sakhalin 20 30 21 30
4 Smena Komsomolsk Smena 20 25 26 25
5 Zenit Irkutsk Zenit 20 20 34 16
6 FC Irtysh Omsk Irtysh Omsk 22 21 41 16
TEMPORADA 2015/2016
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Smena Komsomolsk Smena 24 45 25 49
2 Sakhalin Yuzhno-Sakhalinsk Sakhalin 24 40 17 48
3 FK Chita FK Chita 24 30 25 34
4 Dinamo Barnaul Dinamo 24 33 29 31
5 FC Irtysh Omsk Irtysh Omsk 24 25 23 31
6 Sibir Novosibirsk II Sibir 24 29 42 26
7 Yakutiya Yakutsk Yakutiya 24 38 49 25
8 Tom' Tomsk II Tom' Tomsk 24 26 38 25
9 FK Metallurg-Kuzbass Metallurg-Ku 24 27 45 23
TEMPORADA 2014/2015
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Radian-Baykal Radian-Bayka 24 37 18 44
2 FK Metallurg-Kuzbass Metallurg-Ku 24 38 19 43
3 FC Irtysh Omsk Irtysh Omsk 24 35 17 43
4 Smena Komsomolsk Smena 24 25 20 38
5 FK Chita FK Chita 24 27 30 36
6 Dinamo Barnaul Dinamo 24 43 39 34
7 Sibir Novosibirsk II Sibir 24 27 40 20
8 Yakutiya Yakutsk Yakutiya 24 28 47 20
9 Tom' Tomsk II Tom' Tomsk 24 25 55 18
TEMPORADA 2013/2014
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sakhalin Yuzhno-Sakhalinsk Sakhalin 24 44 16 51
2 FK Chita FK Chita 24 31 20 42
3 Smena Komsomolsk Smena 24 33 18 41
4 Amur-2010 Amur-2010 24 30 24 38
5 Radian-Baykal Radian-Bayka 24 31 20 36
6 Yakutiya Yakutsk Yakutiya 24 36 36 35
7 FC Irtysh Omsk Irtysh Omsk 24 28 28 32
8 Sibir Novosibirsk II Sibir 24 15 45 14
9 Sibiryak Bratsk Sibiryak 24 11 52 10
TEMPORADA 2012/2013
SEGUNDA B RUSIA GRUPO 1
Equipo PJ GF GC Puntos
1 Luch Vladivostok Luch 30 48 27 62
2 FK Chita FK Chita 30 42 22 59
3 Amur-2010 Amur-2010 30 50 21 55
4 Sakhalin Yuzhno-Sakhalinsk Sakhalin 30 42 23 55
5 Smena Komsomolsk Smena 30 41 29 50
6 Dinamo Barnaul Dinamo 30 41 44 37
7 Yakutiya Yakutsk Yakutiya 30 37 46 35
8 Radian-Baykal Radian-Bayka 30 36 61 28
9 FC Irtysh Omsk Irtysh Omsk 30 37 62 24
10 Sibiryak Bratsk Sibiryak 30 27 50 23
11 Sibir Novosibirsk II Sibir 30 33 49 21
TEMPORADA 2011/2012
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 FK Metallurg-Kuzbass Metallurg-Ku 36 64 24 78
2 Mostovik Primorye Mostovik 36 54 31 63
3 FK Chita FK Chita 36 49 33 59
4 FC Irtysh Omsk Irtysh Omsk 36 52 38 57
5 Dinamo Barnaul Dinamo 36 54 41 56
6 Sakhalin Yuzhno-Sakhalinsk Sakhalin 36 40 41 53
7 Radian-Baykal Radian-Bayka 36 42 37 52
8 Smena Komsomolsk Smena 36 47 30 51
9 Kuzbass Kuzbass 36 34 40 42
10 Sibiryak Bratsk Sibiryak 36 43 62 40
11 Amur-2010 Amur-2010 36 30 45 38
12 Yakutiya Yakutsk Yakutiya 36 38 76 29
13 Sibir Novosibirsk II Sibir 36 31 80 24
TEMPORADA 2009/2010
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 FC Kuban FC Kuban 38 51 20 80
2 Volga Novgorod Volga 38 62 25 71
3 FK Nizhny Novgorod Nizhny 38 60 41 70
4 KamAZ KamAZ 38 55 43 66
5 FK Krasnodar Krasnodar 38 60 44 61
6 Mordovia Saransk Mordovia 38 53 40 58
7 Ural Yekaterinburg Ural 38 38 28 58
8 Zhemchuzhina Sochi Zhemchuzhina 38 45 44 57
9 Volgar Astrakhan Volgar 38 45 48 57
10 Shinnik Yaroslavl Shinnik 38 43 31 55
11 SKA-Khabarovsk SKA-Khabarov 38 37 39 53
12 Luch Vladivostok Luch 38 42 42 52
13 FK Khimki FK Khimki 38 39 38 50
14 Dinamo Bryansk Dinamo 38 53 54 44
15 Baltika Kaliningrad Baltika 38 38 47 43
16 Dynamo St Petersburg Dynamo 38 32 53 37
17 Salyut Belgorod Salyut 38 30 47 34
18 Rotor Volgograd Rotor 38 27 64 34
19 FC Irtysh Omsk Irtysh Omsk 38 26 52 28
20 Avangard Kursk Avangard 38 31 67 27
TEMPORADA 2008/2009
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 FC Irtysh Omsk Irtysh Omsk 28 49 20 58
2 Dinamo Barnaul Dinamo 27 41 28 52
3 FK Metallurg-Kuzbass Metallurg-Ku 28 52 32 51
4 Yenisey Yenisey 26 48 27 47
5 Sibiryak Bratsk Sibiryak 27 36 48 39
6 Smena Komsomolsk Smena 27 35 30 37
7 Sakhalin Yuzhno-Sakhalinsk Sakhalin 27 29 28 32
8 Kuzbass Kuzbass 27 32 36 32
9 Okean Nakhodka Okean 27 21 53 13
10 Amur-2010 Amur-2010 26 23 64 12
TEMPORADA 2007/2008
SEGUNDA B RUSIA GRUPO 5
Equipo PJ GF GC Puntos
1 FK Chita FK Chita 27 53 21 62
2 Smena Komsomolsk Smena 27 50 21 53
3 FC Irtysh Omsk Irtysh Omsk 27 46 30 49
4 Sibir Novosibirsk II Sibir 27 36 40 40
5 Sibiryak Bratsk Sibiryak 27 34 37 35
6 Yenisey Yenisey 27 38 34 34
7 Okean Nakhodka Okean 27 22 28 34
8 Amur-2010 Amur-2010 27 29 45 25
9 Kuzbass Kuzbass 27 27 49 25
10 Sakhalin Yuzhno-Sakhalinsk Sakhalin 27 18 48 15
TEMPORADA 2006/2007
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Dinamo Barnaul Dinamo 30 67 17 63
2 Amur-2010 Amur-2010 30 46 20 60
3 FK Chita FK Chita 30 47 20 56
4 Smena Komsomolsk Smena 30 33 29 49
5 FC Irtysh Omsk Irtysh Omsk 30 43 31 47
6 Yenisey Yenisey 30 45 40 46
7 Okean Nakhodka Okean 30 36 36 40
8 Sibiryak Bratsk Sibiryak 30 42 60 28
9 Sakhalin Yuzhno-Sakhalinsk Sakhalin 30 21 49 25
10 Zarya Leninsk Zarya 30 20 55 21
11 Shakhtyor Prokopyevsk Shakhtyor 30 23 66 20
TEMPORADA 2005/2006
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Zvezda Irkutsk Zvezda 36 92 24 89
2 FK Metallurg-Kuzbass Metallurg-Ku 36 79 22 82
3 Okean Nakhodka Okean 36 52 38 63
4 Dinamo Barnaul Dinamo 36 51 38 59
5 Smena Komsomolsk Smena 36 45 33 59
6 FC Irtysh Omsk Irtysh Omsk 36 51 38 58
7 FK Chita FK Chita 36 66 38 57
8 Sibiryak Bratsk Sibiryak 36 42 38 57
9 Amur-2010 Amur-2010 36 34 53 43
10 Chkalovets Ns Chkalovets 36 28 68 25
11 Kuzbass Kuzbass 36 21 70 23
12 Shakhtyor Prokopyevsk Shakhtyor 36 19 73 20
13 Zarya Leninsk Zarya 36 19 66 13

  USO DE MEMORIA  
6,661,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1524
Total Execution Time  0.1535
  CADENA URL  
/historico/Irtysh
  GET DATOS  
$_GET['/historico/Irtysh']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0045  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 = 'Irtysh' 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=13629 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=13629 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=13629 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=13629 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=13629 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 74618
0.0028  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 = 72430
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13629 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2827 AND type_rel = 3
0.0024  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 = '13629' 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 = '13629' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72430 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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.0024  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=13629 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 (74618,73402,71607,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 74618 AND teamId = 13629
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71607 AND teamId = 13629
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 13629
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13629
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 = 74618 AND t.round = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '13629' 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 = '13629' 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 = '13629' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030  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 = 74618 WHERE rp.league_id = 74618 AND rp.teamId = 13629 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.0030  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 = 74618 WHERE rp.league_id = 74618 AND rp.teamId = 13629 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 74618 WHERE rp.league_id = 74618 AND rp.teamId = 13629 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 13629 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72430 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.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 `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 = 74618 AND t.round = 11 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 `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 = 68307 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.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 `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 = 71607 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.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 = 63372 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.0040  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 = 57359 AND t.round = 42 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 `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 = 50462 AND t.round = 14 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 `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 = 44477 AND t.round = 24 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 = 39159 AND t.round = 24 ORDER BY team.conference 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 `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 = 38542 AND t.round = 24 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 `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 = 15683 AND t.round = 28 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 = 4368 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 `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 = 2869 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 `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 = 25084 AND t.round = 33 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 = 25111 AND t.round = 42 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 `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 = 10501 AND t.round = 40 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 `tables2009` 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 = 25143 AND t.round = 27 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 `tables2008` 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 = 25157 AND t.round = 27 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 `tables2007` 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 = 25160 AND t.round = 28 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 `tables2006` 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 = 25187 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC