4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Zaglebie Lubin

Zaglebie Lubin

Entrenador: Waldemar Fornalik

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA POLACA
Equipo PJ GF GC Puntos
1 Jagiellonia Bialystok Jagiellonia 30 68 41 56
2 Lech Poznań Lech Poznań 30 43 34 52
3 Górnik Zabrze Górnik 30 43 33 51
4 Śląsk Wrocław Śląsk 30 40 29 51
5 Legia Warszawa Legia 30 46 34 50
6 Raków Częstochowa Raków 30 51 32 49
7 Pogon Szczecin Pogon 30 56 36 48
8 Widzew Łódź Widzew 30 39 39 42
9 Piast Gliwice Piast 30 32 32 38
10 Stal Mielec Stal Mielec 30 36 42 38
11 Zaglebie Lubin Zaglebie 30 35 46 38
12 Radomiak Radom Radomiak 30 37 51 35
13 Warta Poznan Warta Poznan 30 31 37 34
14 Puszcza Niepolomice Puszcza 30 36 47 33
15 KS Cracovia KS Cracovia 30 38 40 33
16 Korona Kielce Korona 30 35 39 31
17 Ruch Chorzów Ruch 30 34 52 23
18 LKS Lódz LKS Lódz 30 29 65 21
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 2
Equipo PJ GF GC Puntos
1 Piast Gliwice Piast 7 10 2 72
2 Legia Warszawa Legia 7 7 7 68
3 Lechia Gdansk Lechia 7 9 13 67
4 Jagiellonia Bialystok Jagiellonia 7 10 11 57
5 KS Cracovia KS Cracovia 7 6 9 57
6 Zaglebie Lubin Zaglebie 7 9 10 53
7 Pogon Szczecin Pogon 7 13 12 52
8 Lech Poznań Lech Poznań 7 8 8 52
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
LIGA POLACA GRUPO 3
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Zaglebie 7 14 9 34
2 Piast Gliwice Piast 7 14 5 31
3 Śląsk Wrocław Śląsk 7 15 7 29
4 Wisła Płock Wisła 7 7 13 28
5 KS Cracovia KS Cracovia 7 7 9 24
6 Arka Gdynia Arka Gdynia 7 7 10 24
7 Górnik Łęczna Górnik 7 11 11 22
8 Ruch Chorzów Ruch 7 5 16 19
TEMPORADA 2015/2016
LIGA POLACA GRUPO 2
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 7 12 4 43
2 Piast Gliwice Piast 7 11 9 40
3 Zaglebie Lubin Zaglebie 7 14 5 38
4 KS Cracovia KS Cracovia 7 9 8 36
5 Lechia Gdansk Lechia 7 8 7 33
6 Pogon Szczecin Pogon 7 7 13 30
7 Lech Poznań Lech Poznań 7 5 9 27
8 Ruch Chorzów Ruch 7 3 14 21
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
LIGA POLACA GRUPO 1
Equipo PJ GF GC Puntos
1 Legia Warszawa Legia 30 60 30 63
2 Lech Poznań Lech Poznań 30 56 34 53
3 Ruch Chorzów Ruch 30 40 38 50
4 Pogon Szczecin Pogon 30 47 38 47
5 Wisla Kraków Wisla 30 38 30 45
6 Zawisza Bydgoszcz Zawisza 30 43 37 42
7 Górnik Zabrze Górnik 30 42 46 42
8 Lechia Gdansk Lechia 30 38 37 40
9 Jagiellonia Bialystok Jagiellonia 30 46 43 39
10 KS Cracovia KS Cracovia 30 37 43 39
11 Korona Kielce Korona 30 36 41 37
12 Śląsk Wrocław Śląsk 30 38 40 34
13 Piast Gliwice Piast 30 29 47 34
14 Podbeskidzie Podbeskidzie 30 27 39 31
15 Zaglebie Lubin Zaglebie 30 31 40 29
16 Widzew Łódź Widzew 30 26 51 22
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,710,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6444
Total Execution Time  0.6464
  CADENA URL  
/historico/Zaglebie-Lubin
  GET DATOS  
$_GET['/historico/Zaglebie-Lubin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0281  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 = 72168
0.0156  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 = 72171
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3974 AND type_rel = 2
0.0138  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3974 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0138  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 (97638,111611,135482,138528,155052) ORDER BY n.cover_points DESC, update_date DESC
0.0179  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 = '3974' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 72171 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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.0132  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=3974 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 72168 AND teamId = 3974
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 3974
0.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3974
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.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 = 3974 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.0149  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 = 3974 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 3974 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 3974 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 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 `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.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 `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.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 `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.0127  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 = 49562 AND t.round = 7 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 `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 = 38694 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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.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 `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 = 31530 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 38340 AND t.round = 7 ORDER BY team.conference 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 `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.0127  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 = 23684 AND t.round = 7 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 = 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.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 `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 = 10840 AND t.round = 7 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 `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.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 `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.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 = 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.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 `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
0.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72168 ORDER BY nameShow LIMIT 100