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

Tasmania Berlin

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Hertha	24	87	24	63
2	Lichtenberg	25	74	17	59
3	Sparta	25	66	39	47
4	Mahlsdorf	24	49	38	42
5	Tennis	24	42	38	37
6	TUS Makkabi	24	39	34	36
7	Tasmania	24	43	36	35
8	Anker Wismar	24	40	43	32
9	Neustrelitz	24	42	44	31
10	Staaken	24	41	63	31
11	Optik	24	40	47	29
12	Eintracht	25	40	60	27
13	Hertha	15	29	26	23
14	Dynamo	24	36	52	23
15	Rostocker	25	30	80	17
16	Union	25	21	78	8

TEMPORADA 2022/2023

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Hansa	34	94	28	81
2	Rostocker	34	77	38	69
3	TUS Makkabi	34	73	32	67
4	Hertha	34	71	40	62
5	Eintracht	34	56	53	57
6	Hertha	34	48	44	49
7	Blau-Weiß	34	59	60	48
8	Dynamo	34	48	54	48
9	Neustrelitz	34	55	54	47
10	Union	34	48	56	47
11	Mahlsdorf	34	48	52	46
12	Tasmania	36	46	69	39
13	Optik	34	42	60	34
14	Mecklenburg	36	55	90	34
15	Staaken	34	46	61	33
16	Neuruppin	34	43	57	32
17	Frankfurt	34	43	72	31
18	Pampow	34	51	83	30

TEMPORADA 2021/2022

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	BFC Dynamo	38	84	32	82
2	Carl Zeiss.	38	71	35	76
3	Energie	38	85	35	74
4	Altglienicke	38	80	47	72
5	Chemnitzer	38	67	37	72
6	Lokomotive	38	71	42	71
7	Berliner	38	65	48	69
8	Hertha	38	69	49	60
9	Chemie	38	47	48	56
10	Tennis	38	59	50	53
11	Babelsberg	38	46	42	53
12	Luckenwalde	38	58	50	50
13	Lichtenberg	38	49	64	44
14	Meuselwitz	38	42	54	41
15	Germania	38	48	68	41
16	Eilenburg	38	41	79	33
17	Union	38	49	89	33
18	Optik	38	48	81	30
19	Auerbach	38	45	95	23
20	Tasmania	38	28	107	17

TEMPORADA 2020/2021

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tasmania	9	21	7	21
2	Greifswalder	9	21	7	17
3	Staaken	8	17	6	16
4	Eintracht	9	18	16	16
5	Torgelower	8	17	8	15
6	Hertha	9	25	17	15
7	Neustrelitz	9	19	15	13
8	Blau-Weiß	9	11	7	13
9	Pampow	9	18	17	13
10	Hansa	8	14	13	13
11	Stern	8	14	13	13
12	Rostocker	10	16	26	12
13	Strausberg	9	15	18	10
14	Hertha	9	12	25	9
15	Victoria	9	8	24	6
16	Lok Stendal	9	9	18	5
17	BSC Süd 05	9	7	25	5

TEMPORADA 2019/2020

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Tennis	19	61	17	47
2	Greifswalder	18	37	15	42
3	Hansa	19	56	22	39
4	Hertha	19	40	20	39
5	Neustrelitz	19	29	27	32
6	Pampow	19	41	28	30
7	Staaken	19	42	36	25
8	Blau-Weiß	18	25	25	24
9	Torgelower	19	26	30	24
10	Tasmania	19	30	37	21
11	Ludwigsfelde	19	26	39	18
12	Lok Stendal	18	20	33	18
13	Victoria	18	25	44	18
14	Hertha	19	18	43	16
15	BSC Süd 05	18	12	35	11
16	Strausberg	18	17	54	11

TEMPORADA 1998/1999

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hertha	30	89	32	66
2	Tennis	30	65	33	60
3	Hansa	30	52	32	57
4	Eintracht	30	59	39	56
5	Frankfurter	30	45	32	50
6	Greifswalder	30	53	46	45
7	Reinickendor	30	43	40	41
8	Schönberg	30	42	42	40
9	Hertha	30	45	52	40
10	Köpenicker	30	59	52	38
11	Lichterfelde	30	40	49	38
12	Preussen	30	33	43	38
13	Optik	30	35	51	36
14	Neustrelitz	30	37	62	31
15	Charlottenbu	30	29	61	20
16	Tasmania	30	19	79	11

TEMPORADA 1997/1998

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Croatia	28	50	16	62
2	Hertha	28	62	31	50
3	Greifswalder	28	58	38	49
4	Eintracht	28	57	39	46
5	Frankfurt	28	40	33	46
6	Tasmania	28	48	44	42
7	Preussen	28	34	39	40
8	Lichterfelde	28	43	43	38
9	Köpenicker	28	36	37	38
10	Charlottenbu	28	39	47	38
11	Neustrelitz	28	44	62	34
12	Optik	28	37	49	31
13	Türkiyemspo	28	28	32	30
14	SG Bornim	28	23	55	23
15	Parchimer	28	20	54	17

TEMPORADA 1972/1973

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Blau-Weiß	10	29	15	19
2	Wacker	10	20	14	19
3	Tennis	10	19	9	18
4	Tasmania	10	12	13	16
5	Berliner	10	12	25	7
6	Hertha	10	13	29	7

TEMPORADA 1971/1972

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Wacker	33	85	28	77
2	Tasmania	33	83	23	76
3	Blau Weiss.	33	102	37	73
4	Tennis	33	82	26	72
5	Spandauer	33	51	60	48
6	Hertha	33	56	66	38
7	Neukölln	33	45	66	38
8	Alemannia	33	37	55	34
9	Rapide	33	42	83	31
10	Berliner	33	27	63	29
11	Wannsee	33	27	79	25
12	Meteor	33	40	91	18

TEMPORADA 1970/1971

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Tasmania	33	110	20	90
2	Wacker	33	75	34	75
3	Blau-Weiß	33	95	38	74
4	Tennis	33	68	39	64
5	Hertha	33	75	63	48
6	Spandauer	33	59	70	46
7	Wannsee	33	48	84	36
8	Alemannia	33	41	61	32
9	Rapide	33	46	66	29
10	Neukölln	33	53	78	28
11	Staaken	33	35	76	28
12	Nord Berlin	33	31	107	10

TEMPORADA 1969/1970

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Hertha	26	101	23	69
2	Tennis	26	70	23	57
3	Tasmania	26	64	23	55
4	Blau-Weiß	26	63	33	47
5	Wacker	26	58	36	47
6	Spandauer	26	47	44	39
7	Rapide	26	46	51	35
8	Neukölln	26	31	47	30
9	Wannsee	26	32	36	28
10	Staaken	26	32	51	27
11	Berliner	26	34	50	23
12	Kickers 1900	26	31	65	18
13	Meteor	26	29	66	15
14	Neuköllner	26	15	105	10

TEMPORADA 1968/1969

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hertha	30	84	32	74
2	Tasmania	30	75	26	71
3	Tennis	30	96	38	65
4	Wacker	30	93	31	62
5	Spandauer	30	73	42	61
6	Neukölln	30	72	60	49
7	Kickers 1900	30	57	54	39
8	Rapide	30	52	49	38
9	Berliner	30	58	63	36
10	Staaken	30	44	61	33
11	Blau Weiss.	30	41	55	30
12	Meteor	30	53	88	29
13	BFC Sudring	30	38	62	28
14	Alemannia	30	33	75	21
15	Nord Berlin	30	50	107	20
16	Reinickendor	30	26	102	13

TEMPORADA 1967/1968

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hertha BSC	30	104	11	81
2	Tennis	30	108	29	73
3	Hertha	30	69	45	59
4	Wacker	30	90	58	57
5	Tasmania	30	57	32	47
6	BFC Sudring	30	51	42	43
7	Spandauer	30	62	53	42
8	Blau-Weiß	30	43	47	42
9	Berliner	30	46	59	34
10	Alemannia	30	44	58	33
11	Reinickendor	30	51	68	33
12	Neukölln	30	41	66	32
13	Rapide	30	51	72	28
14	Kickers 1900	30	29	69	27
15	Neuköllner	30	32	111	21
16	Hermsdorf	30	39	97	17

TEMPORADA 1966/1967

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hertha BSC	30	114	25	85
2	Tennis	30	101	30	72
3	Spandauer	30	61	42	59
4	Tasmania	30	53	31	55
5	Hertha	30	56	41	55
6	Wacker	30	63	46	50
7	Rapide	30	42	58	36
8	Hermsdorf	30	52	81	35
9	Berliner	30	37	49	33
10	Neukölln	30	42	65	32
11	Reinickendor	30	39	57	29
12	Blau-Weiß	30	32	55	29
13	BFC Sudring	30	44	59	28
14	Kickers 1900	30	49	79	28
15	Staaken	30	36	53	26
16	Lichterfelde	30	42	92	16

TEMPORADA 1965/1966

BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	1860	34	80	40	50
2	B. Dortmund	34	70	36	47
3	Bayern	34	71	38	47
4	Werder	34	76	40	45
5	Köln	34	74	41	44
6	Nürnberg	34	54	43	39
7	Eintracht	34	64	46	38
8	Duisburg	34	70	48	36
9	Hamburger	34	64	52	34
10	Eintracht	34	49	49	34
11	Stuttgart	34	42	48	32
12	Hannover 96	34	59	57	30
13	Mönchenglad	34	57	68	29
14	Schalke 04	34	33	55	27
15	Kaiserslaute	34	42	65	26
16	Karlsruher	34	35	71	24
17	Neunkirchen	34	32	82	22
18	Tasmania	34	15	108	8

TEMPORADA 1964/1965

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Tennis	26	67	23	59
2	Spandauer	26	57	26	59
3	Tasmania	26	82	29	57
4	Wacker	26	47	60	31
5	BFC Sudring	26	54	61	29
6	Blau-Weiß	26	27	38	28
7	Berliner	26	28	61	28
8	Hertha	26	33	50	24
9	Viktoria	26	48	67	24
10	Reinickendor	26	28	56	23

TEMPORADA 1963/1964

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tasmania	27	73	22	67
2	Tennis	27	73	22	61
3	Wacker	27	52	45	49
4	Spandauer	27	63	41	46
5	Hertha	27	46	47	35
6	Blau-Weiß	27	37	55	32
7	Reinickendor	27	31	46	29
8	Berliner	27	28	49	25
9	BFC Sudring	27	36	64	24
10	Union Berlin	27	23	71	15

Competiciones que juega

Grupo 4

Oberliga Grupo 4

Pos	Equipos		Pts
1		FC Hertha 03 Zehlendorf	63
2		Lichtenberg	59
3		Sparta Lichtenberg	47
4		Mahlsdorf	42
5		Tennis Borussia	37
6		TUS Makkabi	36
7		Tasmania Berlin	35
8		Anker Wismar	32
9		Neustrelitz	31
10		Staaken	31
11		Optik Rathenow	29
12		RSV Eintracht	27
13		CFC Hertha 06	23
14		Dynamo Schwerin	23
15		Rostocker FC	17
16		Union Fürstenwalde	8

	Ascenso : FC Hertha 03 Zehlendorf

RIVALES EN Oberliga

USO DE MEMORIA

6,871,920 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.6394
Total Execution Time	0.6408

CADENA URL

/historico/Tasmania-Berlin

GET DATOS

$_GET['/historico/Tasmania-Berlin']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0137	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 = 'Tasmania-Berlin' 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=30921 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=30921 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=30921 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30921 AND type_rel = 2
0.0151	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 = '30921' ORDER BY l.year DESC,cat.coefficient DESC
0.0142	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 = '30921' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '30921' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 72541 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	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=30921 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (72541,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.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 72541 AND teamId = 30921
0.0140	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 30921
0.0143	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 = 72541 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133	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 = '30921' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30921' and rp.type = 4
0.0135	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 = '30921' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0179	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 = 72541 WHERE rp.league_id = 72541 AND rp.teamId = 30921 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.0177	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 = 72541 WHERE rp.league_id = 72541 AND rp.teamId = 30921 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169	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 = 72541 WHERE rp.league_id = 72541 AND rp.teamId = 30921 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 = 30921 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0147	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 = 68171 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.0147	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 = 63253 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.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* `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 = 57316 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 50468 AND t.round = 19 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* `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 = 28336 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 28344 AND t.round = 30 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* `tables1973` 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 = 22738 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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* `tables1972` 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 = 22735 AND t.round = 33 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* `tables1971` 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 = 22763 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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* `tables1970` 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 = 22835 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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* `tables1969` 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 = 22839 AND t.round = 30 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* `tables1968` 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 = 22881 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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* `tables1967` 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 = 22855 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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* `tables1966` 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 = 5428 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* `tables1965` 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 = 22906 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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* `tables1964` 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 = 22886 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 72541 ORDER BY nameShow LIMIT 100

Tasmania Berlin

Tasmania Berlin

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 4

RIVALES EN Oberliga