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

Osasuna Sub 19

Temporada 2023/2024

TEMPORADA 2023/2024

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Athletic	29	57	25	67
2	Osasuna	29	55	19	60
3	Real	29	62	37	57
4	Antiguoko	29	41	29	50
5	Deportivo	29	38	33	47
6	Santutxu	29	50	39	43
7	Eibar	29	54	37	42
8	Juan	29	30	31	39
9	Arenas Club	29	41	44	38
10	Txantrea	29	43	59	38
11	Logroñés	29	58	50	37
12	Vasconia	29	34	44	36
13	Leioa	29	46	50	33
14	Gazte	29	39	53	25
15	Durango	29	26	67	15
16	Logroño	29	25	82	10

TEMPORADA 2022/2023

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Athletic	30	100	23	74
2	Real	30	76	30	67
3	Eibar	30	71	24	63
4	Osasuna	30	72	29	62
5	Deportivo	30	60	36	57
6	Antiguoko	30	50	43	49
7	Juan	30	37	40	45
8	Vasconia	30	50	53	43
9	Logroñés	30	45	52	33
10	Gazte	30	41	70	31
11	Arenas Club	30	30	60	31
12	Santutxu	30	44	69	31
13	Danok	30	36	66	30
14	Tolosa	30	38	62	24
15	Tudelano	30	31	68	21
16	Berceo	30	26	82	13

TEMPORADA 2021/2022

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Athletic	34	68	24	74
2	Osasuna	34	65	33	70
3	Eibar	34	64	45	62
4	Deportivo	34	55	37	60
5	Real	34	53	43	58
6	Antiguoko	34	54	47	57
7	Juan	34	51	29	56
8	Tolosa	34	44	46	50
9	Logroñés	34	48	46	48
10	Danok	34	53	46	46
11	Tudelano	34	54	60	46
12	Arenas Club	34	64	61	45
13	Mutilvera	34	54	50	45
14	Txantrea	34	54	58	43
15	Pamplona	34	36	63	32
16	Oberena	34	32	76	23
17	Getxo	34	22	58	17
18	Villegas	34	26	75	16

TEMPORADA 2020/2021

DIVISIÓN DE HONOR GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Athletic	23	61	18	57
2	Osasuna	23	57	23	52
3	Deportivo	23	51	27	45
4	Eibar	23	44	24	40
5	Txantrea	23	31	28	37
6	Real	23	40	41	36
7	Danok	23	34	38	34
8	Tudelano	23	38	43	34
9	Juan	23	39	32	33
10	Pamplona	23	31	33	27

TEMPORADA 2019/2020

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Athletic	25	64	21	57
2	Real	25	66	24	48
3	Osasuna	25	43	26	48
4	Eibar	25	54	31	45
5	Deportivo	25	51	30	42
6	Danok	25	35	26	41
7	Arenas Club	25	29	31	33
8	Juan	25	28	35	32
9	Numancia	25	34	53	32
10	Antiguoko	25	38	45	30
11	Leioa	25	29	38	30
12	Txantrea	25	32	42	30
13	Pamplona	25	23	34	30
14	Logroñés	25	27	45	29
15	Mutilvera	25	22	52	15
16	Valvanera	25	15	57	9

TEMPORADA 2018/2019

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Numancia	30	74	34	66
2	Real	30	88	31	64
3	Deportivo	30	69	30	58
4	Txantrea	30	57	35	55
5	Danok	30	53	34	54
6	Eibar	30	52	39	52
7	Athletic	30	70	39	51
8	Antiguoko	30	42	37	47
9	Osasuna	30	48	38	42
10	Pamplona	30	39	48	41
11	Juan	30	32	45	36
12	Valvanera	30	30	45	30
13	Santutxu	30	33	73	24
14	Oberena	30	30	77	21
15	Getxo	30	25	81	12
16	Amorebieta	30	16	72	9

