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

Union Fürstenwalde

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Hertha	23	86	24	60
2	Lichtenberg	25	74	17	59
3	Sparta	24	63	38	44
4	Mahlsdorf	23	46	36	39
5	Tennis	24	42	38	37
6	TUS Makkabi	23	38	31	36
7	Tasmania	23	40	32	35
8	Anker Wismar	24	40	43	32
9	Neustrelitz	23	42	43	31
10	Optik	24	40	47	29
11	Staaken	23	37	60	28
12	Eintracht	24	38	59	24
13	Hertha	15	29	26	23
14	Dynamo	23	34	49	23
15	Rostocker	25	30	80	17
16	Union	24	20	76	8

TEMPORADA 2022/2023

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Hansa	34	94	28	81
2	Rostocker	34	77	38	69
3	TUS Makkabi	34	73	32	67
4	Hertha	34	71	40	62
5	Eintracht	34	56	53	57
6	Hertha	34	48	44	49
7	Blau-Weiß	34	59	60	48
8	Dynamo	34	48	54	48
9	Neustrelitz	34	55	54	47
10	Union	34	48	56	47
11	Mahlsdorf	34	48	52	46
12	Tasmania	36	46	69	39
13	Optik	34	42	60	34
14	Mecklenburg	36	55	90	34
15	Staaken	34	46	61	33
16	Neuruppin	34	43	57	32
17	Frankfurt	34	43	72	31
18	Pampow	34	51	83	30

TEMPORADA 2021/2022

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	BFC Dynamo	38	84	32	82
2	Carl Zeiss.	38	71	35	76
3	Energie	38	85	35	74
4	Altglienicke	38	80	47	72
5	Chemnitzer	38	67	37	72
6	Lokomotive	38	71	42	71
7	Berliner	38	65	48	69
8	Hertha	38	69	49	60
9	Chemie	38	47	48	56
10	Tennis	38	59	50	53
11	Babelsberg	38	46	42	53
12	Luckenwalde	38	58	50	50
13	Lichtenberg	38	49	64	44
14	Meuselwitz	38	42	54	41
15	Germania	38	48	68	41
16	Eilenburg	38	41	79	33
17	Union	38	49	89	33
18	Optik	38	48	81	30
19	Auerbach	38	45	95	23
20	Tasmania	38	28	107	17

TEMPORADA 2020/2021

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Viktoria	11	26	9	33
2	Altglienicke	11	29	14	25
3	Chemie	13	25	12	24
4	Carl Zeiss.	12	24	16	21
5	Berliner	12	25	21	20
6	Lokomotive	12	20	17	19
7	BFC Dynamo	11	26	17	18
8	Energie	13	18	19	18
9	Chemnitzer	13	20	17	17
10	Babelsberg	13	18	20	17
11	Union	11	22	20	16
12	Lichtenberg	13	15	20	16
13	Luckenwalde	13	14	22	15
14	Hertha	11	12	15	14
15	Germania	13	12	18	11
16	Auerbach	12	18	26	11
17	Meuselwitz	13	14	22	11
18	Optik	13	15	25	11
19	Tennis	10	15	20	9
20	Bischofswerd	12	12	30	7

TEMPORADA 2019/2020

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Lokomotive	25	49	27	54
2	Altglienicke	24	60	32	48
3	Energie	24	58	35	48
4	Union	25	48	32	43
5	Hertha	24	59	42	39
6	BFC Dynamo	24	36	31	37
7	Berliner	23	48	36	34
8	Viktoria	24	22	20	32
9	Wacker	21	45	36	31
10	Auerbach	23	38	48	29
11	Meuselwitz	23	35	40	28
12	Lichtenberg	23	31	36	28
13	Chemie	24	20	26	24
14	Germania	24	25	40	22
15	Optik	24	20	48	21
16	Rot-Weiss	19	18	27	19
17	Babelsberg	23	23	39	18
18	Bischofswerd	21	16	56	11

