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

KSV Baunatal

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Türkgücü	29	77	35	62
2	FC Giessen	29	56	21	61
3	Bayern	29	63	32	56
4	Baunatal	29	61	40	55
5	Eddersheim	29	50	38	49
6	Hanauer 1960	28	54	45	48
7	Hünfelder	28	59	51	45
8	Fernwald	29	51	44	43
9	Adler	29	46	46	40
10	Rot-Weiß	29	53	53	39
11	Waldgirmes	29	43	68	36
12	Eintracht	29	47	48	34
13	Marburg	29	42	57	33
14	FC Hanau 93	29	45	61	30
15	FC Erlensee	29	40	60	26
16	Steinbach	29	35	61	23
17	Viktoria	29	32	63	23
18	Dietkirchen	29	38	69	21

TEMPORADA 2022/2023

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Eintracht	38	113	35	89
2	FC Giessen	38	80	41	82
3	Türkgücü	38	89	64	70
4	Fernwald	38	86	58	69
5	Eintracht	38	80	51	65
6	Baunatal	38	67	51	62
7	Rot-Weiß	38	87	68	60
8	FC Hanau 93	38	71	64	58
9	Steinbach	38	64	60	52
10	FC Erlensee	38	64	60	49
11	Eddersheim	38	53	53	47
12	Bayern	38	51	60	47
13	Waldgirmes	38	67	73	46
14	Adler	38	55	83	45
15	Viktoria	38	53	89	44
16	Dietkirchen	38	59	80	41
17	Unter-Flocke	38	65	110	40
18	Neuhof	38	44	70	37
19	Rot-Weiß	38	57	96	37
20	Steinbach	38	54	93	25

TEMPORADA 2021/2022

OBERLIGA GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Bayern	12	33	17	46
2	Rot-Weiß	12	27	17	41
3	Viktoria	12	33	20	36
4	Türkgücü	12	26	14	36
5	FC Hanau 93	12	22	12	33
6	Baunatal	12	15	21	33
7	Steinbach	12	23	21	30
8	Bad Vilbel	12	10	14	27
9	Hünfelder	12	14	21	24
10	Ginsheim	12	20	21	23
11	Zeilsheim	12	10	25	19
12	Buchonia	12	4	34	17

TEMPORADA 2020/2021

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Barockstadt	12	31	6	33
2	Hessen	12	37	11	31
3	Rot-Weiß	12	31	17	23
4	FC Hanau 93	11	28	16	23
5	Türkgücü	11	24	9	22
6	Rot-Weiß	12	15	15	19
7	Waldgirmes	12	24	21	18
8	Buchonia	12	20	17	18
9	Zeilsheim	12	23	22	15
10	Fernwald	11	16	18	15
11	Steinbach	12	15	17	15
12	Bad Vilbel	12	12	14	13
13	Baunatal	11	14	19	13
14	Neuhof	12	14	25	13
15	Dietkirchen	12	16	34	13
16	Ginsheim	12	17	25	11
17	Viktoria	12	12	16	10
18	Hünfelder	12	8	23	9
19	Eddersheim	11	19	28	8
20	FC Erlensee	11	7	30	7

TEMPORADA 2019/2020

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Eintracht	22	54	27	48
2	Hessen	22	71	26	47
3	Eddersheim	21	43	22	43
4	Barockstadt	22	55	23	42
5	Ginsheim	21	56	41	37
6	Rot-Weiß	22	53	38	37
7	Hessen	23	44	38	36
8	Rot-Weiß	23	42	42	33
9	Waldgirmes	23	40	44	32
10	Viktoria	22	35	53	32
11	Baunatal	23	32	34	30
12	Türkgücü	21	34	37	30
13	FC Hanau 93	23	30	48	26
14	Dietkirchen	22	29	44	23
15	Bad Vilbel	20	29	41	20
16	Steinbach	20	21	51	16
17	Neuhof	21	24	57	13
18	Fernwald	23	35	61	11

TEMPORADA 2018/2019

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	FC Giessen	35	124	26	88
2	Hessen	35	78	33	79
3	Bayern	36	97	45	78
4	Rot-Weiß	35	86	62	60
5	Barockstadt	35	75	54	58
6	Baunatal	36	59	61	57
7	Ginsheim	36	81	82	56
8	Waldgirmes	36	61	57	54
9	Eddersheim	35	60	67	49
10	Bad Vilbel	35	48	52	43
11	Lohfelden	35	52	61	41
12	Viktoria	35	49	79	39
13	Türkgücü	36	62	86	37
14	Buchonia	34	51	65	35
15	Hünfelder	35	35	76	33
16	Ederbergland	35	42	105	24
17	Neu-Isenburg	34	43	92	21

TEMPORADA 2017/2018

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hessen	32	88	29	72
2	Bayern	32	89	39	66
3	Lehnerz	32	82	41	66
4	FC Giessen	32	96	37	63
5	Waldgirmes	32	58	42	57
6	Rot-Weiß	32	79	50	52
7	Borussia	32	63	38	52
8	Ginsheim	32	53	51	46
9	Baunatal	32	59	52	44
10	Lohfelden	32	52	55	44
11	Neu-Isenburg	32	41	56	39
12	Buchonia	32	48	71	37
13	Ederbergland	32	37	73	34
14	Viktoria	32	45	89	27
15	Rot-Weiß	32	46	85	26
16	Vellmar	32	41	95	23
17	Steinbach	32	39	113	15

TEMPORADA 2016/2017

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Hessen	32	89	34	70
2	Eintracht	32	83	46	69
3	Rot-Weiß	32	90	45	66
4	Bayern	32	87	49	64
5	Borussia	32	66	35	58
6	Rot-Weiß	32	63	48	54
7	Lehnerz	32	59	54	49
8	Seligenstadt	32	57	45	44
9	Baunatal	32	60	53	41
10	Lohfelden	32	49	52	41
11	Vellmar	32	49	70	41
12	Viktoria	32	40	60	38
13	Ederbergland	32	52	76	38
14	Steinbach	32	62	94	36
15	Rot-Weiß	32	41	87	23
16	Viktoria	32	39	77	22
17	Viktoria	32	24	85	11

TEMPORADA 2015/2016

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FC Giessen	32	81	40	68
2	Rot-Weiß	32	81	45	64
3	Lehnerz	32	59	38	57
4	Lohfelden	32	62	49	57
5	Eintracht	32	63	55	54
6	Eschborn	32	55	54	49
7	Wiesbaden	32	57	46	48
8	Viktoria	32	49	55	42
9	Seligenstadt	32	50	57	42
10	Rot-Weiß	32	50	62	41
11	Baunatal	32	63	64	39
12	Borussia	32	36	51	39
13	Hessen	32	54	60	38
14	Vellmar	32	54	69	35
15	Bayern	32	43	60	34
16	Oberrad	32	36	58	31
17	Buchonia	32	42	72	27

TEMPORADA 2014/2015

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kickers	34	55	22	79
2	Saarbrücken	34	51	27	69
3	Elversberg	34	60	28	65
4	Kaiserslaute	34	57	28	61
5	Wormatia	34	59	44	58
6	Homburg	34	48	31	57
7	Freiburg II	34	66	46	53
8	Astoria	34	51	40	53
9	Hoffenheim	34	44	46	51
10	Hessen	34	43	35	47
11	Eintracht	34	31	33	44
12	SpVgg	34	47	55	44
13	Waldhof	34	36	33	43
14	Pirmasens	34	40	44	42
15	Nottingen	34	50	67	37
16	Koblenz	34	24	58	25
17	Baunatal	34	22	82	16
18	Zweibrücken	34	17	82	15

TEMPORADA 2013/2014

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sonnenhof	34	71	37	75
2	Freiburg II	34	69	37	67
3	Mainz 05 II	34	63	34	67
4	Kaiserslaute	34	66	31	63
5	Waldhof	34	48	40	53
6	Eintracht	34	49	37	51
7	Zweibrücken	34	45	39	51
8	Kickers	34	39	31	50
9	SpVgg	34	42	47	48
10	Hoffenheim	34	52	45	45
11	Homburg	34	50	47	44
12	Eintracht	34	52	55	42
13	Hessen	34	41	64	40
14	Koblenz	34	36	46	39
15	Ulm	34	39	56	32
16	Wormatia	34	36	62	30
17	Baunatal	34	33	71	25
18	Pfullendorf	34	29	81	19

TEMPORADA 2012/2013

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Baunatal	34	69	43	65
2	Jügesheim	34	49	22	64
3	Buchonia	34	69	54	60
4	Rot-Weiß	34	69	45	58
5	Wehen	34	64	51	58
6	Lohfelden	34	58	47	56
7	Fernwald	34	79	42	53
8	Hünfelder	34	63	51	51
9	Eintracht	34	53	50	50
10	Viktoria	34	58	57	50
11	Vellmar	34	70	60	49
12	Rot-Weiß	34	63	63	49
13	Kickers	34	51	49	45
14	Viktoria	34	55	73	39
15	Waldgirmes	34	56	64	37
16	Braunfels	34	32	71	33
17	Eddersheim	34	46	91	25
18	Darmstadt	34	26	97	23

TEMPORADA 2011/2012

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Eschborn	34	77	35	77
2	Baunatal	34	82	48	70
3	Fernwald	34	58	30	64
4	Viktoria	34	67	55	56
5	Viktoria	34	67	45	54
6	Wehen	34	61	55	51
7	Vellmar	34	60	63	51
8	Rot-Weiß	34	65	59	49
9	Lohfelden	34	68	63	48
10	Jügesheim	34	47	41	47
11	Buchonia	34	64	69	47
12	Kickers	34	66	63	45
13	Rot-Weiß	34	49	62	38
14	Waldgirmes	34	54	72	38
15	Eintracht	34	49	68	37
16	Darmstadt	34	50	65	32
17	Rot-Weiß	34	37	86	30
18	Eintracht	34	44	86	24

TEMPORADA 2010/2011

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Bayern	34	76	36	66
2	Waldgirmes	34	76	56	58
3	Baunatal	34	75	56	58
4	Eschborn	34	78	58	57
5	Vellmar	34	76	65	55
6	Kickers	34	71	60	54
7	Viktoria	34	60	51	53
8	Eintracht	34	65	65	53
9	Fernwald	34	53	49	50
10	Darmstadt	34	51	49	47
11	Eintracht	34	55	58	47
12	Rot-Weiß	34	51	47	45
13	Buchonia	34	70	71	45
14	Rot-Weiß	34	56	62	42
15	Würges	34	44	58	42
16	Hünfelder	34	44	61	32
17	Schwalmstadt	34	36	76	31
18	Marburg	34	31	90	21

TEMPORADA 2009/2010

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Frankfurt	36	95	34	80
2	Waldgirmes	36	81	56	67
3	Baunatal	36	78	50	66
4	Eintracht	36	58	44	58
5	Rot-Weiß	36	67	53	57
6	Eschborn	36	78	65	56
7	Hünfelder	36	58	47	56
8	Viktoria	36	55	49	55
9	Kickers	36	69	66	55
10	Würges	36	63	49	54
11	Viktoria	36	67	63	52
12	Marburg	36	65	68	49
13	Fernwald	36	61	65	46
14	Schwalmstadt	36	58	70	41
15	Vellmar	36	55	76	40
16	Klein-Karben	36	67	81	39
17	Germania	36	50	72	36
18	Wörsdorf	36	47	84	27
19	Hersfeld	36	47	127	16

TEMPORADA 2008/2009

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Waldgirmes	36	85	45	75
2	Bayern	36	75	46	69
3	Viktoria	36	76	50	63
4	Kickers	36	68	52	57
5	Baunatal	36	77	62	54
6	Eschborn	36	58	45	54
7	Klein-Karben	36	64	60	51
8	Eintracht	36	56	52	51
9	Vellmar	36	53	58	51
10	Hünfelder	36	66	61	49
11	Rot-Weiß	36	57	58	49
12	Fernwald	36	53	49	46
13	Würges	36	49	45	46
14	Wörsdorf	36	37	35	46
15	Germania	36	47	51	43
16	Buchonia	36	54	80	39
17	Borussia	36	39	60	35
18	Hessen	36	39	85	33
19	Lohfelden	36	31	90	24

TEMPORADA 2007/2008

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Darmstadt	34	73	37	69
2	Wehen	34	71	37	64
3	Viktoria	34	50	27	61
4	Eintracht	34	74	43	58
5	Waldgirmes	34	56	55	56
6	Wörsdorf	34	56	47	52
7	Bayern	34	54	50	50
8	Baunatal	34	55	46	49
9	Lohfelden	34	52	58	45
10	Borussia	34	53	50	44
11	Fernwald	34	50	55	42
12	Germania	34	40	52	41
13	Klein-Karben	34	56	64	40
14	Würges	34	36	55	39
15	Rot-Weiß	34	47	59	38
16	Buchonia	34	41	56	37
17	Eintracht	34	30	55	31
18	Schwalmstadt	34	37	85	25

TEMPORADA 2006/2007

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Frankfurt	34	80	19	85
2	Viktoria	34	59	34	63
3	Waldgirmes	34	65	42	63
4	Klein-Karben	34	66	44	58
5	Eintracht	34	66	46	54
6	Bayern	34	55	44	53
7	Fernwald	34	57	49	53
8	Borussia	34	39	31	51
9	Buchonia	34	49	49	50
10	Wörsdorf	34	44	47	45
11	Würges	34	46	52	44
12	Schwalmstadt	34	44	60	42
13	Baunatal	34	48	47	41
14	Bernbach	34	45	73	37
15	Bad Vilbel	34	47	72	36
16	Eschborn	34	40	54	35
17	Vellmar	34	30	59	30
18	Braunfels	34	30	88	21

TEMPORADA 2005/2006

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Hessen	34	75	25	75
2	Frankfurt	34	73	26	75
3	Waldgirmes	34	61	39	62
4	Buchonia	34	49	40	55
5	Bayern	34	48	47	53
6	Bad Vilbel	34	57	51	52
7	Vellmar	34	57	56	49
8	Wörsdorf	34	46	39	48
9	Klein-Karben	34	49	46	48
10	Viktoria	34	48	54	43
11	Eintracht	34	47	41	42
12	Erzhausen	34	47	56	42
13	Schwalmstadt	34	52	62	41
14	Baunatal	34	38	48	41
15	Fernwald	34	37	47	41
16	Bruchkobel	34	46	60	41
17	Germania	34	38	68	32
18	Wattenbach	34	27	90	13

Competiciones que juega

Grupo 11

Oberliga Grupo 11

Pos	Equipos		Pts
1		Türkgücü Friedberg	62
2		FC Giessen	61
3		Bayern Alzenau	56
4		KSV Baunatal	55
5		Eddersheim	49
6		Hanauer SC 1960	48
7		Hünfelder SV	45
8		Fernwald	43
9		Adler Weidenhausen	40
10		Rot-Weiß Walldorf	39
11		Waldgirmes	36
12		Eintracht Stadtallendorf	34
13		Marburg	33
14		FC Hanau 93	30
15		FC Erlensee	26
16		SV Steinbach 1920	23
17		Viktoria Griesheim	23
18		Dietkirchen	21

	Ascenso : Türkgücü Friedberg
	Descenso : FC Erlensee, SV Steinbach 1920, Viktoria Griesheim, Dietkirchen

RIVALES EN Oberliga

USO DE MEMORIA

7,680,800 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6215
Total Execution Time	0.6228

CADENA URL

/historico/Baunatal

GET DATOS

$_GET['/historico/Baunatal']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0141	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 = 'Baunatal' 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.0107	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=11807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=11807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=11807 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0216	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 = 72701
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11807 AND type_rel = 2
0.0122	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 = '11807' ORDER BY l.year DESC,cat.coefficient DESC
0.0116	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 = '11807' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0114	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 = '11807' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0112	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 = 72701 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152	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=11807 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0116	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 (72701,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.0138	SELECT count(id) as num_players from rel_players WHERE league_id = 72701 AND teamId = 11807
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 11807
0.0115	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 = 72701 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0112	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 = '11807' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11807' and rp.type = 4
0.0110	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 = '11807' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128	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 = 72701 WHERE rp.league_id = 72701 AND rp.teamId = 11807 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.0116	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 = 72701 WHERE rp.league_id = 72701 AND rp.teamId = 11807 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114	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 = 72701 WHERE rp.league_id = 72701 AND rp.teamId = 11807 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111	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 = 11807 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111	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 = 72701 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.0115	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 = 68314 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.0112	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 = 63907 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.0110	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 = 66896 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 58332 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 50466 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 44342 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 38844 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 33441 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125	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 = 15535 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119	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 = 3903 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 2505 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 19809 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 19823 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 19834 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 19843 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118	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 = 19855 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 19868 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 19877 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 19887 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

KSV Baunatal

KSV Baunatal

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 11

RIVALES EN Oberliga