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

FC Savoia 1908

Temporada 2020/2021

TEMPORADA 2020/2021

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Monterosi	34	65	26	81
2	Latina	34	60	29	65
3	Savoia 1908	34	39	22	57
4	Nocerina	34	51	32	53
5	Vis Artena	34	51	43	53
6	Insieme	34	52	39	50
7	Lanusei	34	46	40	47
8	Muravera	34	42	40	47
9	Carbonia	34	56	55	46
10	Latte Dolce	34	45	42	44
11	Cassino	34	41	48	41
12	Gladiator	34	37	44	40
13	Team Nuova.	34	39	48	39
14	Arzachena	34	39	50	36
15	Sassari	34	31	48	34
16	Afragolese	34	40	60	34
17	Nola 1925	34	37	58	34
18	Giugliano	34	29	76	20

TEMPORADA 2019/2020

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Palermo FC	26	47	16	63
2	Savoia 1908	26	41	15	56
3	Giugliano	26	40	26	47
4	FC Messina	26	37	20	46
5	Troina	26	30	28	46
6	Acireale	26	44	32	43
7	Licata	26	36	30	41
8	ACR Messina	26	30	29	36
9	Nola 1925	26	32	31	36
10	Biancavilla	26	23	32	35
11	Cittanova	26	31	37	33
12	Castrovillar	26	43	39	32
13	Marina	26	22	29	28
14	Roccella	26	22	26	25
15	Corigliano	26	26	52	25
16	Marsala	26	25	38	24
17	San Tommaso	26	25	46	21
18	Palmese	26	21	49	12

TEMPORADA 2018/2019

SERIE D GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Picerno	34	67	24	81
2	Audace	34	68	28	75
3	Taranto	34	65	28	71
4	USD Bitonto	34	54	31	59
5	Savoia 1908	34	40	27	59
6	Fidelis	34	37	26	56
7	Città	34	58	50	50
8	Gravina	34	48	43	48
9	Team	34	43	49	47
10	Sorrento	34	47	50	43
11	Francavilla	34	30	35	43
12	Nardò	34	30	39	37
13	Gelbison	34	37	49	37
14	Sarnese	34	32	50	36
15	Nola 1925	34	36	55	36
16	Gragnano	34	30	43	33
17	Pomigliano	34	17	59	19
18	Granata 1924	34	21	74	14

TEMPORADA 2014/2015

SERIE C GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Salernitana	38	56	31	80
2	Benevento	38	55	29	76
3	Juve Stabia	38	58	37	70
4	Matera	38	56	38	70
5	Casertana	38	59	35	69
6	Lecce	38	50	32	67
7	Calcio	38	63	36	66
8	Catanzaro	38	48	44	53
9	Melfi	38	43	44	48
10	Barletta	38	35	42	47
11	Cosenza	38	37	39	44
12	Vigor	38	43	48	44
13	Lupa Roma	38	40	62	40
14	Martina	38	34	42	38
15	Paganese	38	30	45	37
16	Real Agro A.	38	36	50	34
17	ACR Messina	38	38	55	34
18	Ischia	38	32	55	34
19	Savoia 1908	38	36	59	32
20	Reggina	38	33	59	32

TEMPORADA 2013/2014

SERIE D GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Piacenza	1	3	2	3
2	Giana	2	3	5	0
3	Ancona	1	2	1	3
4	Pordenone	1	2	1	3
5	Lucchese	1	0	0	1
6	Pistoiese	2	1	2	1
7	Lupa Roma	1	2	1	3
8	Matera	1	0	0	1
9	Savoia 1908	2	1	2	1

TEMPORADA 2012/2013

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	ACR Messina	34	59	24	77
2	Cosenza	34	65	41	73
3	Gelbison	34	39	28	60
4	FC Messina	34	55	40	58
5	Vibonese	34	42	31	51
6	Comprensorio	34	40	37	50
7	Savoia 1908	34	54	52	48
8	Cavese 1919	34	47	38	47
9	Noto	34	46	36	46
10	Licata	34	50	46	46
11	Rios	34	39	37	46
12	Montalto	34	44	38	45
13	Palazzolo	34	44	45	44
14	Agropoli	34	35	37	44
15	Ragusa	34	38	42	39
16	Sambiase	34	42	43	38
17	Acireale	34	21	74	15
18	Nissa	34	12	83	8

TEMPORADA 2008/2009

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Siracusa	36	72	29	81
2	Vico Equense	35	53	24	63
3	Sapri Calcio	36	55	36	61
4	Nissa	35	59	38	59
5	Comprensorio	36	46	35	55
6	Rosarno	36	48	36	53
7	Viribus	36	44	43	52
8	Turris	36	47	44	51
9	HinterReggio	36	41	37	50
10	Modica	36	31	35	49
11	ACRD	35	37	34	47
12	ACR Messina	36	29	34	47
13	Trapani	36	38	40	46
14	Palazzolo	36	37	47	41
15	Puteolana	36	23	42	41
16	Castrovillar	36	28	41	40
17	Savoia 1908	36	30	53	31
18	Vittoria	35	34	61	30
19	Castiglione	36	25	68	20

