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

Bayern Alzenau

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	FC Giessen	30	60	22	64
2	Baunatal	30	64	38	60
3	Türkgücü	30	79	39	59
4	Bayern	30	66	34	59
5	Eddersheim	30	52	38	52
6	Hünfelder	29	62	53	48
7	Hanauer 1960	29	56	47	47
8	Fernwald	30	53	47	43
9	Adler	30	51	47	43
10	Rot-Weiß	30	57	59	39
11	Waldgirmes	30	43	70	36
12	Eintracht	30	49	51	34
13	FC Hanau 93	30	51	65	33
14	Marburg	30	42	59	33
15	FC Erlensee	30	40	63	26
16	Steinbach	30	37	61	26
17	Viktoria	30	33	68	23
18	Dietkirchen	30	39	73	21

TEMPORADA 2022/2023

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Eintracht	38	113	35	89
2	FC Giessen	38	80	41	82
3	Türkgücü	38	89	64	70
4	Fernwald	38	86	58	69
5	Eintracht	38	80	51	65
6	Baunatal	38	67	51	62
7	Rot-Weiß	38	87	68	60
8	FC Hanau 93	38	71	64	58
9	Steinbach	38	64	60	52
10	FC Erlensee	38	64	60	49
11	Eddersheim	38	53	53	47
12	Bayern	38	51	60	47
13	Waldgirmes	38	67	73	46
14	Adler	38	55	83	45
15	Viktoria	38	53	89	44
16	Dietkirchen	38	59	80	41
17	Unter-Flocke	38	65	110	40
18	Neuhof	38	44	70	37
19	Rot-Weiß	38	57	96	37
20	Steinbach	38	54	93	25

TEMPORADA 2021/2022

OBERLIGA GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Bayern	12	33	17	46
2	Rot-Weiß	12	27	17	41
3	Viktoria	12	33	20	36
4	Türkgücü	12	26	14	36
5	FC Hanau 93	12	22	12	33
6	Baunatal	12	15	21	33
7	Steinbach	12	23	21	30
8	Bad Vilbel	12	10	14	27
9	Hünfelder	12	14	21	24
10	Ginsheim	12	20	21	23
11	Zeilsheim	12	10	25	19
12	Buchonia	12	4	34	17

TEMPORADA 2020/2021

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Freiburg II	42	95	38	93
2	Elversberg	42	98	43	88
3	Kickers	42	80	32	87
4	Ulm	42	75	40	79
5	Steinbach	42	84	47	74
6	Frankfurt	42	58	48	70
7	Homburg	42	73	53	68
8	Stuttgart	42	82	55	65
9	Bahlinger	42	66	75	61
10	RW Koblenz	42	57	61	56
11	FC Giessen	42	52	51	53
12	Hessen	42	57	71	53
13	VfR Aalen	42	49	60	52
14	Pirmasens	42	45	58	52
15	Balingen	42	51	60	51
16	Hoffenheim	42	59	76	50
17	Mainz 05 II	42	58	73	49
18	Astoria	42	64	79	47
19	Sonnenhof	42	52	75	43
20	Schott Mainz	42	55	104	38
21	Bayern	42	47	94	25
22	Eintracht	42	40	104	17

TEMPORADA 2019/2020

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Saarbrücken	23	52	18	55
2	Elversberg	23	48	24	49
3	Steinbach	22	40	18	48
4	Homburg	23	42	30	46
5	Astoria	23	41	31	37
6	Mainz 05 II	23	37	29	37
7	Ulm	22	38	24	35
8	Kickers	22	29	28	32
9	Hoffenheim	22	37	34	29
10	Bayern	22	28	31	28
11	Bahlinger	23	33	38	28
12	Frankfurt	23	26	32	28
13	Freiburg II	23	30	37	28
14	VfR Aalen	22	27	25	26
15	FC Giessen	23	22	39	25
16	Pirmasens	22	19	35	18
17	Balingen	23	24	57	11
18	RW Koblenz	22	12	55	5

TEMPORADA 2018/2019

OBERLIGA GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Bayern	2	3	3	2
2	Rochling	2	3	3	2
3	Stuttgarter	2	2	2	2

TEMPORADA 2017/2018

OBERLIGA GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Pirmasens	2	2	0	4
2	Villingen	2	8	3	3
3	Bayern	2	1	8	1

TEMPORADA 2016/2017

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Hessen	32	89	34	70
2	Eintracht	32	83	46	69
3	Rot-Weiß	32	90	45	66
4	Bayern	32	87	49	64
5	Borussia	32	66	35	58
6	Rot-Weiß	32	63	48	54
7	Lehnerz	32	59	54	49
8	Seligenstadt	32	57	45	44
9	Baunatal	32	60	53	41
10	Lohfelden	32	49	52	41
11	Vellmar	32	49	70	41
12	Viktoria	32	40	60	38
13	Ederbergland	32	52	76	38
14	Steinbach	32	62	94	36
15	Rot-Weiß	32	41	87	23
16	Viktoria	32	39	77	22
17	Viktoria	32	24	85	11

TEMPORADA 2015/2016

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FC Giessen	32	81	40	68
2	Rot-Weiß	32	81	45	64
3	Lehnerz	32	59	38	57
4	Lohfelden	32	62	49	57
5	Eintracht	32	63	55	54
6	Eschborn	32	55	54	49
7	Wiesbaden	32	57	46	48
8	Viktoria	32	49	55	42
9	Seligenstadt	32	50	57	42
10	Rot-Weiß	32	50	62	41
11	Baunatal	32	63	64	39
12	Borussia	32	36	51	39
13	Hessen	32	54	60	38
14	Vellmar	32	54	69	35
15	Bayern	32	43	60	34
16	Oberrad	32	36	58	31
17	Buchonia	32	42	72	27

TEMPORADA 2014/2015

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Steinbach	32	66	31	66
2	Bayern	32	55	29	62
3	Lehnerz	32	63	28	61
4	Rot-Weiß	32	60	30	60
5	Wiesbaden	32	65	40	57
6	Wehen	32	51	37	54
7	Seligenstadt	32	67	55	49
8	Buchonia	32	59	63	47
9	Eintracht	32	61	58	40
10	Eschborn	32	50	52	40
11	Vellmar	32	50	60	39
12	Lohfelden	32	52	59	38
13	Oberrad	32	47	70	38
14	Viktoria	32	34	51	37
15	Ederbergland	32	41	57	33
16	Rot-Weiß	32	47	69	32
17	Schwalmstadt	32	17	96	6

TEMPORADA 2013/2014

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Jügesheim	36	70	38	71
2	Vellmar	36	79	57	64
3	Eschborn	36	68	51	60
4	Lehnerz	36	62	47	57
5	Frankfurt	36	86	61	56
6	Rot-Weiß	36	64	47	55
7	Wehen	36	62	60	54
8	Seligenstadt	36	60	55	53
9	Wiesbaden	36	68	62	50
10	Fernwald	36	53	58	48
11	Eintracht	36	52	66	47
12	Lohfelden	36	58	72	46
13	Bayern	36	47	54	45
14	Rot-Weiß	36	56	64	45
15	Buchonia	36	74	81	42
16	Viktoria	36	52	67	42
17	Ederbergland	36	59	81	40
18	Kickers	36	52	70	35
19	Hünfelder	36	51	82	28

TEMPORADA 2012/2013

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hessen	36	56	36	70
2	Elversberg	36	59	44	65
3	Kaiserslaute	36	56	38	60
4	Sonnenhof	36	62	36	58
5	Eintracht	36	50	44	57
6	Waldhof	36	48	38	55
7	Freiburg II	36	61	48	52
8	Koblenz	36	46	44	52
9	Hoffenheim	36	62	45	51
10	Ulm	36	46	46	51
11	Mainz 05 II	36	55	56	49
12	Wormatia	36	49	51	44
13	Pfullendorf	36	40	49	43
14	Homburg	36	51	64	43
15	Eintracht	36	48	54	40
16	Eschborn	36	43	56	40
17	Frankfurt	36	38	62	40
18	Idar-Oberste	36	41	57	35
19	Bayern	36	43	86	28

TEMPORADA 2011/2012

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Stuttgarter	34	66	29	78
2	Sonnenhof	34	78	40	69
3	Eintracht	34	69	41	67
4	Wormatia	34	57	48	58
5	Karlsruher	34	56	48	58
6	Greuther	34	50	48	54
7	Hoffenheim	34	69	36	52
8	Freiburg II	34	49	49	49
9	Ingolstadt	34	46	50	49
10	Nürnberg	34	59	54	44
11	Hessen	34	43	54	42
12	Waldhof	34	40	46	39
13	1860	34	28	52	38
14	Bayern	34	43	54	34
15	Memmingen	34	37	54	33
16	Pfullendorf	34	40	65	33
17	Frankfurt	34	45	70	28
18	Bayern	34	39	76	26

TEMPORADA 2010/2011

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Bayern	34	76	36	66
2	Waldgirmes	34	76	56	58
3	Baunatal	34	75	56	58
4	Eschborn	34	78	58	57
5	Vellmar	34	76	65	55
6	Kickers	34	71	60	54
7	Viktoria	34	60	51	53
8	Eintracht	34	65	65	53
9	Fernwald	34	53	49	50
10	Darmstadt	34	51	49	47
11	Eintracht	34	55	58	47
12	Rot-Weiß	34	51	47	45
13	Buchonia	34	70	71	45
14	Rot-Weiß	34	56	62	42
15	Würges	34	44	58	42
16	Hünfelder	34	44	61	32
17	Schwalmstadt	34	36	76	31
18	Marburg	34	31	90	21

TEMPORADA 2009/2010

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	VfR Aalen	34	51	19	74
2	Nürnberg	34	55	30	63
3	Freiburg II	34	63	34	61
4	Hessen	34	63	41	59
5	Karlsruher	34	50	51	52
6	Ulm	34	52	45	51
7	1860	34	51	39	49
8	Eintracht	34	57	41	48
9	Stuttgarter	34	43	39	48
10	Weiden	34	57	67	48
11	Greuther	34	44	58	47
12	Sonnenhof	34	53	44	46
13	Pfullendorf	34	39	41	41
14	Reutlingen	34	43	56	40
15	Darmstadt	34	39	49	34
16	Wehen	34	32	56	29
17	Eintracht	34	40	76	28
18	Bayern	34	23	69	19

TEMPORADA 2008/2009

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Waldgirmes	36	85	45	75
2	Bayern	36	75	46	69
3	Viktoria	36	76	50	63
4	Kickers	36	68	52	57
5	Baunatal	36	77	62	54
6	Eschborn	36	58	45	54
7	Klein-Karben	36	64	60	51
8	Eintracht	36	56	52	51
9	Vellmar	36	53	58	51
10	Hünfelder	36	66	61	49
11	Rot-Weiß	36	57	58	49
12	Fernwald	36	53	49	46
13	Würges	36	49	45	46
14	Wörsdorf	36	37	35	46
15	Germania	36	47	51	43
16	Buchonia	36	54	80	39
17	Borussia	36	39	60	35
18	Hessen	36	39	85	33
19	Lohfelden	36	31	90	24

TEMPORADA 2007/2008

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Darmstadt	34	73	37	69
2	Wehen	34	71	37	64
3	Viktoria	34	50	27	61
4	Eintracht	34	74	43	58
5	Waldgirmes	34	56	55	56
6	Wörsdorf	34	56	47	52
7	Bayern	34	54	50	50
8	Baunatal	34	55	46	49
9	Lohfelden	34	52	58	45
10	Borussia	34	53	50	44
11	Fernwald	34	50	55	42
12	Germania	34	40	52	41
13	Klein-Karben	34	56	64	40
14	Würges	34	36	55	39
15	Rot-Weiß	34	47	59	38
16	Buchonia	34	41	56	37
17	Eintracht	34	30	55	31
18	Schwalmstadt	34	37	85	25

Competiciones que juega

Grupo 11

Oberliga Grupo 11

Pos	Equipos		Pts
1		FC Giessen	64
2		KSV Baunatal	60
3		Türkgücü Friedberg	59
4		Bayern Alzenau	59
5		Eddersheim	52
6		Hünfelder SV	48
7		Hanauer SC 1960	47
8		Fernwald	43
9		Adler Weidenhausen	43
10		Rot-Weiß Walldorf	39
11		Waldgirmes	36
12		Eintracht Stadtallendorf	34
13		FC Hanau 93	33
14		Marburg	33
15		FC Erlensee	26
16		SV Steinbach 1920	26
17		Viktoria Griesheim	23
18		Dietkirchen	21

	Ascenso : FC Giessen
	Descenso : FC Erlensee, SV Steinbach 1920, Viktoria Griesheim, Dietkirchen

RIVALES EN Oberliga

USO DE MEMORIA

7,126,520 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.6045
Total Execution Time	0.6060

CADENA URL

/historico/Bayern-Alzenau

GET DATOS

$_GET['/historico/Bayern-Alzenau']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0254	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72701
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5687 AND type_rel = 2
0.0132	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 = '5687' ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '5687' 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 = 72701 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=5687 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 (72701,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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 72701 AND teamId = 5687
0.0137	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5687
0.0141	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 = 72701 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129	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 = '5687' 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 = '5687' 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 = '5687' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0165	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 = 72701 WHERE rp.league_id = 72701 AND rp.teamId = 5687 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.0147	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 = 72701 WHERE rp.league_id = 72701 AND rp.teamId = 5687 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143	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 = 72701 WHERE rp.league_id = 72701 AND rp.teamId = 5687 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 = 5687 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 = 72701 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.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* `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 = 68314 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.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* `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 = 63907 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* `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 = 66896 AND t.round = 12 ORDER BY team.conference ASC,t.position 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* `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 = 57336 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.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 = 50105 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.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* `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 = 44342 AND t.round = 34 ORDER BY team.conference 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* `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 = 49825 AND t.round = 3 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* `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 = 38844 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 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 = 43568 AND t.round = 3 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* `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 = 33441 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* `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 = 15535 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* `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 = 4383 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* `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 = 3541 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* `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 = 2005 AND t.round = 38 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* `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 = 1332 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* `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 = 19834 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* `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 = 16432 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* `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 = 19855 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Bayern Alzenau

Bayern Alzenau

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 11

RIVALES EN Oberliga