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

Acireale

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Trapani	33	91	13	91
2	Siracusa	33	75	23	78
3	Vibonese	33	63	27	69
4	Reggina	33	53	24	64
5	Cittá	33	44	31	52
6	Real	33	49	45	51
7	Acireale	33	38	41	51
8	Ragusa	34	41	38	50
9	Canicattì	33	51	49	45
10	Igea Virtus	33	37	39	44
11	Licata	33	41	50	43
12	Akragas	33	41	53	39
13	Sancataldese	33	32	42	37
14	Portici	33	32	54	32
15	San Luca	33	35	51	29
16	Locri 1909	34	34	68	28
17	Castrovillar	33	29	74	17
18	Nuova	33	16	80	8
19	Lamezia	0	0	0	0

TEMPORADA 2022/2023

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Catania	34	74	20	88
2	Locri 1909	34	56	41	57
3	Trapani	34	46	31	54
4	Lamezia	34	45	35	54
5	Cittá	34	61	45	52
6	Licata	34	43	35	52
7	Sancataldese	34	34	30	52
8	Vibonese	34	40	41	47
9	Santa Maria	34	45	48	45
10	Canicattì	34	35	40	45
11	Acireale	34	31	30	41
12	Castrovillar	34	30	42	41
13	Real Agro A.	34	29	31	37
14	San Luca	34	34	46	37
15	Ragusa	34	31	47	37
16	Paternò	34	27	47	37
17	Cittanova	34	23	45	27
18	Mariglianese	34	24	54	24

TEMPORADA 2021/2022

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Gelbison	36	63	23	78
2	Cavese 1919	36	58	21	77
3	Acireale	36	58	31	69
4	Lamezia	36	58	35	69
5	Cittá	36	47	31	60
6	Paternò	36	45	41	52
7	Cittanova	36	48	56	52
8	Santa Maria	36	58	50	51
9	Licata	36	57	45	50
10	Real Agro A.	36	36	34	49
11	Portici	36	42	44	44
12	Trapani	36	44	47	41
13	San Luca	36	45	52	41
14	Sancataldese	36	34	60	40
15	Giarre	36	33	42	39
16	Castrovillar	36	39	48	38
17	Rende	36	35	50	36
18	Troina	36	39	71	29
19	Biancavilla	36	25	83	13
20	FC Messina	0	0	0	0

TEMPORADA 2020/2021

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	ACR Messina	34	66	25	74
2	FC Messina	34	59	25	72
3	Gelbison	34	54	34	64
4	San Luca	34	46	38	58
5	Acireale	34	51	32	57
6	Dattilo	34	52	47	52
7	Rotonda	34	31	33	49
8	Biancavilla	34	44	47	47
9	Santa Maria	34	43	29	45
10	Licata	34	36	39	43
11	Castrovillar	34	39	37	41
12	Paternò	34	28	35	39
13	Cittanova	34	42	51	39
14	Cittá	34	32	48	36
15	Troina	34	27	47	36
16	Rende	34	38	58	34
17	Marina	34	38	58	33
18	Roccella	34	25	68	20

TEMPORADA 2019/2020

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

TEMPORADA 2018/2019

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	SSC Bari	34	69	22	78
2	Turris	34	73	27	69
3	Marsala	34	44	30	53
4	Portici	34	47	46	50
5	Castrovillar	34	40	39	49
6	Cittanova	34	55	53	47
7	Palmese	34	34	32	47
8	Acireale	34	50	51	47
9	Nocerina	34	35	40	47
10	Troina	34	34	35	45
11	Gela	34	49	50	44
12	ACR Messina	34	40	44	43
13	Sancataldese	34	52	51	42
14	FC Messina	34	32	50	40
15	Locri 1909	34	41	60	39
16	Roccella	34	32	46	38
17	Rotonda	34	33	47	31
18	Igea Virtus	34	17	54	21

TEMPORADA 2017/2018

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Vibonese	34	67	24	76
2	Troina	34	59	28	76
3	Nocerina	34	50	20	69
4	Granata 1924	34	58	33	64
5	Igea Virtus	34	43	25	60
6	ACR Messina	34	57	39	53
7	Gela	34	56	46	52
8	Acireale	34	47	45	51
9	Gelbison	34	36	42	47
10	Palmese	34	47	54	43
11	Cittanova	34	43	46	42
12	Portici	34	35	44	42
13	Sancataldese	34	40	41	40
14	Roccella	34	41	49	38
15	Ebolitana	34	32	50	30
16	Palazzolo	34	26	53	25
17	Paceco	34	30	74	21
18	Isola Capo.	34	15	69	12

TEMPORADA 2012/2013

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

TEMPORADA 2011/2012

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	HinterReggio	34	58	34	60
2	Cosenza	34	56	35	59
3	ACR Messina	34	49	36	58
4	Palazzolo	34	50	30	53
5	Battipaglies	33	53	41	53
6	Nuvla Felice	34	43	41	50
7	Polisportiva	34	43	45	49
8	Noto	34	51	39	48
9	Sant	34	55	54	47
10	Licata	34	50	50	47
11	Serre	34	38	37	45
12	Sambiase	34	41	44	45
13	Acri	33	40	42	43
14	Acireale	33	29	35	39
15	Marsala	34	34	44	38
16	Nissa	34	30	37	36
17	Valle	33	29	46	30
18	Cittanova	34	20	79	20

TEMPORADA 2010/2011

SERIE D GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Ebolitana	34	63	18	83
2	Forza	34	63	24	80
3	Casertana	34	58	26	67
4	Sambiase	34	45	31	59
5	Nissa	34	42	27	56
6	Turris	34	66	46	54
7	ACR Messina	35	39	46	50
8	Valle	34	51	42	49
9	HinterReggio	34	39	36	48
10	Sapri Calcio	34	51	47	44
11	Noto	34	39	43	43
12	Cittanova	35	31	36	43
13	Real Nocera	34	39	43	42
14	Acireale	34	35	40	40
15	Modica	34	30	45	38
16	Marsala	34	30	49	32
17	Rossanese	34	26	51	31
18	Mazara 1946	34	46	63	30
19	Nola 1925	34	18	98	9

TEMPORADA 2005/2006

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Napoli	34	48	20	68
2	Frosinone	34	43	37	55
3	Sassari	34	44	32	53
4	Grosseto	34	43	32	51
5	Sangiovannes	34	37	34	51
6	Perugia	34	35	37	50
7	Lucchese	34	33	27	49
8	Martina	34	41	39	47
9	Gela	34	31	35	43
10	Pistoiese	34	28	24	42
11	Manfredonia	34	36	38	42
12	Virtus	34	36	35	41
13	Calcio	34	32	32	40
14	Acireale	34	29	34	39
15	Pisa SC	34	31	43	39
16	Massese	34	21	36	38
17	Juve Stabia	34	25	36	33
18	Chieti	34	24	46	28

TEMPORADA 2004/2005

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2003/2004

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Catanzaro	34	44	25	67
2	Crotone	34	57	33	65
3	Viterbese	34	45	29	61
4	Acireale	34	40	26	60
5	Benevento	34	41	28	56
6	Virtus	34	34	31	53
7	Sambenedette	34	50	40	52
8	Chieti	34	39	35	48
9	Calcio	34	43	43	46
10	Teramo	34	40	41	45
11	Martina	34	45	50	42
12	Real	34	35	39	41
13	Sora	34	27	35	41
14	Fermana	34	34	46	40
15	Vis Pesaro	34	31	48	36
16	Paternò	34	32	47	32
17	Taranto	34	31	46	30
18	L'Aquila	34	26	52	13

TEMPORADA 1994/1995

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Piacenza	38	55	27	71
2	Udinese	38	63	35	70
3	Vicenza	38	54	26	68
4	Atalanta	38	49	36	66
5	Salernitana	38	57	40	61
6	Ancona	38	55	50	58
7	Perugia	38	47	35	54
8	Cosenza	38	38	35	51
9	Cesena	38	44	43	51
10	Venezia	38	46	44	50
11	Hellas	38	40	40	48
12	Pescara	38	50	63	46
13	Palermo FC	38	33	35	44
14	Chievo	38	35	38	44
15	Fidelis	38	36	41	44
16	Lucchese	38	49	54	42
17	Acireale	38	27	42	41
18	Ascoli	38	27	57	34
19	Como	38	25	58	33
20	Lecce	38	36	67	24

TEMPORADA 1993/1994

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Fiorentina	38	53	19	67
2	Cesena	38	49	48	60
3	SSC Bari	38	49	27	59
4	Brescia	38	68	53	59
5	Padova	38	37	29	54
6	Venezia	38	43	40	53
7	Ascoli	38	38	38	53
8	Ancona	38	46	43	50
9	Pescara	38	50	54	50
10	Hellas	38	36	42	48
11	Palermo FC	38	32	38	48
12	Fidelis	38	28	28	47
13	Cosenza	38	30	38	47
14	Vicenza	38	30	33	46
15	Lucchese	38	34	35	45
16	Pisa SC	38	36	40	45
17	Acireale	38	32	39	43
18	Ravenna FC	38	36	47	39
19	Modena	38	29	45	39
20	AC Monza	38	27	47	28

Competiciones que juega

Grupo 9

Serie D Grupo 9

Pos	Equipos		Pts
1		Trapani	91
2		Siracusa	78
3		US Vibonese Calcio	69
4		Reggina	64
5		Cittá Di Sant'Agata	52
6		Real Casalnuovo	51
7		Acireale	51
8		Ragusa	50
9		Canicattì	45
10		Igea Virtus	44
11		Licata	43
12		Akragas	39
13		Sancataldese	37
14		Portici	32
15		San Luca	29
16		Locri 1909	28
17		Castrovillari	17
18		Nuova Gioiese	8
19		Lamezia Terme	0

	Ascenso : Trapani
	Playoff Ascenso : Siracusa, US Vibonese Calcio, Reggina, Cittá Di Sant'Agata
	Playoff Descenso : Sancataldese, Portici, San Luca, Locri 1909
	Descenso : Castrovillari, Nuova Gioiese, Lamezia Terme

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D

USO DE MEMORIA

7,154,744 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1483
Total Execution Time	0.1496

CADENA URL

/historico/Acireale

GET DATOS

$_GET['/historico/Acireale']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0035	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 = 'Acireale' 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=2864 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=2864 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=2864 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 73987
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2864 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 222 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023	SELECT /53 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 (1244039,1222208,1221521,1177309,1176862) ORDER BY n.cover_points DESC, update_date DESC
0.0032	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 = '2864' ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '2864' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027	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 = '2864' 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 = 73987 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=2864 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 (73987,73559) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 73987 AND teamId = 2864
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 2864
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 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 = 73987 AND t.round = 37 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024	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 = '2864' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2864' 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 = '2864' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038	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 = 73987 WHERE rp.league_id = 73987 AND rp.teamId = 2864 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.0037	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 = 73987 WHERE rp.league_id = 73987 AND rp.teamId = 2864 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 73987 WHERE rp.league_id = 73987 AND rp.teamId = 2864 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 2864 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73987 AND t.round = 37 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* `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 = 69427 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.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* `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 = 64283 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.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* `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 = 58834 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* `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 51164 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 = 44804 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* `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 = 39602 AND t.round = 34 ORDER BY team.conference 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* `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2092 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 = 1699 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* `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 = 24703 AND t.round = 36 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* `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 = 542 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables2005` 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 = 582 AND t.round = 38 ORDER BY team.conference 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* `tables2004` 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 = 585 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* `tables1995` 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 = 22417 AND t.round = 38 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* `tables1994` 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 = 30866 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 dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73987 ORDER BY nameShow LIMIT 100

Acireale

Acireale

Selecciona un equipo

Competiciones que juega

Serie D Grupo 9

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D