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

Sagamihara

Entrenador: Kazuyuki Toda

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Omiya Ardija Omiya Ardija 11 21 7 27
2 Azul Claro Numazu Azul Claro. 10 19 9 20
3 Imabari Imabari 11 14 12 20
4 Osaka Osaka 10 13 4 19
5 Gifu Gifu 10 18 11 18
6 Sagamihara Sagamihara 11 10 8 17
7 Ryūkyū Ryūkyū 10 16 14 16
8 Zweigen Kanazawa Zweigen 10 20 20 14
9 Parceiro Nagano Parceiro 11 19 19 14
10 Kataller Toyama Kataller 10 8 8 14
11 Gainare Tottori Gainare 10 9 11 13
12 Matsumoto Yamaga Matsumoto 10 12 16 13
13 Giravanz Kitakyushu Giravanz 11 8 9 11
14 YSCC YSCC 11 9 14 10
15 Nara Club Nara Club 11 13 17 9
16 Tegevajaro Miyazaki Tegevajaro 11 11 17 9
17 Grulla Morioka Grulla 10 9 16 9
18 Fukushima United Fukushima 10 8 14 8
19 Vanraure Hachinohe Vanraure 10 5 11 7
20 Kamatamare Sanuki Kamatamare 10 10 15 6
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
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Iwaki FC Iwaki FC 34 72 23 76
2 Fujieda MYFC Fujieda MYFC 34 58 29 67
3 Kagoshima United Kagoshima 34 55 39 66
4 Matsumoto Yamaga Matsumoto 34 46 33 66
5 Imabari Imabari 34 55 40 60
6 Kataller Toyama Kataller 34 55 48 60
7 Ehime Ehime 34 51 41 52
8 Parceiro Nagano Parceiro 34 42 41 52
9 Tegevajaro Miyazaki Tegevajaro 34 45 47 46
10 Vanraure Hachinohe Vanraure 34 32 46 43
11 Fukushima United Fukushima 34 37 45 42
12 Gainare Tottori Gainare 34 55 56 41
13 Giravanz Kitakyushu Giravanz 34 41 45 40
14 Gifu Gifu 34 43 53 37
15 Azul Claro Numazu Azul Claro. 34 27 46 31
16 YSCC YSCC 34 25 66 28
17 Kamatamare Sanuki Kamatamare 34 27 49 27
18 Sagamihara Sagamihara 34 31 50 25
TEMPORADA 2020/2021
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 Júbilo Iwata Júbilo 42 75 42 91
2 Kyoto Sanga Kyoto Sanga 42 59 31 84
3 Ventforet Kofu Ventforet 42 65 38 80
4 V-Varen Nagasaki V-Varen 42 69 44 78
5 Machida Zelvia Machida 42 64 38 72
6 Albirex Niigata Albirex 42 61 40 68
7 Montedio Yamagata Montedio 42 61 49 68
8 JEF United JEF United 42 48 36 66
9 Ryūkyū Ryūkyū 42 57 47 65
10 Mito Hollyhock Mito 42 59 50 59
11 Fagiano Okayama Fagiano 42 40 36 59
12 Tokyo Verdy Tokyo Verdy 42 62 66 58
13 Blaublitz Akita Blaublitz 42 41 53 47
14 Tochigi Tochigi 42 37 51 45
15 Renofa Yamaguchi Renofa 42 37 51 43
16 Omiya Ardija Omiya Ardija 42 51 56 42
17 Zweigen Kanazawa Zweigen 42 39 60 41
18 Thespa Gunma Thespa Gunma 42 35 56 41
19 Sagamihara Sagamihara 42 33 54 38
20 Ehime Ehime 42 38 67 35
21 Giravanz Kitakyushu Giravanz 42 35 66 35
22 Matsumoto Yamaga Matsumoto 42 36 71 34
TEMPORADA 2019/2020
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Blaublitz Akita Blaublitz 33 50 18 70
2 Sagamihara Sagamihara 34 43 35 61
3 Parceiro Nagano Parceiro 34 45 26 59
4 Kagoshima United Kagoshima 34 55 43 58
5 Gainare Tottori Gainare 34 47 37 57
6 Imabari Imabari 34 39 27 55
7 Roasso Kumamoto Roasso 34 56 47 54
8 Gifu Gifu 32 48 34 53
9 Kataller Toyama Kataller 33 51 42 49
10 Fujieda MYFC Fujieda MYFC 34 48 44 49
11 Grulla Morioka Grulla 34 36 47 42
12 Azul Claro Numazu Azul Claro. 34 36 40 41
13 Fukushima United Fukushima 33 46 53 39
14 Gamba Osaka Sub 23 Gamba Osaka 34 43 55 35
15 Vanraure Hachinohe Vanraure 33 41 55 32
16 Kamatamare Sanuki Kamatamare 34 33 52 31
17 YSCC YSCC 34 37 66 27
18 Cerezo Osaka Sub 23 Cerezo Osaka 34 28 61 25
TEMPORADA 2018/2019
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Giravanz Kitakyushu Giravanz 34 51 27 66
2 Thespa Gunma Thespa Gunma 34 59 34 63
3 Fujieda MYFC Fujieda MYFC 34 42 31 63
4 Kataller Toyama Kataller 34 54 31 58
5 Roasso Kumamoto Roasso 34 45 39 57
6 Cerezo Osaka Sub 23 Cerezo Osaka 34 49 56 52
7 Blaublitz Akita Blaublitz 34 45 35 49
8 Vanraure Hachinohe Vanraure 34 49 42 48
9 Gainare Tottori Gainare 33 48 59 47
10 Parceiro Nagano Parceiro 33 32 34 46
11 Fukushima United Fukushima 33 45 51 43
12 Azul Claro Numazu Azul Claro. 34 35 43 39
13 YSCC YSCC 33 53 62 39
14 Kamatamare Sanuki Kamatamare 33 33 48 39
15 Sagamihara Sagamihara 34 36 45 38
16 Tokyo Sub 23 Tokyo 34 43 52 36
17 Gamba Osaka Sub 23 Gamba Osaka 34 54 55 35
18 Grulla Morioka Grulla 33 34 63 23
TEMPORADA 2017/2018
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Ryūkyū Ryūkyū 32 70 40 66
2 Kagoshima United Kagoshima 32 46 35 57
3 Gainare Tottori Gainare 32 61 47 53
4 Azul Claro Numazu Azul Claro. 32 40 29 52
5 Thespa Gunma Thespa Gunma 32 37 35 52
6 Gamba Osaka Sub 23 Gamba Osaka 32 53 43 47
7 Cerezo Osaka Sub 23 Cerezo Osaka 32 47 36 46
8 Blaublitz Akita Blaublitz 32 37 35 43
9 Sagamihara Sagamihara 32 42 53 42
10 Parceiro Nagano Parceiro 32 39 37 41
11 Kataller Toyama Kataller 32 41 50 41
12 Fukushima United Fukushima 32 36 43 40
13 Grulla Morioka Grulla 32 41 56 40
14 Tokyo Sub 23 Tokyo 32 38 45 36
15 YSCC YSCC 32 40 48 34
16 Fujieda MYFC Fujieda MYFC 32 32 48 34
17 Giravanz Kitakyushu Giravanz 32 22 42 27
TEMPORADA 2016/2017
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Blaublitz Akita Blaublitz 32 53 31 61
2 Tochigi Tochigi 32 44 24 60
3 Azul Claro Numazu Azul Claro. 32 60 27 59
4 Kagoshima United Kagoshima 32 49 37 55
5 Parceiro Nagano Parceiro 32 34 25 50
6 Ryūkyū Ryūkyū 32 44 36 50
7 Fujieda MYFC Fujieda MYFC 32 50 43 47
8 Kataller Toyama Kataller 32 37 33 47
9 Giravanz Kitakyushu Giravanz 32 44 37 46
10 Fukushima United Fukushima 32 39 43 43
11 Tokyo Sub 23 Tokyo 32 36 47 43
12 Sagamihara Sagamihara 32 34 41 39
13 Cerezo Osaka Sub 23 Cerezo Osaka 32 39 43 35
14 YSCC YSCC 32 41 54 32
15 Grulla Morioka Grulla 32 32 49 29
16 Gamba Osaka Sub 23 Gamba Osaka 32 31 65 26
17 Gainare Tottori Gainare 32 31 63 21
TEMPORADA 2015/2016
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Oita Trinita Oita Trinita 30 50 24 61
2 Tochigi Tochigi 30 38 20 59
3 Parceiro Nagano Parceiro 30 33 22 52
4 Blaublitz Akita Blaublitz 30 37 26 50
5 Kagoshima United Kagoshima 30 39 29 50
6 Kataller Toyama Kataller 30 37 29 49
7 Fujieda MYFC Fujieda MYFC 30 48 42 45
8 Ryūkyū Ryūkyū 30 46 46 44
9 Gamba Osaka Sub 23 Gamba Osaka 30 42 41 38
10 Tokyo Sub 23 Tokyo 30 32 31 36
11 Sagamihara Sagamihara 30 29 46 35
12 Cerezo Osaka Sub 23 Cerezo Osaka 30 38 47 32
13 Grulla Morioka Grulla 30 43 47 30
14 Fukushima United Fukushima 30 35 44 30
15 Gainare Tottori Gainare 30 30 47 30
16 YSCC YSCC 30 15 51 20
TEMPORADA 2014/2015
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Renofa Yamaguchi Renofa 36 96 36 78
2 Machida Zelvia Machida 36 52 18 78
3 Parceiro Nagano Parceiro 36 46 28 70
4 Sagamihara Sagamihara 36 59 51 58
5 Kataller Toyama Kataller 36 37 36 52
6 Gainare Tottori Gainare 36 47 41 50
7 Fukushima United Fukushima 36 42 48 49
8 Blaublitz Akita Blaublitz 36 37 40 45
9 Ryūkyū Ryūkyū 36 45 51 45
10 Fujieda MYFC Fujieda MYFC 36 37 61 37
11 Grulla Morioka Grulla 36 36 47 35
12 J League Sub 22 League 36 28 71 28
13 YSCC YSCC 36 24 58 27
TEMPORADA 2013/2014
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Zweigen Kanazawa Zweigen 33 56 20 75
2 Parceiro Nagano Parceiro 33 58 23 69
3 Machida Zelvia Machida 33 59 22 68
4 Gainare Tottori Gainare 33 34 25 53
5 Grulla Morioka Grulla 33 43 39 45
6 Sagamihara Sagamihara 33 44 48 43
7 Fukushima United Fukushima 33 30 38 36
8 Blaublitz Akita Blaublitz 33 38 57 34
9 Ryūkyū Ryūkyū 33 31 50 34
10 J League Sub 22 League 33 37 63 33
11 Fujieda MYFC Fujieda MYFC 33 36 52 30
12 YSCC YSCC 33 29 58 24
TEMPORADA 2012/2013
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Parceiro Nagano Parceiro 34 61 25 72
2 Kamatamare Sanuki Kamatamare 34 49 27 68
3 Sagamihara Sagamihara 34 58 42 61
4 Machida Zelvia Machida 34 51 44 61
5 Honda Honda 34 54 38 53
6 Sagawa Printing Sagawa 34 36 25 53
7 Zweigen Kanazawa Zweigen 34 60 48 50
8 Blaublitz Akita Blaublitz 34 48 45 50
9 Sony Sendai Sony Sendai 34 33 34 50
10 Yokogawa Musashino Yokogawa 34 36 36 49
11 Ryūkyū Ryūkyū 34 47 51 46
12 YSCC YSCC 34 45 56 39
13 Fujieda MYFC Fujieda MYFC 34 40 58 36
14 Fukushima United Fukushima 34 35 42 34
15 Hoyo Oita Hoyo Oita 34 32 45 32
16 MIO Biwako Kusatsu Biwako 34 40 56 30
17 Tochigi Uva Tochigi Uva 34 34 66 30
18 Minebea Mitsumi Minebea 34 26 47 29

  USO DE MEMORIA  
6,706,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1342
Total Execution Time  0.1356
  CADENA URL  
/historico/Sagamihara
  GET DATOS  
$_GET['/historico/Sagamihara']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0029  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 = 'Sagamihara' 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.0018  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=11633 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=11633 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=11633 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11633 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=515 AND type_rel = 3
0.0032  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.0021  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.0025  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 = '11633' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '11633' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '11633' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 74985 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=11633 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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,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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74985 AND teamId = 11633
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75185 AND teamId = 11633
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71686 AND teamId = 11633
0.0026  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 = 74985 AND t.round = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '11633' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11633' and rp.type = 4
0.0020  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 = '11633' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028  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 = 11633 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.0026  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 = 11633 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 11633 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 11633 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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.0024  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 = 66262 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.0025  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 = 61092 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 55385 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.0022  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 = 42574 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 37773 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 9482 AND t.round = 39 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 9486 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 2332 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC