4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hutnik Krakow
TEMPORADA 2023/2024
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Pogon Siedlce Pogon 30 47 38 52
2 Kalisz Kalisz 30 42 28 48
3 Kotwica Kołobrzeg Kotwica 30 54 42 47
4 Radunia Stężyca Radunia 30 42 36 46
5 Hutnik Krakow Hutnik 30 43 39 45
6 Chojniczanka Chojnice Chojniczanka 30 38 35 45
7 LKS Lodz II LKS Lodz II 30 44 40 44
8 Zagłębie Lubin II Zagłębie 30 44 41 42
9 Stal Stalowa Wola Stal Stalowa 30 34 35 42
10 TS Polonia Bytom Polonia 30 43 44 41
11 Olimpia Elblag Olimpia 30 33 40 38
12 Lech Poznań II Lech Poznań 30 33 42 38
13 Wisla Pulawy Wisla Pulawy 30 43 44 36
14 SKRA Częstochowa SKRA 30 33 34 36
15 Jastrzębie Jastrzębie 30 34 41 36
16 Olimpia Grudziadz Olimpia 30 31 37 34
17 Stomil Olsztyn Stomil 30 26 34 33
18 Sandecja Nowy Sacz Sandecja 30 29 43 28
TEMPORADA 2022/2023
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Polonia Warszawa Polonia 35 60 38 68
2 Znicz Pruszkow Znicz 34 49 37 59
3 Kotwica Kołobrzeg Kotwica 34 45 33 59
4 Stomil Olsztyn Stomil 34 51 32 57
5 Wisla Pulawy Wisla Pulawy 34 56 38 56
6 Motor Lublin Motor Lublin 34 52 37 55
7 Kalisz Kalisz 34 63 45 54
8 Pogon Siedlce Pogon 34 41 42 48
9 Olimpia Elblag Olimpia 34 40 36 47
10 Jastrzębie Jastrzębie 34 41 45 47
11 Lech Poznań II Lech Poznań 34 45 60 42
12 Hutnik Krakow Hutnik 34 41 48 40
13 Radunia Stężyca Radunia 34 47 57 39
14 Zagłębie Lubin II Zagłębie 34 44 68 38
15 Gornik Polkowice Gornik 34 46 52 37
16 Siarka Tarnobrzeg Siarka 34 37 57 33
17 Garbarnia Kraków Garbarnia 34 52 65 32
18 Śląsk Wrocław II Śląsk 34 38 57 31
TEMPORADA 2021/2022
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Stal Rzeszow Stal Rzeszow 34 75 35 77
2 Chojniczanka Chojnice Chojniczanka 34 72 31 73
3 Ruch Chorzów Ruch 34 48 27 63
4 Wigry Suwalki Wigry 34 58 38 60
5 Motor Lublin Motor Lublin 34 54 31 59
6 Radunia Stężyca Radunia 34 60 51 53
7 Lech Poznań II Lech Poznań 34 41 45 52
8 Garbarnia Kraków Garbarnia 34 51 43 48
9 Olimpia Elblag Olimpia 34 33 32 46
10 Pogon Siedlce Pogon 34 47 55 46
11 Wisla Pulawy Wisla Pulawy 34 56 54 44
12 Śląsk Wrocław II Śląsk 34 51 53 43
13 Kalisz Kalisz 34 43 48 42
14 Znicz Pruszkow Znicz 34 38 45 39
15 Hutnik Krakow Hutnik 34 38 55 35
16 Pogon Grod. Mazowiecki Pogon Grod. 34 34 54 31
17 Sokół Ostróda Sokół 34 32 77 19
18 GKS Bełchatów Bełchatów 34 17 74 18
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
CUARTA POLONIA GRUPO 4
Equipo PJ GF GC Puntos
1 Hutnik Krakow Hutnik 19 34 27 36
2 Motor Lublin Motor Lublin 19 36 16 36
3 Wólczanka W. Pełkińska Wólczanka 19 27 16 35
4 Korona Kielce II Korona 19 38 26 34
5 Siarka Tarnobrzeg Siarka 19 30 23 30
6 Wisla Pulawy Wisla Pulawy 19 21 19 29
7 Stal Kraśnik Stal 19 29 20 28
8 Avia Świdnik Avia 19 26 27 28
9 NKP Podhale NKP Podhale 19 30 24 28
10 Wisłoka Dębica Wisłoka 19 22 14 27
11 Wisła Sandomierz Wisła 19 24 19 25
12 Sokół Sieniawa Sokół 19 17 18 25
13 KSZO Ostrowiec KSZO 19 21 21 24
14 Hetman Zamosc Hetman 19 22 25 22
15 Orleta Radzyn Orleta 19 15 25 16
16 Jutrzenka Giebultow Jutrzenka 19 14 30 16
17 Chełminianka Chełmno Chełminiank 19 12 35 11
18 Soła Oświęcim Soła 19 20 53 8
TEMPORADA 2018/2019
CUARTA POLONIA GRUPO 4
Equipo PJ GF GC Puntos
1 Stal Rzeszow Stal Rzeszow 34 87 27 76
2 NKP Podhale NKP Podhale 34 63 27 76
3 Motor Lublin Motor Lublin 34 62 34 70
4 Wisla Pulawy Wisla Pulawy 34 41 31 60
5 Hutnik Krakow Hutnik 34 53 45 52
6 KSZO Ostrowiec KSZO 34 51 43 51
7 Sokół Sieniawa Sokół 34 49 43 48
8 Avia Świdnik Avia 34 42 43 44
9 Stal Kraśnik Stal 34 46 47 43
10 Orleta Radzyn Orleta 34 42 52 43
11 Chełminianka Chełmno Chełminiank 34 42 49 39
12 Wisła Sandomierz Wisła 34 37 57 39
13 Wólczanka W. Pełkińska Wólczanka 34 41 39 38
14 Soła Oświęcim Soła 34 37 51 38
15 Wiślanie Jaśkowice Wiślanie 34 45 65 35
16 Podlasie Biała Podlaska Podlasie 34 41 68 35
17 Czarni Połaniec Czarni 34 36 63 28
18 Spartakus Daleszyce Spartakus 34 34 65 23
TEMPORADA 1993/1994
LIGA POLACA
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 34 72 24 51
2 GKS Katowice Katowice 34 52 28 47
3 Górnik Zabrze Górnik 34 56 32 46
4 LKS Lódz LKS Lódz 34 49 24 45
5 Pogon Szczecin Pogon 34 39 24 41
6 Widzew Łódź Widzew 34 45 33 39
7 Ruch Chorzów Ruch 34 48 41 37
8 Hutnik Krakow Hutnik 34 33 30 37
9 Lech Poznań Lech Poznań 34 39 32 35
10 Sokol Tychy Sokol Tychy 34 41 40 33
11 Stal Mielec Stal Mielec 34 32 45 31
12 Zaglebie Lubin Zaglebie 34 40 47 30
13 Stal Stalowa Wola Stal Stalowa 34 25 37 30
14 Warta Poznan Warta Poznan 34 32 45 30
15 Wisla Kraków Wisla 34 30 46 25
16 Siarka Tarnobrzeg Siarka 34 25 57 19
17 Polonia Warszawa Polonia 34 28 61 19
18 Zawisza Bydgoszcz Zawisza 34 30 70 17
TEMPORADA 1992/1993
LIGA POLACA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 34 70 29 47
2 Legia Warszawa Legia 33 50 26 47
3 LKS Lódz LKS Lódz 33 53 32 47
4 Ruch Chorzów Ruch 34 52 27 44
5 Widzew Łódź Widzew 34 60 42 43
6 Stal Mielec Stal Mielec 34 41 28 39
7 Pogon Szczecin Pogon 34 35 33 39
8 GKS Katowice Katowice 34 52 36 37
9 Górnik Zabrze Górnik 34 43 40 35
10 Wisla Kraków Wisla 33 49 37 34
11 Siarka Tarnobrzeg Siarka 34 39 42 31
12 Zaglebie Lubin Zaglebie 34 48 41 30
13 Zawisza Bydgoszcz Zawisza 34 41 60 30
14 Hutnik Krakow Hutnik 34 40 46 29
15 Szombierki Bytom Szombierki 34 31 59 23
16 Śląsk Wrocław Śląsk 34 33 74 23
17 Olimpia Poznan Olimpia 33 27 49 21
18 Jagiellonia Bialystok Jagiellonia 34 28 91 9
TEMPORADA 1991/1992
LIGA POLACA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 34 66 38 49
2 GKS Katowice Katowice 34 51 29 44
3 Widzew Łódź Widzew 34 48 28 43
4 Górnik Zabrze Górnik 34 43 26 43
5 Ruch Chorzów Ruch 34 43 38 39
6 Śląsk Wrocław Śląsk 34 42 35 38
7 Wisla Kraków Wisla 34 39 35 34
8 Zawisza Bydgoszcz Zawisza 34 43 42 34
9 Zaglebie Lubin Zaglebie 34 30 31 34
10 Legia Warszawa Legia 34 34 33 33
11 LKS Lódz LKS Lódz 34 26 29 33
12 Hutnik Krakow Hutnik 34 54 46 32
13 Stal Mielec Stal Mielec 34 27 28 32
14 Olimpia Poznan Olimpia 34 34 41 31
15 Motor Lublin Motor Lublin 34 33 40 30
16 Stal Stalowa Wola Stal Stalowa 34 23 33 28
17 Zagłębie Sosnowiec Zagłębie 34 28 50 24
18 Igloopol Debica Igloopol 34 14 76 11
TEMPORADA 1990/1991
LIGA POLACA
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Zaglebie 30 49 25 44
2 Górnik Zabrze Górnik 30 55 24 40
3 Wisla Kraków Wisla 30 52 26 40
4 GKS Katowice Katowice 30 33 26 39
5 Hutnik Krakow Hutnik 30 53 34 37
6 Lech Poznań Lech Poznań 30 49 28 33
7 Śląsk Wrocław Śląsk 30 41 37 33
8 Olimpia Poznan Olimpia 30 37 41 30
9 Legia Warszawa Legia 30 24 24 28
10 Motor Lublin Motor Lublin 30 33 38 28
11 LKS Lódz LKS Lódz 30 25 36 28
12 Igloopol Debica Igloopol 30 29 45 26
13 Ruch Chorzów Ruch 30 25 35 25
14 Zawisza Bydgoszcz Zawisza 30 27 41 23
15 Stal Mielec Stal Mielec 30 25 49 16
16 Zagłębie Sosnowiec Zagłębie 30 21 69 10

  USO DE MEMORIA  
