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

Oberlausitz Neugersdorf

Temporada 2023/2024

TEMPORADA 2023/2024

LANDESLIGA GRUPO 32
Equipo		PJ	GF	GC	Puntos
1	Taucha	21	51	15	47
2	Handwerk	21	33	12	41
3	Markranstäd	21	28	13	41
4	Empor	21	36	30	38
5	Borea	21	35	26	36
6	Oberlausitz	21	29	25	33
7	Dresden-Laub	21	47	25	32
8	Reichenbache	21	29	24	32
9	1910	21	22	23	29
10	Motor	21	35	32	28
11	Fortuna	21	27	30	26
12	Kickers	21	29	36	22
13	Radebeuler	21	21	33	22
14	Pirna-Copitz	21	23	39	21
15	Radefelder	21	19	42	16
16	Rapid	21	17	76	3

TEMPORADA 2022/2023

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Eilenburg	34	65	33	71
2	Krieschow	34	81	53	65
3	Bischofswerd	34	69	36	59
4	VFC Plauen	34	82	47	57
5	Budissa	34	66	55	54
6	Auerbach	34	55	42	50
7	SC Freital	34	49	42	50
8	Union	34	37	43	49
9	Einheit	34	66	66	48
10	Einheit	34	50	53	47
11	VfL Halle	34	45	49	44
12	Ludwigsfelde	34	35	38	43
13	FC Grimma	34	41	46	42
14	Fahner Höhe	34	50	67	41
15	Wacker	34	42	65	36
16	Blau-Weiß	34	58	77	31
17	1890	34	44	84	28
18	Oberlausitz	34	27	66	24

TEMPORADA 2021/2022

OBERLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Rot-Weiss	29	103	16	78
2	Krieschow	29	72	34	58
3	VFC Plauen	29	61	25	58
4	Budissa	30	74	59	51
5	Union	30	48	33	46
6	VfL Halle	30	52	46	41
7	Einheit	31	42	51	41
8	Oberlausitz	29	43	47	40
9	Einheit	29	49	54	40
10	Carl Zeiss.	29	47	51	39
11	Bischofswerd	30	45	48	38
12	Fahner Höhe	30	32	44	37
13	Blau-Weiß	30	41	62	35
14	FC Grimma	29	45	48	34
15	Wacker	30	33	55	29
16	Internationa	29	43	76	28
17	Arnstadt	29	31	73	21
18	Martinroda	30	34	73	19
19	Merseburg	0	0	0	0

TEMPORADA 2020/2021

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eilenburg	9	22	9	20
2	VfL Halle	9	21	10	20
3	Oberlausitz	10	16	10	20
4	Union	10	16	18	18
5	FC Grimma	9	19	10	17
6	Rot-Weiss	9	14	7	17
7	Krieschow	8	21	12	16
8	VFC Plauen	10	18	16	16
9	Einheit	9	16	11	14
10	Fahner Höhe	10	8	17	13
11	Internationa	10	13	15	10
12	Merseburg	9	9	16	10
13	Ludwigsfelde	8	14	16	8
14	Martinroda	9	13	20	8
15	Blau-Weiß	10	11	22	7
16	Carl Zeiss.	9	6	16	4
17	Wacker	8	6	18	2

TEMPORADA 2019/2020

OBERLIGA GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Carl Zeiss.	18	40	17	43
2	Luckenwalde	17	54	19	41
3	Einheit	18	37	18	35
4	Eilenburg	18	35	25	30
5	Internationa	17	33	17	29
6	VFC Plauen	17	32	31	27
7	Merseburg	17	38	36	24
8	Union	17	28	23	23
9	Krieschow	17	43	41	23
10	FC Grimma	18	32	44	23
11	VfL Halle	18	22	35	23
12	Wacker	18	34	41	22
13	Oberlausitz	18	33	33	21
14	Martinroda	18	22	55	8
15	Askania	18	18	66	3
16	Hohenstein-E	0	0	0	0

TEMPORADA 2018/2019

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Chemnitzer	34	82	36	77
2	Berliner	34	64	36	70
3	Wacker	34	59	38	64
4	Hertha	34	60	43	57
5	Rot-Weiss	34	57	42	54
6	Viktoria	34	50	38	52
7	Lokomotive	34	51	41	50
8	Babelsberg	34	53	44	46
9	Germania	34	46	38	46
10	Auerbach	34	47	53	46
11	Meuselwitz	34	52	55	44
12	BFC Dynamo	34	38	61	42
13	Union	34	43	60	40
14	Altglienicke	34	54	59	39
15	Oberlausitz	34	40	64	37
16	Bischofswerd	34	29	58	34
17	Optik	34	36	65	28
18	Budissa	34	21	51	26

TEMPORADA 2017/2018

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Energie	34	79	14	89
2	Wacker	34	48	29	58
3	Berliner	34	63	47	56
4	BFC Dynamo	34	70	50	54
5	Babelsberg	34	52	38	53
6	Lokomotive	34	48	36	53
7	Germania	34	68	52	52
8	Hertha	34	54	45	48
9	Union	34	59	52	47
10	Meuselwitz	34	44	44	43
11	Auerbach	34	48	51	43
12	Oberlausitz	34	47	53	43
13	Viktoria	34	49	54	42
14	Budissa	34	31	47	41
15	Altglienicke	34	30	41	38
16	Chemie	34	21	51	35
17	Neustrelitz	34	36	75	27
18	Luckenwalde	34	25	93	9

TEMPORADA 2016/2017

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Carl Zeiss.	34	68	25	75
2	Energie	34	58	26	66
3	Leipzig	34	67	42	60
4	Viktoria	34	63	47	56
5	Babelsberg	34	55	42	55
6	Berliner	34	54	42	55
7	Wacker	34	47	47	51
8	Oberlausitz	34	41	33	48
9	Hertha	34	46	48	48
10	Lokomotive	34	53	49	47
11	Schönberg	34	53	60	47
12	Auerbach	34	47	50	45
13	Union	34	49	59	45
14	Meuselwitz	34	37	36	44
15	BFC Dynamo	34	51	54	44
16	Luckenwalde	34	35	75	24
17	Budissa	34	29	68	18
18	Neustrelitz	34	30	80	11

TEMPORADA 2015/2016

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Zwickau	34	77	30	77
2	Berliner	34	68	22	77
3	Wacker	34	59	39	61
4	BFC Dynamo	34	66	48	56
5	Oberlausitz	34	52	48	54
6	Babelsberg	34	49	29	53
7	Carl Zeiss.	34	43	33	53
8	Neustrelitz	34	53	42	51
9	Auerbach	34	52	44	50
10	Hertha	34	52	59	48
11	Leipzig	34	49	48	44
12	Viktoria	34	46	62	38
13	Budissa	34	46	47	37
14	Meuselwitz	34	34	59	37
15	Schönberg	34	37	52	36
16	Luckenwalde	34	33	80	29
17	Germania	34	39	80	23
18	Optik	34	33	66	22

TEMPORADA 2014/2015

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Leipzig	30	82	21	72
2	Oberlausitz	30	71	20	66
3	Markranstäd	30	67	33	58
4	Lokomotive	30	38	21	56
5	Rot-Weiß	30	46	35	50
6	Energie	30	52	59	44
7	VfL Halle	30	43	41	43
8	Erzgebirge	30	37	43	40
9	Carl Zeiss.	30	31	36	38
10	Dynamo	30	45	53	38
11	Chemnitzer	30	42	43	36
12	Eisenach	30	39	71	35
13	Union	30	37	52	30
14	Einheit	30	28	60	23
15	Schott Jena	30	36	65	22
16	Askania	30	30	71	20

TEMPORADA 2013/2014

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Budissa	30	72	22	73
2	Markranstäd	30	54	21	67
3	Oberlausitz	30	70	41	58
4	VfL Halle	30	55	35	51
5	Erzgebirge	30	48	54	48
6	Chemnitzer	30	61	44	45
7	Energie	30	49	52	45
8	Union	30	43	51	45
9	Dynamo	30	41	41	41
10	Carl Zeiss.	30	54	48	39
11	Einheit	30	40	50	39
12	Schott Jena	30	44	49	36
13	Rot-Weiß	30	49	63	33
14	Hallescher	30	39	55	31
15	Grün-Weiß	30	40	66	24
16	Heidenauer	30	27	94	10

TEMPORADA 2005/2006

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Magdeburg	30	62	17	67
2	VFC Plauen	30	58	38	62
3	Sachsen	30	47	21	56
4	Hallescher	30	46	26	53
5	Meuselwitz	30	52	40	53
6	Germania	30	61	40	50
7	Rot-Weiß	30	36	40	44
8	Budissa	30	46	33	43
9	Energie	30	45	43	40
10	Borea	30	41	37	36
11	Auerbach	30	40	46	34
12	Eilenburg	30	32	39	31
13	Possneck	30	29	59	24
14	TSV Völpke	30	25	75	24
15	FC Grimma	30	30	51	23
16	Oberlausitz	30	33	78	20

TEMPORADA 2004/2005

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Carl Zeiss.	34	108	23	87
2	VFC Plauen	34	76	30	75
3	Sachsen	34	52	31	63
4	Hallescher	34	70	38	60
5	Magdeburg	34	59	33	58
6	Meuselwitz	34	58	36	56
7	Auerbach	34	54	65	49
8	Possneck	34	41	56	47
9	Germania	34	51	50	46
10	FC Grimma	34	52	55	43
11	Oberlausitz	34	49	58	42
12	Eilenburg	34	42	52	41
13	Dresden-Nord	34	44	51	38
14	Zwickau	34	43	59	38
15	Dessau 05	34	36	49	34
16	Eintracht	34	43	91	31
17	Erfurt-Nord	34	20	77	19
18	Dresden-Laub	34	34	78	18

TEMPORADA 2003/2004

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Carl Zeiss.	33	79	20	75
2	VFC Plauen	33	71	27	75
3	Magdeburg	34	66	19	74
4	Hallescher	33	58	34	61
5	Dresden-Nord	33	51	34	59
6	Lokomotive	31	55	39	53
7	Energie	32	57	45	51
8	Zwickau	33	40	43	43
9	Dresden-Laub	33	42	57	40
10	Possneck	33	43	51	39
11	Oberlausitz	33	48	53	36
12	FC Grimma	33	38	55	36
13	Germania	32	32	46	34
14	Auerbach	33	34	53	30
15	Eintracht	33	41	70	29
16	Erfurt-Nord	33	33	74	24
17	Dresdner SC	33	29	57	23
18	Anhalt	18	12	52	6

TEMPORADA 2002/2003

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Sachsen	34	76	19	83
2	Carl Zeiss.	34	87	22	82
3	VFC Plauen	34	76	23	73
4	Lokomotive	34	57	23	67
5	Hallescher	34	49	29	59
6	Zwickau	34	59	41	54
7	Dresden-Nord	34	49	36	50
8	Energie	34	56	58	46
9	FC Grimma	34	39	44	43
10	Magdeburg	34	36	47	42
11	Oberlausitz	34	52	50	41
12	Dresden-Laub	34	46	65	37
13	Possneck	34	44	65	36
14	Anhalt	34	40	68	36
15	Eintracht	34	40	75	35
16	Wacker Gotha	34	25	58	28
17	Fortuna	34	25	61	27
18	Lausitz	34	21	93	21

TEMPORADA 2001/2002

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Dynamo	32	61	16	78
2	VFC Plauen	32	69	18	75
3	Carl Zeiss.	32	79	24	71
4	Lokomotive	32	55	18	68
5	Sachsen	32	65	27	65
6	Zwickau	32	55	46	47
7	Hallescher	32	45	29	44
8	Dresden-Nord	32	48	50	44
9	Energie	32	44	40	41
10	Wacker Gotha	32	34	44	39
11	Lausitz	32	38	52	35
12	FC Grimma	32	38	68	33
13	Eintracht	32	31	60	32
14	Oberlausitz	32	30	60	29
15	Fortuna	32	21	47	25
16	VfB Zittau	32	36	73	21
17	Braunsbedra	32	17	94	11

Competiciones que juega

Grupo 32

Landesliga Grupo 32

Pos	Equipos		Pts
1		SG Taucha 99	47
2		Handwerk Rabenstein	41
3		Markranstädt	41
4		VfB Empor Glauchau	38
5		Borea Dresden	36
6		Oberlausitz Neugersdorf	33
7		Dresden-Laubegast	32
8		Reichenbacher FC	32
9		FC 1910 Lößnitz	29
10		Motor Wilsdruff	28
11		Fortuna Chemnitz	26
12		Kickers 94 Markkleeberg	22
13		Radebeuler BC	22
14		VfL Pirna-Copitz	21
15		Radefelder SV	16
16		Rapid Chemnitz	3

RIVALES EN Landesliga

USO DE MEMORIA

6,984,944 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.6868
Total Execution Time	0.6890

CADENA URL

/historico/Oberlausitz-Neugersdorf

GET DATOS

$_GET['/historico/Oberlausitz-Neugersdorf']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0158	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 = 'Oberlausitz-Neugersdorf' 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.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=17170 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=17170 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=17170 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254	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 = 73076
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17170 AND type_rel = 2
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17170 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127	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 (50737) ORDER BY n.cover_points DESC, update_date DESC
0.0131	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 = '17170' ORDER BY l.year DESC,cat.coefficient DESC
0.0138	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 = '17170' AND l.year = 2024 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 = '17170' 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 = 73076 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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=17170 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (73076,71432,68170) 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.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 68170 AND teamId = 17170
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 73076 AND teamId = 17170
0.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17170
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 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 = 73076 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '17170' 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 = '17170' and rp.type = 4
0.0127	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 = '17170' 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 events2024 e ON e.player_id = p.id AND e.league_id = 73076 WHERE rp.league_id = 73076 AND rp.teamId = 17170 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.0130	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 = 73076 WHERE rp.league_id = 73076 AND rp.teamId = 17170 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 events2024 e ON e.player_id = p.id AND e.league_id = 73076 WHERE rp.league_id = 73076 AND rp.teamId = 17170 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 = 17170 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73076 AND t.round = 24 ORDER BY team.conference ASC,t.position 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* `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 = 68170 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.0139	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 = 63241 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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 = 57317 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 50539 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	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 = 43945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 38890 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* `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 = 33792 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* `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 = 15530 AND t.round = 34 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* `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 = 4385 AND t.round = 30 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* `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 = 3542 AND t.round = 30 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* `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 = 19889 AND t.round = 30 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* `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 = 28297 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* `tables2004` 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 = 28293 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* `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 = 28307 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* `tables2002` 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 = 28330 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Oberlausitz Neugersdorf

Oberlausitz Neugersdorf

Selecciona un equipo

Competiciones que juega

Landesliga Grupo 32

RIVALES EN Landesliga