Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

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

Bayern München

Entrenador: Thomas Tuchel

Temporada 2002/2003

Información sobre Bayern München

Enviar Datos

Información

Nombre del equipo Bayern München
Nombre completo Fußball-Club Bayern München e.V
Nombre corto BYM
País Alemania
Ciudad München
Entrenador Thomas Tuchel
URL del equipo en RF //m.resultados-futbol.com/Bayern-Munchen

Otros Datos

Año de Fundación 1900
Patrocinador Deutsche Telekom
Marca de Ropa Adidas
Socios 54000

Internet

Sitio Web www.fcbayern.de/
Correo electrónico webmaster@fcbayern.de
Twitter principal @FCBayern

Información sobre el estadio

Nombre del estadio Allianz Arena
Capacidad 75000
Dirección Werner-Heisenberg-Allee 25
Teléfono +49 (89) 699 310
Fax +49 (89) 644 165
Año de construcción 2001
Tamaño 105x68 metros

Histórico de participación

Champions League Grupo 1

69 veces

(2024, 2024, 2023, 2023, 2022, 2022, 2021, 2021, 2020, 2020, 2019, 2019, 2018, 2018, 2017, 2017, 2016, 2016, 2015, 2015, 2014, 2014, 2013, 2013, 2012, 2012, 2011, 2011, 2010, 2010, 2009, 2009, 2007, 2007, 2006, 2006, 2005, 2005, 2004, 2004, 2003, 2002, 2002, 2002, 2001, 2001, 2001, 2000, 2000, 2000, 1999, 1999, 1998, 1998, 1995, 1995, 1991, 1990, 1988, 1987, 1986, 1982, 1981, 1977, 1976, 1975, 1974, 1973, 1970)

DFB Pokal

62 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1957, 1956, 1943)

Supercopa de Alemania

18 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2011, 1995, 1991, 1990, 1988, 1983)

Partidos Amistosos

17 veces

(2025, 2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2009, 2008)

Oberliga Grupo 4

17 veces

(1963, 1962, 1961, 1960, 1959, 1958, 1957, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1946)

Liga Pokal

12 veces

(2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1973)

Europa League Grupo 0

10 veces

(2008, 2008, 1997, 1996, 1994, 1992, 1989, 1984, 1980, 1978)

Copa Audi

6 veces

(2019, 2017, 2015, 2013, 2011, 2009)

Copa Telekom

6 veces

(2019, 2017, 2017, 2015, 2014, 2013)

Fase Previa Champions League Grupo 4

3 veces

(2012, 2003, 1999)

Partidos del Bayern München

Ir al LIVESCORE

Champions League »

13 Nov 02	Finalizado	Bayern München	3 - 3	Lens	0
29 Oct 02	Finalizado	RC Deportivo	2 - 1	Bayern München	2
23 Oct 02	Finalizado	Milan	2 - 1	Bayern München	0
01 Oct 02	Finalizado	Bayern München	1 - 2	Milan	0
24 Sep 02	Finalizado	Lens	1 - 1	Bayern München	0
18 Sep 02	Finalizado	Bayern München	2 - 3	RC Deportivo	1

Bundesliga »

24 May 03	Finalizado	Schalke 04	1 - 0	Bayern München
17 May 03	Finalizado	Bayern München	2 - 1	Stuttgart
10 May 03	Finalizado	Hertha BSC	3 - 6	Bayern München
03 May 03	Finalizado	Bayern München	1 - 0	Kaiserslautern
26 Abr 03	Finalizado	Wolfsburg	0 - 2	Bayern München
19 Abr 03	Finalizado	B. Dortmund	1 - 0	Bayern München
12 Abr 03	Finalizado	Bayern München	0 - 1	Werder Bremen
05 Abr 03	Finalizado	Hannover 96	2 - 2	Bayern München
22 Mar 03	Finalizado	Bayern München	1 - 0	Hansa Rostock
15 Mar 03	Finalizado	VfL Bochum	1 - 4	Bayern München
08 Mar 03	Finalizado	Bayern München	3 - 0	B. Leverkusen
01 Mar 03	Finalizado	Energie Cottbus	0 - 2	Bayern München
22 Feb 03	Finalizado	Bayern München	2 - 0	Nürnberg
15 Feb 03	Finalizado	1860 München	0 - 5	Bayern München
09 Feb 03	Finalizado	Bayern München	1 - 1	Hamburger SV
01 Feb 03	Finalizado	Arminia Bielefeld	0 - 0	Bayern München
26 Ene 03	Finalizado	Bayern München	3 - 0	B. Mönchengladbach
14 Dic 02	Finalizado	Bayern München	0 - 0	Schalke 04
07 Dic 02	Finalizado	Stuttgart	0 - 3	Bayern München
30 Nov 02	Finalizado	Bayern München	2 - 0	Hertha BSC
23 Nov 02	Finalizado	Kaiserslautern	0 - 2	Bayern München
16 Nov 02	Finalizado	Bayern München	1 - 0	Wolfsburg
09 Nov 02	Finalizado	Bayern München	2 - 1	B. Dortmund
03 Nov 02	Finalizado	Werder Bremen	2 - 0	Bayern München
26 Oct 02	Finalizado	Bayern München	3 - 3	Hannover 96
19 Oct 02	Finalizado	Hansa Rostock	0 - 1	Bayern München
05 Oct 02	Finalizado	Bayern München	4 - 1	VfL Bochum
28 Sep 02	Finalizado	B. Leverkusen	2 - 1	Bayern München
21 Sep 02	Finalizado	Bayern München	3 - 1	Energie Cottbus
14 Sep 02	Finalizado	Nürnberg	1 - 2	Bayern München
10 Sep 02	Finalizado	Bayern München	3 - 1	1860 München
24 Ago 02	Finalizado	Hamburger SV	0 - 3	Bayern München
17 Ago 02	Finalizado	Bayern München	6 - 2	Arminia Bielefeld
10 Ago 02	Finalizado	B. Mönchengladbach	0 - 0	Bayern München

DFB Pokal »

31 May 03	Finalizado	Kaiserslautern	1 - 3	Bayern München	1
05 Mar 03	Finalizado	Bayern München	3 - 1	B. Leverkusen	0
04 Feb 03	Finalizado	Bayern München	8 - 0	Köln	2
04 Dic 02	Finalizado	Bayern München	0 - 0	Schalke 04	0
06 Nov 02	Finalizado	Bayern München	2 - 1	Hannover 96	0
31 Ago 02	Finalizado	Werder Bremen II	0 - 3	Bayern München	0

Fase Previa Champions League »

	27 Ago 02	Finalizado	Bayern München	3 - 1	Partizan Belgrade			0
	14 Ago 02	Finalizado	Partizan Belgrade	0 - 3	Bayern München			0

Liga Pokal »

25 Jul 02

Finalizado

Bayern München

2 - 2

Hertha BSC

Trofeo Santiago Bernabéu »

	04 Ago 02	Finalizado	Real Madrid	1 - 2	Bayern München			0
	03 Ago 02	Finalizado	Milan	1 - 2	Bayern München			0

Estadísticas

GOLEADORES

AMARILLAS

Plantilla del Bayern München Temporada 2002/2003

		Edad	Altura	Peso
Portero
1	O. Kahn	54	188	89	-	-	2
	Stefan Wessels	45	190	83	-	-	-
Defensa
3	B. Lizarazu	54	169	69	2	-	3
	M. Tarnat	54	185	77	-	-	1
5	R. Kovac	50	183	76	-	-	5
	S. Kuffour	47	178	71	1	-	-
25	Thomas Linke	54	183	79	-	-	4
2	W. Sagnol	47	180	76	2	-	3
Centrocampista
	B. Schweinsteiger	39	183	79	-	-	1
	H. Salihamidzic	47	176	71	2	-	2
16	J. Jeremies	50	178	76	-	-	6
13	M. Ballack	47	188	89	10	-	8
	M. Feulner	42	181	73	-	-	-
7	Mehmet Scholl	53	178	70	4	-	2
	N. Kovac	52	178	70	1	-	5
23	O. Hargreaves	43	180	74	1	-	-
	P. Thiam	50	185	77	2	-	3
	Piotr Trochowski	40	169	72	-	-	-
26	S. Deisler	44	183	76	-	-	-
	T. Fink	56	181	83	-	-	1
	Z. Misimović	41	180	79	-	-	-
11	Zé Roberto	49	175	68	1	-	1
Delantero
21	A. Zickler	50	188	87	4	-	-
14	C. Pizarro	45	186	84	15	-	2
9	G. Élber	51	180	80	21	-	4
	Roque Santa Cruz	42	193	80	5	-	-

Noticias del Bayern München

Ver últimas noticias

"Estamos convencidos de que podemos ganar al Madrid"

BeSoccer - Martes, 30 Abril 2024

4 5.275

El jugador del Bayern de Múnich Bryan Zaragoza concedió una entrevista al diario 'Marca' en la que afirmó que en el vestuario bávaro "están convencidos" de poder ganar al Real Madrid en su eliminatoria de semifinales de la Champions League. Además, repasó su etapa en Alemania hasta el momento y quiso despejar las dudas sobre su futuro: "Agradezco el interés que han mostrado en mí algunos clubes, pero no contemplo una cesión".

No es entre Musiala y Bellingham, es entre Jamal y Jude

David Caravaca - Lunes, 29 Abril 2024

12 24.252

Las semifinales de la Champions League suponen el escenario de un reencuentro entre dos chicos que compartieron habitación y sueños en las categorías inferiores de la Selección de Inglaterra. Sus destinos se cruzan con el telón de fondo más exigente posible, el europeo. Cuando el aficionado mire al campo, verá a Musiala competir con Bellingham, pero, para ellos, no es un asunto entre dorsales, sino entre personas. Jamal se mide a su amigo Jude.

"El Madrid tiene algo especial"

BeSoccer - Lunes, 29 Abril 2024

5 4.284

Joshua Kimmich, capitán del Bayern de Múnich, aclaró que pese a que el Real Madrid tiene "algo especial" con la Champions League, el cuadro bávaro no se puede esconder.

"Ancelotti es una leyenda"

BeSoccer - Lunes, 29 Abril 2024

1 1.041

Thomas Tuchel, entrenador del Bayern de Múnich, calificó a su homólogo del Real Madrid, Carlo Ancelotti, como "una leyenda" del fútbol mundial. Ambos se enfrentan este martes en la ida de la semifinal de la Champions League.

Y después de Haaland... llega Kane

Mario Ramírez - Lunes, 29 Abril 2024

1 3.309

Real Madrid y Bayern de Múnich van a protagonizar un duelo apasionante en las semifinales de la Champions League. Además, este enfrentamiento se conoce como el 'Clásico' europeo debido a las numerosas veces que estos dos equipos se han cruzado en el torneo. Pero dentro de esta gran disputa se va a dar otra a nivel individual, Rüdiger contra Kane. El alemán ya secó a Erling Haaland en los cuartos de final y ahora le tocará bailar con el delantero inglés, quien mejora las cifras del noruego esta temporada.

Ver más noticias del equipo»

Competiciones que juega

Grupo 1

Bundesliga

Pos	Equipos		Pts
1		Bayern München	75
2		Stuttgart	59
3		B. Dortmund	58
4		Hamburger SV	56
5		Hertha BSC	54
6		Werder Bremen	52
7		Schalke 04	49
8		Wolfsburg	46
9		VfL Bochum	45
10		1860 München	45
11		Hannover 96	43
12		B. Mönchengladbach	42
13		Hansa Rostock	41
14		Kaiserslautern	40
15		B. Leverkusen	40
16		Arminia Bielefeld	36
17		Nürnberg	30
18		Energie Cottbus	30

	Champions League : Bayern München, Stuttgart
	Previa de Champions : B. Dortmund
	UEFA : Hamburger SV, Hertha BSC, Kaiserslautern
	Intertoto : Werder Bremen, Schalke 04, Wolfsburg
	Descenso : Arminia Bielefeld, Nürnberg, Energie Cottbus

RIVALES EN Bundesliga

RIVALES EN Champions League

RIVALES EN Fase Previa Cham.

RIVALES EN DFB Pokal

RIVALES EN Liga Pokal

USO DE MEMORIA

6,820,440 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.7852
Total Execution Time	0.7870

CADENA URL

/Bayern-Munchen/2003

GET DATOS

$_GET['/Bayern-Munchen/2003']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0153	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 = 'Bayern-Munchen' AND l.year = 2003 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.0126	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=449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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 = 56
0.0131	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 = 9645
0.0132	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 = 40745
0.0133	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 = 49239
0.0132	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 = 72509
0.0144	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 = '449' AND l.year = 2003 ORDER BY l.year DESC,cat.coefficient DESC
0.0145	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 = '449' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 56 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 9645 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 40745 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 49239 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	(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 calendars2003 as c ON c.league_id = l.id WHERE (c.datateam1 = 449 or c.datateam2 = 449) AND l.year = 2003 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0139	(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 calendars2003 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 = 449 or c.datateam2 = 449) AND l.year = 2003 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0137	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2003 as c ON c.league_id = l.id INNER JOIN events2003 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 = 449 or c.datateam2 = 449) AND l.year = 2003)
0.0156	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=449 AND l.year in (2002,2003,2004) ORDER BY l.id DESC, l.year DESC ;
0.0132	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 (72509,49241,40745,16410,11938,11895,9662,57) 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.0168	SELECT count(id) as num_players from rel_players WHERE league_id = 57 AND teamId = 449
0.0182	SELECT count(id) as num_players from rel_players WHERE league_id = 9662 AND teamId = 449
0.0176	SELECT count(id) as num_players from rel_players WHERE league_id = 16410 AND teamId = 449
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 11895 AND teamId = 449
0.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 40745 AND teamId = 449
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 49241 AND teamId = 449
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 11938 AND teamId = 449
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 72509 AND teamId = 449
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2003` 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 = 56 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0151	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 events2003 e ON e.player_id = p.id AND e.league_id = 56 WHERE rp.league_id = 56 AND rp.teamId = 449 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.0156	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 events2003 e ON e.player_id = p.id AND e.league_id = 56 WHERE rp.league_id = 56 AND rp.teamId = 449 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0187	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 events2003 e ON e.player_id = p.id AND e.league_id = 56 WHERE rp.league_id = 56 AND rp.teamId = 449 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0177	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 = 449 AND rp.league_id = 56 AND l.year= 2003 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0148	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=2667 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0131	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=2667
0.0167	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2667 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.0162	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2667 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0168	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2667 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0181	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2667 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2667 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0126	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 = 56 ORDER BY nameShow LIMIT 100

Bayern München

Información sobre Bayern München

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Bayern München

Estadísticas

Plantilla del Bayern München Temporada 2002/2003

Noticias del Bayern München

Bayern München

Selecciona un equipo

Competiciones que juega

RIVALES EN Bundesliga

RIVALES EN Champions League

RIVALES EN Fase Previa Cham.

RIVALES EN DFB Pokal

RIVALES EN Liga Pokal