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

Altona 93

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Altona 93	32	87	28	76
2	Dassendorf	32	90	34	71
3	ETSV Hamburg	32	67	39	60
4	Niendorfer	32	75	49	58
5	HEBC Hamburg	32	71	48	57
6	TSV Sasel	32	72	51	52
7	Paloma	32	56	52	49
8	Süderelbe	32	82	59	45
9	Victoria	32	72	63	45
10	TuRa	32	57	57	45
11	Buchholz	32	59	59	43
12	Halstenbek-R	32	68	64	42
13	Wandsbeker	32	68	86	38
14	Alsterbruder	32	67	86	34
15	Rugenbergen	32	42	80	28
16	Türkiye	32	47	81	26
17	Union	32	39	96	21
18	Düneberger	32	38	125	17

TEMPORADA 2022/2023

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	TSV Sasel	36	108	40	82
2	Dassendorf	36	104	37	77
3	Eimsbüttele	36	87	37	73
4	Altona 93	36	78	45	71
5	Niendorfer	36	83	50	70
6	Paloma	36	71	54	65
7	Süderelbe	36	86	61	57
8	Wandsbeker	36	72	63	54
9	HEBC Hamburg	36	58	52	50
10	Victoria	36	80	80	47
11	TuRa	36	45	67	43
12	Türkiye	36	65	76	41
13	Union	36	53	89	40
14	Buchholz	36	45	79	39
15	Rugenbergen	36	47	75	35
16	Hamm United	36	45	80	33
17	Hamburger	36	55	91	31
18	Tus Osdorf	36	45	93	26
19	Curslack-Neu	36	59	117	23

TEMPORADA 2021/2022

REGIONALLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Phönix	10	26	5	45
2	Eintracht	10	20	4	39
3	Jeddeloh	12	17	10	38
4	Drochtersen	10	20	9	34
5	BSV Rehden	12	24	16	29
6	Pauli	10	15	16	26
7	LSK Hansa	12	8	18	22
8	Hannoversche	12	17	27	19
9	Altona 93	10	10	16	17
10	Oberneuland	12	14	33	16
11	Heider SV	10	13	30	12

TEMPORADA 2020/2021

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Weiche	9	18	6	24
2	Teutonia	10	17	13	16
3	Eintracht	9	14	11	16
4	Pauli	10	15	15	16
5	Hamburger	10	19	12	15
6	Drochtersen	9	14	8	15
7	Phönix	9	11	11	15
8	LSK Hansa	9	10	11	12
9	Holstein	10	10	19	9
10	Heider SV	8	4	19	4
11	Altona 93	7	5	12	3
12	Havelse	9	22	6	20
13	Werder	8	15	5	20
14	BSV Rehden	9	17	10	17
15	Oldenburg	8	12	8	14
16	Hannover	9	14	16	13
17	Jeddeloh	8	13	13	12
18	Oberneuland	10	9	15	12
19	Hildesheim	9	9	15	11
20	Wolfsburg	9	12	15	9
21	Hannoversche	10	14	24	6
22	Atlas	7	5	15	2

TEMPORADA 2019/2020

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	VfB Lübeck	25	64	24	61
2	Wolfsburg	24	72	27	56
3	Weiche	23	35	22	46
4	Drochtersen	25	37	33	44
5	Werder	25	40	37	40
6	Eintracht	24	40	33	39
7	Holstein	24	41	45	36
8	BSV Rehden	24	37	27	34
9	Oldenburg	23	40	42	34
10	Havelse	22	38	38	32
11	LSK Hansa	22	33	40	27
12	Pauli	24	34	33	26
13	Hannover	22	29	42	26
14	Hamburger	22	37	35	23
15	Jeddeloh	24	41	48	21
16	Altona 93	21	26	48	16
17	Heider SV	24	22	66	16
18	Hannoversche	24	20	46	15

TEMPORADA 2018/2019

OBERLIGA GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Altona 93	2	4	3	4
2	Heider SV	2	2	2	2
3	Bremer SV	2	3	4	1

TEMPORADA 2017/2018

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Weiche	34	61	25	73
2	Hamburger	34	66	31	72
3	Wolfsburg	34	65	34	65
4	VfB Lübeck	34	55	41	61
5	Germania	34	53	45	54
6	Pauli	34	60	44	51
7	Jeddeloh	34	57	56	49
8	Hannover	34	36	30	46
9	Eintracht	34	54	58	45
10	LSK Hansa	34	41	47	45
11	Havelse	34	51	59	45
12	Drochtersen	34	42	35	44
13	Oldenburg	34	43	52	40
14	Eintracht	34	51	65	40
15	BSV Rehden	34	45	53	39
16	Hildesheim	34	25	59	28
17	Eutin 08	34	51	80	24
18	Altona 93	34	31	73	23

