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

Rot Weiss Ahlen

Entrenador: Andreas Zimmermann

Temporada 2023/2024

TEMPORADA 2023/2024

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alemannia	32	62	30	72
2	FC Bocholt	32	45	28	59
3	Wuppertaler	31	66	42	58
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	31	46	44	42
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

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Wiedenbrück	20	35	23	41
2	Meinerzhagen	20	41	18	39
3	Weiss Ahlen	18	30	17	36
4	Paderborn	22	40	36	34
5	Eintracht	20	38	29	32
6	Holzwickeder	20	39	38	31
7	Kaan-Marienb	21	40	30	30
8	Ennepetal	20	39	34	30
9	Gutersloh	21	28	27	29
10	Schermbeck	21	26	29	29
11	Westfalia	18	28	15	28
12	Preußen	20	30	28	28
13	Dortmund	21	30	30	27
14	Westfalia	21	29	37	24
15	Siegen	19	34	33	22
16	Sprockhövel	21	25	40	19
17	Erndtebrück	21	26	55	14
18	Hammer SpVg	20	15	54	5

TEMPORADA 2018/2019

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Schalke	34	93	21	85
2	TuS Haltern	34	63	26	70
3	Dortmund	34	60	37	64
4	Sprockhövel	34	73	53	51
5	Westfalia	34	50	53	49
6	Paderborn	34	70	64	46
7	Westfalia	34	58	60	45
8	Schermbeck	34	43	55	45
9	Weiss Ahlen	34	61	62	44
10	Gutersloh	34	48	61	44
11	Holzwickeder	34	52	55	42
12	Hammer SpVg	34	49	58	42
13	Siegen	34	42	59	42
14	Ennepetal	34	44	57	41
15	Erndtebrück	34	49	56	40
16	Eintracht	34	47	81	40
17	Brünninghau	34	42	62	37
18	Gievenbeck	34	40	64	29

TEMPORADA 2017/2018

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Lippstadt	30	56	33	60
2	Kaan-Marienb	30	47	29	60
3	Dortmund	30	70	44	59
4	Hammer SpVg	30	64	31	55
5	TuS Haltern	30	44	36	54
6	Schalke	30	51	24	53
7	Brünninghau	30	62	55	50
8	Eintracht	30	54	62	41
9	Westfalia	30	52	56	37
10	Sprockhövel	30	52	58	35
11	Siegen	30	46	54	33
12	Ennepetal	30	41	59	32
13	Paderborn	30	50	57	29
14	Weiss Ahlen	30	41	58	29
15	Arminia	30	33	67	23
16	Gutersloh	30	24	64	21
17	Marl Hüls	0	0	0	0
18	SC Hassel	0	0	0	0

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

OBERLIGA GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Erndtebrück	33	71	22	70
2	Weiss Ahlen	33	70	39	67
3	Westfalia	33	72	33	64
4	Roland	33	60	35	64
5	SpVgg	33	53	32	58
6	Lippstadt	33	63	35	57
7	Arminia	33	61	54	48
8	Stadtlohn	33	51	58	48
9	Hammer SpVg	33	43	56	43
10	Ennepetal	33	47	56	42
11	Eintracht	33	50	62	40
12	Dortmund	33	54	71	39
13	Gutersloh	33	37	50	38
14	Neuenkirchen	33	42	65	33
15	Sprockhövel	33	36	62	31
16	Hüls	33	50	73	30
17	Westfalia	33	38	66	28
18	Zweckel	33	30	59	26

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

TEMPORADA 2012/2013

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Lippstadt	34	75	25	75
2	Wattenscheid	34	70	37	73
3	Arminia	34	70	35	66
4	Erndtebrück	34	68	47	63
5	SpVgg	34	63	42	60
6	Westfalia	34	61	52	52
7	Neuenkirchen	34	60	62	47
8	Gutersloh	34	46	48	46
9	Weiss Ahlen	34	51	62	46
10	Sprockhövel	34	41	40	45
11	Roland	34	53	66	44
12	Hammer SpVg	34	46	51	39
13	Heven	34	51	67	38
14	Ennepetal	34	50	64	36
15	Dornberg	34	53	69	33
16	Westfalia	34	44	66	33
17	Schermbeck	34	44	79	31
18	Gievenbeck	34	32	66	18

TEMPORADA 2011/2012

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Viktoria	34	102	27	79
2	Siegen	34	75	23	78
3	Duisburg	34	67	30	65
4	Velbert	34	76	51	62
5	Arminia	34	80	60	58
6	Alemannia	34	62	46	58
7	Hüls	34	58	38	56
8	Uerdingen	34	56	50	56
9	Bergisch	34	76	38	55
10	Schwarz-Weis	34	59	51	55
11	Westfalia	34	54	59	45
12	Dornberg	34	45	66	38
13	Schermbeck	34	55	85	35
14	Speldorf	34	53	77	34
15	Erndtebrück	34	43	73	31
16	Homberg	34	35	64	29
17	Weiss Ahlen	34	28	90	18
18	Westfalia	34	13	109	12

TEMPORADA 2010/2011

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Eintracht	38	81	22	85
2	Hansa	38	70	36	78
3	Dynamo	38	55	37	65
4	Wehen	38	55	39	64
5	Rot-Weiss	38	63	45	61
6	Saarbrücken	38	61	51	59
7	Kickers	38	52	45	57
8	Jahn	38	35	41	52
9	Heidenheim	38	59	58	51
10	Stuttgart	38	48	48	51
11	TuS Koblenz	38	38	46	49
12	Sandhausen	38	43	46	46
13	Babelsberg	38	39	47	46
14	Unterhaching	38	39	55	45
15	Carl Zeiss.	38	43	62	44
16	Weiss Ahlen	38	45	69	42
17	VfR Aalen	38	40	52	41
18	Wacker	38	46	66	37
19	Werder	38	33	56	36
20	Bayern	38	30	54	30

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

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	SC Freiburg	34	60	36	68
2	Mainz 05	34	62	37	63
3	Nürnberg	34	51	29	60
4	Alemannia	34	58	38	56
5	Greuther	34	60	46	56
6	Duisburg	34	56	36	55
7	Kaiserslaute	34	53	48	52
8	FC St Pauli	34	52	59	48
9	Rot-Weiß	34	35	54	42
10	TuS Koblenz	34	47	57	41
11	Weiss Ahlen	34	38	57	41
12	FC Augsburg	34	43	46	40
13	1860	34	44	46	39
14	Hansa	34	52	53	38
15	Frankfurt	34	34	47	38
16	Osnabrück	34	41	60	36
17	Ingolstadt	34	38	54	31
18	Wehen	34	28	49	27

TEMPORADA 2007/2008

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Weiss Ahlen	36	73	41	67
2	Rot-Weiß	36	64	32	66
3	Fortuna	36	49	29	64
4	Union Berlin	36	67	49	60
5	Werder	36	52	43	59
6	Wuppertaler	36	60	50	58
7	Rot-Weiss	36	70	46	56
8	Dynamo	36	45	39	55
9	Kickers	36	43	39	54
10	Eintracht	36	55	50	53
11	Magdeburg	36	39	37	53
12	Rot-Weiss	36	42	36	51
13	Dortmund	36	35	37	48
14	Energie	36	31	44	44
15	Babelsberg	36	33	53	34
16	VfB Lübeck	36	32	58	34
17	Hamburger	36	36	58	33
18	Verl	36	31	55	32
19	Wolfsburg	36	20	81	22

TEMPORADA 2006/2007

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos

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

Grupo 2

Regionalliga Grupo 2

Pos	Equipos		Pts
1		Alemannia Aachen	72
2		FC Bocholt	59
3		Wuppertaler SV	58
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	42
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

7,833,304 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6923
Total Execution Time	0.6935

CADENA URL

/historico/Rot-Weiss-Ahlen

GET DATOS

$_GET['/historico/Rot-Weiss-Ahlen']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0158	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 = 'Rot-Weiss-Ahlen' 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=2184 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=2184 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=2184 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2184 AND type_rel = 2
0.0151	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 = '2184' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0154	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 = '2184' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	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=2184 AND l.year in (2023,2024,2025) 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 (72582,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.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 72582 AND teamId = 2184
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2184
0.0291	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.0167	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 = 2184 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.0161	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 = 2184 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 2184 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	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 = 2184 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 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* `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.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 = 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.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* `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.0164	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 = 50470 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.0163	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 = 44367 AND t.round = 34 ORDER BY team.conference 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* `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 = 39085 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* `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.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* `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.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* `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 = 9468 AND t.round = 33 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
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* `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 = 19817 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* `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 = 19829 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 = 1187 AND t.round = 38 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* `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.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* `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 = 451 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* `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 = 16437 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* `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 = 16441 AND t.round = 38 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* `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

Rot Weiss Ahlen

Rot Weiss Ahlen

Selecciona un equipo

Competiciones que juega

Regionalliga Grupo 2

RIVALES EN Regionalliga