4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bytovia Bytow
TEMPORADA 2020/2021
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Gornik Polkowice Gornik 36 70 29 76
2 GKS Katowice Katowice 36 67 41 70
3 Chojniczanka Chojnice Chojniczanka 36 63 34 67
4 Wigry Suwalki Wigry 36 51 35 64
5 Kalisz Kalisz 36 51 40 57
6 SKRA Częstochowa SKRA 36 51 42 52
7 Śląsk Wrocław II Śląsk 36 61 57 52
8 Garbarnia Kraków Garbarnia 36 49 50 52
9 Stal Rzeszow Stal Rzeszow 36 58 60 50
10 Motor Lublin Motor Lublin 36 48 44 50
11 Sokół Ostróda Sokół 36 50 56 46
12 Hutnik Krakow Hutnik 36 47 61 45
13 Pogon Siedlce Pogon 36 61 62 42
14 Lech Poznań II Lech Poznań 36 47 58 40
15 Znicz Pruszkow Znicz 36 37 55 38
16 Olimpia Elblag Olimpia 36 39 52 37
17 Stargard Szczeciński Stargard 36 36 66 36
18 Olimpia Grudziadz Olimpia 36 42 67 36
19 Bytovia Bytow Bytovia 36 46 65 34
TEMPORADA 2019/2020
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Górnik Łęczna Górnik 34 47 37 63
2 GKS Katowice Katowice 34 57 40 59
3 Widzew Łódź Widzew 34 65 37 59
4 Resovia Rzeszów Resovia 34 50 32 52
5 Bytovia Bytow Bytovia 34 50 48 52
6 Stal Rzeszow Stal Rzeszow 34 55 44 51
7 Olimpia Elblag Olimpia 34 46 38 50
8 Garbarnia Kraków Garbarnia 34 46 40 50
9 Znicz Pruszkow Znicz 34 49 52 49
10 Pogon Siedlce Pogon 34 54 53 49
11 Gornik Polkowice Gornik 34 60 47 48
12 Lech Poznań II Lech Poznań 34 49 47 47
13 Stargard Szczeciński Stargard 34 54 53 47
14 SKRA Częstochowa SKRA 34 37 44 47
15 Stal Stalowa Wola Stal Stalowa 34 45 49 46
16 TKP Elana Torun Elana Torun 34 50 54 41
17 KS Legionovia Legionowo Legionovia 34 33 64 24
18 Gryf Wejherowo Gryf 34 23 91 14
TEMPORADA 2018/2019
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Raków Częstochowa Raków 34 54 22 70
2 LKS Lódz LKS Lódz 34 58 23 69
3 Stal Mielec Stal Mielec 34 59 28 64
4 Sandecja Nowy Sacz Sandecja 34 35 29 55
5 Jastrzębie Jastrzębie 34 43 38 48
6 Podbeskidzie Podbeskidzie 34 52 46 48
7 GKS Tychy GKS Tychy 34 48 41 47
8 Termalica Nieciecza Termalica 34 45 46 46
9 Puszcza Niepolomice Puszcza 34 37 45 44
10 Stomil Olsztyn Stomil 34 38 43 43
11 Chojniczanka Chojnice Chojniczanka 34 49 49 42
12 Odra Opole Odra Opole 34 47 58 40
13 Warta Poznan Warta Poznan 34 31 43 39
14 Chrobry Głogów Chrobry 34 29 39 39
15 Wigry Suwalki Wigry 34 40 56 37
16 Bytovia Bytow Bytovia 34 45 50 37
17 GKS Katowice Katowice 34 34 45 37
18 Garbarnia Kraków Garbarnia 34 21 64 21
TEMPORADA 2017/2018
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Miedz Legnica Miedz 34 53 27 63
2 Zagłębie Sosnowiec Zagłębie 34 46 32 58
3 Chojniczanka Chojnice Chojniczanka 34 48 33 56
4 GKS Tychy GKS Tychy 34 41 40 55
5 GKS Katowice Katowice 34 44 34 54
6 Wigry Suwalki Wigry 34 40 37 52
7 Raków Częstochowa Raków 34 50 40 51
8 Stal Mielec Stal Mielec 34 51 46 51
9 Podbeskidzie Podbeskidzie 34 37 37 46
10 Chrobry Głogów Chrobry 34 46 47 46
11 Odra Opole Odra Opole 34 37 43 45
12 Puszcza Niepolomice Puszcza 34 38 38 44
13 Bytovia Bytow Bytovia 34 36 45 40
14 Stomil Olsztyn Stomil 34 39 50 39
15 Pogon Siedlce Pogon 34 42 50 38
16 Górnik Łęczna Górnik 34 29 42 35
17 Olimpia Grudziadz Olimpia 34 24 37 31
18 Ruch Chorzów Ruch 34 35 58 27
TEMPORADA 2016/2017
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Sandecja Nowy Sacz Sandecja 34 50 29 61
2 Górnik Zabrze Górnik 34 53 34 58
3 Miedz Legnica Miedz 34 49 27 57
4 Zagłębie Sosnowiec Zagłębie 34 53 44 57
5 Olimpia Grudziadz Olimpia 34 48 35 56
6 Chojniczanka Chojnice Chojniczanka 34 54 48 56
7 GKS Katowice Katowice 34 47 32 54
8 Podbeskidzie Podbeskidzie 34 40 39 53
9 Wigry Suwalki Wigry 34 51 45 52
10 Stal Mielec Stal Mielec 34 38 42 45
11 Pogon Siedlce Pogon 34 34 46 44
12 Chrobry Głogów Chrobry 34 50 50 43
13 Stomil Olsztyn Stomil 34 48 50 37
14 GKS Tychy GKS Tychy 34 42 51 37
15 Bytovia Bytow Bytovia 34 38 47 35
16 Wisla Pulawy Wisla Pulawy 34 33 49 33
17 Znicz Pruszkow Znicz 34 35 64 30
18 Kluczbork Kluczbork 34 35 66 25
TEMPORADA 2015/2016
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Arka Gdynia Arka Gdynia 34 60 29 69
2 Wisła Płock Wisła 34 51 28 63
3 Zawisza Bydgoszcz Zawisza 34 57 51 52
4 GKS Katowice Katowice 34 42 36 52
5 Zagłębie Sosnowiec Zagłębie 34 53 53 52
6 Chrobry Głogów Chrobry 34 47 33 51
7 Miedz Legnica Miedz 34 41 34 51
8 Bytovia Bytow Bytovia 34 46 44 48
9 Sandecja Nowy Sacz Sandecja 34 51 43 47
10 Wigry Suwalki Wigry 34 41 35 45
11 Stomil Olsztyn Stomil 34 34 42 44
12 Chojniczanka Chojnice Chojniczanka 34 40 45 43
13 Olimpia Grudziadz Olimpia 34 39 43 42
14 Kluczbork Kluczbork 34 40 55 41
15 Pogon Siedlce Pogon 34 31 46 41
16 GKS Bełchatów Bełchatów 34 35 40 38
17 Rozwoj Katowice Rozwoj 34 35 56 35
18 Dolcan Zabki Dolcan Zabki 34 37 67 30
TEMPORADA 2014/2015
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Zaglebie 34 57 20 77
2 Termalica Nieciecza Termalica 34 60 26 73
3 Wisła Płock Wisła 34 50 25 69
4 Olimpia Grudziadz Olimpia 34 46 37 53
5 Chojniczanka Chojnice Chojniczanka 34 50 37 50
6 Dolcan Zabki Dolcan Zabki 34 43 39 50
7 Stomil Olsztyn Stomil 34 47 47 49
8 GKS Katowice Katowice 34 44 41 48
9 Wigry Suwalki Wigry 34 36 37 47
10 Arka Gdynia Arka Gdynia 34 38 39 43
11 Chrobry Głogów Chrobry 34 41 45 41
12 Miedz Legnica Miedz 34 44 45 40
13 Bytovia Bytow Bytovia 34 39 45 40
14 Swinoujscie Swinoujscie 34 26 46 36
15 Sandecja Nowy Sacz Sandecja 34 40 55 35
16 Pogon Siedlce Pogon 34 34 53 30
17 GKS Tychy GKS Tychy 34 31 56 28
18 Widzew Łódź Widzew 34 25 58 22
TEMPORADA 2013/2014
TERCERA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Chrobry Głogów Chrobry 34 55 17 68
2 Bytovia Bytow Bytovia 34 55 30 62
3 Zagłębie Sosnowiec Zagłębie 34 41 28 59
4 Stargard Szczeciński Stargard 34 58 40 55
5 Kluczbork Kluczbork 34 57 46 52
6 Górnik Wałbrzych Górnik 34 40 36 52
7 Rozwoj Katowice Rozwoj 34 40 36 52
8 TS Polonia Bytom Polonia 34 45 34 51
9 Warta Poznan Warta Poznan 34 52 50 51
10 Raków Częstochowa Raków 34 44 40 48
11 Gryf Wejherowo Gryf 34 52 49 45
12 Odra Opole Odra Opole 34 36 40 43
13 Ruch Zdzieszowice Ruch 34 50 52 41
14 Ostrovia Ostrow Wielkop. Ostrovia 34 32 43 38
15 Calisia Kalisz Calisia 34 39 57 36
16 Zielona Góra Zielona 34 37 51 34
17 Jarota Jarocin Jarota 34 31 56 32
18 Gornik Polkowice Gornik 34 15 74 17
TEMPORADA 2012/2013
TERCERA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Energetyk ROW Rybnik Energetyk 34 69 32 72
2 Chojniczanka Chojnice Chojniczanka 34 58 27 71
3 Bytovia Bytow Bytovia 34 53 33 63
4 Zagłębie Sosnowiec Zagłębie 34 54 28 59
5 Kluczbork Kluczbork 34 54 28 57
6 Gornik Polkowice Gornik 34 59 42 56
7 Rozwoj Katowice Rozwoj 34 46 38 51
8 Chrobry Głogów Chrobry 34 38 39 48
9 Jarota Jarocin Jarota 34 36 35 44
10 Gryf Wejherowo Gryf 34 39 44 44
11 Calisia Kalisz Calisia 34 34 43 44
12 Raków Częstochowa Raków 34 43 44 43
13 Górnik Wałbrzych Górnik 34 34 43 42
14 Tur Turek Tur Turek 34 32 42 42
15 Ruch Zdzieszowice Ruch 34 38 55 34
16 MKS Olawa MKS Olawa 34 35 53 30
17 Lech Rypin Lech Rypin 34 24 80 29
18 TKP Elana Torun Elana Torun 34 12 52 19
TEMPORADA 2011/2012
TERCERA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Miedz Legnica Miedz 34 62 23 64
2 GKS Tychy GKS Tychy 34 50 27 59
3 Bytovia Bytow Bytovia 34 47 45 54
4 Jarota Jarocin Jarota 34 41 36 52
5 Górnik Wałbrzych Górnik 34 37 29 50
6 TKP Elana Torun Elana Torun 34 46 41 50
7 Ruch Zdzieszowice Ruch 34 36 36 50
8 Chojniczanka Chojnice Chojniczanka 34 58 45 49
9 Chrobry Głogów Chrobry 34 36 38 49
10 Kluczbork Kluczbork 34 44 35 48
11 Energetyk ROW Rybnik Energetyk 34 46 59 44
12 Raków Częstochowa Raków 34 37 51 44
13 Czarni Żagań Czarni 34 34 53 44
14 Zagłębie Sosnowiec Zagłębie 34 46 45 40
15 Tur Turek Tur Turek 34 41 46 38
16 Calisia Kalisz Calisia 34 47 60 36
17 Bałtyk Gdynia Bałtyk 34 29 42 29
18 Nielba Wagrowiec Nielba 34 36 62 29
TEMPORADA 2010/2011
CUARTA POLONIA GRUPO 8
Equipo PJ GF GC Puntos
1 Bytovia Bytow Bytovia 30 49 20 69
2 Stargard Szczeciński Stargard 30 51 28 57
3 Kotwica Kołobrzeg Kotwica 30 47 31 48
4 Dąb Dębno Dąb Dębno 30 29 30 47
5 Orkan Rumia Orkan Rumia 30 50 37 45
6 Pogoń Barlinek Pogoń 30 34 33 45
7 Gryf Wejherowo Gryf 30 42 32 43
8 Lechia Gdańsk II Lechia 30 37 31 43
9 Cartusia Kartuzy Cartusia 30 35 34 43
10 Kaszubia Kościerzyna Kaszubia 30 38 33 41
11 Gwardia Koszalin Gwardia 30 45 48 41
12 Chemik Police Chemik 30 35 46 37
13 Gryf Słupsk Gryf Słupsk 30 43 42 34
14 Energetyk Gryfino Energetyk 30 25 41 28
15 Rega Trzebiatów Rega 30 28 62 20
16 Orlęta Reda Orlęta Reda 30 18 58 15
TEMPORADA 2009/2010
CUARTA POLONIA GRUPO 7
Equipo PJ GF GC Puntos
1 Chojniczanka Chojnice Chojniczanka 30 70 42 63
2 Rega Trzebiatów Rega 30 50 27 58
3 Orkan Rumia Orkan Rumia 30 67 39 57
4 Gryf Słupsk Gryf Słupsk 30 58 42 50
5 Kaszubia Kościerzyna Kaszubia 30 56 40 50
6 Cartusia Kartuzy Cartusia 30 45 39 45
7 Stargard Szczeciński Stargard 30 56 52 43
8 Dąb Dębno Dąb Dębno 30 39 42 41
9 Gryf Wejherowo Gryf 30 42 48 40
10 Kotwica Kołobrzeg Kotwica 30 53 51 37
11 Chemik Police Chemik 30 44 51 37
12 Energetyk Gryfino Energetyk 30 41 51 37
13 Piast Choszczno Piast 30 41 42 35
14 Bytovia Bytow Bytovia 30 43 45 29
15 Astra Ustronie Morskie Astra 30 38 77 23
16 Darzbór Szczecinek Darzbór 30 27 82 16
TEMPORADA 2008/2009
CUARTA POLONIA GRUPO 8
Equipo PJ GF GC Puntos
1 Bałtyk Gdynia Bałtyk 30 58 22 63
2 Stargard Szczeciński Stargard 30 67 26 58
3 Gryf Słupsk Gryf Słupsk 30 54 29 57
4 Bytovia Bytow Bytovia 30 39 19 51
5 Kaszubia Kościerzyna Kaszubia 30 49 34 51
6 Rega Trzebiatów Rega 30 46 39 51
7 Dąb Dębno Dąb Dębno 30 43 36 50
8 Orkan Rumia Orkan Rumia 30 47 37 48
9 Cartusia Kartuzy Cartusia 29 58 40 46
10 Darzbór Szczecinek Darzbór 30 39 40 42
11 Zatoka Puck SSA Zatoka Puck 30 39 39 41
12 Astra Ustronie Morskie Astra 30 44 53 41
13 MKS Slawa Slawno Slawa Slawno 30 37 60 31
14 Rodlo Kwidzyn Rodlo 30 24 50 25
15 Orlęta Reda Orlęta Reda 29 10 66 10
16 KP Olimpia Sztum Olimpia 30 14 78 6

  USO DE MEMORIA  
6,591,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  4.8468
Total Execution Time  4.8480
  CADENA URL  
/historico/Bytovia-Bytow
  GET DATOS  
$_GET['/historico/Bytovia-Bytow']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.2937  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 = 'Bytovia-Bytow' 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=13376 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=13376 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13376 AND type_rel = 2
0.1143  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13376 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0520  SELECT /*35 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 (41617,42105,181314,182281,484757) ORDER BY n.cover_points DESC, update_date DESC
0.2676  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 = '13376' ORDER BY l.year DESC,cat.coefficient DESC
0.5345  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 = '13376' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.3038  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 = '13376' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.3793  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 = '13376' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.2791  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=13376 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (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.1724  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13376
0.0282  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 = '13376' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0281  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13376' and rp.type = 4
0.0020  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 = '13376' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.2327  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 13376 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.1731  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 13376 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.1786  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 13376 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.1439  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 = 13376 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.1158  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 = 58339 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0801  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 = 50151 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.1421  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 = 44126 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0915  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 = 38760 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1471  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 = 33387 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1140  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 = 15593 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2164  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 = 3876 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1022  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 = 3651 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1009  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 = 25080 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1186  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 = 25076 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1212  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 = 28072 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0732  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 = 28073 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1705  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 = 28099 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC