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

Berliner AK 07

Entrenador: Volkan Uluç

Temporada 2023/2024

TEMPORADA 2023/2024

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Energie	31	61	34	64
2	Greifswalder	31	57	24	62
3	BFC Dynamo	31	55	34	57
4	Viktoria	31	44	36	53
5	Babelsberg	31	38	34	49
6	Altglienicke	31	61	45	48
7	Carl Zeiss.	31	51	40	44
8	Chemnitzer	31	40	44	44
9	Chemie	31	34	38	43
10	Zwickau	31	48	51	42
11	Rot-Weiss	31	50	49	38
12	Meuselwitz	31	42	44	38
13	Lokomotive	31	41	54	37
14	Luckenwalde	31	44	53	35
15	Hertha	31	44	60	35
16	Eilenburg	31	39	54	33
17	Hansa	31	41	58	26
18	Berliner	31	23	61	19

TEMPORADA 2022/2023

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Energie	34	65	28	70
2	Carl Zeiss.	34	59	22	63
3	Rot-Weiss	34	63	32	63
4	Lokomotive	34	60	42	60
5	Altglienicke	34	66	37	59
6	BFC Dynamo	34	58	45	56
7	Chemie	34	50	45	53
8	Chemnitzer	34	47	33	52
9	Hertha	34	59	52	52
10	Babelsberg	34	46	41	49
11	Berliner	34	48	54	49
12	Viktoria	34	46	47	45
13	Luckenwalde	34	45	51	44
14	Greifswalder	34	47	61	37
15	Meuselwitz	34	51	67	35
16	Lichtenberg	34	37	69	27
17	Germania	34	29	75	16
18	Tennis	34	27	102	13

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

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Viktoria	11	26	9	33
2	Altglienicke	11	29	14	25
3	Chemie	13	25	12	24
4	Carl Zeiss.	12	24	16	21
5	Berliner	12	25	21	20
6	Lokomotive	12	20	17	19
7	BFC Dynamo	11	26	17	18
8	Energie	13	18	19	18
9	Chemnitzer	13	20	17	17
10	Babelsberg	13	18	20	17
11	Union	11	22	20	16
12	Lichtenberg	13	15	20	16
13	Luckenwalde	13	14	22	15
14	Hertha	11	12	15	14
15	Germania	13	12	18	11
16	Auerbach	12	18	26	11
17	Meuselwitz	13	14	22	11
18	Optik	13	15	25	11
19	Tennis	10	15	20	9
20	Bischofswerd	12	12	30	7

TEMPORADA 2019/2020

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Lokomotive	25	49	27	54
2	Altglienicke	24	60	32	48
3	Energie	24	58	35	48
4	Union	25	48	32	43
5	Hertha	24	59	42	39
6	BFC Dynamo	24	36	31	37
7	Berliner	23	48	36	34
8	Viktoria	24	22	20	32
9	Wacker	21	45	36	31
10	Auerbach	23	38	48	29
11	Meuselwitz	23	35	40	28
12	Lichtenberg	23	31	36	28
13	Chemie	24	20	26	24
14	Germania	24	25	40	22
15	Optik	24	20	48	21
16	Rot-Weiss	19	18	27	19
17	Babelsberg	23	23	39	18
18	Bischofswerd	21	16	56	11

TEMPORADA 2018/2019

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Chemnitzer	34	82	36	77
2	Berliner	34	64	36	70
3	Wacker	34	59	38	64
4	Hertha	34	60	43	57
5	Rot-Weiss	34	57	42	54
6	Viktoria	34	50	38	52
7	Lokomotive	34	51	41	50
8	Babelsberg	34	53	44	46
9	Germania	34	46	38	46
10	Auerbach	34	47	53	46
11	Meuselwitz	34	52	55	44
12	BFC Dynamo	34	38	61	42
13	Union	34	43	60	40
14	Altglienicke	34	54	59	39
15	Oberlausitz	34	40	64	37
16	Bischofswerd	34	29	58	34
17	Optik	34	36	65	28
18	Budissa	34	21	51	26

TEMPORADA 2017/2018

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Energie	34	79	14	89
2	Wacker	34	48	29	58
3	Berliner	34	63	47	56
4	BFC Dynamo	34	70	50	54
5	Babelsberg	34	52	38	53
6	Lokomotive	34	48	36	53
7	Germania	34	68	52	52
8	Hertha	34	54	45	48
9	Union	34	59	52	47
10	Meuselwitz	34	44	44	43
11	Auerbach	34	48	51	43
12	Oberlausitz	34	47	53	43
13	Viktoria	34	49	54	42
14	Budissa	34	31	47	41
15	Altglienicke	34	30	41	38
16	Chemie	34	21	51	35
17	Neustrelitz	34	36	75	27
18	Luckenwalde	34	25	93	9

TEMPORADA 2016/2017

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Carl Zeiss.	34	68	25	75
2	Energie	34	58	26	66
3	Leipzig	34	67	42	60
4	Viktoria	34	63	47	56
5	Babelsberg	34	55	42	55
6	Berliner	34	54	42	55
7	Wacker	34	47	47	51
8	Oberlausitz	34	41	33	48
9	Hertha	34	46	48	48
10	Lokomotive	34	53	49	47
11	Schönberg	34	53	60	47
12	Auerbach	34	47	50	45
13	Union	34	49	59	45
14	Meuselwitz	34	37	36	44
15	BFC Dynamo	34	51	54	44
16	Luckenwalde	34	35	75	24
17	Budissa	34	29	68	18
18	Neustrelitz	34	30	80	11

TEMPORADA 2015/2016

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Zwickau	34	77	30	77
2	Berliner	34	68	22	77
3	Wacker	34	59	39	61
4	BFC Dynamo	34	66	48	56
5	Oberlausitz	34	52	48	54
6	Babelsberg	34	49	29	53
7	Carl Zeiss.	34	43	33	53
8	Neustrelitz	34	53	42	51
9	Auerbach	34	52	44	50
10	Hertha	34	52	59	48
11	Leipzig	34	49	48	44
12	Viktoria	34	46	62	38
13	Budissa	34	46	47	37
14	Meuselwitz	34	34	59	37
15	Schönberg	34	37	52	36
16	Luckenwalde	34	33	80	29
17	Germania	34	39	80	23
18	Optik	34	33	66	22

TEMPORADA 2014/2015

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Magdeburg	28	61	22	60
2	Zwickau	28	45	21	57
3	Wacker	28	43	38	48
4	Carl Zeiss.	28	46	38	45
5	BFC Dynamo	28	34	26	45
6	Hertha	28	50	41	42
7	Berliner	28	36	35	42
8	Neustrelitz	28	46	41	38
9	Germania	28	43	44	37
10	Union Berlin	28	49	49	36
11	Babelsberg	28	32	34	31
12	Auerbach	28	28	56	31
13	Budissa	28	23	40	27
14	Meuselwitz	28	27	52	22
15	Viktoria	28	25	51	20
16	VFC Plauen	0	0	0	0

TEMPORADA 2013/2014

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Neustrelitz	30	65	30	70
2	Magdeburg	30	71	39	58
3	Carl Zeiss.	30	54	39	52
4	Union Berlin	30	67	51	50
5	Wacker	30	43	46	44
6	Zwickau	30	38	38	43
7	Auerbach	30	41	45	41
8	Viktoria	30	41	40	39
9	VFC Plauen	30	48	49	39
10	Meuselwitz	30	31	49	36
11	Berliner	30	41	46	35
12	Hertha	30	38	46	34
13	Germania	30	45	61	34
14	Babelsberg	30	37	50	33
15	Lokomotive	30	29	41	32
16	Optik	30	34	53	29

TEMPORADA 2012/2013

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	RB Leipzig	32	67	23	76
2	Carl Zeiss.	30	54	28	58
3	Berliner	32	38	20	54
4	Zwickau	30	44	14	53
5	Hertha	30	46	39	46
6	Magdeburg	30	42	41	45
7	Meuselwitz	30	37	40	45
8	Neustrelitz	30	41	39	40
9	Germania	30	31	34	38
10	Lokomotive	30	35	39	36
11	Optik	30	35	46	35
12	Union Berlin	30	36	43	31
13	VFC Plauen	30	42	52	29
14	Auerbach	30	35	48	28
15	Energie	30	26	53	20
16	Torgelower	30	19	69	13

