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

SS Arezzo

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cesena	38	80	19	96
2	Sassari	38	56	38	75
3	Carrarese	38	54	30	73
4	Perugia	38	44	35	63
5	Gubbio 1910	38	50	38	59
6	Pescara	38	60	55	55
7	Juventus	38	50	44	54
8	SS Arezzo	38	46	44	53
9	Pontedera	38	53	54	52
10	Rimini	38	52	54	50
11	SPAL	38	41	40	49
12	Lucchese	38	34	43	45
13	Virtus	38	33	35	45
14	Pineto	38	38	42	45
15	Sestri	38	42	55	44
16	Ancona	38	41	51	42
17	Vis Pesaro	38	39	47	39
18	Recanatese	38	47	65	38
19	Fermana	38	30	59	31
20	Olbia Calcio	38	25	67	26

TEMPORADA 2022/2023

SERIE D GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Sestri	2	5	2	6
2	Lumezzane	2	4	3	3
3	Legnago	2	2	6	0
4	Pineto	2	4	3	3
5	SS Arezzo	2	4	4	3
6	Giana	2	3	4	3
7	Sorrento	2	5	0	6
8	Catania	2	2	3	3
9	Brindisi	2	1	5	0

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 C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Perugia	38	67	30	79
2	Padova	38	68	26	79
3	Südtirol	38	66	29	75
4	Modena	38	51	28	70
5	Feralpisalò	38	54	46	60
6	Triestina	38	48	40	59
7	Cesena	38	51	42	57
8	Matelica	38	59	62	56
9	Sambenedette	38	43	43	54
10	Mantova	38	47	49	49
11	Virtus	38	43	44	49
12	Gubbio 1910	38	40	45	48
13	Fermana	38	31	44	42
14	Vis Pesaro	38	41	57	41
15	AC Carpi	38	45	62	41
16	Legnago	38	35	47	38
17	Imolese	38	34	55	35
18	Fano	38	32	47	33
19	Ravenna FC	38	32	62	30
20	SS Arezzo	38	37	66	29

TEMPORADA 2019/2020

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	AC Monza	27	53	18	61
2	Carrarese	27	47	36	45
3	Renate	27	34	22	43
4	Pontedera	27	38	35	42
5	Siena	27	32	30	40
6	Alessandria	27	34	30	40
7	AlbinoLeffe	27	29	24	39
8	Novara	26	35	29	38
9	SS Arezzo	27	33	28	37
10	Juventus	27	30	34	36
11	Pistoiese	27	24	22	33
12	Como	26	28	25	32
13	Pro Patria	26	32	30	32
14	Vercelli	26	27	28	31
15	Lecco	26	27	42	28
16	Pergolettese	27	21	36	27
17	Giana	26	28	44	26
18	Olbia Calcio	27	28	44	25
19	Pianese	27	23	30	24
20	Gozzano	27	22	38	22

TEMPORADA 2018/2019

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Piacenza	38	59	34	77
2	Virtus	37	58	26	75
3	Pisa SC	38	50	29	72
4	Vercelli	38	48	29	67
5	Siena	38	59	41	66
6	Carrarese	38	70	46	65
7	SS Arezzo	38	50	34	64
8	Pro Patria	38	44	38	57
9	Novara	37	44	36	50
10	Cuneo	38	30	36	47
11	Pontedera	37	33	39	45
12	Alessandria	38	36	43	45
13	Juventus	37	41	48	42
14	Arzachena	38	31	54	40
15	Olbia Calcio	38	40	50	38
16	Lucchese	38	46	40	37
17	Pistoiese	38	39	50	36
18	Gozzano	38	35	47	33
19	Albissola	38	34	59	31
20	Piacenza	34	17	85	15

TEMPORADA 2017/2018

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Livorno	36	64	38	68
2	Siena	36	41	30	67
3	Pisa SC	36	44	30	61
4	AC Monza	36	40	26	58
5	Viterbese	36	46	35	58
6	Alessandria	36	54	37	56
7	Carrarese	36	57	47	55
8	Piacenza	36	43	41	52
9	Pistoiese	36	44	47	46
10	Giana	36	59	56	46
11	Pontedera	36	38	49	46
12	Lucchese	36	35	42	44
13	SS Arezzo	36	39	35	43
14	Olbia Calcio	36	39	52	43
15	Piacenza	36	38	43	41
16	Arzachena	36	49	53	39
17	Follonica	36	35	51	36
18	Cuneo	36	24	47	32
19	Prato	36	32	62	26

TEMPORADA 2016/2017

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Alessandria	38	64	33	78
2	Cremonese	38	68	40	78
3	Livorno	38	51	30	69
4	SS Arezzo	38	50	38	65
5	Giana	38	56	43	63
6	Piacenza	38	54	40	59
7	Como	38	55	49	59
8	Viterbese	38	43	42	54
9	Lucchese	38	47	39	51
10	Renate	38	36	36	51
11	Piacenza	38	40	42	51
12	Siena	38	45	49	45
13	Pistoiese	38	42	43	44
14	Pontedera	38	38	50	43
15	Olbia Calcio	38	43	59	42
16	Prato	38	34	57	40
17	Carrarese	38	44	54	39
18	Tuttocuoio	38	37	53	38
19	Lupa Roma	38	28	48	33
20	Racing Roma	38	38	68	30

TEMPORADA 2015/2016

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	SPAL	34	59	25	71
2	Pisa SC	34	42	26	63
3	Maceratese	34	47	31	58
4	Ancona	34	34	29	53
5	Carrarese	34	49	37	51
6	Teramo	34	42	40	46
7	Siena	34	34	38	46
8	Pontedera	34	43	38	45
9	Santarcangel	34	41	38	45
10	SS Arezzo	34	33	31	43
11	L'Aquila	34	34	41	40
12	Tuttocuoio	34	27	34	40
13	Lucchese	34	39	43	39
14	Pistoiese	34	29	35	39
15	Rimini	34	29	39	38
16	Prato	34	32	43	37
17	Savona	34	27	44	36
18	Lupa Roma	34	26	55	25

TEMPORADA 2014/2015

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Novara	38	58	30	77
2	Bassano	38	57	37	74
3	Pavia	38	58	43	68
4	Como	38	48	33	67
5	Alessandria	38	51	31	65
6	Feralpisalò	38	43	41	56
7	Real Vicenza	38	44	38	52
8	Cremonese	38	45	44	50
9	Venezia	38	47	44	49
10	SS Arezzo	38	35	36	49
11	Südtirol	38	40	41	47
12	Sassari	38	35	38	47
13	Mantova	38	37	34	46
14	AC Monza	38	37	38	45
15	Giana	38	32	39	45
16	Renate	38	35	49	45
17	Pro Patria	38	45	65	38
18	Lumezzane	38	31	50	35
19	Pordenone	38	30	53	34
20	AlbinoLeffe	38	27	51	32

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

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 C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Novara	34	52	24	67
2	Varese	34	53	34	62
3	SS Arezzo	34	54	35	61
4	Cremonese	34	62	47	61
5	Benevento	34	50	37	56
6	Lumezzane	34	45	38	52
7	AS Figline	34	45	44	46
8	Alessandria	34	35	46	43
9	Perugia	34	31	38	42
10	Sorrento	34	44	45	41
11	AC Monza	34	37	45	41
12	Como	34	27	34	40
13	Foligno	34	53	56	39
14	Viareggio	34	29	39	38
15	Pergocrema	34	35	44	36
16	Pro Patria	34	37	49	35
17	Paganese	34	33	48	33
18	Lecco	34	34	53	31

TEMPORADA 2008/2009

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Gallipoli	34	55	32	66
2	Benevento	34	49	31	64
3	Crotone	34	46	37	59
4	SS Arezzo	34	56	37	56
5	Calcio	34	44	33	56
6	Cavese 1919	34	40	35	53
7	Perugia	34	33	30	43
8	Progreditur	34	32	33	43
9	Pescara	34	36	45	43
10	Ternana	34	36	34	42
11	Sorrento	34	37	39	42
12	Taranto	34	31	41	42
13	Paganese	34	21	29	41
14	Virtus	34	37	46	41
15	Foligno	34	35	45	35
16	Juve Stabia	34	29	40	34
17	Pistoiese	34	27	42	33
18	Potenza SC	34	24	39	31

TEMPORADA 2007/2008

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Salernitana	34	42	24	62
2	Ancona	34	43	26	57
3	Taranto	34	47	31	55
4	Crotone	34	45	30	55
5	Pescara	34	47	36	54
6	SS Arezzo	34	42	32	53
7	Perugia	34	35	34	53
8	Lucchese	34	35	29	51
9	Gallipoli	34	49	41	47
10	Sorrento	34	29	30	44
11	Virtus	34	30	34	42
12	Sambenedette	34	32	39	40
13	Massese	34	34	43	40
14	Potenza SC	34	31	36	38
15	Pistoiese	34	27	38	34
16	Juve Stabia	34	34	42	33
17	Sangiovannes	34	24	48	29
18	Martina	34	25	58	21

TEMPORADA 2006/2007

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Juventus	42	83	30	94
2	Napoli	42	52	29	79
3	Genoa	42	68	44	78
4	Piacenza	42	57	50	68
5	Rimini	42	55	38	67
6	Brescia	42	51	43	67
7	Bologna	42	52	43	65
8	Mantova	42	47	36	64
9	Lecce	42	56	53	58
10	AlbinoLeffe	42	46	48	53
11	SS Arezzo	42	42	46	51
12	Vicenza	42	42	43	50
13	Treviso	42	44	47	50
14	SSC Bari	42	40	46	50
15	Frosinone	42	44	54	50
16	Modena	42	38	46	49
17	Triestina	42	37	48	49
18	Cesena	42	51	66	49
19	Hellas	42	34	46	48
20	Spezia	42	50	61	46
21	Crotone	42	36	67	32
22	Pescara	42	36	77	25

TEMPORADA 2005/2006

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Atalanta	42	61	39	81
2	Catania	42	67	42	78
3	Torino	42	51	31	76
4	Mantova	42	46	35	69
5	Modena	42	59	41	67
6	Cesena	42	66	54	66
7	SS Arezzo	42	45	34	66
8	Bologna	42	55	42	64
9	Crotone	42	56	48	63
10	Brescia	42	54	44	60
11	Piacenza	42	56	52	54
12	Pescara	42	41	50	54
13	SSC Bari	42	43	47	51
14	Triestina	42	44	51	51
15	Hellas	42	42	41	49
16	Vicenza	42	38	49	49
17	Rimini	42	42	49	48
18	AlbinoLeffe	42	38	52	46
19	Avellino	42	42	62	46
20	Ternana	42	36	58	39
21	Cremonese	42	36	60	30
22	Catanzaro	42	26	63	28

Competiciones que juega

Grupo 2

RIVALES EN Serie C

RIVALES EN Coppa Italia Ser.

USO DE MEMORIA

7,982,120 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1792
Total Execution Time	0.1805

CADENA URL

/historico/Ac-Arezzo

GET DATOS

$_GET['/historico/Ac-Arezzo']

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0033	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 = 'Ac-Arezzo' 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=31 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=31 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=31 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=31 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=31 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 = 75937
0.0024	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 = 74153
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=31 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 31 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	SELECT /35 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 (106766,898153,907755,914209,971836) ORDER BY n.cover_points DESC, update_date DESC
0.0035	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 = '31' ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '31' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0043	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 = '31' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 75937 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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 = 74153 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=31 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (75937,74153,71666,71432,68661) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 75937 AND teamId = 31
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71666 AND teamId = 31
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 31
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 68661 AND teamId = 31
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 31
0.0019	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 = 75937 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '31' 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 = '31' and rp.type = 4
0.0021	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 = '31' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '31' and rp.type = 4
0.0020	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 = 75937 WHERE rp.league_id = 75937 AND rp.teamId = 31 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.0020	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 = 75937 WHERE rp.league_id = 75937 AND rp.teamId = 31 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 = 75937 WHERE rp.league_id = 75937 AND rp.teamId = 31 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 31 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 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.0021	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 = 71666 AND t.round = 3 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 = 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 = 58761 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* `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 = 51021 AND t.round = 27 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 = 44231 AND t.round = 38 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 = 38929 AND t.round = 38 ORDER BY team.conference 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* `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 = 33443 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* `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 = 15398 AND t.round = 34 ORDER BY team.conference 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* `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.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* `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.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* `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
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* `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.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* `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 = 1043 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* `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 = 446 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* `tables2008` 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 = 538 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* `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 = 507 AND t.round = 42 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* `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 = 508 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

SS Arezzo

SS Arezzo

Selecciona un equipo

Competiciones que juega

RIVALES EN Serie C

RIVALES EN Coppa Italia Ser.