4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Korona Kielce Sub 19
TEMPORADA 2023/2024
LIGA POLACA SUB 19
Equipo PJ GF GC Puntos
1 Legia Warszawa Sub 19 Legia 25 66 38 51
2 Lech Poznań Sub 19 Lech Poznań 25 51 29 51
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 25 47 39 41
6 Arka Gdynia Sub 19 Arka Gdynia 24 50 36 40
7 Polonia Warszawa Sub 19 Polonia 25 42 33 39
8 Jagiellonia Sub 19 Jagiellonia 25 54 43 38
9 Cracovia Kraków Sub 19 Cracovia 25 52 63 32
10 Pogon Szczecin Sub 19 Pogon 25 46 47 31
11 Raków Częstochowa Sub 19 Raków 24 38 42 27
12 Odra Opole Sub 19 Odra Opole 25 33 56 26
13 Korona Kielce Sub 19 Korona 24 35 48 24
14 Wisła Kraków Sub 19 Wisła 24 41 60 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 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 1
Equipo PJ GF GC Puntos
1 Legia Warszawa Sub 19 Legia 30 79 24 72
2 Cracovia Kraków Sub 19 Cracovia 30 75 23 67
3 Motor Lublin Sub 19 Motor Lublin 30 58 25 59
4 Korona Kielce Sub 19 Korona 30 58 42 56
5 Jagiellonia Sub 19 Jagiellonia 30 61 39 53
6 Progres Kraków Sub 19 Progres 30 55 39 52
7 Wisła Kraków Sub 19 Wisła 30 40 32 52
8 SMS Lodz Sub 19 Lodz 30 53 40 47
9 Polonia Warszawa Sub 19 Polonia 30 58 40 43
10 Znicz Pruszków Sub 19 Znicz 30 42 43 36
11 Resovia Rzeszów Sub 19 Resovia 30 45 68 34
12 Stomil Olsztyn Sub 19 Stomil 30 27 49 26
13 Mosp Bialystok Sub 19 Mosp 30 30 76 26
14 Stal Rzeszow Sub 19 Stal Rzeszow 30 23 69 18
15 LKS Lodz Sub 19 Lodz 30 26 84 18
16 Wisła Płock Sub 19 Wisła 30 22 59 17
TEMPORADA 2016/2017
LIGA POLACA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Legia Warszawa Sub 19 Legia 30 85 17 74
2 SMS Lodz Sub 19 Lodz 30 75 24 69
3 Jagiellonia Sub 19 Jagiellonia 30 73 27 63
4 Progres Kraków Sub 19 Progres 30 65 47 55
5 Korona Kielce Sub 19 Korona 30 54 53 46
6 Znicz Pruszków Sub 19 Znicz 30 34 36 45
7 Polonia Warszawa Sub 19 Polonia 30 52 37 44
8 Wisła Kraków Sub 19 Wisła 30 49 46 44
9 Cracovia Kraków Sub 19 Cracovia 30 47 36 43
10 Motor Lublin Sub 19 Motor Lublin 30 51 47 43
11 LKS Lodz Sub 19 Lodz 30 35 42 37
12 Resovia Rzeszów Sub 19 Resovia 30 37 54 36
13 Stal Mielec Sub 19 Stal Mielec 30 54 52 33
14 GKS Bełchatów Sub 19 Bełchatów 30 39 59 28
15 Biała Podlaska Sub 19 Biała 30 28 92 14
16 Neptun Konskie Sub 19 Neptun 30 28 137 6
TEMPORADA 2015/2016
LIGA POLACA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Jagiellonia Sub 19 Jagiellonia 30 97 30 78
2 Legia Warszawa Sub 19 Legia 30 69 22 73
3 SMS Lodz Sub 19 Lodz 30 53 31 58
4 Korona Kielce Sub 19 Korona 30 41 30 52
5 Wisła Kraków Sub 19 Wisła 30 46 30 48
6 Polonia Warszawa Sub 19 Polonia 30 61 49 47
7 Cracovia Kraków Sub 19 Cracovia 30 41 35 46
8 Motor Lublin Sub 19 Motor Lublin 30 48 46 45
9 Stal Mielec Sub 19 Stal Mielec 30 48 37 42
10 LKS Lodz Sub 19 Lodz 30 37 45 38
11 GKS Bełchatów Sub 19 Bełchatów 30 29 39 36
12 Biała Podlaska Sub 19 Biała 30 36 49 32
13 Stal Rzeszow Sub 19 Stal Rzeszow 30 34 48 24
14 KSZO Sub 19 KSZO Sub 19 30 28 57 20
15 MKS Ełk Sub 19 Ełk 30 29 92 18
16 Nowy Hutnik Sub 19 Nowy Hutnik 30 31 88 12
TEMPORADA 2014/2015
LIGA POLACA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Legia Warszawa Sub 19 Legia 30 81 13 79
2 Polonia Warszawa Sub 19 Polonia 30 65 36 60
3 Cracovia Kraków Sub 19 Cracovia 30 65 42 53
4 Jagiellonia Sub 19 Jagiellonia 30 54 29 52
5 Wisła Kraków Sub 19 Wisła 30 53 43 52
6 GKS Bełchatów Sub 19 Bełchatów 30 36 31 48
7 Korona Kielce Sub 19 Korona 30 49 39 43
8 Motor Lublin Sub 19 Motor Lublin 30 54 47 43
9 Stal Mielec Sub 19 Stal Mielec 30 43 38 41
10 Stal Rzeszow Sub 19 Stal Rzeszow 30 31 49 36
11 KSZO Sub 19 KSZO Sub 19 30 35 36 35
12 LKS Lodz Sub 19 Lodz 30 41 65 35
13 Olimpia Elbląg Sub 19 Olimpia 30 28 65 27
14 Stomil Olsztyn Sub 19 Stomil 30 41 70 25
15 ŁKS Łomża Sub 19 ŁKS Łomża 30 27 67 24
16 Wisła Puławy Sub 19 Wisła 30 35 68 23
TEMPORADA 2013/2014
LIGA POLACA SUB 19 GRUPO 4
Equipo PJ GF GC Puntos
1 Wisła Kraków Sub 19 Wisła 22 58 21 48
2 Cracovia Kraków Sub 19 Cracovia 22 63 38 45
3 Korona Kielce Sub 19 Korona 22 50 23 41
4 Stal Mielec Sub 19 Stal Mielec 22 39 23 39
5 Stal Rzeszow Sub 19 Stal Rzeszow 22 50 21 35
6 Wisła Puławy Sub 19 Wisła 22 33 39 35
7 Widok Lublin Sub 19 Widok Lublin 22 39 33 28
8 KSZO Sub 19 KSZO Sub 19 22 27 26 27
9 Sandecja Nowy Sacz Sub 19 Sandecja 22 27 42 25
10 Stal Stalowa Wola Sub 19 Stal Stalowa 22 37 40 24
11 Juventa Starachowice Sub 19 Juventa 22 32 60 18
12 Górnik Łęczna Sub 19 Górnik 22 18 107 5

  USO DE MEMORIA  
5,992,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5425
Total Execution Time  0.5437
  CADENA URL  
/historico/Korona-Kielce-Sub19
  GET DATOS  
$_GET['/historico/Korona-Kielce-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0138  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 = 'Korona-Kielce-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.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=110420 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=110420 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0135  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=110420 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 110420 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 (723591,732040) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '110420' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '110420' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '110420' 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 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=110420 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 (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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 72876 AND teamId = 110420
0.0141  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 = '110420' 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 = '110420' and rp.type = 4
0.0127  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 = '110420' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 72876 WHERE rp.league_id = 72876 AND rp.teamId = 110420 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.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 = 72876 WHERE rp.league_id = 72876 AND rp.teamId = 110420 AND (e.action = 4 or e.action = 5) 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 = 72876 WHERE rp.league_id = 72876 AND rp.teamId = 110420 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0711  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 = 110420 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72876 AND t.round = 25 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 = 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.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 = 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.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 = 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 `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 = 45188 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 `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 = 42980 AND t.round = 30 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 `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 = 43727 AND t.round = 30 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 `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 = 43730 AND t.round = 30 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 `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 = 43733 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 43749 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC