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

SD Borja

Entrenador: Juan Gonzalez

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Ejea	31	44	24	60
2	CD Ebro	31	45	22	59
3	CD Cuarte	31	42	22	58
4	Caspe	31	39	30	55
5	CF Epila	31	44	29	50
6	Almudévar	31	33	25	49
7	Fraga	31	47	35	47
8	Calamocha	31	34	26	46
9	Atlético	31	25	20	45
10	CD Utrillas	31	39	38	43
11	Huesca B	31	36	32	42
12	Tamarite	31	47	49	40
13	CD Binéfar	31	35	46	35
14	Fuentes	31	31	44	31
15	Belchite	31	31	47	28
16	Illueca	31	24	49	23
17	SD Borja	31	14	37	22
18	Cariñena	31	32	67	19

TEMPORADA 2022/2023

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	SD Borja	28	58	25	60
2	José	28	47	28	55
3	Montecarlo	28	55	33	54
4	Calatayud	28	44	23	48
5	Santa	28	50	31	48
6	Mores CD	28	37	31	44
7	Valdefierro	28	32	32	42
8	Casetas	28	59	43	40
9	Villa	28	41	30	40
10	AD Magallon	28	38	36	39
11	Sadabense	28	37	42	37
12	Gancho	28	31	61	23
13	Remolinos	28	32	59	22
14	Cartuja	28	37	72	18
15	Calatorao	28	25	77	17

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Deportivo	32	65	29	67
2	Utebo	32	63	28	66
3	Illueca	32	47	31	65
4	CD Binéfar	32	54	30	56
5	Robres	32	45	32	53
6	CD Cuarte	32	46	27	52
7	Atlético	32	40	23	49
8	Barbastro	32	36	29	48
9	Caspe	32	46	37	48
10	CF Epila	32	39	37	48
11	Cariñena	32	36	45	45
12	Calamocha	32	36	40	36
13	Belchite	32	35	43	33
14	Santa	32	31	40	33
15	SD Borja	32	31	48	29
16	Giner	32	23	97	18
17	Biescas	32	10	67	10

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	CD Teruel	22	34	11	49
2	Huesca B	22	36	18	45
3	Belchite	22	22	9	35
4	Deportivo	22	32	14	34
5	Illueca	22	23	16	34
6	CD Binéfar	22	29	17	32
7	Atlético	22	26	19	31
8	Cariñena	22	21	23	27
9	Tamarite	22	19	29	25
10	Valdefierro	22	20	36	22
11	Fraga	22	17	21	22
12	AD San Juan	22	0	66	0
13	Brea	22	34	12	42
14	CD Cuarte	22	32	21	39
15	Utebo	22	21	15	37
16	Barbastro	22	27	18	36
17	SD Borja	22	29	23	31
18	Calamocha	22	24	19	30
19	Sariñena	22	36	36	29
20	CF Epila	22	23	23	26
21	Robres	22	23	31	26
22	Almudévar	22	17	32	22
23	Villanueva	22	16	39	18
24	Sabiñánigo	22	24	37	14

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	SD Tarazona	28	58	20	65
2	CD Teruel	29	53	19	63
3	Brea	29	41	23	54
4	Deportivo	28	51	23	51
5	CD Cuarte	28	39	32	50
6	AD San Juan	28	38	30	46
7	SD Borja	28	37	29	45
8	Illueca	28	42	37	43
9	Sariñena	29	36	32	43
10	CD Binéfar	29	34	30	41
11	Barbastro	29	35	33	39
12	Fraga	29	35	33	37
13	Utebo	29	37	41	32
14	Atlético	29	24	34	32
15	Robres	29	31	39	28
16	Tamarite	29	27	45	28
17	Calamocha	28	32	48	27
18	Belchite	29	21	35	26
19	Villanueva	29	23	48	24
20	Valdefierro	28	22	56	22
21	Almudévar	28	18	47	19

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	SD Tarazona	38	72	17	80
2	Illueca	38	60	34	72
3	Deportivo	38	58	19	72
4	Sariñena	38	51	30	71
5	SD Borja	38	54	30	70
6	Utebo	38	50	31	67
7	Brea	38	48	34	61
8	AD San Juan	38	44	30	58
9	Atlético	38	41	35	57
10	Almudévar	38	42	42	50
11	CD Binéfar	38	45	50	47
12	Calamocha	38	41	55	46
13	Villanueva	38	37	56	44
14	Robres	38	38	46	43
15	Tamarite	38	36	59	43
16	Belchite	38	32	42	38
17	Lorenzo	38	32	69	33
18	Sabiñánigo	38	33	55	32
19	Almunia	38	38	71	31
20	Casetas	38	20	67	23

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	CD Teruel	38	81	30	82
2	SD Borja	38	62	28	78
3	Ejea	38	89	41	75
4	SD Tarazona	38	85	39	73
5	Robres	38	51	34	68
6	Tamarite	38	57	48	60
7	Illueca	38	53	44	59
8	Almudévar	38	62	59	54
9	Utebo	38	53	49	53
10	Brea	38	47	53	50
11	Sabiñánigo	38	43	48	50
12	Sariñena	38	49	49	46
13	Atlético	38	43	58	43
14	Almunia	38	50	73	43
15	CD Binéfar	38	40	62	41
16	Belchite	38	38	66	41
17	Fraga	38	42	56	40
18	Valdefierro	38	31	60	35
19	Cariñena	38	36	77	29
20	Caspe	38	25	63	23

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	85	30	85
2	SD Tarazona	38	68	46	66
3	Utebo	38	60	38	66
4	Ejea	38	59	38	64
5	CD Teruel	38	65	39	62
6	SD Borja	38	48	35	60
7	Almudévar	38	66	49	57
8	Robres	38	46	45	55
9	Illueca	38	50	42	53
10	Sabiñánigo	38	53	51	53
11	Tamarite	38	56	69	51
12	Brea	38	48	55	48
13	CD Binéfar	38	40	41	45
14	Cariñena	38	55	64	45
15	Belchite	38	35	60	44
16	Sariñena	38	42	60	44
17	CD Cuarte	38	50	66	43
18	Atlético	38	46	60	39
19	CF Epila	38	38	75	36
20	Andorra	38	34	81	27

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	70	19	83
2	Andorra	38	64	31	82
3	SD Tarazona	38	70	33	73
4	CD Teruel	38	69	38	71
5	Sariñena	38	52	26	68
6	Ejea	38	66	38	66
7	Almudévar	38	65	37	64
8	Utebo	38	59	58	61
9	Cariñena	38	50	61	49
10	CD Binéfar	38	36	48	47
11	Atlético	38	54	58	45
12	SD Borja	38	27	36	45
13	Illueca	38	46	63	43
14	CD Cuarte	38	40	52	41
15	Sabiñánigo	38	35	47	41
16	Belchite	38	35	59	39
17	Atlético	38	40	66	39
18	Villa	38	40	68	36
19	Villanueva	38	40	66	32
20	Fraga	38	33	87	24

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	CD Ebro	38	84	27	86
2	CD Teruel	38	72	36	84
3	Sariñena	38	72	26	78
4	SD Tarazona	38	76	36	77
5	Andorra	38	54	24	76
6	SD Borja	38	54	34	61
7	CD Cuarte	38	46	40	60
8	Almudévar	38	49	39	59
9	Utebo	38	49	60	55
10	Ejea	38	51	45	52
11	Illueca	38	48	58	50
12	Villa	38	40	61	47
13	Atlético	38	51	62	43
14	Sabiñánigo	38	53	65	42
15	CD Binéfar	38	37	56	40
16	Villanueva	38	35	50	40
17	Tamarite	38	34	63	35
18	Caspe	38	30	48	35
19	Santa Isabel	38	29	52	29
20	Barbastro	38	26	108	6

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Deportivo	40	95	30	95
2	CD Teruel	40	56	41	78
3	Ejea	40	58	29	72
4	Almudévar	40	78	37	71
5	Atlético	40	65	48	71
6	SD Tarazona	40	67	52	70
7	Utebo	40	57	51	69
8	SD Borja	40	52	34	64
9	Barbastro	40	56	49	59
10	Andorra	40	44	42	57
11	Villanueva	40	57	47	57
12	Tamarite	40	54	64	56
13	CD Ebro	40	67	54	51
14	Sabiñánigo	40	52	59	51
15	Illueca	40	40	51	49
16	CD Cuarte	40	47	53	48
17	Brea	40	39	76	39
18	Calatayud	40	46	79	38
19	Atlético	40	36	77	28
20	Altorricón	40	36	83	24
21	Oliver	40	35	81	21

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Sariñena	38	70	20	84
2	Andorra	38	73	25	84
3	CD Ebro	38	66	40	73
4	Utebo	38	56	26	72
5	Atlético	38	70	50	70
6	Ejea	38	58	40	60
7	SD Borja	38	46	39	57
8	SD Tarazona	38	45	45	53
9	CD Cuarte	38	51	47	53
10	Villanueva	38	47	48	52
11	Oliver	38	45	49	48
12	Atlético	38	35	51	46
13	Barbastro	38	47	57	46
14	Almudévar	38	46	48	45
15	Sabiñánigo	38	51	55	44
16	Calatayud	38	37	52	44
17	Almunia	38	39	58	40
18	Valdefierro	38	38	50	39
19	Robres	38	41	63	30
20	CD Binéfar	38	19	117	15

TEMPORADA 2011/2012

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SD Borja	34	76	22	84
2	Almunia	34	70	31	74
3	Mallén	34	60	34	71
4	Cella	34	60	40	56
5	Illueca	34	62	39	54
6	Villa	34	61	41	53
7	Brea	34	55	57	52
8	Belchite	34	57	45	50
9	Calamocha	34	35	50	42
10	Gregorio	34	45	65	39
11	Hernán	34	46	53	38
12	CD Utrillas	34	46	57	38
13	Morata CD	34	33	50	38
14	Valdefuentes	34	51	46	37
15	Actur Pablo	34	37	62	36
16	La Muela	34	50	69	32
17	Cd Daroca	34	33	79	26
18	Cd Azuara	34	31	68	21

TEMPORADA 2010/2011

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Universidad	34	71	32	69
2	Oliver	34	64	36	67
3	Tamarite	34	65	35	64
4	Robres	34	67	30	62
5	Fraga	34	69	36	62
6	Zuera	34	62	41	61
7	SD Borja	34	59	45	59
8	Alcampell	34	65	42	58
9	Casetas	34	50	51	46
10	Lorenzo	34	50	52	45
11	Almudévar	34	57	51	39
12	Alfindén	34	40	51	38
13	Peña	34	53	72	38
14	Jacetano	34	45	51	37
15	Gregorio	34	34	61	37
16	Grañén	34	47	70	36
17	Alcolea CF	34	39	69	29
18	Pedrola	34	13	125	8

TEMPORADA 1945/1946

TERCERA DIVISIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Arenas	18	49	15	29
2	Logroñés	18	44	12	28
3	Maestranza	18	65	33	24
4	Escoriaza	18	44	41	21
5	Osasuna	18	33	33	19
6	UD Huesca	18	39	38	18
7	Atlético	18	40	33	16
8	Tudelano	18	29	51	12
9	Izarra	18	31	61	8
10	SD Borja	18	21	78	5

Competiciones que juega

Tercera Federación Grupo 17

Pos	Equipos		Pts
1		Ejea	60
2		CD Ebro	59
3		CD Cuarte	58
4		Caspe	55
5		CF Epila	50
6		Almudévar	49
7		Fraga	47
8		Calamocha	46
9		Atlético Monzón	45
10		CD Utrillas	43
11		Huesca B	42
12		CDJ Tamarite	40
13		CD Binéfar	35
14		Fuentes	31
15		CD Belchite 97	28
16		Illueca	23
17		SD Borja	22
18		CD Cariñena	19

	Ascenso : Ejea
	Playoff Ascenso : CD Ebro, CD Cuarte, Caspe, CF Epila
	Descenso : Illueca, SD Borja, CD Cariñena

RIVALES EN Tercera Federaci.

USO DE MEMORIA

7,229,064 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.6260
Total Execution Time	0.6274

CADENA URL

/historico/Sd-Borja

GET DATOS

$_GET['/historico/Sd-Borja']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0134	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 = 'Sd-Borja' 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.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=4730 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=4730 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=4730 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253	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 = 72277
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4730 AND type_rel = 2
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4730 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127	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 (82324,132499,427710,428153,428205) ORDER BY n.cover_points DESC, update_date DESC
0.0133	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 = '4730' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '4730' 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 = 72277 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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=4730 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 (72277,71432,68793) 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 = 72277 AND teamId = 4730
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 68793 AND teamId = 4730
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4730
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 = '4730' 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 = '4730' and rp.type = 4
0.0126	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 = '4730' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135	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 = 72277 WHERE rp.league_id = 72277 AND rp.teamId = 4730 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.0135	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 = 72277 WHERE rp.league_id = 72277 AND rp.teamId = 4730 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 72277 WHERE rp.league_id = 72277 AND rp.teamId = 4730 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	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 = 4730 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0254	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 = 72277 AND t.round = 32 ORDER BY team.conference ASC,t.position 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* `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 = 68793 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.0134	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 = 58596 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 50285 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0254	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 = 44405 AND t.round = 38 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* `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 = 39041 AND t.round = 38 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* `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 = 33367 AND t.round = 38 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* `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 = 15459 AND t.round = 38 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* `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 = 3926 AND t.round = 38 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 = 2567 AND t.round = 42 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* `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 = 1957 AND t.round = 38 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* `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 = 1478 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* `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 = 1141 AND t.round = 34 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* `tables1946` 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 = 21349 AND t.round = 18 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

SD Borja

SD Borja

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 17

RIVALES EN Tercera Federaci.