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

Phönix Lübeck

Entrenador: Christiano Adigo

Temporada 2023/2024

TEMPORADA 2023/2024

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Hannover	32	83	40	70
2	SV Meppen	32	69	38	65
3	Phönix	31	75	33	62
4	Drochtersen	32	49	40	55
5	Holstein	32	59	50	52
6	Oldenburg	32	59	44	51
7	Teutonia	32	59	44	48
8	Hamburger	31	47	44	48
9	Havelse	31	51	48	46
10	BW Lohne	32	51	47	45
11	Pauli	32	61	42	43
12	Bremer SV	31	46	54	41
13	Eintracht	32	55	62	40
14	Weiche	31	39	53	34
15	Jeddeloh	32	36	62	33
16	Eimsbüttele	32	35	67	22
17	Kilia Kiel	31	31	75	16
18	Spelle-Venha	32	26	88	12

TEMPORADA 2022/2023

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	VfB Lübeck	36	74	29	76
2	Hamburger	36	78	45	75
3	Hannover	36	81	54	67
4	Teutonia	36	63	57	58
5	Weiche	36	56	47	56
6	Havelse	36	54	47	52
7	Pauli	36	58	68	51
8	Drochtersen	36	55	44	50
9	BW Lohne	36	65	63	49
10	Eintracht	36	55	49	48
11	Jeddeloh	36	58	63	48
12	Holstein	36	61	57	47
13	Phönix	36	59	56	47
14	Bremer SV	36	51	56	46
15	Werder	36	57	61	45
16	BSV Rehden	36	44	56	41
17	Hildesheim	36	53	64	39
18	Atlas	36	53	82	32
19	Kickers	36	26	103	15

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

OBERLIGA GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Phönix	20	63	21	47
2	Todesfelde	19	51	21	47
3	Flensburg	19	64	31	39
4	Weiche	17	49	26	36
5	SV Eichede	20	44	29	36
6	Lübeck	21	55	44	36
7	Oldenburger	20	60	51	33
8	Bordesholm	20	42	33	31
9	Preußen	19	37	43	28
10	Eutin 08	20	28	29	24
11	Union	18	30	44	23
12	Frisia	21	31	59	21
13	Husumer SV	19	41	55	19
14	Inter	20	29	54	16
15	Kropp	17	17	52	3
16	Eckernförde	18	20	69	1

TEMPORADA 2018/2019

LANDESLIGA GRUPO 19
Equipo		PJ	GF	GC	Puntos
1	Oldenburger	30	118	31	81
2	Phönix	30	96	41	70
3	Preußen	30	89	42	64
4	Pansdorf	30	60	46	52
5	Dornbreite	30	79	74	46
6	Eichede	30	62	48	45
7	Siebenbäume	30	53	57	43
8	SpVg	30	67	71	41
9	Klausdorf	30	54	63	41
10	Heikendorfer	30	49	64	37
11	Lübecker	30	62	69	36
12	Travemünde	30	42	64	36
13	Hartenholm	30	51	57	32
14	Schackendorf	30	44	85	26
15	Concordia	30	40	82	20
16	Wankendorf	30	33	105	14

TEMPORADA 1973/1974

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eintracht	36	125	23	93
2	FC St Pauli	36	113	48	82
3	Osnabrück	36	84	43	68
4	Wolfsburg	36	77	51	65
5	Oldenburg	36	71	55	60
6	Barmbek-Uhle	36	48	38	58
7	Olympia	36	74	57	55
8	SV Meppen	36	55	54	51
9	Concordia	36	44	56	51
10	Arminia	36	57	59	49
11	Hannover	36	70	67	46
12	Göttingen	36	55	46	45
13	Holstein	36	54	73	42
14	Bremerhaven	36	35	61	42
15	Heider SV	36	48	76	31
16	VfB Lübeck	36	34	80	30
17	Itzehoer	36	48	107	28
18	Pinneberg	36	43	76	25
19	Phönix	36	40	105	23

TEMPORADA 1972/1973

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FC St Pauli	34	94	33	82
2	Osnabrück	34	75	41	75
3	Wolfsburg	34	71	35	65
4	Göttingen	34	60	36	61
5	VfB Lübeck	34	48	42	55
6	Barmbek-Uhle	34	47	35	52
7	Phönix	34	55	58	52
8	Holstein	34	63	47	49
9	Arminia	34	48	41	45
10	Oldenburg	34	54	73	40
11	SV Meppen	34	51	62	39
12	Olympia	34	47	55	35
13	Hannover	34	51	74	35
14	Heider SV	34	44	54	33
15	Itzehoer	34	27	58	33
16	Bremerhaven	34	40	60	31
17	TuS Celle	34	40	70	28
18	HSC Leu 06	34	37	78	27

TEMPORADA 1971/1972

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FC St Pauli	34	86	37	78
2	Osnabrück	34	62	20	70
3	Wolfsburg	34	63	38	65
4	Barmbek-Uhle	34	53	33	64
5	Göttingen	34	67	48	64
6	VfB Lübeck	34	50	41	53
7	HSC Leu 06	34	60	47	51
8	Olympia	34	36	33	46
9	Heider SV	34	50	50	43
10	TuS Celle	34	52	64	43
11	Holstein	34	48	56	42
12	Hannover	34	47	69	42
13	Arminia	34	43	51	38
14	Phönix	34	43	59	38
15	Bremerhaven	34	42	60	33
16	Itzehoer	34	36	60	29
17	SC Sperber	34	34	69	25
18	Polizei	34	31	68	25

TEMPORADA 1970/1971

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Osnabrück	34	70	39	60
2	FC St Pauli	34	53	31	60
3	Holstein	34	66	50	59
4	VfB Lübeck	34	63	45	58
5	Barmbek-Uhle	34	63	39	56
6	Olympia	34	37	27	55
7	Bremerhaven	34	54	48	52
8	Göttingen	34	63	42	51
9	Wolfsburg	34	56	48	48
10	TuS Celle	34	52	55	45
11	HSC Leu 06	34	59	55	42
12	Itzehoer	34	49	65	41
13	Arminia	34	46	61	38
14	Phönix	34	38	58	38
15	SC Sperber	34	34	51	36
16	Oldenburg	34	40	57	35
17	Heider SV	34	38	56	35
18	SV Meppen	34	43	97	22

TEMPORADA 1969/1970

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Osnabrück	32	75	38	68
2	Wolfsburg	32	78	35	65
3	Holstein	32	64	37	61
4	FC St Pauli	32	56	33	60
5	Göttingen	32	65	42	59
6	Bremerhaven	32	57	47	53
7	VfB Lübeck	32	46	41	50
8	Arminia	32	53	51	46
9	Oldenburg	32	44	48	45
10	Barmbek-Uhle	32	42	45	40
11	TuS Celle	32	39	61	36
12	Itzehoer	32	57	71	34
13	HSC Leu 06	32	42	57	32
14	Phönix	32	41	61	32
15	Bergedorf	32	46	79	31
16	Olympia	32	28	49	27
17	Concordia	32	22	60	18

TEMPORADA 1968/1969

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Osnabrück	32	94	27	77
2	VfB Lübeck	32	61	39	63
3	FC St Pauli	32	64	37	62
4	Göttingen	32	66	51	58
5	Arminia	32	51	35	53
6	Wolfsburg	32	59	44	53
7	Phönix	32	55	41	53
8	Holstein	32	47	51	44
9	Bremerhaven	32	53	57	40
10	Barmbek-Uhle	32	48	57	38
11	Bergedorf	32	56	67	37
12	Oldenburg	32	47	59	34
13	Concordia	32	41	64	33
14	Itzehoer	32	47	72	32
15	Heider SV	32	46	79	27
16	TuS Celle	32	48	71	26
17	SC Sperber	32	39	71	25

TEMPORADA 1967/1968

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Arminia	32	64	25	64
2	Göttingen	32	66	36	64
3	Wolfsburg	32	61	34	60
4	FC St Pauli	32	60	30	58
5	Bremerhaven	32	48	53	56
6	Phönix	32	49	39	52
7	Holstein	32	47	37	47
8	Osnabrück	32	51	43	47
9	VfB Lübeck	32	44	41	46
10	SC Sperber	32	53	63	45
11	Oldenburg	32	49	49	40
12	Itzehoer	32	50	64	37
13	Concordia	32	42	52	33
14	Barmbek-Uhle	32	56	79	33
15	Bergedorf	32	31	54	30
16	Altona 93	32	37	78	28
17	TuS Haste	32	40	71	27

