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.

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

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

TEMPORADA 2002/2003

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Feucht SC	34	107	37	84
2	1860	34	83	35	71
3	Ismaning	34	77	42	66
4	Bayreuth	34	55	46	62
5	Fürstenfeld	34	62	43	60
6	Nürnberg	34	70	51	59
7	Aindling	34	58	59	53
8	Unterhaching	34	56	56	50
9	Greuther	34	66	69	48
10	Weiden	34	43	52	42
11	Jahn	34	58	63	41
12	Bayern Hof	34	52	69	41
13	SpVgg	34	54	57	40
14	Schwabach	34	43	58	36
15	Quelle Furth	34	49	67	35
16	Schwaben	34	36	67	35
17	FC Falke	34	37	81	24
18	Gerbrunn	34	32	86	18

TEMPORADA 2001/2002

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FC Augsburg	36	93	34	89
2	1860	36	79	34	77
3	Nürnberg	36	84	44	69
4	Bayern Hof	36	59	47	63
5	Greuther	36	77	49	60
6	Unterhaching	36	48	49	51
7	Bayreuth	36	48	52	49
8	Quelle Furth	36	54	47	48
9	Ismaning	36	54	57	48
10	Aindling	36	57	55	47
11	Schwabach	36	60	73	47
12	Weiden	36	56	63	46
13	FC Falke	36	40	52	46
14	Feucht SC	36	57	53	45
15	Würzburger	36	47	68	42
16	1. FC Sand	36	47	74	37
17	Ingolstadt	36	29	62	33
18	Memmingen	36	42	79	28
19	Neumarkt	36	30	69	24

TEMPORADA 2000/2001

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Karlsruher	34	48	25	61
2	Stuttgart	34	57	38	58
3	Schweinfurt	34	57	43	57
4	Eintracht	34	48	34	57
5	Darmstadt	34	46	39	53
6	Siegen	34	45	45	50
7	VfR Aalen	34	45	37	49
8	Mannheim	34	50	45	45
9	Bayern	34	52	55	44
10	Kickers	34	39	43	44
11	Wehen	34	41	49	44
12	Jahn	34	57	62	43
13	Wacker	34	46	52	43
14	Elversberg	34	40	58	43
15	Rot-Weiss	34	40	47	39
16	1860	34	49	63	37
17	Pfullendorf	34	42	49	36
18	Carl Zeiss.	34	39	57	29

TEMPORADA 1999/2000

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Reutlingen	34	102	25	87
2	Pfullendorf	34	57	36	61
3	Mannheim	34	61	55	57
4	Wacker	34	57	42	55
5	Bayern	34	64	58	51
6	Stuttgart	34	51	34	50
7	1860	34	48	38	48
8	FC Augsburg	34	43	43	46
9	Darmstadt	34	49	51	46
10	VfR Aalen	34	51	54	46
11	Schweinfurt	34	47	54	45
12	Karlsruher	34	56	51	44
13	Wehen	34	46	52	43
14	Frankfurt	34	48	57	41
15	Ditzingen	34	46	55	36
16	Quelle Furth	34	40	70	35
17	Borussia	34	40	57	31
18	SV Lohhof	34	29	103	10

TEMPORADA 1998/1999

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Waldhof	34	57	25	71
2	Kickers	34	71	38	68
3	Reutlingen	34	54	30	56
4	Stuttgart	34	54	48	53
5	Schweinfurt	34	52	44	51
6	Wehen	34	48	57	51
7	Wacker	34	50	42	50
8	Bayern	34	53	41	49
9	1860	34	49	51	45
10	Mannheim	34	33	45	40
11	Karlsruher	34	51	52	39
12	Ditzingen	34	43	57	39
13	Borussia	34	45	69	39
14	FC Augsburg	34	42	57	38
15	Frankfurt	34	45	62	38
16	Pfullendorf	34	38	37	37
17	SC Weismain	34	42	53	36
18	Neukirchen	34	43	62	35

