06 Dic 78	Finalizado	Ajax	2 - 0	Budapest Honved	0
22 Nov 78	Finalizado	Budapest Honved	4 - 1	Ajax	0
01 Nov 78	Finalizado	Lausanne Sports	0 - 4	Ajax	0
18 Oct 78	Finalizado	Ajax	1 - 0	Lausanne Sports	0
27 Sep 78	Finalizado	Ajax	3 - 0	Athletic	0
13 Sep 78	Finalizado	Athletic	2 - 0	Ajax	1

Eredivisie »

09 Jun 79	Finalizado	Ajax	8 - 1	Twente
04 Jun 79	Finalizado	Ajax	1 - 1	AZ Alkmaar
02 Jun 79	Finalizado	FC Volendam	1 - 3	Ajax
26 May 79	Finalizado	Ajax	4 - 1	ADO Den Haag
19 May 79	Finalizado	Roda JC	1 - 3	Ajax
12 May 79	Finalizado	Ajax	1 - 0	Sparta Rotterdam
06 May 79	Finalizado	Vitesse	0 - 0	Ajax
29 Abr 79	Finalizado	Feyenoord	1 - 1	Ajax
21 Abr 79	Finalizado	Ajax	3 - 2	NEC Nijmegen
16 Abr 79	Finalizado	HFC Haarlem	0 - 1	Ajax
14 Abr 79	Finalizado	Ajax	4 - 1	HFC Haarlem
10 Abr 79	Finalizado	Go Ahead Eagles	1 - 2	Ajax
07 Abr 79	Finalizado	Ajax	6 - 0	MVV Maastricht
01 Abr 79	Finalizado	VVV Venlo	1 - 3	Ajax
25 Mar 79	Finalizado	Ajax	6 - 1	Utrecht
17 Mar 79	Finalizado	PSV	3 - 1	Ajax
11 Mar 79	Finalizado	Ajax	0 - 0	NAC Breda
17 Dic 78	Finalizado	Twente	2 - 3	Ajax
10 Dic 78	Finalizado	AZ Alkmaar	1 - 2	Ajax
02 Dic 78	Finalizado	Ajax	7 - 3	FC Volendam
26 Nov 78	Finalizado	ADO Den Haag	0 - 0	Ajax
12 Nov 78	Finalizado	Ajax	1 - 2	Roda JC
05 Nov 78	Finalizado	Sparta Rotterdam	1 - 0	Ajax
28 Oct 78	Finalizado	Ajax	0 - 0	Feyenoord
22 Oct 78	Finalizado	NEC Nijmegen	0 - 2	Ajax
08 Oct 78	Finalizado	Ajax	4 - 0	Vitesse
30 Sep 78	Finalizado	MVV Maastricht	1 - 0	Ajax
23 Sep 78	Finalizado	Ajax	4 - 0	VVV Venlo
17 Sep 78	Finalizado	Utrecht	1 - 4	Ajax
09 Sep 78	Finalizado	Ajax	2 - 0	PSV
06 Sep 78	Finalizado	PEC Zwolle	0 - 3	Ajax
03 Sep 78	Finalizado	Ajax	4 - 2	PEC Zwolle
30 Ago 78	Finalizado	Ajax	3 - 2	Go Ahead Eagles
26 Ago 78	Finalizado	NAC Breda	1 - 7	Ajax

Trofeo Naranja »

	22 Ago 79	Finalizado	CA Huracán	4 - 3	Ajax			0
	23 Ago 78	Finalizado	Valencia	1 - 0	Ajax			0

Estadísticas

GOLEADORES

AMARILLAS

Plantilla del Ajax Temporada 1978/1979

		Edad	Altura	Peso
Portero
	P. Schrijvers	77	-	-	-	-	-
	Peter Jager	66	-	-	-	-	-
	Sjaak Storm	62	-	-	-	-	-
Defensa
	Guido Pen	64	-	-	-	-	-
	Jan Everse	70	-	-	-	-	2
	Piet Wijnberg	66	-	-	-	-	-
	R. Krol	75	-	-	2	-	1
	W. Meutstege	71	-	-	1	-	2
Centrocampista
	D. Schoenaker	71	180	74	7	-	-
	Freek Lamain	66	-	-	-	-	-
	Hans Erkens	71	-	-	1	-	-
	Kees Zwamborn	72	-	-	-	-	1
	Pim Van Dord	70	-	-	-	-	-
	S. Lerby	66	-	-	16	-	-
Delantero
	F. Arnesen	67	181	72	13	-	-
	Geert Meijer	73	186	-	5	-	-
	Ray Clarke	71	-	-	26	-	1
	Ruud Kaiser	63	-	-	2	-	-
	Simon Tahamata	67	-	-	4	-	1
	Tscheu La Ling	68	-	-	14	-	1

Noticias del Ajax

Ver últimas noticias

El Ajax y el Jablonec, lucha por un hueco en la Europa League

Cristina Serrano de la Cruz - Viernes, 07 Agosto 2015

0 208

El Ajax ya conoce a su rival para la Europa League. Los holandeses se medirán al Jablonec el 20 y el 27 de agosto, siendo el partido de vuelta en casa.

El Ajax se queda sin Champions a las primeras de cambio

BeSoccer - Martes, 04 Agosto 2015

0 464

El Ajax perdió 2-3 ante el Rapid de Viena y fue eliminado en la tercera ronda previa de la Liga de Campeones para sufrir el primer batacazo de una competición en la que sigue adelante el Mónaco tras derrotar 4-0 al Young Boys suizo.

Brutal entrada de Schwab que vio la roja directa

Ángela M. Romero - Viernes, 31 Julio 2015

0 2.037

El centrocampista del SK Rapid Viena Stefan Schwab se lanzó ante su rival con ambas piernas por delante en esta espectacular agresión.

Rapid de Viena y Ajax empatan 2-2

BeSoccer - Jueves, 30 Julio 2015

0 244

El Rápid de Viena y el Ajax de Amsterdam, dos históricos del fútbol europeo, empataron hoy (2-2) en el partido de ida de la tercera ronda preliminar de la Liga de Campeones, cuyos ganadores acceden a la cuarta y última previa a la fase de grupos.

Sorteada la tercera ronda previa de Champions League

Sergio Álvarez - Viernes, 17 Julio 2015

0 3.602

La UEFA ha anunciado hoy los enfrentamientos entre equipo de la tercera ronda de los que ya se conocen los equipos y también qué enfrentamientos habrá entre los vencedores de la segunda fase.

Ver más noticias del equipo»

Competiciones que juega

Eredivisie

Pos	Equipos		Pts
1		Ajax	54
2		Feyenoord	51
3		PSV	49
4		AZ Alkmaar	45
5		Roda JC	44
6		Sparta Rotterdam	33
7		ADO Den Haag	33
8		PEC Zwolle	32
9		Go Ahead Eagles	31
10		NAC Breda	31
11		MVV Maastricht	31
12		Twente	30
13		Utrecht	30
14		Vitesse	29
15		NEC Nijmegen	28
16		HFC Haarlem	25
17		FC Volendam	22
18		VVV Venlo	14

	Copa de Europa : Ajax
	UEFA : Feyenoord, PSV
	Recopa : Twente
	Descenso : FC Volendam, VVV Venlo

RIVALES EN Europa League

RIVALES EN Eredivisie

USO DE MEMORIA

6,039,160 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.7128
Total Execution Time	0.7148

CADENA URL

/Ajax/1979

GET DATOS

$_GET['/Ajax/1979']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0185	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 = 'Ajax' AND l.year = 1979 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.0146	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=98 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=98 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147	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=98 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=98 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0157	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 = 5785
0.0152	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 = 10945
0.0152	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 = 72872
0.0166	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 = '98' AND l.year = 1979 ORDER BY l.year DESC,cat.coefficient DESC
0.0160	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 = '98' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149	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 = 10945 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = 5785 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0199	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1979 as c ON c.league_id = l.id WHERE (c.datateam1 = 98 or c.datateam2 = 98) AND l.year = 1979 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0203	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars1979 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 98 or c.datateam2 = 98) AND l.year = 1979 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0286	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1979 as c ON c.league_id = l.id INNER JOIN events1979 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 98 or c.datateam2 = 98) AND l.year = 1979)
0.0162	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=98 AND l.year in (1978,1979,1980) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (72872,72540,10945,10930,5786) 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.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 5786 AND teamId = 98
0.0162	SELECT count(id) as num_players from rel_players WHERE league_id = 10930 AND teamId = 98
0.0156	SELECT count(id) as num_players from rel_players WHERE league_id = 10945 AND teamId = 98
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 72540 AND teamId = 98
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 72872 AND teamId = 98
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1979` 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 = 5785 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0162	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 events1979 e ON e.player_id = p.id AND e.league_id = 5785 WHERE rp.league_id = 5785 AND rp.teamId = 98 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.0156	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 events1979 e ON e.player_id = p.id AND e.league_id = 5785 WHERE rp.league_id = 5785 AND rp.teamId = 98 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0168	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 events1979 e ON e.player_id = p.id AND e.league_id = 5785 WHERE rp.league_id = 5785 AND rp.teamId = 98 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 98 AND rp.league_id = 5785 AND l.year= 1979 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0150	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=99177 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=99177
0.0151	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1979 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=99177 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0149	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1979 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=99177 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0149	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1979 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=99177 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0148	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1979 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=99177 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0148	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events1979 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=99177 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0146	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 = 5785 ORDER BY nameShow LIMIT 100


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Ajax

Información sobre Ajax

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Ajax