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

Cassino

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 7
Equipo		PJ	GF	GC	Puntos
1	Sorrento	34	53	28	70
2	Paganese	34	56	29	68
3	Casertana	34	57	40	58
4	Arzachena	34	51	40	57
5	Lupa Roma	34	44	29	50
6	Palmese	34	50	44	49
7	Cassino	34	42	45	47
8	Real	34	51	55	45
9	Sarrabus	34	51	54	43
10	Tivoli	34	36	39	41
11	Vis Artena	34	24	28	41
12	Portici	34	45	49	40
13	Angri	34	39	51	39
14	Atletico	34	45	62	39
15	Ilvamaddalen	34	30	39	38
16	Nola 1925	34	44	55	35
17	Pomezia	34	40	58	35
18	Aprilia	34	34	47	34

TEMPORADA 2021/2022

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Giugliano	34	63	24	75
2	Sassari	34	53	18	66
3	Team Nuova.	34	57	35	66
4	Arzachena	34	53	38	64
5	Afragolese	34	56	45	58
6	Cynthialbalo	34	62	45	55
7	Aprilia	34	47	40	52
8	Ostia Mare	34	44	36	48
9	Muravera	34	54	60	47
10	Vis Artena	34	44	48	46
11	Gladiator	34	50	52	44
12	Real	34	48	59	39
13	Cassino	34	38	49	38
14	Atletico	34	32	53	35
15	Carbonia	34	38	64	29
16	Insieme	34	33	64	29
17	Lanusei	34	32	55	28
18	Latte Dolce	34	30	49	27

TEMPORADA 2020/2021

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Monterosi	34	65	26	81
2	Latina	34	60	29	65
3	Savoia 1908	34	39	22	57
4	Nocerina	34	51	32	53
5	Vis Artena	34	51	43	53
6	Insieme	34	52	39	50
7	Lanusei	34	46	40	47
8	Muravera	34	42	40	47
9	Carbonia	34	56	55	46
10	Latte Dolce	34	45	42	44
11	Cassino	34	41	48	41
12	Gladiator	34	37	44	40
13	Team Nuova.	34	39	48	39
14	Arzachena	34	39	50	36
15	Sassari	34	31	48	34
16	Afragolese	34	40	60	34
17	Nola 1925	34	37	58	34
18	Giugliano	34	29	76	20

TEMPORADA 2019/2020

SERIE D GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Turris	26	65	24	61
2	Ostia Mare	26	46	21	57
3	Sassari	26	44	25	51
4	Trastevere	26	46	33	45
5	Latte Dolce	26	40	29	45
6	Latina	26	40	30	39
7	Cassino	26	27	30	39
8	Vis Artena	26	35	38	35
9	Muravera	26	33	32	34
10	Team Nuova.	26	33	35	33
11	Lanusei	26	23	25	31
12	Portici	26	31	41	30
13	Aprilia	26	25	30	29
14	Arzachena	26	31	39	27
15	Città	26	32	44	25
16	Calcio	26	23	55	19
17	Ladispoli	26	25	42	18
18	Budoni	26	23	49	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 2009/2010

LEGA PRO 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Juve Stabia	34	65	28	73
2	Catanzaro	34	61	29	69
3	Cisco	34	52	23	68
4	Brindisi	34	55	35	57
5	Barletta	34	35	31	56
6	Siracusa	34	40	29	54
7	Gela	34	34	26	49
8	Cassino	34	40	43	48
9	Melfi	34	48	42	47
10	Monopoli	34	38	41	43
11	Real Agro A.	34	34	37	42
12	Manfredonia	34	33	42	42
13	Scafatese	34	35	37	41
14	Isola Liri	34	23	44	35
15	Noicattaro	34	30	50	34
16	Vibonese	34	27	47	31
17	Vico Equense	34	21	37	26
18	Igea Virtus	34	24	74	9

TEMPORADA 2008/2009

LEGA PRO 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Cosenza	34	39	16	67
2	Gela	34	42	23	64
3	Catanzaro	34	39	23	59
4	Pescina	34	42	32	54
5	Cassino	34	39	27	52
6	Andria	34	33	28	52
7	Barletta	34	32	31	44
8	Monopoli	34	42	36	43
9	Real Agro A.	34	32	33	42
10	Melfi	34	39	41	41
11	Noicattaro	34	25	28	41
12	Scafatese	34	32	39	41
13	Igea Virtus	34	29	27	40
14	Manfredonia	34	25	32	40
15	Sangro	34	29	43	35
16	Vibonese	34	21	36	34
17	Isola Liri	34	24	40	30
18	Vigor	34	20	49	24

TEMPORADA 2007/2008

LEGA PRO 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Benevento	34	51	21	68
2	Pescina	34	40	31	59
3	Progreditur	34	48	40	55
4	Vigor	34	35	26	53
5	Celano	34	38	36	53
6	Monopoli	34	46	35	50
7	Gela	34	38	39	46
8	Cassino	34	30	38	45
9	Cisco Calcio	34	33	35	44
10	Catanzaro	34	32	25	43
11	Igea Virtus	34	32	33	43
12	Noicattaro	34	42	45	43
13	Melfi	34	37	42	43
14	Vibonese	34	26	30	42
15	Sangro	34	36	42	36
16	Scafatese	34	27	40	35
17	Andria	34	35	47	34
18	Turris	34	36	57	33

TEMPORADA 2006/2007

LEGA PRO 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sorrento	34	48	26	64
2	Benevento	34	42	21	63
3	Potenza SC	34	37	32	54
4	Gela	34	29	31	54
5	Monopoli	34	42	35	53
6	Sangro	34	39	36	52
7	Vigor	34	35	24	50
8	Andria	34	30	31	49
9	Catanzaro	34	34	27	45
10	Progreditur	34	48	47	44
11	Igea Virtus	34	35	35	41
12	Vibonese	34	42	45	41
13	Cassino	34	39	42	40
14	Celano	34	36	43	40
15	Melfi	34	27	43	38
16	Nocerina	34	31	38	37
17	Pro Vasto	34	23	42	31
18	Cosenza	34	35	54	30

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

6,606,968 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5742
Total Execution Time	0.5754

CADENA URL

/historico/Ss-Cassino

GET DATOS

$_GET['/historico/Ss-Cassino']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0143	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 = 'Ss-Cassino' 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.0125	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=2402 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=2402 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=2402 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255	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.0128	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2402 AND type_rel = 2
0.0143	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 = '2402' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0141	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 = '2402' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149	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.0133	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.0137	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=2402 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 (73985,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.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 73985 AND teamId = 2402
0.0138	SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 2402
0.0130	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 = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '2402' 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 = '2402' 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 = '2402' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137	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 = 2402 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.0161	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 = 2402 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 = 2402 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	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 = 2402 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 68753 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.0132	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 = 64281 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.0130	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 = 58832 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.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* `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 = 51162 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.0135	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.0135	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.0130	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 = 1046 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 449 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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* `tables2008` 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 = 19907 AND t.round = 31 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* `tables2007` 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 = 19910 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 73985 ORDER BY nameShow LIMIT 100

Cassino

Cassino

Selecciona un equipo

Competiciones que juega

Serie D Grupo 7

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie D