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

Eintracht Trier

Temporada 2023/2024

TEMPORADA 2023/2024

OBERLIGA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Eintracht	35	107	30	92
2	Gonsenheim	35	88	42	71
3	Pirmasens	35	79	40	65
4	Wormatia	35	71	45	63
5	Kaiserslaute	35	74	58	59
6	Auersmacher	35	61	59	58
7	RW Koblenz	35	64	56	55
8	Engers 07	35	70	54	53
9	Diefflen	35	70	74	52
10	Morlautern	35	60	66	51
11	Karbach	35	64	82	48
12	Arminia	35	55	71	47
13	Mechtersheim	35	62	52	46
14	Dudenhofen	35	55	58	42
15	Cosmos	35	61	65	41
16	Alemannia	35	38	60	37
17	Baumholder	35	53	77	32
18	Pfeddersheim	35	45	86	30
19	SpVgg	35	34	75	26
20	FC Bitburg	35	43	104	17

TEMPORADA 2022/2023

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

TEMPORADA 2021/2022

OBERLIGA GRUPO 30
Equipo		PJ	GF	GC	Puntos
1	Eintracht	2	6	1	4
2	Stuttgarter	2	4	1	4
3	Eintracht	2	0	8	0

TEMPORADA 2020/2021

OBERLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Eintracht	8	21	2	22
2	Kaiserslaute	8	16	9	16
3	Hassia	9	19	15	16
4	Alemannia	8	16	11	13
5	TuS Koblenz	9	7	10	13
6	Gonsenheim	8	12	8	11
7	Engers 07	6	13	8	10
8	Mülheim-Kä	6	10	13	9
9	Karbach	8	8	17	8
10	Salmrohr	9	8	18	6
11	Sportfreunde	7	5	12	5
12	Emmelshausen	8	6	18	5
13	Wormatia	9	29	8	24
14	Dudenhofen	9	17	11	17
15	Diefflen	9	17	13	14
16	Arminia	9	14	13	13
17	Jägersburg	9	17	24	13
18	Rochling	9	13	13	11
19	Pfeddersheim	9	15	16	11
20	Elversberg	9	9	12	11
21	Mechtersheim	9	8	13	10
22	Hertha	9	24	22	8
23	FV Speyer	8	13	16	8
24	Eppelborn	8	11	26	4

TEMPORADA 2019/2020

OBERLIGA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Schott Mainz	21	49	20	42
2	Kaiserslaute	21	47	25	40
3	Elversberg	21	55	37	40
4	TuS Koblenz	21	34	24	39
5	Eintracht	20	33	20	37
6	Dudenhofen	21	43	31	35
7	Wormatia	20	42	33	33
8	Gonsenheim	21	44	36	31
9	Diefflen	21	36	31	29
10	Pfeddersheim	21	45	46	28
11	Engers 07	21	29	30	28
12	Rochling	21	38	45	26
13	Hertha	21	36	48	25
14	Arminia	21	21	36	24
15	Karbach	21	32	50	21
16	Mechtersheim	21	20	34	19
17	Hassia	21	22	46	19
18	Sportfreunde	21	25	59	14

TEMPORADA 2018/2019

OBERLIGA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	RW Koblenz	34	68	30	71
2	Rochling	34	67	38	60
3	Pfeddersheim	34	73	57	60
4	TuS Koblenz	34	54	34	59
5	Engers 07	34	59	48	59
6	Eintracht	34	67	41	57
7	Schott Mainz	34	76	55	57
8	Mechtersheim	34	57	49	53
9	Kaiserslaute	34	61	42	51
10	Hertha	34	50	43	50
11	Hassia	34	58	58	47
12	Karbach	34	48	50	45
13	Arminia	34	58	74	43
14	Diefflen	34	60	73	42
15	Jägersburg	34	49	65	35
16	Emmelshausen	34	34	71	35
17	Idar-Oberste	34	47	95	18
18	Dillingen	34	34	97	16

TEMPORADA 2017/2018

OBERLIGA GRUPO 11
Equipo		PJ	GF	GC	Puntos
1	Homburg	36	112	20	96
2	Pirmasens	36	97	31	79
3	Kaiserslaute	36	89	29	77
4	Eintracht	36	65	36	71
5	Diefflen	36	81	61	63
6	Jägersburg	36	68	60	55
7	RW Koblenz	36	66	60	52
8	Hertha	36	62	72	48
9	Mechtersheim	36	58	73	47
10	Karbach	36	65	75	44
11	Idar-Oberste	36	53	57	43
12	Pfeddersheim	36	48	66	43
13	Engers 07	36	47	69	42
14	Dudenhofen	36	41	72	40
15	Gonsenheim	36	57	68	39
16	Morlautern	36	46	79	30
17	Salmrohr	36	32	71	28
18	Saar	36	36	74	27
19	Eppelborn	36	51	101	24

TEMPORADA 2016/2017

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

TEMPORADA 2015/2016

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

TEMPORADA 2014/2015

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kickers	34	55	22	79
2	Saarbrücken	34	51	27	69
3	Elversberg	34	60	28	65
4	Kaiserslaute	34	57	28	61
5	Wormatia	34	59	44	58
6	Homburg	34	48	31	57
7	Freiburg II	34	66	46	53
8	Astoria	34	51	40	53
9	Hoffenheim	34	44	46	51
10	Hessen	34	43	35	47
11	Eintracht	34	31	33	44
12	SpVgg	34	47	55	44
13	Waldhof	34	36	33	43
14	Pirmasens	34	40	44	42
15	Nottingen	34	50	67	37
16	Koblenz	34	24	58	25
17	Baunatal	34	22	82	16
18	Zweibrücken	34	17	82	15

TEMPORADA 2013/2014

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sonnenhof	34	71	37	75
2	Freiburg II	34	69	37	67
3	Mainz 05 II	34	63	34	67
4	Kaiserslaute	34	66	31	63
5	Waldhof	34	48	40	53
6	Eintracht	34	49	37	51
7	Zweibrücken	34	45	39	51
8	Kickers	34	39	31	50
9	SpVgg	34	42	47	48
10	Hoffenheim	34	52	45	45
11	Homburg	34	50	47	44
12	Eintracht	34	52	55	42
13	Hessen	34	41	64	40
14	Koblenz	34	36	46	39
15	Ulm	34	39	56	32
16	Wormatia	34	36	62	30
17	Baunatal	34	33	71	25
18	Pfullendorf	34	29	81	19

TEMPORADA 2012/2013

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hessen	36	56	36	70
2	Elversberg	36	59	44	65
3	Kaiserslaute	36	56	38	60
4	Sonnenhof	36	62	36	58
5	Eintracht	36	50	44	57
6	Waldhof	36	48	38	55
7	Freiburg II	36	61	48	52
8	Koblenz	36	46	44	52
9	Hoffenheim	36	62	45	51
10	Ulm	36	46	46	51
11	Mainz 05 II	36	55	56	49
12	Wormatia	36	49	51	44
13	Pfullendorf	36	40	49	43
14	Homburg	36	51	64	43
15	Eintracht	36	48	54	40
16	Eschborn	36	43	56	40
17	Frankfurt	36	38	62	40
18	Idar-Oberste	36	41	57	35
19	Bayern	36	43	86	28

TEMPORADA 2011/2012

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dortmund	36	84	39	77
2	Sportfreunde	36	64	31	76
3	Mönchenglad	36	67	45	69
4	Eintracht	36	57	34	64
5	Wuppertaler	36	68	49	57
6	Köln II	36	59	48	56
7	Fortuna	36	54	56	53
8	Rot-Weiss	36	52	57	52
9	Kaiserslaute	36	56	55	51
10	Verl	36	39	48	46
11	Schalke	36	55	63	45
12	Mainz 05 II	36	49	47	43
13	Elversberg	36	39	60	42
14	Bochum	36	42	64	41
15	Wiedenbrück	36	44	52	40
16	Idar-Oberste	36	38	62	39
17	TuS Koblenz	36	32	51	31
18	Leverkusen	36	34	57	31
19	Fortuna	36	39	54	29

TEMPORADA 2010/2011

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Preußen	34	56	24	72
2	Eintracht	34	58	34	62
3	Sportfreunde	34	43	29	62
4	Kaiserslaute	34	53	36	59
5	Mönchenglad	34	53	41	59
6	Dortmund	34	56	47	52
7	Köln II	34	61	43	51
8	Wuppertaler	34	52	59	50
9	Verl	34	40	34	48
10	Wiedenbrück	34	50	55	46
11	Schalke	34	34	45	44
12	Elversberg	34	39	44	43
13	Mainz 05 II	34	48	51	41
14	Bochum	34	49	64	34
15	Leverkusen	34	43	58	33
16	Fortuna	34	41	55	31
17	Homburg	34	29	49	30
18	Arminia	34	30	67	21

TEMPORADA 2009/2010

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Saarbrücken	34	53	33	69
2	Sportfreunde	34	48	31	61
3	Bochum	34	50	32	57
4	Köln II	34	50	37	55
5	Rot-Weiss	34	44	32	52
6	Preußen	34	47	37	51
7	Elversberg	34	41	34	50
8	Kaiserslaute	34	43	37	49
9	Verl	34	41	41	47
10	Bonner SC	34	48	45	43
11	Fortuna	34	35	51	41
12	Schalke	34	42	43	40
13	Leverkusen	34	38	45	40
14	Waldhof	34	36	43	40
15	Mainz 05 II	34	37	45	40
16	Mönchenglad	34	37	53	40
17	Wormatia	34	35	58	30
18	Eintracht	34	33	61	29

TEMPORADA 2008/2009

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dortmund	34	86	49	68
2	Kaiserslaute	34	59	42	65
3	Köln II	34	53	34	60
4	Preußen	34	51	36	53
5	Mainz 05 II	34	58	45	52
6	Mönchenglad	34	50	49	51
7	Rot-Weiss	34	61	41	49
8	Verl	34	45	42	49
9	Leverkusen	34	53	56	49
10	Sportfreunde	34	53	57	49
11	Elversberg	34	39	37	46
12	Oggersheim	34	43	58	42
13	Eintracht	34	37	51	41
14	Bochum	34	51	59	40
15	Schalke	34	41	54	39
16	Wormatia	34	39	55	33
17	Cloppenburg	34	51	76	28
18	Kleve	34	44	73	27

TEMPORADA 2007/2008

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mainz 05 II	34	87	22	76
2	Kaiserslaute	34	64	26	68
3	Wormatia	34	59	28	68
4	Eintracht	34	61	30	67
5	Saarbrücken	34	70	34	65
6	Borussia	34	48	24	64
7	Homburg	34	49	41	50
8	Wirges	34	47	47	50
9	Hauenstein	34	47	52	46
10	Pirmasens	34	48	49	45
11	Idar-Oberste	34	47	54	42
12	Roßbach	34	41	53	41
13	TuS Mayen	34	51	59	37
14	Mechtersheim	34	53	76	37
15	Köllerbach	34	35	69	31
16	Rot-Weiß	34	30	64	28
17	Eintracht	34	27	86	22
18	Engers 07	34	26	76	17

TEMPORADA 2006/2007

OBERLIGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ludwigshafen	32	69	24	75
2	Mainz 05 II	32	62	26	66
3	Wormatia	32	62	24	65
4	Homburg	32	52	42	56
5	Eintracht	32	59	44	53
6	Saarbrücken	32	55	37	51
7	Wirges	32	50	43	42
8	Hauenstein	32	39	42	41
9	Engers 07	32	35	42	41
10	Borussia	32	46	42	40
11	TuS Mayen	32	31	42	39
12	Rot-Weiß	32	38	56	37
13	Eintracht	32	34	51	36
14	Mechtersheim	32	36	54	31
15	Salmrohr	32	40	59	31
16	Betzdorf	32	26	62	23
17	Hohenecken	32	33	77	17

Competiciones que juega

Grupo 8

Oberliga Grupo 8

Pos	Equipos		Pts
1		Eintracht Trier	92
2		Gonsenheim	71
3		FK Pirmasens	65
4		Wormatia Worms	63
5		Kaiserslautern II	59
6		Auersmacher	58
7		RW Koblenz	55
8		Engers 07	53
9		Diefflen	52
10		Morlautern	51
11		Karbach	48
12		Arminia Ludwigshafen	47
13		Mechtersheim	46
14		Dudenhofen	42
15		Cosmos Koblenz	41
16		Alemannia Waldalgesheim	37
17		VfR Baumholder	32
18		Pfeddersheim	30
19		SpVgg Quierschied	26
20		FC Bitburg	17

	Playoff Ascenso : Eintracht Trier
	Descenso : Mechtersheim, Dudenhofen, Cosmos Koblenz, Alemannia Waldalgesheim, VfR Baumholder, Pfeddersheim, SpVgg Quierschied, FC Bitburg

RIVALES EN Oberliga

USO DE MEMORIA

7,563,256 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1637
Total Execution Time	0.1649

CADENA URL

/historico/Eintracht-Trier

GET DATOS

$_GET['/historico/Eintracht-Trier']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0035	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 = 'Eintracht-Trier' 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.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5676 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5676 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5676 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042	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 = 72627
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5676 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5676 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 (100997,102371) ORDER BY n.cover_points DESC, update_date DESC
0.0034	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 = '5676' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0031	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 = '5676' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72627 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0043	SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=5676 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72627,71432,68047) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 68047 AND teamId = 5676
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 72627 AND teamId = 5676
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5676
0.0021	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 = '5676' 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 = '5676' and rp.type = 4
0.0023	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 = '5676' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0042	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 = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 5676 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.0038	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 5676 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043	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 = 72627 WHERE rp.league_id = 72627 AND rp.teamId = 5676 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 = 5676 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72627 AND t.round = 35 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* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68047 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 63289 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 66977 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 67800 AND t.round = 3 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* `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 = 57793 AND t.round = 22 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* `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 = 50467 AND t.round = 21 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 = 44338 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 39086 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33768 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15531 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3903 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2505 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 2005 AND t.round = 38 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* `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 = 1331 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 16430 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* `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 = 16433 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 16436 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* `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 = 19867 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* `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 = 19876 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Eintracht Trier

Eintracht Trier

Selecciona un equipo

Competiciones que juega

Oberliga Grupo 8

RIVALES EN Oberliga