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

Legnago Salus

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mantova	37	71	30	79
2	Padova	37	52	26	74
3	Vicenza	37	50	29	68
4	Triestina	37	59	41	64
5	Atalanta	37	42	35	58
6	Legnago	37	45	38	55
7	Giana	37	46	43	53
8	Vercelli	37	49	47	50
9	Lumezzane	37	46	46	50
10	Trento	37	33	37	48
11	Virtus	37	35	42	47
12	Pro Patria	37	37	50	46
13	AlbinoLeffe	37	32	34	45
14	Renate	37	35	45	45
15	Arzignano	37	31	36	43
16	Pergolettese	37	43	50	42
17	Novara	37	37	49	40
18	Fiorenzuola	37	38	60	38
19	Pro Sesto	37	24	40	32
20	Alessandria	37	19	46	23

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 C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Südtirol	38	49	9	90
2	Padova	38	60	26	85
3	Feralpisalò	38	56	29	69
4	Renate	38	59	43	62
5	Triestina	38	41	41	55
6	Lecco	38	51	42	55
7	Vercelli	38	41	40	55
8	Juventus	38	43	43	54
9	Piacenza	38	44	46	50
10	Pergolettese	38	42	55	46
11	Pro Patria	38	38	45	45
12	AlbinoLeffe	38	42	43	45
13	Virtus	38	35	38	45
14	Fiorenzuola	38	33	48	43
15	Mantova	38	37	42	42
16	Trento	38	31	36	42
17	Pro Sesto	38	33	46	38
18	Seregno	38	41	55	34
19	Giana	38	25	41	34
20	Legnago	38	32	65	30

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 D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Campodarsego	27	44	25	54
2	Legnago	28	43	32	49
3	Ambrosiana	28	47	31	48
4	Clodiense	27	44	32	47
5	Mestre	27	37	28	45
6	Adriese	27	53	36	44
7	Union Feltre	27	38	25	44
8	Cartigliano	28	46	37	42
9	Cjarlins	28	44	47	42
10	Luparense	27	49	45	37
11	Caldiero	27	25	28	37
12	AC Este	27	37	35	36
13	Chions	28	39	41	35
14	Belluno	27	33	38	34
15	Delta Porto	27	31	38	31
16	Montebelluna	27	26	35	30
17	Vigasio	27	28	42	30
18	Tamai	27	22	45	22
19	San Luigi	28	36	64	21
20	Villafranca	27	25	43	17

TEMPORADA 2018/2019

SERIE D GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Como	34	68	18	89
2	Mantova	34	73	27	83
3	Pro Sesto	34	61	42	69
4	Rezzato	34	53	36	65
5	Caronnese	34	57	41	59
6	Virtus	34	34	41	45
7	Sondrio	34	38	39	44
8	Seregno	34	37	42	43
9	Villa Valle	34	35	35	41
10	Pontisola	34	51	52	40
11	Caravaggio	34	45	53	40
12	Scanzoroscia	34	35	37	39
13	Legnago	34	38	57	38
14	Darfo Boario	34	26	46	35
15	Ambrosiana	34	45	62	33
16	Villafranca	34	36	44	31
17	Ciserano	34	42	68	26
18	Olginatese	34	26	60	19

TEMPORADA 2017/2018

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Virtus	34	60	33	73
2	Campodarsego	34	73	43	68
3	Arzignano	34	75	42	67
4	Mantova	34	56	34	60
5	Adriese	34	56	31	56
6	AC Este	34	49	29	56
7	Belluno	34	62	50	51
8	Legnago	34	53	47	49
9	Union Feltre	34	49	56	49
10	Rovigo	34	47	50	47
11	Cjarlins	34	51	49	44
12	Clodiense	34	44	60	41
13	Tamai	34	50	51	40
14	Ambrosiana	34	51	64	40
15	Montebelluna	34	34	50	32
16	Calvi Noale	34	32	67	28
17	Liventina	34	33	64	25
18	Abano Terme	34	25	80	16

TEMPORADA 2016/2017

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Mestre	34	73	34	80
2	Triestina	34	63	33	72
3	Campodarsego	34	55	42	60
4	Virtus	34	42	30	53
5	Abano Terme	34	46	38	53
6	Belluno	34	40	36	50
7	Arzignano	34	43	34	49
8	Montebelluna	34	46	54	44
9	AC Este	34	33	33	43
10	Union Feltre	34	35	37	43
11	Legnago	34	46	43	41
12	Calvi Noale	34	44	45	40
13	Alto	34	45	55	40
14	Tamai	34	33	45	40
15	Cordenons	34	44	56	39
16	Vigasio	34	42	61	38
17	Vigontina	34	42	62	25
18	Eclisse	34	29	63	23

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 3
Equipo		PJ	GF	GC	Puntos
1	Calcio	34	77	30	85
2	Alto	34	63	34	70
3	Sacilese	34	62	31	62
4	Belluno	34	57	38	59
5	Arzignano	34	53	39	56
6	Union Pro	34	46	42	55
7	Clodiense	34	48	47	49
8	Montebelluna	34	45	49	47
9	Union Ripa.	34	45	42	45
10	Fontanafredd	34	50	49	44
11	Legnago	34	50	55	43
12	Tamai	34	45	38	41
13	Giorgione	34	40	50	38
14	Dro Calcio	34	37	50	35
15	Triestina	34	41	51	34
16	Nk Kras Asd	34	41	58	33
17	Mori Santo.	34	31	69	19
18	Mezzocorona	34	20	79	16

TEMPORADA 2013/2014

