4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lech Poznań Sub 19
TEMPORADA 2023/2024
LIGA POLACA SUB 19
Equipo PJ GF GC Puntos
1 Lech Poznań Sub 19 Lech Poznań 24 50 28 50
2 Legia Warszawa Sub 19 Legia 24 60 36 48
3 Warta Poznań Sub 19 Warta 24 69 46 44
4 Zaglebie Lubin Sub 19 Zaglebie 24 44 33 41
5 Górnik Zabrze Sub 19 Górnik 24 47 37 41
6 Arka Gdynia Sub 19 Arka Gdynia 24 50 36 40
7 Polonia Warszawa Sub 19 Polonia 24 41 31 39
8 Jagiellonia Sub 19 Jagiellonia 24 52 42 35
9 Cracovia Kraków Sub 19 Cracovia 24 50 57 32
10 Pogon Szczecin Sub 19 Pogon 24 45 46 30
11 Raków Częstochowa Sub 19 Raków 24 38 42 27
12 Korona Kielce Sub 19 Korona 24 35 48 24
13 Wisła Kraków Sub 19 Wisła 24 41 60 23
14 Odra Opole Sub 19 Odra Opole 24 31 56 23
15 Widzew Łódź Sub 19 Widzew 24 38 62 22
16 Sandecja Nowy Sacz Sub 19 Sandecja 24 34 65 19
TEMPORADA 2022/2023
LIGA POLACA SUB 19
Equipo PJ GF GC Puntos
1 Lech Poznań Sub 19 Lech Poznań 30 76 39 62
2 Górnik Zabrze Sub 19 Górnik 30 53 33 59
3 Raków Częstochowa Sub 19 Raków 30 60 39 54
4 Wisła Kraków Sub 19 Wisła 30 56 36 53
5 Zaglebie Lubin Sub 19 Zaglebie 30 59 53 50
6 Pogon Szczecin Sub 19 Pogon 30 77 57 46
7 Arka Gdynia Sub 19 Arka Gdynia 30 49 54 45
8 Legia Warszawa Sub 19 Legia 30 73 60 43
9 Polonia Warszawa Sub 19 Polonia 30 57 54 43
10 Korona Kielce Sub 19 Korona 30 63 67 41
11 Jagiellonia Sub 19 Jagiellonia 30 55 56 39
12 Cracovia Kraków Sub 19 Cracovia 30 52 70 39
13 Śląsk Wrocław Sub 19 Śląsk 30 50 53 37
14 FCB Escola Varsovia Sub 19 Escola 30 40 51 31
15 Lechia Gdansk Sub 19 Lechia 30 32 69 24
16 Miedź Legnica Sub 19 Miedź 30 26 87 14
TEMPORADA 2021/2022
LIGA POLACA SUB 19
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Sub 19 Zaglebie 30 47 32 59
2 Arka Gdynia Sub 19 Arka Gdynia 30 65 46 56
3 Legia Warszawa Sub 19 Legia 30 64 52 53
4 Wisła Kraków Sub 19 Wisła 30 65 46 52
5 Cracovia Kraków Sub 19 Cracovia 30 52 48 52
6 Polonia Warszawa Sub 19 Polonia 30 72 50 51
7 Śląsk Wrocław Sub 19 Śląsk 30 57 43 48
8 Lech Poznań Sub 19 Lech Poznań 30 73 50 47
9 Pogon Szczecin Sub 19 Pogon 30 60 46 42
10 Jagiellonia Sub 19 Jagiellonia 30 70 59 42
11 Raków Częstochowa Sub 19 Raków 30 50 55 37
12 Górnik Zabrze Sub 19 Górnik 30 49 42 36
13 SMS Lodz Sub 19 Lodz 30 38 51 32
14 Warta Poznań Sub 19 Warta 30 43 62 27
15 Stal Rzeszow Sub 19 Stal Rzeszow 30 43 88 22
16 Gwarek Zabrze Sub 19 Gwarek 30 22 100 15
TEMPORADA 2020/2021
LIGA POLACA SUB 19
Equipo PJ GF GC Puntos
1 Pogon Szczecin Sub 19 Pogon 30 73 45 61
2 Wisła Kraków Sub 19 Wisła 30 74 50 60
3 Śląsk Wrocław Sub 19 Śląsk 30 63 42 58
4 Zaglebie Lubin Sub 19 Zaglebie 30 62 39 57
5 Górnik Zabrze Sub 19 Górnik 30 50 43 48
6 Legia Warszawa Sub 19 Legia 30 66 55 46
7 Lech Poznań Sub 19 Lech Poznań 30 48 41 43
8 Gwarek Zabrze Sub 19 Gwarek 30 46 61 39
9 SMS Lodz Sub 19 Lodz 30 44 46 39
10 Jagiellonia Sub 19 Jagiellonia 30 67 55 39
11 Arka Gdynia Sub 19 Arka Gdynia 30 62 62 39
12 Cracovia Kraków Sub 19 Cracovia 30 49 52 39
13 FCB Escola Varsovia Sub 19 Escola 30 49 55 39
14 Lechia Gdansk Sub 19 Lechia 30 51 65 25
15 Korona Kielce Sub 19 Korona 30 45 63 25
16 Nowy Hutnik Sub 19 Nowy Hutnik 30 26 101 16
TEMPORADA 2019/2020
LIGA POLACA SUB 19
Equipo PJ GF GC Puntos
1 Górnik Zabrze Sub 19 Górnik 17 34 19 38
2 Legia Warszawa Sub 19 Legia 17 42 17 37
3 Zaglebie Lubin Sub 19 Zaglebie 17 40 20 36
4 Pogon Szczecin Sub 19 Pogon 17 37 24 35
5 Korona Kielce Sub 19 Korona 17 32 25 29
6 Lechia Gdansk Sub 19 Lechia 17 32 36 24
7 Śląsk Wrocław Sub 19 Śląsk 17 43 38 24
8 Arka Gdynia Sub 19 Arka Gdynia 17 25 24 23
9 Jagiellonia Sub 19 Jagiellonia 17 28 27 22
10 Lech Poznań Sub 19 Lech Poznań 17 30 27 20
11 Cracovia Kraków Sub 19 Cracovia 17 28 32 19
12 SMS Lodz Sub 19 Lodz 17 27 40 19
13 FCB Escola Varsovia Sub 19 Escola 17 20 32 17
14 Wisła Kraków Sub 19 Wisła 17 29 33 16
15 Gwarek Zabrze Sub 19 Gwarek 17 24 36 16
16 Nowy Hutnik Sub 19 Nowy Hutnik 17 14 55 4
TEMPORADA 2018/2019
LIGA POLACA SUB 19
Equipo PJ GF GC Puntos
1 Korona Kielce Sub 19 Korona 30 76 31 74
2 Śląsk Wrocław Sub 19 Śląsk 30 76 54 58
3 Zaglebie Lubin Sub 19 Zaglebie 30 54 35 54
4 Jagiellonia Sub 19 Jagiellonia 30 57 49 50
5 Cracovia Kraków Sub 19 Cracovia 30 66 54 48
6 Legia Warszawa Sub 19 Legia 30 44 41 46
7 Arka Gdynia Sub 19 Arka Gdynia 30 50 47 44
8 Wisła Kraków Sub 19 Wisła 30 38 37 43
9 Pogon Szczecin Sub 19 Pogon 30 56 47 41
10 Lech Poznań Sub 19 Lech Poznań 30 55 49 41
11 FCB Escola Varsovia Sub 19 Escola 30 53 57 38
12 Górnik Zabrze Sub 19 Górnik 30 46 54 35
13 Ruch Chorzów Sub 19 Ruch 30 47 66 31
14 GKS Belchatow Sub 19 Belchatow 30 32 65 29
15 Motor Lublin Sub 19 Motor Lublin 30 28 43 28
16 Elana Torun Sub 19 Elana Torun 30 23 72 15
TEMPORADA 2017/2018
LIGA POLACA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Śląsk Wrocław Sub 19 Śląsk 30 80 33 66
2 Lech Poznań Sub 19 Lech Poznań 30 87 26 64
3 Pogon Szczecin Sub 19 Pogon 30 75 33 64
4 Arka Gdynia Sub 19 Arka Gdynia 30 62 26 61
5 Zaglebie Lubin Sub 19 Zaglebie 30 62 41 55
6 Górnik Zabrze Sub 19 Górnik 30 67 37 53
7 Warta Poznań Sub 19 Warta 30 51 35 51
8 Podbeskidzie Sub 19 Podbeskidzie 30 39 37 43
9 Miedź Legnica Sub 19 Miedź 30 40 40 43
10 Lechia Gdansk Sub 19 Lechia 30 34 48 40
11 Chrobry Głogów Sub 19 Chrobry 30 41 49 36
12 Piast Gliwice Sub 19 Piast 30 32 61 26
13 Salos Szczecin Sub 19 Salos 30 29 68 22
14 Odra Opole Sub 19 Odra Opole 30 32 74 21
15 Zielona Góra Sub 19 Zielona 30 18 73 15
16 Warta GW Sub 19 Warta 30 24 92 14
TEMPORADA 2016/2017
LIGA POLACA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Pogon Szczecin Sub 19 Pogon 30 90 31 69
2 Lech Poznań Sub 19 Lech Poznań 30 89 27 67
3 Arka Gdynia Sub 19 Arka Gdynia 30 69 35 52
4 Warta Poznań Sub 19 Warta 30 43 42 51
5 Zaglebie Lubin Sub 19 Zaglebie 30 55 53 46
6 Piast Gliwice Sub 19 Piast 30 60 57 45
7 Lechia Gdansk Sub 19 Lechia 30 44 42 44
8 Górnik Zabrze Sub 19 Górnik 30 42 45 42
9 Śląsk Wrocław Sub 19 Śląsk 30 43 35 41
10 Zielona Góra Sub 19 Zielona 30 34 46 38
11 Miedź Legnica Sub 19 Miedź 30 40 50 37
12 Salos Szczecin Sub 19 Salos 30 32 52 36
13 Gwarek Zabrze Sub 19 Gwarek 30 38 56 33
14 Bałtyk Koszalin Sub 19 Bałtyk 30 45 64 33
15 Gryf Słupsk Sub 19 Gryf Słupsk 30 31 82 23
16 Wrocław Academy Sub 19 Wrocław 30 31 69 22
TEMPORADA 2015/2016
LIGA POLACA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Lech Poznań Sub 19 Lech Poznań 30 90 27 75
2 Pogon Szczecin Sub 19 Pogon 30 83 30 71
3 Zaglebie Lubin Sub 19 Zaglebie 30 56 37 55
4 Wrocław Academy Sub 19 Wrocław 30 56 34 49
5 Bałtyk Koszalin Sub 19 Bałtyk 30 55 43 47
6 Warta Poznań Sub 19 Warta 30 48 35 42
7 Lechia Gdansk Sub 19 Lechia 30 48 41 42
8 Arka Gdynia Sub 19 Arka Gdynia 30 45 47 42
9 Śląsk Wrocław Sub 19 Śląsk 30 46 56 39
10 Górnik Zabrze Sub 19 Górnik 30 37 37 38
11 Gwarek Zabrze Sub 19 Gwarek 30 47 50 37
12 Zielona Góra Sub 19 Zielona 30 29 34 37
13 Ruch Chorzów Sub 19 Ruch 30 45 48 35
14 Zawisza Bydgoszcz Sub 19 Zawisza 30 33 60 24
15 Pomologia Proszkow Sub 19 Pomologia 30 26 58 24
16 ARKA Nowa Sól Sub 19 ARKA Nowa S. 30 16 123 10
TEMPORADA 2014/2015
LIGA POLACA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Lech Poznań Sub 19 Lech Poznań 30 92 34 70
2 Górnik Zabrze Sub 19 Górnik 30 73 28 63
3 Lechia Gdansk Sub 19 Lechia 30 59 22 61
4 Pogon Szczecin Sub 19 Pogon 30 68 43 55
5 Arka Gdynia Sub 19 Arka Gdynia 30 49 29 54
6 Zaglebie Lubin Sub 19 Zaglebie 30 75 39 52
7 Ruch Chorzów Sub 19 Ruch 30 44 31 46
8 Warta Poznań Sub 19 Warta 30 54 40 43
9 Bałtyk Koszalin Sub 19 Bałtyk 30 55 50 43
10 Śląsk Wrocław Sub 19 Śląsk 30 58 49 41
11 Zawisza Bydgoszcz Sub 19 Zawisza 30 41 55 40
12 Odra Opole Sub 19 Odra Opole 30 48 47 39
13 Zielona Góra Sub 19 Zielona 30 33 33 39
14 Olimpia Grudziadz Sub 19 Olimpia 30 22 98 14
15 Kluczbork Sub 19 Kluczbork 30 26 111 14
16 Stilon Gorzów Sub 19 Stilon 30 20 108 8
TEMPORADA 2013/2014
LIGA POLACA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Lech Poznań Sub 19 Lech Poznań 22 73 24 55
2 Pogon Szczecin Sub 19 Pogon 22 62 21 51
3 Arka Gdynia Sub 19 Arka Gdynia 22 56 12 48
4 Lechia Gdansk Sub 19 Lechia 22 34 23 39
5 Bałtyk Koszalin Sub 19 Bałtyk 22 41 22 36
6 Warta Poznań Sub 19 Warta 22 45 30 35
7 Zawisza Bydgoszcz Sub 19 Zawisza 22 41 28 26
8 Bałtyk Gdynia Sub 19 Bałtyk 22 28 32 26
9 AP Pogon Szczecin Sub 19 Pogon 22 46 44 23
10 Polonia Leszno Sub 19 Polonia 22 30 57 22
11 Lider Włocławek Sub 19 Lider 22 25 94 9
12 Elana Torun Sub 19 Elana Torun 22 12 106 4

  USO DE MEMORIA  
6,238,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5388
Total Execution Time  0.5403
  CADENA URL  
/historico/Lech-Poznan-Sub19
  GET DATOS  
$_GET['/historico/Lech-Poznan-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0136  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 = 'Lech-Poznan-Sub19' 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.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=110435 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=110435 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=110435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=110435 AND type_rel = 2
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=529 AND type_rel = 3
0.0182  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 529 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0150  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 (1312351,1312141,1311677,1306283,1301430) ORDER BY n.cover_points DESC, update_date DESC
0.0148  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 = '110435' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0135  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 = '110435' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0132  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 = 72876 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=110435 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (74025,72876) 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 = 72876 AND teamId = 110435
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 74025 AND teamId = 110435
0.0128  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 = '110435' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '110435' 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 = '110435' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0132  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 = 74025 WHERE rp.league_id = 74025 AND rp.teamId = 110435 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.0132  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 = 74025 WHERE rp.league_id = 74025 AND rp.teamId = 110435 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 74025 WHERE rp.league_id = 74025 AND rp.teamId = 110435 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 110435 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 `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 = 68692 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 `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 = 63577 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 `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 = 57495 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 = 51474 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.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 `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 = 42981 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 `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 = 43728 AND t.round = 30 ORDER BY team.conference 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 `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 = 43731 AND t.round = 30 ORDER BY team.conference 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 `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 = 43734 AND t.round = 30 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 `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 = 43747 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 74025 ORDER BY nameShow LIMIT 100