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

SV Straelen

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	SF Baumberg	28	66	27	63
2	Uerdingen	28	50	34	52
3	Schonnebeck	28	61	37	51
4	Germania	28	50	40	48
5	Hilden	29	47	42	48
6	Homberg	28	39	37	40
7	Büderich	27	48	43	39
8	Schwarz-Weis	28	44	39	39
9	Union	29	45	55	37
10	TVD Velbert	28	47	47	35
11	Sonsbeck	29	37	46	35
12	SV Straelen	18	35	18	34
13	Tönis	28	43	49	33
14	Mülheimer	28	41	52	30
15	Kleve	28	30	52	30
16	Union	29	32	54	28
17	Meerbusch	29	44	57	27
18	Hamborn	28	28	58	26

TEMPORADA 2022/2023

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Preußen	34	89	39	79
2	Wuppertaler	34	77	47	66
3	Mönchenglad	34	73	47	66
4	Rödinghause	34	59	35	58
5	Kaan-Marienb	34	59	54	55
6	Fortuna	34	48	43	54
7	Rot-Weiß	34	61	51	53
8	Alemannia	34	50	43	53
9	Schalke	34	65	53	49
10	Düren	34	51	56	48
11	Lippstadt	34	51	56	46
12	Wiedenbrück	34	50	47	41
13	Fortuna	34	50	64	39
14	Köln II	34	45	62	38
15	FC Bocholt	34	49	70	36
16	Weiss Ahlen	34	53	82	29
17	Wattenscheid	34	45	90	27
18	SV Straelen	34	31	67	17

TEMPORADA 2021/2022

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Rot-Weiss	38	84	32	87
2	Preußen	38	73	24	87
3	Wuppertaler	38	68	28	78
4	Rot-Weiß	38	68	35	75
5	Fortuna	38	62	31	74
6	Rödinghause	38	45	35	64
7	Köln II	38	70	49	62
8	Wiedenbrück	38	48	37	55
9	Schalke	38	58	65	47
10	Weiss Ahlen	38	50	67	47
11	Fortuna	38	59	62	46
12	Alemannia	38	43	51	44
13	Mönchenglad	38	42	51	43
14	Lippstadt	38	54	65	43
15	SV Straelen	38	42	64	43
16	Bonner SC	38	44	63	39
17	Wegberg-Beec	38	31	64	31
18	Sportfreunde	38	36	63	30
19	Uerdingen	38	39	96	27
20	Homberg	38	30	64	26

TEMPORADA 2020/2021

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dortmund	40	94	31	93
2	Rot-Weiss	40	90	28	90
3	Preußen	40	70	39	78
4	Fortuna	40	66	48	66
5	Köln II	40	66	55	61
6	Rödinghause	40	52	39	59
7	Rot-Weiß	40	61	50	59
8	Schalke	40	59	56	57
9	Fortuna	40	67	53	56
10	Wiedenbrück	40	55	50	56
11	Mönchenglad	40	49	55	55
12	Wuppertaler	40	57	62	54
13	SV Straelen	40	45	61	47
14	Alemannia	40	35	48	45
15	Sportfreunde	40	47	72	44
16	Lippstadt	40	37	63	40
17	Wegberg-Beec	40	36	62	39
18	Weiss Ahlen	40	50	69	38
19	Bonner SC	40	39	66	38
20	Homberg	40	40	75	35
21	Bergisch	40	36	69	33

TEMPORADA 2019/2020

OBERLIGA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	SV Straelen	22	67	22	61
2	1.FC Monheim	22	40	24	42
3	Schonnebeck	22	36	24	42
4	FC Bocholt	23	50	33	40
5	Velbert	22	42	27	40
6	Meerbusch	23	43	36	35
7	SF Baumberg	23	52	46	35
8	Hilden	23	43	40	34
9	Schwarz-Weis	22	32	32	31
10	Turu 1880 D.	22	32	32	31
11	Kleve	23	32	34	31
12	Kray	23	46	40	30
13	TVD Velbert	23	30	30	30
14	Germania	23	37	42	30
15	SC Velbert	22	22	48	18
16	Union	22	21	50	13
17	Cronenberger	23	22	53	13
18	Niederwenige	23	27	61	11

TEMPORADA 2018/2019

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Viktoria	34	62	30	67
2	Rot-Weiß	34	58	41	64
3	Rödinghause	34	58	29	63
4	Mönchenglad	34	47	38	57
5	Dortmund	34	62	36	56
6	Alemannia	34	48	39	49
7	Verl	34	51	46	46
8	Rot-Weiss	34	42	40	46
9	Köln II	34	54	46	45
10	Wuppertaler	34	45	49	44
11	Wattenscheid	34	44	44	43
12	Fortuna	34	47	62	42
13	Lippstadt	34	36	48	41
14	Bonner SC	34	42	51	40
15	Kaan-Marienb	34	50	54	39
16	SV Straelen	34	36	62	39
17	Wiedenbrück	34	42	52	38
18	Herkenrath	34	34	91	15

TEMPORADA 2017/2018

OBERLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	SV Straelen	34	81	36	70
2	Schonnebeck	34	78	41	69
3	Homberg	34	75	45	63
4	SF Baumberg	34	78	51	58
5	Jahn	34	66	48	56
6	Schwarz-Weis	34	70	55	56
7	Germania	34	74	45	55
8	Velbert	34	67	46	55
9	Düsseldorf-	34	68	67	52
10	FC Bocholt	34	65	50	50
11	1.FC Monheim	34	64	58	50
12	Speldorf	34	64	67	47
13	Hilden	34	62	68	43
14	Turu 1880 D.	34	40	65	40
15	Krefeld-Fisc	34	61	92	30
16	Cronenberger	34	42	84	30
17	Vohwinkel	34	54	101	25
18	Düsseldorfe	34	36	126	8

TEMPORADA 2016/2017

LANDESLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	SV Straelen	34	90	34	77
2	Speldorf	34	88	39	71
3	Rhede	34	74	47	66
4	Sonsbeck	34	58	42	61
5	Rot-Weiss	34	75	51	60
6	Duisburg	34	73	61	51
7	Kleve	34	53	47	51
8	SpVgg	34	71	61	46
9	Rellinghause	34	58	63	45
10	Duisburger	34	59	62	44
11	Niederwenige	34	54	58	42
12	Viktoria	34	46	64	42
13	Wesel-Lackha	34	45	78	38
14	Arminia	34	46	67	36
15	VfL Repelen	34	36	62	36
16	Schwafheim	34	38	79	34
17	Essen-West	34	57	84	29
18	Königshardt	34	34	56	28

TEMPORADA 2015/2016

LANDESLIGA GRUPO 12
Equipo		PJ	GF	GC	Puntos
1	Homberg	34	90	39	74
2	Kleve	34	72	32	72
3	Duisburg	34	70	31	71
4	Union	34	63	43	63
5	Rhede	34	69	49	58
6	Wesel-Lackha	34	64	80	50
7	Sonsbeck	34	56	71	49
8	SV Straelen	34	65	63	45
9	Duisburger	34	46	46	43
10	Viersen	34	43	43	43
11	VfL Repelen	34	41	45	43
12	SpVg	34	50	67	41
13	Speldorf	34	75	71	40
14	VSF Amern	34	44	58	40
15	Uerdingen	34	43	60	36
16	Tönis	34	54	70	35
17	Hönnepel-Ni	34	42	93	26
18	Viktoria	34	46	72	24

TEMPORADA 2007/2008

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mönchenglad	34	86	47	68
2	Leverkusen	34	62	31	66
3	Köln II	34	62	29	65
4	Kleve	34	53	40	55
5	Schwarz-Weis	34	43	48	51
6	Velbert	34	47	54	51
7	Duisburg	34	74	62	49
8	Germania	34	42	34	49
9	Alemannia	34	45	46	48
10	Bonner SC	34	48	45	46
11	Fortuna	34	49	53	46
12	Wuppertaler	34	51	55	45
13	Uerdingen	34	55	67	43
14	Turu 1880 D.	34	37	42	42
15	Homberg	34	49	62	39
16	Speldorf	34	42	69	30
17	Bergisch	34	45	74	28
18	SV Straelen	34	40	72	24

TEMPORADA 2006/2007

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Rot-Weiß	34	50	25	69
2	Alemannia	34	56	39	61
3	Velbert	34	60	48	56
4	Bonner SC	34	48	41	53
5	Duisburg	34	61	58	53
6	Schwarz-Weis	34	54	38	52
7	Kleve	34	44	45	50
8	Köln II	34	62	50	49
9	Wuppertaler	34	40	35	49
10	Uerdingen	34	45	45	48
11	Turu 1880 D.	34	44	38	47
12	Bergisch	34	42	46	45
13	SV Straelen	34	51	46	42
14	Speldorf	34	40	47	42
15	Homberg	34	42	53	41
16	FC Bocholt	34	43	53	40
17	Union	34	31	78	25
18	Düren	34	38	66	24

TEMPORADA 2000/2001

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Leverkusen	34	89	32	71
2	Wuppertaler	34	60	31	71
3	Köln II	34	70	43	65
4	Velbert	34	59	43	60
5	Adler	34	54	55	55
6	Schwarz-Weis	34	48	48	51
7	Duisburg	34	43	38	50
8	Mönchenglad	34	54	44	48
9	Borussia	34	45	53	44
10	FC Bocholt	34	46	47	43
11	Fortuna	34	49	51	43
12	Germania	34	58	62	42
13	Viktoria	34	49	53	42
14	Wegberg-Beec	34	37	46	40
15	Rheydter SV	34	55	71	39
16	Remscheid	34	46	65	34
17	SV Straelen	34	50	84	28
18	Euskirchen	34	29	75	20

TEMPORADA 1999/2000

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Wuppertaler	30	60	28	61
2	Viktoria	30	47	28	55
3	Mönchenglad	30	56	31	53
4	Remscheid	30	48	30	51
5	Rheydter SV	30	55	38	51
6	SV Straelen	30	47	44	50
7	Adler	30	65	42	49
8	Duisburg	30	50	41	45
9	Schwarz-Weis	30	39	45	38
10	FC Bocholt	30	39	56	37
11	Fortuna	30	41	40	36
12	Wegberg-Beec	30	41	44	32
13	Köln II	30	40	49	30
14	Euskirchen	30	26	61	26
15	Bonner SC	30	22	47	24
16	Germania	30	32	84	20

TEMPORADA 1998/1999

OBERLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Rot-Weiss	30	59	28	67
2	Adler	30	58	33	60
3	Wegberg-Beec	30	54	20	55
4	Viktoria	30	45	33	55
5	Rheydter SV	30	56	42	49
6	SV Straelen	30	52	36	47
7	Mönchenglad	30	49	35	46
8	Schwarz-Weis	30	50	43	42
9	Germania	30	45	52	34
10	Köln II	30	34	43	34
11	Fortuna	30	41	59	34
12	FC Bocholt	30	37	42	33
13	Bonner SC	30	32	48	32
14	Baesweiler	30	23	50	31
15	Langerwehe	30	38	53	29
16	Jahn	30	25	81	8

TEMPORADA 1997/1998

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Leverkusen	30	71	18	70
2	Rhenania	30	59	36	61
3	Fortuna	30	64	41	59
4	Mönchenglad	30	40	23	53
5	Uerdingen	30	47	43	45
6	Wegberg-Beec	30	55	52	39
7	Köln II	30	33	32	38
8	Schwarz-Weis	30	30	30	38
9	Langerwehe	30	36	36	36
10	Baesweiler	30	34	52	35
11	FC Bocholt	30	40	44	34
12	Dinslaken	30	37	46	33
13	Rheydter SV	30	27	40	33
14	SV Straelen	30	40	46	32
15	Bergisch	30	29	46	31
16	Honnef	30	19	76	12

TEMPORADA 1996/1997

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Bonner SC	28	44	27	55
2	Fortuna	28	49	23	54
3	Leverkusen	28	47	29	48
4	Wegberg-Beec	28	46	43	48
5	Schwarz-Weis	28	50	33	46
6	SV Straelen	28	37	22	43
7	Köln II	28	49	46	37
8	Uerdingen	28	49	52	37
9	Rheydter SV	28	43	43	35
10	Honnef	28	42	53	34
11	Bergisch	28	29	39	31
12	Baesweiler	28	28	34	29
13	Dinslaken	28	31	45	29
14	Viktoria	28	27	48	26
15	Rheinbach	28	28	62	20

Competiciones que juega

Grupo 10

Oberliga Grupo 10

Pos	Equipos		Pts
1		SF Baumberg	63
2		KFC Uerdingen 05	52
3		Schonnebeck	51
4		Germania Ratingen	48
5		Hilden	48
6		Homberg	40
7		FC Büderich	39
8		Schwarz-Weiss Essen	39
9		SC Union Nettetal	37
10		TVD Velbert	35
11		Sonsbeck	35
12		SV Straelen	34
13		SC St. Tönis	33
14		Mülheimer FC 97	30
15		Kleve	30
16		Union Frintrop	28
17		Meerbusch	27
18		Hamborn	26

	Ascenso : SF Baumberg
	Descenso : Union Frintrop, Meerbusch, Hamborn

RIVALES EN Oberliga

USO DE MEMORIA

7,163,696 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1511
Total Execution Time	0.1523

CADENA URL

/historico/Straelen-1919

GET DATOS

$_GET['/historico/Straelen-1919']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0036	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 = 'Straelen-1919' 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.0020	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=83326 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=83326 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=83326 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0046	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 = 72634
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83326 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 83326 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (609567) ORDER BY n.cover_points DESC, update_date DESC
0.0033	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 = '83326' ORDER BY l.year DESC,cat.coefficient DESC
0.0030	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 = '83326' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0029	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 = '83326' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 72634 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=83326 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (72634,71432,68048,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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 68048 AND teamId = 83326
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72634 AND teamId = 83326
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 67716 AND teamId = 83326
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 83326
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 = '83326' 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 = '83326' 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 = '83326' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030	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 = 72634 WHERE rp.league_id = 72634 AND rp.teamId = 83326 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.0027	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 = 72634 WHERE rp.league_id = 72634 AND rp.teamId = 83326 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 72634 WHERE rp.league_id = 72634 AND rp.teamId = 83326 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 83326 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 = 72634 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.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 = 68048 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.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* `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 = 63325 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.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* `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 = 57407 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.0029	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 = 50471 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.0028	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 = 43944 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 39087 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* `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 = 46823 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 46841 AND t.round = 34 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* `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 = 19869 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* `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 = 19880 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 28321 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* `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 = 28340 AND t.round = 30 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* `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 = 28343 AND t.round = 32 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* `tables1998` 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 = 28352 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1997` 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 = 28360 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

SV Straelen

SV Straelen

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 10

RIVALES EN Oberliga