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

TSV Schwaben Augsburg

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schwaben	31	71	32	61
2	Landsberg	31	78	47	60
3	SV Erlbach	31	44	25	60
4	Heimstetten	31	54	34	59
5	Deisenhofen	31	60	31	56
6	Nördlingen	31	59	42	55
7	1860	31	56	45	49
8	Kottern	31	57	48	46
9	Kirchanschö	31	36	43	43
10	Pipinsried	30	36	33	40
11	Sonthofen	30	45	44	40
12	Rain / Lech	30	37	49	38
13	Dachau	31	50	63	37
14	Ismaning	31	39	62	36
15	Gundelfingen	31	35	51	32
16	Türkspor	31	27	42	29
17	Garching	31	30	74	21
18	Kirchheimer	30	37	86	13

TEMPORADA 2022/2023

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schalding-He	34	73	36	73
2	Memmingen	34	51	36	63
3	Landsberg	34	70	45	60
4	Ingolstadt	34	64	39	60
5	Kottern	34	57	44	60
6	Kirchanschö	34	56	45	58
7	Schwaben	34	63	52	54
8	1860	34	56	40	53
9	Gundelfingen	34	50	47	50
10	Ismaning	34	47	52	50
11	Nördlingen	34	66	64	46
12	Deisenhofen	34	56	47	44
13	SV Erlbach	34	42	36	42
14	Dachau	34	45	61	40
15	Garching	34	35	56	34
16	Türkspor	34	38	79	23
17	Rosenheim	34	37	83	21
18	Hallbergmoos	34	35	79	15

TEMPORADA 2021/2022

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hankofen-Hai	36	63	36	72
2	Donaustauf	36	80	56	66
3	Ingolstadt	36	70	40	65
4	Jahn	36	66	44	64
5	Kirchanschö	36	51	42	62
6	1860	36	55	42	51
7	Schwaben	36	47	42	51
8	Ismaning	36	45	41	51
9	Landsberg	36	55	41	50
10	Deisenhofen	36	63	50	49
11	Garching	36	46	55	45
12	Gundelfingen	36	41	47	44
13	Kottern	36	47	52	44
14	Türkspor	36	47	55	42
15	Hallbergmoos	36	43	66	39
16	Pullach	36	49	65	38
17	Dachau	36	42	66	38
18	Wasserburg	36	39	58	35
19	Schwabmünch	36	27	78	18

TEMPORADA 2019/2020

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pipinsried	23	81	20	63
2	Wasserburg	23	40	29	42
3	Deisenhofen	22	51	37	41
4	Ingolstadt	23	58	42	39
5	Schwabmünch	23	49	36	39
6	Kottern	22	39	31	38
7	1860	23	40	38	33
8	Kirchanschö	23	31	36	31
9	Ismaning	23	41	35	30
10	Dachau	23	30	45	27
11	Donaustauf	21	30	39	26
12	Türkspor	22	37	40	25
13	Landsberg	23	35	42	25
14	Hankofen-Hai	22	27	34	24
15	Jahn	23	42	55	24
16	Pullach	23	33	57	23
17	Schwaben	23	26	48	20
18	Nördlingen	23	25	51	14

TEMPORADA 2018/2019

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Türkgücü	32	59	30	68
2	Rain / Lech	32	60	42	58
3	Jahn	32	69	48	53
4	Pullach	32	52	48	53
5	Vilzing	32	47	36	51
6	Dachau	32	47	45	49
7	Kottern	32	46	47	46
8	1860	32	58	48	45
9	Schwabmünch	32	57	52	45
10	Nördlingen	32	53	55	45
11	Kirchanschö	32	51	47	44
12	Schwaben	32	41	44	43
13	Hankofen-Hai	32	47	50	39
14	Sonthofen	32	54	64	38
15	Ismaning	32	45	51	37
16	Unterföhrin	32	41	59	28
17	Holzkirchen	32	30	91	9

TEMPORADA 2017/2018

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Heimstetten	36	93	51	72
2	Pullach	36	75	48	65
3	Rain / Lech	36	70	44	62
4	Kottern	36	59	48	60
5	Schwaben	36	64	50	54
6	Schwabmünch	36	52	52	53
7	Vilzing	36	65	54	52
8	Neumarkt	36	51	48	50
9	Dachau	36	64	52	49
10	Sonthofen	36	59	50	49
11	Ismaning	36	70	70	47
12	Holzkirchen	36	57	69	47
13	Hankofen-Hai	36	53	66	46
14	1860	36	47	47	43
15	Chiemgau	36	49	63	41
16	Kirchanschö	36	44	51	40
17	Landsberg	36	52	72	39
18	Wolfratshaus	36	57	85	39
19	Kornburg	36	36	97	28

TEMPORADA 2016/2017

LANDESLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Schwaben	32	58	20	68
2	Türkspor	32	68	43	61
3	Illertissen	32	74	44	57
4	SV Egg	32	58	43	56
5	Ichenhausen	32	44	31	56
6	Nördlingen	32	57	50	49
7	SC Olching	32	51	44	48
8	Aindling	32	54	48	47
9	Memmingen	32	49	46	44
10	SV Mering	32	51	54	42
11	Kaufbeuren	32	40	45	39
12	Stätzling	32	50	58	39
13	Raisting	32	44	52	38
14	Gilching-Arg	32	48	61	38
15	Oberweikerts	32	32	52	26
16	Ehekirchen	32	35	77	20
17	Kissinger	32	24	69	16

TEMPORADA 2002/2003

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Feucht SC	34	107	37	84
2	1860	34	83	35	71
3	Ismaning	34	77	42	66
4	Bayreuth	34	55	46	62
5	Fürstenfeld	34	62	43	60
6	Nürnberg	34	70	51	59
7	Aindling	34	58	59	53
8	Unterhaching	34	56	56	50
9	Greuther	34	66	69	48
10	Weiden	34	43	52	42
11	Jahn	34	58	63	41
12	Bayern Hof	34	52	69	41
13	SpVgg	34	54	57	40
14	Schwabach	34	43	58	36
15	Quelle Furth	34	49	67	35
16	Schwaben	34	36	67	35
17	FC Falke	34	37	81	24
18	Gerbrunn	34	32	86	18

TEMPORADA 2000/2001

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	SpVgg	38	81	48	81
2	Nürnberg	38	84	44	78
3	Weiden	38	70	46	66
4	FC Augsburg	38	74	51	65
5	Feucht SC	38	64	48	64
6	Ingolstadt	38	65	46	61
7	Aindling	38	80	57	60
8	Ismaning	38	57	42	59
9	Quelle Furth	38	64	54	54
10	Memmingen	38	54	60	54
11	1. FC Sand	38	56	45	53
12	Schwabach	38	63	55	52
13	Würzburger	38	62	59	51
14	Bayern Hof	38	55	57	51
15	Neumarkt	38	53	56	50
16	Kempten	38	51	66	49
17	Schwaben	38	46	70	40
18	SV Lohhof	38	40	112	25
19	Starnberg	38	43	82	22
20	SpVgg	38	33	97	19

TEMPORADA 1999/2000

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Jahn	34	85	38	74
2	SpVgg	34	80	48	63
3	Feucht SC	34	60	37	63
4	Bayern Hof	34	70	32	60
5	Nürnberg	34	60	44	53
6	Weiden	34	45	35	51
7	Aindling	34	50	47	51
8	Jahn	34	56	60	48
9	Schwabach	34	46	41	45
10	SpVgg	34	58	57	44
11	Starnberg	34	49	50	43
12	Memmingen	34	50	52	43
13	Würzburger	34	65	75	43
14	Schwaben	34	48	74	42
15	Kempten	34	34	66	39
16	Landshut	34	56	55	38
17	SC Weismain	34	42	70	32
18	Passau	34	28	101	15

TEMPORADA 1998/1999

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	SV Lohhof	34	59	27	65
2	Quelle Furth	34	79	38	63
3	Schwabach	34	58	38	61
4	SpVgg	34	76	52	58
5	Weiden	34	48	34	58
6	Jahn	34	59	38	57
7	Nürnberg	34	59	44	54
8	Memmingen	34	64	48	52
9	Feucht SC	34	65	66	47
10	Landshut	34	48	51	47
11	Aindling	34	49	57	44
12	Starnberg	34	46	66	39
13	Passau	34	39	54	38
14	Bayern Hof	34	39	56	35
15	Schwaben	34	47	68	35
16	Post	34	45	63	34
17	Bayreuth	34	41	78	28
18	Frohnlach	34	30	73	20

TEMPORADA 1968/1969

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Karlsruher	34	73	43	61
2	Freiburger	34	67	42	61
3	Bayern Hof	34	53	30	59
4	Stuttgarter	34	66	43	57
5	Jahn	34	54	38	51
6	Greuther	34	37	36	49
7	Schweinfurt	34	67	53	48
8	Darmstadt	34	50	45	48
9	Hessen	34	60	52	47
10	Reutlingen	34	49	58	47
11	Ingolstadt	34	50	60	45
12	Waldhof	34	44	52	44
13	Villingen	34	45	54	44
14	Mannheim	34	51	54	43
15	Opel	34	41	55	43
16	Schwaben	34	44	55	34
17	Neckarau	34	34	65	33
18	Rot-Weiß	34	36	86	26

TEMPORADA 1967/1968

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bayern Hof	34	85	36	77
2	Kickers	34	75	27	74
3	Reutlingen	34	77	39	67
4	Stuttgarter	34	75	51	64
5	Schweinfurt	34	55	48	57
6	Greuther	34	48	39	55
7	Mannheim	34	75	55	53
8	Hessen	34	64	63	52
9	Freiburger	34	57	56	50
10	Villingen	34	41	43	47
11	Opel	34	59	60	43
12	Waldhof	34	55	62	42
13	Schwaben	34	47	54	38
14	Darmstadt	34	45	71	32
15	Jahn	34	37	77	30
16	Frankfurt	34	37	61	25
17	Wehen	34	37	78	22
18	Backnang	34	45	94	22

TEMPORADA 1966/1967

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Bayern Hof	34	81	44	71
2	Kickers	34	65	33	70
3	Greuther	34	80	36	68
4	Stuttgarter	34	85	48	65
5	Mannheim	34	61	43	57
6	Reutlingen	34	59	44	56
7	Freiburger	34	62	50	52
8	Hessen	34	61	62	50
9	Schweinfurt	34	43	47	50
10	Schwaben	34	64	63	47
11	Waldhof	34	50	57	45
12	Opel	34	51	60	40
13	Frankfurt	34	37	58	40
14	Villingen	34	47	76	36
15	Darmstadt	34	45	55	35
16	FC Augsburg	34	49	73	35
17	Germania	34	28	73	21
18	Pforzheim	34	26	72	16

TEMPORADA 1965/1966

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schweinfurt	34	74	39	71
2	Kickers	34	78	48	68
3	Waldhof	34	78	60	57
4	Greuther	34	70	52	54
5	Stuttgarter	34	65	52	51
6	Hessen	34	70	62	49
7	Pforzheim	34	48	46	49
8	Reutlingen	34	60	50	48
9	Opel	34	58	61	47
10	Darmstadt	34	54	71	47
11	Bayern Hof	34	71	63	46
12	Schwaben	34	66	62	46
13	Frankfurt	34	61	76	46
14	Mannheim	34	55	60	43
15	Ingolstadt	34	63	75	41
16	Freiburger	34	55	59	40
17	Weiden	34	51	64	37
18	Pforzheim	34	45	122	15

TEMPORADA 1964/1965

REGIONALLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bayern	36	146	32	79
2	Reutlingen	36	87	45	75
3	Kickers	36	91	63	67
4	Waldhof	36	74	50	65
5	Hessen	36	74	52	57
6	Mannheim	36	66	53	55
7	Greuther	36	72	62	55
8	Stuttgarter	36	69	59	55
9	Bayern Hof	36	65	58	52
10	Frankfurt	36	52	59	51
11	Ingolstadt	36	55	65	47
12	Schweinfurt	36	49	55	46
13	Freiburger	36	60	68	46
14	Pforzheim	36	47	61	46
15	Darmstadt	36	49	66	44
16	Schwaben	36	61	73	41
17	Wacker	36	54	86	37
18	Ulm	36	53	90	33
19	Emmendingen	36	31	158	5

TEMPORADA 1963/1964

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hessen	38	116	61	80
2	Bayern	38	115	61	74
3	Kickers	38	96	66	71
4	Schwaben	38	77	56	68
5	Reutlingen	38	76	61	66
6	Mannheim	38	68	50	63
7	Ulm	38	73	74	62
8	Schweinfurt	38	82	55	60
9	Greuther	38	68	61	53
10	Freiburger	38	58	61	51
11	Waldhof	38	56	60	51
12	Ingolstadt	38	61	81	47
13	Bayern Hof	38	61	64	45
14	Stuttgarter	38	54	74	45
15	Pforzheim	38	51	75	45
16	Frankfurt	38	69	85	44
17	Neu-Isenburg	38	49	80	38
18	FC Augsburg	38	48	90	35
19	Borussia	38	53	77	34
20	Amicitia	38	47	86	30

TEMPORADA 1962/1963

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	1860	30	72	38	63
2	Nürnberg	30	87	41	59
3	Bayern	30	67	52	58
4	Eintracht	30	56	32	53
5	Karlsruher	30	59	48	47
6	Stuttgart	30	49	40	44
7	Kickers	30	57	49	43
8	Ulm	30	64	58	40
9	Greuther	30	49	48	40
10	Hessen	30	49	57	38
11	Schweinfurt	30	43	53	36
12	Mannheim	30	49	62	35
13	Bayern Hof	30	40	62	30
14	Reutlingen	30	48	75	27
15	Schwaben	30	49	73	26
16	FC Augsburg	30	38	88	22

TEMPORADA 1961/1962

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Nürnberg	30	70	30	63
2	Eintracht	30	81	37	62
3	Bayern	30	67	55	57
4	Kickers	30	65	50	53
5	Stuttgart	30	66	53	47
6	Bayern Hof	30	55	56	44
7	1860	30	64	57	41
8	Reutlingen	30	57	51	41
9	Mannheim	30	47	59	37
10	Karlsruher	30	47	44	36
11	FC Augsburg	30	55	63	35
12	Schwaben	30	43	78	33
13	Schweinfurt	30	39	63	31
14	Greuther	30	31	39	30
15	Frankfurt	30	35	65	28
16	Waldhof	30	39	61	26

TEMPORADA 1956/1957

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Nürnberg	30	76	33	68
2	Kickers	30	81	35	60
3	Karlsruher	30	74	41	59
4	Stuttgart	30	69	44	56
5	Eintracht	30	60	42	50
6	Greuther	30	61	57	41
7	Mannheim	30	51	54	41
8	Bayern	30	52	62	38
9	Viktoria	30	44	54	38
10	Jahn	30	46	73	38
11	Frankfurt	30	41	60	35
12	Schweinfurt	30	41	68	33
13	Stuttgarter	30	46	50	31
14	FC Augsburg	30	49	66	31
15	Schwaben	30	35	64	31
16	Freiburger	30	43	66	26

Competiciones que juega

Grupo 2

Oberliga Grupo 2

Pos	Equipos		Pts
1		TSV Schwaben Augsburg	61
2		Landsberg	60
3		SV Erlbach	60
4		Heimstetten	59
5		FC Deisenhofen	56
6		TSV Nördlingen	55
7		1860 München II	49
8		Kottern	46
9		Kirchanschöring	43
10		FC Pipinsried	40
11		Sonthofen	40
12		Rain / Lech	38
13		Dachau	37
14		Ismaning	36
15		FC Gundelfingen	32
16		Türkspor Augsburg	29
17		VfR Garching	21
18		Kirchheimer SC	13

	Ascenso : TSV Schwaben Augsburg
	Playoff Ascenso : Landsberg
	Playoff Descenso : Ismaning, FC Gundelfingen, Türkspor Augsburg, VfR Garching
	Descenso : Kirchheimer SC

RIVALES EN Oberliga

USO DE MEMORIA

7,858,592 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.6463
Total Execution Time	0.6484

CADENA URL

/historico/Schwaben-Augsburg

GET DATOS

$_GET['/historico/Schwaben-Augsburg']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0178	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 = 'Schwaben-Augsburg' 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.0131	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=85414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=85414 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=85414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=85414 AND type_rel = 2
0.0128	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 = '85414' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 72394 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134	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=85414 AND l.year in (2023,2024,2025) 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 (72394,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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 72394 AND teamId = 85414
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 85414
0.0253	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 = 72394 AND t.round = 32 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 = '85414' 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 = '85414' and rp.type = 4
0.0126	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 = '85414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139	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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 85414 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.0135	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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 85414 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 72394 WHERE rp.league_id = 72394 AND rp.teamId = 85414 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 85414 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72394 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.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* `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 = 68055 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.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* `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 = 63158 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.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* `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 = 50138 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.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* `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 = 44076 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* `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 = 38870 AND t.round = 38 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* `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 = 46812 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* `tables2003` 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 = 28301 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* `tables2001` 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 = 28313 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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* `tables2000` 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 = 28328 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* `tables1999` 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 = 28353 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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* `tables1969` 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 = 22844 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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* `tables1968` 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 = 22875 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* `tables1967` 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 = 22860 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* `tables1966` 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 = 22865 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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* `tables1965` 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 = 22897 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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* `tables1964` 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 = 22890 AND t.round = 38 ORDER BY team.conference 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* `tables1963` 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 = 28397 AND t.round = 30 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* `tables1962` 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 = 28401 AND t.round = 30 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* `tables1957` 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 = 28465 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

TSV Schwaben Augsburg

TSV Schwaben Augsburg

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 2

RIVALES EN Oberliga