Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

AD Estudiantil

Temporada 2019/2020

TEMPORADA 2019/2020

TERCERA GALICIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Rois	19	51	9	47
2	Carcacía	18	47	13	42
3	Ulla	19	32	23	36
4	Milladoiro	19	48	35	32
5	Camporrapado	19	26	20	32
6	Viduido CF	18	31	25	26
7	Portomouro	18	29	30	24
8	Brion SD	18	29	34	23
9	Guimarei	19	22	31	22
10	Resmon	19	34	39	21
11	Estudiantil	19	29	37	20
12	Boqueixon	19	37	52	18
13	Raris CF	19	29	49	14
14	Calo Sr B	19	22	69	12

TEMPORADA 2018/2019

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	As Pontes	38	123	40	92
2	CSD Arzua	38	88	45	81
3	Viveiro	38	101	52	79
4	SD Sarriana	38	71	39	76
5	Noia	38	80	51	76
6	Ribadeo FC	38	63	58	67
7	SD Sofán	38	74	59	56
8	Dubra	38	67	61	56
9	At. Arteixo	38	61	46	55
10	Coruña	38	54	50	52
11	Boimorto CF	38	65	58	51
12	Tirso	38	58	61	49
13	Puebla CF	38	48	53	49
14	Xallas FC	38	56	63	49
15	CD Foz	38	58	76	48
16	Negreira	38	45	51	46
17	Club Ordenes	38	53	70	41
18	SD Agolada	38	47	73	26
19	CD Castro	38	36	138	10
20	Estudiantil	38	28	132	6

TEMPORADA 2017/2018

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Lugo B	38	83	31	79
2	UD Paiosaco	38	66	32	79
3	As Pontes	38	85	34	77
4	Ribadeo FC	38	71	58	67
5	Dubra	38	58	45	62
6	CD Castro	38	59	50	59
7	CSD Arzua	38	51	48	56
8	At. Arteixo	38	61	62	54
9	Xallas FC	38	48	48	51
10	Estudiantil	38	45	48	49
11	Tirso	38	52	55	48
12	SD Sofán	38	55	61	48
13	Club Ordenes	38	56	55	47
14	Viveiro	38	67	69	46
15	Boimorto CF	38	46	67	46
16	Residencia	38	52	63	44
17	Betanzos CF	38	50	66	44
18	CF Dumbría	38	41	78	41
19	Atl.	38	38	67	32
20	Outeiro	38	31	78	28

TEMPORADA 2016/2017

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Noia	38	62	34	79
2	Laracha	38	82	45	77
3	Estudiantil	38	74	38	76
4	CD Lugo B	38	87	36	73
5	UD Paiosaco	38	64	41	65
6	Atl.	38	55	50	61
7	Ribadeo FC	38	65	60	60
8	Viveiro	38	68	44	58
9	CSD Arzua	38	73	40	57
10	At. Arteixo	38	76	66	53
11	Xallas FC	38	52	48	53
12	SD Sofán	38	57	61	53
13	Betanzos CF	38	51	49	51
14	Galicia	38	53	55	47
15	Club Lemos	38	45	62	44
16	Bertamiráns	38	40	62	39
17	SD Chantada	38	42	76	36
18	Soneira Sd	38	46	88	35
19	SD Sarriana	38	30	75	23
20	Sporting	38	23	115	12

TEMPORADA 2015/2016

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Castro	38	67	31	78
2	Dubra	38	79	44	76
3	CSD Arzua	38	58	40	76
4	At. Arteixo	38	74	28	74
5	Bertamiráns	38	56	31	66
6	UD Paiosaco	38	55	39	63
7	Sporting	38	44	32	61
8	Viveiro	38	62	48	56
9	Laracha	38	62	53	53
10	Club Lemos	38	59	48	51
11	SD Chantada	38	41	41	50
12	SD Sarriana	38	39	41	48
13	Xallas FC	38	41	46	47
14	Estudiantil	38	48	52	46
15	Milagrosa	38	41	62	44
16	Villestro	38	49	63	39
17	Puebla	38	41	64	31
18	Cidade	38	49	96	26
19	CF Dumbría	38	31	86	22
20	O Val	38	31	82	21

TEMPORADA 2014/2015

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Negreira	38	74	41	82
2	Galicia	38	64	47	72
3	Noia	38	52	37	69
4	Dubra	38	67	53	66
5	At. Arteixo	38	83	48	65
6	Sporting	38	61	56	57
7	Viveiro	38	53	60	55
8	CD Castro	38	69	53	53
9	Cidade	38	68	69	51
10	CSD Arzua	38	55	58	50
11	CF Dumbría	38	43	52	50
12	Estudiantil	38	57	43	49
13	SD Chantada	38	53	58	49
14	O Val	38	48	66	47
15	Xallas FC	38	52	58	45
16	SD Sarriana	38	45	59	44
17	Residencia	38	45	68	44
18	Atl.	38	51	69	39
19	Betanzos CF	38	46	72	29
20	CD Dorneda	38	53	72	28

TEMPORADA 2013/2014

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ribadeo FC	38	76	37	84
2	Bergantiños	38	65	26	83
3	Silva SD	38	74	41	74
4	Viveiro	38	60	34	72
5	CF Dumbría	38	63	31	67
6	Estudiantil	38	50	37	61
7	Sporting	38	52	41	61
8	Dubra	38	54	48	55
9	Residencia	38	51	52	54
10	Galicia	38	61	57	49
11	Cidade	38	54	50	49
12	SD Chantada	38	43	47	47
13	CD Castro	38	41	44	45
14	Xallas FC	38	44	65	40
15	O Val	38	41	63	39
16	Tirso	38	37	58	38
17	Ud Carral	38	42	72	37
18	Club Lemos	38	49	80	35
19	Narón BP	38	47	78	33
20	Soneira Sd	38	41	84	24

Competiciones que juega

Tercera Galicia Grupo 7

Pos	Equipos		Pts
1		Rois	47
2		Carcacía	42
3		Val Do Ulla B	36
4		Milladoiro SD	32
5		Camporrapado	32
6		Viduido CF	26
7		Portomouro	24
8		Brion SD	23
9		Guimarei	22
10		Resmon	21
11		AD Estudiantil	20
12		EF Boqueixon	18
13		Raris CF	14
14		Calo Sr B	12

RIVALES EN Tercera Galicia

USO DE MEMORIA

5,632,736 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1070
Total Execution Time	0.1082

CADENA URL

/historico/Agrupacion-Estudiantil

GET DATOS

$_GET['/historico/Agrupacion-Estudiantil']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0023	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 = 'Agrupacion-Estudiantil' 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.0033	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 = 'Agrupacion-Estudiantil' 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=11894 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=11894 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=11894 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=11894 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=11894 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=11894 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=11894 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=11894 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028	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 = 51556
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11894 AND type_rel = 2
0.0022	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 = '11894' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '11894' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = '11894' 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 = 51556 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=11894 AND l.year in (2019,2020,2021) 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 (51556,44618) 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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 44618 AND teamId = 11894
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 51556 AND teamId = 11894
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 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 = 51556 AND t.round = 19 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '11894' 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 = '11894' and rp.type = 4
0.0021	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 = '11894' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020	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 events2020 e ON e.player_id = p.id AND e.league_id = 51556 WHERE rp.league_id = 51556 AND rp.teamId = 11894 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.0019	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 events2020 e ON e.player_id = p.id AND e.league_id = 51556 WHERE rp.league_id = 51556 AND rp.teamId = 11894 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 events2020 e ON e.player_id = p.id AND e.league_id = 51556 WHERE rp.league_id = 51556 AND rp.teamId = 11894 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 11894 AND l.year <= 2020 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* `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 = 51556 AND t.round = 19 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* `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 = 44618 AND t.round = 38 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* `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 = 39342 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* `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 = 16696 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* `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 = 4049 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* `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 = 2587 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 51556 ORDER BY nameShow LIMIT 100

AD Estudiantil

AD Estudiantil

Selecciona un equipo

Competiciones que juega

Tercera Galicia Grupo 7

RIVALES EN Tercera Galicia