TEMPORADA 2017/2018

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Athletic	30	91	45	70
2	Real	30	79	37	67
3	Deportivo	30	79	38	58
4	Eibar	30	52	42	52
5	Danok	30	55	39	48
6	Txantrea	30	58	50	46
7	Juan	30	31	40	43
8	Antiguoko	30	43	47	37
9	Numancia	30	45	54	35
10	Osasuna	30	40	40	35
11	Pamplona	30	40	52	34
12	Getxo	30	44	65	32
13	Hernani	30	46	63	31
14	Arenas Club	30	46	66	27
15	Logroñés	30	29	57	26
16	Varea	30	32	75	21

TEMPORADA 2016/2017

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Osasuna	30	70	35	68
2	Deportivo	30	64	34	62
3	Athletic	30	69	41	59
4	Real	30	74	38	53
5	Juan	30	41	30	49
6	Eibar	30	41	36	48
7	Danok	30	58	46	42
8	Txantrea	30	45	45	42
9	Varea	30	51	61	41
10	Getxo	30	39	50	40
11	Numancia	30	50	57	38
12	Antiguoko	30	40	41	35
13	Santutxu	30	31	48	28
14	Aurrera	30	29	59	25
15	Ardoi	30	41	75	22
16	Oberena	30	27	74	18

TEMPORADA 2015/2016

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Athletic	30	86	34	70
2	Antiguoko	30	54	26	59
3	Danok	30	61	36	56
4	Osasuna	30	55	30	56
5	Real	30	50	41	50
6	Numancia	30	43	34	44
7	Oberena	30	51	47	43
8	Deportivo	30	47	45	43
9	Eibar	30	35	33	42
10	Juan	30	39	42	41
11	Aurrera	30	33	40	38
12	Txantrea	30	52	59	37
13	Barakaldo	30	40	55	37
14	Durango	30	30	62	21
15	Comillas	30	27	59	19
16	Indartsu	30	28	88	9

TEMPORADA 2014/2015

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	30	67	27	68
2	Athletic	30	63	30	65
3	Osasuna	30	56	24	59
4	Danok	30	52	26	58
5	Antiguoko	30	51	37	51
6	Deportivo	30	50	48	42
7	Juan	30	32	40	38
8	Barakaldo	30	42	54	38
9	Eibar	30	36	37	36
10	Txantrea	30	35	51	33
11	Numancia	30	26	45	33
12	Indartsu	30	36	44	32
13	Logroñés	30	33	45	31
14	Valvanera	30	23	50	29
15	Arenas Club	30	35	54	27
16	Amigó	30	33	58	27

TEMPORADA 2013/2014

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real	30	81	24	70
2	Huesca	30	62	19	65
3	Danok	30	58	26	65
4	Athletic	30	73	32	64
5	Osasuna	30	75	34	59
6	Deportivo	30	39	34	40
7	Eibar	30	37	46	37
8	Juan	30	32	51	37
9	Logroñés	30	29	42	36
10	Antiguoko	30	30	35	35
11	Txantrea	30	40	50	35
12	Arenas Club	30	31	45	34
13	Durango	30	28	53	29
14	Getxo	30	34	64	26
15	Berceo	30	21	69	22
16	Oberena	30	23	69	20

TEMPORADA 2012/2013

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Athletic	30	81	27	69
2	Osasuna	30	64	30	60
3	Eibar	30	64	48	55
4	Real	30	55	39	46
5	Antiguoko	30	47	48	45
6	Berceo	30	41	42	44
7	Juan	30	32	33	44
8	Numancia	30	36	40	44
9	Txantrea	30	49	52	39
10	Danok	30	45	36	38
11	Durango	30	52	62	37
12	Deportivo	30	36	36	36
13	Santuchu Fc	30	30	41	35
14	Aurrera	30	46	54	34
15	Pamplona	30	30	63	24
16	Comillas	30	23	80	15

TEMPORADA 2011/2012

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Athletic	30	63	23	67
2	Danok	30	68	36	67
3	Real	30	63	29	64
4	Osasuna	30	64	31	61
5	Berceo	30	68	39	55
6	Stadium	30	56	46	49
7	Deportivo	30	47	36	47
8	Txantrea	30	46	39	44
9	Eibar	30	41	49	38
10	Pamplona	30	42	54	36
11	Durango	30	45	61	31
12	Santutxu	30	35	48	28
13	Leioa	30	29	52	22
14	Valvanera	30	45	72	21
15	Arenas Club	30	33	79	18
16	Barakaldo	30	32	83	17

TEMPORADA 2010/2011

DIVISIÓN DE HONOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Athletic	30	77	28	71
2	Real	30	59	13	69
3	Osasuna	30	57	22	68
4	Deportivo	30	42	29	54
5	Eibar	30	38	35	43
6	Txantrea	30	37	42	38
7	Danok	30	32	42	38
8	Berceo	30	49	62	36
9	Leioa	30	27	36	35
10	Barakaldo	30	28	48	35
11	Santutxu	30	33	51	33
12	Logroñés	30	34	46	32
13	Juan	30	35	51	31
14	Antiguoko	30	35	60	22
15	Lagunak	30	25	57	16

Competiciones que juega

Grupo 2

División de Honor Grupo 2

Pos	Equipos		Pts
1		Athletic Sub 19	67
2		Osasuna Sub 19	60
3		Real Sociedad Sub 19	57
4		Antiguoko KE Sub 19	50
5		Deportivo Alavés Sub 19	47
6		Santutxu Sub 19	43
7		Eibar Sub 19	42
8		AD San Juan Sub 19	39
9		Arenas Club Sub 19	38
10		UDC Txantrea Sub 19	38
11		UD Logroñés Sub 19	37
12		CD Vasconia Sub 19	36
13		Leioa Sub 19	33
14		Gazte Berriak Sub 19	25
15		Durango Sub 19	15
16		DUX Logroño Sub 19	10

	Playoff Título : Athletic Sub 19
	Copa del Rey Juvenil : Osasuna Sub 19, Real Sociedad Sub 19, Antiguoko KE Sub 19
	Descenso : Leioa Sub 19, Gazte Berriak Sub 19, Durango Sub 19, DUX Logroño Sub 19

RIVALES EN División de Hono.

RIVALES EN Copa del Rey Juv.

USO DE MEMORIA

6,745,336 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.4911
Total Execution Time	0.4923

CADENA URL

/historico/Atletico-Osasuna-Juvenil

GET DATOS

$_GET['/historico/Atletico-Osasuna-Juvenil']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0118	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 = 'Atletico-Osasuna-Juvenil' 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.0106	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=4846 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=4846 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107	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=4846 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4846 AND type_rel = 2
0.0123	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 = '4846' ORDER BY l.year DESC,cat.coefficient DESC
0.0122	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 = '4846' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0124	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 = '4846' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115	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 = 73241 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0122	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=4846 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0110	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,73241) 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.0116	SELECT count(id) as num_players from rel_players WHERE league_id = 73241 AND teamId = 4846
0.0124	SELECT count(id) as num_players from rel_players WHERE league_id = 74910 AND teamId = 4846
0.0108	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 = '4846' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4846' and rp.type = 4
0.0107	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 = '4846' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0115	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 = 73241 WHERE rp.league_id = 73241 AND rp.teamId = 4846 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.0117	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 = 73241 WHERE rp.league_id = 73241 AND rp.teamId = 4846 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112	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 = 73241 WHERE rp.league_id = 73241 AND rp.teamId = 4846 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109	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 = 4846 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111	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 = 68514 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.0111	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 = 63681 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.0109	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 = 58840 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.0108	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 = 61968 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.0109	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 = 50492 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.0124	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 = 44581 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* `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 = 39177 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* `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 = 34119 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 16589 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 4201 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 2710 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121	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 = 2067 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 1488 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 1162 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿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

Osasuna Sub 19

Osasuna Sub 19

Selecciona un equipo

Competiciones que juega

División de Honor Grupo 2

RIVALES EN División de Hono.

RIVALES EN Copa del Rey Juv.