TEMPORADA 2011/2012

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hallescher	34	53	15	77
2	Holstein	34	73	31	75
3	RB Leipzig	34	71	30	73
4	Wolfsburg	34	52	41	51
5	Havelse	34	54	46	51
6	Hannover	34	47	48	50
7	Berliner	34	48	47	47
8	Hamburger	34	56	47	45
9	Meuselwitz	34	41	52	45
10	VFC Plauen	34	46	50	43
11	Wilhelmshave	34	57	64	43
12	VfB Lübeck	34	41	47	38
13	SV Meppen	34	38	56	38
14	Hertha	34	38	58	37
15	Energie	34	39	65	36
16	Germania	34	45	53	34
17	Pauli	34	43	72	32
18	Magdeburg	34	23	43	29

TEMPORADA 2010/2011

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Torgelower	30	66	22	69
2	Hansa	30	56	30	69
3	Berliner	30	55	17	66
4	Neustrelitz	30	56	28	58
5	Union Berlin	30	58	42	51
6	Optik	30	35	41	46
7	BFC Dynamo	30	48	35	45
8	BSC Süd 05	30	45	51	41
9	Anker Wismar	30	38	36	39
10	Malchower	30	45	48	37
11	Germania	30	38	43	34
12	Lichterfelde	30	37	52	30
13	Altlüdersdo	30	40	50	28
14	Tennis	30	26	66	22
15	Reinickendor	30	25	63	21
16	Ludwigsfelde	30	31	75	20

TEMPORADA 2009/2010

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Energie	30	67	26	66
2	BFC Dynamo	30	70	40	58
3	BSC Süd 05	30	57	40	53
4	Luckenwalde	30	56	43	53
5	Malchower	30	47	35	53
6	Neustrelitz	30	70	38	52
7	Optik	30	43	46	45
8	Torgelower	30	46	35	44
9	Germania	30	45	39	42
10	Berliner	30	53	51	42
11	Ludwigsfelde	30	42	52	36
12	Lichterfelde	30	40	51	32
13	Reinickendor	30	26	46	32
14	Lichtenrader	30	31	79	24
15	Greifswalder	30	38	66	23
16	Falkensee-Fi	30	25	69	17

TEMPORADA 2008/2009

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Tennis	30	65	21	74
2	BFC Dynamo	30	53	36	56
3	Optik	30	41	41	47
4	Neustrelitz	30	51	43	46
5	Ludwigsfelde	30	49	35	45
6	Reinickendor	30	44	40	44
7	Falkensee-Fi	30	47	47	44
8	BSC Süd 05	30	60	52	43
9	Lichterfelde	30	45	41	40
10	Berliner	30	35	33	40
11	Greifswalder	30	56	57	40
12	Bentwisch	30	53	57	37
13	Germania	30	39	44	37
14	Torgelower	30	42	59	34
15	Preussen	30	39	58	28
16	Spandauer	30	21	76	13

TEMPORADA 2007/2008

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Hertha	26	68	15	64
2	Hansa	25	71	21	56
3	Türkiyemspo	26	51	23	56
4	Greifswalder	26	54	31	52
5	Tennis	26	58	34	46
6	Optik	26	32	24	45
7	BFC Dynamo	26	42	25	44
8	Lichterfelde	26	40	49	38
9	Torgelower	26	41	44	34
10	Germania	26	26	47	29
11	Neustrelitz	26	35	43	27
12	Spandauer	26	24	57	16
13	Ludwigsfelde	27	21	58	15
14	Preussen	26	16	60	14
15	Berliner	26	14	62	5

TEMPORADA 2006/2007

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Babelsberg	30	46	15	68
2	Hansa	30	65	28	62
3	Tennis	29	51	30	58
4	Berliner	30	51	35	48
5	Türkiyemspo	30	41	38	46
6	Lichterfelde	30	49	39	43
7	Schönberg	30	41	44	41
8	Preussen	30	43	49	39
9	Ludwigsfelde	30	33	37	38
10	BFC Dynamo	30	42	42	36
11	Germania	30	17	27	35
12	Torgelower	30	33	34	34
13	Neustrelitz	30	25	30	33
14	Yesilyurt	29	41	55	29
15	Neuruppin	30	20	47	20
16	Preussen	30	24	72	19

TEMPORADA 2005/2006

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Union Berlin	30	73	22	69
2	Neuruppin	30	61	21	64
3	Babelsberg	30	56	42	51
4	Hansa	30	49	42	51
5	Tennis	30	56	40	49
6	BFC Dynamo	30	43	41	44
7	Türkiyemspo	30	34	32	44
8	Yesilyurt	30	49	45	42
9	Torgelower	30	45	54	42
10	Berliner	30	40	35	39
11	Preussen	30	44	43	38
12	Ludwigsfelde	30	36	48	35
13	Preussen	30	25	58	31
14	Neustrelitz	30	34	52	30
15	Falkensee-Fi	30	31	51	29
16	Anker Wismar	30	31	81	21

TEMPORADA 2004/2005

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Hansa	32	93	20	73
2	Neuruppin	32	68	23	69
3	Babelsberg	32	59	25	65
4	Tennis	32	67	32	63
5	Yesilyurt	32	55	38	58
6	BFC Dynamo	32	46	28	56
7	Energie	32	60	45	53
8	Berliner	32	49	44	51
9	Preussen	32	43	50	41
10	Ludwigsfelde	32	53	58	39
11	Türkiyemspo	32	33	55	37
12	Anker Wismar	32	35	63	36
13	Neustrelitz	32	30	51	32
14	Optik	32	25	52	27
15	Reinickendor	32	19	59	24
16	Schönberg	32	25	62	21
17	Lichtenberg	32	23	78	16

Competiciones que juega

Grupo 3

Regionalliga Grupo 3

Pos	Equipos		Pts
1		Energie Cottbus	64
2		Greifswalder	62
3		BFC Dynamo	57
4		Viktoria Berlin	53
5		SV Babelsberg 03	49
6		Altglienicke	48
7		FC Carl Zeiss Jena	44
8		Chemnitzer	44
9		Chemie Leipzig	43
10		Zwickau	42
11		Rot-Weiss Erfurt	38
12		Meuselwitz	38
13		Lokomotive Leipzig	37
14		Luckenwalde	35
15		Hertha BSC II	35
16		Eilenburg	33
17		Hansa Rostock II	26
18		Berliner AK 07	19

	Ascenso : Energie Cottbus
	Descenso : Berliner AK 07

RIVALES EN Regionalliga

USO DE MEMORIA

7,716,944 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.5671
Total Execution Time	0.5691

CADENA URL

/historico/Bak-07

GET DATOS

$_GET['/historico/Bak-07']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0158	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 = 'Bak-07' 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.0106	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=9749 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=9749 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=9749 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9749 AND type_rel = 2
0.0113	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 = '9749' ORDER BY l.year DESC,cat.coefficient DESC
0.0110	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 = '9749' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0109	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 = '9749' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107	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 = 72583 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109	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=9749 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107	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 (72583,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.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 72583 AND teamId = 9749
0.0111	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9749
0.0106	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 = '9749' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107	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 = '9749' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129	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 = 72583 WHERE rp.league_id = 72583 AND rp.teamId = 9749 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.0120	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 = 72583 WHERE rp.league_id = 72583 AND rp.teamId = 9749 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117	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 = 72583 WHERE rp.league_id = 72583 AND rp.teamId = 9749 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111	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 = 9749 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0213	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 = 72583 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.0111	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 = 68046 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.0112	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.0111	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 = 57335 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.0111	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 = 50104 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 43945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 38890 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 33792 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 15530 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 3907 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 2509 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 2009 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 1333 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 19838 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 19850 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 19862 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 19873 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 19878 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 19888 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120	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 = 28296 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Berliner AK 07

Berliner AK 07

Selecciona un equipo

Competiciones que juega

Regionalliga Grupo 3

RIVALES EN Regionalliga