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

Sprockhövel

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Sportfreunde	30	79	28	67
2	Türkspor	29	71	37	62
3	Dortmund	29	52	31	58
4	SpVgg	29	67	46	54
5	Gievenbeck	29	51	30	49
6	SpVgg Vreden	29	48	36	46
7	Schermbeck	29	55	55	45
8	Preußen	28	50	33	44
9	Siegen	29	55	41	43
10	Finnentrop/B	29	59	70	40
11	Ennepetal	29	42	58	34
12	Westfalia	29	40	53	32
13	Wattenscheid	29	40	59	30
14	Eintracht	29	41	66	29
15	Bovinghausen	29	33	73	26
16	Victoria	29	35	56	25
17	Sprockhövel	30	41	63	22
18	Brünninghau	28	35	59	22

TEMPORADA 2022/2023

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Gutersloh	34	67	38	72
2	Preußen	34	82	46	65
3	Paderborn	34	53	23	64
4	Sportfreunde	34	64	43	60
5	Bovinghausen	34	73	59	53
6	Westfalia	34	52	48	52
7	Dortmund	34	51	55	49
8	Victoria	34	53	48	48
9	Finnentrop/B	34	66	56	47
10	Eintracht	34	52	60	46
11	SpVgg Vreden	34	59	67	43
12	Schermbeck	34	43	56	39
13	Gievenbeck	34	48	50	36
14	Siegen	34	50	54	35
15	Sprockhövel	34	48	69	35
16	Ennepetal	34	32	59	35
17	Erndtebrück	34	47	85	34
18	Delbrücker	34	47	71	32

TEMPORADA 2021/2022

OBERLIGA GRUPO 28
Equipo		PJ	GF	GC	Puntos
1	SpVgg Vreden	10	23	12	20
2	Meinerzhagen	10	17	12	19
3	Victoria	10	23	12	18
4	Preußen	10	27	19	16
5	Finnentrop/B	10	24	18	16
6	Holzwickeder	10	21	18	16
7	Ennepetal	10	18	20	14
8	Sprockhövel	10	17	11	13
9	Hammer SpVg	10	15	19	12
10	TuS Haltern	10	9	24	6
11	Westfalia	10	10	39	3

TEMPORADA 2020/2021

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Gutersloh	9	16	3	25
2	Holzwickeder	6	20	4	18
3	Westfalia	8	21	10	18
4	Sprockhövel	7	19	10	18
5	Dortmund	9	21	17	18
6	Kaan-Marienb	7	27	7	16
7	Meinerzhagen	8	18	11	15
8	SpVgg Vreden	9	19	13	14
9	Wattenscheid	9	14	10	14
10	Siegen	10	11	13	14
11	Preußen	9	14	15	12
12	Ennepetal	7	18	14	11
13	TuS Haltern	10	10	25	10
14	Erndtebrück	8	6	14	9
15	Paderborn	8	18	22	8
16	Schermbeck	7	10	14	7
17	Finnentrop/B	10	14	20	7
18	Eintracht	10	14	28	7
19	Victoria	7	9	17	6
20	Westfalia	8	5	20	1
21	Hammer SpVg	8	8	25	0

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

OBERLIGA GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Siegen	34	59	31	64
2	SpVgg	34	62	38	63
3	Sprockhövel	34	73	48	61
4	Roland	34	67	48	60
5	Westfalia	34	78	50	59
6	Lippstadt	34	58	44	55
7	Eintracht	34	59	54	55
8	Neuenkirchen	34	66	63	52
9	Hüls	34	66	65	48
10	Arminia	34	57	58	43
11	Ennepetal	34	62	60	42
12	Gutersloh	34	52	61	42
13	Stadtlohn	34	49	60	42
14	Hammer SpVg	34	50	65	41
15	Dortmund	34	55	87	38
16	Paderborn	34	49	63	36
17	Schermbeck	34	49	78	31
18	Zweckel	34	40	78	28

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 2009/2010

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Wiedenbrück	36	68	38	75
2	Arminia	36	59	30	71
3	Germania	36	65	40	67
4	Schwarz-Weis	36	49	32	59
5	Rot-Weiss	36	58	52	53
6	Alemannia	36	54	48	52
7	Westfalia	36	55	50	51
8	Speldorf	36	47	46	51
9	Bergisch	36	45	53	47
10	Kleve	36	53	60	45
11	Duisburg	36	58	56	44
12	Velbert	36	51	55	44
13	Siegen	36	47	54	44
14	Schermbeck	36	48	65	44
15	Fortuna	36	49	55	40
16	Hüls	36	48	56	40
17	Hammer SpVg	36	35	52	37
18	Wattenscheid	36	47	71	35
19	Sprockhövel	36	51	74	32

TEMPORADA 2007/2008

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Preußen	34	66	23	71
2	Schalke	34	56	31	67
3	Bochum	34	61	30	66
4	Sportfreunde	34	62	35	60
5	Westfalia	34	55	34	57
6	Schermbeck	34	46	43	51
7	Germania	34	49	56	50
8	Hammer SpVg	34	43	44	49
9	Delbrücker	34	47	42	48
10	Gutersloh	34	44	48	46
11	Arminia	34	66	55	45
12	SpVgg	34	49	54	43
13	Weiss Ahlen	34	32	43	41
14	Oestrich-Ise	34	52	68	37
15	Eintracht	34	39	58	33
16	Lippstadt	34	37	67	32
17	Wiedenbrück	34	33	63	25
18	Sprockhövel	34	29	72	17

TEMPORADA 2004/2005

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Wattenscheid	34	78	34	71
2	Bochum	34	78	39	70
3	Schalke	34	64	42	60
4	Hüls	34	71	45	59
5	Verl	34	55	41	59
6	Emsdetten	34	51	55	58
7	Weiss Ahlen	34	58	42	54
8	Sportfreunde	34	54	55	50
9	Eintracht	34	62	55	44
10	Gutersloh	34	47	49	44
11	Fichte	34	57	65	43
12	SpVgg	34	37	45	42
13	Schermbeck	34	59	60	41
14	Siegen	34	46	59	33
15	Lippstadt	34	44	66	31
16	Sprockhövel	34	33	62	31
17	Vorwärts	34	45	87	31
18	SC Hassel	34	35	73	27

TEMPORADA 2003/2004

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Arminia	34	74	44	62
2	Verl	34	68	41	60
3	Bochum	34	63	39	59
4	Fichte	34	55	48	57
5	Weiss Ahlen	34	75	42	55
6	Hüls	34	53	45	51
7	SC Hassel	34	49	52	49
8	Gutersloh	34	47	50	49
9	Vorwärts	34	52	52	47
10	Eintracht	34	50	55	47
11	Lippstadt	34	51	51	46
12	Wattenscheid	34	51	56	45
13	Schermbeck	34	53	51	44
14	Emsdetten	34	54	57	43
15	Siegen	34	58	61	41
16	Sprockhövel	34	56	71	41
17	Stadtlohn	34	46	58	40
18	Lüner	34	28	110	9

TEMPORADA 2002/2003

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Schalke	34	103	35	86
2	Bochum	34	79	35	77
3	Gutersloh	34	77	39	69
4	Lippstadt	34	74	46	66
5	Eintracht	34	63	60	51
6	Wattenscheid	34	54	59	48
7	Hüls	34	55	48	46
8	Stadtlohn	34	37	47	44
9	Fichte	34	49	48	43
10	Siegen	34	49	61	43
11	SC Hassel	34	36	55	41
12	Emsdetten	34	45	57	39
13	Lüner	34	55	66	38
14	Arminia	34	41	63	37
15	Sprockhövel	34	46	72	35
16	TuS Hordel	34	52	62	33
17	Westfalia	34	39	61	28
18	TSG Dülmen	34	40	80	27

TEMPORADA 2000/2001

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Paderborn	36	85	29	86
2	Bochum	36	87	39	76
3	Hüls	36	93	41	74
4	Gutersloh	36	79	43	63
5	Schalke	36	84	63	60
6	Wattenscheid	36	56	42	59
7	Eintracht	36	69	57	55
8	Westfalia	36	65	45	53
9	Lüner	36	56	54	52
10	TuS Hordel	36	67	86	48
11	Lippstadt	36	64	55	47
12	TSG Dülmen	36	46	56	46
13	Stadtlohn	36	54	56	45
14	Oestrich-Ise	36	51	73	44
15	Preußen	36	65	76	42
16	Sprockhövel	36	46	76	36
17	SC Herford	36	33	67	29
18	SpVgg Beckum	36	28	94	19
19	Kirchellen	36	34	110	11

Competiciones que juega

Grupo 12

Oberliga Grupo 12

Pos	Equipos		Pts
1		Sportfreunde Lotte	67
2		Türkspor Dortmund	62
3		ASC 09 Dortmund	58
4		SpVgg Erkenschwick	54
5		Gievenbeck	49
6		SpVgg Vreden	46
7		Schermbeck	45
8		Preußen Münster II	44
9		Siegen Sportfreunde	43
10		Finnentrop/Bamenohl	40
11		Ennepetal	34
12		Westfalia Rhynern	32
13		Wattenscheid 09	30
14		Eintracht Rheine	29
15		TuS Bovinghausen	26
16		Victoria Clarholz	25
17		Sprockhövel	22
18		Brünninghausen	22

	Ascenso : Sportfreunde Lotte, Türkspor Dortmund
	Descenso : Sprockhövel, Brünninghausen

RIVALES EN Oberliga

USO DE MEMORIA

7,509,776 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.1947
Total Execution Time	0.1965

CADENA URL

/historico/Sprockhovel

GET DATOS

$_GET['/historico/Sprockhovel']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0031	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 = 'Sprockhovel' 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.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=61614 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=61614 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=61614 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=61614 AND type_rel = 2
0.0022	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 = '61614' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '61614' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0030	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 = 72710 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=61614 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (72710,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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 72710 AND teamId = 61614
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61614
0.0023	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 = 72710 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0032	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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 61614 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.0037	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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 61614 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 72710 WHERE rp.league_id = 72710 AND rp.teamId = 61614 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 61614 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027	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 = 72710 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 68216 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.0023	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 = 63363 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 67305 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 57811 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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.0032	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.0029	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.0028	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.0032	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 = 15552 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 = 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.0036	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.0024	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.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* `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 = 19851 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 19870 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0082	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 = 28286 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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* `tables2004` 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 = 28298 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables2003` 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 = 28310 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040	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* `tables2001` 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 = 28320 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Sprockhövel

Sprockhövel

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 12

RIVALES EN Oberliga