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

Mainz 05

Entrenador: Bo Henriksen

Temporada 1996/1997

TEMPORADA 1996/1997

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Kaiserslaute	34	74	28	68
2	Wolfsburg	34	52	29	58
3	Hertha BSC	34	57	38	58
4	Mainz 05	34	50	34	54
5	Stuttgarter	34	38	27	53
6	Unterhaching	34	35	29	49
7	Eintracht	34	43	46	48
8	Lokomotive	34	53	54	46
9	Gutersloh	34	43	51	45
10	Uerdingen	34	46	44	44
11	SV Meppen	34	44	48	44
12	Fortuna	34	52	47	42
13	Carl Zeiss.	34	44	49	42
14	Zwickau	34	34	48	42
15	Waldhof	34	45	56	40
16	VfB Lübeck	34	32	53	36
17	Rot-Weiss	34	47	74	29
18	Oldenburg	34	33	67	27

TEMPORADA 1995/1996

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	VfL Bochum	34	68	30	69
2	Arminia	34	55	45	57
3	Duisburg	34	55	37	56
4	Unterhaching	34	52	38	52
5	Zwickau	34	39	48	49
6	Carl Zeiss.	34	49	54	48
7	Waldhof	34	49	47	46
8	Fortuna	34	37	37	46
9	Mainz 05	34	39	41	45
10	Lokomotive	34	35	49	45
11	SV Meppen	34	45	43	44
12	Wolfsburg	34	41	46	44
13	VfB Lübeck	34	40	45	44
14	Hertha BSC	34	37	35	42
15	Chemnitzer	34	43	51	42
16	Hannover 96	34	38	50	35
17	Nürnberg	34	33	40	33
18	Wattenscheid	34	38	57	31

TEMPORADA 1994/1995

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Hansa	34	66	30	46
2	FC St Pauli	34	58	33	44
3	Fortuna	34	51	35	43
4	Wolfsburg	34	51	40	43
5	Waldhof	34	48	35	42
6	SV Meppen	34	52	40	39
7	Saarbrücken	34	45	43	35
8	Fortuna	34	55	49	34
9	Chemnitzer	34	47	50	34
10	Wattenscheid	34	50	52	33
11	Hertha BSC	34	41	45	32
12	Nürnberg	34	40	45	32
13	Hannover 96	34	52	50	31
14	Lokomotive	34	44	44	30
15	Mainz 05	34	50	55	30
16	Zwickau	34	32	50	29
17	Homburg	34	41	63	23
18	Frankfurt	34	39	103	12

TEMPORADA 1993/1994

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	VfL Bochum	38	56	34	48
2	Uerdingen	38	49	30	47
3	1860	38	55	38	47
4	FC St Pauli	38	47	39	45
5	Wolfsburg	38	47	45	40
6	Waldhof	38	45	45	40
7	SV Meppen	38	48	52	39
8	Hansa	38	51	56	39
9	Chemnitzer	38	34	44	39
10	Homburg	38	53	46	37
11	Hertha BSC	38	48	42	37
12	Hannover 96	38	49	46	37
13	Mainz 05	38	46	51	37
14	Saarbrücken	38	58	69	37
15	Fortuna	38	53	49	36
16	Stuttgarter	38	42	50	35
17	Carl Zeiss.	38	38	41	34
18	Wuppertaler	38	44	52	31
19	Rot-Weiss	38	44	60	29
20	Tennis	38	42	60	26

TEMPORADA 1992/1993

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	SC Freiburg	46	102	57	65
2	Duisburg	46	65	40	60
3	Lokomotive	46	66	45	58
4	Waldhof	46	66	53	55
5	Hertha BSC	46	82	55	53
6	Fortuna	46	56	44	50
7	Chemnitzer	46	64	56	50
8	Carl Zeiss.	46	66	59	50
9	Hannover 96	46	60	60	48
10	SV Meppen	46	41	43	47
11	Hansa	46	54	52	46
12	Mainz 05	46	54	58	46
13	Wuppertaler	46	55	50	45
14	Wolfsburg	46	65	69	45
15	Stuttgarter	46	60	59	43
16	Homburg	46	50	53	43
17	FC St Pauli	46	47	52	43
18	Unterhaching	46	58	67	42
19	Eintracht	46	65	73	41
20	Osnabrück	46	63	72	41
21	Fortuna	46	45	65	34
22	Oldenburg	46	57	90	34
23	Remscheid	46	50	83	33
24	Darmstadt	46	43	79	32

TEMPORADA 1991/1992

2. BUNDESLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Lokomotive	10	13	9	31
2	Darmstadt	10	15	13	31
3	1860	10	12	8	30
4	Mainz 05	10	10	13	30
5	Hallescher	10	8	15	27
6	Rot-Weiss	10	15	15	17

TEMPORADA 1990/1991

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Schalke 04	38	64	29	57
2	Duisburg	38	70	34	53
3	Stuttgarter	38	63	32	51
4	Homburg	38	42	37	45
5	Saarbrücken	38	47	30	44
6	Blau-Weiß	38	55	42	44
7	Waldhof	38	60	47	42
8	Mainz 05	38	45	52	41
9	SC Freiburg	38	54	48	40
10	Hannover 96	38	49	49	38
11	Fortuna	38	51	53	37
12	Oldenburg	38	58	53	36
13	Eintracht	38	53	52	35
14	Osnabrück	38	51	55	35
15	Rot-Weiss	38	49	52	34
16	SV Meppen	38	35	42	34
17	Darmstadt	38	46	54	33
18	Preußen	38	35	59	29
19	Havelse	38	44	82	19
20	Schweinfurt	38	26	95	13

TEMPORADA 1988/1989

2. BUNDESLIGA
Equipo		PJ	GF	GC	Puntos
1	Fortuna	38	85	52	49
2	Homburg	38	55	36	47
3	Saarbrücken	38	53	43	46
4	Fortuna	38	80	57	45
5	SC Freiburg	38	66	52	42
6	Wattenscheid	38	68	58	42
7	Alemannia	38	58	55	41
8	Blau-Weiß	38	56	54	41
9	Eintracht	38	43	43	38
10	SV Meppen	38	55	54	37
11	Darmstadt	38	56	57	37
12	Schalke 04	38	58	51	36
13	Hertha BSC	38	45	44	36
14	Osnabrück	38	58	66	36
15	Kickers	38	51	53	35
16	Rot-Weiss	38	54	60	35
17	Bayreuth	38	52	60	34
18	Viktoria	38	47	60	34
19	Mainz 05	38	44	76	29
20	Union	38	24	77	20

TEMPORADA 1975/1976

2. BUNDESLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Saarbrücken	38	66	28	57
2	Nürnberg	38	78	42	54
3	Homburg	38	72	41	51
4	1860	38	78	55	47
5	Bayreuth	38	71	55	47
6	Rochling	38	72	65	45
7	Darmstadt	38	76	64	43
8	Waldhof	38	64	55	42
9	Bayern Hof	38	60	56	41
10	Greuther	38	64	52	37
11	Stuttgart	38	67	60	36
12	Mainz 05	38	81	92	36
13	Frankfurt	38	49	63	35
14	Pirmasens	38	66	78	33
15	FC Augsburg	38	57	56	32
16	Stuttgarter	38	57	70	32
17	Jahn	38	48	74	30
18	Schweinfurt	38	50	72	26
19	Eintracht	38	49	83	23
20	Reutlingen	38	35	99	13

TEMPORADA 1974/1975

2. BUNDESLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Karlsruher	38	76	50	50
2	Pirmasens	38	75	62	48
3	Schweinfurt	38	65	59	48
4	Bayern Hof	38	65	46	46
5	1860	38	64	45	45
6	Nürnberg	38	70	52	42
7	Saarbrücken	38	72	52	41
8	Waldhof	38	52	42	40
9	Bayreuth	38	53	50	40
10	Darmstadt	38	68	62	39
11	Mainz 05	38	63	60	38
12	FC Augsburg	38	61	63	37
13	Rochling	38	56	54	34
14	Homburg	38	71	74	34
15	Greuther	38	40	48	34
16	Stuttgarter	38	52	61	33
17	Heilbronn	38	51	78	30
18	Borussia	38	49	73	28
19	Wormatia	38	36	66	27
20	Mannheim	38	43	85	26

TEMPORADA 1973/1974

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Borussia	30	64	29	65
2	Saarbrücken	30	59	27	62
3	Homburg	30	65	35	59
4	Mainz 05	30	88	49	55
5	Rochling	30	62	39	55
6	Wormatia	30	58	42	53
7	Eintracht	30	55	36	46
8	Pirmasens	30	63	47	43
9	ASV Landau	30	46	41	43
10	Alsenborn	30	41	48	37
11	Südwest	30	44	48	34
12	TuS Koblenz	30	37	58	34
13	VfB Theley	30	37	60	33
14	Sportfreunde	30	48	87	26
15	FV Speyer	30	31	84	16
16	Ensdorf	30	18	86	9

TEMPORADA 1972/1973

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mainz 05	30	80	41	62
2	Rochling	30	53	19	61
3	Pirmasens	30	73	40	58
4	Borussia	30	59	35	54
5	Wormatia	30	70	39	53
6	ASV Landau	30	51	32	49
7	Homburg	30	72	52	48
8	Alsenborn	30	52	47	42
9	Südwest	30	37	37	38
10	VfB Theley	30	39	53	36
11	FV Speyer	30	34	46	34
12	TuS Koblenz	30	37	50	33
13	Saarbrücken	30	37	49	31
14	Sportfreunde	30	43	83	25
15	Eintracht	30	34	83	17
16	Phonix	30	35	100	12

TEMPORADA 1971/1972

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Borussia	30	77	22	67
2	Rochling	30	55	34	59
3	Alsenborn	30	63	38	55
4	Mainz 05	30	57	41	52
5	TuS Koblenz	30	54	34	46
6	Wormatia	30	63	63	45
7	Pirmasens	30	56	49	44
8	ASV Landau	30	41	44	41
9	Homburg	30	38	30	40
10	Südwest	30	41	39	40
11	FV Speyer	30	37	57	37
12	Saarbrücken	30	34	42	36
13	Phonix	30	44	67	32
14	Eintracht	30	51	71	30
15	Frankenthal	30	34	50	27
16	SpVgg	30	29	93	11

TEMPORADA 1970/1971

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pirmasens	30	69	29	63
2	Borussia	30	82	26	62
3	Südwest	30	56	22	61
4	Saarbrücken	30	61	39	55
5	Alsenborn	30	77	49	54
6	TuS Koblenz	30	51	29	54
7	Mainz 05	30	57	49	50
8	Homburg	30	46	50	42
9	ASV Landau	30	36	43	39
10	Rochling	30	43	50	38
11	Wormatia	30	44	58	32
12	Eintracht	30	53	68	31
13	FV Speyer	30	46	66	28
14	Frankenthal	30	33	53	28
15	VfB Theley	30	32	96	16
16	Saar	30	26	85	14

TEMPORADA 1969/1970

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Alsenborn	30	69	23	67
2	Pirmasens	30	68	36	63
3	Südwest	30	45	30	55
4	Borussia	30	63	40	52
5	FV Speyer	30	42	41	46
6	ASV Landau	30	44	31	45
7	TuS Koblenz	30	45	51	45
8	Saarbrücken	30	47	31	44
9	Eintracht	30	36	48	40
10	Saar	30	42	47	39
11	Wormatia	30	50	57	35
12	Mainz 05	30	37	58	35
13	Rochling	30	34	41	31
14	Homburg	30	41	54	28
15	Weisenau	30	38	76	27
16	Friedrichsth	30	41	78	20

TEMPORADA 1968/1969

REGIONALLIGA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Alsenborn	30	69	25	62
2	TuS Koblenz	30	56	23	61
3	Saarbrücken	30	71	28	58
4	Pirmasens	30	65	36	56
5	Borussia	30	54	34	53
6	Saar	30	51	36	47
7	Südwest	30	42	36	46
8	Wormatia	30	49	53	42
9	Homburg	30	40	49	40
10	Eintracht	30	47	45	39
11	FV Speyer	30	40	59	33
12	Mainz 05	30	40	58	32
13	Rochling	30	41	64	32
14	Weisenau	30	33	55	28
15	Frankenthal	30	33	64	26
16	Landsweiler-	30	33	99	11

TEMPORADA 1967/1968

REGIONALLIGA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Alsenborn	30	87	21	75
2	Pirmasens	30	57	31	59
3	TuS Koblenz	30	66	29	58
4	Mainz 05	30	57	32	53
5	Saarbrücken	30	55	37	46
6	Südwest	30	45	32	46
7	Rochling	30	53	47	45
8	Eintracht	30	57	46	43
9	Saar	30	32	35	43
10	Homburg	30	41	53	39
11	Weisenau	30	42	60	37
12	Frankenthal	30	35	63	34
13	Wormatia	30	34	40	33
14	Friedrichsth	30	42	60	29
15	Ludwigshafen	30	27	90	13
16	Mülheim	30	22	76	11

TEMPORADA 1966/1967

REGIONALLIGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Borussia	30	73	27	66
2	Saarbrücken	30	77	31	65
3	Weisenau	30	63	35	58
4	Mainz 05	30	50	35	57
5	Eintracht	30	67	48	53
6	Pirmasens	30	60	31	50
7	Südwest	30	49	34	49
8	Alsenborn	30	58	43	45
9	Rochling	30	42	46	43
10	Saar	30	47	39	41
11	Homburg	30	46	81	31
12	TuS Koblenz	30	35	64	29
13	Frankenthal	30	40	50	28
14	Wormatia	30	31	48	26
15	Phonix	30	40	71	24
16	Germania	30	19	114	3

TEMPORADA 1965/1966

REGIONALLIGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Saarbrücken	30	89	40	58
2	Pirmasens	30	62	31	58
3	TuS Koblenz	30	81	62	56
4	Mainz 05	30	66	39	54
5	Wormatia	30	52	41	46
6	Saar	30	44	39	44
7	Rochling	30	52	58	44
8	Frankenthal	30	55	50	43
9	Alsenborn	30	57	55	41
10	Weisenau	30	61	66	41
11	Südwest	30	46	50	37
12	Phonix	30	36	60	37
13	Eintracht	30	44	49	34
14	Ludwigshafen	30	43	61	31
15	BSC Oppau	30	37	84	30
16	Zweibrücken	30	41	81	25

Competiciones que juega

2. Bundesliga

Pos	Equipos		Pts
1		Kaiserslautern	68
2		Wolfsburg	58
3		Hertha BSC	58
4		Mainz 05	54
5		Stuttgarter Kickers	53
6		Unterhaching	49
7		Eintracht Frankfurt	48
8		Lokomotive Leipzig	46
9		Gutersloh	45
10		KFC Uerdingen 05	44
11		SV Meppen	44
12		Fortuna Köln	42
13		FC Carl Zeiss Jena	42
14		Zwickau	42
15		Waldhof Mannheim	40
16		VfB Lübeck	36
17		Rot-Weiss Essen	29
18		VfB Oldenburg	27

RIVALES EN 2. Bundesliga

RIVALES EN DFB Pokal

USO DE MEMORIA

7,811,464 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.1695
Total Execution Time	0.1710

CADENA URL

/historico/Mainz-Amat/1997

GET DATOS

$_GET['/historico/Mainz-Amat/1997']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0058	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 = 'Mainz-Amat' AND l.year = 1997 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.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=2987 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=2987 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=2987 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 9848
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2987 AND type_rel = 2
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2987 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (1255719,804,1990,2203,1312567) 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 = '2987' AND l.year = 1997 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 = '2987' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 9848 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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 = 22420 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037	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=2987 AND l.year in (1996,1997,1998) 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 (22421,9850) 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 = 9850 AND teamId = 2987
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 22421 AND teamId = 2987
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 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 = 9848 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '2987' 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 = '2987' 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 = '2987' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031	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 events1997 e ON e.player_id = p.id AND e.league_id = 9848 WHERE rp.league_id = 9848 AND rp.teamId = 2987 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.0029	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 events1997 e ON e.player_id = p.id AND e.league_id = 9848 WHERE rp.league_id = 9848 AND rp.teamId = 2987 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035	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 events1997 e ON e.player_id = p.id AND e.league_id = 9848 WHERE rp.league_id = 9848 AND rp.teamId = 2987 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 2987 AND l.year <= 1997 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 9848 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* `tables1996` 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 = 9850 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* `tables1994` 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 = 9857 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044	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* `tables1993` 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 = 9858 AND t.round = 46 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* `tables1992` 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 = 9944 AND t.round = 22 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* `tables1992` 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 = 9946 AND t.round = 32 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* `tables1991` 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 = 9868 AND t.round = 38 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* `tables1989` 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 = 9866 AND t.round = 38 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* `tables1976` 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 = 9927 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* `tables1975` 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 = 9930 AND t.round = 38 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* `tables1974` 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 = 22729 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* `tables1973` 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 = 22725 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* `tables1972` 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 = 22739 AND t.round = 30 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* `tables1971` 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 = 22753 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* `tables1970` 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 = 22834 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 22845 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 22885 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* `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 = 22852 AND t.round = 30 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* `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 = 22861 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 9848 ORDER BY nameShow LIMIT 100

Mainz 05

Mainz 05

Selecciona un equipo

Competiciones que juega

2. Bundesliga

RIVALES EN 2. Bundesliga

RIVALES EN DFB Pokal