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.

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

Alhaurín de la Torre B

Temporada 2019/2020

TEMPORADA 2019/2020

3ª ANDALUZA MÁLAGA
Equipo		PJ	GF	GC	Puntos
1	Alhaurín	23	61	12	59
2	Félix	23	75	28	57
3	Tiro Pichón	21	52	24	51
4	Yunquera	22	42	35	40
5	Ardales	22	53	32	38
6	Borge CD	22	55	43	33
7	Estación	22	52	57	30
8	CD La Cala	20	44	57	28
9	Pablo	22	43	55	24
10	Candor CF	21	39	48	23
11	CD Álora	20	31	34	21
12	Alozaina CD	22	28	54	21
13	Arriate	22	36	63	19
14	Internaciona	21	31	53	16
15	Guaro	23	33	80	8

TEMPORADA 2016/2017

2ª ANDALUZA MÁLAGA
Equipo		PJ	GF	GC	Puntos
1	Villanueva	32	74	39	73
2	CD Trabuco	32	67	48	71
3	Palo	32	89	47	70
4	CD Torrox	32	81	38	69
5	Benagalbón	32	74	54	67
6	Zenit	32	79	45	64
7	Atlético	32	74	68	53
8	Mijas	32	77	59	52
9	Alhaurín	32	62	74	49
10	CD Monda	32	48	50	46
11	Atlético	32	56	75	43
12	Sierra	32	51	68	42
13	Guadalmar	32	58	88	40
14	Nerja	32	58	63	38
15	Algarrobo	32	38	78	34
16	Alhaurino	32	53	80	33
17	CD Álora	32	44	109	21
18	Fútbol Base	0	0	0	0

TEMPORADA 2015/2016

3ª ANDALUZA MÁLAGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alhaurín	20	62	19	46
2	Palo	18	63	20	45
3	Sierra	19	40	20	37
4	Guadalmar	19	45	30	37
5	CD Almargen	20	62	38	33
6	Mollina CD	19	42	37	28
7	Pizarra CF	18	35	29	26
8	Villanueva	20	28	45	20
9	Marcos	19	30	72	12
10	Valle	20	42	79	11
11	Cuevas	16	21	81	4
12	Marbella	0	0	0	0

TEMPORADA 2014/2015

3ª ANDALUZA MÁLAGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Estepona	23	99	18	64
2	Pedro U.D.	24	61	22	58
3	Alhaurín	24	64	21	57
4	Torremolinos	24	67	23	48
5	Guaro	24	38	57	29
6	Alozaina CD	23	38	52	26
7	UD Ojen	23	31	50	25
8	Nueva	19	40	38	24
9	Atlco.	24	47	63	24
10	Estepona	24	32	49	24
11	C.D. Cortes	23	39	58	24
12	CD Monda	23	37	82	20
13	Candor CF	22	22	82	7
14	C.D.	0	0	0	0

TEMPORADA 2008/2009

2ª ANDALUZA MÁLAGA
Equipo		PJ	GF	GC	Puntos
1	Atlco.	34	101	25	83
2	Pedro	34	77	32	71
3	Malaka	34	69	49	66
4	CF Alameda	34	73	72	55
5	Atco. Lauro	34	59	48	53
6	Campillos	34	60	55	52
7	CD Rincón	34	50	44	50
8	Churriana	34	56	62	48
9	Alhaurín	34	49	58	46
10	CD Cártama	34	57	50	45
11	Marbella B	34	73	74	41
12	Mijas	34	42	44	41
13	Casabermeja	34	46	59	40
14	La Unidad	34	51	90	39
15	Archidona	34	50	68	35
16	CD Torrox	34	54	86	34
17	CD Monda	34	49	81	31
18	Cala Míjas	34	39	58	27

TEMPORADA 2003/2004

2ª ANDALUZA MÁLAGA
Equipo		PJ	GF	GC	Puntos
1	CD Ronda	30	77	29	73
2	Fuengirola	30	104	24	72
3	Torremolinos	30	67	36	62
4	Unión	30	59	38	57
5	Vélez CF	30	54	34	52
6	Manilva-Sabi	30	63	45	52
7	Alhaurín	30	52	28	50
8	Torre	30	41	34	46
9	CD Mijas	30	45	51	37
10	CD Álora	30	45	56	37
11	Benagalbón	30	38	50	37
12	Nerja	30	39	59	37
13	Marbella B	30	56	59	35
14	Nueva	30	38	83	28
15	CD Cártama	30	40	63	27
16	Julian	30	32	62	27
17	Benamiel	30	32	59	25
18	Sierra	30	33	105	16

TEMPORADA 2002/2003

2ª ANDALUZA MÁLAGA
Equipo		PJ	GF	GC	Puntos
1	CD Ronda	36	98	29	81
2	Pedro	36	92	40	76
3	Fuengirola	36	68	34	68
4	Alhaurín	36	58	33	64
5	Torre	36	71	51	64
6	Marbella B	36	71	51	61
7	Benamiel	36	74	59	56
8	Manilva-Sabi	36	80	60	55
9	Unión	36	52	43	55
10	CD Mijas	36	47	55	52
11	Torremolinos	36	62	55	50
12	CD Álora	36	63	88	46
13	CD Cártama	36	52	71	44
14	Benagalbón	36	38	60	41
15	Mijas	36	51	66	40
16	El Palo FC	36	47	79	39
17	Cala Míjas	36	50	71	37
18	Antequera	36	38	99	12

Competiciones que juega

3ª Andaluza Málaga

Pos	Equipos		Pts
1		Alhaurín de la Torre B	59
2		CD San Félix	57
3		CD Tiro Pichón	51
4		Yunquera Paraiso Pinsapo	40
5		Ardales Atletico	38
6		Borge CD	33
7		At. Estación B	30
8		CD La Cala	28
9		Pablo Picasso CD	24
10		Candor CF	23
11		CD Álora	21
12		Alozaina CD	21
13		Arriate CD AD Setenil	19
14		Internacional de la Paz	16
15		Guaro Atletic Ass. Dva.	8

	Ascenso : Alhaurín de la Torre B, CD San Félix, CD Tiro Pichón, Yunquera Paraiso Pinsapo

RIVALES EN 3ª Andaluza Mála.

USO DE MEMORIA

5,457,136 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.4892
Total Execution Time	0.4905

CADENA URL

/historico/Alhaurin-Torre-B/2020

GET DATOS

$_GET['/historico/Alhaurin-Torre-B/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0155	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 = 'Alhaurin-Torre-B' AND l.year = 2020 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.0130	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=64240 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=64240 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64240 AND type_rel = 2
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 64240 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129	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 (53002,53102,53138,53148,53151) ORDER BY n.cover_points DESC, update_date DESC
0.0130	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 = '64240' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0132	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 = '64240' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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 = '64240' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 51500 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	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=64240 AND l.year in (2019,2020,2021) 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 (59416,51500) 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.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 59416 AND teamId = 64240
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 51500 AND teamId = 64240
0.0130	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 = 51500 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126	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 = '64240' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '64240' and rp.type = 4
0.0128	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 = '64240' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128	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 = 51500 WHERE rp.league_id = 51500 AND rp.teamId = 64240 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.0130	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 = 51500 WHERE rp.league_id = 51500 AND rp.teamId = 64240 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 51500 WHERE rp.league_id = 51500 AND rp.teamId = 64240 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 = 64240 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0139	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 = 51500 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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* `tables2017` 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 = 34424 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 16928 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 4118 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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* `tables2009` 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 = 2978 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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* `tables2004` 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 = 2973 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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* `tables2003` 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 = 2972 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 51500 ORDER BY nameShow LIMIT 100

Alhaurín de la Torre B

Alhaurín de la Torre B

Selecciona un equipo

Competiciones que juega

3ª Andaluza Málaga

RIVALES EN 3ª Andaluza Mála.