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

Heider SV

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Todesfelde	26	83	18	66
2	SV Eichede	26	64	20	57
3	Union	26	74	43	53
4	Flensburg	26	58	33	47
5	Eckernförde	25	52	39	42
6	Preußen	26	48	38	41
7	Heider SV	26	55	47	39
8	Oldenburger	27	53	60	33
9	Neumunster	27	38	48	32
10	Lübeck	27	52	64	28
11	Nordmark	25	43	55	28
12	Hohenwestedt	26	30	64	27
13	Inter	27	54	71	26
14	Dornbreite	26	30	57	26
15	Bordesholm	27	35	80	21
16	Weiche	27	37	69	16

TEMPORADA 2022/2023

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Kilia Kiel	32	125	25	81
2	SV Eichede	32	63	23	75
3	Todesfelde	32	112	34	73
4	Union	32	111	39	66
5	Flensburg	32	75	46	60
6	Heider SV	32	78	68	55
7	Eckernförde	32	59	58	48
8	Lübeck	32	77	86	46
9	Inter	32	78	76	43
10	Bordesholm	32	55	67	37
11	Oldenburger	32	51	68	37
12	Weiche	32	51	76	30
13	Dornbreite	32	32	85	27
14	Frisia	32	33	94	24
15	Pansdorf	32	42	96	23
16	Husumer SV	32	41	95	23
17	Siebenbäume	32	37	84	21

TEMPORADA 2021/2022

REGIONALLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Phönix	10	26	5	45
2	Eintracht	10	20	4	39
3	Jeddeloh	12	17	10	38
4	Drochtersen	10	20	9	34
5	BSV Rehden	12	24	16	29
6	Pauli	10	15	16	26
7	LSK Hansa	12	8	18	22
8	Hannoversche	12	17	27	19
9	Altona 93	10	10	16	17
10	Oberneuland	12	14	33	16
11	Heider SV	10	13	30	12

TEMPORADA 2020/2021

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Weiche	9	18	6	24
2	Teutonia	10	17	13	16
3	Eintracht	9	14	11	16
4	Pauli	10	15	15	16
5	Hamburger	10	19	12	15
6	Drochtersen	9	14	8	15
7	Phönix	9	11	11	15
8	LSK Hansa	9	10	11	12
9	Holstein	10	10	19	9
10	Heider SV	8	4	19	4
11	Altona 93	7	5	12	3
12	Havelse	9	22	6	20
13	Werder	8	15	5	20
14	BSV Rehden	9	17	10	17
15	Oldenburg	8	12	8	14
16	Hannover	9	14	16	13
17	Jeddeloh	8	13	13	12
18	Oberneuland	10	9	15	12
19	Hildesheim	9	9	15	11
20	Wolfsburg	9	12	15	9
21	Hannoversche	10	14	24	6
22	Atlas	7	5	15	2

TEMPORADA 2019/2020

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	VfB Lübeck	25	64	24	61
2	Wolfsburg	24	72	27	56
3	Weiche	23	35	22	46
4	Drochtersen	25	37	33	44
5	Werder	25	40	37	40
6	Eintracht	24	40	33	39
7	Holstein	24	41	45	36
8	BSV Rehden	24	37	27	34
9	Oldenburg	23	40	42	34
10	Havelse	22	38	38	32
11	LSK Hansa	22	33	40	27
12	Pauli	24	34	33	26
13	Hannover	22	29	42	26
14	Hamburger	22	37	35	23
15	Jeddeloh	24	41	48	21
16	Altona 93	21	26	48	16
17	Heider SV	24	22	66	16
18	Hannoversche	24	20	46	15

TEMPORADA 2018/2019

OBERLIGA GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Altona 93	2	4	3	4
2	Heider SV	2	2	2	2
3	Bremer SV	2	3	4	1

TEMPORADA 2017/2018

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	NTSV Strand	30	80	32	73
2	Flensburg	30	80	38	66
3	Holstein	30	65	26	61
4	Weiche	30	85	40	59
5	SV Eichede	30	77	39	56
6	Todesfelde	30	64	39	44
7	Heider SV	30	50	42	43
8	Inter	30	71	69	43
9	Lägerdorf	30	62	68	40
10	Frisia	30	54	66	40
11	Neumunster	30	46	50	38
12	Schilksee	30	55	73	37
13	Union	30	51	70	28
14	Dornbreite	30	52	83	24
15	Friedrichsbe	30	44	99	14
16	Wankendorf	30	20	122	4

TEMPORADA 2016/2017

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Eutin 08	35	104	24	94
2	Holstein	34	73	34	70
3	Neumunster	35	77	45	67
4	NTSV Strand	35	80	51	64
5	Flensburg	34	85	48	62
6	Flensburg	35	80	52	62
7	Heider SV	35	75	48	61
8	Schilksee	35	76	49	57
9	Todesfelde	34	72	57	52
10	Lägerdorf	34	59	63	47
11	Frisia	34	54	68	43
12	Union	35	55	71	41
13	Hartenholm	35	57	74	38
14	Kropp	34	53	75	32
15	Oldenburger	34	52	95	31
16	Altenholz	34	37	89	28
17	Concordia	34	46	115	19
18	Kilia Kiel	34	32	109	13

TEMPORADA 2015/2016

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	SV Eichede	34	92	31	81
2	Eutin 08	34	108	46	76
3	Holstein	34	76	31	68
4	Flensburg	34	73	38	65
5	Todesfelde	34	78	55	62
6	Heider SV	34	59	46	58
7	Neumunster	34	62	44	55
8	Flensburg	34	90	68	52
9	Kropp	34	71	63	50
10	Altenholz	34	62	56	50
11	Union	34	54	62	43
12	Oldenburger	34	76	80	42
13	Kilia Kiel	34	43	64	39
14	Hartenholm	34	36	90	30
15	Henstedt-Ulz	34	38	98	29
16	Preetzer	34	45	76	28
17	TuRa Meldorf	34	38	88	24
18	Reher/Puls	34	40	105	15

TEMPORADA 2014/2015

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Schilksee	34	94	33	74
2	Holstein	34	90	38	72
3	SV Eichede	34	102	48	71
4	Eutin 08	34	70	45	64
5	Todesfelde	34	88	55	59
6	Kropp	34	81	54	59
7	Preetzer	34	65	60	53
8	Altenholz	34	68	71	51
9	Flensburg	34	90	76	47
10	Henstedt-Ulz	34	52	75	46
11	Hartenholm	34	62	75	45
12	Union	34	60	69	41
13	TuRa Meldorf	34	55	66	39
14	Heider SV	34	42	49	37
15	NTSV Strand	34	45	84	36
16	Dornbreite	34	48	93	33
17	Bordesholm	34	46	96	22
18	Angeln 02	34	34	105	15

TEMPORADA 2013/2014

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	VfB Lübeck	34	116	17	96
2	Preetzer	34	69	52	60
3	Union	34	77	48	59
4	Holstein	34	82	52	58
5	Altenholz	34	85	61	58
6	Kropp	34	78	61	54
7	Todesfelde	34	66	59	52
8	Flensburg	34	67	65	52
9	TuRa Meldorf	34	49	56	48
10	Heider SV	34	54	57	44
11	Schilksee	34	51	52	43
12	NTSV Strand	34	47	58	43
13	Hartenholm	34	48	65	40
14	Dornbreite	34	58	76	35
15	Husumer SV	34	51	76	33
16	Hagen	34	38	74	32
17	Eichede	34	35	76	29
18	Heikendorfer	34	33	99	17

TEMPORADA 2012/2013

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	SV Eichede	32	87	30	77
2	Holstein	32	98	21	73
3	Flensburg	32	91	45	73
4	Kropp	32	65	38	66
5	Preetzer	32	53	46	49
6	Todesfelde	32	56	62	49
7	Heider SV	32	33	52	42
8	NTSV Strand	32	42	39	41
9	Heikendorfer	32	41	40	40
10	Dornbreite	32	46	57	40
11	Altenholz	32	43	58	38
12	Lübeck	32	53	72	37
13	Hagen	32	50	66	36
14	TuRa Meldorf	32	43	62	35
15	Hartenholm	32	38	66	34
16	Henstedt-Ulz	32	46	81	27
17	Schleswig	32	40	90	17
18	Sylt	0	0	0	0

TEMPORADA 2011/2012

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Neumunster	34	88	29	80
2	Weiche	34	71	28	72
3	Holstein	34	97	34	71
4	SV Eichede	34	85	53	60
5	Lübeck	34	80	63	54
6	Kropp	34	61	55	54
7	NTSV Strand	34	71	56	53
8	Flensburg	34	60	52	52
9	Sylt	34	63	71	47
10	Preetzer	34	46	54	45
11	Todesfelde	34	79	73	42
12	Henstedt-Ulz	34	60	70	40
13	Heider SV	34	53	78	40
14	Heikendorfer	34	48	53	38
15	Eider	34	46	69	36
16	Husumer SV	34	51	97	29
17	Schackendorf	34	38	97	29
18	Breitenfelde	34	43	108	22

TEMPORADA 2010/2011

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Neumunster	34	74	20	82
2	SV Eichede	34	71	28	67
3	Sylt	34	80	36	63
4	Lübeck	34	75	55	59
5	NTSV Strand	34	73	55	56
6	Weiche	34	67	45	53
7	Holstein	34	62	44	53
8	Kropp	34	56	51	51
9	Henstedt-Ulz	34	76	52	48
10	Flensburg	34	59	64	47
11	Heikendorfer	34	56	70	47
12	Eider	34	38	57	42
13	Todesfelde	34	50	65	40
14	Heider SV	34	43	62	39
15	Union	34	60	89	34
16	Bordesholm	34	50	93	27
17	Eckernförde	34	29	80	21
18	Schleswig	34	46	99	21

TEMPORADA 2009/2010

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Holstein	34	106	27	82
2	Neumunster	34	76	29	75
3	SV Eichede	34	72	39	66
4	Eider	34	63	42	62
5	Henstedt-Ulz	34	77	54	59
6	Lübeck	34	80	43	56
7	Eckernförde	34	50	57	51
8	Flensburg	34	66	73	49
9	Weiche	34	45	37	44
10	Heider SV	34	49	42	42
11	Heikendorfer	34	56	57	42
12	Kropp	34	54	64	42
13	Schleswig	34	57	68	40
14	Union	34	58	68	39
15	Klausdorf	34	42	67	39
16	Comet Kiel	34	38	76	30
17	Altenholz	34	39	83	30
18	Itzehoe	34	32	134	9

TEMPORADA 2008/2009

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Holstein	34	92	26	77
2	Neumunster	34	89	31	75
3	Henstedt-Ulz	34	109	38	69
4	Heider SV	34	61	42	56
5	Eider	34	64	49	54
6	Comet Kiel	34	51	50	53
7	Heikendorfer	34	61	55	52
8	Lübeck	34	67	55	51
9	Schleswig	34	51	61	51
10	Flensburg	34	56	39	50
11	Itzehoe	34	55	59	42
12	Eckernförde	34	47	71	40
13	Kropp	34	43	56	38
14	Altenholz	34	50	71	38
15	Horst 1946	34	49	77	38
16	Husumer SV	34	44	76	26
17	Kilia Kiel	34	41	106	24
18	NTSV Strand	34	37	105	16

TEMPORADA 1973/1974

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eintracht	36	125	23	93
2	FC St Pauli	36	113	48	82
3	Osnabrück	36	84	43	68
4	Wolfsburg	36	77	51	65
5	Oldenburg	36	71	55	60
6	Barmbek-Uhle	36	48	38	58
7	Olympia	36	74	57	55
8	SV Meppen	36	55	54	51
9	Concordia	36	44	56	51
10	Arminia	36	57	59	49
11	Hannover	36	70	67	46
12	Göttingen	36	55	46	45
13	Holstein	36	54	73	42
14	Bremerhaven	36	35	61	42
15	Heider SV	36	48	76	31
16	VfB Lübeck	36	34	80	30
17	Itzehoer	36	48	107	28
18	Pinneberg	36	43	76	25
19	Phönix	36	40	105	23

TEMPORADA 1972/1973

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FC St Pauli	34	94	33	82
2	Osnabrück	34	75	41	75
3	Wolfsburg	34	71	35	65
4	Göttingen	34	60	36	61
5	VfB Lübeck	34	48	42	55
6	Barmbek-Uhle	34	47	35	52
7	Phönix	34	55	58	52
8	Holstein	34	63	47	49
9	Arminia	34	48	41	45
10	Oldenburg	34	54	73	40
11	SV Meppen	34	51	62	39
12	Olympia	34	47	55	35
13	Hannover	34	51	74	35
14	Heider SV	34	44	54	33
15	Itzehoer	34	27	58	33
16	Bremerhaven	34	40	60	31
17	TuS Celle	34	40	70	28
18	HSC Leu 06	34	37	78	27

Competiciones que juega

Grupo 7

Oberliga Grupo 7

Pos	Equipos		Pts
1		Todesfelde	66
2		SV Eichede	57
3		Union Neumünster	53
4		TSB Flensburg	47
5		Eckernförder SV	42
6		SV Preußen Reinfeld	41
7		Heider SV	39
8		Oldenburger SV	33
9		VfR Neumunster	32
10		VfB Lübeck II	28
11		Nordmark Satrup	28
12		Hohenwestedt	27
13		Inter Turkspor Kiel	26
14		Dornbreite Lübeck	26
15		Bordesholm	21
16		Weiche Flensburg 08 II	16

	Ascenso : Todesfelde
	Descenso : Dornbreite Lübeck, Bordesholm, Weiche Flensburg 08 II

RIVALES EN Oberliga

USO DE MEMORIA

7,200,224 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6432
Total Execution Time	0.6445

CADENA URL

/historico/Heider-Sv

GET DATOS

$_GET['/historico/Heider-Sv']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17117 AND type_rel = 2
0.0167	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 = '17117' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=17117 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0149	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 (72559,67320) 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 = 72559 AND teamId = 17117
0.0168	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 17117
0.0148	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 = '17117' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17117' and rp.type = 4
0.0148	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 = '17117' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 72559 WHERE rp.league_id = 72559 AND rp.teamId = 17117 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.0174	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 = 72559 WHERE rp.league_id = 72559 AND rp.teamId = 17117 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0186	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 = 72559 WHERE rp.league_id = 72559 AND rp.teamId = 17117 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169	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 = 17117 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0165	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* `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 = 72559 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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* `tables2023` 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 = 68312 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.0153	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 = 63377 AND t.round = 22 ORDER BY team.conference ASC,t.position 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* `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 = 66875 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 58547 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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* `tables2020` 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 = 50103 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 44493 AND t.round = 30 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* `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 = 49768 AND t.round = 3 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* `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 = 39084 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 34100 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 15545 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* `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 = 4376 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 3539 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* `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 = 19813 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* `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 = 19825 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168	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 = 19839 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161	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 = 19852 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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* `tables2009` 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 = 19861 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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* `tables1974` 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 = 22726 AND t.round = 38 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* `tables1973` 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 = 22728 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Heider SV

Heider SV

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 7

RIVALES EN Oberliga