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

Santfeliuenc FC

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA CATALANA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Vilanova	27	55	30	59
2	Sant Just	27	59	30	53
3	Sant	27	52	37	48
4	Martorell	27	42	29	45
5	Tortosa Ebre	26	31	26	43
6	Ascó	27	33	31	38
7	Vilafranca	27	45	42	38
8	Canonja	27	38	43	36
9	Parc	27	42	46	35
10	Sitges	27	38	40	34
11	Santfeliuenc	27	44	36	34
12	Prat B	27	33	49	33
13	Gornal	27	37	46	30
14	El Catllar	27	41	45	29
15	Sarrià	26	27	55	18
16	Morell	27	23	55	17

TEMPORADA 2022/2023

PRIMERA CATALANA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Reus Reddis	30	58	22	64
2	UE Valls	30	58	32	60
3	Can Vidalet	30	49	32	53
4	Santboià	30	44	32	52
5	Europa B	30	63	43	48
6	Viladecans	30	39	31	48
7	Santfeliuenc	30	45	39	47
8	Martorell	30	47	36	46
9	Vilanova	30	50	40	44
10	Sant Just	30	52	44	44
11	El Catllar	30	41	50	35
12	Ascó	30	44	52	30
13	Sarrià	30	38	59	28
14	Prat B	30	27	49	27
15	Molins	30	30	73	20
16	Cambrils	30	25	76	15

TEMPORADA 2021/2022

