15 Ene 23	Finalizado	Kaiserslautern	4 - 0	Rot-Weiss Erfurt	0
08 Ene 23	Finalizado	1860 München	1 - 1	Kaiserslautern	1
05 Ene 23	Finalizado	Kaiserslautern	1 - 2	Mezőkövesd-Zsory	2
16 Dic 22	Finalizado	Kaiserslautern	2 - 0	Wehen Wiesbaden	40
22 Sep 22	Finalizado	FK Pirmasens	1 - 4	Kaiserslautern	0
09 Jul 22	Finalizado	Kaiserslautern	4 - 1	KAS Eupen	0
02 Jul 22	Finalizado	Kaiserslautern	3 - 0	Unterhaching	0
28 Jun 22	Finalizado	Kaiserslautern	3 - 4	FC Lugano	3
18 Jun 22	Finalizado	Rulzheim	0 - 9	Kaiserslautern	2

2. Bundesliga »

28 May 23	Finalizado	Kaiserslautern	0 - 3	Fortuna Düsseldorf	10
21 May 23	Finalizado	Karlsruher SC	2 - 0	Kaiserslautern	2
13 May 23	Finalizado	Kaiserslautern	1 - 2	Arminia Bielefeld	64
07 May 23	Finalizado	Nürnberg	3 - 3	Kaiserslautern	2
29 Abr 23	Finalizado	Kaiserslautern	0 - 1	Hansa Rostock	38
23 Abr 23	Finalizado	Jahn Regensburg	0 - 0	Kaiserslautern	18
15 Abr 23	Finalizado	Kaiserslautern	2 - 0	Hamburger SV	48
08 Abr 23	Finalizado	Eintracht Braunschweig	1 - 0	Kaiserslautern	14
01 Abr 23	Finalizado	Kaiserslautern	2 - 2	Heidenheim	34
18 Mar 23	Finalizado	Darmstadt 98	2 - 0	Kaiserslautern	38
10 Mar 23	Finalizado	Kaiserslautern	2 - 2	Sandhausen	156
03 Mar 23	Finalizado	Magdeburg	2 - 0	Kaiserslautern	52
25 Feb 23	Finalizado	Kaiserslautern	3 - 1	Greuther Fürth	25
17 Feb 23	Finalizado	Paderborn	1 - 0	Kaiserslautern	201
12 Feb 23	Finalizado	FC St Pauli	1 - 0	Kaiserslautern	26
04 Feb 23	Finalizado	Kaiserslautern	2 - 1	Holstein Kiel	7
28 Ene 23	Finalizado	Hannover 96	1 - 3	Kaiserslautern	20
11 Nov 22	Finalizado	Fortuna Düsseldorf	1 - 2	Kaiserslautern	141
08 Nov 22	Finalizado	Kaiserslautern	2 - 0	Karlsruher SC	9
05 Nov 22	Finalizado	Arminia Bielefeld	2 - 3	Kaiserslautern	58
29 Oct 22	Finalizado	Kaiserslautern	0 - 0	Nürnberg	9
21 Oct 22	Finalizado	Hansa Rostock	0 - 2	Kaiserslautern	149
16 Oct 22	Finalizado	Kaiserslautern	0 - 3	Jahn Regensburg	6
08 Oct 22	Finalizado	Hamburger SV	1 - 1	Kaiserslautern	38
02 Oct 22	Finalizado	Kaiserslautern	1 - 1	Eintracht Braunschweig	9
18 Sep 22	Finalizado	Heidenheim	2 - 2	Kaiserslautern	3
11 Sep 22	Finalizado	Kaiserslautern	3 - 3	Darmstadt 98	9
04 Sep 22	Finalizado	Sandhausen	0 - 0	Kaiserslautern	9
28 Ago 22	Finalizado	Kaiserslautern	4 - 4	Magdeburg	47
21 Ago 22	Finalizado	Greuther Fürth	1 - 3	Kaiserslautern	9
12 Ago 22	Finalizado	Kaiserslautern	0 - 1	Paderborn	111
07 Ago 22	Finalizado	Kaiserslautern	2 - 1	FC St Pauli	20
23 Jul 22	Finalizado	Holstein Kiel	2 - 2	Kaiserslautern	21
15 Jul 22	Finalizado	Kaiserslautern	2 - 1	Hannover 96	144

Estadísticas

GOLEADORES

T. Boyd13

AMARILLAS

ROJAS

Plantilla del Kaiserslautern Temporada 2022/2023

		Edad	Altura	Peso
Portero
1	A. Luthe	37	195	90	-	1	3
30	A. Spahic	27	190	77	-	-	-
33	J. Weyand	23	186	-	-	-	-
18	Julian Krahl	24	194	86	-	-	-
Defensa
2	Boris Tomiak	25	193	76	3	-	9
20	D. Schad	27	176	66	-	-	-
37	Erik Durm	31	183	73	-	-	7
21	Hendrick Zuck	33	176	64	-	1	2
8	Jean Zimmer	30	173	68	-	1	8
5	Kevin Kraus	31	190	89	4	-	2
22	Lars Bünning	26	188	-	-	-	-
23	P. Hercher	28	182	80	5	-	2
32	R. Bormuth	28	190	87	-	-	4
Centrocampista
39	A. Basenach	21	184	70	-	-	-
16	J. Niehues	23	195	82	2	-	6
7	Marlon Ritter	29	173	65	-	-	4
4	N. Rapp	27	186	75	-	-	4
10	P. Klement	31	175	69	3	-	4
Delantero
25	A. Opoku	25	185	81	2	1	3
35	A. Stavridis	20	173	67	-	-	-
31	Ben Zolinski	32	181	78	-	-	4
19	D. Hanslik	27	186	81	3	-	4
11	K. Redondo	29	180	76	5	-	-
27	L. Lobinger	25	192	85	2	-	4
9	M. Kiprit	24	184	80	-	-	-
28	N. De Préville	33	182	77	1	-	2
13	T. Boyd	33	188	87	13	-	6

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		Heidenheim	67
2		Darmstadt 98	67
3		Hamburger SV	66
4		Fortuna Düsseldorf	58
5		FC St Pauli	58
6		Paderborn	55
7		Karlsruher SC	46
8		Holstein Kiel	46
9		Kaiserslautern	45
10		Hannover 96	44
11		Magdeburg	43
12		Greuther Fürth	41
13		Hansa Rostock	41
14		Nürnberg	39
15		Eintracht Braunschweig	36
16		Arminia Bielefeld	34
17		Jahn Regensburg	31
18		Sandhausen	28

	Campeón : Heidenheim
	Ascenso : Darmstadt 98
	Playoff Ascenso : Hamburger SV
	Playoff Descenso : Arminia Bielefeld
	Descenso : Jahn Regensburg, Sandhausen

RIVALES EN 2. Bundesliga

RIVALES EN DFB Pokal

USO DE MEMORIA

6,046,832 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.6201
Total Execution Time	0.6221

CADENA URL

/Kaiserslautern/2023

GET DATOS

$_GET['/Kaiserslautern/2023']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0148	SELECT type FROM routes WHERE alias = 'kaiserslautern'
0.0227	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 = 'Kaiserslautern' AND l.year = 2023 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.0145	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=1435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=1435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=1435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=1435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0180	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' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0208	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.0153	(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 calendars2023 as c ON c.league_id = l.id WHERE (c.datateam1 = 1435 or c.datateam2 = 1435) AND l.year = 2023 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0162	(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 calendars2023 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 l.year = 2023 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0155	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN events2023 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 l.year = 2023)
0.0160	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 (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0146	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,67536,63195) 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.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 72037 AND teamId = 1435
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 63195 AND teamId = 1435
0.0157	SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 1435
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 67536 AND teamId = 1435
0.0241	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1435
0.0164	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 events2023 e ON e.player_id = p.id AND e.league_id = 67802 WHERE rp.league_id = 67802 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.0160	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 events2023 e ON e.player_id = p.id AND e.league_id = 67802 WHERE rp.league_id = 67802 AND rp.teamId = 1435 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158	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 events2023 e ON e.player_id = p.id AND e.league_id = 67802 WHERE rp.league_id = 67802 AND rp.teamId = 1435 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 = 67802 AND l.year= 2023 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0151	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=6517183 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6517183
0.0152	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6517183 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.0153	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6517183 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0154	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6517183 and (e.action = 3 or e.action = 4) 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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6517183 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0174	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6517183 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