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

Germania Halberstadt

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	VFC Plauen	26	54	13	63
2	Bischofswerd	26	59	28	58
3	Germania	26	59	36	50
4	Magdeburg	26	61	37	49
5	Auerbach	26	55	31	48
6	Krieschow	26	49	41	40
7	Union	26	43	34	39
8	SC Freital	26	37	39	34
9	Einheit	26	49	58	32
10	Ludwigsfelde	26	32	39	31
11	Budissa	26	35	42	28
12	VfL Halle	26	38	50	27
13	FC Grimma	26	31	55	26
14	Einheit	26	33	50	25
15	Motor	26	26	81	21
16	Arnstadt	26	28	55	15

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

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Chemie	30	69	21	71
2	Germania	30	73	20	69
3	Bischofswerd	30	62	21	66
4	Wismut Gera	30	48	37	50
5	1899	30	44	44	50
6	Einheit	30	47	38	49
7	Internationa	30	45	38	43
8	Carl Zeiss.	30	59	50	42
9	VFC Plauen	30	48	41	41
10	Askania	30	45	53	34
11	Union	30	42	58	33
12	Barleben	30	41	71	32
13	BSC Süd 05	30	37	54	29
14	Schott Jena	30	29	55	23
15	VfL Halle	30	32	64	21
16	Markranstäd	30	24	80	17

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

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 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 5

Oberliga Grupo 5

Pos	Equipos		Pts
1		VFC Plauen	63
2		Bischofswerdaer	58
3		Germania Halberstadt	50
4		Magdeburg II	49
5		Auerbach	48
6		VfB Krieschow	40
7		Union Sandersdorf	39
8		SC Freital	34
9		Einheit Wernigerode	32
10		Ludwigsfelder FC	31
11		Budissa Bautzen	28
12		VfL Halle	27
13		FC Grimma	26
14		Einheit Rudolstadt	25
15		FSV Motor Marienberg	21
16		SV 09 Arnstadt	15

	Ascenso : VFC Plauen

RIVALES EN Oberliga

USO DE MEMORIA

7,650,032 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1861
Total Execution Time	0.1882

CADENA URL

/historico/Germania-Halbe

GET DATOS

$_GET['/historico/Germania-Halbe']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0033	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 = 'Germania-Halbe' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5702 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=5702 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=5702 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043	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 = 72542
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5702 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5702 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019	SELECT /35 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 (688233) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '5702' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0036	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 = '5702' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72542 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=5702 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (72542,71432,68046) 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.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 68046 AND teamId = 5702
0.0036	SELECT count(id) as num_players from rel_players WHERE league_id = 72542 AND teamId = 5702
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5702
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72542 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '5702' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5702' and rp.type = 4
0.0020	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 = '5702' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72542 WHERE rp.league_id = 72542 AND rp.teamId = 5702 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.0046	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 = 72542 WHERE rp.league_id = 72542 AND rp.teamId = 5702 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039	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 = 72542 WHERE rp.league_id = 72542 AND rp.teamId = 5702 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 5702 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72542 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 33811 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.0058	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.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* `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.0023	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.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0019	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 = 72542 ORDER BY nameShow LIMIT 100

Germania Halberstadt

Germania Halberstadt

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 5

RIVALES EN Oberliga