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

Resultados de Fútbol

Tenerife Sub 19

Entrenador: Jesús Manuel

Temporada 2023/2024

TEMPORADA 2023/2024

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	28	98	13	72
2	Tenerife	28	55	26	53
3	Oliva	28	36	29	48
4	Universitari	28	45	33	45
5	Acodetti	28	43	41	45
6	Sobradillo	28	35	30	42
7	Huracán	28	45	43	41
8	Juventud	28	39	45	39
9	Atlético	28	38	44	37
10	Orientación	28	33	41	36
11	Arucas	28	33	48	34
12	Unión Viera	28	34	47	33
13	Mensajero	28	31	36	31
14	Fernando	28	32	50	28
15	Marino	28	26	51	27
16	José	28	21	67	11

TEMPORADA 2022/2023

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	30	118	12	88
2	Tenerife	30	58	27	63
3	Orientación	30	51	37	52
4	Huracán	30	49	43	52
5	Juventud	30	39	35	47
6	Sobradillo	30	41	38	44
7	Oliva	30	40	44	42
8	Unión Viera	30	49	48	39
9	Arucas	30	41	48	38
10	José	30	32	43	36
11	Mensajero	30	31	45	35
12	Fernando	30	40	55	34
13	Longueras	30	31	56	30
14	Maspalomas	30	37	61	25
15	Ibarra	30	30	50	24
16	Puerto Cruz	30	34	79	21

TEMPORADA 2021/2022

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	34	131	19	93
2	Tenerife	34	87	19	84
3	Arucas	34	69	43	63
4	Unión Viera	33	76	53	57
5	José	34	64	37	56
6	Juventud	33	54	37	55
7	Huracán	34	45	47	53
8	Orientación	34	45	50	52
9	Sobradillo	34	68	51	50
10	Oliva	34	54	43	50
11	Mensajero	34	47	59	44
12	Maspalomas	34	54	49	43
13	Atco. Gran.	34	56	63	39
14	Acodetti	34	41	81	28
15	Aguilas	34	29	88	27
16	Marino	34	40	102	20
17	Victoria	34	38	70	19
18	Zocas	34	30	117	12

TEMPORADA 2020/2021

DIVISIÓN DE HONOR GRUPO 25
Equipo		PJ	GF	GC	Puntos
1	Palmas	23	73	14	64
2	Tenerife	23	54	14	50
3	Marino	23	52	40	41
4	Maspalomas	23	32	21	40
5	Sobradillo	23	48	29	39
6	Unión Viera	23	36	41	33
7	Orientación	23	41	30	31
8	Mensajero	23	33	43	31
9	Juventud	23	33	46	28
10	Arucas	23	22	39	25

TEMPORADA 2019/2020

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	25	61	9	65
2	Tenerife	25	57	15	52
3	Acodetti	25	57	32	50
4	Orientación	25	42	33	45
5	José	25	41	29	43
6	Unión Viera	25	48	45	37
7	Sobradillo	25	34	35	37
8	Huracán	25	43	42	31
9	Maspalomas	25	33	45	31
10	Llanos	25	34	41	30
11	Laguna	25	25	28	29
12	Victoria	25	34	53	25
13	Juventud	25	31	56	25
14	Marino	25	34	63	19
15	Ofra	25	23	52	19
16	Fernando	25	20	39	17

TEMPORADA 2018/2019

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2017/2018

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	30	89	13	85
2	Tenerife	30	93	16	83
3	José	30	52	39	47
4	Estrella CF	30	50	45	46
5	Laguna	30	54	47	43
6	Sobradillo	30	40	35	43
7	Orientación	30	39	31	40
8	Acodetti	30	41	47	38
9	Arucas	30	41	53	38
10	Guía	30	41	43	36
11	Victoria	30	40	65	35
12	Longuera-Tos	30	45	64	33
13	Huracán	30	40	53	30
14	Juventud	30	31	50	26
15	SD Tenisca	30	28	68	23
16	Playas	30	27	82	17

TEMPORADA 2016/2017

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	32	107	17	89
2	Tenerife	32	65	30	64
3	Sobradillo	32	60	32	62
4	José	32	66	36	61
5	Huracán	32	58	31	60
6	Acodetti	32	60	47	54
7	Orientación	32	69	60	49
8	Laguna	32	44	39	48
9	Longuera-Tos	32	63	51	48
10	Guía	32	61	64	45
11	Arucas	32	56	55	42
12	Estrella CF	32	48	44	41
13	Marino	32	56	73	37
14	CD Tahíche	32	38	62	28
15	Las Zocas	32	29	86	21
16	UD Telde	32	26	105	16
17	Pedro Martir	32	20	94	11

TEMPORADA 2015/2016

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	30	106	14	83
2	Tenerife	30	66	26	60
3	Longuera-Tos	30	53	47	53
4	José	30	48	44	52
5	Estrella CF	30	47	46	45
6	Orientación	30	41	48	44
7	UD Telde	30	51	49	40
8	Arucas	30	31	34	39
9	Acodetti	30	38	39	39
10	Huracán	30	42	36	39
11	Sobradillo	30	46	42	39
12	CD Tahíche	30	33	56	34
13	Unión Viera	30	34	59	33
14	Laguna	30	32	50	31
15	Juventud	30	26	47	29
16	Ofra	30	29	86	11

TEMPORADA 2014/2015

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	30	86	23	72
2	Laguna	30	57	28	67
3	Tenerife	30	62	29	65
4	Arucas	30	52	44	48
5	Acodetti	30	60	50	43
6	Sobradillo	30	48	43	39
7	CD Tahíche	30	32	39	39
8	Juventud	30	54	65	36
9	Ofra	30	45	61	34
10	Huracán	30	43	48	33
11	UD Telde	30	33	40	33
12	Orientación	30	40	64	33
13	Victoria	30	47	73	33
14	Ud Ibarra	30	56	79	32
15	SD Tenisca	30	47	58	30
16	Vecindario	30	42	60	28

TEMPORADA 2013/2014

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	30	91	15	82
2	Tenerife	30	65	21	60
3	Arucas	30	63	40	54
4	CD Tahíche	30	50	50	48
5	Acodetti	30	38	32	46
6	Vecindario	30	41	40	43
7	Sobradillo	30	51	60	39
8	Ofra	30	35	44	37
9	Telde	30	43	55	37
10	SD Tenisca	30	41	57	37
11	Huracán	30	46	57	36
12	Laguna	30	41	42	35
13	Puerto Cruz	30	30	47	35
14	Unión Viera	30	29	46	29
15	Mensajero	30	31	57	27
16	Estrella CF	30	32	64	26

TEMPORADA 2012/2013

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	30	82	17	73
2	Tenerife	30	85	32	64
3	Acodetti	30	47	29	54
4	Vecindario	30	45	31	51
5	Huracán	30	59	45	45
6	Sobradillo	30	52	40	42
7	Laguna	30	37	38	38
8	Puerto Cruz	30	39	57	38
9	Telde	30	36	49	37
10	Unión Viera	30	37	45	37
11	CD Tahíche	30	40	51	37
12	SD Tenisca	30	40	56	36
13	Barrio	30	27	44	36
14	Ud Ibarra	30	45	52	34
15	Puertos	30	39	56	33
16	CD Teguise	30	18	86	12

TEMPORADA 2011/2012

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	30	95	23	73
2	Tenerife	30	87	31	63
3	Sobradillo	30	64	44	57
4	Puerto Cruz	30	56	50	51
5	Huracán	30	68	42	50
6	Vecindario	30	58	36	49
7	Puertos	30	52	47	47
8	Unión Viera	30	33	31	46
9	CD Herbania	30	46	47	44
10	CD Teguise	30	43	51	42
11	Laguna	30	41	52	36
12	Telde	30	45	50	34
13	José	30	24	67	26
14	UD Realejos	30	35	76	22
15	Victoria	30	30	67	20
16	Vallinamar	30	26	89	12

TEMPORADA 2010/2011

DIVISIÓN DE HONOR GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Palmas	34	100	23	89
2	Tenerife	34	81	29	68
3	Vecindario	34	74	45	66
4	José	34	89	52	61
5	Universidad	34	64	48	54
6	Puerto Cruz	34	58	52	52
7	Laguna	34	52	55	52
8	Huracán	34	58	46	51
9	Sobradillo	34	54	47	49
10	Puertos	34	45	58	48
11	CD Teguise	34	44	55	46
12	Vallinamar	34	63	64	44
13	CD Herbania	34	46	57	44
14	Ud Atalaya	34	46	60	44
15	Acodetti	34	57	66	40
16	Andrés	34	60	62	34
17	Real Unión	34	31	99	16
18	UD Icodense	34	25	129	9

Competiciones que juega

Grupo 6

División de Honor Grupo 6

Pos	Equipos		Pts
1		Las Palmas Sub 19	72
2		Tenerife Sub 19	53
3		CD La Oliva Sub 19	48
4		Universitario FC Sub 19	45
5		CF Acodetti Sub 19	45
6		CD Sobradillo Sub 19	42
7		AD Huracán Sub 19	41
8		CF Juventud Laguna Sub 19	39
9		Atlético Paso Sub 19	37
10		Orientación Marítima Sub 1.	36
11		Arucas Sub 19	34
12		Unión Viera Sub 19	33
13		Mensajero Sub 19	31
14		San Fernando Sub 19	28
15		CD Marino Sub 19	27
16		SD San José Sub 19	11

	Playoff Título : Las Palmas Sub 19
	Copa del Rey Juvenil : Tenerife Sub 19, CD La Oliva Sub 19, Universitario FC Sub 19
	Descenso : Mensajero Sub 19, San Fernando Sub 19, CD Marino Sub 19, SD San José Sub 19

RIVALES EN División de Hono.

RIVALES EN Copa del Rey Juv.

USO DE MEMORIA

6,748,568 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5962
Total Execution Time	0.5974

CADENA URL

/historico/Cd-Tenerife-Juvenil

GET DATOS

$_GET['/historico/Cd-Tenerife-Juvenil']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0265	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 = 73246
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4909 AND type_rel = 2
0.0133	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4909 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0137	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 (77559,88277,101029,229024,224715) ORDER BY n.cover_points DESC, update_date DESC
0.0130	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 = '4909' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	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 = 73246 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	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=4909 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (74910,73246) 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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 73246 AND teamId = 4909
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 74910 AND teamId = 4909
0.0132	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2024` 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 = 73246 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128	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 = '4909' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4909' and rp.type = 4
0.0131	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 = '4909' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '4909' and rp.type = 4
0.0153	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 events2024 e ON e.player_id = p.id AND e.league_id = 73246 WHERE rp.league_id = 73246 AND rp.teamId = 4909 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.0173	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 events2024 e ON e.player_id = p.id AND e.league_id = 73246 WHERE rp.league_id = 73246 AND rp.teamId = 4909 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0174	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 events2024 e ON e.player_id = p.id AND e.league_id = 73246 WHERE rp.league_id = 73246 AND rp.teamId = 4909 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 = 4909 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0145	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* `tables2024` 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 = 73246 AND t.round = 29 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* `tables2023` 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 = 68518 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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* `tables2022` 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 = 63685 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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* `tables2021` 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 = 58885 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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* `tables2021` 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 = 61976 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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 = 50496 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 44582 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 39181 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 34123 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 16643 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* `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 = 4223 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 2714 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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* `tables2013` 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 = 2071 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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* `tables2012` 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 = 1486 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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* `tables2011` 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 = 1165 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 73246 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

Resultados de Fútbol

Tenerife Sub 19

Tenerife Sub 19

Selecciona un equipo

Competiciones que juega

División de Honor Grupo 6

RIVALES EN División de Hono.

RIVALES EN Copa del Rey Juv.