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

Flaminia

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Cavese 1919	33	55	23	75
2	Ischia	33	42	24	60
3	Nocerina	33	44	27	59
4	Romana	33	47	33	58
5	Cassino	33	37	21	55
6	Flaminia	33	42	34	50
7	Ostia Mare	33	52	41	46
8	Cynthialbalo	33	41	34	46
9	Sarrabus	33	46	48	46
10	San Marzano	33	35	34	43
11	Trastevere	33	41	48	38
12	Team Nuova.	33	36	41	36
13	Atletico	33	29	47	36
14	Latte Dolce	33	30	42	34
15	Anzio	33	36	57	34
16	Gladiator	33	33	46	31
17	Boreale	33	17	41	26
18	Budoni	33	25	47	25

TEMPORADA 2022/2023

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	SS Arezzo	34	54	30	70
2	Pianese	34	58	42	63
3	Poggibonsi	34	65	43	58
4	Follonica	34	52	41	55
5	Flaminia	34	47	40	49
6	Livorno	34	39	35	49
7	Seravezza	34	41	41	47
8	Ghivizzano	34	40	41	43
9	Altopascio	34	41	43	42
10	Orvietana	34	38	42	42
11	Sangiovannes	34	38	37	41
12	Grosseto	34	37	40	41
13	Ostia Mare	34	30	34	41
14	Ponsacco	34	39	53	38
15	Sporting	34	40	48	37
16	Terranuova	34	31	45	35
17	Montespaccat	34	30	45	33
18	Città	34	32	52	32

TEMPORADA 2021/2022

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Donato	34	86	30	81
2	Poggibonsi	34	61	28	74
3	SS Arezzo	34	65	45	64
4	Follonica	34	63	30	63
5	Pianese	34	58	42	56
6	Lornano	34	47	43	54
7	Sporting	34	48	43	49
8	Flaminia	34	49	50	46
9	Montespaccat	34	43	44	42
10	ASD Cascina	34	39	40	42
11	Tiferno	34	36	48	42
12	Sangiovannes	34	37	39	41
13	Scandicci	34	36	44	41
14	Foligno	34	46	65	35
15	Rieti	34	39	58	35
16	Unipomezia	34	38	64	31
17	Cannara	34	27	52	24
18	Pro Livorno	34	31	84	21

TEMPORADA 2020/2021

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Montevarchi	34	68	32	71
2	Trastevere	34	56	38	60
3	Sporting	34	48	33	56
4	Donato	34	48	41	54
5	Siena	34	48	40	53
6	Pianese	34	42	34	51
7	Follonica	34	48	37	51
8	Lornano	34	51	44	48
9	Tiferno	34	44	48	47
10	Cannara	34	41	48	47
11	Sangiovannes	34	42	43	45
12	Montespaccat	34	40	47	41
13	Ostia Mare	34	50	54	39
14	Flaminia	34	44	57	39
15	Foligno	34	35	48	36
16	Scandicci	34	42	49	35
17	Grassina	34	32	52	30
18	Sinalunghese	34	24	58	23

TEMPORADA 2019/2020

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Grosseto	26	44	25	52
2	Monterosi	26	35	20	50
3	Grassina	26	39	32	46
4	Albalonga	26	36	24	45
5	Montevarchi	26	35	26	40
6	Scandicci	26	45	30	39
7	Foligno	26	33	27	36
8	Aglianese	26	35	30	34
9	Follonica	26	33	31	34
10	Flaminia	26	31	29	34
11	Cannara	26	31	31	33
12	Sporting	26	34	35	33
13	Sangiovannes	26	25	37	32
14	Donato	26	30	32	31
15	Pomezia	26	23	34	26
16	Bastia	26	22	36	26
17	Ponsacco	26	20	46	17
18	Tuttocuoio	26	19	45	16

TEMPORADA 2018/2019

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Avellino	38	70	36	83
2	Lanusei	38	62	30	83
3	Trastevere	38	70	39	75
4	Latte Dolce	38	56	32	71
5	Cassino	38	65	44	69
6	Monterosi	38	58	39	67
7	Latina	38	54	40	56
8	Vis Artena	38	66	63	55
9	Aprilia	38	51	48	55
10	Albalonga	38	63	51	54
11	Fiuggi	38	64	55	54
12	Flaminia	38	47	51	43
13	Budoni	38	51	60	43
14	Ladispoli	38	47	66	40
15	Sassari	38	35	59	40
16	Ostia Mare	38	35	45	39
17	Città	38	29	42	39
18	Castiadas	38	43	62	36
19	Lupa Roma	38	44	79	31
20	Anzio	38	29	98	17

TEMPORADA 2017/2018

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Rieti	34	76	29	75
2	Albalonga	34	60	28	70
3	Fiuggi	34	73	37	66
4	Trastevere	34	60	43	62
5	Latina	34	55	42	61
6	Aprilia	34	52	42	54
7	Cassino	34	50	48	52
8	Lupa Roma	34	47	49	46
9	Monterosi	34	47	42	44
10	Budoni	34	40	41	43
11	Ostia Mare	34	47	56	42
12	Flaminia	34	42	48	41
13	Latte Dolce	34	39	45	40
14	Lanusei	34	41	55	37
15	Nuorese	34	28	46	35
16	Anzio	34	28	68	28
17	Tortolì	34	36	65	26
18	San Teodoro	34	47	84	23

TEMPORADA 2016/2017

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Arzachena	34	62	21	74
2	Monterosi	34	69	22	73
3	Rieti	34	67	29	71
4	L'Aquila	34	57	27	63
5	Ostia Mare	34	59	33	63
6	Nuorese	34	43	33	58
7	Albalonga	34	59	42	55
8	Avezzano	34	42	36	46
9	Sansepolcro	34	50	47	46
10	Flaminia	34	48	41	45
11	Lanusei	34	45	52	44
12	Sporting	34	46	44	43
13	Latte Dolce	34	34	44	38
14	San Teodoro	34	32	57	31
15	Muravera	34	24	51	30
16	Sassari	34	23	58	28
17	Città	34	25	64	24
18	Foligno	34	12	96	12

TEMPORADA 2015/2016

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Viterbese	34	67	24	76
2	Grosseto	34	71	43	68
3	Sassari	34	64	28	66
4	Olbia Calcio	34	58	42	63
5	Rieti	34	52	30	62
6	Arzachena	34	44	37	59
7	Albalonga	34	63	45	57
8	Nuorese	34	41	33	51
9	Flaminia	34	49	44	47
10	Ostia Mare	34	34	34	44
11	Trastevere	34	35	38	40
12	Muravera	34	38	51	37
13	Lanusei	34	25	49	35
14	Budoni	34	36	49	34
15	Cynthia	34	37	60	33
16	Castiadas	34	31	57	31
17	Cesareo	34	24	48	28
18	Astrea	34	22	79	14

TEMPORADA 2014/2015

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Siena	34	63	30	72
2	Poggibonsi	34	45	24	68
3	Rieti	34	57	31	61
4	Ponsacco	34	53	33	61
5	Massese	34	51	33	58
6	Sansepolcro	34	50	36	55
7	Gualdo	34	50	46	49
8	Sangiovanniv	34	44	42	49
9	Foligno	34	51	42	48
10	Flaminia	34	48	60	46
11	Pianese	34	47	47	43
12	Follonica	34	43	49	42
13	Voluntas	34	40	51	39
14	Colligiana	34	30	41	37
15	Donato	34	47	59	37
16	Villabiagio	34	42	57	31
17	Sporting	34	32	58	25
18	Bastia	34	26	80	10

TEMPORADA 2013/2014

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Pistoiese	34	78	28	77
2	Foligno	34	46	20	69
3	SS Arezzo	34	57	27	64
4	Pianese	34	60	38	63
5	Scandicci	34	51	42	62
6	Ostia Mare	34	53	41	52
7	Colligiana	34	41	39	50
8	Sansepolcro	34	51	44	45
9	Gualdo	34	42	44	43
10	Sporting	34	41	44	42
11	Flaminia	34	40	43	42
12	Voluntas	34	46	48	41
13	Jolly	34	38	36	40
14	Bastia	34	38	58	39
15	Deruta	34	38	60	31
16	FiesoleCal..	34	32	65	28
17	Narnese	34	28	62	21
18	Pontevecchio	34	42	83	20

TEMPORADA 2012/2013

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Castel	34	58	25	68
2	Gualdo	34	69	35	67
3	Viterbese	34	58	37	63
4	Sansepolcro	34	41	28	58
5	Deruta	34	50	49	49
6	Voluntas	34	41	41	49
7	Pianese	34	39	39	47
8	FiesoleCal..	34	41	42	47
9	SS Arezzo	34	49	34	46
10	Sporting	33	35	31	45
11	Bastia	34	38	39	45
12	Sporting	33	43	48	44
13	Scandicci	34	40	48	44
14	Pontevecchio	34	38	51	44
15	Flaminia	34	38	49	37
16	Lanciotto	34	32	44	35
17	Pierantonio	34	30	60	27
18	Todi	34	30	70	19

TEMPORADA 2011/2012

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Pontedera	34	67	28	75
2	SS Arezzo	34	70	39	65
3	Pianese	34	54	46	53
4	Castel	34	55	42	50
5	Sporting	34	37	37	47
6	Sporting	34	48	50	47
7	Voluntas	34	43	45	47
8	Pierantonio	34	47	51	47
9	Deruta	34	36	36	46
10	Viterbese	34	42	46	46
11	Flaminia	34	50	40	44
12	Todi	34	31	30	44
13	Sansepolcre	34	38	39	44
14	Orvietana	34	47	52	40
15	Pontevecchio	34	34	48	37
16	Zagarolo	34	47	71	34
17	Città	34	34	61	31
18	Sansovino	34	33	52	30

TEMPORADA 2010/2011

SERIE D GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Perugia	34	51	24	74
2	Castel	34	64	44	62
3	Sansepolcro	34	44	28	60
4	Todi	34	49	33	58
5	Pianese	34	54	46	55
6	Città	34	44	38	51
7	Flaminia	34	44	35	48
8	Scandicci	34	43	44	46
9	SS Arezzo	34	42	41	45
10	Sporting	34	43	43	44
11	Pontevecchio	34	44	46	43
12	Voluntas	34	41	37	42
13	AS Sestese	34	43	51	38
14	Orvietana	34	39	50	37
15	Montevarchi	34	39	61	35
16	Deruta	34	32	56	34
17	Fortis	34	37	56	33
18	Monteriggion	34	33	53	29

TEMPORADA 2009/2010

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Fondi	34	59	26	64
2	Gaeta	34	62	41	60
3	Pomezia	34	53	43	58
4	Sanluri	34	49	44	57
5	Selargius	34	57	45	56
6	Flaminia	34	45	30	51
7	Viterbese	34	34	26	49
8	Aprilia	34	48	48	48
9	Latina	34	42	44	46
10	Budoni	34	51	48	44
11	Tavolara	34	38	39	42
12	Cynthia	34	39	47	40
13	Atletico	34	40	46	39
14	Astrea	34	46	63	37
15	Castelsardo	34	37	49	36
16	Arzachena	34	36	53	34
17	Rieti	34	53	75	33
18	AS Morolo	34	26	48	30

TEMPORADA 2008/2009

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Villacidrese	34	53	26	67
2	Tavolara	34	44	28	61
3	Viterbese	34	40	30	60
4	Gaeta	34	47	29	57
5	Arzachena	34	52	37	56
6	Atletico	34	42	33	50
7	Budoni	34	39	31	49
8	Cynthia	34	36	32	49
9	Flaminia	34	45	40	44
10	Monterotondo	34	38	37	44
11	Astrea	34	36	48	42
12	AS Morolo	34	39	43	40
13	Lupa Roma	34	33	40	40
14	Castelsardo	34	31	43	40
15	Ferentino	34	38	41	38
16	Guidonia	34	45	57	38
17	Civitavecchi	34	35	54	36
18	Calangianus	34	28	72	12

Competiciones que juega

Grupo 7

Serie D Grupo 7

Pos	Equipos		Pts
1		Cavese 1919	75
2		Ischia	60
3		Nocerina	59
4		Romana	58
5		Cassino	55
6		Flaminia	50
7		Ostia Mare	46
8		Cynthialbalonga	46
9		Sarrabus Ogliastra	46
10		San Marzano	43
11		Trastevere	38
12		Team Nuova Florida	36
13		Atletico Uri	36
14		Latte Dolce	34
15		Anzio	34
16		Gladiator	31
17		Boreale Calcio	26
18		Budoni	25

	Ascenso : Cavese 1919
	Playoff Ascenso : Ischia, Nocerina, Romana, Cassino
	Playoff Descenso : Atletico Uri, Latte Dolce, Anzio, Gladiator
	Descenso : Boreale Calcio, Budoni

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D

USO DE MEMORIA

7,378,528 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1471
Total Execution Time	0.1483

CADENA URL

/historico/Flaminia-Civita

GET DATOS

$_GET['/historico/Flaminia-Civita']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0042	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 = 73985
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6914 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=222 AND type_rel = 3
0.0026	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 222 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025	SELECT /53 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 (1244039,1222208,1221521,1177309,1176862) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = '6914' ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '6914' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 73985 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=6914 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (73985,73559,67320) 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 = 73985 AND teamId = 6914
0.0036	SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 6914
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 6914
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 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 = 73985 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '6914' 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 = '6914' 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 = '6914' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038	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 = 73985 WHERE rp.league_id = 73985 AND rp.teamId = 6914 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 = 73985 WHERE rp.league_id = 73985 AND rp.teamId = 6914 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73985 WHERE rp.league_id = 73985 AND rp.teamId = 6914 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 6914 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73985 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.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 = 68751 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* `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 = 64279 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* `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 = 58830 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* `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 = 51160 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.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* `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 = 44802 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* `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 = 39600 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* `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 = 33455 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* `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 = 15655 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 = 4818 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* `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 = 24677 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* `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 = 2091 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 = 1695 AND t.round = 34 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* `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 = 24698 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* `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 = 24715 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* `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 = 24734 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Flaminia

Flaminia

Selecciona un equipo

Competiciones que juega

Serie D Grupo 7

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D