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

1860 München II

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schwaben	31	71	32	61
2	Landsberg	31	78	47	60
3	SV Erlbach	31	44	25	60
4	Heimstetten	31	54	34	59
5	Nördlingen	31	59	41	57
6	Deisenhofen	31	60	31	56
7	1860	31	56	45	49
8	Kottern	31	57	48	46
9	Kirchanschö	31	36	43	43
10	Pipinsried	30	36	33	40
11	Sonthofen	30	44	44	39
12	Rain / Lech	30	37	49	38
13	Dachau	31	50	63	37
14	Ismaning	31	39	62	36
15	Gundelfingen	31	35	51	32
16	Türkspor	30	27	41	29
17	Garching	30	29	74	18
18	Kirchheimer	30	37	86	13

TEMPORADA 2022/2023

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schalding-He	34	73	36	73
2	Memmingen	34	51	36	63
3	Landsberg	34	70	45	60
4	Ingolstadt	34	64	39	60
5	Kottern	34	57	44	60
6	Kirchanschö	34	56	45	58
7	Schwaben	34	63	52	54
8	1860	34	56	40	53
9	Gundelfingen	34	50	47	50
10	Ismaning	34	47	52	50
11	Nördlingen	34	66	64	46
12	Deisenhofen	34	56	47	44
13	SV Erlbach	34	42	36	42
14	Dachau	34	45	61	40
15	Garching	34	35	56	34
16	Türkspor	34	38	79	23
17	Rosenheim	34	37	83	21
18	Hallbergmoos	34	35	79	15

TEMPORADA 2021/2022

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hankofen-Hai	36	63	36	72
2	Donaustauf	36	80	56	66
3	Ingolstadt	36	70	40	65
4	Jahn	36	66	44	64
5	Kirchanschö	36	51	42	62
6	1860	36	55	42	51
7	Schwaben	36	47	42	51
8	Ismaning	36	45	41	51
9	Landsberg	36	55	41	50
10	Deisenhofen	36	63	50	49
11	Garching	36	46	55	45
12	Gundelfingen	36	41	47	44
13	Kottern	36	47	52	44
14	Türkspor	36	47	55	42
15	Hallbergmoos	36	43	66	39
16	Pullach	36	49	65	38
17	Dachau	36	42	66	38
18	Wasserburg	36	39	58	35
19	Schwabmünch	36	27	78	18

TEMPORADA 2019/2020

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pipinsried	23	81	20	63
2	Wasserburg	23	40	29	42
3	Deisenhofen	22	51	37	41
4	Ingolstadt	23	58	42	39
5	Schwabmünch	23	49	36	39
6	Kottern	22	39	31	38
7	1860	23	40	38	33
8	Kirchanschö	23	31	36	31
9	Ismaning	23	41	35	30
10	Dachau	23	30	45	27
11	Donaustauf	21	30	39	26
12	Türkspor	22	37	40	25
13	Landsberg	23	35	42	25
14	Hankofen-Hai	22	27	34	24
15	Jahn	23	42	55	24
16	Pullach	23	33	57	23
17	Schwaben	23	26	48	20
18	Nördlingen	23	25	51	14

TEMPORADA 2018/2019

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Türkgücü	32	59	30	68
2	Rain / Lech	32	60	42	58
3	Jahn	32	69	48	53
4	Pullach	32	52	48	53
5	Vilzing	32	47	36	51
6	Dachau	32	47	45	49
7	Kottern	32	46	47	46
8	1860	32	58	48	45
9	Schwabmünch	32	57	52	45
10	Nördlingen	32	53	55	45
11	Kirchanschö	32	51	47	44
12	Schwaben	32	41	44	43
13	Hankofen-Hai	32	47	50	39
14	Sonthofen	32	54	64	38
15	Ismaning	32	45	51	37
16	Unterföhrin	32	41	59	28
17	Holzkirchen	32	30	91	9

TEMPORADA 2017/2018

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Heimstetten	36	93	51	72
2	Pullach	36	75	48	65
3	Rain / Lech	36	70	44	62
4	Kottern	36	59	48	60
5	Schwaben	36	64	50	54
6	Schwabmünch	36	52	52	53
7	Vilzing	36	65	54	52
8	Neumarkt	36	51	48	50
9	Dachau	36	64	52	49
10	Sonthofen	36	59	50	49
11	Ismaning	36	70	70	47
12	Holzkirchen	36	57	69	47
13	Hankofen-Hai	36	53	66	46
14	1860	36	47	47	43
15	Chiemgau	36	49	63	41
16	Kirchanschö	36	44	51	40
17	Landsberg	36	52	72	39
18	Wolfratshaus	36	57	85	39
19	Kornburg	36	36	97	28

TEMPORADA 2016/2017

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Unterhaching	34	95	23	83
2	1860	34	45	35	63
3	Bayern	34	62	40	58
4	Augsburg	34	71	36	57
5	Memmingen	34	62	48	52
6	Illertissen	34	46	46	51
7	Nürnberg	34	72	67	49
8	Ingolstadt	34	59	51	48
9	Schweinfurt	34	57	61	48
10	Rosenheim	34	47	51	48
11	Wacker	34	46	54	47
12	Garching	34	56	64	46
13	Bayreuth	34	49	59	42
14	Buchbach	34	43	62	41
15	Schalding-He	34	57	64	40
16	Greuther	34	39	58	31
17	Seligenporte	34	41	76	29
18	Bayern Hof	34	35	87	12

TEMPORADA 2015/2016

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Jahn	34	61	36	64
2	Wacker	34	58	33	63
3	Nürnberg	34	57	37	63
4	Unterhaching	34	59	32	56
5	Illertissen	34	53	49	53
6	Bayern	34	54	38	52
7	Bayreuth	34	52	57	49
8	Buchbach	34	43	46	48
9	Greuther	34	53	56	47
10	1860	34	48	38	46
11	Ingolstadt	34	55	54	46
12	Memmingen	34	52	60	42
13	Schalding-He	34	40	62	40
14	Schweinfurt	34	44	52	38
15	Viktoria	34	49	63	35
16	Augsburg	34	52	63	33
17	Amberg	34	36	57	29
18	Rain / Lech	34	44	77	27

TEMPORADA 2014/2015

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Würzburger	34	67	15	80
2	Bayern	34	60	28	72
3	1860	34	60	34	63
4	Buchbach	34	45	41	52
5	Ingolstadt	34	47	39	50
6	Bayreuth	34	48	47	50
7	Memmingen	34	45	51	47
8	Nürnberg	34	39	39	46
9	Illertissen	34	56	55	45
10	Augsburg	34	41	47	45
11	Wacker	34	36	43	42
12	Schweinfurt	34	46	53	40
13	Schalding-He	34	43	52	40
14	Greuther	34	47	50	38
15	Heimstetten	34	40	58	34
16	Garching	34	42	64	33
17	Seligenporte	34	34	61	28
18	Eintracht	34	38	57	26

TEMPORADA 2013/2014

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Bayern	36	94	33	79
2	Illertissen	36	79	33	75
3	1860	36	68	41	72
4	Augsburg	36	63	34	69
5	Buchbach	36	63	55	61
6	Ingolstadt	36	65	50	57
7	Seligenporte	36	55	60	54
8	Nürnberg	36	57	46	53
9	Greuther	36	68	57	52
10	Eintracht	36	63	65	51
11	Würzburger	36	61	55	49
12	Schalding-He	36	52	71	42
13	Memmingen	36	51	56	41
14	Heimstetten	36	50	82	38
15	Rosenheim	36	45	59	37
16	Schweinfurt	36	46	71	36
17	Bayern Hof	36	42	68	36
18	Viktoria	36	45	86	23
19	Rain / Lech	36	45	90	20

TEMPORADA 2012/2013

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	1860	38	69	35	80
2	Bayern	38	71	31	73
3	Illertissen	38	74	44	72
4	Nürnberg	38	64	40	65
5	Heimstetten	38	61	53	61
6	Buchbach	38	73	57	60
7	Rosenheim	38	43	44	58
8	Ingolstadt	38	69	57	55
9	Memmingen	38	45	39	55
10	Würzburger	38	63	76	52
11	Rain / Lech	38	51	59	49
12	Greuther	38	49	56	48
13	Eintracht	38	48	64	47
14	Seligenporte	38	53	72	45
15	Viktoria	38	45	71	42
16	Augsburg	38	57	66	41
17	Bayern Hof	38	39	56	40
18	Eltersdorf	38	50	70	39
19	Ismaning	38	38	48	36
20	Frohnlach	38	40	64	35

TEMPORADA 2011/2012

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

TEMPORADA 2010/2011

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Darmstadt	30	50	26	62
2	Stuttgarter	30	54	28	58
3	Hessen	30	59	37	54
4	Hoffenheim	31	64	40	49
5	Greuther	30	51	42	48
6	Eintracht	30	56	48	46
7	Freiburg II	30	65	54	43
8	1860	30	39	54	41
9	Pfullendorf	30	40	43	40
10	Karlsruher	30	42	37	39
11	Nürnberg	30	45	46	38
12	Wormatia	30	40	45	36
13	Memmingen	30	33	50	36
14	Sonnenhof	30	29	44	33
15	Frankfurt	30	31	54	24
16	Wehen	30	25	71	20
17	Weiden	0	0	0	0
18	Ulm	1	0	4	0

TEMPORADA 2009/2010

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

TEMPORADA 2008/2009

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Heidenheim	34	61	37	72
2	Hessen	34	75	33	71
3	Eintracht	34	61	35	66
4	Waldhof	34	54	30	63
5	Nürnberg	34	65	37	61
6	1860	34	59	42	55
7	Ulm	34	55	35	53
8	Pfullendorf	34	50	48	50
9	Wehen	34	40	37	49
10	Eintracht	34	50	61	44
11	Greuther	34	37	39	41
12	Reutlingen	34	41	55	40
13	Viktoria	34	38	46	39
14	Freiburg II	34	46	63	38
15	Darmstadt	34	44	54	37
16	Karlsruher	34	37	66	34
17	Grossbardorf	34	32	84	18
18	Unterhaching	34	35	78	17

TEMPORADA 2007/2008

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Frankfurt	34	57	31	62
2	Ingolstadt	34	50	36	62
3	Stuttgart	34	52	30	59
4	VfR Aalen	34	64	45	57
5	Sandhausen	34	48	38	57
6	Unterhaching	34	55	44	54
7	Wacker	34	36	37	49
8	Bayern	34	53	42	47
9	Jahn	34	40	48	47
10	Stuttgarter	34	38	35	45
11	Siegen	34	35	37	45
12	Reutlingen	34	45	46	44
13	1860	34	40	44	42
14	Hessen	34	51	57	38
15	Elversberg	34	35	52	38
16	Karlsruher	34	33	45	37
17	Pfullendorf	34	33	41	34
18	Ludwigshafen	34	17	74	12

TEMPORADA 2006/2007

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Wehen	34	58	25	72
2	Hoffenheim	34	62	31	68
3	Stuttgart	34	47	42	53
4	Stuttgarter	34	51	41	51
5	Ingolstadt	34	45	39	51
6	VfR Aalen	34	51	46	49
7	Pfullendorf	34	45	46	47
8	Bayern	34	41	37	46
9	Elversberg	34	51	54	46
10	Hessen	34	45	56	46
11	Reutlingen	34	31	37	45
12	Siegen	34	53	49	44
13	1860	34	54	47	43
14	Karlsruher	34	44	44	43
15	Saarbrücken	34	52	50	42
16	Darmstadt	34	47	59	39
17	Pirmasens	34	31	61	31
18	Kaiserslaute	34	19	63	10

TEMPORADA 2005/2006

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FC Augsburg	34	73	26	76
2	TuS Koblenz	34	55	31	66
3	Wehen	34	63	46	57
4	Hoffenheim	34	47	34	56
5	Darmstadt	34	57	44	54
6	VfR Aalen	34	43	33	54
7	Stuttgart	34	50	43	53
8	Stuttgarter	34	46	39	48
9	Elversberg	34	40	37	48
10	Bayreuth	34	51	54	46
11	Karlsruher	34	41	51	42
12	Bayern	34	34	44	42
13	Kaiserslaute	34	39	44	41
14	Pfullendorf	34	30	34	40
15	1860	34	39	51	37
16	Eintracht	34	41	58	36
17	Jahn	34	37	48	32
18	Eschborn	34	15	84	10

TEMPORADA 2004/2005

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kickers	34	62	36	67
2	Wehen	34	56	37	64
3	Siegen	34	51	30	62
4	FC Augsburg	34	62	36	61
5	Darmstadt	34	50	33	54
6	Bayern	34	51	38	52
7	Hoffenheim	34	57	49	50
8	Jahn	34	47	46	48
9	Stuttgarter	34	48	43	47
10	Elversberg	34	45	55	44
11	TuS Koblenz	34	43	38	43
12	VfR Aalen	34	41	59	43
13	Stuttgart	34	55	57	42
14	Feucht SC	34	42	49	42
15	1860	34	39	44	40
16	Pfullendorf	34	36	64	36
17	Mainz 05 II	34	29	46	33
18	Nottingen	34	29	83	16

TEMPORADA 2003/2004

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	1860	34	71	40	68
2	Nürnberg	34	68	39	67
3	Ismaning	34	63	47	59
4	Greuther	34	69	46	55
5	Unterhaching	34	55	32	55
6	Fürstenfeld	34	49	47	54
7	Jahn	34	57	40	52
8	Bayreuth	34	56	41	52
9	Schwabach	34	48	43	47
10	Aindling	34	43	49	46
11	Memmingen	34	45	40	45
12	Grossbardorf	34	67	72	44
13	Weiden	34	41	46	42
14	SpVgg	34	42	45	40
15	Passau	34	38	68	32
16	Würzburger	34	37	69	28
17	Bayern Hof	34	36	71	28
18	Landshut	34	36	86	18

Competiciones que juega

Grupo 2

Oberliga Grupo 2

Pos	Equipos		Pts
1		TSV Schwaben Augsburg	61
2		Landsberg	60
3		SV Erlbach	60
4		Heimstetten	59
5		TSV Nördlingen	57
6		FC Deisenhofen	56
7		1860 München II	49
8		Kottern	46
9		Kirchanschöring	43
10		FC Pipinsried	40
11		Sonthofen	39
12		Rain / Lech	38
13		Dachau	37
14		Ismaning	36
15		FC Gundelfingen	32
16		Türkspor Augsburg	29
17		VfR Garching	18
18		Kirchheimer SC	13

	Ascenso : TSV Schwaben Augsburg
	Playoff Ascenso : Landsberg
	Playoff Descenso : Ismaning, FC Gundelfingen, Türkspor Augsburg, VfR Garching
	Descenso : Kirchheimer SC

RIVALES EN Oberliga

USO DE MEMORIA

7,911,344 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1477
Total Execution Time	0.1498

CADENA URL

/historico/1860-Munchen-Ii

GET DATOS

$_GET['/historico/1860-Munchen-Ii']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5690 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5690 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020	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 (4951) ORDER BY n.cover_points DESC, update_date DESC
0.0033	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 = '5690' ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '5690' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=5690 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (72394,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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72394 AND teamId = 5690
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5690
0.0022	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 = '5690' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5690' 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 = '5690' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040	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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 5690 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.0031	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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 5690 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 5690 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 5690 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 72394 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* `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 = 68055 AND t.round = 34 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* `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 = 63158 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 50138 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.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* `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 = 44076 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* `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 = 38870 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 33371 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* `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 = 3904 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* `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 = 2508 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 2008 AND t.round = 38 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* `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1332 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 16429 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* `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 16432 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 16435 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 = 16439 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* `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 = 16448 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* `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 = 16454 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 16453 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* `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 = 28289 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

1860 München II

1860 München II

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 2

RIVALES EN Oberliga