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

Ponsacco

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Pianese	33	61	34	67
2	Grosseto	33	52	30	63
3	Follonica	33	43	25	62
4	Livorno	33	49	31	59
5	Altopascio	33	54	30	57
6	Seravezza	33	47	39	54
7	Ghivizzano	33	54	53	50
8	Poggibonsi	33	44	41	49
9	AS Figline	33	44	39	49
10	Sangiovannes	33	29	34	42
11	Montevarchi	33	39	40	40
12	Sporting	33	40	44	40
13	Donato	33	29	32	39
14	Orvietana	33	32	44	35
15	Real Forte.	33	30	44	28
16	Vivi	33	23	45	28
17	Ponsacco	33	33	57	20
18	SC Cenaia	33	26	67	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 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 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 2015/2016

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Gubbio 1910	34	54	29	74
2	Valdinievole	34	53	33	63
3	Follonica	34	53	36	61
4	Poggibonsi	34	41	23	55
5	Colligiana	34	55	39	52
6	Jolly	34	42	33	52
7	Ghivizzano	34	46	44	52
8	Foligno	34	48	42	49
9	Sangiovannes	34	47	48	48
10	Ponsacco	34	39	40	48
11	Pianese	34	45	35	47
12	Viareggio	34	37	33	46
13	Città	34	39	49	44
14	Scandicci	34	31	46	35
15	Massese	34	29	35	33
16	Sansepolcro	34	26	37	32
17	Gualdo	34	23	58	21
18	Voluntas	34	24	72	20

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 2010/2011

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Borgo	34	53	23	69
2	Pontedera	34	47	29	62
3	Bagnolese	34	55	38	56
4	Virtus	34	43	28	54
5	Mezzolara	34	51	48	53
6	Camaiore	34	44	39	52
7	Forcoli 1921	34	42	39	51
8	Pergolettese	34	46	39	47
9	Rosignano	34	39	32	47
10	Rudianese	34	41	37	47
11	Tuttocuoio	34	38	35	46
12	Fiorenzuola	34	38	40	46
13	Ponsacco	34	28	23	44
14	Virtus	34	37	40	44
15	Carpenedolo	34	44	47	38
16	Castel	34	33	48	31
17	US Russi	34	31	52	29
18	Nuova	34	14	87	6

TEMPORADA 2009/2010

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Pisa SC	38	66	24	82
2	AC Carpi	38	59	35	65
3	Fossombrone	38	49	32	65
4	AC Chioggia	38	63	40	61
5	Santarcangel	38	48	38	61
6	Rosignano	38	45	36	59
7	US Russi	38	53	38	57
8	Virtus	38	43	38	56
9	Rovigo	38	51	44	55
10	Borgo	38	39	45	50
11	ASD Cecina	38	33	37	48
12	Mezzolara	38	35	41	46
13	Pontedera	38	43	44	45
14	Castellana	38	42	49	45
15	Ponsacco	38	39	48	45
16	Riccione	38	46	56	42
17	Castel	38	34	50	36
18	Adriese	38	34	64	34
19	Dorando	38	38	66	29
20	Castellarano	38	36	71	24

TEMPORADA 2008/2009

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Lucchese	38	86	28	83
2	Sansepolcro	38	52	36	71
3	Follonica	38	69	35	65
4	AS Sestese	38	51	36	62
5	Montevarchi	38	61	48	62
6	Deruta	38	51	36	61
7	GSD Arrone	38	66	62	61
8	Rieti	38	53	47	57
9	Pontedera	38	50	38	56
10	ASD Cecina	38	42	47	52
11	Ponsacco	38	42	47	50
12	Scandicci	38	45	53	50
13	Forcoli 1921	38	41	52	47
14	Orvietana	38	39	37	46
15	Sansovino	38	55	57	45
16	Fortis	38	36	47	44
17	Pontevecchio	38	47	59	41
18	Sangimignano	38	37	54	39
19	Armando	38	34	55	34
20	Massese	38	24	107	8

Competiciones que juega

Grupo 5

Serie D Grupo 5

Pos	Equipos		Pts
1		Pianese	67
2		Grosseto	63
3		Follonica Gavorrano	62
4		Livorno	59
5		Tau Altopascio	57
6		Seravezza	54
7		Ghivizzano Borgo	50
8		Poggibonsi	49
9		AS Figline	49
10		Sangiovannese	42
11		Montevarchi Calcio	40
12		Sporting Trestina	40
13		San Donato Tavarnelle	39
14		Orvietana Calcio	35
15		Real Forte Querceta	28
16		Vivi Altotevere Sansepolcr.	28
17		Ponsacco	20
18		SC Cenaia	16

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

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D

USO DE MEMORIA

6,639,176 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.5395
Total Execution Time	0.5408

CADENA URL

/historico/Mobilieri-Ponsacco

GET DATOS

$_GET['/historico/Mobilieri-Ponsacco']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0136	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 = 'Mobilieri-Ponsacco' 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.0130	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=24970 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=24970 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=24970 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=24970 AND type_rel = 2
0.0148	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 = '24970' ORDER BY l.year DESC,cat.coefficient DESC
0.0143	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 = '24970' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '24970' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	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=24970 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130	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) 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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 73983 AND teamId = 24970
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 24970
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 71633 AND teamId = 24970
0.0131	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 = '24970' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '24970' and rp.type = 4
0.0136	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 = '24970' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0188	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 = 24970 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.0165	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 = 24970 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 24970 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 24970 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0252	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.0132	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.0131	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.0132	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.0130	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.0133	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.0132	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 = 15653 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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.0131	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 = 24697 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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* `tables2010` 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 = 24712 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 24731 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Ponsacco

Ponsacco

Selecciona un equipo

Competiciones que juega

Serie D Grupo 5

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D