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 Fisterra

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	SD Negreira	30	106	28	70
2	Cordeiro CF	30	51	18	65
3	Puebla	30	64	24	65
4	CD Union	30	71	27	63
5	Tordoia	31	63	54	54
6	CF Dumbría	30	52	37	47
7	Flavia	30	74	57	47
8	Calo SR	31	62	58	42
9	SD Fisterra	30	52	75	42
10	Bertamiráns	30	54	55	40
11	Esteirana	30	47	54	38
12	Lorenzo	30	41	52	38
13	Valiño Cabo	30	44	65	36
14	Praiña	30	41	52	36
15	SD Agolada	30	40	72	30
16	CD Baio	30	32	56	30
17	Sporting	30	30	51	27
18	Cruces SD	30	12	101	2

TEMPORADA 2022/2023

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SD Sarriana	38	79	31	83
2	Betanzos CF	38	83	38	82
3	Boiro	38	74	25	79
4	Noia	38	70	28	79
5	Tirso	38	74	43	57
6	Dubra	38	51	54	56
7	Residencia	38	51	46	55
8	Galicia	38	53	43	55
9	SD Sofán	38	55	59	54
10	Ribadeo FC	38	53	62	53
11	O Pino	38	66	80	52
12	Coruña	38	62	55	51
13	Sigueiro CF	38	55	50	51
14	Club Lemos	38	55	57	50
15	Victoria CF	38	53	51	49
16	As Pontes	38	47	52	49
17	Club Ordenes	38	49	54	46
18	CD Union	38	49	71	42
19	SD Fisterra	38	30	143	15
20	Portomarín	38	31	98	9

TEMPORADA 2021/2022

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	At. Arteixo	22	52	9	53
2	Sigueiro CF	22	30	16	42
3	UD Paiosaco	22	43	15	41
4	SD Fisterra	22	39	20	40
5	Dubra	22	30	20	37
6	O Pino	22	31	28	33
7	Boiro	22	24	25	31
8	Boimorto CF	22	29	43	26
9	Puebla	22	31	39	25
10	Xallas FC	22	26	43	19
11	Laracha	22	31	47	16
12	Estudiantil	22	12	73	-7

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bergantiños	22	37	16	48
2	CD Lugo B	22	34	17	42
3	Somozas	22	41	21	41
4	Villalbés	22	34	26	40
5	Deportivo	22	41	27	32
6	Silva SD	22	21	20	30
7	CSD Arzua	22	32	23	29
8	Viveiro	22	25	39	28
9	Estudiantil	22	27	45	20
10	As Pontes	22	18	40	19
11	SD Fisterra	22	22	35	17
12	UD Paiosaco	22	16	39	12
13	Arenteiro	22	33	13	47
14	Arosa	22	27	14	41
15	Alondras CF	22	31	15	37
16	Estradense	22	35	34	31
17	Choco	22	28	22	31
18	Rápido	22	25	25	31
19	Barco	22	26	27	30
20	Ourense CF	22	33	29	28
21	Ribadumia	22	24	36	26
22	Ourense UD	22	25	32	25
23	UD Atios	22	18	32	20
24	Pontellas	22	12	38	9

TEMPORADA 2019/2020

PREFERENTE GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Viveiro	26	57	21	62
2	SD Fisterra	26	45	29	51
3	Boiro	26	38	31	47
4	Noia	26	44	26	46
5	Galicia	26	41	29	45
6	Puebla CF	26	28	23	43
7	At. Arteixo	26	32	24	42
8	SD Sofán	26	44	33	41
9	SD Sarriana	26	53	33	38
10	Ribadeo FC	26	38	35	37
11	Sigueiro CF	26	28	26	35
12	Tirso	26	29	34	35
13	Boimorto CF	26	41	45	32
14	Residencia	26	32	39	32
15	Club Lemos	26	31	46	31
16	Dubra	26	41	48	27
17	Coruña	26	26	40	24
18	Xallas FC	26	31	66	20
19	Laracha	26	27	41	19
20	CD Foz	26	24	61	15

TEMPORADA 2018/2019

PRIMERA GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sigueiro CF	34	70	17	79
2	SD Fisterra	34	72	27	79
3	Flavia	34	78	31	75
4	CD Baio	34	62	43	60
5	CF Dumbría	34	59	51	51
6	CD Union	34	38	40	49
7	Piloño	34	52	58	47
8	CD Lalín	34	42	43	45
9	Soneira Sd	34	46	48	45
10	Esclavitud	34	37	54	44
11	Praiña	34	42	52	42
12	Tordoia	34	52	55	41
13	Val do Ulla	34	60	67	41
14	Cordeiro CF	34	49	53	40
15	Chaian	34	31	57	35
16	Esteirana	34	37	54	33
17	Bertamiráns	34	43	89	26
18	Bastavales	34	38	69	25

TEMPORADA 2017/2018

PRIMERA GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	SD Agolada	34	60	29	73
2	Puebla	34	69	28	69
3	SD Piloño	34	61	43	69
4	Flavia	34	60	30	64
5	CD Union	34	63	43	62
6	Bastavales	34	56	46	57
7	Soneira Sd	34	60	40	56
8	Lalín	34	69	48	55
9	Bertamiráns	34	51	53	46
10	CD Baio	34	43	43	40
11	Cordeiro CF	34	53	59	40
12	Chaián	34	45	46	39
13	Sigueiro CF	34	44	54	39
14	Tordoia	34	32	54	37
15	SD Fisterra	34	39	59	36
16	Cidade	34	43	82	29
17	Lorenzo	34	38	76	25
18	CF Silleda	34	35	88	17

TEMPORADA 2016/2017

PRIMERA GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CF Dumbría	34	69	30	75
2	SD Agolada	34	62	46	65
3	Sigueiro CF	34	66	43	56
4	Puebla	34	49	38	55
5	SD Piloño	34	74	62	53
6	CD Union	34	52	44	53
7	Cordeiro CF	34	72	56	51
8	Flavia	34	59	46	51
9	Cidade	34	70	55	49
10	Tordoia	34	49	44	44
11	SD Fisterra	33	46	48	44
12	CF Silleda	34	34	52	44
13	Val do Ulla	34	48	49	43
14	Outes	34	41	65	41
15	Lalín	33	48	58	40
16	Sporting	34	43	72	34
17	Esclavitud	34	35	61	27
18	Villestro	34	46	94	22

TEMPORADA 2015/2016

SEGUNDA GALICIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	SD Fisterra	34	113	31	85
2	Sporting	34	104	32	81
3	Mazaricos	34	87	40	71
4	Lorenzo	34	95	35	71
5	Ponteceso	34	80	46	68
6	Baiñas	34	79	36	67
7	Castriz	34	79	55	56
8	Unión Cee	34	60	57	55
9	Esteirana	34	55	72	50
10	Camariñas	34	53	83	42
11	Cerqueda UD	34	51	57	40
12	Buño	34	52	80	39
13	Coristanco	34	49	84	35
14	Porteño	34	50	73	30
15	Ameixenda	34	59	88	27
16	Cabana	34	49	114	19
17	Volantes	34	41	113	19
18	Carnota	34	40	100	18

TEMPORADA 2014/2015

SEGUNDA GALICIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Outes	34	77	33	75
2	Sporting	34	76	36	74
3	Lorenzo	34	89	42	72
4	Castriz	34	66	40	68
5	Mazaricos	34	67	45	60
6	Baiñas	34	69	57	52
7	SD Fisterra	34	60	46	51
8	Buño	34	66	59	50
9	Volantes	34	82	74	49
10	Carnota	34	47	51	48
11	Camariñas	34	55	64	41
12	Ponteceso	34	56	67	38
13	Unión Cee	34	47	72	38
14	Cabana	34	62	84	37
15	Porteño	34	50	74	35
16	Monte Louro	34	52	77	31
17	Sporting	34	39	61	27
18	Camelle	34	31	109	9

TEMPORADA 1981/1982

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pontevedra	38	78	24	60
2	CD Ourense	38	70	24	56
3	CD Lugo	38	72	30	55
4	Arosa	38	46	33	46
5	Celta Gran.	38	51	40	45
6	Celta	38	42	33	45
7	Viveiro	38	57	35	43
8	Vista Alegre	38	40	44	40
9	Flavia	38	35	39	39
10	Alondras CF	38	48	51	37
11	Deportivo	38	47	50	36
12	Lalín	38	35	45	33
13	Martiño	38	37	54	32
14	Arenteiro	38	41	50	32
15	Club Lemos	38	40	34	32
16	Cidade	38	34	53	32
17	Porriño	38	42	48	30
18	Cambados	38	49	66	29
19	SD Fisterra	38	29	93	22
20	Verín	38	19	66	16

TEMPORADA 1980/1981

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Lugo	38	73	15	59
2	Arosa	38	82	28	58
3	Celta Gran.	38	55	30	54
4	Alondras CF	38	66	42	47
5	CD Ourense	38	53	29	46
6	Vista Alegre	38	52	35	46
7	Cambados	38	54	53	39
8	Arenteiro	38	46	49	38
9	Porriño	38	51	59	38
10	Deportivo	38	54	46	36
11	Martiño	38	39	48	35
12	Cidade	38	34	41	33
13	SD Fisterra	38	41	61	33
14	Club Lemos	38	34	46	32
15	Celta	38	32	41	29
16	Choco	38	38	64	29
17	Flavia	38	43	60	29
18	Noia	38	30	54	28
19	Céltiga FC	38	35	66	28
20	Boiro	38	32	77	23

Competiciones que juega

Primera Galicia Grupo 2

Pos	Equipos		Pts
1		SD Negreira	70
2		Cordeiro CF	65
3		Puebla Galicia CF	65
4		CD Union	63
5		Tordoia	54
6		CF Dumbría	47
7		Flavia	47
8		Calo SR	42
9		SD Fisterra	42
10		Bertamiráns FC	40
11		SD Esteirana	38
12		San Lorenzo Verdillo	38
13		Valiño Cabo de Cruz	36
14		Praiña	36
15		SD Agolada	30
16		CD Baio	30
17		Sporting Estrada	27
18		Cruces SD	2

	Ascenso : SD Negreira
	Playoff Ascenso : Cordeiro CF, Puebla Galicia CF, CD Union
	Descenso : CD Baio, Sporting Estrada, Cruces SD

RIVALES EN Primera Galicia

USO DE MEMORIA

6,638,264 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1233
Total Execution Time	0.1246

CADENA URL

/historico/Fisterra

GET DATOS

$_GET['/historico/Fisterra']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0028	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 = 'Fisterra' 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.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=19934 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=19934 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042	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 = 73634
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19934 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=694 AND type_rel = 3
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 694 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025	SELECT /53 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 (912025,141904,92516) ORDER BY n.cover_points DESC, update_date DESC
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 = '19934' AND l.year = 2024 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 = '19934' 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 = 73634 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=19934 AND l.year in (2023,2024,2025) 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 (73634,68756) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 68756 AND teamId = 19934
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 73634 AND teamId = 19934
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* `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 = 73634 AND t.round = 31 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 = '19934' 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 = '19934' and rp.type = 4
0.0020	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 = '19934' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031	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 = 73634 WHERE rp.league_id = 73634 AND rp.teamId = 19934 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.0031	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 = 73634 WHERE rp.league_id = 73634 AND rp.teamId = 19934 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 73634 WHERE rp.league_id = 73634 AND rp.teamId = 19934 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 19934 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022	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 = 73634 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.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* `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 = 68756 AND t.round = 38 ORDER BY team.conference ASC,t.position 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* `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 = 67009 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 64088 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.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* `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 = 51173 AND t.round = 26 ORDER BY team.conference ASC,t.position 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* `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 = 45148 AND t.round = 34 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* `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 = 39705 AND t.round = 34 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* `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 = 34036 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 16818 AND t.round = 34 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* `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 = 4345 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables1982` 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 = 20978 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables1981` 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 = 20977 AND t.round = 38 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 Fisterra

SD Fisterra

Selecciona un equipo

Competiciones que juega

Primera Galicia Grupo 2

RIVALES EN Primera Galicia