TEMPORADA 2018/2019

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Chemnitzer	34	82	36	77
2	Berliner	34	64	36	70
3	Wacker	34	59	38	64
4	Hertha	34	60	43	57
5	Rot-Weiss	34	57	42	54
6	Viktoria	34	50	38	52
7	Lokomotive	34	51	41	50
8	Babelsberg	34	53	44	46
9	Germania	34	46	38	46
10	Auerbach	34	47	53	46
11	Meuselwitz	34	52	55	44
12	BFC Dynamo	34	38	61	42
13	Union	34	43	60	40
14	Altglienicke	34	54	59	39
15	Oberlausitz	34	40	64	37
16	Bischofswerd	34	29	58	34
17	Optik	34	36	65	28
18	Budissa	34	21	51	26

TEMPORADA 2017/2018

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Energie	34	79	14	89
2	Wacker	34	48	29	58
3	Berliner	34	63	47	56
4	BFC Dynamo	34	70	50	54
5	Babelsberg	34	52	38	53
6	Lokomotive	34	48	36	53
7	Germania	34	68	52	52
8	Hertha	34	54	45	48
9	Union	34	59	52	47
10	Meuselwitz	34	44	44	43
11	Auerbach	34	48	51	43
12	Oberlausitz	34	47	53	43
13	Viktoria	34	49	54	42
14	Budissa	34	31	47	41
15	Altglienicke	34	30	41	38
16	Chemie	34	21	51	35
17	Neustrelitz	34	36	75	27
18	Luckenwalde	34	25	93	9

TEMPORADA 2016/2017

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Carl Zeiss.	34	68	25	75
2	Energie	34	58	26	66
3	Leipzig	34	67	42	60
4	Viktoria	34	63	47	56
5	Babelsberg	34	55	42	55
6	Berliner	34	54	42	55
7	Wacker	34	47	47	51
8	Oberlausitz	34	41	33	48
9	Hertha	34	46	48	48
10	Lokomotive	34	53	49	47
11	Schönberg	34	53	60	47
12	Auerbach	34	47	50	45
13	Union	34	49	59	45
14	Meuselwitz	34	37	36	44
15	BFC Dynamo	34	51	54	44
16	Luckenwalde	34	35	75	24
17	Budissa	34	29	68	18
18	Neustrelitz	34	30	80	11

TEMPORADA 2015/2016

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Union	30	84	35	69
2	Hansa	30	78	30	65
3	Hertha	30	75	37	59
4	Tennis	30	55	35	55
5	Lichtenberg	30	54	34	53
6	Malchower	30	65	46	48
7	Anker Wismar	30	59	36	45
8	Germania	30	32	30	40
9	Victoria	30	38	46	39
10	Altlüdersdo	30	49	56	38
11	Hertha	30	45	49	37
12	Neubrandenbu	30	55	61	36
13	BSC Süd 05	30	38	61	33
14	Strausberg	30	29	48	30
15	Frankfurt	30	31	77	21
16	Hürtürkel	30	24	130	10

TEMPORADA 2014/2015

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Optik	30	65	38	66
2	Schönberg	30	73	23	63
3	Luckenwalde	30	65	32	61
4	Lichtenberg	30	69	49	52
5	Malchower	30	50	45	49
6	Altlüdersdo	30	54	36	48
7	Hansa	30	48	36	47
8	Union	30	41	45	44
9	Hertha	30	58	43	43
10	Neubrandenbu	30	45	60	37
11	Waren	30	37	57	37
12	Germania	30	31	52	34
13	BSC Süd 05	30	46	59	32
14	Strausberg	30	40	59	26
15	Pommern	30	24	53	21
16	Hürtürkel	30	31	90	9

TEMPORADA 2013/2014

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	BFC Dynamo	30	75	10	84
2	BSC Süd 05	30	40	41	50
3	Lichtenberg	30	42	33	48
4	Hansa	30	68	47	47
5	Strausberg	30	48	42	44
6	Altlüdersdo	30	55	55	43
7	Altglienicke	30	47	62	43
8	Luckenwalde	30	50	45	40
9	Pommern	30	39	39	40
10	Hürtürkel	30	44	66	40
11	Schönberg	30	51	51	36
12	Union	30	37	45	34
13	Malchower	30	39	49	33
14	Neubrandenbu	30	45	66	32
15	Waltersdorf	30	38	50	29
16	Torgelower	30	28	45	25

TEMPORADA 2012/2013

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	57	20	66
2	Union	30	73	32	61
3	BFC Dynamo	30	59	28	56
4	Altlüdersdo	30	46	25	53
5	Luckenwalde	30	64	49	52
6	Hansa	30	49	40	46
7	Lichtenberg	30	37	37	45
8	Pommern	30	32	42	42
9	Altglienicke	30	49	54	36
10	Malchower	30	43	55	33
11	Neubrandenbu	30	35	39	32
12	Waltersdorf	30	33	46	32
13	BSC Süd 05	30	41	68	32
14	Lichterfelde	30	46	69	29
15	Waren	30	38	73	25
16	Anker Wismar	30	38	63	22

TEMPORADA 2011/2012

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Hansa	28	64	26	65
2	Union Berlin	28	55	34	56
3	Optik	28	57	36	55
4	Neustrelitz	28	51	24	54
5	Torgelower	28	54	42	48
6	Germania	28	54	39	46
7	Viktoria	28	54	35	43
8	Union	28	34	39	38
9	Neubrandenbu	28	40	46	34
10	Malchower	28	40	45	33
11	Anker Wismar	28	42	61	32
12	Altlüdersdo	28	33	52	31
13	BFC Dynamo	28	35	39	29
14	BSC Süd 05	28	26	73	18
15	Lichterfelde	28	22	70	5
16	Türkiyemspo	0	0	0	0

Competiciones que juega

Grupo 4

Oberliga Grupo 4

Pos	Equipos		Pts
1		FC Hertha 03 Zehlendorf	60
2		Lichtenberg	59
3		Sparta Lichtenberg	44
4		Mahlsdorf	39
5		Tennis Borussia	37
6		TUS Makkabi	36
7		Tasmania Berlin	35
8		Anker Wismar	32
9		Neustrelitz	31
10		Optik Rathenow	29
11		Staaken	28
12		RSV Eintracht	24
13		CFC Hertha 06	23
14		Dynamo Schwerin	23
15		Rostocker FC	17
16		Union Fürstenwalde	8

	Ascenso : FC Hertha 03 Zehlendorf

RIVALES EN Oberliga

USO DE MEMORIA

6,659,744 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5204
Total Execution Time	0.5216

CADENA URL

/historico/Union-Furstenwalde

GET DATOS

$_GET['/historico/Union-Furstenwalde']

POST DATOS

No hay datos POST existentes

CONSULTAS (26)

0.0150	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17186 AND type_rel = 2
0.0162	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 = '17186' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155	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=17186 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147	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 (72541,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 = 72541 AND teamId = 17186
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17186
0.0146	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 = '17186' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17186' and rp.type = 4
0.0146	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 = '17186' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0155	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 = 72541 WHERE rp.league_id = 72541 AND rp.teamId = 17186 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.0159	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 = 72541 WHERE rp.league_id = 72541 AND rp.teamId = 17186 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72541 WHERE rp.league_id = 72541 AND rp.teamId = 17186 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148	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 = 17186 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72541 AND t.round = 25 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* `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 = 68171 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.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* `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 = 63253 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.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* `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 = 57335 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 50104 AND t.round = 25 ORDER BY team.conference ASC,t.position 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* `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 = 43945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167	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 = 38890 AND t.round = 34 ORDER BY team.conference 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* `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 = 33792 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167	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 = 15540 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170	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 = 4375 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	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 = 3543 AND t.round = 30 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* `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 = 19815 AND t.round = 30 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* `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 = 19824 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Union Fürstenwalde

Union Fürstenwalde

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 4

RIVALES EN Oberliga