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

Condor Hamburg

Temporada 2023/2024

TEMPORADA 2023/2024

LANDESLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Vorwärts-Wa	24	97	34	59
2	Hamburg	24	69	37	53
3	Voran Ohe	24	68	38	51
4	Rahlstedter	25	59	37	50
5	Bramfelder	25	58	37	45
6	Hamm United	23	47	37	41
7	Curslack-Neu	25	63	62	36
8	Condor	25	63	64	36
9	Altengamme	24	51	52	29
10	Lohbrügge	25	49	53	29
11	Vier-	25	54	67	28
12	Ahrensburger	25	57	77	24
13	Concordia	25	61	71	23
14	ASV Hamburg	25	44	79	23
15	Harburger	25	33	80	16
16	Oststeinbeke	25	32	80	15

TEMPORADA 2022/2023

LANDESLIGA GRUPO 20
Equipo		PJ	GF	GC	Puntos
1	ETSV Hamburg	30	128	31	78
2	Düneberger	30	121	42	77
3	Voran Ohe	30	67	56	54
4	Rahlstedter	30	84	51	52
5	Billstedt	30	89	66	50
6	Lohbrügge	30	72	57	49
7	Condor	30	76	70	49
8	Bramfelder	30	80	50	48
9	Altengamme	30	65	49	41
10	Ahrensburger	30	68	70	40
11	ASV Hamburg	30	69	75	38
12	Hamburg	30	70	60	36
13	Oststeinbeke	30	50	87	32
14	Kosova	30	40	57	28
15	Sasel	30	34	122	9
16	Meiendorfer	30	22	192	3

TEMPORADA 2019/2020

LANDESLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Lohbrügge	22	96	26	61
2	ASV Hamburg	22	70	38	42
3	Altengamme	21	51	32	41
4	Billstedt	21	40	34	37
5	Condor	22	53	53	36
6	Rahlstedter	22	46	48	34
7	Voran Ohe	20	48	43	33
8	Kosova	22	48	42	28
9	Oststeinbeke	22	38	43	26
10	Bergstedt	21	40	47	26
11	Türkiye	19	33	44	23
12	TuS Berne	21	36	81	22
13	Dersimspor	19	33	47	21
14	Düneberger	22	31	58	21
15	Nettelnburg/	22	36	44	20
16	FTSV	22	36	55	14

TEMPORADA 2018/2019

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Altona 93	34	72	24	78
2	Teutonia	34	79	33	76
3	Dassendorf	34	92	30	71
4	Victoria	34	100	46	71
5	Niendorfer	34	81	39	64
6	TSV Sasel	35	90	53	62
7	Barmbek-Uhle	34	88	58	60
8	Tus Osdorf	34	68	69	50
9	Buchholz	34	73	66	49
10	Süderelbe	34	68	70	46
11	Curslack-Neu	34	61	59	44
12	Rugenbergen	34	63	67	40
13	Wandsbeker	34	56	76	37
14	Meiendorfer	34	44	71	36
15	Wedeler TSV	34	51	68	33
16	HEBC Hamburg	34	55	99	29
17	Condor	35	60	95	28
18	Pinneberg	34	21	199	3

TEMPORADA 2017/2018

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Dassendorf	34	100	27	96
2	Victoria	34	96	33	72
3	Teutonia	34	92	51	72
4	Niendorfer	34	74	43	71
5	Rugenbergen	34	78	59	58
6	TSV Sasel	34	86	64	55
7	Buchholz	34	66	50	50
8	Barmbek-Uhle	34	65	71	47
9	Wandsbeker	34	69	70	46
10	Curslack-Neu	34	62	72	45
11	Tus Osdorf	34	75	85	41
12	Pinneberg	34	48	73	41
13	Süderelbe	34	59	84	40
14	Condor	34	62	80	35
15	Wedeler TSV	34	73	97	35
16	Türkiye	34	56	96	28
17	Hamburger	34	57	96	27
18	Vorwärts-Wa	34	45	112	18

