4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Honda
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 - 1ª FASE
Equipo PJ GF GC Puntos
1 Honda Honda 15 39 11 36
2 Sony Sendai Sony Sendai 15 36 15 36
3 Osaka Osaka 15 27 14 30
4 Reinmeer Aomori Reinmeer 15 17 10 30
5 Vanraure Hachinohe Vanraure 15 23 18 24
6 Imabari Imabari 15 16 15 22
7 Yokogawa Musashino Yokogawa 15 26 19 20
8 Ryutsu Keizai Dragons Ryutsu 15 15 20 20
9 Veertien Kuwana Veertien 15 22 21 19
10 Minebea Mitsumi Minebea 15 15 23 16
11 Nara Club Nara Club 15 18 29 14
12 Reilac Shiga Reilac Shiga 15 17 25 13
13 Maruyasu Industries Maruyasu 15 16 24 13
14 Verspah Oita Verspah Oita 15 12 23 12
15 Tochigi Uva Tochigi Uva 15 15 30 10
16 Urayasu Urayasu 15 10 27 9
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 - 1ª 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
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
TEMPORADA 2010/2011
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Sagawa Shiga Sagawa Shiga 33 60 34 70
2 Parceiro Nagano Parceiro 33 51 27 63
3 Machida Zelvia Machida 33 61 28 61
4 Matsumoto Yamaga Matsumoto 33 60 38 59
5 V-Varen Nagasaki V-Varen 33 61 44 56
6 Honda Honda 33 40 36 52
7 Zweigen Kanazawa Zweigen 33 49 40 47
8 Minebea Mitsumi Minebea 33 47 45 47
9 Ryūkyū Ryūkyū 33 47 51 46
10 Tochigi Uva Tochigi Uva 33 40 43 45
11 Kamatamare Sanuki Kamatamare 33 39 49 40
12 Sagawa Printing Sagawa 33 43 61 38
13 Reilac Shiga Reilac Shiga 33 43 65 38
14 Blaublitz Akita Blaublitz 33 38 52 37
15 Yokogawa Musashino Yokogawa 33 33 37 36
16 Arte Takasaki Arte 33 39 55 34
17 JEF United II United 33 27 63 19
18 Sony Sendai Sony Sendai 17 14 24 16
TEMPORADA 2009/2010
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Gainare Tottori Gainare 34 64 31 77
2 Sagawa Shiga Sagawa Shiga 34 69 35 62
3 Machida Zelvia Machida 34 71 44 61
4 Honda Honda 34 52 43 59
5 V-Varen Nagasaki V-Varen 34 50 38 53
6 Sagawa Printing Sagawa 34 54 46 53
7 Matsumoto Yamaga Matsumoto 34 48 41 52
8 Blaublitz Akita Blaublitz 34 54 41 51
9 Zweigen Kanazawa Zweigen 34 46 41 50
10 Ryūkyū Ryūkyū 34 51 51 48
11 Reilac Shiga Reilac Shiga 34 51 56 46
12 Yokogawa Musashino Yokogawa 34 34 38 44
13 Minebea Mitsumi Minebea 34 36 39 42
14 Sony Sendai Sony Sendai 34 34 42 42
15 Tochigi Uva Tochigi Uva 34 41 75 31
16 JEF United II United 34 31 55 30
17 Arte Takasaki Arte 34 28 51 29
18 Ryutsu Keizai University Ryutsu 34 33 80 19
TEMPORADA 2008/2009
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Sagawa Shiga Sagawa Shiga 34 62 36 66
2 Yokogawa Musashino Yokogawa 34 48 34 60
3 Sony Sendai Sony Sendai 34 49 30 59
4 Giravanz Kitakyushu Giravanz 34 49 31 58
5 Gainare Tottori Gainare 34 65 37 56
6 Machida Zelvia Machida 34 38 30 54
7 Honda Honda 34 49 38 51
8 Reilac Shiga Reilac Shiga 34 51 43 48
9 Sagawa Printing Sagawa 34 56 46 47
10 Blaublitz Akita Blaublitz 34 39 54 46
11 V-Varen Nagasaki V-Varen 34 38 43 44
12 JEF United II United 34 26 37 41
13 Minebea Mitsumi Minebea 34 34 38 40
14 Arte Takasaki Arte 34 34 46 40
15 Ryutsu Keizai University Ryutsu 34 41 55 40
16 Ryūkyū Ryūkyū 34 42 57 38
17 FC Kariya FC Kariya 34 26 51 31
18 Mizushima Mizushima 34 28 69 18
TEMPORADA 2007/2008
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Honda Honda 34 77 33 69
2 Tochigi Tochigi 34 64 36 65
3 Kataller Toyama Kataller 34 56 34 60
4 Yokogawa Musashino Yokogawa 34 46 31 60
5 Fagiano Okayama Fagiano 34 59 43 57
6 Gainare Tottori Gainare 34 56 41 56
7 Ryutsu Keizai University Ryutsu 34 53 47 55
8 Sagawa Printing Sagawa 34 43 39 53
9 Sony Sendai Sony Sendai 34 53 41 50
10 Giravanz Kitakyushu Giravanz 34 48 47 49
11 FC Kariya FC Kariya 34 43 39 48
12 Sagawa Shiga Sagawa Shiga 34 52 46 47
13 Blaublitz Akita Blaublitz 34 47 46 41
14 Reilac Shiga Reilac Shiga 34 39 61 38
15 Ryūkyū Ryūkyū 34 31 53 29
16 JEF United II United 34 30 53 28
17 Arte Takasaki Arte 34 38 102 18
18 Mizushima Mizushima 34 29 72 17
TEMPORADA 2006/2007
LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo PJ GF GC Puntos
1 Sagawa Shiga Sagawa Shiga 34 81 31 83
2 Roasso Kumamoto Roasso 34 65 34 69
3 Gifu Gifu 34 45 31 60
4 Honda Honda 34 61 42 58
5 Hokuriku FC Hokuriku FC 33 47 35 56
6 YKK AP YKK AP 34 60 52 55
7 Yokogawa Musashino Yokogawa 34 50 44 54
8 Tochigi Tochigi 34 43 29 52
9 JEF United II United 34 50 45 52
10 Ryutsu Keizai University Ryutsu 34 58 49 50
11 Sony Sendai Sony Sendai 34 46 59 44
12 Sagawa Printing Sagawa 33 45 54 43
13 Blaublitz Akita Blaublitz 34 49 47 42
14 Gainare Tottori Gainare 34 40 51 38
15 Mizushima Mizushima 34 36 53 35
16 FC Kariya FC Kariya 34 36 58 30
17 Ryūkyū Ryūkyū 34 38 82 27
18 Arte Takasaki Arte 34 17 71 7

  USO DE MEMORIA  
6,953,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1457
Total Execution Time  0.1470
  CADENA URL  
/historico/Honda/2021
  GET DATOS  
$_GET['/historico/Honda/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
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 = 'Honda' AND l.year = 2021 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=7415 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=7415 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=7415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 61094
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7415 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=233 AND type_rel = 3
0.0019  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.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 (1210510,1085447,1000011,822371,638010) 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 = '7415' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '7415' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '7415' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 61094 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=7415 AND l.year in (2020,2021,2022) 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 (67535,66708) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 66708 AND teamId = 7415
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 67535 AND teamId = 7415
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 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 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 = '7415' 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 = '7415' 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 = '7415' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 events2021 e ON e.player_id = p.id AND e.league_id = 61094 WHERE rp.league_id = 61094 AND rp.teamId = 7415 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.0020  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 events2021 e ON e.player_id = p.id AND e.league_id = 61094 WHERE rp.league_id = 61094 AND rp.teamId = 7415 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2021 e ON e.player_id = p.id AND e.league_id = 61094 WHERE rp.league_id = 61094 AND rp.teamId = 7415 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 7415 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 = 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.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 = 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.0021  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.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 `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.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 `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.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 = 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.0021  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.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 `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.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 `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.0021  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
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 `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.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 `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
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 `tables2011` 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 = 49989 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 `tables2010` 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 = 49990 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 `tables2009` 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 = 49991 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 `tables2008` 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 = 49992 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2007` 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 = 49993 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 61094 ORDER BY nameShow LIMIT 100