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

Sporting Trestina

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Pianese	32	58	32	64
2	Follonica	32	43	25	61
3	Grosseto	32	49	30	57
4	Altopascio	32	53	29	56
5	Livorno	32	47	30	56
6	Seravezza	32	45	36	54
7	Poggibonsi	32	43	39	49
8	AS Figline	32	42	37	48
9	Ghivizzano	32	51	52	47
10	Donato	32	29	30	41
11	Sporting	32	39	42	40
12	Sangiovannes	32	27	33	39
13	Montevarchi	32	38	40	37
14	Orvietana	32	31	42	35
15	Vivi	32	23	44	28
16	Real Forte.	32	30	44	27
17	Ponsacco	32	31	55	19
18	SC Cenaia	32	25	64	16

TEMPORADA 2022/2023

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	SS Arezzo	34	54	30	70
2	Pianese	34	58	42	63
3	Poggibonsi	34	65	43	58
4	Follonica	34	52	41	55
5	Flaminia	34	47	40	49
6	Livorno	34	39	35	49
7	Seravezza	34	41	41	47
8	Ghivizzano	34	40	41	43
9	Altopascio	34	41	43	42
10	Orvietana	34	38	42	42
11	Sangiovannes	34	38	37	41
12	Grosseto	34	37	40	41
13	Ostia Mare	34	30	34	41
14	Ponsacco	34	39	53	38
15	Sporting	34	40	48	37
16	Terranuova	34	31	45	35
17	Montespaccat	34	30	45	33
18	Città	34	32	52	32

TEMPORADA 2021/2022

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Donato	34	86	30	81
2	Poggibonsi	34	61	28	74
3	SS Arezzo	34	65	45	64
4	Follonica	34	63	30	63
5	Pianese	34	58	42	56
6	Lornano	34	47	43	54
7	Sporting	34	48	43	49
8	Flaminia	34	49	50	46
9	Montespaccat	34	43	44	42
10	ASD Cascina	34	39	40	42
11	Tiferno	34	36	48	42
12	Sangiovannes	34	37	39	41
13	Scandicci	34	36	44	41
14	Foligno	34	46	65	35
15	Rieti	34	39	58	35
16	Unipomezia	34	38	64	31
17	Cannara	34	27	52	24
18	Pro Livorno	34	31	84	21

TEMPORADA 2020/2021

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Montevarchi	34	68	32	71
2	Trastevere	34	56	38	60
3	Sporting	34	48	33	56
4	Donato	34	48	41	54
5	Siena	34	48	40	53
6	Pianese	34	42	34	51
7	Follonica	34	48	37	51
8	Lornano	34	51	44	48
9	Tiferno	34	44	48	47
10	Cannara	34	41	48	47
11	Sangiovannes	34	42	43	45
12	Montespaccat	34	40	47	41
13	Ostia Mare	34	50	54	39
14	Flaminia	34	44	57	39
15	Foligno	34	35	48	36
16	Scandicci	34	42	49	35
17	Grassina	34	32	52	30
18	Sinalunghese	34	24	58	23

TEMPORADA 2019/2020

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Grosseto	26	44	25	52
2	Monterosi	26	35	20	50
3	Grassina	26	39	32	46
4	Albalonga	26	36	24	45
5	Montevarchi	26	35	26	40
6	Scandicci	26	45	30	39
7	Foligno	26	33	27	36
8	Aglianese	26	35	30	34
9	Follonica	26	33	31	34
10	Flaminia	26	31	29	34
11	Cannara	26	31	31	33
12	Sporting	26	34	35	33
13	Sangiovannes	26	25	37	32
14	Donato	26	30	32	31
15	Pomezia	26	23	34	26
16	Bastia	26	22	36	26
17	Ponsacco	26	20	46	17
18	Tuttocuoio	26	19	45	16

TEMPORADA 2018/2019

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Pianese	38	58	21	74
2	Ponsacco	38	61	27	73
3	Seravezza	38	62	42	65
4	Follonica	38	49	34	64
5	Montevarchi	38	49	38	64
6	Donato	38	51	32	63
7	Ghivizzano	38	50	37	60
8	Prato	38	50	48	55
9	Tuttocuoio	38	43	43	55
10	Cannara	38	33	38	51
11	Sporting	38	39	40	50
12	Aglianese	38	43	52	46
13	Real Forte.	38	42	54	46
14	Sangiovannes	38	36	41	45
15	Bastia	38	45	56	45
16	Scandicci	38	44	53	43
17	Viareggio	38	42	50	37
18	Sinalunghese	38	30	54	37
19	Sangimignano	38	22	51	36
20	Massese	38	26	64	16

TEMPORADA 2017/2018

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Rimini	38	65	38	80
2	Imolese	38	72	45	71
3	Forli	38	60	43	65
4	Fiorenzuola	38	50	32	64
5	Sangiovannes	38	42	38	61
6	Lentigione	38	45	33	60
7	Villabiagio	38	52	49	59
8	Pianese	38	54	35	58
9	Montevarchi	38	42	40	56
10	Romagna	38	49	42	54
11	Sammaurese	38	34	29	54
12	Vigor	38	50	48	45
13	Sasso	38	35	48	45
14	Tuttocuoio	38	25	34	42
15	Sporting	38	36	52	41
16	Castelvetro	38	46	62	38
17	Mezzolara	38	34	50	36
18	Sansepolcro	38	40	62	33
19	Correggese	38	37	55	32
20	Colligiana	38	27	60	29

TEMPORADA 2016/2017

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Arzachena	34	62	21	74
2	Monterosi	34	69	22	73
3	Rieti	34	67	29	71
4	L'Aquila	34	57	27	63
5	Ostia Mare	34	59	33	63
6	Nuorese	34	43	33	58
7	Albalonga	34	59	42	55
8	Avezzano	34	42	36	46
9	Sansepolcro	34	50	47	46
10	Flaminia	34	48	41	45
11	Lanusei	34	45	52	44
12	Sporting	34	46	44	43
13	Latte Dolce	34	34	44	38
14	San Teodoro	34	32	57	31
15	Muravera	34	24	51	30
16	Sassari	34	23	58	28
17	Città	34	25	64	24
18	Foligno	34	12	96	12

TEMPORADA 2014/2015

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Siena	34	63	30	72
2	Poggibonsi	34	45	24	68
3	Rieti	34	57	31	61
4	Ponsacco	34	53	33	61
5	Massese	34	51	33	58
6	Sansepolcro	34	50	36	55
7	Gualdo	34	50	46	49
8	Sangiovanniv	34	44	42	49
9	Foligno	34	51	42	48
10	Flaminia	34	48	60	46
11	Pianese	34	47	47	43
12	Follonica	34	43	49	42
13	Voluntas	34	40	51	39
14	Colligiana	34	30	41	37
15	Donato	34	47	59	37
16	Villabiagio	34	42	57	31
17	Sporting	34	32	58	25
18	Bastia	34	26	80	10

TEMPORADA 2013/2014

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Pistoiese	34	78	28	77
2	Foligno	34	46	20	69
3	SS Arezzo	34	57	27	64
4	Pianese	34	60	38	63
5	Scandicci	34	51	42	62
6	Ostia Mare	34	53	41	52
7	Colligiana	34	41	39	50
8	Sansepolcro	34	51	44	45
9	Gualdo	34	42	44	43
10	Sporting	34	41	44	42
11	Flaminia	34	40	43	42
12	Voluntas	34	46	48	41
13	Jolly	34	38	36	40
14	Bastia	34	38	58	39
15	Deruta	34	38	60	31
16	FiesoleCal..	34	32	65	28
17	Narnese	34	28	62	21
18	Pontevecchio	34	42	83	20

TEMPORADA 2012/2013

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Castel	34	58	25	68
2	Gualdo	34	69	35	67
3	Viterbese	34	58	37	63
4	Sansepolcro	34	41	28	58
5	Deruta	34	50	49	49
6	Voluntas	34	41	41	49
7	Pianese	34	39	39	47
8	FiesoleCal..	34	41	42	47
9	SS Arezzo	34	49	34	46
10	Sporting	33	35	31	45
11	Bastia	34	38	39	45
12	Sporting	33	43	48	44
13	Scandicci	34	40	48	44
14	Pontevecchio	34	38	51	44
15	Flaminia	34	38	49	37
16	Lanciotto	34	32	44	35
17	Pierantonio	34	30	60	27
18	Todi	34	30	70	19

TEMPORADA 2011/2012

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Pontedera	34	67	28	75
2	SS Arezzo	34	70	39	65
3	Pianese	34	54	46	53
4	Castel	34	55	42	50
5	Sporting	34	37	37	47
6	Sporting	34	48	50	47
7	Voluntas	34	43	45	47
8	Pierantonio	34	47	51	47
9	Deruta	34	36	36	46
10	Viterbese	34	42	46	46
11	Flaminia	34	50	40	44
12	Todi	34	31	30	44
13	Sansepolcre	34	38	39	44
14	Orvietana	34	47	52	40
15	Pontevecchio	34	34	48	37
16	Zagarolo	34	47	71	34
17	Città	34	34	61	31
18	Sansovino	34	33	52	30

Competiciones que juega

Grupo 5

Serie D Grupo 5

Pos	Equipos		Pts
1		Pianese	64
2		Follonica Gavorrano	61
3		Grosseto	57
4		Tau Altopascio	56
5		Livorno	56
6		Seravezza	54
7		Poggibonsi	49
8		AS Figline	48
9		Ghivizzano Borgo	47
10		San Donato Tavarnelle	41
11		Sporting Trestina	40
12		Sangiovannese	39
13		Montevarchi Calcio	37
14		Orvietana Calcio	35
15		Vivi Altotevere Sansepolcr.	28
16		Real Forte Querceta	27
17		Ponsacco	19
18		SC Cenaia	16

	Ascenso : Pianese
	Playoff Ascenso : Follonica Gavorrano, Grosseto, Tau Altopascio, Livorno
	Playoff Descenso : Montevarchi Calcio, Orvietana Calcio, Vivi Altotevere Sansepolcro, Real Forte Querceta
	Descenso : Ponsacco, SC Cenaia

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D

USO DE MEMORIA

6,856,112 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1275
Total Execution Time	0.1287

CADENA URL

/historico/Sporting-Trestina

GET DATOS

$_GET['/historico/Sporting-Trestina']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

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 = 'Sporting-Trestina' 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.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=6915 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=6915 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=6915 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=6915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039	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 = 73559
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6915 AND type_rel = 2
0.0030	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 = '6915' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '6915' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028	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=6915 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 (73983,73559,71633,71432) 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.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 73983 AND teamId = 6915
0.0054	SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 6915
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71633 AND teamId = 6915
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6915
0.0039	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 = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 6915 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.0035	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 = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 6915 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 6915 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 6915 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73983 AND t.round = 33 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 = 68751 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.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* `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 = 64279 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.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 = 58830 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.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* `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 = 51160 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 = 44800 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* `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 = 39598 AND t.round = 38 ORDER BY team.conference 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* `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 = 33455 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* `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 = 4818 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 24677 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* `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 = 2091 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* `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 = 1695 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Sporting Trestina

Sporting Trestina

Selecciona un equipo

Competiciones que juega

Serie D Grupo 5

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D