TEMPORADA 1963/1964

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Pirmasens	38	128	49	86
2	Borussia	38	106	32	85
3	Wormatia	38	85	41	83
4	Mainz 05	38	79	55	65
5	Eintracht	38	72	68	59
6	Saar	38	76	49	58
7	Kaiserslaute	38	65	54	58
8	Sportfreunde	38	81	62	57
9	Ludwigshafen	38	66	64	57
10	TuS Koblenz	38	84	73	55
11	Phönix	38	58	56	55
12	Tura	38	64	54	49
13	Weisenau	38	60	77	45
14	BSC Oppau	38	49	71	45
15	Rochling	38	65	74	44
16	Frankenthal	38	55	77	44
17	Phonix	38	67	99	38
18	Zweibrücken	38	50	98	31
19	ASV Landau	38	39	110	23
20	1911	38	37	123	21

TEMPORADA 1959/1960

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hamburger	22	69	25	48
2	Werder	22	58	35	43
3	Osnabrück	22	41	26	42
4	FC St Pauli	22	43	24	40
5	Bremerhaven	22	42	31	39
6	Eintracht	22	35	30	34
7	Concordia	22	34	42	31
8	Holstein	22	36	28	30
9	Hannover 96	22	36	39	29
10	VfB Lübeck	22	30	38	29
11	Hildesheim	21	27	35	28
12	Altona 93	22	29	34	23
13	Neumunster	22	31	38	23
14	Phönix	22	24	51	22
15	Bergedorf	22	31	52	18
16	Eintracht	21	19	57	8

Competiciones que juega

Grupo 5

Regionalliga Grupo 5

Pos	Equipos		Pts
1		Hannover 96 II	70
2		SV Meppen	65
3		Phönix Lübeck	62
4		Drochtersen / Assel	55
5		Holstein Kiel II	52
6		VfB Oldenburg	51
7		Teutonia Ottensen	48
8		Hamburger SV II	48
9		Havelse	46
10		BW Lohne	45
11		St. Pauli II	43
12		Bremer SV	41
13		Eintracht Norderstedt	40
14		Weiche Flensburg	34
15		Jeddeloh	33
16		Eimsbütteler TV	22
17		Kilia Kiel	16
18		Spelle-Venhaus	12

	Ascenso : Hannover 96 II
	Playoff Descenso : Eimsbütteler TV
	Descenso : Kilia Kiel, Spelle-Venhaus

RIVALES EN Regionalliga

USO DE MEMORIA

7,018,952 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6810
Total Execution Time	0.6822

CADENA URL

/historico/Fc-Phonix-Lubeck

GET DATOS

$_GET['/historico/Fc-Phonix-Lubeck']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0149	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 = 'Fc-Phonix-Lubeck' 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=85486 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=85486 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=85486 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253	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 = 72795
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=85486 AND type_rel = 2
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=178 AND type_rel = 3
0.0134	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 178 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0131	SELECT /53 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 (1312550,1292079,1266183,1227043,1201762) ORDER BY n.cover_points DESC, update_date DESC
0.0131	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 = '85486' ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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 = '85486' 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 = '85486' 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 = 72795 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	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=85486 AND l.year in (2023,2024,2025) 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 (72795,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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 72795 AND teamId = 85486
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 85486
0.0137	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 = 72795 AND t.round = 32 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 = '85486' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '85486' 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 = '85486' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137	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 = 72795 WHERE rp.league_id = 72795 AND rp.teamId = 85486 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 72795 WHERE rp.league_id = 72795 AND rp.teamId = 85486 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 events2024 e ON e.player_id = p.id AND e.league_id = 72795 WHERE rp.league_id = 72795 AND rp.teamId = 85486 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 85486 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72795 AND t.round = 32 ORDER BY team.conference ASC,t.position 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* `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 = 68049 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.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* `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.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* `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.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 = 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.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* `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 = 50542 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 48752 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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* `tables1974` 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 = 22726 AND t.round = 38 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* `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 = 22728 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	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 = 22736 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* `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 = 22762 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* `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 = 22836 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* `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 = 22837 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* `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 = 22884 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 22891 AND t.round = 38 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* `tables1960` 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 = 47456 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 72795 ORDER BY nameShow LIMIT 100

Phönix Lübeck

Phönix Lübeck

Selecciona un equipo

Competiciones que juega

Regionalliga Grupo 5

RIVALES EN Regionalliga