TEMPORADA 2016/2017

OBERLIGA GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Eutin 08	3	3	0	7
2	Altona 93	3	2	0	7
3	Bremer SV	3	3	3	3
4	Eintracht	3	0	5	0

TEMPORADA 2015/2016

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Dassendorf	34	80	22	72
2	Barmbek-Uhle	34	75	34	71
3	Victoria	34	79	43	63
4	Süderelbe	34	95	34	60
5	Buchholz	34	73	37	60
6	Altona 93	34	65	41	57
7	Condor	34	73	56	54
8	Rugenbergen	34	67	52	51
9	Curslack-Neu	34	72	50	50
10	Halstenbek-R	34	60	44	49
11	WTSV	34	82	61	47
12	Niendorfer	34	56	39	46
13	Pinneberg	34	48	43	44
14	Türkiye	34	56	73	40
15	Buxtehude	34	51	72	39
16	Meiendorfer	34	48	77	35
17	Paloma	34	42	105	17
18	SV Lurup	34	13	252	1

TEMPORADA 2014/2015

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dassendorf	32	82	30	68
2	Victoria	32	72	40	64
3	Barmbek-Uhle	32	60	35	61
4	Pinneberg	32	54	38	56
5	Halstenbek-R	32	80	49	54
6	Buchholz	32	55	37	52
7	Altona 93	32	61	38	51
8	Niendorfer	32	56	50	50
9	Rugenbergen	32	44	41	49
10	Meiendorfer	32	47	51	49
11	Condor	32	62	59	43
12	Süderelbe	32	47	49	41
13	Curslack-Neu	32	51	57	40
14	Paloma	32	41	69	36
15	Buxtehude	32	35	71	23
16	Vier-	32	38	92	16
17	Germania	32	26	105	9
18	Elmshorn	0	0	0	0

TEMPORADA 2013/2014

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dassendorf	34	68	30	75
2	Curslack-Neu	34	83	39	64
3	Altona 93	34	78	43	64
4	Pinneberg	34	66	46	61
5	Buchholz	34	67	38	60
6	Condor	34	61	39	58
7	Niendorfer	34	44	30	55
8	Rugenbergen	34	74	62	55
9	Elmshorn	34	57	50	51
10	Halstenbek-R	34	52	47	49
11	Oststeinbeke	34	53	51	46
12	Meiendorfer	34	45	58	45
13	Barmbek-Uhle	34	52	52	40
14	Germania	34	55	81	36
15	Vier-	34	48	66	35
16	Alstertal-La	34	45	87	27
17	Blankenese	34	38	102	18
18	Bramfelder	34	30	95	13

TEMPORADA 2012/2013

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Elmshorn	34	76	29	76
2	Altona 93	34	74	50	67
3	Buchholz	34	79	38	65
4	Eintracht	34	76	37	64
5	Condor	34	75	48	58
6	Curslack-Neu	34	67	48	58
7	Halstenbek-R	34	51	46	50
8	Germania	34	50	54	47
9	Meiendorfer	34	61	62	45
10	Rugenbergen	34	54	55	45
11	Barmbek-Uhle	34	44	51	44
12	Vier-	34	45	55	41
13	Niendorfer	34	44	63	41
14	Pinneberg	34	50	59	39
15	Bramfelder	34	43	56	38
16	Paloma	34	41	49	36
17	SV Lurup	34	28	87	17
18	Bergedorf	34	35	106	15

TEMPORADA 2011/2012

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Victoria	34	73	36	71
2	Bergedorf	34	73	51	65
3	Curslack-Neu	34	63	41	64
4	Germania	34	66	49	60
5	Buchholz	34	55	39	59
6	Eintracht	34	62	37	58
7	Condor	34	54	44	57
8	Niendorfer	34	62	51	55
9	Altona 93	34	52	51	50
10	Pinneberg	34	57	55	49
11	Halstenbek-R	34	46	52	46
12	Meiendorfer	34	56	57	42
13	Vier-	34	55	70	40
14	Rugenbergen	34	51	62	38
15	Paloma	34	38	58	38
16	Oststeinbeke	34	39	55	37
17	Vorwärts-Wa	34	45	77	22
18	TSV Sasel	34	38	100	10

