29 Jun 03	Finalizado	Racing Ferrol	0 - 1	Tenerife	0
21 Jun 03	Finalizado	Real Murcia	5 - 0	Racing Ferrol	0
14 Jun 03	Finalizado	Racing Ferrol	1 - 0	Levante	1
08 Jun 03	Finalizado	Córdoba CF	1 - 2	Racing Ferrol	0
01 Jun 03	Finalizado	Racing Ferrol	1 - 1	UD Salamanca	0
24 May 03	Finalizado	Poli Ejido	1 - 1	Racing Ferrol	0
17 May 03	Finalizado	Racing Ferrol	2 - 1	Albacete	0
11 May 03	Finalizado	Leganés	1 - 0	Racing Ferrol	0
04 May 03	Finalizado	Racing Ferrol	2 - 1	Real Sporting	0
27 Abr 03	Finalizado	Xerez CD	1 - 1	Racing Ferrol	0
20 Abr 03	Finalizado	Racing Ferrol	1 - 0	Elche	0
13 Abr 03	Finalizado	Numancia	4 - 2	Racing Ferrol	0
06 Abr 03	Finalizado	Racing Ferrol	2 - 0	CD Badajoz	0
30 Mar 03	Finalizado	Terrassa FC	2 - 1	Racing Ferrol	0
22 Mar 03	Finalizado	Racing Ferrol	0 - 1	Eibar	0
16 Mar 03	Finalizado	Almería	3 - 2	Racing Ferrol	0
08 Mar 03	Finalizado	Racing Ferrol	1 - 2	Real Zaragoza	0
02 Mar 03	Finalizado	Getafe	3 - 1	Racing Ferrol	0
23 Feb 03	Finalizado	Racing Ferrol	1 - 1	Real Oviedo	0
15 Feb 03	Finalizado	SD Compostela	1 - 1	Racing Ferrol	0
08 Feb 03	Finalizado	Racing Ferrol	1 - 2	Las Palmas	0
01 Feb 03	Finalizado	Tenerife	4 - 0	Racing Ferrol	0
26 Ene 03	Finalizado	Racing Ferrol	0 - 3	Real Murcia	0
19 Ene 03	Finalizado	Levante	1 - 0	Racing Ferrol	0
11 Ene 03	Finalizado	Racing Ferrol	0 - 0	Córdoba CF	0
05 Ene 03	Finalizado	UD Salamanca	0 - 0	Racing Ferrol	0
21 Dic 02	Finalizado	Racing Ferrol	1 - 1	Poli Ejido	0
14 Dic 02	Finalizado	Albacete	2 - 0	Racing Ferrol	0
08 Dic 02	Finalizado	Racing Ferrol	1 - 1	Leganés	0
30 Nov 02	Finalizado	Real Sporting	3 - 1	Racing Ferrol	0
24 Nov 02	Finalizado	Racing Ferrol	2 - 1	Xerez CD	0
17 Nov 02	Finalizado	Elche	1 - 2	Racing Ferrol	0
10 Nov 02	Finalizado	Racing Ferrol	1 - 0	Numancia	0
02 Nov 02	Finalizado	CD Badajoz	1 - 0	Racing Ferrol	0
27 Oct 02	Finalizado	Racing Ferrol	1 - 1	Terrassa FC	0
19 Oct 02	Finalizado	Eibar	1 - 0	Racing Ferrol	0
13 Oct 02	Finalizado	Racing Ferrol	1 - 1	Almería	0
06 Oct 02	Finalizado	Real Zaragoza	2 - 2	Racing Ferrol	0
29 Sep 02	Finalizado	Racing Ferrol	2 - 1	Getafe	0
21 Sep 02	Finalizado	Real Oviedo	1 - 2	Racing Ferrol	0
14 Sep 02	Finalizado	Racing Ferrol	1 - 1	SD Compostela	0
31 Ago 02	Finalizado	Las Palmas	2 - 0	Racing Ferrol	0

Copa del Rey »

	05 Nov 02	Finalizado	Racing Ferrol	3 - 4	RC Deportivo			0
	08 Sep 02	Finalizado	UD Salamanca	0 - 4	Racing Ferrol			0

Estadísticas

GOLEADORES

AMARILLAS

Rambier13

Raul12

ROJAS

Ramis2

Rambier2

Vosahlo1

E. Jaio1

Pablo1

Raul1

D. Pezzarossi1

Alberto Méndez1

Plantilla del Racing Ferrol Temporada 2002/2003

		Edad	Altura	Peso
Portero
	Bello Amigo	45	182	80	-	-	1
	De Navas	47	186	85	-	-	-
Defensa
	Burle	50	187	85	1	-	8
	E. Jaio	43	187	86	1	1	8
	Iñigo	51	180	71	2	-	6
	Pablo	48	174	70	3	1	4
	Rambier	42	180	72	-	2	13
	Ramis	53	190	80	1	2	6
	Raul	47	180	71	-	1	12
	Sito Castro	43	174	73	-	-	3
	Vosahlo	49	180	78	-	1	5
Centrocampista
	Alberto Méndez	49	180	78	4	1	8
	Andrés Martínez	51	186	82	-	-	4
	Boughanem	48	180	78	-	-	4
	David Pérez	47	180	71	1	-	5
	Manel	51	178	74	-	-	2
	Mickaël Marsiglia	48	181	75	-	-	1
	Olivares	47	170	72	1	-	2
	Razic	41	187	79	1	-	2
	Toril	50	179	76	2	-	4
Delantero
	Ángel Cuéllar	51	173	70	12	-	6
	D. Pezzarossi	44	189	95	5	1	4
	Dutil	43	182	80	1	-	2
	Graieb	49	176	73	-	-	4
	I. Uche	40	175	73	2	-	1
	J. Delgado	48	186	81	-	-	-
	Sotaro Yasunaga	48	176	71	1	-	1

Noticias del Racing Ferrol

Ver últimas noticias

Piette llega al Racing de Ferrol cedido por el Dépor

BeSoccer - Sábado, 08 Agosto 2015

0 581

El Deportivo ha hecho oficial el acuerdo al que ha llegado con el Racing de Ferrol, de Segunda División B, para la cesión del internacional canadiense Sam Piette.

Sorteadas la primera y la segunda ronda de la Copa del Rey

Sergio Álvarez - Martes, 21 Julio 2015

22 15.650

En ella toman parte los equipos de Tercera, Segunda División B y Segunda División.

Primera jornada del Grupo 1 de la Segunda B

Sergio Álvarez - Jueves, 16 Julio 2015

0 3.288

La RFEF ha dado a conocer el calendario de la primera jornada de la temporada en Segunda B, en el que destaca el derbi entre el filial del Valladolid B y la Cultural Leonesa.

Así queda el grupo I de Segunda B

Isabel Ruiz - Martes, 14 Julio 2015

3 4.651

Esta mañana, la Asamblea de la Federación Española de Fútbol (RFEF) ha aprobado la propuesta de grupos para la temporada 2015-16 que la semana pasada efectuó la Comisión de Segunda B de la RFEF.

El Deportivo cierra el calendario de amistosos

BeSoccer - Miércoles, 01 Julio 2015

0 226

El Deportivo ha cerrado el calendario de partidos amistosos de pretemporada, en la que afrontará nueve citas de preparación, dos de ellas en Gran Bretaña, antes de debutar en la Liga BBVA a mediados de agosto.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Real Murcia	79
2		Real Zaragoza	72
3		Albacete	71
4		Levante	65
5		Las Palmas	64
6		Xerez CD	64
7		UD Salamanca	60
8		Tenerife	57
9		SD Compostela	55
10		Real Sporting	53
11		Getafe	53
12		Terrassa FC	52
13		Poli Ejido	52
14		Numancia	52
15		Córdoba CF	50
16		Elche	50
17		Eibar	50
18		Almería	50
19		Leganés	48
20		Racing Ferrol	46
21		Real Oviedo	40
22		CD Badajoz	38

Pos

Equipos

Pts

	Ascenso : Real Murcia, Real Zaragoza, Albacete
	Descenso : SD Compostela, Racing Ferrol, Real Oviedo, CD Badajoz

Ascenso : Real Murcia, Real Zaragoza, Albacete

Descenso : SD Compostela, Racing Ferrol, Real Oviedo, CD Badajoz

USO DE MEMORIA

6,042,672 bytes

BENCHMARKS

Loading Time Base Classes	0.0034
Controller Execution Time ( Home / Category )	0.1676
Total Execution Time	0.1711

CADENA URL

/Racing-Club-Ferrol/2003

GET DATOS

$_GET['/Racing-Club-Ferrol/2003']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0044	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 = 'Racing-Club-Ferrol' AND l.year = 2003 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=2055 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=2055 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=2055 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2055 AND type_rel = 2
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2055 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 (1100,2598,2826,3254,5486) ORDER BY n.cover_points DESC, update_date DESC
0.0053	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 = '2055' AND l.year = 2003 ORDER BY l.year DESC,cat.coefficient DESC
0.0064	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 = '2055' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	(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 calendars2003 as c ON c.league_id = l.id WHERE (c.datateam1 = 2055 or c.datateam2 = 2055) AND l.year = 2003 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0048	(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 calendars2003 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 = 2055 or c.datateam2 = 2055) AND l.year = 2003 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0040	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2003 as c ON c.league_id = l.id INNER JOIN events2003 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 = 2055 or c.datateam2 = 2055) AND l.year = 2003)
0.0038	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=2055 AND l.year in (2002,2003,2004) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (45436,21477,574,176) 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.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 574 AND teamId = 2055
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 176 AND teamId = 2055
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 21477 AND teamId = 2055
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 45436 AND teamId = 2055
0.0034	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 events2003 e ON e.player_id = p.id AND e.league_id = 573 WHERE rp.league_id = 573 AND rp.teamId = 2055 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 events2003 e ON e.player_id = p.id AND e.league_id = 573 WHERE rp.league_id = 573 AND rp.teamId = 2055 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2003 e ON e.player_id = p.id AND e.league_id = 573 WHERE rp.league_id = 573 AND rp.teamId = 2055 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 2055 AND rp.league_id = 573 AND l.year= 2003 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0025	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=14177 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=14177
0.0027	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14177 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.0027	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14177 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0029	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14177 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0024	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14177 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0031	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 events2003 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14177 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Racing Ferrol

Información sobre Racing Ferrol

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Racing Ferrol

Estadísticas

Plantilla del Racing Ferrol Temporada 2002/2003

Noticias del Racing Ferrol

Racing Ferrol

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Segunda División