TEMPORADA 2000/2001

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Palermo FC	34	47	31	64
2	ACR Messina	34	40	26	61
3	Catania	34	49	40	58
4	Avellino	34	45	27	57
5	Ascoli	34	47	33	54
6	Sassari	34	55	45	53
7	Castel	34	44	40	47
8	L'Aquila	34	37	35	46
9	Fermana	34	41	38	42
10	Real	34	36	40	42
11	Vis Pesaro	34	26	29	39
12	Lodigiani	34	34	44	39
13	Benevento	34	40	54	39
14	Nocerina	34	29	42	36
15	Viterbese	34	32	48	29
16	Atl. Catania	34	27	44	27

TEMPORADA 1999/2000

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Vicenza	38	69	45	67
2	Atalanta	38	51	34	63
3	Brescia	38	54	38	63
4	Napoli	38	55	44	63
5	Sampdoria	38	45	40	62
6	Genoa	38	51	42	57
7	Salernitana	38	55	61	52
8	Treviso	38	56	48	51
9	Empoli	38	42	52	51
10	Ternana	38	45	47	49
11	Pistoiese	38	39	43	49
12	Ravenna FC	38	41	39	48
13	Cosenza	38	36	41	48
14	Pescara	38	62	55	47
15	AC Monza	38	45	46	47
16	Chievo	38	48	53	47
17	Cesena	38	47	45	45
18	AlzanoCene	38	39	51	42
19	Savoia 1908	38	36	62	29
20	Fermana	38	36	66	29

Competiciones que juega

Serie D Grupo 7

Pos	Equipos		Pts
1		Monterosi Tuscia	81
2		Latina	65
3		FC Savoia 1908	57
4		Nocerina	53
5		Vis Artena	53
6		Insieme Formia	50
7		Lanusei	47
8		Muravera	47
9		Carbonia	46
10		Latte Dolce	44
11		Cassino	41
12		Gladiator	40
13		Team Nuova Florida	39
14		Arzachena	36
15		Sassari Torres	34
16		Afragolese	34
17		Nola 1925	34
18		SSC Giugliano	20

	Ascenso : Monterosi Tuscia
	Playoff Ascenso : Latina, FC Savoia 1908, Nocerina, Vis Artena
	Playoff Descenso : Team Nuova Florida, Arzachena, Sassari Torres, Afragolese
	Descenso : Nola 1925, SSC Giugliano

RIVALES EN Serie D Italia -.

RIVALES EN Serie D

USO DE MEMORIA

6,136,504 bytes

BENCHMARKS

Loading Time Base Classes	0.0025
Controller Execution Time ( Home / Category )	4.9514
Total Execution Time	4.9540

CADENA URL

/historico/Savoia-1908

GET DATOS

$_GET['/historico/Savoia-1908']

POST DATOS

No hay datos POST existentes

CONSULTAS (56)

0.2162	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 = 'Savoia-1908' 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.4260	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 = 'Savoia-1908' 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=2821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=2821 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=2821 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=2821 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=2821 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=2821 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=2821 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=2821 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=2821 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=2821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=2821 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=2821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=2821 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=2821 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=2821 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=2821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=2821 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=2821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=2821 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=2821 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=2821 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=2821 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=2821 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=2821 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=2821 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=2821 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=2821 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025	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 = 63095
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2821 AND type_rel = 2
0.0662	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 = '2821' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.3059	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 = '2821' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.1963	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 = '2821' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0574	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 = 63095 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.1860	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=2821 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0245	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 (63095,58832,51105) 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.1853	SELECT count(id) as num_players from rel_players WHERE league_id = 58832 AND teamId = 2821
0.1268	SELECT count(id) as num_players from rel_players WHERE league_id = 51105 AND teamId = 2821
0.2414	SELECT count(id) as num_players from rel_players WHERE league_id = 63095 AND teamId = 2821
0.0043	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 = '2821' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0269	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2821' and rp.type = 4
0.0371	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 = '2821' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.4829	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 events2021 e ON e.player_id = p.id AND e.league_id = 58832 WHERE rp.league_id = 58832 AND rp.teamId = 2821 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.2287	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 events2021 e ON e.player_id = p.id AND e.league_id = 58832 WHERE rp.league_id = 58832 AND rp.teamId = 2821 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.2060	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 events2021 e ON e.player_id = p.id AND e.league_id = 58832 WHERE rp.league_id = 58832 AND rp.teamId = 2821 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.2784	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 = 2821 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.3826	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 = 58832 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.1542	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 = 51164 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.1767	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 = 44803 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0341	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 = 24687 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1291	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 = 24690 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1496	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 = 2092 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0913	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* `tables2009` 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 = 24736 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2235	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* `tables2001` 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 = 591 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2140	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* `tables2000` 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 = 514 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

FC Savoia 1908

FC Savoia 1908

Selecciona un equipo

Competiciones que juega

Serie D Grupo 7

RIVALES EN Serie D Italia -.

RIVALES EN Serie D