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

Schermbeck

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 27
Equipo		PJ	GF	GC	Puntos
1	Kaan-Marienb	9	29	13	21
2	Westfalia	9	25	8	19
3	Wattenscheid	9	15	7	19
4	Paderborn	9	19	10	14
5	Gutersloh	9	14	13	12
6	Eintracht	9	11	13	10
7	Erndtebrück	9	12	23	9
8	Siegen	9	8	19	8
9	Dortmund	9	13	27	8
10	Schermbeck	9	7	20	5

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 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 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

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 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 2005/2006

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Dortmund	34	79	25	79
2	Verl	34	75	43	70
3	Gutersloh	34	71	41	59
4	Schalke	34	64	43	58
5	Sportfreunde	34	49	43	56
6	Bochum	34	61	52	51
7	Hüls	34	48	53	46
8	Westfalia	34	47	51	44
9	Emsdetten	34	44	57	43
10	Arminia	34	36	38	42
11	Weiss Ahlen	34	36	43	42
12	Delbrücker	34	35	46	41
13	Lippstadt	34	43	65	41
14	Eintracht	34	44	65	39
15	SpVgg	34	32	45	38
16	Siegen	34	42	63	34
17	Schermbeck	34	43	46	33
18	Fichte	34	31	61	31

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

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,194,640 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5070
Total Execution Time	0.5083

CADENA URL

/historico/Schermbeck

GET DATOS

$_GET['/historico/Schermbeck']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65735 AND type_rel = 2
0.0136	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 = '65735' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131	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=65735 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 (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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 72710 AND teamId = 65735
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65735
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 = '65735' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65735' and rp.type = 4
0.0130	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 = '65735' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138	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 = 65735 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.0142	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 = 65735 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141	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 = 65735 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 65735 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0254	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.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* `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.0127	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 = 67304 AND t.round = 9 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* `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.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* `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.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* `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.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* `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.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* `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.0142	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.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* `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.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* `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.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* `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.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* `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.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* `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 = 19891 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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.0145	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

Schermbeck

Schermbeck

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 12

RIVALES EN Oberliga