PRIMERA CATALANA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Tona	26	65	43	60
2	Manlleu	26	42	28	50
3	Sant Just	26	48	39	44
4	UE Vic	26	49	32	42
5	Sant Cugat	26	52	44	42
6	Santfeliuenc	26	40	34	42
7	Santboià	26	37	33	42
8	Can Vidalet	26	41	40	40
9	UA Horta	26	47	42	34
10	Rubí	26	39	40	32
11	Júpiter	26	35	42	31
12	Sant	26	34	48	21
13	Sabadell	26	27	54	20
14	Riuprimer	26	18	55	11

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	CE Europa	20	35	17	44
2	Vilafranca	20	33	16	40
3	Terrassa FC	20	23	11	35
4	Cristóbal	20	17	13	31
5	CE Manresa	20	21	16	29
6	Castelldefel	20	19	20	28
7	Pobla	20	27	25	26
8	Santfeliuenc	20	16	24	22
9	UE Valls	20	12	24	17
10	Igualada	20	14	32	13
11	Montañesa	20	10	29	12
12	Cerdanyola	20	31	15	40
13	Girona FC B	20	29	12	37
14	Granollers	20	32	22	33
15	Sant Andreu	20	24	21	31
16	Vilassar	20	21	21	30
17	FE Grama	20	22	28	27
18	CF Peralada	20	16	18	25
19	UE Sants	20	17	25	24
20	UE Figueres	20	19	32	21
21	UA Horta	20	20	26	18
22	Banyoles	20	13	24	15

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	L´Hospitale	27	59	28	59
2	Terrassa FC	27	42	19	53
3	CE Europa	27	59	31	50
4	Sant Andreu	27	45	28	50
5	CF Peralada	27	38	26	46
6	Pobla	27	37	26	45
7	Vilafranca	27	38	27	44
8	Vilassar	27	44	34	44
9	Granollers	27	50	34	43
10	CE Manresa	27	37	28	39
11	Castelldefel	27	37	37	38
12	UA Horta	27	39	48	36
13	Cerdanyola	27	37	38	35
14	UE Figueres	27	43	48	31
15	Cristóbal	27	31	38	31
16	Santfeliuenc	27	31	44	29
17	Banyoles	27	22	35	28
18	Igualada	27	28	46	25
19	UE Sants	27	29	50	22
20	Reus	27	0	81	0

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Badalona	40	75	31	83
2	L´Hospitale	40	71	31	80
3	UA Horta	40	57	32	79
4	AE Prat	40	51	22	75
5	Sant Andreu	40	65	34	71
6	CE Europa	40	53	41	63
7	Reus	40	58	41	63
8	Terrassa FC	40	52	45	63
9	Vilafranca	40	53	42	62
10	Granollers	40	54	42	61
11	Cerdanyola	40	40	46	50
12	UE Figueres	40	36	46	49
13	Santfeliuenc	40	56	58	49
14	Pobla	40	44	46	48
15	Cristóbal	40	52	70	48
16	Castelldefel	40	39	56	43
17	UE Sants	40	37	56	43
18	FE Grama	40	30	57	33
19	Santboià	40	24	66	31
20	Ascó	40	31	65	30
21	Martinenc	40	34	85	26

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Espanyol B	38	74	25	90
2	Sant Andreu	38	61	24	71
3	L´Hospitale	38	61	31	71
4	Terrassa FC	38	60	38	64
5	AE Prat	38	57	35	63
6	Pobla	38	40	25	63
7	Ascó	38	47	41	60
8	CE Europa	38	48	46	58
9	Vilafranca	38	48	42	54
10	UE Figueres	38	47	43	53
11	UA Horta	38	47	52	50
12	Cerdanyola	38	35	43	48
13	Santboià	38	35	37	48
14	Reus	38	40	50	47
15	Santfeliuenc	38	43	42	46
16	Castelldefel	38	40	46	44
17	Granollers	38	32	54	38
18	Palamós	38	38	64	31
19	CF Gavá	38	28	87	21
20	Vilassar	38	24	80	18

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Olot	38	73	38	80
2	CF Peralada	38	68	27	77
3	Terrassa FC	38	48	26	66
4	Vilafranca	38	60	37	64
5	Sant Andreu	38	51	40	60
6	Ascó	38	44	37	57
7	Pobla	38	43	36	55
8	Granollers	38	47	54	50
9	UE Figueres	38	39	41	50
10	Vilassar	38	40	44	50
11	Palamós	38	49	55	49
12	CE Europa	38	28	32	47
13	Santfeliuenc	38	39	44	45
14	Cerdanyola	38	43	51	45
15	Castelldefel	38	34	51	42
16	Jonquera	38	19	29	42
17	Montañesa	38	32	48	42
18	Manlleu	38	41	59	40
19	Júpiter	38	32	52	35
20	Sabadell B	38	34	63	31

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	AE Prat	38	62	26	76
2	CF Gavá	38	69	38	70
3	CE Europa	38	60	33	68
4	Vilafranca	38	68	55	66
5	Montañesa	38	52	35	65
6	Sabadell B	38	57	41	62
7	Sant Andreu	38	54	46	55
8	Cerdanyola	38	52	50	54
9	Júpiter	38	60	68	51
10	UE Figueres	38	48	40	51
11	Ascó	38	35	43	49
12	Palamós	38	54	54	48
13	Terrassa FC	38	43	61	48
14	CF Peralada	38	50	54	47
15	Manlleu	38	44	58	47
16	Santfeliuenc	38	47	55	45
17	Granollers	38	52	63	44
18	Rubí	38	38	57	39
19	Morell	38	29	70	28
20	Masnou	38	40	67	26

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ascó	38	61	34	72
2	Pobla	38	54	30	69
3	CE Europa	38	53	32	68
4	UE Figueres	38	46	44	59
5	Vilafranca	38	57	56	59
6	AE Prat	38	49	34	59
7	Terrassa FC	38	56	42	59
8	Rubí	38	47	40	54
9	Masnou	38	40	48	51
10	Cerdanyola	38	44	49	49
11	Palamós	38	52	53	49
12	CF Peralada	38	41	50	49
13	Montañesa	38	41	40	48
14	CF Gavá	38	42	54	48
15	Sabadell B	38	46	49	47
16	Santfeliuenc	38	41	48	47
17	Manlleu	38	51	54	45
18	Castelldefel	38	39	47	41
19	Martinenc	38	49	70	37
20	Vilassar	38	28	63	28

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Cornellà	38	58	40	73
2	Montañesa	38	61	31	73
3	CE Europa	38	52	29	69
4	Terrassa FC	38	55	35	69
5	Rubí	38	58	37	69
6	Ascó	38	53	40	68
7	Palamós	38	62	53	61
8	Pobla	38	45	37	57
9	Santfeliuenc	38	46	41	57
10	Manlleu	38	39	39	50
11	UE Figueres	38	51	52	47
12	Cerdanyola	38	52	58	46
13	Vilafranca	38	41	50	44
14	Masnou	38	36	46	44
15	CF Gavá	38	43	52	42
16	Castelldefel	38	47	50	42
17	Vilassar	38	35	49	42
18	Santboià	38	47	54	40
19	Rapitenca	38	31	67	31
20	Gramanet	38	25	77	18

TEMPORADA 2012/2013

PRIMERA CATALANA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ascó	34	81	30	76
2	Viladecans	34	53	23	68
3	Santfeliuenc	34	52	28	68
4	Martinenc	34	60	34	59
5	Igualada	34	55	39	53
6	Vista Alegre	34	52	47	53
7	Amposta	34	49	38	51
8	FC Andorra	34	41	44	47
9	Tàrrega	34	41	49	47
10	Vilanova	34	48	48	44
11	Torreforta	34	42	54	39
12	Tecnofutbol	34	42	58	39
13	Reus Reddis	34	40	74	36
14	Torredembarr	33	43	47	35
15	UE Sants	34	52	66	35
16	Cervera	33	37	55	33
17	UE Valls	34	38	58	33
18	Morell	34	28	62	30

TEMPORADA 2011/2012

PRIMERA CATALANA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rapitenca	34	53	23	72
2	Júpiter	34	81	41	61
3	Vista Alegre	34	66	52	59
4	Martinenc	34	54	41	56
5	Gimnástica	34	54	55	51
6	Reus Reddis	34	51	47	51
7	Santfeliuenc	34	42	46	51
8	UE Tarrega	34	56	49	51
9	UE Sants	34	55	50	49
10	Viladecans	34	47	45	47
11	Torrefota	34	56	58	47
12	Ascó	34	57	39	45
13	Igualada	34	53	58	43
14	UE Valls	34	45	58	43
15	Efac	34	49	49	42
16	Olímpic	34	37	52	38
17	Tortosa	34	41	58	30
18	Olesa	34	23	99	14

Competiciones que juega

Primera Catalana Grupo 3

Pos	Equipos		Pts
1		Vilanova Geltru CF	59
2		At. Sant Just	53
3		Sant Ildefons	48
4		Martorell	45
5		Tortosa Ebre	43
6		Ascó	38
7		At. Vilafranca	38
8		Canonja	36
9		Parc	35
10		Sitges	34
11		Santfeliuenc FC	34
12		Prat B	33
13		Gornal	30
14		El Catllar	29
15		Sarrià	18
16		Morell	17

	Ascenso : Vilanova Geltru CF
	Playoff Ascenso : At. Sant Just
	Posible siguiente ronda : Sant Ildefons
	Descenso : Gornal, El Catllar, Sarrià, Morell

RIVALES EN Primera Catalana

USO DE MEMORIA

6,777,648 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.4458
Total Execution Time	0.4471

CADENA URL

/historico/Fc-Santfeliuenc

GET DATOS

$_GET['/historico/Fc-Santfeliuenc']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0122	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 = 'Fc-Santfeliuenc' 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=6214 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=6214 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6214 AND type_rel = 2
0.0108	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6214 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108	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 (611,78713,93103,104972,110251) ORDER BY n.cover_points DESC, update_date DESC
0.0111	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 = '6214' ORDER BY l.year DESC,cat.coefficient DESC
0.0108	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 = '6214' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108	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=6214 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106	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 (72880) 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.0108	SELECT count(id) as num_players from rel_players WHERE league_id = 72880 AND teamId = 6214
0.0109	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 = '6214' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6214' and rp.type = 4
0.0108	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 = '6214' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0123	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 = 72880 WHERE rp.league_id = 72880 AND rp.teamId = 6214 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.0120	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 = 72880 WHERE rp.league_id = 72880 AND rp.teamId = 6214 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0125	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 = 72880 WHERE rp.league_id = 72880 AND rp.teamId = 6214 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118	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 = 6214 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72880 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120	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 = 68554 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.0123	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 = 63409 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.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* `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 = 58583 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.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* `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 = 50273 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 44393 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 39029 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 33355 AND t.round = 38 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* `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 = 15446 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 3915 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 2555 AND t.round = 38 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* `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 = 1984 AND t.round = 34 ORDER BY team.conference 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* `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 = 1506 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Santfeliuenc FC

Santfeliuenc FC

Selecciona un equipo

Competiciones que juega

Primera Catalana Grupo 3

RIVALES EN Primera Catalana