TEMPORADA 1997/1998

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kickers	33	59	38	62
2	Ulm	33	63	36	61
3	Borussia	33	55	48	60
4	Wacker	33	57	34	57
5	Reutlingen	33	51	31	56
6	Karlsruher	34	44	54	51
7	Waldhof	33	48	40	50
8	Bayern	33	45	46	48
9	1860	34	56	44	47
10	FC Augsburg	33	51	48	42
11	SC Weismain	33	42	48	41
12	Wehen	34	53	58	39
13	Ditzingen	33	37	48	39
14	Mannheim	33	40	48	38
15	Neukirchen	33	48	56	36
16	Darmstadt	33	39	58	34
17	Kirchheim/Te	33	33	72	18
18	Hessen	20	17	31	17

TEMPORADA 1996/1997

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	1860	34	71	29	70
2	Memmingen	34	70	48	61
3	Starnberg	34	67	46	60
4	Frohnlach	34	52	38	57
5	Schweinfurt	34	71	40	54
6	Post	34	64	37	54
7	Jahn	34	58	47	52
8	SpVgg	34	79	65	49
9	Weiden	34	52	46	49
10	Landshut	34	55	53	49
11	Bayern Hof	34	52	44	47
12	Passau	34	33	47	44
13	Aindling	34	48	69	41
14	SV Lohhof	34	49	57	40
15	Bayreuth	34	61	86	37
16	Gundelfingen	34	43	77	30
17	Alemannia	34	45	73	29
18	Helmbrechts	34	26	94	17

Competiciones que juega

Grupo 2

Regionalliga Grupo 2

Pos	Equipos		Pts
1		Darmstadt 98	62
2		Stuttgarter Kickers	58
3		Hessen Kassel	54
4		Hoffenheim II	49
5		Greuther Fürth II	48
6		Eintracht Frankfurt II	46
7		Freiburg II	43
8		1860 München II	41
9		Pfullendorf	40
10		Karlsruher SC II	39
11		Nürnberg II	38
12		Wormatia Worms	36
13		Memmingen	36
14		SG Sonnenhof Großaspach	33
15		FSV Frankfurt II	24
16		Wehen Wiesbaden II	20
17		Weiden	0
18		Ulm	0

RIVALES EN Regionalliga

USO DE MEMORIA

6,966,680 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.6204
Total Execution Time	0.6226

CADENA URL

/historico/1860-Munchen-Ii/2011

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0135	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 = '1860-Munchen-Ii' AND l.year = 2011 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.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=5690 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=5690 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254	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 = 16429
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5690 AND type_rel = 2
0.0126	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.0125	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.0129	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' AND l.year = 2011 ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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.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 = 16429 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	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 (2010,2011,2012) ORDER BY l.id DESC, l.year DESC ;
0.0125	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 (16432) 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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 16432 AND teamId = 5690
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '5690' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5690' and rp.type = 4
0.0127	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.0139	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 events2011 e ON e.player_id = p.id AND e.league_id = 16429 WHERE rp.league_id = 16429 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.0140	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 events2011 e ON e.player_id = p.id AND e.league_id = 16429 WHERE rp.league_id = 16429 AND rp.teamId = 5690 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142	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 events2011 e ON e.player_id = p.id AND e.league_id = 16429 WHERE rp.league_id = 16429 AND rp.teamId = 5690 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 <= 2011 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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.0129	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.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* `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.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* `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.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* `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.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* `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.0146	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.0140	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
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* `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 = 28301 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* `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 = 28311 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 16449 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* `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 = 22658 AND t.round = 34 ORDER BY team.conference 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* `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 = 22678 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* `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 = 22684 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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 = 28364 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 16429 ORDER BY nameShow LIMIT 100

1860 München II

1860 München II

Selecciona un equipo

Competiciones que juega

Regionalliga Grupo 2

RIVALES EN Regionalliga