TEMPORADA 2016/2017

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dassendorf	34	79	32	75
2	Buchholz	34	77	44	66
3	Altona 93	34	72	41	64
4	Victoria	34	82	63	61
5	WTSV	34	89	52	59
6	Wedeler TSV	34	77	67	56
7	Tus Osdorf	33	63	53	55
8	Rugenbergen	34	67	54	49
9	Pinneberg	34	62	57	46
10	Condor	33	62	69	46
11	Türkiye	34	51	61	45
12	Curslack-Neu	34	44	55	45
13	Barmbek-Uhle	34	56	55	44
14	Niendorfer	34	57	62	40
15	Süderelbe	34	65	78	36
16	Halstenbek-R	34	37	72	29
17	Kosova	34	32	106	22
18	Buxtehude	34	40	91	17

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

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Victoria	34	83	37	74
2	Meiendorfer	34	68	38	67
3	Bergedorf	34	67	39	67
4	Buchholz	34	56	29	66
5	Pauli	34	78	36	60
6	Curslack-Neu	34	71	55	58
7	Barmbek-Uhle	34	54	58	50
8	Eintracht	34	61	60	49
9	SV Lurup	34	46	48	49
10	Condor	34	51	47	46
11	Paloma	34	46	42	43
12	Niendorfer	34	45	48	42
13	Concordia	34	42	51	40
14	Halstenbek-R	34	35	56	40
15	Hamburg 93	34	43	75	30
16	Vorwärts-Wa	34	39	66	27
17	Egenbuttel	34	39	91	21
18	Voran Ohe	34	43	91	20

Competiciones que juega

Grupo 8

Landesliga Grupo 8

Pos	Equipos		Pts
1		Vorwärts-Wacker 04	59
2		HT 16 Hamburg	53
3		Voran Ohe	51
4		Rahlstedter SC	50
5		Bramfelder SV	45
6		Hamm United FC	41
7		Curslack-Neuengamme	36
8		Condor Hamburg	36
9		SV Altengamme	29
10		Lohbrügge	29
11		SC Vier- und Marschlande	28
12		Ahrensburger TSV	24
13		Concordia Hamburg II	23
14		ASV Hamburg	23
15		Harburger TB	16
16		Oststeinbeker SV	15

RIVALES EN Landesliga

USO DE MEMORIA

6,646,296 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6759
Total Execution Time	0.6771

CADENA URL

/historico/Condor-Hamburg

GET DATOS

$_GET['/historico/Condor-Hamburg']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0166	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 = 'Condor-Hamburg' 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.0151	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=17099 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151	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=17099 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0319	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 = 73088
0.0147	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17099 AND type_rel = 2
0.0148	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2090 AND type_rel = 3
0.0151	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2090 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0157	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 (184451,1011237,984949) ORDER BY n.cover_points DESC, update_date DESC
0.0164	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 = '17099' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155	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 = 73088 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0160	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=17099 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0150	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 (73088) 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.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 73088 AND teamId = 17099
0.0155	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 = '17099' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0150	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17099' and rp.type = 4
0.0159	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 = '17099' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0161	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 = 73088 WHERE rp.league_id = 73088 AND rp.teamId = 17099 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.0157	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 = 73088 WHERE rp.league_id = 73088 AND rp.teamId = 17099 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155	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 = 73088 WHERE rp.league_id = 73088 AND rp.teamId = 17099 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162	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 = 17099 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0164	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 = 73088 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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 = 72026 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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 = 50262 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.0166	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.0164	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 = 38886 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0172	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.0170	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.0168	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.0166	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.0154	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.0156	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.0156	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.0171	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.0167	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 = 19858 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Condor Hamburg

Condor Hamburg

Selecciona un equipo

Competiciones que juega

Landesliga Grupo 8

RIVALES EN Landesliga