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

Osaka

Entrenador: Naoto Otake

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Omiya Ardija Omiya Ardija 12 24 7 30
2 Azul Claro Numazu Azul Claro. 12 21 11 22
3 Osaka Osaka 12 15 6 21
4 Imabari Imabari 12 15 13 21
5 Gifu Gifu 11 18 11 19
6 Sagamihara Sagamihara 12 10 8 18
7 Zweigen Kanazawa Zweigen 12 21 20 18
8 Ryūkyū Ryūkyū 12 17 16 17
9 Matsumoto Yamaga Matsumoto 12 15 17 17
10 Gainare Tottori Gainare 12 11 15 16
11 Kataller Toyama Kataller 12 10 12 15
12 Parceiro Nagano Parceiro 11 19 19 14
13 Fukushima United Fukushima 12 17 14 12
14 Giravanz Kitakyushu Giravanz 12 8 9 12
15 YSCC YSCC 12 9 14 11
16 Nara Club Nara Club 12 14 18 10
17 Tegevajaro Miyazaki Tegevajaro 12 12 18 10
18 Vanraure Hachinohe Vanraure 12 6 12 9
19 Grulla Morioka Grulla 12 9 26 9
20 Kamatamare Sanuki Kamatamare 12 11 16 8
TEMPORADA 2022/2023
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Ehime Ehime 38 59 48 73
2 Kagoshima United Kagoshima 38 58 41 62
3 Kataller Toyama Kataller 38 59 48 62
4 Imabari Imabari 38 54 42 59
5 Nara Club Nara Club 38 45 32 57
6 Gainare Tottori Gainare 38 57 52 56
7 Vanraure Hachinohe Vanraure 38 49 47 56
8 Gifu Gifu 38 44 35 54
9 Matsumoto Yamaga Matsumoto 38 51 47 54
10 Grulla Morioka Grulla 38 48 49 54
11 Osaka Osaka 38 41 38 53
12 YSCC YSCC 38 48 50 52
13 Azul Claro Numazu Azul Claro. 38 48 48 51
14 Parceiro Nagano Parceiro 38 52 60 50
15 Fukushima United Fukushima 38 37 42 47
16 Kamatamare Sanuki Kamatamare 38 29 45 44
17 Ryūkyū Ryūkyū 38 43 61 43
18 Sagamihara Sagamihara 38 44 48 41
19 Tegevajaro Miyazaki Tegevajaro 38 31 52 39
20 Giravanz Kitakyushu Giravanz 38 33 45 31
TEMPORADA 2021/2022
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Nara Club Nara Club 30 48 25 59
2 Osaka Osaka 30 47 34 59
3 Honda Honda 30 47 23 56
4 Reinmeer Aomori Reinmeer 30 35 23 51
5 Maruyasu Industries Maruyasu 30 48 34 49
6 Yokogawa Musashino Yokogawa 30 49 33 48
7 Veertien Kuwana Veertien 30 43 29 45
8 Verspah Oita Verspah Oita 30 40 44 43
9 Suzuka Point Getters Suzuka Point 30 31 40 41
10 Minebea Mitsumi Minebea 30 33 33 36
11 Kochi United Kochi United 30 30 39 34
12 Kagura Shimane Kagura 30 32 42 34
13 TIAMO Hirakata TIAMO 30 40 50 32
14 Sony Sendai Sony Sendai 30 23 39 28
15 Criacao Shinjuku Criacao 30 30 52 24
16 Reilac Shiga Reilac Shiga 30 21 57 21
TEMPORADA 2020/2021
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Iwaki FC Iwaki FC 32 65 28 71
2 Honda Honda 32 69 25 67
3 Verspah Oita Verspah Oita 32 46 24 62
4 Suzuka Point Getters Suzuka Point 32 51 46 50
5 Kagura Shimane Kagura 32 38 37 50
6 Sony Sendai Sony Sendai 32 52 39 48
7 Osaka Osaka 32 37 35 48
8 TIAMO Hirakata TIAMO 32 58 57 48
9 Reinmeer Aomori Reinmeer 32 41 49 45
10 Nara Club Nara Club 32 39 36 43
11 Veertien Kuwana Veertien 32 40 43 40
12 Reilac Shiga Reilac Shiga 32 35 48 37
13 Kochi United Kochi United 32 30 49 33
14 Maruyasu Industries Maruyasu 32 27 46 33
15 Yokogawa Musashino Yokogawa 32 38 53 32
16 Minebea Mitsumi Minebea 32 26 48 27
17 FC Kariya FC Kariya 32 26 55 18
TEMPORADA 2019/2020
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Verspah Oita Verspah Oita 15 27 16 32
2 Tegevajaro Miyazaki Tegevajaro 14 26 11 28
3 Sony Sendai Sony Sendai 15 25 22 26
4 Honda Honda 15 20 12 22
5 Suzuka Point Getters Suzuka Point 15 23 19 21
6 Veertien Kuwana Veertien 15 17 16 21
7 Iwaki FC Iwaki FC 15 24 24 21
8 Reilac Shiga Reilac Shiga 15 23 27 20
9 Kagura Shimane Kagura 15 18 24 20
10 Minebea Mitsumi Minebea 15 19 25 19
11 Nara Club Nara Club 15 21 21 18
12 Yokogawa Musashino Yokogawa 14 15 17 18
13 Osaka Osaka 14 20 24 17
14 Kochi United Kochi United 15 17 20 16
15 Maruyasu Industries Maruyasu 15 14 22 15
16 Reinmeer Aomori Reinmeer 14 17 26 15
TEMPORADA 2018/2019
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Honda Honda 30 59 30 63
2 Sony Sendai Sony Sendai 30 60 34 55
3 Imabari Imabari 30 41 26 51
4 Yokogawa Musashino Yokogawa 30 44 39 48
5 Tegevajaro Miyazaki Tegevajaro 30 37 34 41
6 Minebea Mitsumi Minebea 30 41 39 41
7 Verspah Oita Verspah Oita 30 42 36 40
8 Osaka Osaka 30 33 32 40
9 Reilac Shiga Reilac Shiga 30 27 40 40
10 Veertien Kuwana Veertien 30 38 34 39
11 Maruyasu Industries Maruyasu 30 30 30 38
12 Suzuka Point Getters Suzuka Point 30 43 47 36
13 Reinmeer Aomori Reinmeer 30 40 44 36
14 Nara Club Nara Club 30 27 32 34
15 Kagura Shimane Kagura 30 26 51 25
16 Ryutsu Keizai Dragons Ryutsu 30 35 75 21
TEMPORADA 2017/2018
LIGA FÚTBOL JAPÓN - 2ª FASE
Equipo PJ GF GC Puntos
1 Honda Honda 15 34 8 41
2 Vanraure Hachinohe Vanraure 15 20 7 31
3 Sony Sendai Sony Sendai 15 37 25 28
4 Imabari Imabari 15 35 16 27
5 Reilac Shiga Reilac Shiga 15 22 17 27
6 Yokogawa Musashino Yokogawa 15 28 18 24
7 Verspah Oita Verspah Oita 15 16 14 24
8 Osaka Osaka 15 22 17 23
9 Tegevajaro Miyazaki Tegevajaro 15 23 24 23
10 Maruyasu Industries Maruyasu 15 12 16 18
11 Nara Club Nara Club 15 11 12 17
12 Veertien Kuwana Veertien 15 22 32 15
13 Reinmeer Aomori Reinmeer 15 20 30 15
14 Minebea Mitsumi Minebea 15 16 27 12
15 Ryutsu Keizai Dragons Ryutsu 15 12 37 8
16 Cobaltore Onagawa Cobaltore 15 10 40 2
TEMPORADA 2016/2017
LIGA FÚTBOL JAPÓN - 2ª FASE
Equipo PJ GF GC Puntos
1 Honda Honda 15 33 9 34
2 Reinmeer Aomori Reinmeer 15 27 18 31
3 Vanraure Hachinohe Vanraure 15 18 13 27
4 Imabari Imabari 15 38 21 26
5 Nara Club Nara Club 15 23 22 26
6 Osaka Osaka 15 32 18 25
7 Sony Sendai Sony Sendai 15 28 21 23
8 Maruyasu Industries Maruyasu 15 19 22 21
9 Minebea Mitsumi Minebea 15 21 23 18
10 Urayasu Urayasu 15 14 19 17
11 Verspah Oita Verspah Oita 15 15 23 15
12 Ryutsu Keizai Dragons Ryutsu 15 23 31 14
13 Reilac Shiga Reilac Shiga 15 16 26 14
14 Tochigi Uva Tochigi Uva 15 7 26 14
15 Yokogawa Musashino Yokogawa 15 18 28 13
16 Veertien Kuwana Veertien 15 13 25 10
TEMPORADA 2015/2016
LIGA FÚTBOL JAPÓN - 2ª FASE
Equipo PJ GF GC Puntos
1 Ryutsu Keizai Dragons Ryutsu 15 30 14 35
2 Osaka Osaka 15 28 14 32
3 Azul Claro Numazu Azul Claro. 15 21 11 29
4 Minebea Mitsumi Minebea 15 18 10 26
5 Vanraure Hachinohe Vanraure 15 19 10 25
6 Honda Honda 15 21 16 25
7 Sony Sendai Sony Sendai 15 24 15 23
8 Reilac Shiga Reilac Shiga 15 19 23 22
9 Urayasu Urayasu 15 19 22 19
10 Yokogawa Musashino Yokogawa 15 10 14 19
11 Reinmeer Aomori Reinmeer 15 15 17 17
12 Maruyasu Industries Maruyasu 15 10 15 17
13 Verspah Oita Verspah Oita 15 13 18 16
14 Nara Club Nara Club 15 17 25 14
15 Tochigi Uva Tochigi Uva 15 19 42 10
16 Fagiano Okayama II Fagiano 15 10 27 6
TEMPORADA 2014/2015
LIGA FÚTBOL JAPÓN - 2ª FASE
Equipo PJ GF GC Puntos
1 Vanraure Hachinohe Vanraure 15 21 8 34
2 Sony Sendai Sony Sendai 15 22 11 34
3 Honda Honda 15 31 9 33
4 Kagoshima United Kagoshima 15 20 11 30
5 Osaka Osaka 15 26 11 29
6 Azul Claro Numazu Azul Claro. 15 17 12 28
7 Nara Club Nara Club 15 14 13 23
8 Sagawa Printing Sagawa 15 24 14 22
9 Minebea Mitsumi Minebea 15 16 21 19
10 Reilac Shiga Reilac Shiga 15 18 17 18
11 Verspah Oita Verspah Oita 15 21 27 18
12 Yokogawa Musashino Yokogawa 15 15 18 17
13 Ryutsu Keizai Dragons Ryutsu 15 16 31 10
14 Maruyasu Industries Maruyasu 15 10 26 9
15 Tochigi Uva Tochigi Uva 15 12 27 8
16 Fagiano Okayama II Fagiano 15 7 34 4

  USO DE MEMORIA  
6,415,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5149
Total Execution Time  0.5161
  CADENA URL  
/historico/Osaka
  GET DATOS  
$_GET['/historico/Osaka']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0118  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 = 'Osaka' 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.0105  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=62300 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=62300 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=62300 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=62300 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62300 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=515 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 515 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  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 (1194856,840228,812834,543923,269590) ORDER BY n.cover_points DESC, update_date DESC
0.0111  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 = '62300' ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '62300' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '62300' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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=62300 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (75185,74985,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.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 74985 AND teamId = 62300
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 75185 AND teamId = 62300
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 62300
0.0108  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 = '62300' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62300' and rp.type = 4
0.0108  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 = '62300' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0123  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 = 74985 WHERE rp.league_id = 74985 AND rp.teamId = 62300 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.0120  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 = 74985 WHERE rp.league_id = 74985 AND rp.teamId = 62300 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 74985 WHERE rp.league_id = 74985 AND rp.teamId = 62300 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  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 = 62300 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0112  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 = 74985 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 70796 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.0112  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 = 66708 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.0118  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 = 61094 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.0111  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 = 55426 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.0111  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 = 48941 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 42642 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 43954 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 37804 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 38924 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 20345 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 23946 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 10273 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 12822 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC