4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dinamo Barnaul
TEMPORADA 2023/2024
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 Dinamo Kirov Dinamo Kirov 4 10 2 12
2 Sokol Kazan Sokol Kazan 4 5 2 10
3 Amkar Perm Amkar Perm 4 8 3 9
4 Rubin Kazán II Rubin Kazán 4 7 3 9
5 Ural II Ural II 4 6 4 7
6 Krylia Sovetov II Krylia 4 4 3 6
7 Orenburg II Orenburg II 4 4 5 6
8 FK Nizhny Novgorod II Nizhny 4 5 5 5
9 Dinamo Barnaul Dinamo 4 6 10 4
10 NoSta NoSta 4 6 7 3
11 Akron Togliatti II Akron 4 4 8 3
12 Uralets TS Nizhnyi Tagil Uralets 4 5 9 2
13 Volna Nizhegorodskaya Volna 4 3 7 1
14 Lada Tolyatti Lada 4 2 7 1
TEMPORADA 2022/2023
SEGUNDA B RUSIA - TRANSICIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Torpedo Miass Torpedo 16 33 12 36
2 Khimik-Avgust Khimik-Avgus 16 19 6 31
3 Rubin Kazán II Rubin Kazán 16 15 14 26
4 NoSta NoSta 16 19 14 25
5 Ural II Ural II 16 20 20 21
6 Uralets TS Nizhnyi Tagil Uralets 16 8 12 18
7 Dinamo Barnaul Dinamo 16 28 29 17
8 Orenburg II Orenburg II 16 14 24 15
9 Akron Togliatti II Akron 16 9 34 3
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
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Tyumen Tyumen 28 55 22 63
2 KamAZ KamAZ 27 72 25 61
3 Volga Ulyanovsk Volga 28 45 15 59
4 FC Chelyabinsk Chelyabinsk 27 59 22 56
5 Zvezda Perm Zvezda Perm 26 54 23 55
6 FK Novosibirsk Novosibirsk 27 50 25 55
7 Dinamo Barnaul Dinamo 27 30 38 41
8 NoSta NoSta 26 38 34 36
9 Ural II Ural II 28 39 40 35
10 Volna Nizhegorodskaya Volna 28 32 39 35
11 Lada Sok Lada Sok 28 33 34 27
12 Zenit Izhevsk Zenit 27 31 40 22
13 Lada Tolyatti Lada 28 15 100 13
14 Orenburg II Orenburg II 28 15 70 12
15 Krylia Sovetov II Krylia 27 22 63 9
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 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
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 Yenisey Yenisey 30 50 24 61
2 Radian-Baykal Radian-Bayka 30 56 43 56
3 FK Chita FK Chita 30 43 27 53
4 Dinamo Barnaul Dinamo 30 48 42 48
5 FK Metallurg-Kuzbass Metallurg-Ku 30 49 29 47
6 Sakhalin Yuzhno-Sakhalinsk Sakhalin 30 38 29 47
7 Smena Komsomolsk Smena 30 41 27 46
8 Kuzbass Kuzbass 30 29 45 29
9 Mostovik Primorye Mostovik 30 29 54 26
10 Sibiryak Bratsk Sibiryak 30 27 50 24
11 Okean Nakhodka Okean 30 18 58 14
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
PRIMERA RUSIA
Equipo PJ GF GC Puntos
1 FK Rostov FK Rostov 42 78 29 96
2 FC Kuban FC Kuban 42 84 36 87
3 KamAZ KamAZ 42 68 41 79
4 Ural Yekaterinburg Ural 42 69 39 75
5 NoSta NoSta 42 59 37 73
6 Anzhi Anzhi 42 63 35 72
7 Baltika Kaliningrad Baltika 42 43 34 65
8 Chernomorets Novorossisk Chernomorets 42 51 38 61
9 SKA-Khabarovsk SKA-Khabarov 42 63 60 61
10 Alaniya Vladikavkaz Alaniya 42 50 47 59
11 Sibir Novosibirsk Sibir 42 51 41 58
12 SKA Rostov SKA Rostov 42 52 50 58
13 Salyut Belgorod Salyut 42 51 51 58
14 Vityaz Podolsk Vityaz 42 49 57 58
15 FK Metallurg-Kuzbass Metallurg-Ku 42 44 42 57
16 SAC Moskva SAC Moskva 42 55 57 57
17 Volga Ulyanovsk Volga 42 50 65 49
18 Torpedo Moscow Torpedo 42 47 69 49
19 Mashuk-KMV Mashuk-KMV 42 39 79 32
20 Dinamo Barnaul Dinamo 42 31 80 27
21 Zvezda Irkutsk Zvezda 42 36 95 23
22 Dinamo Bryansk Dinamo 42 30 81 22
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
TEMPORADA 2004/2005
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Yenisey Yenisey 29 54 17 69
2 Okean Nakhodka Okean 30 58 17 66
3 Dinamo Barnaul Dinamo 30 54 21 64
4 FC Irtysh Omsk Irtysh Omsk 30 37 32 49
5 Smena Komsomolsk Smena 31 42 34 47
6 Zvezda Irkutsk Zvezda 29 41 32 44
7 Sibiryak Bratsk Sibiryak 30 28 40 33
8 Chkalovets Ns Chkalovets 30 20 54 25
9 Zarya Leninsk Zarya 31 17 42 24
10 Kuzbass Kuzbass 30 15 36 22
11 Shakhtyor Prokopyevsk Shakhtyor 30 31 72 18

  USO DE MEMORIA  
6,602,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6874
Total Execution Time  0.6886
  CADENA URL  
/historico/Dinamo-Barnaul
  GET DATOS  
$_GET['/historico/Dinamo-Barnaul']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0138  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 = 'Dinamo-Barnaul' 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.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=19986 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=19986 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=19986 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=19986 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19986 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=382 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 382 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1268221,1267675,1162132,1037410,1031092) ORDER BY n.cover_points DESC, update_date DESC
0.0131  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 = '19986' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '19986' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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.0130  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=19986 AND l.year in (2023,2024,2025) 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 (75609,73402,72437,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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 75609 AND teamId = 19986
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72437 AND teamId = 19986
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 19986
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19986
0.0168  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 = 75609 WHERE rp.league_id = 75609 AND rp.teamId = 19986 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.0171  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 = 75609 WHERE rp.league_id = 75609 AND rp.teamId = 19986 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 75609 WHERE rp.league_id = 75609 AND rp.teamId = 19986 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 19986 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 75609 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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.0137  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 = 71608 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.0140  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 = 72437 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.0145  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.0145  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 = 57518 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.0139  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.0139  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.0140  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.0138  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.0133  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.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 `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.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 `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.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 `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.0129  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 = 25129 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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.0132  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 = 12949 AND t.round = 42 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 `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.0129  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
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 `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 = 25241 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC