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

Mezzolara

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	AC Carpi	32	63	31	68
2	Ravenna FC	32	56	13	66
3	Lentigione	32	51	30	58
4	Corticella	32	57	40	55
5	Forli	32	45	36	55
6	Victor	32	42	38	54
7	Sangiuliano	32	35	34	47
8	Prato	32	39	40	47
9	Fanfulla	32	30	34	45
10	Aglianese	32	33	34	44
11	Imolese	32	32	31	43
12	Sant Angelo	31	46	45	38
13	Sammaurese	32	34	46	35
14	Progresso	32	25	42	35
15	Pistoiese	31	22	39	32
16	Borgo	32	31	55	28
17	Calcio	32	20	49	24
18	Mezzolara	32	22	46	23

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 4
Equipo		PJ	GF	GC	Puntos
1	Rimini	38	72	21	87
2	Ravenna FC	38	85	40	83
3	Lentigione	38	75	42	83
4	Correggese	38	47	38	58
5	AC Carpi	38	59	52	58
6	Mezzolara	38	48	44	56
7	Prato	38	47	52	51
8	Forli	38	46	47	50
9	Aglianese	38	44	56	50
10	Sammaurese	38	44	50	50
11	Alcione	38	52	49	48
12	Seravezza	38	42	54	46
13	Fanfulla	38	44	49	45
14	Ghivizzano	38	51	61	45
15	Real Forte.	38	36	43	44
16	Bagnolese	38	26	39	38
17	Sasso	38	37	61	37
18	Progresso	38	36	48	36
19	Borgo	38	34	52	36
20	Tritium	38	38	65	35

TEMPORADA 2020/2021

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Fiorenzuola	34	76	32	75
2	Aglianese	34	61	35	73
3	Lentigione	34	57	27	65
4	Prato	34	50	41	54
5	Rimini	34	56	44	52
6	Forli	34	51	46	52
7	Pro Livorno	34	56	59	48
8	Correggese	34	53	58	47
9	Real Forte.	34	45	47	46
10	Sammaurese	34	50	53	42
11	Ghivizzano	34	44	48	41
12	Bagnolese	34	40	41	40
13	Mezzolara	34	40	49	39
14	Seravezza	34	41	54	36
15	Progresso	34	41	56	36
16	Sasso	34	36	57	33
17	Marignanese	34	42	57	29
18	Corticella	34	33	68	24

TEMPORADA 2019/2020

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mantova	24	59	31	51
2	Fiorenzuola	24	36	27	44
3	Correggese	25	42	31	41
4	Calvina	25	40	32	41
5	Lentigione	24	39	31	40
6	Fanfulla	24	38	31	40
7	Mezzolara	25	34	33	36
8	Forli	24	26	26	32
9	Franciacorta	24	41	44	31
10	Breno Futura	24	32	28	30
11	Sasso	25	41	43	29
12	Vigor	24	33	38	29
13	Progresso	24	24	33	29
14	Sammaurese	25	33	38	26
15	Crema	24	27	34	25
16	Pol.	25	28	41	25
17	Alfonsine	25	15	33	22
18	Savignanese	25	24	38	21

TEMPORADA 2018/2019

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Modena	34	60	27	73
2	Pergolettese	34	62	32	73
3	Reggiana	34	57	28	66
4	Fanfulla	34	58	52	57
5	Fiorenzuola	34	52	31	56
6	Crema	34	52	50	49
7	Vigor	34	42	35	47
8	Franciacorta	34	45	45	47
9	Axys Zola	34	40	45	41
10	Pol.	34	38	48	41
11	Lentigione	34	34	36	39
12	Calvina	34	40	51	39
13	Pavia	34	32	46	36
14	Mezzolara	34	39	50	35
15	Sasso	34	31	50	34
16	Marino	34	24	32	31
17	Classe	34	25	51	30
18	OltrepòVogh	34	22	44	23

