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

Triestina

Entrenador: Massimo Pavanel

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mantova	37	71	30	79
2	Padova	37	52	26	74
3	Vicenza	37	50	29	68
4	Triestina	37	59	41	64
5	Atalanta	37	42	35	58
6	Legnago	37	45	38	55
7	Giana	37	46	43	53
8	Vercelli	37	49	47	50
9	Lumezzane	37	46	46	50
10	Trento	37	33	37	48
11	Virtus	37	35	42	47
12	Pro Patria	37	37	50	46
13	AlbinoLeffe	37	32	34	45
14	Renate	37	35	45	45
15	Arzignano	37	31	36	43
16	Pergolettese	37	43	50	42
17	Novara	37	37	49	40
18	Fiorenzuola	37	38	60	38
19	Pro Sesto	37	24	40	32
20	Alessandria	37	19	46	23

TEMPORADA 2022/2023

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Feralpisalò	38	41	21	71
2	Pordenone	38	53	35	62
3	Lecco	38	45	40	62
4	Pro Sesto	38	46	45	60
5	Padova	38	47	40	59
6	Virtus	38	46	30	58
7	Vicenza	38	64	47	58
8	Renate	38	49	55	53
9	Arzignano	38	43	38	53
10	Novara	38	48	45	52
11	Pergolettese	38	43	42	51
12	Pro Patria	38	37	43	50
13	Juventus	38	42	48	49
14	Trento	38	40	42	46
15	Vercelli	38	38	47	46
16	Mantova	38	48	62	45
17	Sangiuliano	38	38	46	42
18	Triestina	38	31	45	39
19	AlbinoLeffe	38	43	54	38
20	Piacenza	38	42	59	38

TEMPORADA 2021/2022

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Südtirol	38	49	9	90
2	Padova	38	60	26	85
3	Feralpisalò	38	56	29	69
4	Renate	38	59	43	62
5	Triestina	38	41	41	55
6	Lecco	38	51	42	55
7	Vercelli	38	41	40	55
8	Juventus	38	43	43	54
9	Piacenza	38	44	46	50
10	Pergolettese	38	42	55	46
11	Pro Patria	38	38	45	45
12	AlbinoLeffe	38	42	43	45
13	Virtus	38	35	38	45
14	Fiorenzuola	38	33	48	43
15	Mantova	38	37	42	42
16	Trento	38	31	36	42
17	Pro Sesto	38	33	46	38
18	Seregno	38	41	55	34
19	Giana	38	25	41	34
20	Legnago	38	32	65	30

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 3
Equipo		PJ	GF	GC	Puntos
1	Mestre	34	73	34	80
2	Triestina	34	63	33	72
3	Campodarsego	34	55	42	60
4	Virtus	34	42	30	53
5	Abano Terme	34	46	38	53
6	Belluno	34	40	36	50
7	Arzignano	34	43	34	49
8	Montebelluna	34	46	54	44
9	AC Este	34	33	33	43
10	Union Feltre	34	35	37	43
11	Legnago	34	46	43	41
12	Calvi Noale	34	44	45	40
13	Alto	34	45	55	40
14	Tamai	34	33	45	40
15	Cordenons	34	44	56	39
16	Vigasio	34	42	61	38
17	Vigontina	34	42	62	25
18	Eclisse	34	29	63	23

TEMPORADA 2015/2016

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Venezia	38	89	26	90
2	Campodarsego	38	56	31	79
3	AC Este	38	61	23	76
4	Belluno	38	52	38	67
5	Virtus	38	67	37	63
6	Luparense	38	65	57	58
7	Tamai	38	45	43	53
8	Mestre	38	71	54	51
9	Abano Terme	38	50	47	49
10	Levico	38	54	53	48
11	Calvi Noale	38	40	43	48
12	Dro Calcio	38	35	53	48
13	Union Ripa.	38	50	56	45
14	Fincantieri	38	47	57	43
15	Montebelluna	38	50	62	43
16	Liventina	38	45	62	39
17	Triestina	38	40	57	39
18	Fontanafredd	38	44	62	39
19	Giorgione	38	42	74	38
20	Sacilese	38	26	94	13

TEMPORADA 2014/2015

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Calcio	34	77	30	85
2	Alto	34	63	34	70
3	Sacilese	34	62	31	62
4	Belluno	34	57	38	59
5	Arzignano	34	53	39	56
6	Union Pro	34	46	42	55
7	Clodiense	34	48	47	49
8	Montebelluna	34	45	49	47
9	Union Ripa.	34	45	42	45
10	Fontanafredd	34	50	49	44
11	Legnago	34	50	55	43
12	Tamai	34	45	38	41
13	Giorgione	34	40	50	38
14	Dro Calcio	34	37	50	35
15	Triestina	34	41	51	34
16	Nk Kras Asd	34	41	58	33
17	Mori Santo.	34	31	69	19
18	Mezzocorona	34	20	79	16

TEMPORADA 2013/2014

SERIE D GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Pordenone	34	77	20	85
2	Marano	34	72	24	83
3	Sacilese	34	55	28	66
4	Belluno	34	54	43	59
5	Luparense	34	45	51	50
6	Union Ripa.	34	59	49	49
7	AC Este	34	53	43	48
8	Montebelluna	34	45	46	48
9	Trissino	34	47	49	43
10	Triestina	34	48	45	42
11	Giorgione	34	36	35	39
12	Tamai	34	42	56	39
13	Vittorio	34	42	59	38
14	Fincantieri	34	37	52	34
15	Mezzocorona	34	35	56	33
16	Dro Calcio	34	34	66	31
17	Sanvitese	34	37	55	30
18	Fersina	34	26	67	17

TEMPORADA 2011/2012

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Spezia	36	49	30	65
2	Trapani	36	59	45	63
3	Siracusa	35	46	35	63
4	Virtus	41	48	43	62
5	Cremonese	35	50	30	58
6	Barletta	35	44	39	50
7	Frosinone	36	41	41	49
8	Calcio	37	43	45	49
9	Piacenza	36	43	50	47
10	Südtirol	35	39	35	46
11	Carrarese	37	44	44	46
12	Pergocrema	34	33	46	45
13	Andria	34	37	38	39
14	Triestina	37	50	59	39
15	Prato	35	37	44	38
16	Feralpisalò	34	26	37	38
17	Latina	35	37	46	35
18	Bassano	34	29	48	32

TEMPORADA 2010/2011

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Atalanta	42	61	35	79
2	Siena	42	67	35	77
3	Novara	42	63	38	70
4	Varese	42	51	34	68
5	Padova	42	63	48	62
6	Reggina	42	46	40	61
7	Livorno	42	49	46	59
8	Torino	42	49	48	58
9	Empoli	42	46	39	57
10	Ascoli	42	44	48	56
11	Modena	42	46	51	55
12	Crotone	42	45	50	54
13	Vicenza	42	44	54	54
14	Pescara	42	44	48	53
15	Cittadella	42	50	54	51
16	Sassuolo	42	42	46	51
17	Grosseto	42	43	50	51
18	AlbinoLeffe	42	55	66	49
19	Piacenza	42	50	63	46
20	Triestina	42	34	57	40
21	Calcio	42	39	63	40
22	Frosinone	42	46	64	38

TEMPORADA 2009/2010

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Lecce	42	66	47	75
2	Cesena	42	55	29	74
3	Brescia	42	60	44	72
4	Sassuolo	42	60	42	69
5	Torino	42	53	36	68
6	Cittadella	42	62	43	66
7	Crotone	42	53	50	62
8	Grosseto	42	66	63	61
9	Ascoli	42	57	57	57
10	Empoli	42	66	56	56
11	AlbinoLeffe	42	59	56	55
12	Ancona	42	55	56	54
13	Reggina	42	51	56	54
14	Modena	42	39	47	54
15	Vicenza	42	40	41	53
16	Piacenza	42	40	45	53
17	Frosinone	42	50	67	53
18	Padova	42	44	48	51
19	Triestina	42	41	51	51
20	Mantova	42	46	58	48
21	Gallipoli	42	43	74	40
22	Salernitana	42	40	80	23

TEMPORADA 2008/2009

SERIE B
Equipo		PJ	GF	GC	Puntos
1	SSC Bari	42	65	35	80
2	Parma	42	65	34	76
3	Livorno	42	64	40	68
4	Brescia	42	54	40	67
5	Empoli	42	53	44	67
6	Grosseto	42	64	66	64
7	Sassuolo	42	57	50	60
8	Triestina	42	52	47	59
9	AlbinoLeffe	42	49	49	58
10	Piacenza	42	48	48	55
11	Frosinone	42	48	53	53
12	Vicenza	42	44	41	52
13	Mantova	42	41	46	52
14	Ascoli	42	37	48	52
15	Modena	42	54	63	51
16	Salernitana	42	46	56	51
17	Cittadella	42	42	43	50
18	Rimini	42	43	56	50
19	Ancona	42	54	66	49
20	Pisa SC	42	45	55	48
21	Avellino	42	41	61	42
22	Treviso	42	37	62	36

TEMPORADA 2007/2008

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Chievo	42	77	43	85
2	Bologna	42	58	29	84
3	Lecce	42	70	29	83
4	AlbinoLeffe	42	67	48	78
5	Brescia	42	59	40	72
6	Pisa SC	42	61	44	71
7	Rimini	42	68	46	69
8	Ascoli	42	64	49	62
9	Mantova	42	56	49	60
10	Frosinone	42	63	67	56
11	SSC Bari	42	50	55	55
12	Triestina	42	55	67	51
13	Grosseto	42	47	54	49
14	ACR Messina	42	38	62	49
15	Piacenza	42	43	59	47
16	Modena	42	57	65	46
17	Treviso	42	41	52	45
18	Vicenza	42	43	60	45
19	Avellino	42	42	64	36
20	Ravenna FC	42	48	75	35
21	Spezia	42	45	66	34
22	Cesena	42	37	66	32

TEMPORADA 2006/2007

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Juventus	42	83	30	94
2	Napoli	42	52	29	79
3	Genoa	42	68	44	78
4	Piacenza	42	57	50	68
5	Rimini	42	55	38	67
6	Brescia	42	51	43	67
7	Bologna	42	52	43	65
8	Mantova	42	47	36	64
9	Lecce	42	56	53	58
10	AlbinoLeffe	42	46	48	53
11	SS Arezzo	42	42	46	51
12	Vicenza	42	42	43	50
13	Treviso	42	44	47	50
14	SSC Bari	42	40	46	50
15	Frosinone	42	44	54	50
16	Modena	42	38	46	49
17	Triestina	42	37	48	49
18	Cesena	42	51	66	49
19	Hellas	42	34	46	48
20	Spezia	42	50	61	46
21	Crotone	42	36	67	32
22	Pescara	42	36	77	25

TEMPORADA 2005/2006

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Atalanta	42	61	39	81
2	Catania	42	67	42	78
3	Torino	42	51	31	76
4	Mantova	42	46	35	69
5	Modena	42	59	41	67
6	Cesena	42	66	54	66
7	SS Arezzo	42	45	34	66
8	Bologna	42	55	42	64
9	Crotone	42	56	48	63
10	Brescia	42	54	44	60
11	Piacenza	42	56	52	54
12	Pescara	42	41	50	54
13	SSC Bari	42	43	47	51
14	Triestina	42	44	51	51
15	Hellas	42	42	41	49
16	Vicenza	42	38	49	49
17	Rimini	42	42	49	48
18	AlbinoLeffe	42	38	52	46
19	Avellino	42	42	62	46
20	Ternana	42	36	58	39
21	Cremonese	42	36	60	30
22	Catanzaro	42	26	63	28

TEMPORADA 2004/2005

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Genoa	42	72	44	76
2	Empoli	42	58	36	74
3	Perugia	42	56	34	74
4	Torino	42	49	31	74
5	Treviso	42	58	48	64
6	Modena	42	47	37	62
7	Ascoli	42	51	52	62
8	Hellas	42	60	47	61
9	Ternana	42	51	54	57
10	SSC Bari	42	41	37	56
11	Piacenza	42	44	46	56
12	AlbinoLeffe	42	55	51	55
13	Catania	42	42	44	55
14	Crotone	42	48	45	53
15	SS Arezzo	42	51	52	51
16	Salernitana	42	50	57	51
17	Cesena	42	47	61	50
18	Vicenza	42	59	67	49
19	Triestina	42	43	54	48
20	Pescara	42	43	61	46
21	Venezia	42	33	58	35
22	Catanzaro	42	40	82	26

Competiciones que juega

Grupo 1

Serie C Grupo 1

Pos	Equipos		Pts
1		Mantova	79
2		Padova	74
3		Vicenza	68
4		Triestina	64
5		Atalanta Sub 23	58
6		Legnago Salus	55
7		Giana Erminio	53
8		Pro Vercelli	50
9		Lumezzane	50
10		Trento	48
11		Virtus Verona	47
12		Pro Patria	46
13		AlbinoLeffe	45
14		Renate	45
15		Arzignano Valchiampo	43
16		Pergolettese	42
17		Novara	40
18		Fiorenzuola	38
19		Pro Sesto	32
20		US Alessandria	23

	Ascenso : Mantova
	Playoff Ascenso : Padova, Vicenza
	Siguiente Ronda : Triestina, Atalanta Sub 23, Legnago Salus, Giana Erminio, Pro Vercelli, Lumezzane, Trento
	Posible siguiente ronda : Virtus Verona
	Playoff Descenso : Pergolettese, Novara, Fiorenzuola, Pro Sesto
	Descenso : US Alessandria

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie C

USO DE MEMORIA

8,543,472 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.6268
Total Execution Time	0.6287

CADENA URL

/historico/Us-Triestina-Calcio

GET DATOS

$_GET['/historico/Us-Triestina-Calcio']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0291	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 = 72299
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2635 AND type_rel = 2
0.0146	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2635 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147	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 (676397,1022041,1021262) ORDER BY n.cover_points DESC, update_date DESC
0.0157	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 = '2635' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152	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=2635 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (74153,72299,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.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 72299 AND teamId = 2635
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 2635
0.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2635
0.0162	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 = 72299 WHERE rp.league_id = 72299 AND rp.teamId = 2635 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.0160	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 = 72299 WHERE rp.league_id = 72299 AND rp.teamId = 2635 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157	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 = 72299 WHERE rp.league_id = 72299 AND rp.teamId = 2635 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155	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 = 2635 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 63824 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.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* `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.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* `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.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* `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.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* `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.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* `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 = 33451 AND t.round = 34 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* `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 = 15651 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* `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 = 14783 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 4816 AND t.round = 34 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* `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 = 24671 AND t.round = 34 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* `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 = 1566 AND t.round = 34 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* `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 = 1188 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 444 AND t.round = 42 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* `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 = 506 AND t.round = 42 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* `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 = 507 AND t.round = 42 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* `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 = 508 AND t.round = 42 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* `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 = 509 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Triestina

Triestina

Selecciona un equipo

Competiciones que juega

Serie C Grupo 1

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie C