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

Scandicci

Temporada 2022/2023

TEMPORADA 2022/2023

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Giana	38	77	31	80
2	Pistoiese	38	56	32	73
3	AC Carpi	38	58	44	59
4	Forli	38	54	42	57
5	Real Forte.	38	49	41	57
6	Corticella	38	63	62	57
7	Ravenna FC	38	52	47	56
8	Sammaurese	38	49	44	51
9	Aglianese	38	51	46	50
10	Riccione	38	50	51	50
11	Prato	38	57	59	49
12	Mezzolara	38	43	47	49
13	Crema	38	56	56	48
14	Lentigione	38	49	52	48
15	Correggese	38	41	48	48
16	Fanfulla	38	48	57	48
17	Sant Angelo	38	45	51	45
18	Scandicci	38	46	57	42
19	Bagnolese	38	30	48	38
20	Salsomaggior	38	21	80	13

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 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 4
Equipo		PJ	GF	GC	Puntos
1	Ravenna FC	34	52	26	65
2	Imolese	34	60	35	63
3	Delta Porto	34	57	37	61
4	Lentigione	34	40	31	58
5	Correggese	34	58	48	56
6	Castelvetro	34	60	57	50
7	Pianese	34	46	48	46
8	Scandicci	34	45	55	46
9	Mezzolara	34	43	46	45
10	Donato	34	50	47	44
11	Rignanese	34	34	35	44
12	Colligiana	34	46	47	43
13	Fiorenzuola	34	39	45	43
14	Adriese	34	46	51	39
15	Ribelle	34	45	46	38
16	Sangiovannes	34	42	51	37
17	Virtus	34	25	41	33
18	Poggibonsi	34	24	66	21

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 4
Equipo		PJ	GF	GC	Puntos
1	Rimini	38	81	35	86
2	Delta Porto	38	83	38	74
3	Correggese	38	71	45	72
4	Piacenza	38	60	34	72
5	AC Este	38	69	41	67
6	Abano Terme	38	49	47	53
7	Fiorenzuola	38	46	45	52
8	Bellaria	37	41	46	51
9	Scandicci	38	47	49	48
10	Jolly	38	49	57	47
11	Imolese	38	45	50	46
12	Fortis	38	42	53	46
13	Virtus	38	49	59	45
14	Ribelle	38	41	54	44
15	Mezzolara	37	49	58	43
16	Fidenza	38	36	45	41
17	Romagna	38	50	67	37
18	Luparense	38	37	61	36
19	Thermal	38	39	69	31
20	Formigine	38	36	67	28

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 4
Equipo		PJ	GF	GC	Puntos
1	Forli	38	72	45	80
2	AC Este	38	71	28	77
3	Mezzolara	38	62	41	75
4	Virtus	38	72	51	72
5	Luparense	38	60	40	63
6	Virtus	38	64	48	61
7	Pistoiese	38	65	50	54
8	Lanciotto	38	45	44	53
9	Cerea	38	57	58	53
10	Tuttocuoio	38	44	38	52
11	Bagnolese	38	44	46	49
12	Rosignano	38	41	53	46
13	Forcoli 1921	38	41	42	45
14	Scandicci	38	46	55	44
15	Camaiore	38	45	61	44
16	Ravenna FC	38	38	50	39
17	Virtus	38	36	55	37
18	Villafranca	38	39	61	35
19	Pelli	38	34	69	25
20	AS Sestese	38	34	75	23

TEMPORADA 2010/2011

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Perugia	34	51	24	74
2	Castel	34	64	44	62
3	Sansepolcro	34	44	28	60
4	Todi	34	49	33	58
5	Pianese	34	54	46	55
6	Città	34	44	38	51
7	Flaminia	34	44	35	48
8	Scandicci	34	43	44	46
9	SS Arezzo	34	42	41	45
10	Sporting	34	43	43	44
11	Pontevecchio	34	44	46	43
12	Voluntas	34	41	37	42
13	AS Sestese	34	43	51	38
14	Orvietana	34	39	50	37
15	Montevarchi	34	39	61	35
16	Deruta	34	32	56	34
17	Fortis	34	37	56	33
18	Monteriggion	34	33	53	29

TEMPORADA 2009/2010

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Follonica	34	55	38	62
2	Guidonia	34	61	43	57
3	Castel	34	54	33	55
4	Città	34	51	35	55
5	Monterotondo	34	53	38	54
6	Deruta	34	41	33	51
7	Sansepolcro	34	42	38	51
8	AS Sestese	34	40	50	46
9	Forcoli 1921	34	36	37	44
10	Scandicci	34	37	42	44
11	Montevarchi	34	34	33	43
12	Fortis	34	34	45	42
13	Pontevecchio	34	42	47	41
14	Orvietana	34	34	43	41
15	Monteriggion	34	34	47	40
16	Sporting	34	42	57	40
17	Calenzano	34	27	38	38
18	Sangimignano	34	27	47	33

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

Serie D Grupo 4

Pos	Equipos		Pts
1		Giana Erminio	80
2		Pistoiese	73
3		AC Carpi	59
4		Forli	57
5		Real Forte Querceta	57
6		Corticella	57
7		Ravenna FC	56
8		Sammaurese	51
9		Aglianese	50
10		Riccione	50
11		Prato	49
12		Mezzolara	49
13		Crema	48
14		Lentigione	48
15		Correggese	48
16		Fanfulla	48
17		Sant Angelo	45
18		Scandicci	42
19		Bagnolese	38
20		Salsomaggiore	13

	Ascenso : Giana Erminio
	Playoff Ascenso : Pistoiese, AC Carpi, Forli, Real Forte Querceta
	Playoff Descenso : Correggese, Fanfulla, Sant Angelo, Scandicci
	Descenso : Bagnolese, Salsomaggiore

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D Italia -.

RIVALES EN Serie D

USO DE MEMORIA

7,606,976 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8815
Total Execution Time	0.8827

CADENA URL

/historico/Scandicci

GET DATOS

$_GET['/historico/Scandicci']

POST DATOS

No hay datos POST existentes

CONSULTAS (68)

0.0116	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 = 'Scandicci' 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.0150	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 = 'Scandicci' 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=6888 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=6888 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=6888 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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 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=6888 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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 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=6888 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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 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=6888 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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6888 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=6888 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110	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 = 68661
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6888 AND type_rel = 2
0.0110	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 = '6888' ORDER BY l.year DESC,cat.coefficient DESC
0.0110	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 = '6888' AND l.year = 2023 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 = '6888' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0112	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 = 68661 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107	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 = 68750 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112	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=6888 AND l.year in (2022,2023,2024) 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 (71633,68750,68661,67320) 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 = 68750 AND teamId = 6888
0.0116	SELECT count(id) as num_players from rel_players WHERE league_id = 68661 AND teamId = 6888
0.0106	SELECT count(id) as num_players from rel_players WHERE league_id = 71633 AND teamId = 6888
0.0107	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 6888
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 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 = 68750 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0108	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 = '6888' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6888' and rp.type = 4
0.0116	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 = '6888' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0170	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 events2023 e ON e.player_id = p.id AND e.league_id = 68750 WHERE rp.league_id = 68750 AND rp.teamId = 6888 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.0169	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 events2023 e ON e.player_id = p.id AND e.league_id = 68750 WHERE rp.league_id = 68750 AND rp.teamId = 6888 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0176	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 events2023 e ON e.player_id = p.id AND e.league_id = 68750 WHERE rp.league_id = 68750 AND rp.teamId = 6888 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139	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 = 6888 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68750 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.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* `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.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* `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.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 = 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.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* `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 = 33452 AND t.round = 34 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* `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.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* `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 = 4817 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* `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.0118	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.0116	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 = 1694 AND t.round = 38 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* `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 = 24698 AND t.round = 34 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* `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 = 24713 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* `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

Scandicci

Scandicci

Selecciona un equipo

Competiciones que juega

Serie D Grupo 4

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D Italia -.

RIVALES EN Serie D