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

Seligenporten

Temporada 2022/2023

TEMPORADA 2021/2022

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Vilzing	34	89	26	81
2	SpVgg	34	89	32	81
3	ATSV	34	77	40	72
4	Eintracht	34	82	35	68
5	Neumarkt	34	70	51	61
6	DJK Bamberg	34	68	59	56
7	Gebenbach	34	74	63	52
8	Ammerthal	34	69	71	52
9	Abtswind	34	49	54	51
10	Feucht SC	34	57	46	50
11	Grossbardorf	34	56	60	44
12	Bayern Hof	34	55	69	39
13	ASV Cham	34	46	76	32
14	Würzburger	34	44	70	31
15	Vatanspor	34	36	71	31
16	Karlburg	34	24	55	30
17	Seligenporte	34	40	96	21
18	1. FC Sand	34	30	81	20

TEMPORADA 2019/2020

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Vilzing	21	57	19	50
2	Eltersdorf	21	60	22	48
3	Seligenporte	20	46	15	47
4	Grossbardorf	21	48	37	36
5	Ammerthal	20	40	31	35
6	Eintracht	20	40	40	32
7	ATSV	21	37	36	31
8	Würzburger	22	44	40	31
9	ASV Cham	20	26	31	27
10	SpVgg	20	47	43	27
11	Gebenbach	20	34	39	25
12	Bayern Hof	20	27	40	23
13	DJK Bamberg	22	24	38	22
14	Abtswind	22	27	46	21
15	1. FC Sand	21	27	35	18
16	Karlburg	22	19	54	13
17	Viktoria	19	19	56	9

TEMPORADA 2018/2019

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Aubstadt	34	83	27	76
2	Gebenbach	34	83	42	73
3	Würzburger	34	67	39	66
4	Grossbardorf	34	67	39	65
5	Seligenporte	34	69	50	62
6	Eltersdorf	34	56	45	53
7	Bayern Hof	34	54	45	49
8	DJK Bamberg	34	44	39	48
9	Würzburger	34	60	69	48
10	Abtswind	34	59	67	45
11	SpVgg	34	68	77	43
12	Ammerthal	34	51	52	39
13	ATSV	34	43	60	39
14	1. FC Sand	34	42	66	35
15	ASV Vach	34	45	76	33
16	Erlangen-Bru	34	53	74	31
17	Jahn	34	58	86	30
18	Neumarkt	34	35	84	28

TEMPORADA 2017/2018

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	1860	36	87	27	83
2	Bayern	36	84	41	74
3	Schweinfurt	36	79	52	68
4	Garching	36	67	67	56
5	Nürnberg	36	70	61	55
6	Ingolstadt	36	68	57	53
7	Eichstätt	36	55	56	52
8	Augsburg	36	55	44	50
9	Wacker	36	53	49	50
10	Illertissen	36	50	50	49
11	Schalding-He	36	59	72	49
12	Buchbach	36	50	56	46
13	Greuther	36	45	51	46
14	Pipinsried	36	43	63	44
15	Rosenheim	36	43	55	41
16	Memmingen	36	47	58	39
17	Bayreuth	36	53	79	38
18	Seligenporte	36	39	58	36
19	Unterföhrin	36	36	87	20

TEMPORADA 2016/2017

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Unterhaching	34	95	23	83
2	1860	34	45	35	63
3	Bayern	34	62	40	58
4	Augsburg	34	71	36	57
5	Memmingen	34	62	48	52
6	Illertissen	34	46	46	51
7	Nürnberg	34	72	67	49
8	Ingolstadt	34	59	51	48
9	Schweinfurt	34	57	61	48
10	Rosenheim	34	47	51	48
11	Wacker	34	46	54	47
12	Garching	34	56	64	46
13	Bayreuth	34	49	59	42
14	Buchbach	34	43	62	41
15	Schalding-He	34	57	64	40
16	Greuther	34	39	58	31
17	Seligenporte	34	41	76	29
18	Bayern Hof	34	35	87	12

TEMPORADA 2015/2016

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Seligenporte	34	72	42	69
2	Eichstätt	34	70	44	68
3	Weiden	34	64	26	67
4	Grossbardorf	34	57	23	67
5	Bayern Hof	34	68	40	67
6	Alemannia	34	58	49	58
7	Eltersdorf	34	55	55	48
8	Aubstadt	34	48	49	47
9	1. FC Sand	34	50	57	46
10	Feucht SC	34	57	61	40
11	DJK Bamberg	34	55	75	39
12	Jahn	34	47	49	38
13	Würzburger	34	43	55	38
14	Erlenbach	34	39	51	35
15	Burglengenfe	34	32	51	33
16	Jahn	34	38	74	31
17	Frohnlach	34	41	66	30
18	Eintracht	34	52	79	29

TEMPORADA 2014/2015

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Würzburger	34	67	15	80
2	Bayern	34	60	28	72
3	1860	34	60	34	63
4	Buchbach	34	45	41	52
5	Ingolstadt	34	47	39	50
6	Bayreuth	34	48	47	50
7	Memmingen	34	45	51	47
8	Nürnberg	34	39	39	46
9	Illertissen	34	56	55	45
10	Augsburg	34	41	47	45
11	Wacker	34	36	43	42
12	Schweinfurt	34	46	53	40
13	Schalding-He	34	43	52	40
14	Greuther	34	47	50	38
15	Heimstetten	34	40	58	34
16	Garching	34	42	64	33
17	Seligenporte	34	34	61	28
18	Eintracht	34	38	57	26

TEMPORADA 2013/2014

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Bayern	36	94	33	79
2	Illertissen	36	79	33	75
3	1860	36	68	41	72
4	Augsburg	36	63	34	69
5	Buchbach	36	63	55	61
6	Ingolstadt	36	65	50	57
7	Seligenporte	36	55	60	54
8	Nürnberg	36	57	46	53
9	Greuther	36	68	57	52
10	Eintracht	36	63	65	51
11	Würzburger	36	61	55	49
12	Schalding-He	36	52	71	42
13	Memmingen	36	51	56	41
14	Heimstetten	36	50	82	38
15	Rosenheim	36	45	59	37
16	Schweinfurt	36	46	71	36
17	Bayern Hof	36	42	68	36
18	Viktoria	36	45	86	23
19	Rain / Lech	36	45	90	20

TEMPORADA 2012/2013

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	1860	38	69	35	80
2	Bayern	38	71	31	73
3	Illertissen	38	74	44	72
4	Nürnberg	38	64	40	65
5	Heimstetten	38	61	53	61
6	Buchbach	38	73	57	60
7	Rosenheim	38	43	44	58
8	Ingolstadt	38	69	57	55
9	Memmingen	38	45	39	55
10	Würzburger	38	63	76	52
11	Rain / Lech	38	51	59	49
12	Greuther	38	49	56	48
13	Eintracht	38	48	64	47
14	Seligenporte	38	53	72	45
15	Viktoria	38	45	71	42
16	Augsburg	38	57	66	41
17	Bayern Hof	38	39	56	40
18	Eltersdorf	38	50	70	39
19	Ismaning	38	38	48	36
20	Frohnlach	38	40	64	35

TEMPORADA 2011/2012

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rosenheim	34	72	34	70
2	Bayern Hof	34	55	27	64
3	Eltersdorf	34	70	50	58
4	Buchbach	34	65	49	56
5	Rain / Lech	34	50	44	55
6	Seligenporte	34	51	44	52
7	Frohnlach	34	62	46	51
8	Eintracht	34	62	57	51
9	Ismaning	34	52	47	47
10	Grossbardorf	34	49	65	46
11	Erlangen-Bru	34	37	49	44
12	Würzburger	34	55	66	43
13	Schweinfurt	34	58	70	41
14	Rosenheim	34	53	59	39
15	Heimstetten	34	56	67	38
16	Aindling	34	41	58	32
17	Gersthofen	34	49	82	27
18	Unterhaching	34	35	58	26

TEMPORADA 2010/2011

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ismaning	34	72	48	66
2	Ingolstadt	34	75	48	63
3	Rosenheim	34	58	39	53
4	Buchbach	34	58	51	53
5	Würzburger	34	57	52	52
6	Seligenporte	34	59	56	52
7	Unterhaching	34	53	44	51
8	Eintracht	34	54	61	51
9	Schweinfurt	34	48	50	50
10	Grossbardorf	34	53	54	45
11	Erlangen-Bru	34	59	70	45
12	Rain / Lech	34	52	47	44
13	Aindling	34	40	39	43
14	Heimstetten	34	53	53	43
15	Bayern Hof	34	50	56	41
16	Bayreuth	34	45	63	41
17	Schalding-He	34	47	66	32
18	Freier TuS	34	38	74	23

TEMPORADA 2009/2010

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Memmingen	36	57	23	74
2	Ismaning	36	70	47	63
3	Unterhaching	36	65	48	62
4	Aindling	36	60	46	59
5	Rain / Lech	36	54	45	59
6	Ingolstadt	36	61	53	58
7	Seligenporte	36	61	53	58
8	Erlangen-Bru	36	56	43	56
9	Bayreuth	36	44	34	54
10	Bayern Hof	36	45	44	52
11	Buchbach	36	71	62	49
12	Rosenheim	36	53	47	49
13	Schalding-He	36	46	65	47
14	Grossbardorf	36	49	50	44
15	SpVgg	36	42	57	42
16	Frohnlach	36	43	59	40
17	Memmelsdorf	36	36	74	29
18	Thannhausen	36	43	77	28
19	Kötzting	36	43	72	24

TEMPORADA 2008/2009

OBERLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Weiden	34	66	29	74
2	Aindling	34	69	27	65
3	Memmingen	34	48	34	59
4	Bayreuth	34	48	38	55
5	Erlangen-Bru	34	60	44	53
6	Ingolstadt	34	50	42	52
7	Frohnlach	34	64	56	45
8	Buchbach	34	47	44	45
9	Thannhausen	34	53	55	43
10	Bayern Hof	34	41	45	42
11	Ismaning	34	61	60	41
12	SpVgg	34	37	49	40
13	Kötzting	34	42	65	39
14	Würzburger	34	45	52	38
15	Seligenporte	34	41	55	38
16	Rain / Lech	34	47	67	38
17	Schweinfurt	34	39	66	36
18	Würzburger	34	52	82	30

Competiciones que juega

RIVALES EN Landesliga

USO DE MEMORIA

6,574,360 bytes

BENCHMARKS

Loading Time Base Classes	0.0016
Controller Execution Time ( Home / Category )	0.9053
Total Execution Time	0.9070

CADENA URL

/historico/Seligenporten

GET DATOS

$_GET['/historico/Seligenporten']

POST DATOS

No hay datos POST existentes

CONSULTAS (62)

0.0133	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 = 'Seligenporten' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0146	SELECT 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 = 'Seligenporten' 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.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=9738 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132	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 = 72008
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9738 AND type_rel = 2
0.0130	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 = '9738' ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '9738' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0133	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 = '9738' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	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 = '9738' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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 = 72008 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	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=9738 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (72008,67320,63157) 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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 63157 AND teamId = 9738
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 72008 AND teamId = 9738
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 9738
0.0126	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72008 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126	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 = '9738' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9738' and rp.type = 4
0.0128	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 = '9738' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127	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 events2023 e ON e.player_id = p.id AND e.league_id = 72008 WHERE rp.league_id = 72008 AND rp.teamId = 9738 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.0126	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 events2023 e ON e.player_id = p.id AND e.league_id = 72008 WHERE rp.league_id = 72008 AND rp.teamId = 9738 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126	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 events2023 e ON e.player_id = p.id AND e.league_id = 72008 WHERE rp.league_id = 72008 AND rp.teamId = 9738 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 9738 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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 = 63157 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.0129	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 = 50122 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.0130	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 = 44075 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 38887 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 33371 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 15533 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 3904 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 2508 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 2008 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 19820 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 19831 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 19842 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 19854 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 72008 ORDER BY nameShow LIMIT 100
0.0127	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 2090 AND l.group_code = 8 ORDER BY l.year DESC

Seligenporten

Seligenporten

Selecciona un equipo

Competiciones que juega

RIVALES EN Landesliga