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

Zwickau

Entrenador: Rico Schmitt

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	46	36	56
5	Babelsberg	31	38	34	49
6	Altglienicke	31	61	45	48
7	Carl Zeiss.	31	52	40	46
8	Chemnitzer	31	40	44	44
9	Chemie	31	34	38	43
10	Zwickau	31	48	52	41
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	Eilenburg	31	39	54	33
16	Hertha	31	44	62	32
17	Hansa	31	41	58	26
18	Berliner	31	23	61	19

TEMPORADA 2022/2023

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Elversberg	38	80	40	74
2	Freiburg II	38	54	34	73
3	Osnabrück	38	70	49	70
4	Wehen	38	71	51	70
5	Saarbrücken	38	64	39	69
6	Dynamo	38	65	44	69
7	Waldhof	38	63	65	60
8	1860	38	61	52	57
9	Viktoria	38	58	53	55
10	Verl	38	60	58	49
11	Ingolstadt	38	54	56	47
12	Duisburg	38	54	58	46
13	Dortmund	38	47	49	45
14	Erzgebirge	38	49	62	45
15	Rot-Weiss	38	43	56	42
16	Hallescher	38	49	60	41
17	SV Meppen	38	43	65	37
18	Oldenburg	38	42	64	35
19	Zwickau	38	42	72	35
20	Bayreuth	38	39	81	32

TEMPORADA 2021/2022

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Magdeburg	36	83	39	78
2	Eintracht	36	61	36	64
3	Kaiserslaute	36	56	27	63
4	1860	36	67	50	61
5	Waldhof	36	58	40	60
6	Osnabrück	36	56	48	58
7	Saarbrücken	36	50	44	53
8	Wehen	36	49	44	51
9	Dortmund	36	51	48	49
10	Zwickau	36	46	44	47
11	Freiburg II	36	34	42	47
12	SV Meppen	36	47	60	47
13	Viktoria	36	39	52	45
14	Hallescher	36	46	48	43
15	Duisburg	36	46	71	42
16	Verl	36	56	66	40
17	Viktoria	36	44	62	37
18	Würzburger	36	34	59	30
19	Havelse	36	28	71	23
20	Türkgücü	0	0	0	0

TEMPORADA 2020/2021

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Dynamo	38	61	29	75
2	Hansa	38	52	33	71
3	Ingolstadt	38	56	40	71
4	1860	38	69	35	66
5	Saarbrücken	38	66	51	59
6	Wehen	38	57	53	56
7	Verl	38	66	55	55
8	Waldhof	38	50	55	52
9	Hallescher	38	51	58	52
10	Zwickau	38	46	45	51
11	Magdeburg	38	42	45	51
12	Viktoria	38	52	59	51
13	Türkgücü	38	45	55	47
14	Kaiserslaute	38	47	52	43
15	Duisburg	38	52	67	43
16	Uerdingen	38	38	50	41
17	SV Meppen	38	37	61	41
18	Bayern	38	47	58	37
19	VfB Lübeck	38	41	57	35
20	Unterhaching	38	40	57	32

TEMPORADA 2019/2020

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Bayern	38	76	60	65
2	Würzburger	38	71	60	64
3	Eintracht	38	64	53	64
4	Ingolstadt	38	61	40	63
5	Duisburg	38	68	48	62
6	Hansa	38	54	43	59
7	SV Meppen	38	69	57	58
8	1860	38	63	54	58
9	Waldhof	38	52	47	56
10	Kaiserslaute	38	59	54	55
11	Unterhaching	38	50	53	51
12	Viktoria	38	65	71	51
13	Uerdingen	38	40	54	48
14	Magdeburg	38	49	42	47
15	Hallescher	38	64	66	46
16	Zwickau	38	56	61	44
17	Chemnitzer	38	54	60	44
18	Preußen	38	49	62	40
19	Sonnenhof	38	33	67	32
20	Carl Zeiss.	38	40	85	23

TEMPORADA 2018/2019

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Osnabrück	38	56	31	76
2	Karlsruher	38	64	38	71
3	Wehen	38	71	47	70
4	Hallescher	38	47	34	66
5	Würzburger	38	56	45	57
6	Hansa	38	47	46	55
7	Zwickau	38	49	47	52
8	Preußen	38	48	50	52
9	Kaiserslaute	38	49	51	51
10	Uerdingen	38	47	62	48
11	1860	38	48	52	47
12	Unterhaching	37	53	46	47
13	SV Meppen	38	48	53	47
14	Carl Zeiss.	38	48	57	46
15	Sonnenhof	38	38	39	45
16	Eintracht	38	48	54	45
17	Energie	37	51	58	44
18	Sportfreunde	38	31	46	40
19	Fortuna	38	38	64	39
20	VfR Aalen	38	45	62	31

TEMPORADA 2017/2018

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Magdeburg	38	70	32	85
2	Paderborn	38	90	33	83
3	Karlsruher	38	49	29	69
4	Wehen	38	76	39	68
5	Würzburger	38	53	46	61
6	Hansa	38	48	34	60
7	SV Meppen	38	50	47	58
8	Fortuna	38	53	48	54
9	Unterhaching	38	54	55	54
10	Preußen	38	50	49	52
11	Carl Zeiss.	38	49	59	52
12	VfR Aalen	38	48	57	50
13	Hallescher	38	52	54	49
14	Sonnenhof	38	55	60	47
15	Zwickau	38	38	55	41
16	Sportfreunde	38	43	60	40
17	Osnabrück	38	47	67	37
18	Werder	38	39	62	31
19	Chemnitzer	38	48	74	22
20	Rot-Weiss	38	26	78	13

TEMPORADA 2016/2017

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Duisburg	38	52	32	68
2	Holstein	38	59	25	67
3	Jahn	38	62	50	63
4	Magdeburg	38	53	36	61
5	Zwickau	38	47	54	56
6	Osnabrück	38	46	43	54
7	Wehen	38	45	42	53
8	Chemnitzer	38	54	51	52
9	Preußen	38	49	43	51
10	Sonnenhof	38	48	48	51
11	VfR Aalen	38	52	36	48
12	Sportfreunde	38	46	47	48
13	Hallescher	38	34	39	48
14	Rot-Weiss	38	34	47	47
15	Hansa	38	44	46	46
16	Fortuna	38	37	59	46
17	Werder	38	32	48	45
18	Paderborn	38	38	57	44
19	Mainz 05 II	38	41	58	40
20	Frankfurt	38	38	50	25

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

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Zwickau	26	71	20	60
2	Auerbach	26	47	30	52
3	Rot-Weiß	26	40	35	46
4	Dynamo	26	51	36	44
5	Carl Zeiss.	26	39	32	44
6	Lokomotive	26	40	27	42
7	Chemnitzer	26	39	28	39
8	Fortuna	26	47	48	37
9	Budissa	26	34	30	36
10	Erzgebirge	26	43	42	31
11	Luckenwalde	26	38	55	24
12	Wacker Gotha	26	26	65	18
13	Grün-Weiß	26	27	63	16
14	VfL Halle	26	22	53	15
15	Borea	0	0	0	0
16	Gera	0	0	0	0

TEMPORADA 2010/2011

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Germania	30	69	22	72
2	Auerbach	30	63	39	57
3	Budissa	30	44	30	52
4	Rot-Weiß	30	48	39	48
5	Dynamo	30	48	45	41
6	Luckenwalde	30	53	55	41
7	Erzgebirge	30	43	47	41
8	Lokomotive	30	42	43	39
9	Zwickau	30	39	39	37
10	Sachsen	30	33	43	36
11	Chemnitzer	30	45	50	34
12	Wacker Gotha	30	40	55	34
13	Carl Zeiss.	30	42	47	33
14	VfL Halle	30	34	47	33
15	Borea	30	33	47	32
16	Magdeburg	30	37	65	26

TEMPORADA 2009/2010

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	RB Leipzig	30	74	17	80
2	Budissa	30	43	22	58
3	Carl Zeiss.	30	56	37	53
4	Auerbach	30	54	35	53
5	Dynamo	30	52	36	50
6	Sachsen	30	40	27	48
7	Rot-Weiß	30	40	41	43
8	Erzgebirge	30	41	32	40
9	Zwickau	30	42	37	39
10	Germania	30	47	46	39
11	VfL Halle	30	40	38	36
12	Lokomotive	30	30	42	33
13	Borea	30	37	58	28
14	Gera 03	30	31	60	25
15	Possneck	30	17	63	18
16	Schott Jena	30	15	68	15

TEMPORADA 2008/2009

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Meuselwitz	30	59	19	66
2	Auerbach	30	49	29	59
3	Lokomotive	30	56	38	56
4	Gera 03	30	46	45	52
5	Germania	30	43	37	48
6	Markranstäd	30	50	33	47
7	Zwickau	30	44	42	46
8	Possneck	30	36	35	41
9	Budissa	30	29	34	40
10	Erzgebirge	30	43	38	37
11	Carl Zeiss.	30	35	49	33
12	Borea	30	36	46	32
13	Rot-Weiß	30	47	57	30
14	Eilenburg	30	28	46	27
15	Grun Weiss.	30	31	53	23
16	Magdeburg	30	25	56	20

TEMPORADA 2007/2008

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Hallescher	30	50	21	63
2	Chemnitzer	30	55	25	57
3	VFC Plauen	29	47	31	53
4	Sachsen	30	47	36	48
5	Carl Zeiss.	30	49	36	46
6	Auerbach	30	40	25	45
7	Gera 03	30	47	50	44
8	Meuselwitz	30	51	49	43
9	Germania	30	56	41	42
10	Markranstäd	30	41	38	42
11	Eilenburg	29	42	46	34
12	Dresden-Nord	15	23	11	32
13	Zwickau	30	34	54	29
14	Budissa	30	28	55	28
15	Possneck	30	23	58	22
16	Sangerhausen	30	19	54	19
17	Borea	15	10	32	9

TEMPORADA 2006/2007

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Energie	30	53	26	61
2	Chemnitzer	30	48	19	57
3	Eilenburg	30	45	32	55
4	Sachsen	30	40	27	53
5	Meuselwitz	30	41	42	45
6	VFC Plauen	30	41	34	43
7	Hallescher	30	31	30	42
8	Budissa	30	37	39	38
9	Zwickau	30	36	31	37
10	Germania	30	43	44	37
11	Borea	30	34	39	37
12	Auerbach	30	33	39	37
13	Possneck	30	31	51	36
14	Carl Zeiss.	30	25	34	33
15	Dessau 05	30	36	53	26
16	Rot-Weiß	30	29	63	19

TEMPORADA 2004/2005

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Carl Zeiss.	34	108	23	87
2	VFC Plauen	34	76	30	75
3	Sachsen	34	52	31	63
4	Hallescher	34	70	38	60
5	Magdeburg	34	59	33	58
6	Meuselwitz	34	58	36	56
7	Auerbach	34	54	65	49
8	Possneck	34	41	56	47
9	Germania	34	51	50	46
10	FC Grimma	34	52	55	43
11	Oberlausitz	34	49	58	42
12	Eilenburg	34	42	52	41
13	Dresden-Nord	34	44	51	38
14	Zwickau	34	43	59	38
15	Dessau 05	34	36	49	34
16	Eintracht	34	43	91	31
17	Erfurt-Nord	34	20	77	19
18	Dresden-Laub	34	34	78	18

TEMPORADA 2003/2004

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Carl Zeiss.	33	79	20	75
2	VFC Plauen	33	71	27	75
3	Magdeburg	34	66	19	74
4	Hallescher	33	58	34	61
5	Dresden-Nord	33	51	34	59
6	Lokomotive	31	55	39	53
7	Energie	32	57	45	51
8	Zwickau	33	40	43	43
9	Dresden-Laub	33	42	57	40
10	Possneck	33	43	51	39
11	Oberlausitz	33	48	53	36
12	FC Grimma	33	38	55	36
13	Germania	32	32	46	34
14	Auerbach	33	34	53	30
15	Eintracht	33	41	70	29
16	Erfurt-Nord	33	33	74	24
17	Dresdner SC	33	29	57	23
18	Anhalt	18	12	52	6

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	56
5		SV Babelsberg 03	49
6		Altglienicke	48
7		FC Carl Zeiss Jena	46
8		Chemnitzer	44
9		Chemie Leipzig	43
10		Zwickau	41
11		Rot-Weiss Erfurt	38
12		Meuselwitz	38
13		Lokomotive Leipzig	37
14		Luckenwalde	35
15		Eilenburg	33
16		Hertha BSC II	32
17		Hansa Rostock II	26
18		Berliner AK 07	19

	Ascenso : Energie Cottbus
	Descenso : Berliner AK 07

RIVALES EN Regionalliga

USO DE MEMORIA

7,908,608 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.7535
Total Execution Time	0.7556

CADENA URL

/historico/Zwickau

GET DATOS

$_GET['/historico/Zwickau']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0157	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 = 'Zwickau' 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.0146	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=9746 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=9746 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=9746 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9746 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 = '9746' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0151	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 = '9746' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156	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=9746 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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,68042) 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 = 68042 AND teamId = 9746
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 72583 AND teamId = 9746
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9746
0.0147	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 = '9746' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9746' and rp.type = 4
0.0148	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 = '9746' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0174	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 = 9746 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.0194	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 = 9746 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 = 72583 WHERE rp.league_id = 72583 AND rp.teamId = 9746 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160	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 = 9746 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0296	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 = 32 ORDER BY team.conference ASC,t.position 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* `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 = 68042 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.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* `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 = 63195 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.0152	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 = 57101 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.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* `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 = 49902 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.0161	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 = 43698 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0175	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 = 38729 AND t.round = 38 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* `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 = 33314 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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.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* `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.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* `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.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* `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.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* `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 = 19828 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	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 = 19840 AND t.round = 30 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* `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 = 19853 AND t.round = 30 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* `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 = 19864 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	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 = 19874 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* `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 = 19879 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 28297 AND t.round = 34 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* `tables2004` 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 = 28293 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Zwickau

Zwickau

Selecciona un equipo

Competiciones que juega

Regionalliga Grupo 3

RIVALES EN Regionalliga