TEMPORADA 2017/2018

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Rimini	38	65	38	80
2	Imolese	38	72	45	71
3	Forli	38	60	43	65
4	Fiorenzuola	38	50	32	64
5	Sangiovannes	38	42	38	61
6	Lentigione	38	45	33	60
7	Villabiagio	38	52	49	59
8	Pianese	38	54	35	58
9	Montevarchi	38	42	40	56
10	Romagna	38	49	42	54
11	Sammaurese	38	34	29	54
12	Vigor	38	50	48	45
13	Sasso	38	35	48	45
14	Tuttocuoio	38	25	34	42
15	Sporting	38	36	52	41
16	Castelvetro	38	46	62	38
17	Mezzolara	38	34	50	36
18	Sansepolcro	38	40	62	33
19	Correggese	38	37	55	32
20	Colligiana	38	27	60	29

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 4
Equipo		PJ	GF	GC	Puntos
1	Parma	38	82	17	94
2	Alto	38	84	43	77
3	Forli	38	69	46	69
4	Marino	38	55	41	65
5	Correggese	38	66	49	64
6	Imolese	38	63	41	63
7	Delta Porto	38	68	51	61
8	Ribelle	38	63	54	61
9	Lentigione	38	52	50	59
10	Sammaurese	38	53	50	54
11	Arzignano	38	60	54	53
12	Legnago	38	55	53	51
13	Ravenna FC	38	50	59	44
14	Romagna	38	40	51	44
15	Virtus	38	50	59	42
16	Mezzolara	38	30	55	35
17	Villafranca	38	45	62	33
18	Bellaria	38	38	76	29
19	Clodiense	38	35	81	27
20	Fortis	38	31	97	13

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 4
Equipo		PJ	GF	GC	Puntos
1	Lucchese	34	74	21	82
2	Correggese	34	88	22	81
3	Massese	34	62	25	67
4	Thermal	34	64	34	67
5	Romagna	34	71	33	66
6	Fortis	34	68	44	62
7	Mezzolara	34	65	57	57
8	Imolese	34	54	47	51
9	Clodiense	34	46	46	44
10	Formigine	34	41	51	42
11	Virtus	34	46	49	41
12	Sancolombano	34	35	43	38
13	Fidenza	34	39	45	37
14	Camaiore	34	36	48	29
15	Montichiari	34	49	77	29
16	Palazzolo	34	33	60	22
17	Forcoli 1921	34	20	64	21
18	Riccione	34	20	145	12

TEMPORADA 2012/2013

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Miniato	34	59	34	70
2	Massese	34	62	26	67
3	Piacenza	34	63	33	65
4	Lucchese	34	49	24	65
5	Pistoiese	34	65	34	63
6	Virtus	34	75	51	59
7	SPAL	34	57	40	56
8	Mezzolara	34	61	43	51
9	Fidenza	34	38	46	44
10	Formigine	34	37	43	41
11	Fortis	34	43	53	41
12	Camaiore	34	48	58	39
13	Riccione	34	36	67	36
14	Forcoli 1921	34	24	42	34
15	Castenaso	34	35	62	33
16	Virtus	34	37	67	28
17	Bagnolese	34	32	58	25
18	Rosignano	34	30	70	25

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

TEMPORADA 2009/2010

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

TEMPORADA 2008/2009

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Crociati	34	49	29	67
2	Castellarano	34	52	32	61
3	Fiorenzuola	34	47	38	54
4	Salò	34	39	34	50
5	AC Este	34	35	32	46
6	Albignasego	34	44	38	45
7	Castel	33	34	33	45
8	Calenzano	33	38	42	45
9	Mezzolara	34	29	35	45
10	Santarcangel	33	42	36	44
11	Virtus	33	38	38	44
12	Virtus	34	42	39	43
13	US Russi	34	33	33	43
14	AC Carpi	33	39	41	42
15	Suzzara	33	41	49	37
16	Castellana	34	36	49	35
17	Comacchio	34	32	46	35
18	Villa	34	33	59	28

Competiciones que juega

Grupo 4

Serie D Grupo 4

Pos	Equipos		Pts
1		AC Carpi	68
2		Ravenna FC	66
3		Lentigione	58
4		Corticella	55
5		Forli	55
6		Victor San Marino	54
7		Sangiuliano City Nova	47
8		Prato	47
9		Fanfulla	45
10		Aglianese	44
11		Imolese	43
12		Sant Angelo	38
13		Sammaurese	35
14		Progresso	35
15		Pistoiese	32
16		Borgo San Donnino	28
17		Calcio Certaldo	24
18		Mezzolara	23

	Ascenso : AC Carpi
	Playoff Ascenso : Ravenna FC, Lentigione, Corticella, Forli
	Playoff Descenso : Sammaurese, Progresso, Pistoiese, Borgo San Donnino
	Descenso : Calcio Certaldo, Mezzolara

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D

USO DE MEMORIA

7,484,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1396
Total Execution Time	0.1408

CADENA URL

/historico/Mezzolara

GET DATOS

$_GET['/historico/Mezzolara']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

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 = 'Mezzolara' 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.0018	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=6895 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=6895 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=6895 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 = 73982
0.0023	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 = 73559
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6895 AND type_rel = 2
0.0024	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 = '6895' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027	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 = 73559 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=6895 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (73982,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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 73982 AND teamId = 6895
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 6895
0.0020	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 = '6895' 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 = '6895' 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 = '6895' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033	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 = 73982 WHERE rp.league_id = 73982 AND rp.teamId = 6895 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.0030	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 = 73982 WHERE rp.league_id = 73982 AND rp.teamId = 6895 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 73982 WHERE rp.league_id = 73982 AND rp.teamId = 6895 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 = 6895 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 = 73982 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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.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* `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 = 64278 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.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* `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 = 58829 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* `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 = 51159 AND t.round = 25 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* `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 = 44799 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* `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 = 39598 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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.0029	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 = 15652 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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.0031	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 = 24675 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* `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 = 2090 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* `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.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* `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24697 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24712 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 24728 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Mezzolara

Mezzolara

Selecciona un equipo

Competiciones que juega

Serie D Grupo 4

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D