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

Rödinghausen

Temporada 2023/2024

TEMPORADA 2023/2024

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alemannia	32	62	30	72
2	Wuppertaler	32	66	42	59
3	FC Bocholt	32	45	28	59
4	Fortuna	32	58	36	55
5	Schalke	32	62	46	50
6	Rödinghause	32	44	39	48
7	Rot-Weiß	32	50	33	47
8	Wiedenbrück	32	43	44	47
9	Düren	32	55	45	46
10	Köln II	32	49	46	46
11	Fortuna	32	46	44	43
12	Mönchenglad	32	51	56	38
13	Gutersloh	32	38	57	38
14	Paderborn	32	50	50	37
15	Lippstadt	32	39	62	31
16	Velbert	32	35	68	29
17	Wegberg-Beec	32	40	70	26
18	Weiss Ahlen	32	35	72	25

TEMPORADA 2022/2023

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Preußen	34	89	39	79
2	Wuppertaler	34	77	47	66
3	Mönchenglad	34	73	47	66
4	Rödinghause	34	59	35	58
5	Kaan-Marienb	34	59	54	55
6	Fortuna	34	48	43	54
7	Rot-Weiß	34	61	51	53
8	Alemannia	34	50	43	53
9	Schalke	34	65	53	49
10	Düren	34	51	56	48
11	Lippstadt	34	51	56	46
12	Wiedenbrück	34	50	47	41
13	Fortuna	34	50	64	39
14	Köln II	34	45	62	38
15	FC Bocholt	34	49	70	36
16	Weiss Ahlen	34	53	82	29
17	Wattenscheid	34	45	90	27
18	SV Straelen	34	31	67	17

TEMPORADA 2021/2022

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Rot-Weiss	38	84	32	87
2	Preußen	38	73	24	87
3	Wuppertaler	38	68	28	78
4	Rot-Weiß	38	68	35	75
5	Fortuna	38	62	31	74
6	Rödinghause	38	45	35	64
7	Köln II	38	70	49	62
8	Wiedenbrück	38	48	37	55
9	Schalke	38	58	65	47
10	Weiss Ahlen	38	50	67	47
11	Fortuna	38	59	62	46
12	Alemannia	38	43	51	44
13	Mönchenglad	38	42	51	43
14	Lippstadt	38	54	65	43
15	SV Straelen	38	42	64	43
16	Bonner SC	38	44	63	39
17	Wegberg-Beec	38	31	64	31
18	Sportfreunde	38	36	63	30
19	Uerdingen	38	39	96	27
20	Homberg	38	30	64	26

TEMPORADA 2020/2021

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dortmund	40	94	31	93
2	Rot-Weiss	40	90	28	90
3	Preußen	40	70	39	78
4	Fortuna	40	66	48	66
5	Köln II	40	66	55	61
6	Rödinghause	40	52	39	59
7	Rot-Weiß	40	61	50	59
8	Schalke	40	59	56	57
9	Fortuna	40	67	53	56
10	Wiedenbrück	40	55	50	56
11	Mönchenglad	40	49	55	55
12	Wuppertaler	40	57	62	54
13	SV Straelen	40	45	61	47
14	Alemannia	40	35	48	45
15	Sportfreunde	40	47	72	44
16	Lippstadt	40	37	63	40
17	Wegberg-Beec	40	36	62	39
18	Weiss Ahlen	40	50	69	38
19	Bonner SC	40	39	66	38
20	Homberg	40	40	75	35
21	Bergisch	40	36	69	33

TEMPORADA 2019/2020

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Rödinghause	27	68	21	64
2	Rot-Weiss	25	45	25	54
3	Verl	23	51	16	53
4	Rot-Weiß	23	42	21	46
5	Alemannia	25	43	35	38
6	Köln II	24	41	31	36
7	Mönchenglad	25	49	47	36
8	Dortmund	25	43	39	34
9	Sportfreunde	23	37	34	34
10	Schalke	25	31	27	31
11	Fortuna	25	36	43	30
12	Fortuna	23	20	27	30
13	Bonner SC	25	28	43	25
14	Wuppertaler	23	29	48	23
15	TuS Haltern	24	28	51	23
16	Lippstadt	22	21	43	19
17	Bergisch	24	18	53	18
18	Homberg	26	22	52	17
19	Wattenscheid	13	20	16	16

TEMPORADA 2018/2019

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Viktoria	34	62	30	67
2	Rot-Weiß	34	58	41	64
3	Rödinghause	34	58	29	63
4	Mönchenglad	34	47	38	57
5	Dortmund	34	62	36	56
6	Alemannia	34	48	39	49
7	Verl	34	51	46	46
8	Rot-Weiss	34	42	40	46
9	Köln II	34	54	46	45
10	Wuppertaler	34	45	49	44
11	Wattenscheid	34	44	44	43
12	Fortuna	34	47	62	42
13	Lippstadt	34	36	48	41
14	Bonner SC	34	42	51	40
15	Kaan-Marienb	34	50	54	39
16	SV Straelen	34	36	62	39
17	Wiedenbrück	34	42	52	38
18	Herkenrath	34	34	91	15

TEMPORADA 2017/2018

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Uerdingen	34	68	24	76
2	Viktoria	34	85	36	72
3	Wuppertaler	34	61	47	56
4	Dortmund	34	55	46	55
5	Rödinghause	34	76	63	53
6	Alemannia	34	59	47	53
7	Wiedenbrück	34	55	48	52
8	Verl	34	47	33	50
9	Rot-Weiß	34	50	41	50
10	Rot-Weiss	34	55	43	49
11	Wattenscheid	34	58	52	45
12	Mönchenglad	34	49	49	43
13	Bonner SC	34	47	62	38
14	Köln II	34	49	62	37
15	Fortuna	34	42	59	36
16	Wegberg-Beec	34	37	78	28
17	Erndtebrück	34	28	67	26
18	Westfalia	34	29	93	19

TEMPORADA 2016/2017

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Viktoria	34	91	42	72
2	Dortmund	34	54	25	63
3	Mönchenglad	34	71	42	62
4	Rot-Weiß	34	69	50	59
5	Alemannia	34	51	39	59
6	Rot-Weiss	34	48	35	55
7	Köln II	34	59	54	51
8	Wattenscheid	34	51	44	50
9	Bonner SC	34	60	61	48
10	Rödinghause	34	55	57	48
11	Wuppertaler	34	47	47	42
12	Fortuna	34	44	51	41
13	Verl	34	37	49	40
14	Wiedenbrück	34	43	52	39
15	Weiss Ahlen	34	43	66	32
16	Schalke	34	32	48	30
17	Sprockhövel	34	31	73	24
18	Siegen	34	31	82	21

TEMPORADA 2015/2016

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Sportfreunde	36	67	23	83
2	Mönchenglad	36	80	46	68
3	Viktoria	36	66	36	63
4	Dortmund	36	57	36	60
5	Rot-Weiß	36	58	44	59
6	Fortuna	36	63	51	59
7	Alemannia	36	52	43	56
8	Wattenscheid	36	61	52	55
9	Schalke	36	44	44	51
10	Verl	36	43	46	51
11	Wiedenbrück	36	50	45	50
12	Rot-Weiss	36	48	49	48
13	Weiss Ahlen	36	56	60	46
14	Rödinghause	36	43	42	43
15	Köln II	36	44	51	41
16	Velbert	36	38	65	36
17	Erndtebrück	36	42	68	32
18	Kray	36	36	81	18
19	Wegberg-Beec	36	30	96	16

TEMPORADA 2014/2015

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mönchenglad	34	77	43	69
2	Alemannia	34	56	20	68
3	Viktoria	34	70	29	66
4	Rot-Weiß	34	54	37	57
5	Sportfreunde	34	56	33	56
6	Rot-Weiss	34	58	38	56
7	Verl	34	53	32	54
8	Rödinghause	34	48	44	49
9	Fortuna	34	39	52	49
10	Köln II	34	38	47	42
11	Schalke	34	38	41	41
12	Wiedenbrück	34	39	54	40
13	Wattenscheid	34	42	58	39
14	Kray	34	39	61	39
15	Uerdingen	34	34	63	34
16	Bochum	34	46	58	30
17	Siegen	34	33	56	30
18	Hennef 05	34	26	80	18

TEMPORADA 2013/2014

OBERLIGA GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Arminia	34	87	33	86
2	Rödinghause	34	80	33	72
3	SpVgg	34	78	39	70
4	Neuenkirchen	34	81	50	64
5	Erndtebrück	34	54	44	55
6	Roland	34	50	52	55
7	Westfalia	34	43	38	48
8	Eintracht	34	57	61	48
9	Weiss Ahlen	34	54	62	48
10	Gutersloh	34	49	57	45
11	Sprockhövel	34	48	53	44
12	Ennepetal	34	59	50	43
13	Hammer SpVg	34	56	65	42
14	Zweckel	34	47	65	41
15	Westfalia	34	39	65	29
16	Hüls	34	40	69	29
17	Heven	34	41	88	25
18	Dornberg	34	30	69	16

Competiciones que juega

Grupo 2

Regionalliga Grupo 2

Pos	Equipos		Pts
1		Alemannia Aachen	72
2		Wuppertaler SV	59
3		FC Bocholt	59
4		Fortuna Köln	55
5		Schalke 04 II	50
6		Rödinghausen	48
7		Rot-Weiß Oberhausen	47
8		Wiedenbrück	47
9		Düren	46
10		Köln II	46
11		Fortuna Düsseldorf II	43
12		B. Mönchengladbach II	38
13		Gutersloh	38
14		Paderborn 07 II	37
15		Lippstadt 08	31
16		Velbert	29
17		Wegberg-Beeck	26
18		Rot Weiss Ahlen	25

	Ascenso : Alemannia Aachen
	Descenso : Velbert, Wegberg-Beeck, Rot Weiss Ahlen

RIVALES EN Regionalliga

USO DE MEMORIA

6,502,744 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.5817
Total Execution Time	0.5830

CADENA URL

/historico/Rodinghausen

GET DATOS

$_GET['/historico/Rodinghausen']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0155	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 = 'Rodinghausen' 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.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=9272 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=9272 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=9272 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9272 AND type_rel = 2
0.0152	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9272 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147	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 (529553,688246) ORDER BY n.cover_points DESC, update_date DESC
0.0149	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 = '9272' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152	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 = '9272' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72582 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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=9272 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (72582,71432,67716) 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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 72582 AND teamId = 9272
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 67716 AND teamId = 9272
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9272
0.0294	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 = 72582 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0157	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 = 72582 WHERE rp.league_id = 72582 AND rp.teamId = 9272 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 72582 WHERE rp.league_id = 72582 AND rp.teamId = 9272 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 = 72582 WHERE rp.league_id = 72582 AND rp.teamId = 9272 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 9272 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68048 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.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* `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 = 63325 AND t.round = 38 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* `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 = 57407 AND t.round = 42 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* `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 = 50106 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 43944 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* `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 = 38889 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* `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 = 33767 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* `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 = 15532 AND t.round = 38 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 = 3906 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 = 9577 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Rödinghausen

Rödinghausen

Selecciona un equipo

Competiciones que juega

Regionalliga Grupo 2

RIVALES EN Regionalliga