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

Erlangen-Bruck

Temporada 2023/2024

TEMPORADA 2023/2024

LANDESLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eintracht	32	71	36	68
2	FSV Stadeln	32	60	29	63
3	TSV Buch	31	57	30	63
4	Schwabach	32	55	45	52
5	Großschwarz	32	63	37	51
6	Buckenhofen	31	54	43	51
7	Jahn	32	49	50	47
8	Weisendorf	32	43	50	47
9	1860	32	42	42	44
10	Unterreichen	31	46	50	39
11	Erlangen-Bru	32	45	56	38
12	Mitterteich	32	38	52	38
13	Quelle Furth	32	50	67	38
14	Baiersdorfer	31	52	49	36
15	Bayreuth	32	46	68	36
16	Herzogenaura	31	42	58	31
17	Vorwärts	31	48	67	31
18	Katschenreut	32	43	75	27

TEMPORADA 2021/2022

LANDESLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Herzogenaura	18	36	19	35
2	Jahn	18	37	17	34
3	Neudrossenfe	18	39	21	34
4	FSV Stadeln	18	27	25	29
5	Vorwärts	18	26	25	29
6	Kickers Selb	18	32	36	23
7	Eintracht	18	22	27	22
8	Erlangen-Bru	18	29	39	21
9	ASV Vach	18	18	38	17
10	Mitterteich	18	20	39	10
11	Kornburg	16	52	10	46
12	Schwabach	16	41	21	31
13	TSV Buch	16	24	30	25
14	1860	16	26	28	20
15	Quelle Furth	16	27	25	19
16	Türkspor	16	29	36	19
17	Großschwarz	16	19	35	18
18	SV Schwaig	16	17	31	14
19	Woffenbach	16	16	35	13

TEMPORADA 2019/2020

LANDESLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Feucht SC	22	61	14	53
2	TSV Buch	21	50	23	43
3	Schwabach	22	42	22	42
4	Neudrossenfe	23	48	36	39
5	Kickers Selb	22	56	32	38
6	FSV Stadeln	21	40	24	38
7	Jahn	23	32	25	36
8	Erlangen-Bru	23	43	30	34
9	ASV Vach	22	36	33	30
10	Quelle Furth	21	33	39	28
11	Mitterteich	20	33	36	27
12	SV Schwaig	21	26	34	26
13	Vorwärts	21	33	52	25
14	Kornburg	21	31	44	24
15	Herzogenaura	23	39	53	24
16	Großschwarz	21	23	42	21
17	Feuchtwangen	21	28	59	16
18	Baiersdorfer	22	20	76	4

TEMPORADA 2018/2019

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Aubstadt	34	83	27	76
2	Gebenbach	34	83	42	73
3	Würzburger	34	67	39	66
4	Grossbardorf	34	67	39	65
5	Seligenporte	34	69	50	62
6	Eltersdorf	34	56	45	53
7	Bayern Hof	34	54	45	49
8	DJK Bamberg	34	44	39	48
9	Würzburger	34	60	69	48
10	Abtswind	34	59	67	45
11	SpVgg	34	68	77	43
12	Ammerthal	34	51	52	39
13	ATSV	34	43	60	39
14	1. FC Sand	34	42	66	35
15	ASV Vach	34	45	76	33
16	Erlangen-Bru	34	53	74	31
17	Jahn	34	58	86	30
18	Neumarkt	34	35	84	28

TEMPORADA 2017/2018

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Viktoria	34	91	29	82
2	Aubstadt	34	71	33	70
3	Würzburger	34	71	36	67
4	Gebenbach	34	76	51	64
5	Eltersdorf	34	65	44	64
6	Jahn	34	78	67	54
7	SpVgg	34	74	61	53
8	Grossbardorf	34	51	47	51
9	Erlangen-Bru	34	53	75	44
10	Bayern Hof	34	61	59	43
11	Würzburger	34	47	49	42
12	Ammerthal	34	65	67	41
13	DJK Bamberg	34	44	50	40
14	Weiden	34	51	77	40
15	1. FC Sand	34	39	57	30
16	Schweinfurt	34	33	54	30
17	Erlenbach	34	43	94	23
18	Amberg	34	37	100	15

TEMPORADA 2016/2017

LANDESLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Kornburg	34	82	36	75
2	Erlangen-Bru	34	75	44	72
3	Quelle Furth	34	79	49	69
4	TSV Buch	34	71	38	68
5	ATSV	34	70	43	58
6	ASV Vach	34	55	37	56
7	Baiersdorfer	34	62	55	56
8	Neudrossenfe	34	61	50	54
9	Schwabach	34	58	53	44
10	SpVgg	34	48	53	44
11	Veitsbronn	34	52	61	43
12	Bayreuth	34	57	70	38
13	Vorwärts	34	44	55	36
14	Mitterteich	34	43	56	36
15	Bayreuth	34	51	74	34
16	ASV Pegnitz	34	50	74	33
17	Türkspor	34	57	100	28
18	Kasendorf	34	34	101	12

