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

Fermana

Temporada 2020/2021

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 C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vicenza	27	41	12	61
2	Reggiana	27	45	25	55
3	AC Carpi	26	44	21	53
4	Südtirol	27	43	24	48
5	Feralpisalò	26	34	31	44
6	Padova	26	35	19	44
7	Piacenza	26	32	24	41
8	Modena	27	29	25	40
9	Triestina	27	36	32	40
10	Fermana	27	22	33	33
11	Sambenedette	26	31	31	33
12	Virtus	27	33	35	32
13	Cesena	27	33	42	30
14	Gubbio 1910	27	23	31	28
15	Vis Pesaro	27	22	37	28
16	Ravenna FC	27	25	41	27
17	Imolese	27	20	35	23
18	Arzignano	26	18	32	22
19	Fano	27	24	42	21
20	Rimini	27	24	42	21

TEMPORADA 2018/2019

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pordenone	38	56	32	73
2	Triestina	38	60	33	67
3	Imolese	38	51	33	62
4	Feralpisalò	38	50	41	62
5	AC Monza	38	45	35	60
6	Südtirol	38	42	33	55
7	Ravenna FC	38	39	38	55
8	Vicenza	38	43	38	51
9	Sambenedette	38	40	40	50
10	Fermana	38	21	35	47
11	Ternana	38	39	40	44
12	Gubbio 1910	38	35	45	44
13	AlbinoLeffe	38	31	35	43
14	Teramo	38	36	46	43
15	Vis Pesaro	38	29	31	42
16	Giana	38	42	50	42
17	Renate	38	23	33	39
18	Rimini	38	28	44	39
19	Virtus	38	36	50	38
20	Fano	38	18	32	38

TEMPORADA 2017/2018

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Padova	34	44	27	63
2	Südtirol	34	37	28	55
3	Sambenedette	34	38	31	53
4	Reggiana	34	41	35	53
5	AlbinoLeffe	34	36	31	49
6	Feralpisalò	34	47	43	49
7	Bassano	34	38	30	48
8	Renate	34	34	31	48
9	Mestre	34	40	36	46
10	Pordenone	34	46	44	46
11	Ravenna FC	34	31	38	43
12	Triestina	34	42	36	43
13	Fano	34	25	31	38
14	Fermana	34	27	36	38
15	Santarcangel	34	34	52	37
16	Gubbio 1910	34	34	46	36
17	Teramo	34	33	42	35
18	Vicenza	34	29	39	31
19	Modena	0	0	0	0

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 2013/2014

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Ancona	34	69	18	78
2	Matelica	34	64	29	68
3	Termoli	34	66	28	67
4	Maceratese	34	61	34	64
5	Vis Pesaro	34	53	38	49
6	Recanatese	34	53	39	49
7	Celano	34	46	26	46
8	Jesina	34	51	48	46
9	Fermana	34	48	40	45
10	Fano	34	37	31	44
11	Real	34	45	41	44
12	Civitanovese	34	36	32	44
13	Olympia	34	41	47	43
14	Amiternina	34	38	40	40
15	Sulmona	34	40	53	40
16	Isernia	34	29	57	28
17	RC Angolana	34	34	53	26
18	Bojano	34	9	166	4

TEMPORADA 2005/2006

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Spezia	34	42	22	63
2	Genoa	34	42	27	59
3	AC Monza	34	35	25	56
4	Pavia	34	44	29	54
5	Teramo	34	39	35	53
6	Salernitana	34	42	30	52
7	Cittadella	34	38	33	50
8	Novara	34	40	36	48
9	Padova	34	36	32	47
10	Pro Patria	34	36	39	44
11	Pizzighetton	34	37	32	43
12	Real	34	33	33	43
13	Ravenna FC	34	30	33	43
14	Sambenedette	34	35	48	42
15	Pro Sesto	34	28	48	38
16	Marino	34	32	38	35
17	Lumezzane	34	35	44	35
18	Fermana	34	18	58	13

TEMPORADA 2004/2005

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rimini	34	50	23	70
2	Avellino	34	48	29	64
3	Napoli	34	45	31	61
4	Reggiana	34	41	24	54
5	Sambenedette	34	38	25	54
6	Padova	34	46	39	48
7	Virtus	34	36	38	46
8	Benevento	34	31	38	45
9	SPAL	34	36	33	43
10	Calcio	34	36	35	42
11	Martina	34	31	41	42
12	Cittadella	34	36	37	41
13	Teramo	34	32	37	40
14	Fermana	34	30	45	39
15	Sora	34	35	42	36
16	Real	34	20	43	31
17	Chieti	34	19	32	30
18	Vis Pesaro	34	21	39	25

TEMPORADA 2003/2004

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Catanzaro	34	44	25	67
2	Crotone	34	57	33	65
3	Viterbese	34	45	29	61
4	Acireale	34	40	26	60
5	Benevento	34	41	28	56
6	Virtus	34	34	31	53
7	Sambenedette	34	50	40	52
8	Chieti	34	39	35	48
9	Calcio	34	43	43	46
10	Teramo	34	40	41	45
11	Martina	34	45	50	42
12	Real	34	35	39	41
13	Sora	34	27	35	41
14	Fermana	34	34	46	40
15	Vis Pesaro	34	31	48	36
16	Paternò	34	32	47	32
17	Taranto	34	31	46	30
18	L'Aquila	34	26	52	13

TEMPORADA 2002/2003

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pescara	34	64	36	69
2	Avellino	34	51	25	69
3	Martina	34	52	37	62
4	Teramo	34	58	40	58
5	Sambenedette	34	46	26	56
6	Crotone	34	40	29	50
7	Virtus	34	39	39	49
8	Benevento	34	27	32	44
9	Taranto	34	31	35	41
10	Chieti	34	28	32	41
11	Viterbese	34	37	50	39
12	Sassari	34	34	37	38
13	Vis Pesaro	34	29	40	36
14	Real	34	29	37	35
15	Paternò	34	31	46	35
16	Sora	34	36	48	34
17	L'Aquila	34	30	53	33
18	Fermana	34	28	48	32

TEMPORADA 2001/2002

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ascoli	34	55	26	67
2	Taranto	34	50	30	62
3	Catania	34	44	26	58
4	Pescara	34	48	29	53
5	Real	34	44	31	51
6	Virtus	34	36	30	51
7	Avellino	35	40	43	48
8	Chieti	34	28	27	47
9	Fermana	34	32	33	46
10	L'Aquila	35	33	46	46
11	Viterbese	34	33	35	44
12	Sassari	34	41	35	43
13	Vis Pesaro	34	32	32	43
14	Castel	34	27	37	39
15	Benevento	34	27	38	39
16	Nocerina	34	32	59	30
17	Sora	34	21	39	29
18	Lodigiani	34	24	51	23

TEMPORADA 2000/2001

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Palermo FC	34	47	31	64
2	ACR Messina	34	40	26	61
3	Catania	34	49	40	58
4	Avellino	34	45	27	57
5	Ascoli	34	47	33	54
6	Sassari	34	55	45	53
7	Castel	34	44	40	47
8	L'Aquila	34	37	35	46
9	Fermana	34	41	38	42
10	Real	34	36	40	42
11	Vis Pesaro	34	26	29	39
12	Lodigiani	34	34	44	39
13	Benevento	34	40	54	39
14	Nocerina	34	29	42	36
15	Viterbese	34	32	48	29
16	Atl. Catania	34	27	44	27

TEMPORADA 1999/2000

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Vicenza	38	69	45	67
2	Atalanta	38	51	34	63
3	Brescia	38	54	38	63
4	Napoli	38	55	44	63
5	Sampdoria	38	45	40	62
6	Genoa	38	51	42	57
7	Salernitana	38	55	61	52
8	Treviso	38	56	48	51
9	Empoli	38	42	52	51
10	Ternana	38	45	47	49
11	Pistoiese	38	39	43	49
12	Ravenna FC	38	41	39	48
13	Cosenza	38	36	41	48
14	Pescara	38	62	55	47
15	AC Monza	38	45	46	47
16	Chievo	38	48	53	47
17	Cesena	38	47	45	45
18	AlzanoCene	38	39	51	42
19	Savoia 1908	38	36	62	29
20	Fermana	38	36	66	29

Competiciones que juega

Grupo 2

Serie C Grupo 2

Pos	Equipos		Pts
1		Perugia	79
2		Padova	79
3		FC Südtirol	75
4		Modena	70
5		Feralpisalò	60
6		Triestina	59
7		Cesena	57
8		Matelica Calcio	56
9		Sambenedettese	54
10		Mantova	49
11		Virtus Verona	49
12		AS Gubbio 1910	48
13		Fermana	42
14		Vis Pesaro	41
15		AC Carpi	41
16		Legnago Salus	38
17		Imolese	35
18		Fano	33
19		Ravenna FC	30
20		SS Arezzo	29

	Ascenso : Perugia
	Playoff Ascenso : Padova, FC Südtirol, Modena, Feralpisalò, Triestina, Cesena, Matelica Calcio, Mantova, Virtus Verona
	Descenso : Sambenedettese, AC Carpi, SS Arezzo
	Playoff Descenso : Legnago Salus, Imolese, Fano, Ravenna FC

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie C

USO DE MEMORIA

7,312,576 bytes

BENCHMARKS

Loading Time Base Classes	0.0016
Controller Execution Time ( Home / Category )	0.1571
Total Execution Time	0.1588

CADENA URL

/historico/Fermana/2021

GET DATOS

$_GET['/historico/Fermana/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0027	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 = 'Fermana' AND l.year = 2021 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=2818 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=2818 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=2818 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039	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 = 58761
0.0024	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 = 63868
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2818 AND type_rel = 2
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 = '2818' ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '2818' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '2818' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 63868 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 58761 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032	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=2818 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (69410,67435,62807,50675) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 67435 AND teamId = 2818
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 50675 AND teamId = 2818
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 69410 AND teamId = 2818
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 2818
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '2818' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2818' 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 = '2818' 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 events2021 e ON e.player_id = p.id AND e.league_id = 58761 WHERE rp.league_id = 58761 AND rp.teamId = 2818 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.0032	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 events2021 e ON e.player_id = p.id AND e.league_id = 58761 WHERE rp.league_id = 58761 AND rp.teamId = 2818 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 events2021 e ON e.player_id = p.id AND e.league_id = 58761 WHERE rp.league_id = 58761 AND rp.teamId = 2818 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 2818 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 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.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 = 51022 AND t.round = 27 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 = 44232 AND t.round = 38 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* `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 = 38930 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* `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.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* `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.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* `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 = 24680 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* `tables2006` 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 = 541 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* `tables2005` 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 = 583 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* `tables2004` 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 = 585 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* `tables2003` 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 = 587 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* `tables2002` 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 = 589 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* `tables2001` 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 = 591 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* `tables2000` 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 = 514 AND t.round = 38 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 = 58761 ORDER BY nameShow LIMIT 100

Fermana

Fermana

Selecciona un equipo

Competiciones que juega

Serie C Grupo 2

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie C