4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA POLACA
Equipo PJ GF GC Puntos
1 Jagiellonia Bialystok Jagiellonia 30 68 41 56
2 Śląsk Wrocław Śląsk 29 38 26 51
3 Lech Poznań Lech Poznań 29 43 34 51
4 Pogon Szczecin Pogon 30 56 36 48
5 Górnik Zabrze Górnik 29 39 32 48
6 Legia Warszawa Legia 29 43 33 47
7 Raków Częstochowa Raków 29 50 32 46
8 Widzew Łódź Widzew 29 39 38 42
9 Piast Gliwice Piast 30 32 32 38
10 Stal Mielec Stal Mielec 29 35 39 38
11 Zaglebie Lubin Zaglebie 29 31 43 35
12 Radomiak Radom Radomiak 29 34 47 35
13 Warta Poznan Warta Poznan 30 31 37 34
14 Puszcza Niepolomice Puszcza 29 35 46 32
15 KS Cracovia KS Cracovia 29 38 40 32
16 Korona Kielce Korona 29 34 38 30
17 LKS Lódz LKS Lódz 29 28 61 21
18 Ruch Chorzów Ruch 29 31 50 20
TEMPORADA 2022/2023
LIGA POLACA
Equipo PJ GF GC Puntos
1 Raków Częstochowa Raków 34 63 24 75
2 Legia Warszawa Legia 34 57 37 66
3 Lech Poznań Lech Poznań 34 51 29 61
4 Pogon Szczecin Pogon 34 57 46 60
5 Piast Gliwice Piast 34 40 31 53
6 Górnik Zabrze Górnik 34 45 43 48
7 KS Cracovia KS Cracovia 34 41 35 46
8 Warta Poznan Warta Poznan 34 37 35 45
9 Zaglebie Lubin Zaglebie 34 35 44 45
10 Radomiak Radom Radomiak 34 34 41 44
11 Stal Mielec Stal Mielec 34 36 40 43
12 Widzew Łódź Widzew 34 38 47 41
13 Korona Kielce Korona 34 39 48 41
14 Jagiellonia Bialystok Jagiellonia 34 48 49 41
15 Śląsk Wrocław Śląsk 34 35 48 38
16 Wisła Płock Wisła 34 41 50 37
17 Lechia Gdansk Lechia 34 28 56 30
18 Miedz Legnica Miedz 34 33 55 23
TEMPORADA 2021/2022
LIGA POLACA
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 34 67 24 74
2 Raków Częstochowa Raków 34 60 30 69
3 Pogon Szczecin Pogon 34 63 31 65
4 Lechia Gdansk Lechia 34 52 39 57
5 Piast Gliwice Piast 34 45 37 54
6 Wisła Płock Wisła 34 48 51 48
7 Radomiak Radom Radomiak 34 42 40 48
8 Górnik Zabrze Górnik 34 55 55 47
9 KS Cracovia KS Cracovia 34 40 42 46
10 Legia Warszawa Legia 34 46 48 43
11 Warta Poznan Warta Poznan 34 35 38 42
12 Jagiellonia Bialystok Jagiellonia 34 39 50 40
13 Zaglebie Lubin Zaglebie 34 43 59 38
14 Stal Mielec Stal Mielec 34 39 52 37
15 Śląsk Wrocław Śląsk 34 42 52 35
16 Termalica Nieciecza Termalica 34 36 56 32
17 Wisla Kraków Wisla 34 37 54 31
18 Górnik Łęczna Górnik 34 29 60 28
TEMPORADA 2020/2021
LIGA POLACA
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 30 48 24 64
2 Raków Częstochowa Raków 30 46 25 59
3 Pogon Szczecin Pogon 30 36 23 52
4 Śląsk Wrocław Śląsk 30 36 32 43
5 Warta Poznan Warta Poznan 30 33 32 43
6 Piast Gliwice Piast 30 39 32 42
7 Lechia Gdansk Lechia 30 40 37 42
8 Zaglebie Lubin Zaglebie 30 38 40 41
9 Jagiellonia Bialystok Jagiellonia 30 39 48 37
10 Górnik Zabrze Górnik 30 31 33 37
11 Lech Poznań Lech Poznań 30 39 38 37
12 Wisła Płock Wisła 30 37 44 33
13 Wisla Kraków Wisla 30 39 42 33
14 KS Cracovia KS Cracovia 30 28 32 32
15 Stal Mielec Stal Mielec 30 31 47 29
16 Podbeskidzie Podbeskidzie 30 29 60 25
TEMPORADA 2019/2020
LIGA POLACA GRUPO 3
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Zaglebie 7 12 7 53
2 Górnik Zabrze Górnik 7 12 9 53
3 Raków Częstochowa Raków 7 13 13 53
4 Wisła Płock Wisła 7 8 4 51
5 Wisla Kraków Wisla 7 7 9 45
6 Arka Gdynia Arka Gdynia 7 11 10 40
7 Korona Kielce Korona 7 8 11 35
8 LKS Lódz LKS Lódz 7 7 15 24
TEMPORADA 2018/2019
LIGA POLACA GRUPO 3
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 7 12 15 49
2 Korona Kielce Korona 7 7 10 47
3 Górnik Zabrze Górnik 7 12 4 46
4 Śląsk Wrocław Śląsk 7 14 8 44
5 Arka Gdynia Arka Gdynia 7 10 7 42
6 Wisła Płock Wisła 7 10 9 41
7 Miedz Legnica Miedz 7 10 13 40
8 Zagłębie Sosnowiec Zagłębie 7 8 17 29
TEMPORADA 2017/2018
LIGA POLACA GRUPO 2
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 7 12 4 70
2 Jagiellonia Bialystok Jagiellonia 7 10 5 67
3 Górnik Zabrze Górnik 7 12 8 60
4 Lech Poznań Lech Poznań 7 4 11 60
5 Wisła Płock Wisła 7 11 10 57
6 Wisla Kraków Wisla 7 10 6 55
7 Zaglebie Lubin Zaglebie 7 6 9 52
8 Korona Kielce Korona 7 5 17 49
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
LIGA POLACA GRUPO 3
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 7 16 10 32
2 Śląsk Wrocław Śląsk 7 13 9 31
3 Jagiellonia Bialystok Jagiellonia 7 9 8 28
4 Korona Kielce Korona 7 7 8 27
5 Termalica Nieciecza Termalica 7 6 7 26
6 Górnik Łęczna Górnik 7 10 10 24
7 Górnik Zabrze Górnik 7 5 5 23
8 Podbeskidzie Podbeskidzie 7 8 17 20
TEMPORADA 2014/2015
LIGA POLACA GRUPO 2
Equipo PJ GF GC Puntos
1 Lech Poznań Lech Poznań 7 15 6 43
2 Legia Warszawa Legia 7 7 3 42
3 Jagiellonia Bialystok Jagiellonia 7 16 9 41
4 Śląsk Wrocław Śląsk 7 7 7 35
5 Lechia Gdansk Lechia 7 9 10 29
6 Wisla Kraków Wisla 7 9 9 28
7 Górnik Zabrze Górnik 7 7 17 26
8 Pogon Szczecin Pogon 7 5 14 22
TEMPORADA 2013/2014
LIGA POLACA GRUPO 2
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 7 15 4 50
2 Lech Poznań Lech Poznań 7 12 6 40
3 Ruch Chorzów Ruch 7 7 10 34
4 Lechia Gdansk Lechia 7 8 4 32
5 Górnik Zabrze Górnik 7 11 11 31
6 Wisla Kraków Wisla 7 13 16 31
7 Pogon Szczecin Pogon 7 3 12 27
8 Zawisza Bydgoszcz Zawisza 7 5 11 25
TEMPORADA 2012/2013
LIGA POLACA
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 30 59 22 67
2 Lech Poznań Lech Poznań 30 46 22 61
3 Śląsk Wrocław Śląsk 30 44 42 47
4 Piast Gliwice Piast 30 41 41 46
5 Górnik Zabrze Górnik 30 35 31 43
6 Polonia Warszawa Polonia 30 45 34 42
7 Lechia Gdansk Lechia 30 42 43 38
8 Wisla Kraków Wisla 30 28 35 38
9 Zaglebie Lubin Zaglebie 30 38 37 37
10 Jagiellonia Bialystok Jagiellonia 30 31 45 37
11 Korona Kielce Korona 30 32 37 36
12 Pogon Szczecin Pogon 30 29 39 35
13 Widzew Łódź Widzew 30 30 41 33
14 Podbeskidzie Podbeskidzie 30 39 43 32
15 Ruch Chorzów Ruch 30 35 48 31
16 GKS Bełchatów Bełchatów 30 24 38 31
TEMPORADA 2011/2012
LIGA POLACA
Equipo PJ GF GC Puntos
1 Śląsk Wrocław Śląsk 30 47 31 56
2 Ruch Chorzów Ruch 30 44 28 55
3 Legia Warszawa Legia 30 42 17 53
4 Lech Poznań Lech Poznań 30 42 22 52
5 Korona Kielce Korona 30 34 29 48
6 Polonia W. Polonia W. 30 33 32 45
7 Wisla Kraków Wisla 30 29 26 43
8 Górnik Zabrze Górnik 30 36 30 42
9 Zaglebie Lubin Zaglebie 30 36 42 40
10 Widzew Łódź Widzew 30 25 26 39
11 Jagiellonia Bialystok Jagiellonia 30 35 45 39
12 Podbeskidzie Podbeskidzie 30 26 39 35
13 GKS Bełchatów Bełchatów 30 34 36 31
14 Lechia Gdansk Lechia 30 21 30 31
15 LKS Lódz LKS Lódz 30 23 53 24
16 KS Cracovia KS Cracovia 30 20 41 22
TEMPORADA 2010/2011
LIGA POLACA
Equipo PJ GF GC Puntos
1 Wisla Kraków Wisla 30 44 29 56
2 Śląsk Wrocław Śląsk 30 46 34 49
3 Legia Warszawa Legia 30 45 38 49
4 Jagiellonia Bialystok Jagiellonia 30 38 32 48
5 Lech Poznań Lech Poznań 30 37 23 45
6 Górnik Zabrze Górnik 30 36 40 45
7 Polonia W. Polonia W. 30 41 26 44
8 Widzew Łódź Widzew 30 41 34 43
9 Lechia Gdansk Lechia 30 37 36 43
10 GKS Bełchatów Bełchatów 30 31 33 40
11 Zaglebie Lubin Zaglebie 30 31 38 39
12 Ruch Chorzów Ruch 30 29 32 38
13 Korona Kielce Korona 30 34 48 37
14 KS Cracovia KS Cracovia 30 37 47 29
15 Arka Gdynia Arka Gdynia 30 22 43 28
16 TS Polonia Bytom Polonia 30 29 45 27

  USO DE MEMORIA  
6,686,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6745
Total Execution Time  0.6758
  CADENA URL  
/historico/Ks-Gornik-Zabrze
  GET DATOS  
$_GET['/historico/Ks-Gornik-Zabrze']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0190  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 = 'Ks-Gornik-Zabrze' 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.0136  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=1468 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=1468 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=1468 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=1468 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1468 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1468 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (290266,300167,324532,325746,326445) ORDER BY n.cover_points DESC, update_date DESC
0.0137  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 = '1468' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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 = '1468' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 72168 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=1468 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (72171,72168,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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 72168 AND teamId = 1468
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 1468
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1468
0.0131  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 = 72168 AND t.round = 30 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 = '1468' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1468' and rp.type = 4
0.0126  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 = '1468' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0141  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 = 72168 WHERE rp.league_id = 72168 AND rp.teamId = 1468 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.0147  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 = 72168 WHERE rp.league_id = 72168 AND rp.teamId = 1468 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 72168 WHERE rp.league_id = 72168 AND rp.teamId = 1468 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 1468 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 67771 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.0131  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 = 63126 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 `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 = 57378 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.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 `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 = 49920 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.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 `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 = 56792 AND t.round = 7 ORDER BY team.conference ASC,t.position 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 `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 = 43817 AND t.round = 30 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 `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 = 49563 AND t.round = 7 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 `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 = 43271 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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.0141  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 = 15467 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 `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 = 23686 AND t.round = 7 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 = 3818 AND t.round = 30 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 `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 = 13703 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 2422 AND t.round = 30 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 `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 = 10839 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 2038 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 1363 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 1076 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC