19 May 13	Finalizado	Real Avilés Industrial	0 - 2	Leganés	59
12 May 13	Finalizado	Sporting Atlético	0 - 0	Real Avilés Industrial	45
05 May 13	Finalizado	Caudal Deportivo	2 - 1	Real Avilés Industrial	118
28 Abr 13	Finalizado	Real Avilés Industrial	1 - 0	Marino de Luanco	50
21 Abr 13	Finalizado	CD Ourense	5 - 3	Real Avilés Industrial	67
14 Abr 13	Finalizado	Real Avilés Industrial	0 - 0	Coruxo	89
06 Abr 13	Finalizado	Rayo Vallecano B	1 - 1	Real Avilés Industrial	25
29 Mar 13	Finalizado	Real Avilés Industrial	2 - 3	Getafe B	60
24 Mar 13	Finalizado	Marino	2 - 1	Real Avilés Industrial	48
17 Mar 13	Finalizado	Real Avilés Industrial	0 - 3	Tenerife	253
10 Mar 13	Finalizado	UD Salamanca	1 - 1	Real Avilés Industrial	212
03 Mar 13	Finalizado	Real Avilés Industrial	2 - 0	Guijuelo	30
24 Feb 13	Finalizado	RSD Alcalá	1 - 0	Real Avilés Industrial	33
17 Feb 13	Finalizado	Real Avilés Industrial	1 - 2	Atlético B	32
10 Feb 13	Finalizado	UD Sanse	1 - 0	Real Avilés Industrial	17
03 Feb 13	Finalizado	Real Avilés Industrial	0 - 4	Real Madrid C	26
27 Ene 13	Finalizado	Fuenlabrada	4 - 1	Real Avilés Industrial	36
20 Ene 13	Finalizado	Real Avilés Industrial	2 - 1	Zamora	188
13 Ene 13	Finalizado	Real Oviedo	2 - 0	Real Avilés Industrial	273
05 Ene 13	Finalizado	Leganés	3 - 2	Real Avilés Industrial	216
22 Dic 12	Finalizado	Real Avilés Industrial	1 - 1	Sporting Atlético	24
16 Dic 12	Finalizado	Real Avilés Industrial	1 - 3	Caudal Deportivo	77
09 Dic 12	Finalizado	Marino de Luanco	0 - 1	Real Avilés Industrial	42
02 Dic 12	Finalizado	Real Avilés Industrial	1 - 1	CD Ourense	89
25 Nov 12	Finalizado	Coruxo	2 - 0	Real Avilés Industrial	135
18 Nov 12	Finalizado	Real Avilés Industrial	4 - 0	Rayo Vallecano B	48
11 Nov 12	Finalizado	Getafe B	1 - 2	Real Avilés Industrial	56
04 Nov 12	Finalizado	Real Avilés Industrial	1 - 0	Marino	18
28 Oct 12	Finalizado	Tenerife	1 - 0	Real Avilés Industrial	251
21 Oct 12	Finalizado	Real Avilés Industrial	0 - 0	UD Salamanca	123
13 Oct 12	Finalizado	Guijuelo	0 - 2	Real Avilés Industrial	45
06 Oct 12	Finalizado	Real Avilés Industrial	2 - 0	RSD Alcalá	19
30 Sep 12	Finalizado	Atlético B	3 - 1	Real Avilés Industrial	13
23 Sep 12	Finalizado	Real Avilés Industrial	2 - 1	UD Sanse	22
16 Sep 12	Finalizado	Real Madrid C	0 - 1	Real Avilés Industrial	39
09 Sep 12	Finalizado	Real Avilés Industrial	2 - 1	Fuenlabrada	27
02 Sep 12	Finalizado	Zamora	1 - 4	Real Avilés Industrial	122
25 Ago 12	Finalizado	Real Avilés Industrial	0 - 2	Real Oviedo	757

Estadísticas

GOLEADORES

AMARILLAS

Jeffrey16

Salva15

Ito1

ROJAS

Miguel1

Boris1

Juan Díaz1

Naya1

Jeffrey1

Plantilla del Real Avilés Industrial Temporada 2012/2013

		Edad	Altura	Peso
Portero
	Davo	37	182	76	-	-	-
	José Luis	30	178	77	-	-	-
	Rebollo	41	185	86	-	-	1
Defensa
	Aitor Tornavaca	48	175	70	1	-	9
	Álex Cruz	37	180	72	-	1	10
	Boris	43	184	85	-	1	9
	H. Garcia	32	178	73	-	-	3
	Iván M.	33	-	-	-	-	-
	Jairo Casal	31	185	77	-	-	-
	Jeffrey	39	180	75	-	1	16
	Jorge Rodríguez	43	184	78	-	-	1
	Salva	39	182	77	1	-	15
	Sietes	50	177	72	-	-	-
Centrocampista
	Abraham	40	184	82	3	-	5
	Borja Prieto	37	180	74	5	-	8
	Cristian Sánchez	31	185	82	-	-	1
	G. Noriega	42	173	67	3	2	12
	Geni	44	179	83	8	-	5
	Juan Díaz	46	186	82	8	1	19
	Juanín	32	182	71	-	-	1
	Milio	-	171	63	-	-	-
35	R. Rodríguez	31	173	-	-	-	-
	Rony	30	177	68	-	-	1
	Sergio	33	170	76	-	-	1
Delantero
	Álvaro Viña	28	-	-	-	-	-
	Cristian	31	178	70	-	-	1
	Ito	32	180	70	-	-	1
	Jony	32	179	80	1	-	3
	Miguel	45	195	88	3	1	4
	Naya	34	178	74	9	1	9
	Yoni	32	170	73	-	-	1

Noticias del Real Avilés Industrial

Ver últimas noticias

Álex Arias, de la prisión al césped

BeSoccer - Domingo, 28 Agosto 2016

1 4.501

El Real Avilés ha anunciado la incorporación de Álex Arias, jugador que cumple una condena de cuatro años y que tras fichar por el conjunto avilesino disfrutará del régimen de semilibertad.

El Real Avilés quiere a Álex Arias, actualmente condenado a cuatro años de cárcel

BeSoccer - Martes, 05 Julio 2016

4 2.491

El Real Avilés se muestra interesado en fichar al jugador avilesino Álex Arias, que cumple condena de cuatro años de cárcel por el doble atropello mortal que tuvo lugar en el municipio salmantino de Casillas de Flores en agosto de 2011.

Álex García firma con el Avilés

BeSoccer - Miércoles, 29 Junio 2016

0 1.444

El atacante ha rescindido su contrato con el Levante.

Así quedaron los emparejamientos de la fase de ascenso a Segunda B

Enrique Salvatierra - Lunes, 16 Mayo 2016

7 13.869

Vive con nosotros el sorteo que se está celebrando en Las Rozas y del que saldrán los emparejamientos de la primera ronda del play off de ascenso a Segunda División B.

El Logroñés ficha al ex del Avilés Borja García

BeSoccer - Lunes, 29 Junio 2015

0 842

La Unión Deportiva Logroñés ha contratado a Borja García Santamaría, defensa central de 25 años procedente del Real Avilés CF de Segunda División B.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Tenerife	73
2		Leganés	70
3		Real Oviedo	66
4		Caudal Deportivo	60
5		Real Madrid C	57
6		Fuenlabrada	56
7		Atlético B	54
8		UD Salamanca	53
9		Coruxo	52
10		Getafe B	48
11		Marino de Luanco	47
12		CD Ourense	47
13		Sporting Atlético	47
14		Real Avilés Industrial	46
15		Guijuelo	45
16		Zamora	43
17		UD Sanse	43
18		RSD Alcalá	41
19		Rayo Vallecano B	36
20		Marino	35

Pos

Equipos

Pts

Real Avilés Industrial

USO DE MEMORIA

5,917,976 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.5506
Total Execution Time	0.5526

CADENA URL

/Real-Aviles-Ind/2013

GET DATOS

$_GET['/Real-Aviles-Ind/2013']

POST DATOS

No hay datos POST existentes

CONSULTAS (28)

0.0207	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 = 'Real-Aviles-Ind' AND l.year = 2013 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.0133	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=2096 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=2096 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 = 1902
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 = '2096' AND l.year = 2013 ORDER BY l.year DESC,cat.coefficient DESC
0.0141	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 = '2096' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 1902 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	(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 calendars2013 as c ON c.league_id = l.id WHERE (c.datateam1 = 2096 or c.datateam2 = 2096) AND l.year = 2013 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0132	(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 calendars2013 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 = 2096 or c.datateam2 = 2096) AND l.year = 2013 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0148	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2013 as c ON c.league_id = l.id INNER JOIN events2013 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 = 2096 or c.datateam2 = 2096) AND l.year = 2013)
0.0133	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=2096 AND l.year in (2012,2013,2014) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (3672,2466,2399,1841,1399) 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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 2466 AND teamId = 2096
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 1399 AND teamId = 2096
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 3672 AND teamId = 2096
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 1841 AND teamId = 2096
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 2399 AND teamId = 2096
0.0160	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 events2013 e ON e.player_id = p.id AND e.league_id = 1902 WHERE rp.league_id = 1902 AND rp.teamId = 2096 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.0165	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 events2013 e ON e.player_id = p.id AND e.league_id = 1902 WHERE rp.league_id = 1902 AND rp.teamId = 2096 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163	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 events2013 e ON e.player_id = p.id AND e.league_id = 1902 WHERE rp.league_id = 1902 AND rp.teamId = 2096 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 = 2096 AND rp.league_id = 1902 AND l.year= 2013 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0143	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=39993 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0126	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=39993
0.0136	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39993 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.0138	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39993 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0143	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39993 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39993 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0134	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39993 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Real Avilés Industrial

Información sobre Real Avilés Industrial

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Tercera División Grupo 2

Copa del Rey

Segunda División B Grupo 1

Segunda División

Partidos Amistosos

Regional

Tercera División - Play Offs Ascenso

Copa Federación

Copa Federación - Fase Autonómica Grupo 8

Segunda Federación Grupo 1

Segunda B - Play Offs Ascenso

Segunda - Play Offs Ascenso

Segunda Federación - Play Offs Ascenso

Segunda B - Play Offs Permanencia

Play Offs Ascenso a Segunda División RFEF

Tercera División - 2ª Fase ascenso a Segunda RFEF Grupo 2

Partidos del Real Avilés Industrial

Estadísticas

Plantilla del Real Avilés Industrial Temporada 2012/2013

Noticias del Real Avilés Industrial

Álex Arias, de la prisión al césped

El Real Avilés quiere a Álex Arias, actualmente condenado a cuatro años de cárcel

Álex García firma con el Avilés

Así quedaron los emparejamientos de la fase de ascenso a Segunda B

El Logroñés ficha al ex del Avilés Borja García

Real Avilés Industrial

Selecciona un equipo

Competiciones que juega

Segunda División B Grupo 1

RIVALES EN Segunda División.