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

Kickers Offenbach FC

Entrenador: Christian Neidhart

Temporada 2023/2024

TEMPORADA 2023/2024

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Stuttgarter	32	60	32	60
2	Hoffenheim	32	64	26	59
3	Stuttgart	32	73	49	59
4	Eintracht	32	60	43	56
5	Freiberg	32	52	36	56
6	Homburg	32	63	45	52
7	Barockstadt	32	47	40	48
8	Kickers	32	58	43	46
9	Hessen	32	45	46	44
10	Mainz 05 II	32	50	59	44
11	Bahlinger	32	41	46	43
12	Frankfurt	32	42	46	42
13	Steinbach	32	51	60	41
14	Astoria	32	39	52	40
15	VfR Aalen	32	36	54	33
16	Balingen	32	51	74	28
17	Schott Mainz	32	42	76	27
18	TuS Koblenz	32	29	76	18

TEMPORADA 2022/2023

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ulm	34	59	25	72
2	Steinbach	34	80	31	71
3	Hoffenheim	34	80	38	69
4	Homburg	34	65	44	58
5	Frankfurt	34	57	45	57
6	Balingen	34	51	44	56
7	Kickers	34	48	38	55
8	Stuttgart	34	53	39	52
9	Mainz 05 II	34	50	47	48
10	Bahlinger	34	53	67	46
11	Barockstadt	34	47	50	40
12	Astoria	34	43	64	34
13	Hessen	34	34	51	33
14	Freiberg	34	41	68	33
15	VfR Aalen	34	38	52	32
16	Wormatia	34	37	63	29
17	RW Koblenz	34	35	67	27
18	Eintracht	34	32	70	22

TEMPORADA 2021/2022

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Elversberg	36	79	29	80
2	Ulm	36	60	30	77
3	Kickers	36	67	26	76
4	Steinbach	36	62	35	70
5	Mainz 05 II	36	63	42	69
6	Homburg	36	43	48	52
7	Hessen	36	46	37	51
8	Balingen	36	46	64	46
9	Bahlinger	36	35	44	45
10	Astoria	36	49	61	44
11	Stuttgart	36	49	52	43
12	VfR Aalen	36	49	60	43
13	Hoffenheim	36	45	50	41
14	RW Koblenz	36	36	44	39
15	Frankfurt	36	40	53	39
16	Sonnenhof	36	42	64	39
17	Schott Mainz	36	36	58	33
18	Pirmasens	36	32	59	33
19	FC Giessen	36	28	51	29

TEMPORADA 2020/2021

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Freiburg II	42	95	38	93
2	Elversberg	42	98	43	88
3	Kickers	42	80	32	87
4	Ulm	42	75	40	79
5	Steinbach	42	84	47	74
6	Frankfurt	42	58	48	70
7	Homburg	42	73	53	68
8	Stuttgart	42	82	55	65
9	Bahlinger	42	66	75	61
10	RW Koblenz	42	57	61	56
11	FC Giessen	42	52	51	53
12	Hessen	42	57	71	53
13	VfR Aalen	42	49	60	52
14	Pirmasens	42	45	58	52
15	Balingen	42	51	60	51
16	Hoffenheim	42	59	76	50
17	Mainz 05 II	42	58	73	49
18	Astoria	42	64	79	47
19	Sonnenhof	42	52	75	43
20	Schott Mainz	42	55	104	38
21	Bayern	42	47	94	25
22	Eintracht	42	40	104	17

TEMPORADA 2019/2020

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Saarbrücken	23	52	18	55
2	Elversberg	23	48	24	49
3	Steinbach	22	40	18	48
4	Homburg	23	42	30	46
5	Astoria	23	41	31	37
6	Mainz 05 II	23	37	29	37
7	Ulm	22	38	24	35
8	Kickers	22	29	28	32
9	Hoffenheim	22	37	34	29
10	Bayern	22	28	31	28
11	Bahlinger	23	33	38	28
12	Frankfurt	23	26	32	28
13	Freiburg II	23	30	37	28
14	VfR Aalen	22	27	25	26
15	FC Giessen	23	22	39	25
16	Pirmasens	22	19	35	18
17	Balingen	23	24	57	11
18	RW Koblenz	22	12	55	5

TEMPORADA 2018/2019

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Waldhof	34	88	32	85
2	Saarbrücken	34	77	35	67
3	Homburg	34	54	30	64
4	Elversberg	34	61	40	60
5	Kickers	34	61	34	59
6	Ulm	34	50	43	57
7	Freiburg II	34	50	38	55
8	Steinbach	34	46	44	51
9	Pirmasens	34	36	60	43
10	Hoffenheim	34	55	62	41
11	Balingen	34	39	49	41
12	Frankfurt	34	45	58	40
13	Astoria	34	42	53	39
14	Mainz 05 II	34	39	48	33
15	Stuttgart	34	35	56	31
16	Wormatia	34	34	58	31
17	Eintracht	34	37	63	29
18	Hessen	34	29	75	19

TEMPORADA 2017/2018

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Saarbrücken	36	92	32	82
2	Waldhof	36	62	32	71
3	Kickers	36	68	43	66
4	Freiburg II	36	50	32	66
5	Elversberg	36	61	43	56
6	Hoffenheim	36	57	45	56
7	Mainz 05 II	36	52	56	51
8	Steinbach	36	53	48	50
9	Ulm	36	56	54	48
10	Stuttgart	36	52	62	48
11	Astoria	36	58	61	42
12	Eintracht	36	46	63	42
13	Wormatia	36	49	68	42
14	Frankfurt	36	49	66	41
15	TuS Koblenz	36	45	51	39
16	Hessen	36	53	54	38
17	Stuttgarter	36	49	72	36
18	Schott Mainz	36	44	76	32
19	Rochling	36	39	77	27

TEMPORADA 2016/2017

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Elversberg	36	62	22	78
2	Waldhof	36	60	34	76
3	Saarbrücken	36	61	42	69
4	Hoffenheim	36	69	40	57
5	Steinbach	36	52	39	56
6	Wormatia	36	44	37	52
7	Stuttgart	36	58	55	52
8	TuS Koblenz	36	40	39	52
9	Ulm	36	48	46	51
10	Hessen	36	41	49	49
11	Astoria	36	48	56	47
12	Kickers	36	49	39	44
13	Stuttgarter	36	53	51	44
14	Pirmasens	36	38	55	42
15	Homburg	36	41	59	41
16	Kaiserslaute	36	46	59	36
17	FC Giessen	36	42	68	35
18	Eintracht	36	44	58	33
19	Nottingen	36	43	91	28

TEMPORADA 2015/2016

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Waldhof	34	64	19	73
2	Elversberg	34	69	28	72
3	Hoffenheim	34	77	39	66
4	Kickers	34	67	49	64
5	Eintracht	34	62	33	63
6	Homburg	34	59	42	59
7	Saarbrücken	34	48	36	54
8	Hessen	34	42	32	53
9	Wormatia	34	54	54	48
10	Kaiserslaute	34	47	42	43
11	Astoria	34	46	53	42
12	Steinbach	34	36	56	42
13	Pirmasens	34	43	43	39
14	Bahlinger	34	45	58	37
15	Freiburg II	34	50	60	34
16	Spielberg	34	28	70	26
17	SpVgg	34	32	76	26
18	Saar	34	21	100	11

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

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Karlsruher	38	69	27	79
2	Arminia	38	59	32	76
3	Osnabrück	38	64	35	73
4	Preußen	38	63	33	72
5	Heidenheim	38	69	47	72
6	Chemnitzer	38	56	47	55
7	Wehen	38	51	51	51
8	Wacker	38	45	45	51
9	Unterhaching	38	48	55	51
10	Hallescher	38	37	50	46
11	Saarbrücken	38	52	62	45
12	Hansa	38	39	52	44
13	Rot-Weiss	38	44	58	44
14	Stuttgart	38	35	42	43
15	Kickers	38	41	44	42
16	Dortmund	38	39	58	41
17	Stuttgarter	38	39	48	40
18	Darmstadt	38	32	46	38
19	Babelsberg	38	32	54	37
20	Alemannia	38	40	68	26

TEMPORADA 2011/2012

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Sandhausen	38	57	42	66
2	VfR Aalen	38	50	42	64
3	Jahn	38	55	41	61
4	Heidenheim	38	48	36	60
5	Rot-Weiss	38	54	41	59
6	Wacker	38	55	47	57
7	Osnabrück	38	46	35	55
8	Kickers	38	49	41	55
9	Chemnitzer	38	47	43	55
10	Saarbrücken	38	61	51	54
11	Stuttgart	38	44	47	50
12	Preußen	38	40	44	50
13	Arminia	38	51	57	50
14	Darmstadt	38	51	47	49
15	Unterhaching	38	63	59	44
16	Wehen	38	40	48	44
17	Babelsberg	38	44	59	44
18	Carl Zeiss.	38	39	59	39
19	Rot-Weiß	38	33	47	38
20	Werder	38	29	70	22

TEMPORADA 2010/2011

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Eintracht	38	81	22	85
2	Hansa	38	70	36	78
3	Dynamo	38	55	37	65
4	Wehen	38	55	39	64
5	Rot-Weiss	38	63	45	61
6	Saarbrücken	38	61	51	59
7	Kickers	38	52	45	57
8	Jahn	38	35	41	52
9	Heidenheim	38	59	58	51
10	Stuttgart	38	48	48	51
11	TuS Koblenz	38	38	46	49
12	Sandhausen	38	43	46	46
13	Babelsberg	38	39	47	46
14	Unterhaching	38	39	55	45
15	Carl Zeiss.	38	43	62	44
16	Weiss Ahlen	38	45	69	42
17	VfR Aalen	38	40	52	41
18	Wacker	38	46	66	37
19	Werder	38	33	56	36
20	Bayern	38	30	54	30

TEMPORADA 2009/2010

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Osnabrück	38	55	37	69
2	Erzgebirge	38	57	41	68
3	Ingolstadt	38	72	46	64
4	Eintracht	38	55	37	62
5	Carl Zeiss.	38	54	44	60
6	Heidenheim	38	66	56	59
7	Kickers	38	55	35	57
8	Bayern	38	55	65	54
9	Rot-Weiss	38	41	41	53
10	Stuttgart	38	53	50	52
11	Unterhaching	38	52	52	50
12	Dynamo	38	39	46	50
13	Werder	38	49	54	47
14	Sandhausen	38	54	63	47
15	Wehen	38	52	64	47
16	Jahn	38	43	48	46
17	Wacker	38	45	64	46
18	Dortmund	38	43	58	39
19	Holstein	38	43	61	38
20	Wuppertaler	38	40	61	38

TEMPORADA 2008/2009

3. LIGA
Equipo		PJ	GF	GC	Puntos
1	Union Berlin	38	59	23	78
2	Fortuna	38	54	33	69
3	Paderborn	38	68	38	68
4	Unterhaching	38	57	46	67
5	Bayern	38	54	38	59
6	Kickers	38	45	44	59
7	Kickers	38	40	35	52
8	Sandhausen	38	58	52	50
9	Dynamo	38	46	46	50
10	Rot-Weiss	38	46	48	50
11	Stuttgart	38	61	50	49
12	Erzgebirge	38	43	43	48
13	Eintracht	38	46	51	45
14	Wuppertaler	38	36	45	45
15	Jahn	38	37	51	45
16	Carl Zeiss.	38	41	59	41
17	Werder	38	49	58	40
18	Wacker	38	40	65	40
19	VfR Aalen	38	38	60	39
20	Stuttgarter	38	38	71	29

TEMPORADA 2007/2008

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Mönchenglad	34	71	38	66
2	Hoffenheim	34	60	40	60
3	Köln	34	62	44	60
4	Mainz 05	34	62	36	58
5	SC Freiburg	34	49	44	55
6	Greuther	34	53	47	52
7	Alemannia	34	49	44	51
8	TuS Koblenz	34	46	47	47
9	Wehen	34	47	53	44
10	FC St Pauli	34	47	53	42
11	1860	34	42	45	41
12	Osnabrück	34	43	54	40
13	Kaiserslaute	34	37	37	39
14	FC Augsburg	34	39	51	38
15	Kickers	34	38	60	38
16	Erzgebirge	34	49	57	32
17	Paderborn	34	33	54	31
18	Carl Zeiss.	34	45	68	29

TEMPORADA 2006/2007

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Karlsruher	34	69	41	70
2	Hansa	34	49	30	62
3	Duisburg	34	66	40	60
4	SC Freiburg	34	55	39	60
5	Greuther	34	53	40	54
6	Kaiserslaute	34	48	34	53
7	FC Augsburg	34	43	32	52
8	1860	34	47	49	48
9	Köln	34	49	50	46
10	Erzgebirge	34	46	48	45
11	Paderborn	34	32	41	42
12	TuS Koblenz	34	36	45	41
13	Carl Zeiss.	34	40	56	38
14	Kickers	34	42	59	36
15	Rot-Weiss	34	34	40	35
16	Unterhaching	34	33	49	35
17	Wacker	34	42	63	32
18	Eintracht	34	20	48	23

TEMPORADA 2005/2006

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	VfL Bochum	34	55	26	66
2	Alemannia	34	61	36	65
3	Energie	34	49	33	58
4	SC Freiburg	34	41	33	56
5	Greuther	34	51	42	54
6	Karlsruher	34	55	45	53
7	Erzgebirge	34	38	36	48
8	Wacker	34	45	49	47
9	Paderborn	34	46	40	46
10	Hansa	34	44	49	43
11	Kickers	34	42	53	43
12	Eintracht	34	37	48	43
13	1860	34	41	44	42
14	Unterhaching	34	42	48	42
15	Dynamo	34	39	45	41
16	Saarbrücken	34	37	63	38
17	Weiss Ahlen	34	36	50	35
18	Siegen	34	35	54	31

TEMPORADA 2004/2005

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kickers	34	62	36	67
2	Wehen	34	56	37	64
3	Siegen	34	51	30	62
4	FC Augsburg	34	62	36	61
5	Darmstadt	34	50	33	54
6	Bayern	34	51	38	52
7	Hoffenheim	34	57	49	50
8	Jahn	34	47	46	48
9	Stuttgarter	34	48	43	47
10	Elversberg	34	45	55	44
11	TuS Koblenz	34	43	38	43
12	VfR Aalen	34	41	59	43
13	Stuttgart	34	55	57	42
14	Feucht SC	34	42	49	42
15	1860	34	39	44	40
16	Pfullendorf	34	36	64	36
17	Mainz 05 II	34	29	46	33
18	Nottingen	34	29	83	16

Competiciones que juega

Grupo 4

Regionalliga Grupo 4

Pos	Equipos		Pts
1		Stuttgarter Kickers	60
2		Hoffenheim II	59
3		Stuttgart II	59
4		Eintracht Frankfurt II	56
5		Freiberg	56
6		FC 08 Homburg	52
7		Barockstadt	48
8		Kickers Offenbach FC	46
9		Hessen Kassel	44
10		Mainz 05 II	44
11		Bahlinger SC	43
12		FSV Frankfurt	42
13		TSV Steinbach Haiger	41
14		Astoria Walldorf	40
15		VfR Aalen	33
16		TSG Balingen	28
17		Schott Mainz	27
18		TuS Koblenz	18

	Ascenso : Stuttgarter Kickers
	Descenso : TSG Balingen, Schott Mainz, TuS Koblenz

RIVALES EN Regionalliga

USO DE MEMORIA

8,116,944 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1904
Total Execution Time	0.1923

CADENA URL

/historico/Kickers-Offenbach

GET DATOS

$_GET['/historico/Kickers-Offenbach']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0044	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 = 'Kickers-Offenbach' 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=1458 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=1458 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=1458 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1458 AND type_rel = 2
0.0064	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 = '1458' ORDER BY l.year DESC,cat.coefficient DESC
0.0059	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 = '1458' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0051	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 = '1458' 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 = 72592 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0043	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=1458 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 (72592,71432,67716) 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.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 72592 AND teamId = 1458
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 67716 AND teamId = 1458
0.0035	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1458
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 = 72592 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '1458' 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 = '1458' 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 = '1458' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0062	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 = 72592 WHERE rp.league_id = 72592 AND rp.teamId = 1458 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.0051	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 = 72592 WHERE rp.league_id = 72592 AND rp.teamId = 1458 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038	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 = 72592 WHERE rp.league_id = 72592 AND rp.teamId = 1458 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041	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 = 1458 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72592 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.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* `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 = 68047 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.0031	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 = 63290 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.0041	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 = 57336 AND t.round = 42 ORDER BY team.conference ASC,t.position 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* `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 = 50105 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.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* `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 = 43943 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* `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 = 38891 AND t.round = 38 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* `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 = 33768 AND t.round = 38 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* `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 = 15531 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* `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.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 = 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.0038	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 = 2004 AND t.round = 38 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* `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 = 1326 AND t.round = 38 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 = 1187 AND t.round = 38 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* `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 = 885 AND t.round = 38 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* `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 = 452 AND t.round = 38 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 = 546 AND t.round = 34 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* `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 = 547 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* `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 = 548 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* `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 = 16453 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Kickers Offenbach FC

Kickers Offenbach FC

Selecciona un equipo

Competiciones que juega

Regionalliga Grupo 4

RIVALES EN Regionalliga