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

Fujieda MYFC

Entrenador: Daisuke Sudo

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA JAPONESA J2
Equipo PJ GF GC Puntos
1 V-Varen Nagasaki V-Varen 12 25 11 27
2 Shimizu S-Pulse Shimizu 11 19 13 25
3 Fagiano Okayama Fagiano 11 14 7 22
4 Yokohama Yokohama 11 16 8 18
5 Ventforet Kofu Ventforet 12 20 15 18
6 Blaublitz Akita Blaublitz 11 12 8 18
7 Ehime Ehime 12 18 16 18
8 JEF United JEF United 12 25 15 17
9 Vegalta Sendai Vegalta 12 12 11 17
10 Iwaki FC Iwaki FC 11 20 10 16
11 Montedio Yamagata Montedio 11 12 12 16
12 Renofa Yamaguchi Renofa 11 14 9 15
13 Oita Trinita Oita Trinita 11 10 11 13
14 Roasso Kumamoto Roasso 11 15 23 12
15 Kagoshima United Kagoshima 11 12 20 12
16 Tochigi Tochigi 11 10 24 12
17 Mito Hollyhock Mito 12 10 13 11
18 Fujieda MYFC Fujieda MYFC 12 7 19 11
19 Tokushima Vortis Tokushima 11 9 21 8
20 Thespa Gunma Thespa Gunma 12 7 21 6
TEMPORADA 2022/2023
SEGUNDA JAPONESA J2 GRUPO 1
Equipo PJ GF GC Puntos
1 Machida Zelvia Machida 42 79 35 87
2 Júbilo Iwata Júbilo 42 74 44 75
3 Tokyo Verdy Tokyo Verdy 42 57 31 75
4 Shimizu S-Pulse Shimizu 42 78 34 74
5 Montedio Yamagata Montedio 42 64 54 67
6 JEF United JEF United 42 61 53 67
7 V-Varen Nagasaki V-Varen 42 70 56 65
8 Ventforet Kofu Ventforet 42 60 50 64
9 Oita Trinita Oita Trinita 42 54 56 62
10 Fagiano Okayama Fagiano 42 49 49 58
11 Thespa Gunma Thespa Gunma 42 44 44 57
12 Fujieda MYFC Fujieda MYFC 42 61 72 52
13 Blaublitz Akita Blaublitz 42 37 44 51
14 Roasso Kumamoto Roasso 42 52 53 49
15 Tokushima Vortis Tokushima 42 43 53 49
16 Vegalta Sendai Vegalta 42 48 61 48
17 Mito Hollyhock Mito 42 49 66 47
18 Iwaki FC Iwaki FC 42 45 69 47
19 Tochigi Tochigi 42 39 47 44
20 Renofa Yamaguchi Renofa 42 37 67 44
21 Omiya Ardija Omiya Ardija 42 37 71 39
22 Zweigen Kanazawa Zweigen 42 41 70 35
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
TERCERA JAPONESA J3
Equipo PJ GF GC Puntos
1 Roasso Kumamoto Roasso 28 39 20 54
2 Grulla Morioka Grulla 28 43 28 53
3 Tegevajaro Miyazaki Tegevajaro 28 44 31 53
4 Kataller Toyama Kataller 28 40 34 46
5 Fukushima United Fukushima 28 41 32 45
6 Gifu Gifu 28 38 35 41
7 Kagoshima United Kagoshima 28 34 35 40
8 YSCC YSCC 28 31 33 40
9 Parceiro Nagano Parceiro 28 35 28 36
10 Fujieda MYFC Fujieda MYFC 28 42 42 32
11 Imabari Imabari 28 34 33 30
12 Gainare Tottori Gainare 28 36 53 29
13 Vanraure Hachinohe Vanraure 28 24 44 29
14 Azul Claro Numazu Azul Claro. 28 32 44 27
15 Kamatamare Sanuki Kamatamare 28 20 41 21
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
TEMPORADA 2011/2012
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 V-Varen Nagasaki V-Varen 32 57 24 67
2 Parceiro Nagano Parceiro 32 57 34 58
3 Sagawa Shiga Sagawa Shiga 32 61 37 57
4 Kamatamare Sanuki Kamatamare 32 49 29 53
5 Honda Honda 32 55 39 53
6 YSCC YSCC 32 58 50 49
7 Sagawa Printing Sagawa 32 43 43 45
8 MIO Biwako Kusatsu Biwako 32 53 52 43
9 Ryūkyū Ryūkyū 32 58 62 43
10 Yokogawa Musashino Yokogawa 32 35 50 41
11 Fujieda MYFC Fujieda MYFC 32 39 48 40
12 Sony Sendai Sony Sendai 32 27 29 39
13 Blaublitz Akita Blaublitz 32 33 41 37
14 Zweigen Kanazawa Zweigen 32 33 41 36
15 Hoyo Oita Hoyo Oita 32 40 57 35
16 Minebea Mitsumi Minebea 32 28 56 28
17 Tochigi Uva Tochigi Uva 32 36 70 22

  USO DE MEMORIA  
6,957,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1496
Total Execution Time  0.1509
  CADENA URL  
/historico/Fujieda-Myfc
  GET DATOS  
$_GET['/historico/Fujieda-Myfc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0030  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 = 'Fujieda-Myfc' 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.0019  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=7420 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=7420 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=7420 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=7420 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 75725
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7420 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=181 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 181 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 (932464,840228,816492,812834,785136) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '7420' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '7420' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '7420' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 75185 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 75725 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 74984 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=7420 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 (75725,75185,74984) 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 = 74984 AND teamId = 7420
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75185 AND teamId = 7420
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75725 AND teamId = 7420
0.0021  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 = '7420' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7420' 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 = '7420' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 74984 WHERE rp.league_id = 74984 AND rp.teamId = 7420 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 = 74984 WHERE rp.league_id = 74984 AND rp.teamId = 7420 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 74984 WHERE rp.league_id = 74984 AND rp.teamId = 7420 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 = 7420 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74984 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.0039  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 = 70795 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.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 = 61093 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.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 `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.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 `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 = 48804 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0061  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.0051  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.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 `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 = 20272 AND t.round = 30 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.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 `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
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 `tables2012` 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 = 1732 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC