Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Karlsruher SC

Entrenador: Christian Eichner

Temporada 2023/2024

TEMPORADA 2023/2024

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	FC St Pauli	31	57	33	63
2	Holstein	31	61	37	61
3	Fortuna	30	64	35	55
4	Hamburger	31	59	42	52
5	Karlsruher	30	61	45	46
6	Hannover 96	31	53	39	46
7	Paderborn	31	49	50	46
8	Hertha BSC	31	63	52	45
9	Greuther	30	40	43	42
10	Elversberg	31	45	55	40
11	Nürnberg	30	38	56	37
12	Magdeburg	30	42	46	36
13	Schalke 04	30	46	56	36
14	Eintracht	31	33	45	34
15	Kaiserslaute	31	49	60	33
16	Wehen	30	32	41	32
17	Hansa	31	27	51	31
18	Osnabrück	30	27	60	24

TEMPORADA 2022/2023

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Heidenheim	34	67	36	67
2	Darmstadt	34	50	33	67
3	Hamburger	34	70	45	66
4	Fortuna	34	60	43	58
5	FC St Pauli	34	55	39	58
6	Paderborn	34	68	44	55
7	Karlsruher	34	56	53	46
8	Holstein	34	58	61	46
9	Kaiserslaute	34	47	48	45
10	Hannover 96	34	50	55	44
11	Magdeburg	34	48	55	43
12	Greuther	34	47	50	41
13	Hansa	34	32	48	41
14	Nürnberg	34	32	49	39
15	Eintracht	34	42	59	36
16	Arminia	34	50	62	34
17	Jahn	34	34	58	31
18	Sandhausen	34	35	63	28

TEMPORADA 2021/2022

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Schalke 04	34	72	44	65
2	Werder	34	65	43	63
3	Hamburger	34	67	35	60
4	Darmstadt	34	71	46	60
5	FC St Pauli	34	61	46	57
6	Heidenheim	34	43	45	52
7	Paderborn	34	56	44	51
8	Nürnberg	34	49	49	51
9	Holstein	34	46	54	45
10	Fortuna	34	45	42	44
11	Hannover 96	34	35	49	42
12	Karlsruher	34	54	55	41
13	Hansa	34	41	52	41
14	Sandhausen	34	42	54	41
15	Jahn	34	50	51	40
16	Dynamo	34	33	46	32
17	Erzgebirge	34	32	72	26
18	Ingolstadt	34	30	65	21

TEMPORADA 2020/2021

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	VfL Bochum	34	66	39	67
2	Greuther	34	69	44	64
3	Holstein	34	57	35	62
4	Hamburger	34	71	44	58
5	Fortuna	34	55	46	56
6	Karlsruher	34	51	44	52
7	Darmstadt	34	63	55	51
8	Heidenheim	34	49	49	51
9	Paderborn	34	53	45	47
10	FC St Pauli	34	51	56	47
11	Nürnberg	34	46	51	44
12	Erzgebirge	34	44	53	44
13	Hannover 96	34	53	51	42
14	Jahn	34	37	50	38
15	Sandhausen	34	41	60	34
16	Osnabrück	34	35	58	33
17	Eintracht	34	30	59	31
18	Würzburger	34	37	69	25

TEMPORADA 2019/2020

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Arminia	34	65	30	68
2	Stuttgart	34	62	41	58
3	Heidenheim	34	45	36	55
4	Hamburger	34	62	46	54
5	Darmstadt	34	48	43	52
6	Hannover 96	34	54	49	48
7	Erzgebirge	34	46	48	47
8	VfL Bochum	34	53	51	46
9	Greuther	34	46	45	44
10	Sandhausen	34	43	45	43
11	Holstein	34	53	56	43
12	Jahn	34	50	56	43
13	Osnabrück	34	46	48	40
14	FC St Pauli	34	41	50	39
15	Karlsruher	34	45	56	37
16	Nürnberg	34	45	58	37
17	Wehen	34	45	65	34
18	Dynamo	34	32	58	32

TEMPORADA 2018/2019

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Osnabrück	38	56	31	76
2	Karlsruher	38	64	38	71
3	Wehen	38	71	47	70
4	Hallescher	38	47	34	66
5	Würzburger	38	56	45	57
6	Hansa	38	47	46	55
7	Zwickau	38	49	47	52
8	Preußen	38	48	50	52
9	Kaiserslaute	38	49	51	51
10	Uerdingen	38	47	62	48
11	1860	38	48	52	47
12	Unterhaching	37	53	46	47
13	SV Meppen	38	48	53	47
14	Carl Zeiss.	38	48	57	46
15	Sonnenhof	38	38	39	45
16	Eintracht	38	48	54	45
17	Energie	37	51	58	44
18	Sportfreunde	38	31	46	40
19	Fortuna	38	38	64	39
20	VfR Aalen	38	45	62	31

TEMPORADA 2017/2018

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Magdeburg	38	70	32	85
2	Paderborn	38	90	33	83
3	Karlsruher	38	49	29	69
4	Wehen	38	76	39	68
5	Würzburger	38	53	46	61
6	Hansa	38	48	34	60
7	SV Meppen	38	50	47	58
8	Fortuna	38	53	48	54
9	Unterhaching	38	54	55	54
10	Preußen	38	50	49	52
11	Carl Zeiss.	38	49	59	52
12	VfR Aalen	38	48	57	50
13	Hallescher	38	52	54	49
14	Sonnenhof	38	55	60	47
15	Zwickau	38	38	55	41
16	Sportfreunde	38	43	60	40
17	Osnabrück	38	47	67	37
18	Werder	38	39	62	31
19	Chemnitzer	38	48	74	22
20	Rot-Weiss	38	26	78	13

TEMPORADA 2016/2017

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Stuttgart	34	63	37	69
2	Hannover 96	34	51	32	67
3	Eintracht	34	50	36	66
4	Union Berlin	34	51	39	60
5	Dynamo	34	53	46	50
6	Heidenheim	34	43	39	46
7	FC St Pauli	34	39	35	45
8	Greuther	34	33	40	45
9	VfL Bochum	34	42	47	44
10	Sandhausen	34	41	36	42
11	Fortuna	34	37	39	42
12	Nürnberg	34	46	52	42
13	Kaiserslaute	34	29	33	41
14	Erzgebirge	34	37	52	39
15	Arminia	34	50	54	37
16	1860	34	37	47	36
17	Würzburger	34	32	41	34
18	Karlsruher	34	27	56	25

TEMPORADA 2015/2016

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	SC Freiburg	34	75	39	72
2	RB Leipzig	34	54	32	67
3	Nürnberg	34	68	41	65
4	FC St Pauli	34	45	39	53
5	VfL Bochum	34	56	40	51
6	Union Berlin	34	56	50	49
7	Karlsruher	34	35	37	47
8	Eintracht	34	44	38	46
9	Greuther	34	49	55	46
10	Kaiserslaute	34	49	47	45
11	Heidenheim	34	42	40	45
12	Arminia	34	38	39	42
13	Sandhausen	34	40	50	40
14	Fortuna	34	32	47	35
15	1860	34	32	46	34
16	Duisburg	34	32	54	32
17	Frankfurt	34	33	59	32
18	Paderborn	34	28	55	28

TEMPORADA 2014/2015

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Ingolstadt	34	53	32	64
2	Darmstadt	34	44	26	59
3	Karlsruher	34	46	26	58
4	Kaiserslaute	34	45	31	56
5	RB Leipzig	34	39	31	50
6	Eintracht	34	44	41	50
7	Union Berlin	34	46	51	47
8	Heidenheim	34	49	44	46
9	Nürnberg	34	42	47	45
10	Fortuna	34	48	52	44
11	VfL Bochum	34	53	55	42
12	Sandhausen	34	32	37	39
13	Frankfurt	34	41	53	39
14	Greuther	34	34	42	37
15	FC St Pauli	34	40	51	37
16	1860	34	41	51	36
17	Erzgebirge	34	32	47	36
18	VfR Aalen	34	34	46	31

TEMPORADA 2013/2014

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Köln	34	53	20	68
2	Paderborn	34	63	48	62
3	Greuther	34	64	38	60
4	Kaiserslaute	34	55	39	54
5	Karlsruher	34	47	34	50
6	Fortuna	34	45	44	50
7	1860	34	38	41	48
8	FC St Pauli	34	44	49	48
9	Union Berlin	34	48	47	44
10	Ingolstadt	34	34	33	44
11	VfR Aalen	34	36	39	44
12	Sandhausen	34	29	35	44
13	Frankfurt	34	46	51	41
14	Erzgebirge	34	42	54	41
15	VfL Bochum	34	30	43	40
16	Arminia	34	40	58	35
17	Dynamo	34	36	53	32
18	Energie	34	35	59	25

TEMPORADA 2012/2013

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Karlsruher	38	69	27	79
2	Arminia	38	59	32	76
3	Osnabrück	38	64	35	73
4	Preußen	38	63	33	72
5	Heidenheim	38	69	47	72
6	Chemnitzer	38	56	47	55
7	Wehen	38	51	51	51
8	Wacker	38	45	45	51
9	Unterhaching	38	48	55	51
10	Hallescher	38	37	50	46
11	Saarbrücken	38	52	62	45
12	Hansa	38	39	52	44
13	Rot-Weiss	38	44	58	44
14	Stuttgart	38	35	42	43
15	Kickers	38	41	44	42
16	Dortmund	38	39	58	41
17	Stuttgarter	38	39	48	40
18	Darmstadt	38	32	46	38
19	Babelsberg	38	32	54	37
20	Alemannia	38	40	68	26

TEMPORADA 2011/2012

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Greuther	34	73	27	70
2	Eintracht	34	76	33	68
3	Fortuna	34	64	35	62
4	FC St Pauli	34	59	34	62
5	Paderborn	34	51	42	61
6	1860	34	63	46	57
7	Union Berlin	34	55	58	48
8	Eintracht	34	37	35	45
9	Dynamo	34	50	52	45
10	Duisburg	34	42	47	39
11	VfL Bochum	34	41	55	37
12	Ingolstadt	34	43	58	37
13	Frankfurt	34	43	59	35
14	Energie	34	30	49	35
15	Erzgebirge	34	31	56	35
16	Karlsruher	34	34	60	33
17	Alemannia	34	30	47	31
18	Hansa	34	34	63	27

TEMPORADA 2010/2011

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Hertha BSC	34	69	28	74
2	FC Augsburg	34	58	27	65
3	VfL Bochum	34	49	35	65
4	Greuther	34	47	27	61
5	Erzgebirge	34	40	37	56
6	Energie	34	65	52	55
7	Fortuna	34	49	39	53
8	Duisburg	34	53	38	52
9	1860	34	50	36	52
10	Alemannia	34	58	60	48
11	Union Berlin	34	39	45	42
12	Paderborn	34	32	47	39
13	Frankfurt	34	42	54	38
14	Ingolstadt	34	40	46	37
15	Karlsruher	34	46	72	33
16	Osnabrück	34	40	62	31
17	Rot-Weiß	34	30	65	28
18	Arminia	34	28	65	20

TEMPORADA 2009/2010

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Kaiserslaute	34	56	28	67
2	FC St Pauli	34	72	37	64
3	FC Augsburg	34	60	40	62
4	Fortuna	34	48	31	59
5	Arminia	34	48	41	53
6	Paderborn	34	49	49	51
7	Duisburg	34	51	46	50
8	1860	34	43	45	48
9	Energie	34	55	49	47
10	Karlsruher	34	43	45	46
11	Greuther	34	51	50	44
12	Union Berlin	34	42	45	44
13	Alemannia	34	37	41	43
14	Rot-Weiß	34	38	52	41
15	Frankfurt	34	29	50	38
16	Hansa	34	33	45	36
17	TuS Koblenz	34	35	60	31
18	Weiss Ahlen	34	19	55	22

TEMPORADA 2008/2009

BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Wolfsburg	34	80	41	69
2	Bayern	34	71	42	67
3	Stuttgart	34	63	43	64
4	Hertha BSC	34	48	41	63
5	Hamburger	34	49	47	61
6	B. Dortmund	34	60	37	59
7	Hoffenheim	34	63	49	55
8	Schalke 04	34	47	35	50
9	Leverkusen	34	59	46	49
10	Werder	34	64	50	45
11	Hannover 96	34	49	69	40
12	Köln	34	35	50	39
13	Eintracht	34	39	60	33
14	VfL Bochum	34	39	55	32
15	Mönchenglad	34	39	62	31
16	Energie	34	30	57	30
17	Karlsruher	34	30	54	29
18	Arminia	34	29	56	28

TEMPORADA 2007/2008

BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Bayern	34	68	21	76
2	Werder	34	75	45	66
3	Schalke 04	34	55	32	64
4	Hamburger	34	47	26	54
5	Wolfsburg	34	58	46	54
6	Stuttgart	34	57	57	52
7	Leverkusen	34	57	40	51
8	Hannover 96	34	54	56	49
9	Eintracht	34	43	50	46
10	Hertha BSC	34	39	44	44
11	Karlsruher	34	38	53	43
12	VfL Bochum	34	48	54	41
13	B. Dortmund	34	50	62	40
14	Energie	34	35	56	36
15	Arminia	34	35	60	34
16	Nürnberg	34	35	51	31
17	Hansa	34	30	52	30
18	Duisburg	34	36	55	29

TEMPORADA 2006/2007

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Karlsruher	34	69	41	70
2	Hansa	34	49	30	62
3	Duisburg	34	66	40	60
4	SC Freiburg	34	55	39	60
5	Greuther	34	53	40	54
6	Kaiserslaute	34	48	34	53
7	FC Augsburg	34	43	32	52
8	1860	34	47	49	48
9	Köln	34	49	50	46
10	Erzgebirge	34	46	48	45
11	Paderborn	34	32	41	42
12	TuS Koblenz	34	36	45	41
13	Carl Zeiss.	34	40	56	38
14	Kickers	34	42	59	36
15	Rot-Weiss	34	34	40	35
16	Unterhaching	34	33	49	35
17	Wacker	34	42	63	32
18	Eintracht	34	20	48	23

TEMPORADA 2005/2006

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	VfL Bochum	34	55	26	66
2	Alemannia	34	61	36	65
3	Energie	34	49	33	58
4	SC Freiburg	34	41	33	56
5	Greuther	34	51	42	54
6	Karlsruher	34	55	45	53
7	Erzgebirge	34	38	36	48
8	Wacker	34	45	49	47
9	Paderborn	34	46	40	46
10	Hansa	34	44	49	43
11	Kickers	34	42	53	43
12	Eintracht	34	37	48	43
13	1860	34	41	44	42
14	Unterhaching	34	42	48	42
15	Dynamo	34	39	45	41
16	Saarbrücken	34	37	63	38
17	Weiss Ahlen	34	36	50	35
18	Siegen	34	35	54	31

TEMPORADA 2004/2005

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Köln	34	62	33	67
2	Duisburg	34	50	37	62
3	Eintracht	34	65	39	61
4	1860	34	52	39	57
5	Greuther	34	51	42	56
6	Alemannia	34	60	40	54
7	Erzgebirge	34	49	40	51
8	Dynamo	34	48	53	49
9	Wacker	34	48	55	48
10	Unterhaching	34	40	43	45
11	Karlsruher	34	46	47	43
12	Saarbrücken	34	44	50	40
13	Weiss Ahlen	34	43	49	39
14	Energie	34	35	48	39
15	Eintracht	34	39	53	39
16	Rot-Weiß	34	40	62	34
17	Rot-Weiss	34	35	51	33
18	Rot-Weiss	34	34	60	30

Competiciones que juega

2. Bundesliga

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

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

RIVALES EN 2. Bundesliga

RIVALES EN DFB Pokal

USO DE MEMORIA

8,377,352 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6086
Total Execution Time	0.6098

CADENA URL

/historico/Karlsruher-Sc

GET DATOS

$_GET['/historico/Karlsruher-Sc']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1443 AND type_rel = 2
0.0130	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1443 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131	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 (2994,4910,7504,47536,49077) ORDER BY n.cover_points DESC, update_date DESC
0.0136	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 = '1443' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134	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=1443 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130	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.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 72037 AND teamId = 1443
0.0138	SELECT count(id) as num_players from rel_players WHERE league_id = 72172 AND teamId = 1443
0.0267	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1443
0.0130	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 = '1443' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1443' and rp.type = 4
0.0127	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 = '1443' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0152	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 = 1443 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.0146	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 = 1443 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144	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 = 1443 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0180	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 1443 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0268	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2022` 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 = 62743 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` 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 = 56926 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2019` 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 = 43698 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2018` 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 = 38729 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` 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 = 29215 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2016` 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 = 15098 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 3811 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2014` 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 = 2445 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2013` 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 = 2004 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2012` 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 = 1325 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2011` 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 = 1081 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2010` 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 = 876 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2008` 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 = 30 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2007` 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 = 547 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2006` 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 = 548 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2005` 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 = 549 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Karlsruher SC

Karlsruher SC

Selecciona un equipo

Competiciones que juega

2. Bundesliga

RIVALES EN 2. Bundesliga

RIVALES EN DFB Pokal