4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Verspah Oita
TEMPORADA 2023/2024
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Kochi United Kochi United 7 16 3 21
2 Veertien Kuwana Veertien 7 12 8 14
3 Okinawa SV Okinawa SV 6 13 7 12
4 Reilac Shiga Reilac Shiga 6 8 6 10
5 TIAMO Hirakata TIAMO 6 11 10 10
6 Suzuka Point Getters Suzuka Point 7 9 9 10
7 Sony Sendai Sony Sendai 7 8 8 10
8 Honda Honda 7 6 4 9
9 Tochigi City Tochigi City 6 10 10 9
10 Verspah Oita Verspah Oita 7 9 10 8
11 Yokogawa Musashino Yokogawa 7 8 9 8
12 Reinmeer Aomori Reinmeer 7 5 6 7
13 Maruyasu Industries Maruyasu 7 8 10 7
14 Minebea Mitsumi Minebea 7 4 12 5
15 Criacao Shinjuku Criacao 7 3 12 5
16 Urayasu Urayasu 7 4 10 3
TEMPORADA 2022/2023
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Honda Honda 28 51 26 53
2 Urayasu Urayasu 28 42 35 45
3 Reilac Shiga Reilac Shiga 28 47 37 44
4 Sony Sendai Sony Sendai 28 46 40 43
5 Reinmeer Aomori Reinmeer 28 30 24 42
6 Verspah Oita Verspah Oita 28 28 29 40
7 Kochi United Kochi United 28 30 26 38
8 Maruyasu Industries Maruyasu 28 34 34 37
9 Suzuka Point Getters Suzuka Point 28 34 41 36
10 Veertien Kuwana Veertien 28 35 32 35
11 Criacao Shinjuku Criacao 28 25 33 34
12 TIAMO Hirakata TIAMO 28 32 42 34
13 Yokogawa Musashino Yokogawa 28 30 36 32
14 Minebea Mitsumi Minebea 28 35 44 31
15 Okinawa SV Okinawa SV 28 18 38 26
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
TEMPORADA 2013/2014
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Honda Honda 13 36 11 34
2 Kagoshima United Kagoshima 13 23 5 34
3 Sagawa Printing Sagawa 13 21 12 27
4 Sony Sendai Sony Sendai 13 26 12 26
5 Verspah Oita Verspah Oita 13 17 9 23
6 Renofa Yamaguchi Renofa 13 25 13 22
7 Azul Claro Numazu Azul Claro. 13 11 14 14
8 Yokogawa Musashino Yokogawa 13 14 18 12
9 Vanraure Hachinohe Vanraure 13 11 18 12
10 Fagiano Okayama II Fagiano 13 10 22 11
11 Tochigi Uva Tochigi Uva 13 9 19 10
12 Minebea Mitsumi Minebea 13 11 24 10
13 Reilac Shiga Reilac Shiga 13 9 32 9
14 Maruyasu Industries Maruyasu 13 11 25 8

  USO DE MEMORIA  
6,086,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6718
Total Execution Time  0.6737
  CADENA URL  
/historico/Verspah-Oita
  GET DATOS  
$_GET['/historico/Verspah-Oita']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0293  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 = 75435
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20594 AND type_rel = 2
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=233 AND type_rel = 3
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 233 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 (1210510,1085447,1000011,822371,638010) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '20594' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '20594' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 75435 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=20594 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0155  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 (75435,71686) 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.0166  SELECT count(id) as num_players from rel_players WHERE league_id = 75435 AND teamId = 20594
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 71686 AND teamId = 20594
0.0147  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 = '20594' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20594' and rp.type = 4
0.0147  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 = '20594' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 = 75435 WHERE rp.league_id = 75435 AND rp.teamId = 20594 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.0168  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 = 75435 WHERE rp.league_id = 75435 AND rp.teamId = 20594 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163  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 = 75435 WHERE rp.league_id = 75435 AND rp.teamId = 20594 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 20594 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0162  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 = 75435 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 70962 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.0169  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.0163  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.0164  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.0168  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.0170  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.0155  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.0149  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.0148  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.0152  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.0152  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.0151  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.0150  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
0.0149  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 = 4442 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 4443 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC