11 Jun 15	Finalizado	Japón	4 - 0	Iraq	44
31 Mar 15	Finalizado	Japón	5 - 1	Uzbekistán	130
27 Mar 15	Finalizado	Japón	2 - 0	Túnez	65
18 Nov 14	Finalizado	Japón	2 - 1	Australia	42
14 Nov 14	Finalizado	Japón	6 - 0	Honduras	19
14 Oct 14	Finalizado	Japón	0 - 4	Brasil	41
10 Oct 14	Finalizado	Japón	1 - 0	Jamaica	4
09 Sep 14	Finalizado	Japón	2 - 2	Venezuela	54
05 Sep 14	Finalizado	Japón	0 - 2	Uruguay	37

Clasificación Mundial Asia »

05 Sep 17	Finalizado	Arabia Saudí	1 - 0	Japón	79
31 Ago 17	Finalizado	Japón	2 - 0	Australia	93
13 Jun 17	Finalizado	Iraq	1 - 1	Japón	65
28 Mar 17	Finalizado	Japón	4 - 0	Tailandia	31
23 Mar 17	Finalizado	Emiratos Árabes	0 - 2	Japón	43
15 Nov 16	Finalizado	Japón	2 - 1	Arabia Saudí	84
11 Oct 16	Finalizado	Australia	1 - 1	Japón	99
06 Oct 16	Finalizado	Japón	2 - 1	Iraq	137
06 Sep 16	Finalizado	Tailandia	0 - 2	Japón	19
01 Sep 16	Finalizado	Japón	1 - 2	Emiratos Árabes	52
29 Mar 16	Finalizado	Japón	5 - 0	Siria	37
24 Mar 16	Finalizado	Japón	5 - 0	Afganistán	10
17 Nov 15	Finalizado	Camboya	0 - 2	Japón	24
12 Nov 15	Finalizado	Singapur	0 - 3	Japón	43
08 Oct 15	Finalizado	Siria	0 - 3	Japón	27
08 Sep 15	Finalizado	Afganistán	0 - 6	Japón	32
03 Sep 15	Finalizado	Japón	3 - 0	Camboya	27
16 Jun 15	Finalizado	Japón	0 - 0	Singapur	27

Copa Asia »

23 Ene 15	Finalizado	Japón	1 - 1	Emiratos Árabes	227
20 Ene 15	Finalizado	Japón	2 - 0	Jordania	46
16 Ene 15	Finalizado	Iraq	0 - 1	Japón	108
12 Ene 15	Finalizado	Japón	4 - 0	Palestina	59

Copa del Este de Asia »

09 Ago 15	Finalizado	China	1 - 1	Japón	1
05 Ago 15	Finalizado	Japón	1 - 1	Corea del Sur	15
02 Ago 15	Finalizado	Corea del Norte	2 - 1	Japón	1

Estadísticas

GOLEADORES

AMARILLAS

Plantilla del Japón Temporada 2014/2015

		Edad	Altura	Peso
Portero
23	A. Hayashi	36	195	82	-	-	-
1	E. Kawashima	41	185	74	-	-	-
23	M. Higashiguchi	37	184	78	-	-	-
23	S. Gonda	35	187	85	-	-	-
12	S. Nishikawa	37	183	81	-	-	-
Defensa
2	A. Uchida	36	176	62	-	-	-
20	D. Nishi	36	176	70	-	-	-
15	D. Niwa	38	180	76	-	-	-
15	D. Suzuki	34	182	76	-	-	-
3	G. Sakai	33	176	74	-	-	-
18	Gen Shoji	31	182	74	-	-	-
27	H. Fujiharu	35	175	60	-	-	-
2	H. Mizumoto	38	183	70	-	-	1
21	H. Sakai	34	185	70	-	-	-
	H. Taniguchi	38	182	73	-	-	-
16	K. Matsubara	31	180	70	-	-	-
21	K. Ota	36	179	77	-	-	-
	M. Inoha	38	179	72	-	-	-
6	M. Morishige	36	183	72	-	-	1
22	M. Yoshida	35	189	78	1	-	-
17	Makoto Hasebe	40	180	72	-	-	-
2	S. Taniguchi	32	183	70	-	-	-
20	T. Makino	36	182	77	1	-	-
15	T. Sakai	33	183	71	-	-	-
16	T. Shiotani	35	182	80	-	-	-
5	Y. Nagatomo	37	170	68	-	-	-
Centrocampista
8	G. Haraguchi	32	178	68	1	-	-
7	G. Shibasaki	31	174	62	2	-	-
13	H. Hosogai	37	177	69	-	-	-
13	H. Kiyotake	34	172	66	-	-	-
16	H. Yamaguchi	33	174	72	-	-	-
4	K. Honda	37	182	74	3	-	-
	M. Saito	34	169	68	-	-	-
10	R. Morioka	33	183	70	-	-	-
10	S. Kagawa	35	175	68	-	-	-
28	T. Aoyama	38	173	75	1	-	-
20	T. Ogihara	32	185	61	-	-	-
22	T. Taguchi	33	176	65	-	-	-
7	Y. Endo	44	178	73	1	-	1
11	Y. Kakitani	34	176	68	-	-	-
	Y. Kobayashi	29	171	60	-	-	-
15	Y. Konno	41	178	73	1	-	-
	Y. Muto	35	170	68	-	-	-
Delantero
8	J. Tanaka	36	181	77	-	-	-
20	K. Kawamata	34	184	76	1	-	-
26	K. Nagai	35	177	70	-	-	-
18	M. Havenaar	36	194	81	-	-	-
9	S. Okazaki	38	175	70	4	-	-
8	T. Inui	35	169	63	2	-	-
11	T. Usami	31	178	72	1	-	-
19	Y. Kobayashi	36	178	70	-	-	-
19	Y. Minagawa	32	186	84	-	-	-
14	Y. Muto	31	179	72	1	-	-
	Y. Okubo	41	170	73	-	-	-
18	Y. Osako	33	184	71	-	-	-
11	Y. Toyoda	39	185	79	1	-	1

Noticias del Japón

Ver últimas noticias

Un golazo de falta ensayado al milímetro

Fran Alameda - Jueves, 14 Enero 2016

0 1.820

El fútbol es un mundo lleno de sorpresas y la imaginación de muchos a la hora de ensayar jugadas no conoce límites.

Japón, Australia, Irán y Corea del Sur, cada vez más cerca del Mundial

BeSoccer - Jueves, 12 Noviembre 2015

1 337

Las selecciones de Japón, Australia, Irán y Corea del Sur ganaron sus respectivos compromisos ante Singapur, Kirguistán, Turkmenistán y Birmania, y se acercaron a la tercera fase de clasificación en la zona asiática para el Mundial de Rusia 2018.

Suzuki, defensa internacional japonés, confirma que el Rayo le ha hecho una oferta

BeSoccer - Martes, 10 Noviembre 2015

1 1.257

El defensa internacional nipón Daisuke Suzuki, que milita en el Kashiwa Reysol de la primera división japonesa, confirmó hoy que ha recibido una oferta del Rayo Vallecano, y se mostró dispuesto a marcharse a la liga española.

Vergonzosa derrota de Australia ante Jordania, mientras Japón y Corea no fallan

BeSoccer - Jueves, 08 Octubre 2015

0 338

Australia, campeona de Asia, sucumbió hoy en Amman ante Jordania (2-0), en partido de la segunda ronda de la fase de clasificación para el Mundial de Rusia 2018, mientras que otras dos potencias como Japón y Corea del Sur no fallaron en sus visitas a Siria (0-3) y Kuwait (0-1), respectivamente.

El Mundial de leyendas, en el 2017

Isabel Ruiz - Miércoles, 07 Octubre 2015

1 2.625

El Mundial de Leyendas estará compuesto por 12 equipos, todos invitados, y ya está más cerca de ser una realidad. El torneo fue representado el martes en Berlín.

Ver más noticias del equipo»

Comparar equipos

Japón

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa Asia

RIVALES EN Copa del Este de.

RIVALES EN Clasificación Mu.

USO DE MEMORIA

6,458,656 bytes

BENCHMARKS

Loading Time Base Classes	0.0022
Controller Execution Time ( Home / Category )	0.6727
Total Execution Time	0.6750

CADENA URL

/Seleccion-Japon/2015

GET DATOS

$_GET['/Seleccion-Japon/2015']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0128	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 = 'Seleccion-Japon' AND l.year = 2015 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.0106	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=3798 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=3798 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=3798 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=3798 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=3798 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=3798 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=3798 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112	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 = 4262
0.0112	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 = 12805
0.0112	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 = 23850
0.0111	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 = 7935
0.0114	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 = 9341
0.0113	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 = 12317
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3798 AND type_rel = 2
0.0111	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3798 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108	SELECT /35 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 (15994,16216,21710,22136,34140) ORDER BY n.cover_points DESC, update_date DESC
0.0137	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 = '3798' AND l.year = 2015 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 = '3798' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107	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 = 7935 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107	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 = 12317 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106	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 = 12805 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2015 as c ON c.league_id = l.id WHERE (c.datateam1 = 3798 or c.datateam2 = 3798) AND l.year = 2015 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0115	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2015 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 3798 or c.datateam2 = 3798) AND l.year = 2015 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0111	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2015 as c ON c.league_id = l.id INNER JOIN events2015 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 3798 or c.datateam2 = 3798) AND l.year = 2015)
0.0123	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=3798 AND l.year in (2014,2015,2016) ORDER BY l.id DESC, l.year DESC ;
0.0106	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 (30674,23850,16586,12317,9341,3384) 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.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 3384 AND teamId = 3798
0.0111	SELECT count(id) as num_players from rel_players WHERE league_id = 23850 AND teamId = 3798
0.0112	SELECT count(id) as num_players from rel_players WHERE league_id = 9341 AND teamId = 3798
0.0106	SELECT count(id) as num_players from rel_players WHERE league_id = 12317 AND teamId = 3798
0.0110	SELECT count(id) as num_players from rel_players WHERE league_id = 30674 AND teamId = 3798
0.0119	SELECT count(id) as num_players from rel_players WHERE league_id = 16586 AND teamId = 3798
0.0106	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 4262 AND t.round = 154 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0150	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 events2015 e ON e.player_id = p.id AND e.league_id = 4262 WHERE rp.league_id = 4262 AND rp.teamId = 3798 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.0135	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 events2015 e ON e.player_id = p.id AND e.league_id = 4262 WHERE rp.league_id = 4262 AND rp.teamId = 3798 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115	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 events2015 e ON e.player_id = p.id AND e.league_id = 4262 WHERE rp.league_id = 4262 AND rp.teamId = 3798 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 3798 AND rp.league_id = 4262 AND l.year= 2015 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0113	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=77874 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0106	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=77874
0.0127	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=77874 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.0144	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=77874 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0113	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=77874 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0125	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=77874 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0142	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=77874 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0120	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 = 4262 ORDER BY nameShow LIMIT 100

Resultados de Fútbol

Japón

Información sobre Japón

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Amistosos Selecciones

Clasificación Mundial Asia Grupo 2

Copa Asia Grupo 0

Copa Kirin

Mundial Grupo 5

Copa del Este de Asia

Copa Confederaciones Grupo 1

Juegos Olímpicos Grupo 2

Clasificación Juegos Olímpicos Grupo 8

Partidos Amistosos

Clasificación Copa Asia Grupo 2

Copa de Naciones Afro-Asiáticas

Copa América Grupo 3

Trofeo Costa del Sol

Partidos del Japón

Estadísticas

Plantilla del Japón Temporada 2014/2015

Noticias del Japón

Un golazo de falta ensayado al milímetro

Japón, Australia, Irán y Corea del Sur, cada vez más cerca del Mundial

Suzuki, defensa internacional japonés, confirma que el Rayo le ha hecho una oferta

Vergonzosa derrota de Australia ante Jordania, mientras Japón y Corea no fallan

El Mundial de leyendas, en el 2017

Japón

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa Asia

RIVALES EN Copa del Este de.

RIVALES EN Clasificación Mu.


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos