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

Sambenedettese

Temporada 2004/2005

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 1988/1989

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Genoa	38	35	13	67
2	SSC Bari	38	38	21	67
3	Cosenza	38	35	29	61
4	Udinese	38	37	24	58
5	Cremonese	38	40	30	57
6	Reggina	38	33	31	57
7	Avellino	38	31	29	52
8	ACR Messina	38	46	42	51
9	Licata	38	39	40	48
10	Parma	38	29	31	45
11	Padova	38	27	35	45
12	Brescia	38	27	29	43
13	Catanzaro	38	24	26	43
14	Barletta	38	40	43	43
15	Empoli	38	29	33	42
16	AC Monza	38	31	32	41
17	Ancona	38	28	35	41
18	Sambenedette	38	21	30	38
19	Taranto	38	24	40	37
20	Piacenza	38	20	41	33

TEMPORADA 1987/1988

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Bologna	38	62	37	68
2	Lecce	38	42	26	66
3	Lazio	38	42	25	62
4	Atalanta	38	50	34	61
5	Catanzaro	38	36	24	60
6	SSC Bari	38	30	27	53
7	Padova	38	38	41	52
8	Cremonese	38	26	18	51
9	Brescia	38	30	26	50
10	Udinese	38	37	35	50
11	Parma	38	33	33	47
12	ACR Messina	38	36	38	47
13	Triestina	38	32	40	44
14	Piacenza	38	26	42	42
15	Genoa	38	25	32	41
16	Taranto	38	40	54	41
17	Barletta	38	27	37	38
18	Sambenedette	38	26	37	37
19	Modena	38	30	46	37
20	SS Arezzo	38	22	38	30

TEMPORADA 1986/1987

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Pescara	38	43	33	60
2	Pisa SC	38	42	32	60
3	Cesena	38	38	29	58
4	Lecce	38	38	32	58
5	Cremonese	38	35	29	57
6	Lazio	38	35	28	56
7	Genoa	38	44	39	54
8	ACR Messina	38	29	28	52
9	Parma	38	30	26	51
10	SSC Bari	38	33	32	50
11	Triestina	38	31	26	49
12	Bologna	38	40	38	46
13	Sambenedette	38	33	37	45
14	Modena	38	32	50	45
15	Taranto	38	37	40	43
16	Città	38	34	35	42
17	SS Arezzo	38	30	33	42
18	Vicenza	38	31	40	41
19	Catania	38	25	38	40
20	Cagliari	38	32	47	40

TEMPORADA 1985/1986

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Ascoli	38	56	33	67
2	Brescia	38	41	28	64
3	Vicenza	38	48	33	62
4	Triestina	38	40	30	60
5	Empoli	38	32	28	58
6	Bologna	38	37	29	56
7	Genoa	38	35	31	54
8	Cesena	38	42	38	51
9	Catania	38	30	37	48
10	Cagliari	38	27	38	48
11	Cremonese	38	35	31	47
12	Lazio	38	38	42	47
13	Città	38	30	36	46
14	Sambenedette	38	26	26	45
15	SS Arezzo	38	37	40	45
16	Pescara	38	33	37	43
17	Palermo FC	38	27	35	41
18	Perugia	38	29	39	40
19	Catanzaro	38	33	45	39
20	AC Monza	38	25	45	32

TEMPORADA 1984/1985

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Pisa SC	38	52	27	67
2	SSC Bari	38	42	25	67
3	Lecce	38	40	26	66
4	Triestina	38	39	27	63
5	Perugia	38	38	25	59
6	Genoa	38	38	32	53
7	Pescara	38	38	35	50
8	Città	38	29	32	48
9	AC Monza	38	26	28	46
10	Cagliari	38	29	32	46
11	Cesena	38	35	34	45
12	Sambenedette	38	27	29	45
13	Bologna	38	25	31	45
14	Empoli	38	22	28	45
15	SS Arezzo	38	25	33	45
16	Padova	38	31	34	43
17	Varese	38	37	42	42
18	Catania	38	33	38	42
19	Parma	38	25	47	32
20	Taranto	38	25	51	29

TEMPORADA 1983/1984

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Atalanta	38	49	28	65
2	Como	38	41	26	65
3	Cremonese	38	44	29	60
4	Lecce	38	33	28	55
5	Città	38	31	31	53
6	SS Arezzo	38	34	33	52
7	Padova	38	34	28	51
8	Triestina	38	37	40	49
9	Pescara	38	41	48	49
10	Varese	38	30	38	48
11	Perugia	38	33	30	47
12	Cagliari	38	31	32	46
13	AC Monza	38	29	34	46
14	Pistoiese	38	27	34	46
15	Cesena	38	31	33	45
16	Sambenedette	38	30	35	44
17	Palermo FC	38	30	32	43
18	Empoli	38	27	34	43
19	Cavese 1919	38	25	33	41
20	Catanzaro	38	34	45	40

TEMPORADA 1982/1983

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Milan	38	77	36	73
2	Lazio	38	44	32	60
3	Catania	38	37	21	59
4	Cremonese	38	42	28	58
5	Como	38	36	24	58
6	Cavese 1919	38	38	37	54
7	AC Monza	38	40	42	51
8	Atalanta	38	30	27	47
9	Sambenedette	38	33	32	47
10	Perugia	38	36	37	47
11	Varese	38	31	37	46
12	SS Arezzo	38	30	38	46
13	Città	38	26	34	45
14	Palermo FC	38	36	46	45
15	Lecce	38	33	44	44
16	Pistoiese	38	33	34	41
17	Bologna	38	31	47	41
18	SSC Bari	38	30	46	39
19	Reggiana	38	39	49	38
20	Calcio	38	24	35	38

TEMPORADA 1981/1982

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Hellas	38	49	31	65
2	Sampdoria	38	41	25	64
3	SSC Bari	38	47	33	60
4	Varese	38	42	30	60
5	Pisa SC	38	47	26	59
6	Perugia	38	37	26	58
7	Palermo FC	38	52	42	57
8	Sambenedette	38	37	32	49
9	Catania	38	38	41	49
10	Lazio	38	38	35	48
11	Cremonese	38	36	39	48
12	Lecce	38	30	35	47
13	Rimini	38	39	45	47
14	Calcio	38	30	37	47
15	Cavese 1919	38	28	35	47
16	Reggiana	38	31	36	45
17	Pistoiese	38	31	38	45
18	Brescia	38	26	39	39
19	SPAL	38	26	43	34
20	Pescara	38	20	57	21

TEMPORADA 1979/1980

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Como	38	33	17	64
2	Brescia	38	39	27	62
3	Pistoiese	38	36	23	58
4	AC Monza	38	40	38	57
5	Vicenza	38	49	37	55
6	Cesena	38	39	32	55
7	Sampdoria	38	33	27	51
8	Palermo FC	38	35	32	50
9	Atalanta	38	29	24	49
10	SPAL	38	33	32	49
11	Genoa	38	33	34	49
12	Hellas	38	24	26	49
13	Pisa SC	38	25	24	48
14	SSC Bari	38	26	30	47
15	Taranto	38	24	29	47
16	Lecce	38	27	30	46
17	Sambenedette	38	23	31	45
18	Ternana	38	26	36	41
19	Parma	38	27	49	34
20	Matera	38	19	42	34

TEMPORADA 1978/1979

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Udinese	38	52	22	76
2	Cagliari	38	46	24	65
3	AC Monza	38	39	20	64
4	Pescara	38	44	27	64
5	Pistoiese	38	38	28	59
6	Lecce	38	33	33	57
7	Palermo FC	38	38	34	52
8	Brescia	38	41	41	50
9	Genoa	38	34	35	46
10	Sampdoria	38	37	39	45
11	Sambenedette	38	35	42	45
12	Cesena	38	27	29	44
13	SPAL	38	34	37	44
14	Ternana	38	33	39	44
15	Taranto	38	25	30	42
16	Calcio	38	39	45	41
17	SSC Bari	38	29	36	41
18	Nocerina	38	24	39	37
19	Varese	38	29	55	30
20	Rimini	38	17	39	27

TEMPORADA 1977/1978

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Ascoli	38	73	30	87
2	Catanzaro	38	50	41	60
3	Avellino	38	34	29	59
4	AC Monza	38	36	29	56
5	Ternana	38	34	27	56
6	Palermo FC	38	42	36	52
7	Lecce	38	27	26	51
8	Sampdoria	38	41	37	50
9	Cagliari	38	52	47	49
10	Cesena	38	36	33	49
11	Sambenedette	38	30	28	49
12	SSC Bari	38	38	42	49
13	Taranto	38	31	38	48
14	Pistoiese	38	33	40	46
15	Varese	38	34	44	45
16	Brescia	38	35	40	44
17	Rimini	38	31	39	43
18	Cremonese	38	34	38	42
19	Como	38	25	37	39
20	Modena	38	24	59	26

TEMPORADA 1976/1977

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Vicenza	38	47	29	69
2	Atalanta	38	44	26	68
3	Pescara	38	48	29	66
4	Cagliari	38	45	32	66
5	AC Monza	38	46	27	65
6	Como	38	35	27	53
7	Lecce	38	33	32	52
8	Varese	38	41	37	50
9	Taranto	38	32	31	49
10	Ascoli	38	41	43	49
11	Sambenedette	38	27	31	46
12	Ternana	38	32	45	43
13	Rimini	38	25	27	42
14	Modena	38	28	35	42
15	Avellino	38	27	37	42
16	Brescia	38	35	46	41
17	Palermo FC	38	29	41	41
18	SPAL	38	29	37	37
19	Catania	38	26	44	37
20	Novara	38	34	48	36

TEMPORADA 1975/1976

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Catanzaro	38	36	23	61
2	Calcio	38	28	23	60
3	Genoa	38	57	33	59
4	Varese	38	50	37	59
5	Brescia	38	42	37	56
6	SPAL	38	40	36	54
7	Avellino	38	38	34	53
8	Modena	38	30	34	52
9	Novara	38	31	29	51
10	Atalanta	38	26	24	51
11	Pescara	38	25	32	50
12	Palermo FC	38	34	35	49
13	Taranto	38	28	31	49
14	Sambenedette	38	26	30	49
15	Ternana	38	30	33	48
16	Vicenza	38	36	35	44
17	Catania	38	27	30	44
18	Piacenza	38	42	50	42
19	Brindisi	38	20	41	34
20	Reggiana	38	31	50	29

TEMPORADA 1974/1975

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Perugia	38	44	27	66
2	Como	38	40	23	64
3	Hellas	38	39	30	61
4	Catanzaro	38	27	18	58
5	Palermo FC	38	31	25	56
6	Atalanta	38	37	36	53
7	Genoa	38	31	33	52
8	Sambenedette	38	36	43	49
9	SPAL	38	38	42	48
10	Calcio	38	31	35	48
11	Brescia	38	24	28	47
12	Brindisi	38	32	38	46
13	Avellino	38	33	29	45
14	Pescara	38	37	38	45
15	Novara	38	30	33	45
16	Taranto	38	24	34	45
17	Alessandria	38	35	38	43
18	Reggiana	38	33	36	43
19	Parma	38	30	37	42
20	SS Arezzo	38	35	44	42

TEMPORADA 1962/1963

SERIE B
Equipo		PJ	GF	GC	Puntos
1	ACR Messina	38	50	31	68
2	Lazio	38	50	31	66
3	SSC Bari	38	47	26	63
4	Brescia	38	40	27	60
5	Calcio	38	56	42	59
6	Lecco	38	45	36	56
7	Hellas	38	41	34	56
8	Padova	38	45	47	54
9	AC Monza	38	56	52	52
10	Cagliari	38	41	40	50
11	Pro Patria	38	36	33	49
12	Catanzaro	38	34	43	49
13	Parma	38	32	44	47
14	Alessandria	38	32	34	45
15	Udinese	38	49	48	44
16	Triestina	38	49	59	44
17	Cosenza	38	27	37	42
18	Como	38	38	51	40
19	Sambenedette	38	29	51	38
20	Lucchese	38	36	67	28

TEMPORADA 1961/1962

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Genoa	38	64	28	76
2	Napoli	38	44	35	58
3	Modena	38	39	36	58
4	Lazio	38	50	28	56
5	Hellas	38	39	27	56
6	SSC Bari	38	48	38	56
7	Pro Patria	38	43	38	56
8	ACR Messina	38	53	46	53
9	Brescia	38	37	36	51
10	AC Monza	38	37	44	50
11	Alessandria	38	45	46	49
12	Novara	38	37	43	48
13	Lucchese	38	46	54	47
14	Sambenedette	38	30	42	45
15	Como	38	33	46	45
16	Parma	38	25	33	44
17	Cosenza	38	29	46	44
18	Catanzaro	38	37	50	43
19	Prato	38	33	47	41
20	Reggiana	38	34	40	40

TEMPORADA 1960/1961

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Venezia	38	54	31	72
2	Mantova	38	44	25	67
3	Palermo FC	38	46	27	59
4	Reggiana	38	63	55	59
5	AC Monza	38	36	26	56
6	Genoa	38	47	42	56
7	ACR Messina	38	45	34	54
8	Alessandria	38	43	41	54
9	Sambenedette	38	35	42	54
10	Pro Patria	38	46	39	53
11	Catanzaro	38	46	42	53
12	Prato	38	35	41	51
13	Como	38	42	45	50
14	Parma	38	36	36	47
15	Brescia	38	44	38	46
16	Hellas	38	31	44	45
17	Novara	38	31	51	44
18	Triestina	38	31	39	42
19	Calcio	38	40	56	39
20	AC Marzotto	38	28	69	25

Competiciones que juega

Grupo 6

Serie C Grupo 2

Pos	Equipos		Pts
1		Rimini	70
2		Avellino	64
3		Napoli	61
4		Reggiana	54
5		Sambenedettese	54
6		Padova	48
7		Virtus Lanciano	46
8		Benevento	45
9		SPAL	43
10		Calcio Foggia	42
11		Martina	42
12		Cittadella	41
13		Teramo	40
14		Fermana	39
15		Sora	36
16		Real Giulianova	31
17		Chieti	30
18		Vis Pesaro	25

RIVALES EN Serie C

USO DE MEMORIA

8,181,256 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.7136
Total Execution Time	0.7149

CADENA URL

/historico/Ss-Sambenedettese-Calcio/2005

GET DATOS

$_GET['/historico/Ss-Sambenedettese-Calcio/2005']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0186	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-Sambenedettese-Calcio' AND l.year = 2005 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.0130	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=2408 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=2408 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 = 583
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2408 AND type_rel = 2
0.0128	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2408 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0138	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 (468433,648783,797663,870260,871850) ORDER BY n.cover_points DESC, update_date DESC
0.0153	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 = '2408' AND l.year = 2005 ORDER BY l.year DESC,cat.coefficient DESC
0.0138	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 = '2408' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 583 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134	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=2408 AND l.year in (2004,2005,2006) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (14131,585) 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.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 585 AND teamId = 2408
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 14131 AND teamId = 2408
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 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 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 = '2408' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2408' and rp.type = 4
0.0128	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 = '2408' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0152	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 events2005 e ON e.player_id = p.id AND e.league_id = 583 WHERE rp.league_id = 583 AND rp.teamId = 2408 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.0144	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 events2005 e ON e.player_id = p.id AND e.league_id = 583 WHERE rp.league_id = 583 AND rp.teamId = 2408 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 events2005 e ON e.player_id = p.id AND e.league_id = 583 WHERE rp.league_id = 583 AND rp.teamId = 2408 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161	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 = 2408 AND l.year <= 2005 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.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* `tables1988` 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 = 30860 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* `tables1987` 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 = 30859 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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* `tables1986` 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 = 30858 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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* `tables1985` 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 = 30857 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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* `tables1984` 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 = 30856 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0190	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* `tables1983` 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 = 30855 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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* `tables1982` 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 = 30854 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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* `tables1980` 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 = 30852 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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* `tables1979` 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 = 30851 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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* `tables1978` 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 = 30850 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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* `tables1977` 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 = 30849 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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* `tables1976` 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 = 30848 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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* `tables1975` 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 = 30847 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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* `tables1963` 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 = 30835 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	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* `tables1962` 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 = 30834 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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* `tables1961` 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 = 30833 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 583 ORDER BY nameShow LIMIT 100

Sambenedettese

Sambenedettese

Selecciona un equipo

Competiciones que juega

Serie C Grupo 2

RIVALES EN Serie C