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

Sanremese

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE D GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Alcione	37	69	26	78
2	Chisola	37	59	36	69
3	RG Ticino	37	57	36	65
4	Città	37	48	32	65
5	Vado FC	37	50	27	64
6	AS Bra	37	45	30	62
7	Ligorna	37	44	37	62
8	ASD Asti	37	42	31	59
9	Albenga	37	49	32	57
10	Fezzanese	37	41	45	51
11	Sanremese	37	31	32	49
12	Lavagnese	37	45	45	44
13	Gozzano	37	34	37	44
14	Derthona	37	34	52	40
15	Chieri	37	39	51	39
16	Voghera	37	40	56	39
17	Pinerolo	37	25	42	37
18	Alba Calcio	37	37	63	34
19	PDHAE	37	24	60	22
20	Borgosesia	37	24	67	19

TEMPORADA 2022/2023

SERIE D GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sestri	38	77	29	94
2	AS Bra	38	59	31	74
3	Sanremese	38	59	33	74
4	Vado FC	38	61	40	69
5	Ligorna	38	50	36	66
6	AC Legnano	38	53	35	60
7	ASD Asti	38	44	35	57
8	Gozzano	38	51	48	55
9	Borgosesia	38	54	54	52
10	PDHAE	38	33	43	47
11	Castellanzes	38	51	55	46
12	Chieri	38	41	45	45
13	Fezzanese	38	47	58	45
14	Chisola	38	43	53	43
15	Pinerolo	38	38	44	42
16	Derthona	38	55	62	42
17	Castanese	38	43	57	39
18	Stresa	38	37	47	34
19	Casale	38	28	79	24
20	Fossano	38	40	80	14

TEMPORADA 2021/2022

SERIE D GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Novara	38	75	27	85
2	Sanremese	38	69	38	77
3	Casale	38	49	30	64
4	Città	38	53	34	63
5	Derthona	38	49	44	55
6	AS Bra	38	41	43	55
7	Caronnese	38	40	34	53
8	Borgosesia	38	47	41	52
9	Chieri	38	44	40	52
10	Sestri	38	45	47	52
11	Gozzano	38	43	29	51
12	Ligorna	38	44	45	48
13	Vado FC	38	42	51	48
14	PDHAE	38	43	53	48
15	ASD Asti	38	40	41	47
16	Fossano	38	38	62	44
17	RG Ticino	38	33	45	44
18	Imperia	38	37	57	33
19	Lavagnese	38	30	62	30
20	Saluzzo	38	20	59	18

TEMPORADA 2020/2021

SERIE D GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Gozzano	38	62	33	78
2	Castellanzes	38	83	66	71
3	PDHAE	38	61	41	70
4	AS Bra	38	62	36	69
5	Sanremese	38	57	41	65
6	AC Legnano	38	66	55	64
7	Sestri	38	64	48	60
8	Folgore	38	50	43	57
9	Lavagnese	38	62	63	56
10	Caronnese	38	52	52	53
11	Imperia	38	43	49	49
12	Casale	38	42	41	48
13	Derthona	38	42	49	47
14	Arconatese	38	51	61	45
15	Chieri	38	47	43	44
16	Città	38	40	44	42
17	Saluzzo	38	31	51	37
18	Fossano	38	40	69	32
19	Borgosesia	38	47	77	30
20	Vado FC	38	36	76	26

TEMPORADA 2019/2020

SERIE D GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lucchese	25	32	19	48
2	Prato	25	47	26	47
3	Seravezza	25	46	33	43
4	Casale	25	40	28	43
5	Caronnese	24	45	29	42
6	Savona	25	33	31	36
7	Real Forte.	25	29	27	36
8	Borgosesia	25	34	31	35
9	Sanremese	25	30	27	33
10	Chieri	25	30	31	33
11	Fossano	25	38	38	32
12	Lavagnese	25	25	31	27
13	AS Bra	25	32	34	26
14	Ghivizzano	25	35	47	26
15	Fezzanese	25	26	39	26
16	Vado FC	25	30	43	24
17	Verbania	24	19	42	23
18	Ligorna	25	31	46	22

TEMPORADA 2018/2019

SERIE D GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lecco	34	75	23	86
2	Sanremese	34	49	35	59
3	Savona	34	49	33	55
4	Inveruno	34	59	45	54
5	Folgore	34	55	39	54
6	Casale	34	40	28	54
7	Ligorna	34	49	40	54
8	AS Bra	34	47	45	48
9	Chieri	34	53	45	45
10	Lavagnese	34	47	47	42
11	Borgosesia	34	43	50	41
12	Fezzanese	34	40	49	41
13	Bustese	34	36	51	40
14	Sestri	34	36	50	38
15	Arconatese	34	37	47	36
16	Pro Dronero	34	37	66	29
17	Stresa	34	26	49	26
18	Borgaro	34	27	63	26

TEMPORADA 2017/2018

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Albissola	34	56	30	69
2	Sanremese	34	58	34	67
3	Ponsacco	34	49	31	62
4	Real Forte.	34	50	27	60
5	Viareggio	34	57	46	60
6	Massese	34	50	33	56
7	Savona	34	53	34	55
8	Seravezza	34	44	33	51
9	Donato	34	41	34	46
10	Ghivizzano	34	48	45	44
11	Ligorna	34	41	50	43
12	Sestri	34	35	34	42
13	Lavagnese	34	35	42	41
14	Rignanese	34	36	60	38
15	Scandicci	34	42	54	34
16	Finale 1908	34	38	49	30
17	Argentina	34	29	71	21
18	Valdinievole	34	19	74	15

TEMPORADA 2016/2017

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Follonica	34	64	36	70
2	Massese	34	59	37	64
3	Savona	34	58	31	62
4	Lavagnese	34	58	40	61
5	Finale 1908	34	51	46	51
6	Sanremese	34	50	34	50
7	Argentina	34	42	35	48
8	Ponsacco	34	46	45	48
9	Real Forte.	34	52	41	47
10	Ligorna	34	54	56	46
11	Valdinievole	34	40	44	46
12	Sestri	34	46	45	42
13	Jolly	34	34	35	41
14	Fezzanese	34	40	52	39
15	Viareggio	34	43	59	38
16	Ghivizzano	34	43	53	34
17	Sporting	34	36	64	27
18	Grosseto	34	27	90	16

TEMPORADA 2010/2011

LEGA PRO 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tritium	32	49	25	59
2	Feralpisalò	32	36	22	57
3	Pro Patria	32	57	34	52
4	Vercelli	32	36	23	52
5	Renate	32	42	28	50
6	Savona	32	36	26	49
7	Lecco	32	32	34	47
8	Montichiari	32	28	28	41
9	Rodengo	32	28	29	41
10	Casale	32	25	41	37
11	FC Canavese	32	33	33	36
12	Sambonifaces	32	36	41	34
13	Valenzana	32	24	33	33
14	Virtus	32	30	35	31
15	Sanremese	32	24	38	27
16	Sacilese	32	27	45	27
17	Mezzocorona	32	24	52	23

TEMPORADA 2006/2007

LEGA PRO 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	AC Legnano	34	34	22	61
2	Lecco	34	42	28	60
3	Pergocrema	34	45	35	59
4	Nuorese	34	45	31	57
5	Bassano	34	44	31	55
6	Carpenedolo	34	47	41	52
7	Südtirol	34	37	33	49
8	Vercelli	34	38	35	45
9	Olbia Calcio	34	31	33	42
10	Valenzana	34	33	38	42
11	Sassari	34	33	39	42
12	Varese	34	32	35	41
13	Cuneo	34	43	46	38
14	Lumezzane	34	25	36	37
15	Calcio	34	35	43	36
16	Montichiari	34	29	36	34
17	Biellese	34	32	49	33
18	Sanremese	34	18	32	31

TEMPORADA 2005/2006

LEGA PRO 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Venezia	34	49	27	69
2	Cuneo	34	44	27	64
3	Ivrea Calcio	34	34	23	60
4	Südtirol	34	36	27	55
5	Carpenedolo	34	36	27	53
6	Vercelli	34	35	30	50
7	Sanremese	34	33	34	46
8	Pergocrema	34	35	33	45
9	Valenzana	34	36	35	42
10	Lecco	34	32	32	41
11	AC Legnano	34	34	35	41
12	Montichiari	34	30	27	40
13	Bassano	34	37	36	40
14	Citta Jesolo	34	38	44	38
15	Calcio	34	34	40	38
16	Biellese	34	28	51	33
17	Olbia Calcio	34	30	46	30
18	Casale	34	21	48	21

Competiciones que juega

Grupo 1

Serie D Grupo 1

Pos	Equipos		Pts
1		Alcione	78
2		Chisola Calcio	69
3		RG Ticino	65
4		Città di Varese	65
5		Vado FC	64
6		AS Bra	62
7		Ligorna	62
8		ASD Asti	59
9		Albenga	57
10		Fezzanese	51
11		Sanremese	49
12		Lavagnese	44
13		Gozzano	44
14		Derthona	40
15		Chieri	39
16		Voghera	39
17		Pinerolo	37
18		Alba Calcio	34
19		PDHAE	22
20		Borgosesia	19

	Ascenso : Alcione
	Playoff Ascenso : Chisola Calcio, RG Ticino, Città di Varese, Vado FC
	Playoff Descenso : Chieri, Voghera, Pinerolo, Alba Calcio
	Descenso : PDHAE, Borgosesia

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D

USO DE MEMORIA

6,738,184 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1148
Total Execution Time	0.1160

CADENA URL

/historico/Sanremese

GET DATOS

$_GET['/historico/Sanremese']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

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 = 73979
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6504 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=222 AND type_rel = 3
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 222 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021	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 (1244039,1222208,1221521,1177309,1176862) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '6504' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 73979 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=6504 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 (73979,73559,71632) 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 = 73979 AND teamId = 6504
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 6504
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71632 AND teamId = 6504
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 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 = 73979 AND t.round = 37 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '6504' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6504' 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 = '6504' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 = 73979 WHERE rp.league_id = 73979 AND rp.teamId = 6504 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 = 73979 WHERE rp.league_id = 73979 AND rp.teamId = 6504 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 73979 WHERE rp.league_id = 73979 AND rp.teamId = 6504 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 6504 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73979 AND t.round = 37 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* `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 = 68747 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 = 64275 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.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* `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 = 58826 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.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* `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 = 51156 AND t.round = 25 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* `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 = 44796 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 = 38853 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 = 33453 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* `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 = 1634 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* `tables2007` 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 = 19908 AND t.round = 31 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* `tables2006` 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 = 19911 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Sanremese

Sanremese

Selecciona un equipo

Competiciones que juega

Serie D Grupo 1

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D