TEMPORADA 2010/2011

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Pauli	34	103	36	83
2	Buchholz	34	56	33	68
3	Curslack-Neu	34	55	43	62
4	Condor	34	55	43	57
5	Altona 93	34	63	46	54
6	Eintracht	34	55	44	52
7	Bergedorf	34	67	69	52
8	Meiendorfer	34	55	48	51
9	Victoria	34	58	51	50
10	Germania	34	55	47	45
11	Rugenbergen	34	46	47	45
12	Niendorfer	34	55	63	40
13	Oststeinbeke	34	59	67	39
14	Paloma	34	39	57	32
15	Barmbek-Uhle	34	46	68	32
16	Wedeler TSV	34	43	71	32
17	WTSV	34	37	71	31
18	Bramfelder	34	41	84	24

TEMPORADA 2009/2010

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Victoria	34	78	40	68
2	Buchholz	34	60	28	68
3	Altona 93	34	73	36	66
4	Curslack-Neu	34	64	46	62
5	Meiendorfer	34	64	42	56
6	Oststeinbeke	34	62	51	54
7	Paloma	34	53	44	49
8	Bergedorf	34	58	50	49
9	Condor	34	50	58	45
10	Eintracht	34	52	47	44
11	Niendorfer	34	43	43	42
12	Wedeler TSV	34	57	63	40
13	Barmbek-Uhle	34	39	56	40
14	WTSV	34	43	61	40
15	SV Lurup	34	40	57	39
16	Halstenbek-R	34	40	73	32
17	Lohbrügge	34	33	72	26
18	Uetersen	34	38	80	25

TEMPORADA 2008/2009

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Holstein	34	54	22	73
2	Hallescher	34	43	20	70
3	Babelsberg	34	46	25	63
4	Magdeburg	34	50	36	59
5	Wolfsburg	34	53	35	53
6	Hannover	34	48	42	49
7	Chemnitzer	34	50	42	45
8	VfB Lübeck	34	38	34	45
9	Oberneuland	34	40	41	44
10	Hansa	34	53	59	43
11	Wilhelmshave	34	45	52	43
12	Hertha	34	40	55	43
13	Hamburger	34	44	43	42
14	VFC Plauen	34	52	54	42
15	Türkiyemspo	34	36	43	42
16	Altona 93	34	40	66	31
17	Sachsen	34	21	54	24
18	Energie	34	23	53	23

Competiciones que juega

Grupo 3

Oberliga Grupo 3

Pos	Equipos		Pts
1		Altona 93	76
2		Dassendorf	71
3		ETSV Hamburg	60
4		Niendorfer TSV	58
5		HEBC Hamburg	57
6		TSV Sasel	52
7		Paloma Hamburg	49
8		Süderelbe	45
9		Victoria Hamburg	45
10		TuRa Harksheide	45
11		TSV Buchholz 08	43
12		Halstenbek-Rellingen	42
13		Wandsbeker Concordia	38
14		Alsterbruder	34
15		Rugenbergen	28
16		FC Türkiye Wilhelmsburg Ac.	26
17		Union Tornesch	21
18		Düneberger SV	17

	Ascenso : Altona 93
	Descenso : FC Türkiye Wilhelmsburg Aca, Union Tornesch, Düneberger SV

RIVALES EN Oberliga

USO DE MEMORIA

6,889,776 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1598
Total Execution Time	0.1610

CADENA URL

/historico/Altona-93

GET DATOS

$_GET['/historico/Altona-93']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0028	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 = 'Altona-93' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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 = 72461
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17095 AND type_rel = 2
0.0030	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17095 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0029	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 = '17095' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '17095' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72461 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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=17095 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (72461,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 = 72461 AND teamId = 17095
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17095
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 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 = 72461 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '17095' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021	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 = '17095' 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 = 72461 WHERE rp.league_id = 72461 AND rp.teamId = 17095 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.0027	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 = 72461 WHERE rp.league_id = 72461 AND rp.teamId = 17095 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 72461 WHERE rp.league_id = 72461 AND rp.teamId = 17095 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 17095 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72461 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 68313 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.0038	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 = 63377 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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 = 66875 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 58547 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039	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 = 50103 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.0047	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 = 44074 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* `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 = 49768 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 38888 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 33341 AND t.round = 34 ORDER BY team.conference 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* `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 = 38575 AND t.round = 3 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* `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 = 29204 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 15538 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 4247 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 3538 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 19808 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* `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 = 19821 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 19833 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* `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 = 19844 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* `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 = 16434 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Altona 93

Altona 93

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 3

RIVALES EN Oberliga