6,537,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7401
Total Execution Time  0.7413
  CADENA URL  
/historico/Hutnik-Krakow
  GET DATOS  
$_GET['/historico/Hutnik-Krakow']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0167  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 = 'Hutnik-Krakow' 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.0145  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=62485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=62485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=62485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=62485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294  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 = 72234
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62485 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=380 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 380 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0151  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 (1213703,1162606,632025,615056,275113) ORDER BY n.cover_points DESC, update_date DESC
0.0162  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 = '62485' ORDER BY l.year DESC,cat.coefficient DESC
0.0163  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 = '62485' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0165  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 = '62485' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  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 = 72234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0165  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=62485 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0157  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 (72234,72171,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.0163  SELECT count(id) as num_players from rel_players WHERE league_id = 72234 AND teamId = 62485
0.0178  SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 62485
0.0165  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 62485
0.0168  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 = 72234 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0156  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 = '62485' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0150  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62485' and rp.type = 4
0.0156  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 = '62485' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0211  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 = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 62485 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.0220  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 = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 62485 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0175  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 = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 62485 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 = 62485 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0156  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 = 72234 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 68006 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.0169  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 = 63257 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.0307  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.0149  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 = 50432 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 44319 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1994` 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 = 10679 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1993` 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 = 10682 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables1992` 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 = 10686 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1991` 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 = 10704 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC