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

Schwarz-Weiss Essen

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	SF Baumberg	29	68	30	63
2	Schonnebeck	29	64	39	54
3	Uerdingen	28	50	34	52
4	Germania	29	53	41	51
5	Hilden	29	47	42	48
6	Homberg	29	43	39	43
7	Schwarz-Weis	28	44	39	39
8	Büderich	28	49	46	39
9	Sonsbeck	30	44	47	38
10	Union	30	45	55	38
11	TVD Velbert	29	48	54	35
12	SV Straelen	18	35	18	34
13	Tönis	29	47	54	33
14	Kleve	29	30	52	31
15	Meerbusch	30	49	61	30
16	Mülheimer	29	43	56	30
17	Union	29	32	54	28
18	Hamborn	28	28	58	26

TEMPORADA 2022/2023

OBERLIGA GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Velbert	40	93	33	94
2	Hilden	40	89	45	79
3	TVD Velbert	40	86	46	78
4	Germania	40	79	55	74
5	Schwarz-Weis	40	84	52	73
6	Uerdingen	40	80	58	72
7	Schonnebeck	40	84	70	61
8	Meerbusch	40	81	67	59
9	SF Baumberg	40	78	54	58
10	Hamborn	40	77	79	56
11	Union	40	65	72	55
12	Homberg	40	68	57	54
13	Sonsbeck	40	71	68	53
14	Tönis	40	59	60	53
15	Kleve	40	67	77	52
16	Düsseldorf	40	71	68	50
17	1.FC Monheim	40	58	76	42
18	Cronenberger	40	38	87	30
19	Turu 1880 D.	40	35	85	29
20	Kray	40	47	110	24
21	Duisburg	40	36	127	18

TEMPORADA 2021/2022

OBERLIGA GRUPO 23
Equipo		PJ	GF	GC	Puntos
1	FC Bocholt	10	24	8	24
2	Hilden	10	26	11	21
3	SF Baumberg	10	26	21	15
4	Velbert	10	20	19	15
5	Germania	10	19	14	13
6	TVD Velbert	10	16	18	12
7	Schonnebeck	10	16	24	12
8	Schwarz-Weis	10	21	23	11
9	1.FC Monheim	10	12	16	11
10	Kleve	10	17	23	10
11	Meerbusch	10	10	30	5

TEMPORADA 2020/2021

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	FC Bocholt	10	32	9	28
2	Velbert	10	23	15	22
3	SF Baumberg	11	28	17	21
4	Germania	9	30	11	19
5	Kleve	10	20	16	19
6	SpVgg	10	20	17	17
7	Düsseldorf-	7	18	9	16
8	Tönis	8	18	9	14
9	Schwarz-Weis	11	17	14	14
10	TVD Velbert	9	19	17	14
11	1.FC Monheim	9	17	15	14
12	Schonnebeck	8	14	11	13
13	SC Velbert	10	18	17	11
14	Meerbusch	9	11	18	11
15	Hilden	7	17	15	10
16	Union	11	12	20	10
17	Turu 1880 D.	9	10	21	10
18	Cronenberger	8	13	15	9
19	Niederwenige	10	16	20	8
20	Kray	8	12	17	7
21	Jahn	9	9	22	7
22	Duisburg	9	11	25	4
23	Mönchenglad	10	8	43	3

TEMPORADA 2019/2020

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	SV Straelen	22	67	22	61
2	1.FC Monheim	22	40	24	42
3	Schonnebeck	22	36	24	42
4	FC Bocholt	23	50	33	40
5	Velbert	22	42	27	40
6	Meerbusch	23	43	36	35
7	SF Baumberg	23	52	46	35
8	Hilden	23	43	40	34
9	Schwarz-Weis	22	32	32	31
10	Turu 1880 D.	22	32	32	31
11	Kleve	23	32	34	31
12	Kray	23	46	40	30
13	TVD Velbert	23	30	30	30
14	Germania	23	37	42	30
15	SC Velbert	22	22	48	18
16	Union	22	21	50	13
17	Cronenberger	23	22	53	13
18	Niederwenige	23	27	61	11

TEMPORADA 2018/2019

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Homberg	34	100	34	83
2	SF Baumberg	34	83	57	69
3	FC Bocholt	34	61	45	57
4	1.FC Monheim	34	66	57	55
5	Velbert	34	73	44	54
6	Germania	34	67	51	54
7	Meerbusch	34	70	60	51
8	Turu 1880 D.	34	51	56	49
9	Schonnebeck	34	58	65	48
10	Hilden	34	73	68	47
11	SC Velbert	34	47	58	47
12	Kleve	34	56	49	45
13	Schwarz-Weis	34	57	51	43
14	Union	34	41	54	43
15	Düsseldorf-	34	50	59	41
16	Jahn	34	45	82	29
17	Speldorf	34	48	87	26
18	Duisburg	34	41	110	13

TEMPORADA 2017/2018

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	SV Straelen	34	81	36	70
2	Schonnebeck	34	78	41	69
3	Homberg	34	75	45	63
4	SF Baumberg	34	78	51	58
5	Jahn	34	66	48	56
6	Schwarz-Weis	34	70	55	56
7	Germania	34	74	45	55
8	Velbert	34	67	46	55
9	Düsseldorf-	34	68	67	52
10	FC Bocholt	34	65	50	50
11	1.FC Monheim	34	64	58	50
12	Speldorf	34	64	67	47
13	Hilden	34	62	68	43
14	Turu 1880 D.	34	40	65	40
15	Krefeld-Fisc	34	61	92	30
16	Cronenberger	34	42	84	30
17	Vohwinkel	34	54	101	25
18	Düsseldorfe	34	36	126	8

TEMPORADA 2016/2017

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Uerdingen	33	81	20	83
2	Schonnebeck	34	71	40	72
3	FC Bocholt	34	61	35	66
4	Krefeld-Fisc	34	79	74	56
5	Velbert	34	65	44	54
6	Jahn	34	65	60	54
7	Homberg	34	60	51	53
8	Germania	34	61	54	51
9	Düsseldorf-	34	56	61	49
10	Hilden	33	67	58	48
11	Turu 1880 D.	34	39	49	44
12	SF Baumberg	34	76	68	41
13	Schwarz-Weis	34	51	65	36
14	Cronenberger	34	40	87	35
15	Meerbusch	34	56	74	31
16	Kapellen-Erf	34	48	77	30
17	Honnepel-Nie	34	46	73	27
18	Kray	34	59	91	25

TEMPORADA 2015/2016

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Wuppertaler	34	69	25	74
2	Uerdingen	34	59	38	62
3	Jahn	34	70	48	58
4	Turu 1880 D.	34	46	40	52
5	Schonnebeck	34	52	48	50
6	Krefeld-Fisc	34	66	64	49
7	Kapellen-Erf	34	55	51	48
8	Meerbusch	34	54	58	48
9	Düsseldorf-	34	43	50	47
10	Honnepel-Nie	34	56	48	46
11	Germania	34	47	46	45
12	FC Bocholt	34	52	52	45
13	Duisburg	34	50	42	43
14	Hilden	34	48	58	41
15	Schwarz-Weis	34	51	62	40
16	Mönchenglad	34	41	67	33
17	Rot-Weiss	34	43	72	31
18	Kalkum-Wittl	34	36	69	24

TEMPORADA 2014/2015

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Velbert	34	100	38	80
2	Wuppertaler	35	66	30	69
3	Germania	34	64	40	64
4	Honnepel-Nie	34	57	50	57
5	Duisburg	34	72	42	52
6	FC Bocholt	34	55	41	51
7	Jahn	34	60	58	50
8	Krefeld-Fisc	34	53	61	49
9	Turu 1880 D.	34	51	50	47
10	Bösinghoven	34	71	64	46
11	Rot-Weiss	34	51	54	45
12	Schwarz-Weis	34	49	48	44
13	Kapellen-Erf	34	62	70	43
14	Hilden	34	69	76	42
15	Sonsbeck	34	41	66	37
16	SF Baumberg	34	40	70	29
17	Nievenheim	34	37	103	27
18	Homberg	35	37	78	22

TEMPORADA 2013/2014

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Honnepel-Nie	38	80	39	80
2	Kray	38	88	56	74
3	Wuppertaler	38	76	54	71
4	Jahn	38	69	43	69
5	Duisburg	38	84	49	68
6	Rot-Weiss	38	82	62	67
7	Schwarz-Weis	38	67	42	63
8	Turu 1880 D.	38	86	60	62
9	Homberg	38	62	58	60
10	Kapellen-Erf	38	68	53	57
11	Bösinghoven	38	70	76	51
12	Rot-Weiss	38	69	74	50
13	Hilden	38	81	64	49
14	SF Baumberg	38	76	68	49
15	Germania	38	57	60	49
16	Sonsbeck	38	56	77	43
17	Rhede	38	46	82	33
18	Speldorf	38	41	87	26
19	Uedesheim	38	39	95	19
20	Wesel-Lackha	38	32	130	14

TEMPORADA 2012/2013

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Uerdingen	38	98	32	96
2	Turu 1880 D.	38	77	54	73
3	Rhede	38	78	54	68
4	Kapellen-Erf	38	58	48	61
5	Germania	38	71	46	59
6	Schwarz-Weis	38	69	50	59
7	Wuppertaler	38	57	48	57
8	Sonsbeck	38	59	53	56
9	Jahn	38	58	52	54
10	Homberg	38	60	58	52
11	Speldorf	38	71	77	51
12	SF Baumberg	38	50	61	50
13	Rot-Weiss	38	63	60	48
14	Honnepel-Nie	38	64	61	45
15	Bösinghoven	38	60	80	44
16	Uedesheim	38	52	73	39
17	Cronenberger	38	53	82	39
18	Wulfrath	38	37	68	37
19	Krefeld-Fisc	38	56	93	34
20	Hamborn	38	41	82	29

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

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Rot-Weiss	32	59	28	71
2	Germania	32	62	37	66
3	Fortuna	32	57	25	61
4	Alemannia	32	58	37	52
5	Schwarz-Weis	32	45	36	51
6	Velbert	32	60	45	49
7	Siegen	32	54	47	48
8	Duisburg	32	39	42	44
9	Speldorf	32	49	46	42
10	Schermbeck	32	44	49	42
11	Homberg	32	41	51	38
12	Bergisch	32	35	61	37
13	Westfalia	32	52	60	36
14	Wegberg-Beec	32	43	58	36
15	Hüls	32	34	50	36
16	Westfalia	32	43	64	31
17	SpVgg	32	30	69	17
18	Kleve	0	0	0	0

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

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Fortuna	34	71	28	74
2	Bonner SC	34	77	30	73
3	Alemannia	34	62	39	64
4	Arminia	34	66	45	60
5	Schwarz-Weis	34	56	44	58
6	Westfalia	34	59	57	53
7	Duisburg	34	60	58	52
8	Germania	34	52	47	47
9	Rot-Weiss	34	54	48	46
10	Fortuna	35	57	54	45
11	Siegen	34	42	49	45
12	Wattenscheid	34	48	57	43
13	Hüls	34	46	57	40
14	Schermbeck	35	40	54	40
15	Velbert	34	50	66	35
16	Hammer SpVg	34	43	63	34
17	Oestrich-Ise	34	36	55	33
18	Gutersloh	34	41	73	31
19	Delbrücker	34	39	75	29

TEMPORADA 2007/2008

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mönchenglad	34	86	47	68
2	Leverkusen	34	62	31	66
3	Köln II	34	62	29	65
4	Kleve	34	53	40	55
5	Schwarz-Weis	34	43	48	51
6	Velbert	34	47	54	51
7	Duisburg	34	74	62	49
8	Germania	34	42	34	49
9	Alemannia	34	45	46	48
10	Bonner SC	34	48	45	46
11	Fortuna	34	49	53	46
12	Wuppertaler	34	51	55	45
13	Uerdingen	34	55	67	43
14	Turu 1880 D.	34	37	42	42
15	Homberg	34	49	62	39
16	Speldorf	34	42	69	30
17	Bergisch	34	45	74	28
18	SV Straelen	34	40	72	24

TEMPORADA 2006/2007

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Rot-Weiß	34	50	25	69
2	Alemannia	34	56	39	61
3	Velbert	34	60	48	56
4	Bonner SC	34	48	41	53
5	Duisburg	34	61	58	53
6	Schwarz-Weis	34	54	38	52
7	Kleve	34	44	45	50
8	Köln II	34	62	50	49
9	Wuppertaler	34	40	35	49
10	Uerdingen	34	45	45	48
11	Turu 1880 D.	34	44	38	47
12	Bergisch	34	42	46	45
13	SV Straelen	34	51	46	42
14	Speldorf	34	40	47	42
15	Homberg	34	42	53	41
16	FC Bocholt	34	43	53	40
17	Union	34	31	78	25
18	Düren	34	38	66	24

TEMPORADA 2005/2006

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Mönchenglad	32	82	38	68
2	Bonner SC	32	71	34	62
3	Kleve	32	72	47	62
4	Velbert	32	66	46	54
5	FC Bocholt	32	49	48	48
6	Homberg	32	66	70	48
7	Alemannia	32	55	47	47
8	Wuppertaler	32	51	43	47
9	Schwarz-Weis	32	58	50	44
10	Duisburg	32	51	83	41
11	Uerdingen	32	38	41	38
12	Speldorf	32	41	49	37
13	Düren	32	35	50	34
14	Union	32	51	58	33
15	Turu 1880 D.	32	41	51	33
16	Junkersdorf	32	43	73	33
17	Wegberg-Beec	32	36	78	17

Competiciones que juega

Grupo 10

Oberliga Grupo 10

Pos	Equipos		Pts
1		SF Baumberg	63
2		Schonnebeck	54
3		KFC Uerdingen 05	52
4		Germania Ratingen	51
5		Hilden	48
6		Homberg	43
7		Schwarz-Weiss Essen	39
8		FC Büderich	39
9		Sonsbeck	38
10		SC Union Nettetal	38
11		TVD Velbert	35
12		SV Straelen	34
13		SC St. Tönis	33
14		Kleve	31
15		Meerbusch	30
16		Mülheimer FC 97	30
17		Union Frintrop	28
18		Hamborn	26

	Ascenso : SF Baumberg
	Descenso : Mülheimer FC 97, Union Frintrop, Hamborn

RIVALES EN Oberliga

USO DE MEMORIA

7,772,160 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6143
Total Execution Time	0.6156

CADENA URL

/historico/Schwarz-Weiss-Essen

GET DATOS

$_GET['/historico/Schwarz-Weiss-Essen']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61586 AND type_rel = 2
0.0135	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 = '61586' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 72634 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0144	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=61586 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (72634,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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 72634 AND teamId = 61586
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61586
0.0130	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 = 72634 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128	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 = '61586' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61586' and rp.type = 4
0.0129	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 = '61586' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0150	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 = 72634 WHERE rp.league_id = 72634 AND rp.teamId = 61586 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.0169	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 = 72634 WHERE rp.league_id = 72634 AND rp.teamId = 61586 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0179	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 = 72634 WHERE rp.league_id = 72634 AND rp.teamId = 61586 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0168	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 = 61586 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0135	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 = 72634 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.0134	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 = 68317 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.0132	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 = 63365 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 67169 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.0130	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 = 58331 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.0129	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 = 50471 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 44366 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 39087 AND t.round = 34 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* `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 = 33888 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	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 = 15549 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* `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 = 9465 AND t.round = 34 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* `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 = 9571 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 19810 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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* `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 = 19841 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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.0133	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 = 19863 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 19869 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 19880 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 19890 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72634 ORDER BY nameShow LIMIT 100

Schwarz-Weiss Essen

Schwarz-Weiss Essen

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 10

RIVALES EN Oberliga