4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Kariya
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 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  
5,400,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0711
Total Execution Time  0.0724
  CADENA URL  
/historico/Fc-Kariya
  GET DATOS  
$_GET['/historico/Fc-Kariya']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=110528 AND type_rel = 2
0.0020  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 = '110528' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = '110528' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=110528 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (62618,61094) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 61094 AND teamId = 110528
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 62618 AND teamId = 110528
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 = '110528' 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 = '110528' and rp.type = 4
0.0022  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 = '110528' 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 = 110528 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 = 110528 AND (e.action = 4 or e.action = 5) 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 = 110528 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 110528 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029  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.0037  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.0041  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.0043  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