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

Meuselwitz

Entrenador: Heiko Weber

Temporada 2023/2024

TEMPORADA 2023/2024

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

TEMPORADA 2022/2023

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

TEMPORADA 2021/2022

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	BFC Dynamo	38	84	32	82
2	Carl Zeiss.	38	71	35	76
3	Energie	38	85	35	74
4	Altglienicke	38	80	47	72
5	Chemnitzer	38	67	37	72
6	Lokomotive	38	71	42	71
7	Berliner	38	65	48	69
8	Hertha	38	69	49	60
9	Chemie	38	47	48	56
10	Tennis	38	59	50	53
11	Babelsberg	38	46	42	53
12	Luckenwalde	38	58	50	50
13	Lichtenberg	38	49	64	44
14	Meuselwitz	38	42	54	41
15	Germania	38	48	68	41
16	Eilenburg	38	41	79	33
17	Union	38	49	89	33
18	Optik	38	48	81	30
19	Auerbach	38	45	95	23
20	Tasmania	38	28	107	17

TEMPORADA 2020/2021

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

TEMPORADA 2019/2020

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

TEMPORADA 2018/2019

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

TEMPORADA 2017/2018

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

TEMPORADA 2016/2017

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

TEMPORADA 2015/2016

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

TEMPORADA 2014/2015

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

TEMPORADA 2013/2014

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

TEMPORADA 2012/2013

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

TEMPORADA 2011/2012

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

TEMPORADA 2010/2011

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chemnitzer	34	82	23	82
2	Wolfsburg	34	59	28	75
3	VfB Lübeck	34	58	36	69
4	RB Leipzig	34	57	29	64
5	Hallescher	34	51	34	58
6	Holstein	34	65	36	55
7	Hertha	34	47	49	52
8	Hamburger	34	57	49	49
9	Hannover	34	56	47	46
10	Energie	34	49	51	45
11	Meuselwitz	34	41	53	42
12	Magdeburg	34	37	46	41
13	Wilhelmshave	34	48	61	41
14	VFC Plauen	34	43	48	39
15	Havelse	34	45	67	35
16	Eintracht	34	31	54	29
17	Oberneuland	34	46	77	28
18	Türkiyemspo	34	12	96	2

TEMPORADA 2009/2010

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Babelsberg	34	54	18	77
2	Wolfsburg	34	60	20	70
3	Chemnitzer	34	58	34	61
4	Hallescher	34	47	25	56
5	Hamburger	34	45	34	55
6	Magdeburg	34	57	38	51
7	VFC Plauen	34	49	39	50
8	Hannover	34	62	41	49
9	VfB Lübeck	34	47	48	49
10	Meuselwitz	34	40	50	43
11	Hertha	34	57	55	42
12	Hansa	34	36	60	40
13	Türkiyemspo	34	51	64	39
14	Wilhelmshave	34	45	59	39
15	Tennis	34	33	55	34
16	Oberneuland	34	37	71	33
17	Pauli	34	34	67	30
18	Goslarer SC	34	33	67	20

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 2005/2006

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Magdeburg	30	62	17	67
2	VFC Plauen	30	58	38	62
3	Sachsen	30	47	21	56
4	Hallescher	30	46	26	53
5	Meuselwitz	30	52	40	53
6	Germania	30	61	40	50
7	Rot-Weiß	30	36	40	44
8	Budissa	30	46	33	43
9	Energie	30	45	43	40
10	Borea	30	41	37	36
11	Auerbach	30	40	46	34
12	Eilenburg	30	32	39	31
13	Possneck	30	29	59	24
14	TSV Völpke	30	25	75	24
15	FC Grimma	30	30	51	23
16	Oberlausitz	30	33	78	20

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

Competiciones que juega

Grupo 3

Regionalliga Grupo 3

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

	Ascenso : Energie Cottbus
	Descenso : Berliner AK 07

RIVALES EN Regionalliga

USO DE MEMORIA

7,788,856 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1715
Total Execution Time	0.1727

CADENA URL

/historico/Meuselwitz

GET DATOS

$_GET['/historico/Meuselwitz']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

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 = 'Meuselwitz' 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.0019	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=5696 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=5696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=5696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045	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 = 72583
0.0021	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5696 AND type_rel = 2
0.0030	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 = '5696' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '5696' 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 = '5696' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72583 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.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=5696 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72583,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72583 AND teamId = 5696
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5696
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024	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 = '5696' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5696' and rp.type = 4
0.0022	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 = '5696' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0043	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 = 5696 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.0054	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 = 5696 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 = 5696 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 = 5696 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0032	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.0032	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68046 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63253 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 57335 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50104 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 43945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38890 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33792 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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.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* `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.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* `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.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* `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.0028	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1333 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 16428 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 16431 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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.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* `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.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* `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.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* `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 19889 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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

Meuselwitz

Meuselwitz

Selecciona un equipo

Competiciones que juega

Regionalliga Grupo 3

RIVALES EN Regionalliga