25 May 24	en 1 mes	Kaiserslautern	20:00	B. Leverkusen	26
02 Abr 24	Finalizado	1. FC Saarbrücken	0 - 2	Kaiserslautern	204
31 Ene 24	Finalizado	Hertha BSC	1 - 3	Kaiserslautern	150

Partidos Amistosos »

	10 Ene 24	Finalizado	Dynamo Dresden	3 - 0	Kaiserslautern			3
	06 Ene 24	Finalizado	Gençlerbirliği SK	1 - 4	Kaiserslautern			1

2. Bundesliga »

19 May 24	en 1 mes	Kaiserslautern	15:30	Eintracht Braunschweig	0
11 May 24	en 22 días	Hertha BSC	13:00	Kaiserslautern	0
04 May 24	en 15 días	Kaiserslautern	20:30	Magdeburg	0
27 Abr 24	en 8 días	Holstein Kiel	13:00	Kaiserslautern	0
20 Abr 24	en 1 día	Kaiserslautern	13:00	Wehen Wiesbaden	0
12 Abr 24	Finalizado	Greuther Fürth	2 - 1	Kaiserslautern	162
06 Abr 24	Finalizado	Hamburger SV	2 - 1	Kaiserslautern	40
30 Mar 24	Finalizado	Kaiserslautern	1 - 3	Fortuna Düsseldorf	45
16 Mar 24	Finalizado	Hannover 96	1 - 1	Kaiserslautern	103
10 Mar 24	Finalizado	Kaiserslautern	3 - 2	VfL Osnabrück	9
02 Mar 24	Finalizado	Hansa Rostock	0 - 3	Kaiserslautern	19
24 Feb 24	Finalizado	Kaiserslautern	0 - 4	Karlsruher SC	25
18 Feb 24	Finalizado	Nürnberg	1 - 1	Kaiserslautern	9
10 Feb 24	Finalizado	Kaiserslautern	1 - 2	Paderborn	39
04 Feb 24	Finalizado	SV Elversberg	2 - 1	Kaiserslautern	15
26 Ene 24	Finalizado	Kaiserslautern	4 - 1	Schalke 04	178
20 Ene 24	Finalizado	FC St Pauli	2 - 0	Kaiserslautern	56

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Kaiserslautern Temporada 2023/2024

		Edad	Altura	Peso
Portero
30	A. Spahic	27	190	77	-	-	-
18	Julian Krahl	24	194	86	-	-	2
35	Niklas Heeger	24	187	-	-	-	-
32	R. Himmelmann	35	187	79	-	-	-
Defensa
6	A. Touré	27	181	79	1	-	1
2	Boris Tomiak	25	193	76	4	2	6
27	Frank Ronstadt	26	179	76	-	-	-
21	Hendrick Zuck	33	176	64	-	-	-
33	Jan Elvedi	27	187	83	1	-	3
8	Jean Zimmer	30	173	68	1	-	3
5	Kevin Kraus	31	190	89	2	-	2
14	Nikola Soldo	23	189	89	-	-	4
23	P. Hercher	28	182	80	-	-	1
15	Tymoteusz Puchacz	25	180	74	1	-	5
Centrocampista
4	A. Aremu	24	181	75	-	1	-
39	A. Basenach	21	184	70	-	-	-
26	Filip Kaloc	24	190	85	-	-	4
16	J. Niehues	23	195	82	1	-	6
7	Marlon Ritter	29	173	65	5	-	5
10	P. Klement	31	175	69	-	-	-
20	Tobias Raschl	24	177	75	1	-	4
Delantero
17	A. Opoku	25	185	81	2	-	1
24	B. Simakala	27	180	77	1	-	3
31	Ben Zolinski	31	181	78	-	-	1
40	D. Abiama	25	184	75	3	-	4
19	D. Hanslik	27	186	81	-	-	-
25	Filip Stojilković	24	186	80	1	-	1
11	K. Redondo	29	180	76	1	-	4
29	R. Tachie	24	177	70	3	-	1
9	Ragnar Ache	25	183	77	16	-	-

Noticias del Kaiserslautern

Ver últimas noticias

El Bayer Leverkusen cede a Frey al Kaiserslautern

BeSoccer - Martes, 05 Julio 2016

0 654

El joven centrocampista contará con más minutos en el conjunto de la segunda alemana, en el que espera poder coger la experiencia necesaria para volver al Bayer.

Tayfun Korkut, nuevo entrenador del Kaiserslautern

BeSoccer - Miércoles, 15 Junio 2016

0 123

El Kaiserslautern de la Segunda División alemana ha hecho oficial la contratación de Tayfun Korkut como entrenador de cara a la próxima campaña.

Dittgen, primer refuerzo del Kaiserslautern

BeSoccer - Martes, 17 Mayo 2016

0 416

Su buena temporada en el Sonnenhof Grossaspach le ha valido para firmar dos años con el conjunto alemán.

El Stuttgart ficha a Zimmer para la próxima temporada

BeSoccer - Martes, 05 Abril 2016

0 207

El conjunto alemán pagará 2,5 millones de euros por el lateral derecho del Kaiserlautern, que no se incorporará hasta el curso que viene.

El Bayern abre la Bundesliga ante el Hamburgo

BeSoccer - Viernes, 26 Junio 2015

0 225

La competición entre los equipos de la máxima categoría alemana comienza el próximo 14 de agosto con un encuentro entre el FC Bayern de Munich y el Hamburgo SV.

Ver más noticias del equipo»

Competiciones que juega

2. Bundesliga

Pos	Equipos		Pts
1		Holstein Kiel	58
2		FC St Pauli	57
3		Fortuna Düsseldorf	52
4		Hamburger SV	49
5		Hannover 96	45
6		Hertha BSC	44
7		Karlsruher SC	43
8		Greuther Fürth	42
9		Paderborn	40
10		SV Elversberg	39
11		Nürnberg	37
12		Schalke 04	35
13		Magdeburg	33
14		Wehen Wiesbaden	31
15		Eintracht Braunschweig	31
16		Hansa Rostock	31
17		Kaiserslautern	29
18		VfL Osnabrück	24

	Ascenso : Holstein Kiel, FC St Pauli
	Playoff Ascenso : Fortuna Düsseldorf
	Playoff Descenso : Hansa Rostock
	Descenso : Kaiserslautern, VfL Osnabrück

RIVALES EN 2. Bundesliga

RIVALES EN DFB Pokal

USO DE MEMORIA

5,846,968 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.5086
Total Execution Time	0.5105

CADENA URL

/Kaiserslautern/

GET DATOS

$_GET['/Kaiserslautern/']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0104	SELECT type FROM routes WHERE alias = 'kaiserslautern'
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1435 AND type_rel = 2
0.0108	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1435 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0110	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 (703,57472,71083,80856,87307) ORDER BY n.cover_points DESC, update_date DESC
0.0245	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 = '1435' ORDER BY l.year DESC,cat.coefficient DESC
0.0138	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 = '1435' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0114	(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 calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 1435 or c.datateam2 = 1435) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120360024 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0121	(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 calendars2024 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 = 1435 or c.datateam2 = 1435) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120360024 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0112	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 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 = 1435 or c.datateam2 = 1435) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120360024 AND l.year = 2024)
0.0122	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=1435 AND l.year in (2023,2024,2025) 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 (72172,72037,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.0122	SELECT count(id) as num_players from rel_players WHERE league_id = 72037 AND teamId = 1435
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 1435
0.0330	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1435
0.0111	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 = 72037 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0108	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 = '1435' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0104	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1435' and rp.type = 4
0.0108	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 = '1435' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0105	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1435' and rp.type = 4
0.0130	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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 1435 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.0133	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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 1435 AND (e.action = 4 or e.action = 5) 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 = 72037 WHERE rp.league_id = 72037 AND rp.teamId = 1435 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0124	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 = 1435 AND rp.league_id = 72037 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0120	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=6582307 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=6582307
0.0123	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=6582307 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.0121	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=6582307 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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582307 and (e.action = 3 or e.action = 4) 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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582307 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0114	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=6582307 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC


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

Kaiserslautern

Información sobre Kaiserslautern

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Kaiserslautern