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

Hassia Bingen

Temporada 2023/2024

TEMPORADA 2023/2024

LANDESLIGA GRUPO 26
Equipo		PJ	GF	GC	Puntos
1	Idar-Oberste	26	63	22	60
2	Jahn Zeiskam	26	58	31	48
3	Basara Mainz	26	56	35	48
4	Viktoria	26	46	25	48
5	Eintracht	26	54	39	42
6	Marienborn	26	42	33	40
7	1881	26	48	50	40
8	Bienwald	26	44	56	35
9	Pirmasens	26	43	48	32
10	Steinwenden	26	42	46	31
11	Offenbach	26	37	48	31
12	Bretzenheim	26	38	48	29
13	Russingen	26	43	57	29
14	Hermersberg	26	30	57	26
15	Hassia	26	27	45	25
16	Hohenecken	26	34	65	20

TEMPORADA 2021/2022

OBERLIGA GRUPO 22
Equipo		PJ	GF	GC	Puntos
1	Pfeddersheim	34	65	61	51
2	Sportfreunde	32	79	56	46
3	Kaiserslaute	32	58	60	45
4	Elversberg	34	62	77	45
5	Mülheim-Kä	32	42	52	43
6	Jägersburg	34	66	69	40
7	Salmrohr	32	43	69	37
8	Eppelborn	34	48	78	35
9	Hassia	32	41	77	23
10	Emmelshausen	32	28	72	22
11	FV Speyer	34	48	100	21
12	Rochling	22	29	43	0

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 2009/2010

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Homburg	34	53	32	64
2	Pirmasens	34	53	34	64
3	Zweibrücken	34	41	31	59
4	Idar-Oberste	34	48	35	56
5	Auersmacher	34	75	69	55
6	Mechtersheim	34	55	50	49
7	Sportfreunde	34	53	67	49
8	Alemannia	34	54	61	48
9	Hauenstein	34	50	40	47
10	Elversberg	34	60	51	46
11	Köllerbach	34	57	59	46
12	Borussia	34	53	47	45
13	Betzdorf	34	51	49	45
14	Roßbach	34	44	49	42
15	Rot-Weiß	34	47	64	38
16	Wirges	34	36	51	32
17	TuS Mayen	34	42	56	30
18	Hassia	34	44	71	30

TEMPORADA 2005/2006

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pirmasens	32	60	17	71
2	Homburg	32	61	34	68
3	Mainz 05 II	32	55	35	56
4	Wormatia	32	58	35	52
5	Saarbrücken	32	57	35	52
6	Ludwigshafen	32	55	40	52
7	Eintracht	32	58	43	48
8	Hauenstein	32	56	52	48
9	Borussia	32	47	42	42
10	Wirges	32	40	41	40
11	TuS Mayen	32	39	52	39
12	Engers 07	32	51	72	39
13	Mechtersheim	32	43	48	38
14	Eintracht	32	31	58	34
15	Rot-Weiß	32	25	55	29
16	Betzdorf	32	35	62	28
17	Hassia	32	25	75	20

TEMPORADA 2004/2005

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Borussia	34	66	30	70
2	Kaiserslaute	34	76	28	69
3	Hauenstein	34	66	34	67
4	Homburg	34	69	33	64
5	Weingarten	34	61	42	64
6	Saarbrücken	34	59	40	57
7	Eintracht	34	70	60	55
8	Wormatia	34	44	48	49
9	Hassia	34	44	51	47
10	Pirmasens	34	49	57	44
11	Engers 07	34	43	48	39
12	TuS Mayen	34	37	44	38
13	Mechtersheim	34	46	70	38
14	Betzdorf	34	32	57	38
15	Wirges	34	46	57	37
16	Ingelheim	34	41	70	37
17	Idar-Oberste	34	44	71	28
18	Halberg	34	35	88	13

TEMPORADA 2003/2004

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	TuS Koblenz	34	69	19	73
2	Weingarten	34	70	31	69
3	Wormatia	34	47	38	61
4	Homburg	34	52	44	60
5	Saarbrücken	34	68	37	59
6	Eintracht	34	59	51	58
7	Wirges	34	68	38	56
8	Hauenstein	34	57	40	56
9	Engers 07	34	45	58	46
10	TuS Mayen	34	42	55	45
11	Borussia	34	48	46	43
12	Pirmasens	34	50	56	41
13	Hassia	34	43	48	39
14	Ingelheim	34	47	56	39
15	Idar-Oberste	34	38	71	36
16	Salmrohr	34	40	62	34
17	Köllerbach	34	40	76	23
18	SV Klausen	34	18	75	13

TEMPORADA 2000/2001

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kaiserslaute	40	89	27	85
2	Homburg	40	91	47	73
3	Hamm / Sieg	40	76	38	72
4	Borussia	39	71	34	72
5	Wirges	40	85	50	71
6	Salmrohr	39	78	41	70
7	Mainz 05 II	40	81	45	70
8	Pirmasens	40	53	35	68
9	TuS Koblenz	40	70	40	64
10	Sportfreunde	40	59	47	63
11	Eintracht	40	54	56	63
12	Idar-Oberste	40	57	59	51
13	Halberg	39	54	63	51
14	Mettlach	40	45	68	51
15	Hauenstein	40	57	59	50
16	Wormatia	40	66	76	50
17	Saarbrücken	39	53	62	44
18	Rot-Weiß	40	36	78	31
19	Hassia	39	32	98	25
20	Germania	40	28	110	22
21	SV Prüm	35	19	121	7

TEMPORADA 1999/2000

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Borussia	36	82	36	81
2	Hamm / Sieg	36	63	38	71
3	Mainz 05 II	36	66	33	63
4	Homburg	36	55	35	63
5	Wirges	36	66	45	61
6	Sportfreunde	36	50	31	60
7	Wormatia	36	36	38	57
8	Hauenstein	36	53	47	52
9	TuS Koblenz	36	50	56	51
10	Halberg	36	58	49	50
11	Saarbrücken	36	61	58	49
12	Rot-Weiß	36	34	39	47
13	Hassia	36	29	39	45
14	SV Prüm	36	42	51	41
15	TuS Mayen	36	48	62	35
16	Betzdorf	36	31	46	35
17	Pfeddersheim	36	31	64	29
18	VfB Theley	36	39	65	28
19	Montabaur	36	22	84	18

TEMPORADA 1998/1999

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Idar-Oberste	34	74	31	73
2	Pirmasens	34	63	24	72
3	Borussia	34	73	37	69
4	Sportfreunde	34	77	33	65
5	Saarbrücken	34	54	32	52
6	Hamm / Sieg	34	46	44	47
7	Wirges	34	51	61	46
8	Hauenstein	34	60	57	45
9	Montabaur	34	45	46	45
10	Betzdorf	34	39	65	43
11	SV Prüm	34	45	50	42
12	Wormatia	34	54	56	41
13	Halberg	34	55	63	41
14	TuS Koblenz	34	38	43	38
15	Pfeddersheim	34	36	50	36
16	Hassia	34	30	44	35
17	Schiffweiler	34	45	87	35
18	Mettlach	34	25	87	16

TEMPORADA 1997/1998

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Elversberg	34	87	35	78
2	Sportfreunde	34	85	33	70
3	Halberg	34	69	53	68
4	Hamm / Sieg	34	75	36	66
5	Idar-Oberste	34	65	32	65
6	Borussia	34	69	37	61
7	Hauenstein	34	80	41	59
8	Pirmasens	34	65	49	52
9	Montabaur	34	56	57	43
10	TuS Koblenz	34	42	45	43
11	Schiffweiler	34	46	60	41
12	Mettlach	34	53	82	39
13	SV Prüm	34	46	66	32
14	Pfeddersheim	34	48	73	32
15	Hassia	34	39	64	30
16	Auersmacher	34	44	87	29
17	Eintracht	34	53	98	25
18	VfL Trier	34	22	96	13

TEMPORADA 1996/1997

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Kaiserslaute	34	82	24	79
2	Idar-Oberste	34	75	37	67
3	Mettlach	34	63	50	58
4	Hamm / Sieg	34	55	35	57
5	Sportfreunde	34	58	49	53
6	VfL Trier	34	48	53	49
7	Borussia	34	56	37	48
8	Schiffweiler	34	49	58	46
9	Hassia	34	53	54	45
10	Auersmacher	34	50	55	41
11	TuS Koblenz	34	30	40	39
12	Pfeddersheim	34	36	48	39
13	SV Prüm	34	36	49	39
14	Eintracht	34	45	73	38
15	Saarbrücken	34	38	49	37
16	SV Wittlich	34	33	50	37
17	RWO Alzey	34	42	56	32
18	Betzdorf	34	42	74	25

TEMPORADA 1995/1996

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Elversberg	34	80	44	66
2	TuS Koblenz	34	52	23	63
3	Pfeddersheim	34	51	22	63
4	Hassia	34	60	37	59
5	Mettlach	34	58	51	55
6	Auersmacher	34	50	42	53
7	Hamm / Sieg	34	53	36	51
8	SV Wittlich	34	56	44	50
9	Saarbrücken	34	54	46	50
10	Sportfreunde	34	59	47	48
11	Idar-Oberste	34	67	55	47
12	VfL Trier	34	49	50	47
13	Schiffweiler	34	59	54	45
14	Betzdorf	34	53	55	45
15	Edenkoben	34	40	72	36
16	Wirges	34	28	65	28
17	Südwest	34	30	93	19
18	VfB Wissen	34	11	74	6

TEMPORADA 1994/1995

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Kaiserslaute	34	80	23	77
2	Sportfreunde	34	82	32	70
3	TuS Koblenz	34	54	37	61
4	Mettlach	34	55	46	57
5	SV Wittlich	34	59	35	54
6	Südwest	34	56	40	51
7	Saarbrücken	34	45	34	51
8	Pfeddersheim	34	50	37	50
9	Hamm / Sieg	34	46	42	45
10	Hassia	34	43	41	45
11	Betzdorf	34	50	42	43
12	Wirges	34	33	48	42
13	Elversberg	34	49	66	38
14	Schiffweiler	34	40	48	37
15	Saarwellinge	34	45	53	36
16	SV Prüm	34	25	52	31
17	Dillingen	34	28	85	21
18	TuS Mayen	34	29	108	12

TEMPORADA 1952/1953

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kaiserslaute	30	127	31	74
2	Saarbrücken	30	89	39	68
3	Neuendorf	30	97	28	67
4	Wormatia	30	85	58	53
5	Tura	30	57	47	46
6	Borussia	30	36	46	43
7	Pirmasens	30	64	56	42
8	Mainz 05	30	59	55	42
9	Saar	30	54	62	40
10	Kaiserslaute	30	55	72	39
11	FV Speyer	30	33	39	38
12	Eintracht	30	43	66	33
13	Phönix	30	44	68	33
14	VfR Kirn	30	41	73	31
15	Engers 07	30	46	81	27
16	Hassia	30	32	141	3

Competiciones que juega

Grupo 26

Landesliga Grupo 26

Pos	Equipos		Pts
1		Idar-Oberstein	60
2		TB Jahn Zeiskam	48
3		Basara Mainz	48
4		Viktoria Herxheim	48
5		Eintracht Bad Kreuznach	42
6		TuS Marienborn	40
7		TSV 1881 Gau-Odernheim	40
8		FC Bienwald Kandel	35
9		FK Pirmasens II	32
10		SV Steinwenden	31
11		FSV Offenbach	31
12		Bretzenheim	29
13		Russingen	29
14		SV Hermersberg	26
15		Hassia Bingen	25
16		Tus Hohenecken	20

RIVALES EN Landesliga

USO DE MEMORIA

7,247,024 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.6449
Total Execution Time	0.6463

CADENA URL

/historico/Hassia-Bingen

GET DATOS

$_GET['/historico/Hassia-Bingen']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0157	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 = 'Hassia-Bingen' 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.0126	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=83282 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=83282 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=83282 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256	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 = 73070
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83282 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2090 AND type_rel = 3
0.0126	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.0127	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.0133	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 = '83282' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 73070 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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=83282 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 (73070,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.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 73070 AND teamId = 83282
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 83282
0.0127	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 = '83282' 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 = '83282' and rp.type = 4
0.0133	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 = '83282' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0133	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 = 73070 WHERE rp.league_id = 73070 AND rp.teamId = 83282 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.0133	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 = 73070 WHERE rp.league_id = 73070 AND rp.teamId = 83282 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 = 73070 WHERE rp.league_id = 73070 AND rp.teamId = 83282 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 = 83282 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73070 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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.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* `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 = 66978 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 = 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.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* `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.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 = 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.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 = 19845 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* `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 = 28291 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* `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 = 28292 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* `tables2001` 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 = 28317 AND t.round = 42 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* `tables2000` 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 = 28333 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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* `tables1999` 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 = 28355 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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* `tables1998` 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 = 28346 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* `tables1997` 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 = 28363 AND t.round = 34 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* `tables1996` 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 = 28373 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* `tables1995` 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 = 28390 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* `tables1953` 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 = 47460 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Hassia Bingen

Hassia Bingen

Selecciona un equipo

Competiciones que juega

Landesliga Grupo 26

RIVALES EN Landesliga