TEMPORADA 2015/2016

LANDESLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Neumarkt	34	85	30	81
2	Kornburg	34	89	37	72
3	Quelle Furth	34	61	35	59
4	ASV Vach	34	46	40	54
5	Neudrossenfe	34	58	39	52
6	TSV Buch	34	58	48	51
7	Türkspor	34	52	56	51
8	SpVgg	34	57	55	49
9	ASV Pegnitz	34	52	56	46
10	Erlangen-Bru	34	42	53	43
11	Vorwärts	34	42	47	41
12	Veitsbronn	34	53	62	39
13	Kasendorf	34	48	67	39
14	FSV Stadeln	34	50	69	37
15	Poppenreuth	34	49	74	36
16	Baiersdorfer	34	42	69	33
17	Seligenporte	34	45	68	31
18	SV Friesen	34	41	65	31

TEMPORADA 2014/2015

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Viktoria	34	98	33	79
2	Amberg	34	76	30	73
3	Jahn	34	62	48	61
4	Weiden	34	64	34	60
5	Grossbardorf	34	45	26	59
6	Jahn	34	71	54	59
7	Eltersdorf	34	65	52	54
8	Bayern Hof	34	46	32	53
9	Aubstadt	34	46	41	52
10	Erlenbach	34	39	39	46
11	Würzburger	34	45	48	45
12	Alemannia	34	43	54	43
13	Frohnlach	34	52	69	41
14	Ammerthal	34	34	68	32
15	SpVgg	34	46	73	31
16	Erlangen-Bru	34	37	72	25
17	Neudrossenfe	34	39	73	21
18	Memmelsdorf	34	27	89	13

TEMPORADA 2013/2014

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Bayreuth	34	69	27	81
2	Aubstadt	34	60	30	65
3	Jahn	34	62	39	63
4	Amberg	34	57	44	60
5	Weiden	34	63	39	58
6	Grossbardorf	34	64	53	54
7	Jahn	34	65	41	53
8	Eltersdorf	34	59	48	53
9	Erlenbach	34	43	33	51
10	Würzburger	34	41	51	45
11	Frohnlach	34	52	53	43
12	Ammerthal	34	44	55	42
13	Memmelsdorf	34	43	58	39
14	Erlangen-Bru	34	39	52	37
15	Alemannia	34	41	54	35
16	Selbitz	34	39	72	35
17	Neumarkt	34	37	67	28
18	Hollfeld	34	22	84	12

TEMPORADA 2012/2013

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schweinfurt	34	81	31	77
2	Jahn	34	79	48	72
3	Amberg	34	73	34	70
4	Grossbardorf	34	80	44	70
5	Würzburger	34	90	52	62
6	Bayreuth	34	74	53	62
7	Ammerthal	34	58	49	47
8	Aubstadt	34	64	61	46
9	Memmelsdorf	34	52	59	44
10	Alemannia	34	53	52	42
11	Selbitz	34	48	67	39
12	Neumarkt	34	47	67	37
13	Erlangen-Bru	34	57	86	37
14	Hollfeld	34	43	85	36
15	DJK Bamberg	34	39	55	33
16	Trogen	34	40	61	33
17	1. FC Sand	34	42	73	31
18	Kleinrinderf	34	42	85	20

TEMPORADA 2011/2012

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rosenheim	34	72	34	70
2	Bayern Hof	34	55	27	64
3	Eltersdorf	34	70	50	58
4	Buchbach	34	65	49	56
5	Rain / Lech	34	50	44	55
6	Seligenporte	34	51	44	52
7	Frohnlach	34	62	46	51
8	Eintracht	34	62	57	51
9	Ismaning	34	52	47	47
10	Grossbardorf	34	49	65	46
11	Erlangen-Bru	34	37	49	44
12	Würzburger	34	55	66	43
13	Schweinfurt	34	58	70	41
14	Rosenheim	34	53	59	39
15	Heimstetten	34	56	67	38
16	Aindling	34	41	58	32
17	Gersthofen	34	49	82	27
18	Unterhaching	34	35	58	26

TEMPORADA 2010/2011

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ismaning	34	72	48	66
2	Ingolstadt	34	75	48	63
3	Rosenheim	34	58	39	53
4	Buchbach	34	58	51	53
5	Würzburger	34	57	52	52
6	Seligenporte	34	59	56	52
7	Unterhaching	34	53	44	51
8	Eintracht	34	54	61	51
9	Schweinfurt	34	48	50	50
10	Grossbardorf	34	53	54	45
11	Erlangen-Bru	34	59	70	45
12	Rain / Lech	34	52	47	44
13	Aindling	34	40	39	43
14	Heimstetten	34	53	53	43
15	Bayern Hof	34	50	56	41
16	Bayreuth	34	45	63	41
17	Schalding-He	34	47	66	32
18	Freier TuS	34	38	74	23

TEMPORADA 2009/2010

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Memmingen	36	57	23	74
2	Ismaning	36	70	47	63
3	Unterhaching	36	65	48	62
4	Aindling	36	60	46	59
5	Rain / Lech	36	54	45	59
6	Ingolstadt	36	61	53	58
7	Seligenporte	36	61	53	58
8	Erlangen-Bru	36	56	43	56
9	Bayreuth	36	44	34	54
10	Bayern Hof	36	45	44	52
11	Buchbach	36	71	62	49
12	Rosenheim	36	53	47	49
13	Schalding-He	36	46	65	47
14	Grossbardorf	36	49	50	44
15	SpVgg	36	42	57	42
16	Frohnlach	36	43	59	40
17	Memmelsdorf	36	36	74	29
18	Thannhausen	36	43	77	28
19	Kötzting	36	43	72	24

TEMPORADA 2008/2009

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Weiden	34	66	29	74
2	Aindling	34	69	27	65
3	Memmingen	34	48	34	59
4	Bayreuth	34	48	38	55
5	Erlangen-Bru	34	60	44	53
6	Ingolstadt	34	50	42	52
7	Frohnlach	34	64	56	45
8	Buchbach	34	47	44	45
9	Thannhausen	34	53	55	43
10	Bayern Hof	34	41	45	42
11	Ismaning	34	61	60	41
12	SpVgg	34	37	49	40
13	Kötzting	34	42	65	39
14	Würzburger	34	45	52	38
15	Seligenporte	34	41	55	38
16	Rain / Lech	34	47	67	38
17	Schweinfurt	34	39	66	36
18	Würzburger	34	52	82	30

Competiciones que juega

Grupo 2

Landesliga Grupo 2

Pos	Equipos		Pts
1		FC Eintracht Münchberg	68
2		FSV Stadeln	63
3		TSV Buch	63
4		SC 04 Schwabach	52
5		SC Großschwarzenlohe	51
6		SV Buckenhofen	51
7		Jahn Forchheim	47
8		ASV Weisendorf	47
9		TSV 1860 Weissenburg	44
10		SV Unterreichenbach	39
11		Erlangen-Bruck	38
12		SV Mitterteich	38
13		Quelle Furth	38
14		Baiersdorfer SV	36
15		Bayreuth II SpVgg	36
16		FC Herzogenaurach	31
17		FC Vorwärts Röslau	31
18		VfR Katschenreuth	27

RIVALES EN Landesliga

USO DE MEMORIA

6,834,864 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.4858
Total Execution Time	0.4873

CADENA URL

/historico/Erlangen-Bruck

GET DATOS

$_GET['/historico/Erlangen-Bruck']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0216	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 = 73059
0.0111	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61539 AND type_rel = 2
0.0110	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2090 AND type_rel = 3
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2090 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0113	SELECT /53 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (184451,1011237,984949) ORDER BY n.cover_points DESC, update_date DESC
0.0113	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 = '61539' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107	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 = 73059 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111	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=61539 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106	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 (73059,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.0107	SELECT count(id) as num_players from rel_players WHERE league_id = 73059 AND teamId = 61539
0.0107	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61539
0.0111	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 = 73059 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0106	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 = '61539' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61539' and rp.type = 4
0.0106	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 = '61539' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0106	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 = 73059 WHERE rp.league_id = 73059 AND rp.teamId = 61539 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.0106	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 = 73059 WHERE rp.league_id = 73059 AND rp.teamId = 61539 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113	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 = 73059 WHERE rp.league_id = 73059 AND rp.teamId = 61539 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115	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 = 61539 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0117	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 = 73059 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 66648 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 51136 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.0113	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 = 44075 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* `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 = 38869 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 46816 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 46834 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 9462 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 9568 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 19807 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 19820 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* `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 = 19831 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117	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 = 19842 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 19854 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Erlangen-Bruck

Erlangen-Bruck

Selecciona un equipo

Competiciones que juega

Landesliga Grupo 2

RIVALES EN Landesliga