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

Arminia Ludwigshafen

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Eintracht	33	101	27	89
2	Pirmasens	33	78	35	65
3	Gonsenheim	33	81	42	65
4	Auersmacher	33	61	53	58
5	Wormatia	33	65	43	57
6	Kaiserslaute	33	70	58	53
7	RW Koblenz	33	60	53	52
8	Morlautern	33	57	60	50
9	Diefflen	33	66	70	50
10	Engers 07	33	66	53	49
11	Karbach	33	64	74	48
12	Arminia	33	52	69	43
13	Mechtersheim	33	56	48	42
14	Dudenhofen	33	51	54	39
15	Cosmos	33	59	63	39
16	Alemannia	33	34	58	34
17	Baumholder	33	51	73	31
18	Pfeddersheim	33	44	83	27
19	SpVgg	33	29	73	22
20	FC Bitburg	33	42	98	17

TEMPORADA 2022/2023

OBERLIGA GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Arminia	32	63	62	53
2	Dudenhofen	32	50	44	45
3	Pfeddersheim	32	60	50	45
4	Alemannia	32	48	59	44
5	Morlautern	32	65	60	44
6	Hertha	32	61	59	43
7	Jägersburg	32	56	67	37
8	Ahrweiler	32	34	77	25
9	Kirchberg	32	44	89	25
10	Sportfreunde	32	50	89	22
11	Mülheim-Kä	32	32	78	20
12	Elversberg	32	33	90	19

TEMPORADA 2021/2022

OBERLIGA GRUPO 21
Equipo		PJ	GF	GC	Puntos
1	Eintracht	34	83	28	79
2	Wormatia	34	94	26	79
3	Arminia	34	81	59	63
4	Hertha	34	91	63	62
5	Dudenhofen	34	80	50	57
6	Engers 07	34	60	49	57
7	Gonsenheim	34	61	55	51
8	Diefflen	34	66	67	50
9	Alemannia	34	58	58	50
10	Karbach	34	60	63	46
11	Mechtersheim	34	61	64	45
12	TuS Koblenz	34	49	57	40

TEMPORADA 2020/2021

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Eintracht	8	21	2	22
2	Kaiserslaute	8	16	9	16
3	Hassia	9	19	15	16
4	Alemannia	8	16	11	13
5	TuS Koblenz	9	7	10	13
6	Gonsenheim	8	12	8	11
7	Engers 07	6	13	8	10
8	Mülheim-Kä	6	10	13	9
9	Karbach	8	8	17	8
10	Salmrohr	9	8	18	6
11	Sportfreunde	7	5	12	5
12	Emmelshausen	8	6	18	5
13	Wormatia	9	29	8	24
14	Dudenhofen	9	17	11	17
15	Diefflen	9	17	13	14
16	Arminia	9	14	13	13
17	Jägersburg	9	17	24	13
18	Rochling	9	13	13	11
19	Pfeddersheim	9	15	16	11
20	Elversberg	9	9	12	11
21	Mechtersheim	9	8	13	10
22	Hertha	9	24	22	8
23	FV Speyer	8	13	16	8
24	Eppelborn	8	11	26	4

TEMPORADA 2019/2020

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Schott Mainz	21	49	20	42
2	Kaiserslaute	21	47	25	40
3	Elversberg	21	55	37	40
4	TuS Koblenz	21	34	24	39
5	Eintracht	20	33	20	37
6	Dudenhofen	21	43	31	35
7	Wormatia	20	42	33	33
8	Gonsenheim	21	44	36	31
9	Diefflen	21	36	31	29
10	Pfeddersheim	21	45	46	28
11	Engers 07	21	29	30	28
12	Rochling	21	38	45	26
13	Hertha	21	36	48	25
14	Arminia	21	21	36	24
15	Karbach	21	32	50	21
16	Mechtersheim	21	20	34	19
17	Hassia	21	22	46	19
18	Sportfreunde	21	25	59	14

TEMPORADA 2018/2019

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	RW Koblenz	34	68	30	71
2	Rochling	34	67	38	60
3	Pfeddersheim	34	73	57	60
4	TuS Koblenz	34	54	34	59
5	Engers 07	34	59	48	59
6	Eintracht	34	67	41	57
7	Schott Mainz	34	76	55	57
8	Mechtersheim	34	57	49	53
9	Kaiserslaute	34	61	42	51
10	Hertha	34	50	43	50
11	Hassia	34	58	58	47
12	Karbach	34	48	50	45
13	Arminia	34	58	74	43
14	Diefflen	34	60	73	42
15	Jägersburg	34	49	65	35
16	Emmelshausen	34	34	71	35
17	Idar-Oberste	34	47	95	18
18	Dillingen	34	34	97	16

TEMPORADA 2016/2017

OBERLIGA GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Schott Mainz	34	110	41	74
2	Rochling	34	83	41	70
3	Hertha	34	95	50	67
4	Mechtersheim	34	78	52	62
5	RW Koblenz	34	65	51	57
6	Karbach	34	82	53	55
7	Saar	34	67	44	52
8	Pirmasens	34	68	52	52
9	Gonsenheim	34	71	60	52
10	Diefflen	34	87	71	51
11	Pfeddersheim	34	75	54	46
12	Morlautern	34	57	49	46
13	Hauenstein	34	65	55	41
14	Jägersburg	34	65	74	38
15	Salmrohr	34	57	68	37
16	Arminia	34	52	72	32
17	Borussia	34	46	71	31
18	Burgbrohl	34	9	255	1

TEMPORADA 2015/2016

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	TuS Koblenz	33	73	23	79
2	Hauenstein	33	55	29	65
3	Karbach	33	53	46	57
4	Borussia	33	57	44	54
5	Hertha	34	65	52	53
6	Pfeddersheim	33	53	40	47
7	Rochling	33	45	41	46
8	Burgbrohl	34	57	62	45
9	Jägersburg	33	52	59	45
10	Salmrohr	33	52	49	44
11	Wirges	33	42	46	44
12	Gonsenheim	33	52	60	44
13	Schott Mainz	33	74	65	42
14	Arminia	33	49	62	41
15	Pirmasens	33	48	47	40
16	Elversberg	33	57	70	37
17	Mehring	33	42	64	31
18	Zweibrücken	19	7	74	3

TEMPORADA 2014/2015

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Saar	34	56	22	70
2	Hauenstein	34	60	27	68
3	Pfeddersheim	34	49	28	65
4	Gonsenheim	34	63	42	59
5	Rochling	34	62	47	59
6	Schott Mainz	34	70	59	55
7	Salmrohr	34	58	54	55
8	Wirges	34	55	32	54
9	Elversberg	34	62	52	54
10	Hertha	34	61	56	46
11	Arminia	34	62	64	46
12	Borussia	34	51	47	44
13	Burgbrohl	34	45	53	41
14	Idar-Oberste	34	47	55	39
15	Mechtersheim	34	59	62	37
16	Diefflen	34	44	83	29
17	Saarbrücken	34	40	91	17
18	Betzdorf	34	21	91	16

TEMPORADA 2013/2014

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Pirmasens	34	62	29	65
2	Salmrohr	34	57	32	60
3	Hauenstein	34	55	41	55
4	Arminia	34	62	47	51
5	Elversberg	34	53	51	50
6	Idar-Oberste	34	53	41	48
7	Pfeddersheim	34	50	42	48
8	Hertha	34	62	62	47
9	Gonsenheim	34	51	61	46
10	Burgbrohl	34	54	68	43
11	Saarbrücken	34	43	53	42
12	Betzdorf	34	45	53	41
13	Mechtersheim	34	50	49	40
14	Rochling	34	37	56	40
15	Borussia	34	36	49	39
16	Mehring	34	48	68	39
17	Alemannia	34	50	53	37
18	Roßbach	34	43	56	37

TEMPORADA 2012/2013

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Zweibrücken	34	70	23	81
2	Salmrohr	34	86	34	73
3	Hauenstein	34	74	51	66
4	Saarbrücken	34	68	45	58
5	Borussia	34	48	39	56
6	Arminia	34	60	50	51
7	Mechtersheim	34	51	52	50
8	Pirmasens	34	50	50	49
9	Betzdorf	34	53	58	47
10	Rochling	34	53	58	46
11	Pfeddersheim	34	46	46	43
12	Roßbach	34	45	57	42
13	Mehring	34	46	55	41
14	Gonsenheim	34	53	65	41
15	Elversberg	34	54	54	38
16	Wirges	34	40	57	38
17	Halberg	34	28	79	18
18	Köllerbach	34	37	89	16

TEMPORADA 2011/2012

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Homburg	34	71	34	71
2	Zweibrücken	34	52	34	61
3	Pirmasens	34	58	36	60
4	Arminia	34	59	49	57
5	Hauenstein	34	57	52	51
6	Salmrohr	34	63	45	50
7	Borussia	34	55	49	50
8	Gonsenheim	34	53	58	49
9	Saarbrücken	34	49	45	46
10	Wirges	34	41	43	46
11	Mechtersheim	34	37	42	45
12	Elversberg	34	51	52	43
13	Rochling	34	49	54	43
14	Betzdorf	34	51	58	43
15	Roßbach	34	50	64	41
16	Köllerbach	34	48	65	38
17	Alemannia	34	41	57	37
18	Eintracht	34	38	86	20

Competiciones que juega

Grupo 8

Oberliga Grupo 8

Pos	Equipos		Pts
1		Eintracht Trier	89
2		FK Pirmasens	65
3		Gonsenheim	65
4		Auersmacher	58
5		Wormatia Worms	57
6		Kaiserslautern II	53
7		RW Koblenz	52
8		Morlautern	50
9		Diefflen	50
10		Engers 07	49
11		Karbach	48
12		Arminia Ludwigshafen	43
13		Mechtersheim	42
14		Dudenhofen	39
15		Cosmos Koblenz	39
16		Alemannia Waldalgesheim	34
17		VfR Baumholder	31
18		Pfeddersheim	27
19		SpVgg Quierschied	22
20		FC Bitburg	17

	Playoff Ascenso : Eintracht Trier
	Descenso : Mechtersheim, Dudenhofen, Cosmos Koblenz, Alemannia Waldalgesheim, VfR Baumholder, Pfeddersheim, SpVgg Quierschied, FC Bitburg

RIVALES EN Oberliga

USO DE MEMORIA

6,527,152 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1335
Total Execution Time	0.1349

CADENA URL

/historico/Arminia-Ludwigshafen

GET DATOS

$_GET['/historico/Arminia-Ludwigshafen']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0028	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Arminia-Ludwigshafen' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61561 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61561 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61561 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61561 AND type_rel = 2
0.0019	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 61561 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019	SELECT /35 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 (187491) ORDER BY n.cover_points DESC, update_date DESC
0.0021	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 = '61561' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '61561' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 72627 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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=61561 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (72627,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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72627 AND teamId = 61561
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61561
0.0041	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 = 72627 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019	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 = '61561' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61561' and rp.type = 4
0.0020	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 = '61561' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028	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 = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 61561 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.0026	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 = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 61561 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 61561 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 = 61561 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023	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 = 72627 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 68315 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.0028	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 = 71186 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.0026	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 = 63289 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.0022	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 = 66977 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.0022	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 = 57793 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.0023	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 = 50467 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.0024	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 = 44338 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 34103 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 15544 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 9464 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 9574 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 19812 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 19826 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Arminia Ludwigshafen

Arminia Ludwigshafen

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 8

RIVALES EN Oberliga