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

SN Notaresco 2018

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Città	32	52	28	66
2	L'Aquila	32	39	22	64
3	Sambenedette	32	51	32	54
4	Avezzano	32	46	32	53
5	Vigor	32	53	43	49
6	Roma City	32	51	34	48
7	Chieti	32	35	32	47
8	Notaresco	32	37	36	45
9	Atletico	32	34	31	44
10	Termoli	32	29	35	41
11	Sora	32	36	35	40
12	Fossombrone	32	28	27	40
13	Real	32	37	55	38
14	Riccione	32	44	46	34
15	Tivoli	32	33	54	31
16	Fano	32	30	45	29
17	Vastogirardi	32	23	43	29
18	Matese	32	20	48	25

TEMPORADA 2022/2023

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Pineto	34	50	21	72
2	Vigor	34	52	34	67
3	Trastevere	34	56	41	62
4	Fano	34	45	34	60
5	Cynthialbalo	34	32	23	52
6	Matese	34	44	38	47
7	Sambenedette	34	39	37	46
8	Chieti	34	29	27	46
9	Porto	34	28	27	45
10	Vastogirardi	34	30	31	42
11	Team Nuova.	34	33	44	42
12	Avezzano	34	35	41	40
13	Roma City	34	29	42	37
14	Vastese	34	37	43	36
15	Termoli	34	25	34	34
16	Montegiorgio	34	21	34	31
17	Tolentino	34	25	41	31
18	Notaresco	34	23	41	31

TEMPORADA 2021/2022

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Recanatese	34	69	23	68
2	Trastevere	34	54	33	59
3	Tolentino	34	42	30	56
4	Sambenedette	34	41	36	55
5	Vastese	34	44	32	53
6	Pineto	34	43	29	52
7	Fiuggi	34	41	45	51
8	Notaresco	34	45	41	49
9	Matese	34	44	41	49
10	Porto	34	41	39	49
11	Montegiorgio	34	38	36	49
12	Chieti	34	38	38	49
13	Fano	34	44	39	48
14	Vastogirardi	34	48	51	46
15	Castelnuovo	34	49	51	44
16	Castelfidard	34	36	36	41
17	Nereto	34	23	80	12
18	Aurora Alto	34	21	81	7

TEMPORADA 2020/2021

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Città	34	63	29	72
2	Notaresco	34	59	34	64
3	Pineto	34	45	35	56
4	Cynthialbalo	34	51	36	56
5	Matese	34	46	38	56
6	Castelfidard	34	46	33	55
7	Recanatese	34	62	45	50
8	Castelnuovo	34	53	53	50
9	Vastese	34	47	37	48
10	Montegiorgio	34	42	42	46
11	Rieti	34	38	42	44
12	Aprilia	34	43	49	44
13	Tolentino	34	52	53	40
14	Fiuggi	34	40	41	40
15	Vastogirardi	34	46	51	40
16	Real	34	33	50	31
17	Porto	34	22	63	17
18	Olympia	34	26	83	15

TEMPORADA 2019/2020

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Matelica	26	49	17	55
2	Città	26	47	24	52
3	Notaresco	26	43	30	52
4	Recanatese	26	48	42	48
5	Pineto	26	35	30	43
6	Vastese	26	40	33	42
7	Olympia	26	40	34	40
8	Montegiorgio	26	32	27	38
9	Tolentino	26	33	37	36
10	Porto	26	40	40	34
11	Vastogirardi	26	42	45	34
12	Fiuggi	26	37	38	33
13	Cattolica	26	31	36	28
14	Real	26	29	40	28
15	Sangiustese	26	27	39	20
16	Avezzano	26	16	33	20
17	Chieti	26	26	51	18
18	Jesina	26	27	46	13

TEMPORADA 2018/2019

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Cesena	38	69	28	83
2	Matelica	38	74	36	80
3	Recanatese	38	55	35	63
4	Pineto	38	59	41	62
5	Sangiustese	38	49	38	61
6	Francavilla	38	59	44	60
7	Notaresco	38	48	43	54
8	Jesina	38	34	38	51
9	Montegiorgio	38	36	43	51
10	Città	38	49	49	49
11	Sammaurese	38	36	48	49
12	Savignanese	38	42	43	48
13	Avezzano	38	47	50	45
14	Real	38	34	47	44
15	Forli	38	47	47	43
16	Vastese	38	47	61	42
17	Olympia	38	36	46	41
18	Santarcangel	38	41	61	37
19	Isernia	38	28	53	35
20	Castelfidard	38	34	73	23

TEMPORADA 2017/2018

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Vis Pesaro	34	61	29	73
2	Matelica	34	66	28	71
3	Avezzano	34	51	26	62
4	Pineto	34	53	41	57
5	L'Aquila	34	57	40	55
6	Francavilla	34	47	38	53
7	Marino	34	45	35	51
8	Vastese	34	55	50	51
9	Città	34	41	40	49
10	Sangiustese	34	39	41	48
11	Castelfidard	34	43	54	44
12	Recanatese	34	47	47	43
13	Olympia	34	34	35	41
14	Notaresco	34	42	51	40
15	Jesina	34	32	46	34
16	Monticelli	34	25	45	30
17	Fabriano	34	29	69	20
18	Nerostellati	34	19	71	18

