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

Luparense

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Clodiense	33	47	17	77
2	Dolomiti	33	55	24	65
3	Treviso	33	51	35	60
4	Bassano	33	35	28	54
5	Campodarsego	33	41	25	50
6	AC Este	33	42	33	48
7	Montecchio	33	46	40	48
8	Adriese	33	49	39	47
9	Mestre	33	33	36	47
10	Calcio	33	43	43	45
11	Montebelluna	33	35	39	45
12	Chions	33	39	46	41
13	Luparense	33	38	40	39
14	US Breno	33	35	48	34
15	Atletico	33	37	53	33
16	Cjarlins	33	29	37	32
17	Virtus	33	24	51	23
18	Mori Santo.	33	22	67	15

TEMPORADA 2022/2023

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Legnago	34	48	26	60
2	Clodiense	34	46	31	58
3	Adriese	34	54	38	56
4	Campodarsego	34	50	40	54
5	Luparense	34	49	34	53
6	Virtus	34	53	43	53
7	AC Este	34	47	39	50
8	Cjarlins	34	38	36	48
9	Caldiero	34	42	41	48
10	Cartigliano	34	47	50	46
11	Mestre	34	46	42	43
12	Dolomiti	34	42	47	43
13	Montecchio	34	50	55	39
14	Torviscosa	34	31	46	36
15	Calcio	34	36	56	35
16	Villafranca	34	35	46	34
17	Montebelluna	34	35	61	31
18	Levico	34	23	41	29

TEMPORADA 2021/2022

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Arzignano	34	74	32	73
2	Clodiense	34	53	22	72
3	Adriese	34	61	36	66
4	Luparense	34	60	35	58
5	Campodarsego	34	48	37	56
6	Caldiero	34	58	50	51
7	Dolomiti	34	51	50	50
8	Montebelluna	34	57	52	49
9	Mestre	34	36	45	46
10	Cjarlins	34	51	43	45
11	Cartigliano	34	44	40	45
12	AC Este	34	31	42	43
13	Levico	34	31	40	42
14	Ambrosiana	34	45	52	40
15	Delta Porto	34	43	51	36
16	Spinea	34	27	58	25
17	Cattolica	34	20	61	23
18	Martino	34	29	73	20

TEMPORADA 2020/2021

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Trento	38	65	35	81
2	Arzignano	38	52	34	67
3	Manzanese	38	64	44	66
4	Clodiense	38	51	41	62
5	Caldiero	38	56	36	61
6	Mestre	38	58	49	60
7	Delta Porto	38	51	38	58
8	Luparense	38	52	48	54
9	Belluno	38	43	45	53
10	Cjarlins	38	60	60	52
11	Cartigliano	38	42	45	52
12	Union	38	48	48	49
13	Adriese	38	55	64	49
14	Ambrosiana	38	57	64	47
15	AC Este	38	45	53	43
16	Campodarsego	38	41	48	40
17	Union Feltre	38	41	59	39
18	Virtus	38	46	52	38
19	Montebelluna	38	41	67	38
20	Chions	38	30	68	21

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 2015/2016

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Venezia	38	89	26	90
2	Campodarsego	38	56	31	79
3	AC Este	38	61	23	76
4	Belluno	38	52	38	67
5	Virtus	38	67	37	63
6	Luparense	38	65	57	58
7	Tamai	38	45	43	53
8	Mestre	38	71	54	51
9	Abano Terme	38	50	47	49
10	Levico	38	54	53	48
11	Calvi Noale	38	40	43	48
12	Dro Calcio	38	35	53	48
13	Union Ripa.	38	50	56	45
14	Fincantieri	38	47	57	43
15	Montebelluna	38	50	62	43
16	Liventina	38	45	62	39
17	Triestina	38	40	57	39
18	Fontanafredd	38	44	62	39
19	Giorgione	38	42	74	38
20	Sacilese	38	26	94	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 3
Equipo		PJ	GF	GC	Puntos
1	Pordenone	34	77	20	85
2	Marano	34	72	24	83
3	Sacilese	34	55	28	66
4	Belluno	34	54	43	59
5	Luparense	34	45	51	50
6	Union Ripa.	34	59	49	49
7	AC Este	34	53	43	48
8	Montebelluna	34	45	46	48
9	Trissino	34	47	49	43
10	Triestina	34	48	45	42
11	Giorgione	34	36	35	39
12	Tamai	34	42	56	39
13	Vittorio	34	42	59	38
14	Fincantieri	34	37	52	34
15	Mezzocorona	34	35	56	33
16	Dro Calcio	34	34	66	31
17	Sanvitese	34	37	55	30
18	Fersina	34	26	67	17

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 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 3
Equipo		PJ	GF	GC	Puntos
1	Treviso	34	59	26	73
2	Venezia	34	69	42	69
3	Tamai	34	61	43	56
4	Sandonà	34	56	44	55
5	Luparense	34	49	44	55
6	Union Quinto	34	50	42	49
7	Rovigo	34	48	43	49
8	AC Este	34	55	48	46
9	Sanvitese	34	51	54	45
10	Pordenone	34	52	53	42
11	AC Chioggia	34	34	39	42
12	Montebelluna	34	32	43	41
13	Montecchio	34	43	48	40
14	Belluno	34	38	48	39
15	Opitergina	34	50	63	36
16	Concordia	34	49	68	36
17	Nk Kras Asd	34	39	61	32
18	Torviscosa	34	41	67	23

Competiciones que juega

Grupo 3

Serie D Grupo 3

Pos	Equipos		Pts
1		Clodiense	77
2		Dolomiti Bellunesi	65
3		Treviso	60
4		Bassano Virtus	54
5		Campodarsego	50
6		AC Este	48
7		Montecchio Maggiore	48
8		Adriese	47
9		Mestre	47
10		Calcio Portogruaro-Summaga	45
11		Montebelluna	45
12		Chions	41
13		Luparense	39
14		US Breno	34
15		Atletico Castegnato	33
16		Cjarlins Muzane	32
17		Virtus Bolzano	23
18		Mori Santo Stefano	15

	Ascenso : Clodiense
	Playoff Ascenso : Dolomiti Bellunesi, Treviso, Bassano Virtus, Campodarsego
	Playoff Descenso : Luparense, US Breno, Atletico Castegnato, Cjarlins Muzane
	Descenso : Virtus Bolzano, Mori Santo Stefano

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D

USO DE MEMORIA

6,780,280 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1163
Total Execution Time	0.1176

CADENA URL

/historico/San-Paolo-Padova

GET DATOS

$_GET['/historico/San-Paolo-Padova']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0028	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 = 'San-Paolo-Padova' 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=6900 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=6900 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=6900 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017	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=6900 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038	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.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6900 AND type_rel = 2
0.0023	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 = '6900' ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '6900' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '6900' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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=6900 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (73981,73559,71632,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 73981 AND teamId = 6900
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 6900
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71632 AND teamId = 6900
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6900
0.0021	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 = '6900' 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 = '6900' and rp.type = 4
0.0020	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 = '6900' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 = 73981 WHERE rp.league_id = 73981 AND rp.teamId = 6900 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.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 = 73981 WHERE rp.league_id = 73981 AND rp.teamId = 6900 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 73981 WHERE rp.league_id = 73981 AND rp.teamId = 6900 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 6900 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 64277 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.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* `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 = 58828 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.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* `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.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15651 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.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* `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 = 24671 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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.0022	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.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* `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 = 24696 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Luparense

Luparense

Selecciona un equipo

Competiciones que juega

Serie D Grupo 3

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D