4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kochi United
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 TIAMO Hirakata TIAMO 7 12 10 13
4 Okinawa SV Okinawa SV 7 14 10 12
5 Tochigi City Tochigi City 7 13 11 12
6 Reilac Shiga Reilac Shiga 7 8 7 10
7 Suzuka Point Getters Suzuka Point 7 9 9 10
8 Sony Sendai Sony Sendai 7 8 8 10
9 Honda Honda 7 6 4 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

  USO DE MEMORIA  
5,246,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4699
Total Execution Time  0.4711
  CADENA URL  
/historico/Kochi-United-Sc
  GET DATOS  
$_GET['/historico/Kochi-United-Sc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0135  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 = 'Kochi-United-Sc' 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.0125  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=92411 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=92411 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0251  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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92411 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=233 AND type_rel = 3
0.0126  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.0127  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.0128  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 = '92411' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '92411' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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.0130  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=92411 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 75435 AND teamId = 92411
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71686 AND teamId = 92411
0.0128  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 = 75435 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '92411' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '92411' and rp.type = 4
0.0126  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 = '92411' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  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 = 92411 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.0136  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 = 92411 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 92411 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 92411 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0144  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 = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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.0145  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.0131  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.0131  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