TEMPORADA 2016/2017

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Fermana	32	51	28	69
2	Matelica	32	56	30	63
3	Notaresco	32	53	29	60
4	Vis Pesaro	32	48	32	53
5	Olympia	32	45	33	51
6	Sammaurese	32	37	25	50
7	Monticelli	32	37	33	47
8	Vastese	32	43	32	45
9	Marino	32	43	38	41
10	Jesina	32	35	44	40
11	Romagna	32	34	42	39
12	Pineto	32	35	44	39
13	Città	32	32	44	38
14	Alfonsine	32	33	45	30
15	Castelfidard	32	28	44	28
16	Recanatese	32	30	50	27
17	Civitanovese	32	22	69	17
18	Chieti	0	0	0	0

TEMPORADA 2015/2016

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Sambenedette	34	76	36	81
2	Fano	34	49	29	68
3	Città	34	48	27	61
4	Matelica	34	57	37	58
5	Fermana	34	50	39	55
6	Chieti	34	49	38	49
7	Recanatese	34	45	50	48
8	Jesina	34	39	46	47
9	Notaresco	34	49	42	46
10	Avezzano	34	51	52	44
11	Vis Pesaro	34	40	42	43
12	Castelfidard	34	33	40	42
13	Olympia	34	47	49	40
14	Monticelli	34	42	48	37
15	Isernia	34	27	49	37
16	Folgore	34	34	52	32
17	Real	34	27	63	27
18	Amiternina	34	34	58	24

TEMPORADA 2014/2015

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Maceratese	34	61	22	78
2	Fano	34	60	25	74
3	Sambenedette	34	71	40	63
4	Città	34	49	42	57
5	Notaresco	34	59	46	52
6	Chieti	34	52	46	50
7	Civitanovese	34	56	51	50
8	Matelica	34	36	34	45
9	Real	34	44	43	45
10	Jesina	34	40	38	42
11	Fermana	34	37	44	42
12	Recanatese	34	37	44	39
13	Termoli	34	31	53	39
14	Amiternina	34	30	45	38
15	Olympia	34	31	51	31
16	Castelfidard	34	25	49	31
17	Vis Pesaro	34	35	45	29
18	Celano	34	23	59	17

TEMPORADA 2012/2013

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Sambenedette	34	75	35	71
2	Termoli	34	74	39	68
3	Cesareo	34	69	44	68
4	Maceratese	34	58	39	64
5	Vis Pesaro	34	47	25	57
6	Olympia	34	68	56	53
7	Ancona	34	54	43	53
8	Astrea	34	53	47	50
9	Jesina	34	50	47	46
10	Civitanovese	34	34	45	42
11	Amiternina	34	39	49	40
12	Fidene	34	41	52	40
13	Isernia	34	46	65	38
14	RC Angolana	34	35	53	37
15	Celano	34	32	42	33
16	Recanatese	34	28	51	29
17	Notaresco	34	36	62	22
18	Città	34	33	78	20

TEMPORADA 2011/2012

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Teramo	34	86	29	73
2	Sambenedette	34	57	31	72
3	Civitanovese	34	60	33	68
4	Isernia	34	46	35	60
5	Atletico	34	60	46	59
6	Notaresco	34	43	40	50
7	Jesina	34	48	33	48
8	Olympia	34	64	56	48
9	Recanatese	34	41	36	46
10	Vis Pesaro	34	45	47	44
11	Riccione	34	52	56	39
12	Atessa	34	40	49	39
13	RC Angolana	34	34	45	36
14	Santegidiese	34	48	62	36
15	Miglianico	34	32	57	24
16	Luco	34	22	71	19
17	Real Rimini	34	16	105	6

Competiciones que juega

Grupo 6

Serie D Grupo 6

Pos	Equipos		Pts
1		Città di Campobasso	66
2		L'Aquila	64
3		Sambenedettese	54
4		Avezzano	53
5		Vigor Senigallia	49
6		Roma City	48
7		Chieti	47
8		SN Notaresco 2018	45
9		ASD Atletico Ascoli	44
10		Termoli Calcio	41
11		Sora	40
12		FC Fossombrone	40
13		Real Monterotondo Scalo	38
14		Riccione	34
15		Tivoli	31
16		Fano	29
17		Vastogirardi	29
18		Matese	25

	Ascenso : Città di Campobasso
	Playoff Ascenso : L'Aquila, Sambenedettese, Avezzano, Vigor Senigallia
	Playoff Descenso : Real Monterotondo Scalo, Riccione, Tivoli, Fano
	Descenso : Vastogirardi, Matese

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D

USO DE MEMORIA

6,803,128 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	1.1246
Total Execution Time	1.1258

CADENA URL

/historico/San-Nicolo

GET DATOS

$_GET['/historico/San-Nicolo']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6931 AND type_rel = 2
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6931 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (49789) ORDER BY n.cover_points DESC, update_date DESC
0.0035	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 = '6931' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025	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 = 73984 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036	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=6931 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0024	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 (73984,73559,71633,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.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 73984 AND teamId = 6931
0.0048	SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 6931
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 71633 AND teamId = 6931
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6931
0.0048	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73984 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0026	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 = '6931' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6931' and rp.type = 4
0.0025	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 = '6931' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035	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 = 73984 WHERE rp.league_id = 73984 AND rp.teamId = 6931 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 = 73984 WHERE rp.league_id = 73984 AND rp.teamId = 6931 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 73984 WHERE rp.league_id = 73984 AND rp.teamId = 6931 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 6931 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* `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 = 73984 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.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68752 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 64280 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 = 58831 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.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* `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 = 51161 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.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* `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 = 44801 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* `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 = 39599 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* `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 = 33454 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* `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 = 15654 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 4819 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 = 2095 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 1696 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73984 ORDER BY nameShow LIMIT 100

SN Notaresco 2018

SN Notaresco 2018

Selecciona un equipo

Competiciones que juega

Serie D Grupo 6

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D