SERIE D GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Piacenza	34	69	45	66
2	Olginatese	34	43	25	57
3	Piacenza	34	59	46	57
4	Seregno	34	54	46	56
5	Inveruno	34	65	43	55
6	Pontisola	34	44	41	53
7	Pro Sesto	34	38	32	52
8	Caravaggio	34	54	40	50
9	Lecco	34	50	43	50
10	Aurora	34	35	39	46
11	Legnago	34	44	50	44
12	Castellana	34	38	45	42
13	MapelloBonat	34	44	56	39
14	AlzanoCene	34	32	43	36
15	Borgomanero	34	43	56	36
16	Gozzano	34	35	41	34
17	Darfo Boario	34	40	61	29
18	Sambonifaces	34	34	69	25

TEMPORADA 2012/2013

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Delta Porto	38	64	29	75
2	Pordenone	38	55	38	71
3	Sambonifaces	38	53	36	71
4	Virtus	38	60	37	69
5	Real Vicenza	38	70	49	67
6	Clodiense	38	48	43	65
7	Sandonà	38	59	48	58
8	Sacilese	38	48	41	56
9	Trissino	38	58	49	54
10	Belluno	38	53	56	52
11	Legnago	38	54	47	51
12	Tamai	38	54	52	46
13	AC Este	38	45	50	46
14	Luparense	38	43	49	46
15	Cerea	38	42	56	44
16	Montebelluna	38	40	62	43
17	Giorgione	38	40	52	39
18	Sanvitese	38	33	52	36
19	Nk Kras Asd	38	34	73	29
20	Union Quinto	38	32	66	21

TEMPORADA 2011/2012

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Venezia	34	74	37	73
2	Delta Porto	34	65	34	67
3	Legnago	34	45	23	62
4	Montebelluna	34	40	33	55
5	Sacilese	34	40	34	50
6	Sandonà	34	49	34	48
7	Pordenone	34	47	38	48
8	Mezzocorona	34	40	37	48
9	Belluno	34	41	44	45
10	Giorgione	34	38	35	44
11	Tamai	34	52	54	44
12	Union Quinto	34	42	52	44
13	St. Georgen	34	39	54	42
14	Sanvitese	34	31	48	35
15	Sarego	34	37	59	35
16	Montecchio	34	32	42	34
17	Concordia	34	43	59	32
18	Itala Marco	34	32	70	18

TEMPORADA 2010/2011

SERIE D GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mantova	34	53	27	67
2	Voghera	34	57	47	58
3	Pontisola	34	49	39	58
4	Colognese	34	48	40	56
5	Legnago	34	61	39	54
6	Olginatese	34	53	36	54
7	Caronnese	34	48	41	54
8	Darfo Boario	34	52	36	51
9	Castiglione	34	50	34	49
10	Cantù Paolo	34	40	37	47
11	Virtus	34	35	34	44
12	AlzanoCene	34	47	53	42
13	Castellana	34	33	43	38
14	Villafranca	34	39	59	35
15	Folgore	34	44	61	32
16	Trento	34	35	58	32
17	Castelnuovo	34	40	66	30
18	Solbiatese	34	26	60	26

Competiciones que juega

Grupo 1

Serie C Grupo 1

Pos	Equipos		Pts
1		Mantova	79
2		Padova	74
3		Vicenza	68
4		Triestina	64
5		Atalanta Sub 23	58
6		Legnago Salus	55
7		Giana Erminio	53
8		Pro Vercelli	50
9		Lumezzane	50
10		Trento	48
11		Virtus Verona	47
12		Pro Patria	46
13		AlbinoLeffe	45
14		Renate	45
15		Arzignano Valchiampo	43
16		Pergolettese	42
17		Novara	40
18		Fiorenzuola	38
19		Pro Sesto	32
20		US Alessandria	23

	Ascenso : Mantova
	Playoff Ascenso : Padova, Vicenza
	Siguiente Ronda : Triestina, Atalanta Sub 23, Legnago Salus, Giana Erminio, Pro Vercelli, Lumezzane, Trento
	Posible siguiente ronda : Virtus Verona
	Playoff Descenso : Pergolettese, Novara, Fiorenzuola, Pro Sesto
	Descenso : US Alessandria

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie C

USO DE MEMORIA

7,216,008 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.6358
Total Execution Time	0.6372

CADENA URL

/historico/Legnago-Salus

GET DATOS

$_GET['/historico/Legnago-Salus']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0138	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 = 'Legnago-Salus' 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.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=6873 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=6873 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=6873 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=6873 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6873 AND type_rel = 2
0.0138	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 = '6873' ORDER BY l.year DESC,cat.coefficient DESC
0.0134	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 = '6873' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0135	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 = '6873' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0139	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=6873 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129	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,72299,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.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 72299 AND teamId = 6873
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 71666 AND teamId = 6873
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 6873
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 68661 AND teamId = 6873
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6873
0.0128	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 = '6873' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6873' and rp.type = 4
0.0127	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 = '6873' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0151	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 = 72299 WHERE rp.league_id = 72299 AND rp.teamId = 6873 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.0149	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 = 72299 WHERE rp.league_id = 72299 AND rp.teamId = 6873 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158	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 = 72299 WHERE rp.league_id = 72299 AND rp.teamId = 6873 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 6873 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0254	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 = 72299 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.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* `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 = 68749 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* `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.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 = 63824 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.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* `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.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* `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 = 51158 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 44797 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 39597 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 33451 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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.0151	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 = 4816 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 24670 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* `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 = 2089 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* `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 = 1693 AND t.round = 34 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* `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 = 24695 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Legnago Salus

Legnago Salus

Selecciona un equipo

Competiciones que juega

Serie C Grupo 1

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie C