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

ACR Messina

Entrenador: Giacomo Modica

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE C GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Juve Stabia	37	54	22	76
2	Avellino	37	61	29	66
3	Taranto	37	44	30	66
4	Benevento	37	45	32	66
5	Casertana	37	46	36	62
6	Picerno	37	51	37	58
7	Giugliano	37	44	44	53
8	Crotone	37	54	46	52
9	Latina	37	43	49	51
10	Audace	37	51	46	50
11	Calcio	37	40	43	48
12	Sorrento	37	37	42	48
13	ACR Messina	37	40	47	45
14	Potenza	37	38	47	42
15	Catania	37	38	38	42
16	Turris	37	44	56	41
17	Monopoli	37	39	50	39
18	Virtus	37	30	50	34
19	Monterosi	37	42	62	32
20	Brindisi	37	27	62	29

TEMPORADA 2022/2023

SERIE C GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Catanzaro	38	102	21	96
2	Crotone	38	57	31	80
3	Pescara	38	58	42	65
4	Calcio	38	60	44	61
5	Audace	38	48	41	60
6	Picerno	38	40	34	59
7	Monopoli	38	46	48	54
8	Latina	38	39	46	49
9	Potenza	38	49	57	48
10	Juve Stabia	38	37	49	46
11	Taranto	38	26	36	46
12	Giugliano	38	51	61	46
13	Virtus	38	47	54	45
14	Avellino	38	42	49	43
15	Turris	38	40	56	43
16	Monterosi	38	39	45	42
17	ACR Messina	38	32	47	41
18	Gelbison	38	25	40	36
19	Viterbese	38	35	52	33
20	Fidelis	38	29	49	33

TEMPORADA 2021/2022

SERIE C GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	SSC Bari	36	52	26	75
2	Catanzaro	36	57	26	67
3	Palermo FC	36	64	33	66
4	Avellino	36	45	26	64
5	Monopoli	36	38	31	59
6	Virtus	36	48	38	56
7	Calcio	36	62	51	54
8	Turris	36	52	49	52
9	Monterosi	36	40	38	51
10	Picerno	36	41	45	50
11	Juve Stabia	36	44	36	49
12	Latina	36	37	42	45
13	Città	36	51	62	44
14	ACR Messina	36	40	57	39
15	Taranto	36	31	40	39
16	Potenza	36	37	51	37
17	Fidelis	36	26	45	30
18	Paganese	36	36	69	26
19	Vibonese	36	24	60	21
20	Catania	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 2016/2017

SERIE C GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Calcio	38	70	29	85
2	Lecce	38	62	36	74
3	Matera	38	71	44	65
4	Juve Stabia	38	65	43	64
5	Siracusa	38	47	43	57
6	Virtus	38	47	45	57
7	Cosenza	38	57	46	55
8	Paganese	38	51	45	51
9	Casertana	38	38	42	49
10	Fondi	38	49	46	49
11	Fidelis	38	30	33	47
12	Catania	38	40	36	47
13	ACR Messina	38	38	52	46
14	Reggina	38	44	54	45
15	Monopoli	38	42	54	42
16	Akragas	38	30	47	39
17	Vibonese	38	27	46	39
18	Catanzaro	38	36	49	38
19	Melfi	38	38	68	34
20	Taranto	38	25	49	30

TEMPORADA 2015/2016

SERIE C GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Benevento	34	51	21	71
2	Calcio	34	61	31	65
3	Lecce	34	46	28	63
4	Casertana	34	52	35	63
5	Cosenza	34	44	28	60
6	Matera	34	45	32	55
7	Catania	34	37	34	49
8	Fidelis	34	33	21	45
9	ACR Messina	34	37	41	45
10	Akragas	34	35	47	45
11	Paganese	34	41	39	43
12	Juve Stabia	34	45	45	42
13	Catanzaro	34	27	40	41
14	Monopoli	34	43	42	39
15	Melfi	34	32	40	30
16	Ischia	34	31	65	25
17	Martina	34	30	58	24
18	Lupa Cast	34	22	65	13

TEMPORADA 2014/2015

SERIE C GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	AC Monza	2	8	3	6
2	Lumezzane	2	3	0	6
3	Reggina	2	2	0	6
4	Savona	2	3	2	4
5	Piacenza	2	2	1	4
6	Ischia	2	5	4	3
7	Real Agro A.	2	4	5	3
8	Gubbio 1910	2	2	3	1
9	Forli	2	1	2	1
10	ACR Messina	2	0	2	0
11	Pro Patria	2	0	3	0
12	Pordenone	2	3	8	0

TEMPORADA 2013/2014

LEGA PRO 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	ACR Messina	34	43	33	57
2	Casertana	34	38	28	57
3	Teramo	34	48	34	55
4	Cosenza	34	38	29	55
5	Calcio	34	50	40	51
6	Melfi	34	39	31	51
7	Ischia	34	33	29	48
8	Vigor	34	37	39	46
9	Sorrento	34	40	36	45
10	Tuttocuoio	34	41	38	44
11	Real Agro A.	34	36	40	43
12	Arzanese	34	41	46	43
13	Martina	34	36	36	42
14	Chieti	34	34	35	41
15	Aprilia	34	41	50	41
16	Poggibonsi	34	31	41	36
17	Castel	34	39	56	34
18	Follonica	34	24	48	30

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

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Milazzo	33	41	25	65
2	Trapani	33	55	27	64
3	Rosarno	33	39	21	61
4	Avellino	33	54	31	59
5	Vigor	33	51	32	57
6	Rossanese	33	38	26	56
7	Sapri Calcio	33	43	37	50
8	Modica	33	46	49	47
9	Nissa	33	39	36	46
10	Sambiase	33	47	36	45
11	HinterReggio	33	45	49	42
12	Mazara 1946	33	31	40	41
13	Palazzolo	33	45	48	39
14	ACR Messina	33	39	37	38
15	Viribus	33	34	52	32
16	Castrovillar	33	33	58	25
17	ACRD	33	23	57	24
18	Comprensorio	33	26	68	22

TEMPORADA 2008/2009

SERIE D GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Siracusa	36	72	29	81
2	Vico Equense	35	53	24	63
3	Sapri Calcio	36	55	36	61
4	Nissa	35	59	38	59
5	Comprensorio	36	46	35	55
6	Rosarno	36	48	36	53
7	Viribus	36	44	43	52
8	Turris	36	47	44	51
9	HinterReggio	36	41	37	50
10	Modica	36	31	35	49
11	ACRD	35	37	34	47
12	ACR Messina	36	29	34	47
13	Trapani	36	38	40	46
14	Palazzolo	36	37	47	41
15	Puteolana	36	23	42	41
16	Castrovillar	36	28	41	40
17	Savoia 1908	36	30	53	31
18	Vittoria	35	34	61	30
19	Castiglione	36	25	68	20

TEMPORADA 2007/2008

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Chievo	42	77	43	85
2	Bologna	42	58	29	84
3	Lecce	42	70	29	83
4	AlbinoLeffe	42	67	48	78
5	Brescia	42	59	40	72
6	Pisa SC	42	61	44	71
7	Rimini	42	68	46	69
8	Ascoli	42	64	49	62
9	Mantova	42	56	49	60
10	Frosinone	42	63	67	56
11	SSC Bari	42	50	55	55
12	Triestina	42	55	67	51
13	Grosseto	42	47	54	49
14	ACR Messina	42	38	62	49
15	Piacenza	42	43	59	47
16	Modena	42	57	65	46
17	Treviso	42	41	52	45
18	Vicenza	42	43	60	45
19	Avellino	42	42	64	36
20	Ravenna FC	42	48	75	35
21	Spezia	42	45	66	34
22	Cesena	42	37	66	32

TEMPORADA 2006/2007

SERIE A
Equipo		PJ	GF	GC	Puntos
1	Inter	38	80	34	97
2	Roma	38	74	34	75
3	Lazio	38	59	33	62
4	Milan	38	57	36	61
5	Palermo FC	38	58	51	58
6	Fiorentina	38	62	31	58
7	Empoli	38	42	43	54
8	Atalanta	38	56	54	50
9	Sampdoria	38	44	48	49
10	Udinese	38	49	55	46
11	Livorno	38	41	54	43
12	Parma	38	41	56	42
13	Catania	38	46	68	41
14	Reggina	38	52	50	40
15	Siena	38	35	45	40
16	Torino	38	27	47	40
17	Cagliari	38	35	46	40
18	Chievo	38	38	48	39
19	Ascoli	38	36	67	27
20	ACR Messina	38	37	69	26

TEMPORADA 2005/2006

SERIE A
Equipo		PJ	GF	GC	Puntos
1	Inter	38	68	30	76
2	Roma	38	70	42	69
3	Milan	38	85	31	58
4	Chievo	38	54	49	54
5	Palermo FC	38	50	52	52
6	Livorno	38	37	44	49
7	Empoli	38	47	61	45
8	Parma	38	46	60	45
9	Fiorentina	38	66	41	44
10	Ascoli	38	43	53	43
11	Udinese	38	40	54	43
12	Sampdoria	38	47	51	41
13	Reggina	38	39	65	41
14	Cagliari	38	42	55	39
15	Siena	38	42	60	39
16	Lazio	38	57	47	32
17	ACR Messina	38	33	59	31
18	Lecce	38	30	57	29
19	Treviso	38	24	56	21
20	Juventus	38	71	24	0

Competiciones que juega

Grupo 3

Serie C Grupo 3

Pos	Equipos		Pts
1		Juve Stabia	76
2		Avellino	66
3		Taranto	66
4		Benevento	66
5		Casertana	62
6		Picerno	58
7		SSC Giugliano	53
8		Crotone	52
9		Latina	51
10		Audace Cerignola	50
11		Calcio Foggia	48
12		Sorrento	48
13		ACR Messina	45
14		Potenza Calcio	42
15		Catania	42
16		Turris Neapolis	41
17		Monopoli	39
18		Virtus Francavilla	34
19		Monterosi Tuscia	32
20		Brindisi	29

	Ascenso : Juve Stabia
	Playoff Ascenso : Avellino, Taranto
	Siguiente Ronda : Benevento, Casertana, Picerno, SSC Giugliano, Crotone, Latina, Audace Cerignola
	Posible siguiente ronda : Calcio Foggia
	Playoff Descenso : Turris Neapolis, Monopoli, Virtus Francavilla, Monterosi Tuscia
	Descenso : Brindisi

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie C

USO DE MEMORIA

8,050,768 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.6272
Total Execution Time	0.6284

CADENA URL

/historico/Messina

GET DATOS

$_GET['/historico/Messina']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0139	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 = 'Messina' 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.0127	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=1681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=1681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=1681 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1681 AND type_rel = 2
0.0129	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1681 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130	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 (122938,956802,1200049) ORDER BY n.cover_points DESC, update_date DESC
0.0147	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 = '1681' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147	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 = '1681' 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,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 = 72301 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154	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=1681 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128	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 (74153,72301) 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.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 72301 AND teamId = 1681
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 1681
0.0141	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 = 72301 WHERE rp.league_id = 72301 AND rp.teamId = 1681 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.0145	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 = 72301 WHERE rp.league_id = 72301 AND rp.teamId = 1681 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142	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 = 72301 WHERE rp.league_id = 72301 AND rp.teamId = 1681 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 = 1681 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0256	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 = 72301 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.0149	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 = 68593 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.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* `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 = 63826 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.0129	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.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* `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.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* `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.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* `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.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* `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 = 33445 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* `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 = 15399 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 4074 AND t.round = 38 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* `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 = 14781 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 2746 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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.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* `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.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* `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.0136	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 = 24717 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 24736 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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 = 506 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

ACR Messina

ACR Messina

Selecciona un equipo

Competiciones que juega

Serie C Grupo 3

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie C