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

Borussia Neunkirchen

Temporada 2023/2024

TEMPORADA 2023/2024

LANDESLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Eppelborn	31	85	34	69
2	Hertha	31	91	27	67
3	Jägersburg	31	72	39	63
4	Borussia	31	59	52	55
5	Rot-Weiß	31	70	51	54
6	Herrensohr	31	67	58	49
7	Homburg	31	63	53	47
8	Ballweiler-W	31	60	76	45
9	Saar	31	56	58	40
10	Köllerbach	31	70	69	39
11	Schwalbach	31	50	63	38
12	SC Reisbach	31	49	86	37
13	Preußen	31	48	58	35
14	Elversberg	31	50	65	32
15	Mettlach	31	46	61	30
16	Primstal	31	47	67	29
17	Bliesmengen-	31	48	77	29
18	Marpingen-Ur	31	50	87	25

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

TEMPORADA 2010/2011

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Idar-Oberste	36	69	35	67
2	Pirmasens	36	51	40	63
3	Betzdorf	36	55	43	60
4	Hauenstein	36	61	53	58
5	Zweibrücken	36	49	32	55
6	Köllerbach	36	57	46	55
7	Borussia	36	60	54	54
8	Mechtersheim	36	62	52	53
9	Elversberg	36	48	51	50
10	Eintracht	36	53	59	47
11	Wirges	36	42	52	47
12	Alemannia	36	58	65	46
13	Roßbach	36	46	55	46
14	Saarbrücken	36	61	54	45
15	Gonsenheim	36	57	62	45
16	Rot-Weiß	36	47	52	44
17	Bad Breisig	36	57	71	37
18	Auersmacher	36	44	79	36
19	Sportfreunde	36	36	58	33

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

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Saarbrücken	34	94	23	81
2	Homburg	34	67	29	74
3	Pirmasens	34	58	45	57
4	Borussia	34	49	32	56
5	Idar-Oberste	34	64	43	55
6	Betzdorf	34	48	37	55
7	Wirges	34	48	37	55
8	Roßbach	34	45	45	49
9	Rot-Weiß	34	41	40	46
10	Mechtersheim	34	43	56	46
11	Hauenstein	34	39	47	40
12	TuS Mayen	34	41	52	39
13	Zweibrücken	34	28	37	38
14	Köllerbach	34	40	62	38
15	Alemannia	34	46	57	36
16	Elversberg	34	36	64	27
17	Bad Breisig	34	34	63	26
18	Mettlach	34	36	88	24

TEMPORADA 2007/2008

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mainz 05 II	34	87	22	76
2	Kaiserslaute	34	64	26	68
3	Wormatia	34	59	28	68
4	Eintracht	34	61	30	67
5	Saarbrücken	34	70	34	65
6	Borussia	34	48	24	64
7	Homburg	34	49	41	50
8	Wirges	34	47	47	50
9	Hauenstein	34	47	52	46
10	Pirmasens	34	48	49	45
11	Idar-Oberste	34	47	54	42
12	Roßbach	34	41	53	41
13	TuS Mayen	34	51	59	37
14	Mechtersheim	34	53	76	37
15	Köllerbach	34	35	69	31
16	Rot-Weiß	34	30	64	28
17	Eintracht	34	27	86	22
18	Engers 07	34	26	76	17

TEMPORADA 2006/2007

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ludwigshafen	32	69	24	75
2	Mainz 05 II	32	62	26	66
3	Wormatia	32	62	24	65
4	Homburg	32	52	42	56
5	Eintracht	32	59	44	53
6	Saarbrücken	32	55	37	51
7	Wirges	32	50	43	42
8	Hauenstein	32	39	42	41
9	Engers 07	32	35	42	41
10	Borussia	32	46	42	40
11	TuS Mayen	32	31	42	39
12	Rot-Weiß	32	38	56	37
13	Eintracht	32	34	51	36
14	Mechtersheim	32	36	54	31
15	Salmrohr	32	40	59	31
16	Betzdorf	32	26	62	23
17	Hohenecken	32	33	77	17

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 2002/2003

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Unterhaching	32	69	30	66
2	Jahn	32	57	22	61
3	FC Augsburg	32	51	33	56
4	Saarbrücken	32	37	32	53
5	Hoffenheim	32	55	37	51
6	Rot-Weiss	32	42	39	48
7	Pfullendorf	32	46	50	46
8	Bayern	32	39	31	45
9	VfR Aalen	33	45	51	44
10	Wehen	32	44	41	43
11	Siegen	32	41	46	42
12	Kickers	32	36	33	41
13	Kaiserslaute	32	40	39	41
14	Darmstadt	32	38	46	39
15	Elversberg	33	33	49	39
16	Schweinfurt	32	46	48	36
17	Stuttgarter	33	36	53	36
18	Eintracht	32	31	55	29
19	Borussia	33	21	72	15

TEMPORADA 2001/2002

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Borussia	34	63	18	73
2	Mainz 05 II	34	65	23	69
3	Salmrohr	34	59	43	64
4	Idar-Oberste	34	66	44	61
5	Wirges	34	77	52	60
6	Sportfreunde	34	48	37	60
7	Pirmasens	34	63	39	56
8	Hamm / Sieg	34	60	50	49
9	Homburg	34	55	45	49
10	Hauenstein	34	48	50	46
11	TuS Koblenz	34	41	37	44
12	TuS Mayen	34	53	64	39
13	Halberg	34	45	62	37
14	Ingelheim	34	43	66	32
15	Wormatia	34	35	67	30
16	Eintracht	34	49	75	28
17	Mettlach	34	32	88	26
18	Saar	34	32	74	21

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

Competiciones que juega

Grupo 6

Landesliga Grupo 6

Pos	Equipos		Pts
1		Eppelborn	69
2		Hertha Wiesbach	67
3		FSV Jägersburg	63
4		Borussia Neunkirchen	55
5		Rot-Weiß Hasborn	54
6		TuS Herrensohr	49
7		FC 08 Homburg II	47
8		DJK Ballweiler-Wecklingen	45
9		Saar Saarbrücken	40
10		Köllerbach	39
11		FV Schwalbach	38
12		SC Reisbach	37
13		SV Preußen Merchweiler	35
14		SV 07 Elversberg II	32
15		Mettlach	30
16		Primstal	29
17		SV Bliesmengen-Bolchen	29
18		SG Marpingen-Urexweiler	25

RIVALES EN Landesliga

USO DE MEMORIA

7,746,792 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1431
Total Execution Time	0.1444

CADENA URL

/historico/Borussia-Neunkirchen

GET DATOS

$_GET['/historico/Borussia-Neunkirchen']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0031	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 = 'Borussia-Neunkirchen' 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=61567 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=61567 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044	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 = 73077
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61567 AND type_rel = 2
0.0026	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 = '61567' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '61567' 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 = 73077 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=61567 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 (73077) 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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 73077 AND teamId = 61567
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 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 = 73077 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019	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 = 73077 WHERE rp.league_id = 73077 AND rp.teamId = 61567 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.0019	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 = 73077 WHERE rp.league_id = 73077 AND rp.teamId = 61567 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 = 73077 WHERE rp.league_id = 73077 AND rp.teamId = 61567 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 61567 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73077 AND t.round = 31 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* `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.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* `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.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* `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.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* `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.0050	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
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* `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 = 19832 AND t.round = 38 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* `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.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* `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 = 19856 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables2008` 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 = 19867 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* `tables2007` 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 = 19876 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* `tables2006` 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 = 19885 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* `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.0027	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.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* `tables2003` 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 = 16451 AND t.round = 34 ORDER BY team.conference 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* `tables2002` 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 = 28322 AND t.round = 34 ORDER BY team.conference 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* `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.0031	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.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* `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

Borussia Neunkirchen

Borussia Neunkirchen

Selecciona un equipo

Competiciones que juega

Landesliga Grupo 6

RIVALES EN Landesliga