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

Rotenburger SV

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Kickers	27	75	22	68
2	Atlas	29	56	39	53
3	Hildesheim	28	55	38	52
4	Bersenbrück	28	66	43	51
5	Germania	28	49	36	50
6	BSV Rehden	28	45	35	46
7	Lupo-Martini	29	50	43	46
8	Vorsfelde	28	44	41	46
9	Heeslinger	27	44	39	40
10	Oldenburg	29	48	50	39
11	Meppen	30	42	50	39
12	Schöningen	29	47	62	33
13	Arminia	27	37	50	27
14	Ramlingen	29	39	60	27
15	Rotenburger	26	29	48	26
16	Eintracht	26	41	56	25
17	Blau Weiss.	28	30	56	20
18	STK Eilvese	28	30	59	15

TEMPORADA 2022/2023

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Spelle-Venha	34	80	36	77
2	Lupo-Martini	34	69	28	74
3	Germania	34	73	40	65
4	Bersenbrück	34	85	55	60
5	Schöningen	34	72	54	57
6	Heeslinger	34	59	45	57
7	Oldenburg	34	73	53	56
8	Eintracht	34	78	75	49
9	Rotenburger	34	48	41	45
10	Ramlingen	34	59	61	44
11	Arminia	34	58	65	43
12	Hannoversche	34	50	72	41
13	Pattensen	34	54	76	38
14	MTV Gifhorn	34	52	71	35
15	Ahlerstedt	34	51	75	35
16	LSK Hansa	34	37	60	32
17	Braunschweig	34	41	84	26
18	Papenburg	34	46	94	24

TEMPORADA 2021/2022

OBERLIGA GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Eintracht	10	27	11	34
2	Rotenburger	10	16	9	34
3	Bersenbrück	10	22	12	32
4	MTV Gifhorn	10	17	14	25
5	Wolfenbütte	10	13	16	24
6	Göttingen	10	11	18	22
7	TB Uphusen	10	14	22	22
8	Schwalbe	10	18	20	17
9	Eintracht	10	15	23	17
10	Hagen/Uthled	10	12	20	15

TEMPORADA 2020/2021

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	BW Lohne	8	22	5	20
2	Spelle-Venha	7	20	6	18
3	Heeslinger	6	17	7	14
4	Kickers	8	15	13	13
5	Oldenburg	7	9	10	11
6	TB Uphusen	8	11	17	10
7	Rotenburger	8	7	12	6
8	Hagen/Uthled	8	6	22	5
9	Bersenbrück	8	9	14	4
10	Eintracht	8	14	24	4
11	Ramlingen	9	18	9	17
12	Germania	8	13	4	17
13	Lupo-Martini	9	17	15	16
14	MTV Gifhorn	9	14	16	13
15	Göttingen	9	14	9	12
16	Schwalbe	9	14	13	12
17	Wolfenbütte	9	9	13	10
18	Arminia	7	11	12	8
19	Eintracht	8	6	18	8
20	Braunschweig	9	5	12	4

TEMPORADA 2019/2020

LANDESLIGA GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Rotenburger	18	50	26	41
2	Treubund	18	46	18	38
3	Harsefeld	18	33	18	33
4	Ahlerstedt	17	44	29	31
5	Drochtersen/	18	42	35	30
6	Güldenstern	19	40	42	27
7	Lüneburg	16	28	24	26
8	Verden	19	32	30	26
9	Ottersberg	18	39	41	24
10	Blau Weiss.	19	37	42	23
11	Westercelle	19	36	36	21
12	Hedendorf/Ne	19	38	53	21
13	Gellersen	17	27	33	20
14	Eintracht	18	28	44	20
15	Teutonia	18	28	36	16
16	Emmendorf	17	20	61	6

TEMPORADA 2018/2019

LANDESLIGA GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Eintracht	30	106	35	70
2	Harsefeld	30	64	38	60
3	Ahlerstedt	30	73	36	56
4	Treubund	30	60	36	53
5	Rotenburger	30	50	33	53
6	Eintracht	30	67	61	50
7	Teutonia	30	56	55	45
8	Güldenstern	30	63	59	44
9	Blau Weiss.	30	52	49	43
10	Emmendorf	30	49	56	41
11	Verden	30	52	53	40
12	Gellersen	30	53	53	39
13	Drochtersen/	30	45	62	39
14	Winsen/Luhe	30	44	80	25
15	Meckelfeld	30	23	74	21
16	TuSG	30	33	110	8

TEMPORADA 2017/2018

LANDESLIGA GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Hagen/Uthled	30	91	39	72
2	Treubund	30	76	25	66
3	Blau Weiss.	30	60	42	50
4	Emmendorf	30	54	55	49
5	Rotenburger	30	36	30	48
6	Eintracht	30	45	42	44
7	Harsefeld	30	43	44	43
8	TuSG	30	45	69	41
9	Ahlerstedt	30	55	52	39
10	Meckelfeld	30	45	45	37
11	Drochtersen/	30	47	53	37
12	Teutonia	30	67	67	35
13	Ottersberg	30	40	56	33
14	TSV Etelsen	30	65	83	32
15	Westercelle	30	40	64	32
16	Cuxhaven	30	40	83	15

TEMPORADA 2016/2017

LANDESLIGA GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Eintracht	30	77	34	65
2	Harsefeld	30	54	31	60
3	Hagen/Uthled	30	75	38	58
4	Treubund	30	63	36	57
5	TSV Etelsen	30	60	43	48
6	Cuxhaven	30	57	50	47
7	Teutonia	30	69	55	45
8	Drochtersen/	30	46	59	42
9	Eintracht	30	53	44	41
10	Meckelfeld	30	52	57	39
11	Ottersberg	30	40	49	39
12	Rotenburger	30	49	44	38
13	Verden	30	53	78	36
14	Bodenteich	30	27	45	32
15	Pennigbütte	30	31	86	15
16	Stinstedt	30	39	96	13

TEMPORADA 2015/2016

LANDESLIGA GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Blau Weiss.	32	105	48	71
2	Hagen/Uthled	32	83	41	66
3	Eintracht	32	64	37	61
4	Rotenburger	32	55	46	58
5	Cuxhaven	32	63	50	52
6	Ottersberg	32	50	60	47
7	Harsefeld	32	59	46	46
8	Eintracht	32	52	48	46
9	Treubund	32	53	47	45
10	TSV Etelsen	32	62	43	43
11	Verden	32	75	58	43
12	Drochtersen/	32	62	60	43
13	Jahn	32	74	61	42
14	Ahlerstedt	32	43	60	37
15	TuS Celle	32	43	91	30
16	TuS Zeven	32	42	91	20
17	Dannenberg	32	24	122	12

TEMPORADA 2014/2015

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Drochtersen	30	79	30	71
2	Hildesheim	30	61	23	62
3	Jeddeloh	30	69	41	61
4	Germania	30	51	42	48
5	Eintracht	30	61	55	47
6	Spelle-Venha	30	67	53	45
7	Lupo-Martini	30	55	44	44
8	Wunstorf	30	56	51	44
9	Osnabrück	30	54	54	44
10	Arminia	30	47	50	44
11	TB Uphusen	30	59	65	41
12	Teutonia	30	39	49	37
13	Oldenburg	30	46	57	32
14	Ottersberg	30	29	66	23
15	Rotenburger	30	40	75	17
16	Göttingen	30	32	90	16

TEMPORADA 2013/2014

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	LSK Hansa	30	77	35	66
2	Braunschweig	30	56	31	60
3	Lupo-Martini	30	56	42	51
4	Osnabrück	30	63	41	46
5	Germania	30	62	53	46
6	Drochtersen	30	46	37	46
7	Wunstorf	30	56	55	46
8	Hildesheim	30	48	33	45
9	TB Uphusen	30	54	52	43
10	Jeddeloh	30	54	55	41
11	Ottersberg	30	32	36	37
12	Oldenburg	30	40	45	37
13	Rotenburger	30	37	50	37
14	Göttingen	30	38	66	34
15	Bückeburg	30	38	72	28
16	TuS Celle	30	23	77	10

TEMPORADA 2012/2013

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Eintracht	30	85	31	68
2	Lupo-Martini	30	63	37	58
3	LSK Hansa	30	74	48	57
4	Heeslingen	30	59	42	54
5	Drochtersen	30	50	29	50
6	Germania	30	62	61	49
7	Osnabrück	30	59	37	48
8	Jeddeloh	30	55	59	44
9	Göttingen	30	46	44	40
10	Hildesheim	30	47	63	40
11	Holthausen-B	30	38	52	37
12	Bückeburg	30	47	65	30
13	Rotenburger	30	33	57	29
14	Ottersberg	30	30	54	27
15	TuS Celle	30	43	69	23
16	Langenhagen	30	35	78	21

TEMPORADA 2011/2012

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Goslarer SC	30	69	23	69
2	Cloppenburg	30	74	33	65
3	Oldenburg	30	54	27	62
4	BSV Rehden	30	80	28	60
5	Osnabrück	30	57	40	47
6	Holthausen-B	30	60	49	45
7	Heeslingen	30	37	49	44
8	Eintracht	30	65	43	43
9	Ottersberg	30	51	51	40
10	Langenhagen	30	41	51	40
11	LSK Hansa	30	53	59	38
12	Hildesheim	30	36	49	36
13	Göttingen	30	33	51	31
14	Bückeburg	30	33	79	21
15	Osterholz	30	29	78	20
16	Rotenburger	30	27	89	14
17	Kickers	0	0	0	0
18	Eintracht	0	0	0	0

TEMPORADA 2008/2009

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Goslarer SC	34	91	35	83
2	Osterholz	34	84	39	70
3	Eintracht	34	78	37	69
4	LSK Hansa	34	83	48	65
5	Heeslingen	34	91	57	64
6	Ottersberg	34	71	50	59
7	Drochtersen	34	61	49	57
8	MTV Gifhorn	34	69	52	55
9	Eintracht	34	59	59	50
10	Olper	34	51	52	44
11	Braunschweig	34	51	56	43
12	Güldenstern	34	42	50	39
13	Blau Weiss.	34	54	82	36
14	TuS Celle	34	68	89	34
15	Weende	34	49	95	27
16	Rotenburger	34	43	102	27
17	Vorsfelde	34	37	80	23
18	Maschen	34	38	88	19

Competiciones que juega

Grupo 6

Oberliga Grupo 6

Pos	Equipos		Pts
1		BSV Kickers Emden	68
2		Atlas Delmenhorst	53
3		VfV 06 Hildesheim	52
4		TuS Bersenbrück	51
5		Germania Egestorf	50
6		BSV Rehden	46
7		Lupo-Martini	46
8		Vorsfelde	46
9		Heeslinger SC	40
10		VfL Oldenburg	39
11		SV Meppen II	39
12		FSV Schöningen	33
13		Arminia Hannover	27
14		Ramlingen / Ehlershausen	27
15		Rotenburger SV	26
16		MTV Eintracht Celle	25
17		Blau Weiss Bornreihe	20
18		STK Eilvese	15

	Ascenso : BSV Kickers Emden
	Playoff Ascenso : Atlas Delmenhorst
	Descenso : Rotenburger SV, MTV Eintracht Celle, Blau Weiss Bornreihe, STK Eilvese

RIVALES EN Oberliga

USO DE MEMORIA

6,703,952 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.2248
Total Execution Time	0.2268

CADENA URL

/historico/Rotenburger-Sv

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0050	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 = 'Rotenburger-Sv' AND l.year = 2024 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.0018	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=17140 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=17140 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=17140 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17140 AND type_rel = 2
0.0039	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 = '17140' ORDER BY l.year DESC,cat.coefficient DESC
0.0035	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 = '17140' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0048	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 = '17140' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0053	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=17140 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0026	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 (72558,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.0086	SELECT count(id) as num_players from rel_players WHERE league_id = 72558 AND teamId = 17140
0.0063	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17140
0.0021	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 = '17140' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0030	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17140' and rp.type = 4
0.0022	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 = '17140' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0131	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 = 72558 WHERE rp.league_id = 72558 AND rp.teamId = 17140 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.0104	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 = 72558 WHERE rp.league_id = 72558 AND rp.teamId = 17140 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0077	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 = 72558 WHERE rp.league_id = 72558 AND rp.teamId = 17140 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0054	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 = 17140 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0060	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 = 72558 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0051	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 = 68056 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.0060	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 = 63362 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 66716 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0071	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 = 58500 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0065	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 = 50527 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041	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 = 48750 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039	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 = 46658 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0052	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 = 46828 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042	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 = 46846 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048	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 = 4248 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 3540 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046	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 = 19811 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048	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 = 19827 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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 = 19859 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Rotenburger SV

Rotenburger SV

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 6

RIVALES EN Oberliga