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

Osaka

Entrenador: Naoto Otake

Información

Partidos del Osaka

Ir al LIVESCORE
24 Ago 24  en 3 meses Gainare Tottori
12:00
Osaka 0
17 Ago 24  en 3 meses Imabari
12:00
Osaka 0
27 Jul 24  en 3 meses Osaka
11:00
Kamatamare Sanuki 0
20 Jul 24  en 2 meses Osaka
11:00
Omiya Ardija 0
14 Jul 24  en 2 meses Matsumoto Yamaga
11:00
Osaka 0
06 Jul 24  en 2 meses Osaka
11:00
Kataller Toyama 1
29 Jun 24  en 2 meses Osaka
10:00
Tegevajaro Miyazaki 0
23 Jun 24  en 1 mes Fukushima United
07:00
Osaka 1
16 Jun 24  Aplazado Osaka
-
Gainare Tottori 1
09 Jun 24  en 1 mes Kamatamare Sanuki
07:00
Osaka 0
02 Jun 24  en 1 mes Osaka
09:00
Nara Club 0
18 May 24  en 20 días Kataller Toyama
07:00
Osaka 0
06 May 24  en 8 días Osaka
06:00
Ryūkyū 1
03 May 24  en 5 días Sagamihara
07:00
Osaka 0
28 Abr 24  en 20 h Osaka
08:00
Azul Claro Numazu 0
14 Abr 24  Finalizado Grulla Morioka
0 - 1
Osaka 3
10 Abr 24  Finalizado Osaka
2 - 0
Vanraure Hachinohe 2
06 Abr 24  Finalizado Omiya Ardija
1 - 0
Osaka 1
30 Mar 24  Finalizado Osaka
0 - 0
Imabari 0
23 Mar 24  Finalizado Tarjeta RojaOsaka
0 - 0
Matsumoto YamagaTarjeta Roja 5
20 Mar 24  Finalizado Giravanz Kitakyushu
0 - 0
Osaka 1
16 Mar 24  Finalizado Osaka
0 - 0
Gifu 1
09 Mar 24  Finalizado Zweigen Kanazawa
2 - 6
Osaka 0
03 Mar 24  Finalizado YSCC
0 - 2
Osaka 0
25 Feb 24  Finalizado Osaka
2 - 1
Parceiro Nagano 8

Plantilla del Osaka Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
31 25 jp 181 82 - - -
1 28 jp 185 85 - - -
Defensa
4 24 jp 181 75 - - 1
22 22 jp 183 74 - - -
2 26 jp 173 68 - - 1
3 29 jp 180 75 2 - -
23 jp 173 - - - -
6 30 jp 175 68 1 - 1
5 31 jp 183 78 - - -
23 29 jp 185 84 2 1 2
32 24 jp 170 68 - - 1
Centrocampista
20 23 jp 168 60 - - -
34 24 jp 178 71 - - -
14 31 jp 181 77 2 - -
10 27 jp 166 60 - - 1
19 25 jp 172 69 - - -
7 31 jp 177 73 - - 2
33 31 kr 175 74 - - 1
24 jp 175 70 - - -
22 jp 178 70 - - -
16 26 jp 170 68 1 - 1
Delantero
13 28 jp 175 77 1 - -
28 22 jp - - - - -
24 33 jp 174 71 - - -
43 22 jp 178 - - - 1
27 21 jp - - - - -
11 31 jp 176 72 1 - -
25 26 jp 181 74 - - 1
9 27 jp 175 69 1 - 3

Noticias de Tercera Japonesa J3

Ver últimas noticias

Japón, de luto: muere el ex internacional Masato Kudo con solo 32 años

El ex internacional japonés Masato Kudo, que también jugó en el Vancouver Whitecaps canadiense y el Brisbane Roar australiano, murió a los 32 años debido a una hidrocefalia, anunció este sábado el club japonés en el que jugaba actualmente, el Tegevajaro Miyazaki.

OFICIAL: la Liga Japonesa retorna el 4 de julio

Otra competición ya sabe que echará a andar de nuevo. La J-League, primera categoría nipona, volverá el 4 de julio. La segunda y la tercera lo harán una semana antes.

Otro receso para Iniesta: la J-League se retrasa al menos hasta mayo

Japón todavía no se siente preparada para la reanudación de su fútbol. Andrés Iniesta tendrá que aguardar al menos hasta el 9 de mayo para seguir jugando, según informó el presidente de la J-League.

El Alavés colaborará con el Kagoshima United

El Deportivo Alavés y el Kagoshima United han alcanzado un acuerdo para que el conjunto albiazul despliegue su proyecto de gestión en el club asiático.

No pudo convencer al Real Madrid y ahora llega a la Tercera Japonesa

El Kagoshima United dará cobijo al internacional macedonio Dorian Babunski, ex de las categorías inferiores del Real Madrid.




  USO DE MEMORIA  
5,631,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0948
Total Execution Time  0.0967
  CADENA URL  
/Osaka
  GET DATOS  
$_GET['/Osaka']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0017  SELECT type FROM routes WHERE alias = 'osaka'
0.0043  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 = 74985
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62300 AND type_rel = 2
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 = '62300' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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.0024  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=62300 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,71432) 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 = 62300
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75185 AND teamId = 62300
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 62300
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 = '62300' 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 = '62300' and rp.type = 4
0.0021  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 = '62300' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 62300 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.0027  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 = 62300 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 = 62300 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 62300 AND rp.league_id = 74985 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0038  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6625192 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6625192
0.0026  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6625192 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0024  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6625192 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0021  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6625192 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0024   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6625192 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0030  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6625192 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC