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

Cremonese

Entrenador: Giovanni Stroppa

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Parma	35	63	32	73
2	Como	35	55	38	68
3	Venezia	35	64	40	67
4	Cremonese	35	44	30	60
5	Catanzaro	35	55	44	57
6	Palermo FC	35	59	50	52
7	Brescia	35	38	35	47
8	Sampdoria	35	48	49	46
9	Pisa SC	35	47	48	45
10	Cittadella	35	38	41	45
11	Südtirol	35	40	42	43
12	Modena	35	38	44	43
13	Reggiana	35	36	43	43
14	Cosenza	35	43	39	42
15	Ascoli	35	34	38	37
16	Ternana	35	38	46	37
17	Spezia	35	31	46	37
18	SSC Bari	35	34	47	36
19	Feralpisalò	35	41	60	32
20	Lecco	35	32	66	26

TEMPORADA 2022/2023

SERIE A
Equipo		PJ	GF	GC	Puntos
1	Napoli	38	77	28	90
2	Lazio	38	60	30	74
3	Inter	38	71	42	72
4	Milan	38	64	43	70
5	Atalanta	38	66	48	64
6	Roma	38	50	38	63
7	Juventus	38	56	33	62
8	Fiorentina	38	53	43	56
9	Bologna	38	53	49	54
10	Torino	38	42	41	53
11	AC Monza	38	48	52	52
12	Udinese	38	47	48	46
13	Sassuolo	38	47	61	45
14	Empoli	38	37	49	43
15	Salernitana	38	48	62	42
16	Lecce	38	33	46	36
17	Spezia	38	31	62	31
18	Hellas	38	31	59	31
19	Cremonese	38	36	69	27
20	Sampdoria	38	24	71	19

TEMPORADA 2021/2022

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Lecce	38	59	31	71
2	Cremonese	38	57	39	69
3	Pisa SC	38	48	35	67
4	AC Monza	38	60	38	67
5	Brescia	38	55	35	66
6	Ascoli	38	52	42	65
7	Benevento	38	62	39	63
8	Perugia	38	40	32	58
9	Frosinone	38	58	45	58
10	Ternana	38	58	61	54
11	Cittadella	38	38	36	52
12	Parma	38	48	43	49
13	Como	38	49	54	47
14	Reggina	38	31	49	46
15	SPAL	38	46	54	42
16	Cosenza	38	36	59	35
17	Vicenza	38	38	59	34
18	Alessandria	38	37	59	34
19	Crotone	38	41	61	26
20	Pordenone	38	29	71	18

TEMPORADA 2020/2021

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Empoli	38	68	35	73
2	Salernitana	38	46	34	69
3	AC Monza	38	51	33	64
4	Lecce	38	68	47	62
5	Venezia	38	53	39	59
6	Cittadella	38	48	35	57
7	Brescia	38	61	53	56
8	Chievo	38	50	37	56
9	SPAL	38	44	42	56
10	Frosinone	38	38	42	50
11	Reggina	38	42	45	50
12	Vicenza	38	48	53	48
13	Cremonese	38	46	44	48
14	Pisa SC	38	54	59	48
15	Pordenone	38	40	39	45
16	Ascoli	38	37	48	44
17	Cosenza	38	29	47	35
18	Reggiana	38	31	57	34
19	Pescara	38	29	60	32
20	Virtus	38	30	64	23

TEMPORADA 2019/2020

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Benevento	38	67	27	86
2	Crotone	38	63	40	68
3	Spezia	38	54	40	61
4	Pordenone	38	48	46	58
5	Cittadella	38	49	49	58
6	Chievo	38	48	38	56
7	Empoli	38	47	48	54
8	Frosinone	38	41	38	54
9	Pisa SC	38	49	45	54
10	Salernitana	38	53	50	52
11	Venezia	38	37	40	50
12	Cremonese	38	42	43	49
13	Virtus	38	46	50	48
14	Ascoli	38	50	58	46
15	Cosenza	38	50	49	46
16	Perugia	38	38	49	45
17	Pescara	38	48	55	45
18	Trapani	38	48	60	44
19	Juve Stabia	38	47	63	41
20	Livorno	38	30	67	21

TEMPORADA 2018/2019

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Brescia	36	69	42	67
2	Lecce	36	66	45	66
3	Benevento	36	61	45	60
4	Pescara	36	50	46	55
5	Hellas	36	49	46	52
6	Cittadella	36	49	38	51
7	Spezia	36	53	46	51
8	Perugia	36	49	49	50
9	Cremonese	36	37	33	49
10	Cosenza	36	34	42	46
11	Palermo FC	36	57	38	43
12	Crotone	36	40	42	43
13	Ascoli	36	40	56	43
14	Livorno	36	38	51	39
15	Venezia	36	35	46	38
16	Salernitana	36	41	57	38
17	Calcio	36	44	49	37
18	Padova	36	36	49	31
19	AC Carpi	36	39	67	29

TEMPORADA 2017/2018

SERIE B
Equipo		PJ	GF	GC	Puntos
1	Empoli	42	88	49	85
2	Parma	42	57	37	72
3	Frosinone	42	65	47	72
4	Palermo FC	42	59	39	71
5	Venezia	42	56	42	67
6	Cittadella	42	61	48	66
7	SSC Bari	42	59	48	65
8	Perugia	42	67	58	60
9	Calcio	42	66	68	58
10	Spezia	42	46	45	53
11	AC Carpi	42	32	46	52
12	Salernitana	42	51	58	51
13	Cesena	42	55	61	50
14	Cremonese	42	48	47	48
15	Avellino	42	49	60	48
16	Brescia	42	41	52	48
17	Pescara	42	50	64	48
18	Ascoli	42	40	60	46
19	Virtus	42	41	54	44
20	Novara	42	42	52	44
21	Vercelli	42	47	70	40
22	Ternana	42	62	77	37

TEMPORADA 2016/2017

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Alessandria	38	64	33	78
2	Cremonese	38	68	40	78
3	Livorno	38	51	30	69
4	SS Arezzo	38	50	38	65
5	Giana	38	56	43	63
6	Piacenza	38	54	40	59
7	Como	38	55	49	59
8	Viterbese	38	43	42	54
9	Lucchese	38	47	39	51
10	Renate	38	36	36	51
11	Piacenza	38	40	42	51
12	Siena	38	45	49	45
13	Pistoiese	38	42	43	44
14	Pontedera	38	38	50	43
15	Olbia Calcio	38	43	59	42
16	Prato	38	34	57	40
17	Carrarese	38	44	54	39
18	Tuttocuoio	38	37	53	38
19	Lupa Roma	38	28	48	33
20	Racing Roma	38	38	68	30

TEMPORADA 2015/2016

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cittadella	34	57	35	76
2	Pordenone	34	52	30	65
3	Bassano	34	45	31	62
4	Alessandria	34	47	31	57
5	Padova	34	46	30	54
6	Cremonese	34	40	33	53
7	Reggiana	34	40	25	52
8	Pavia	34	48	36	51
9	Feralpisalò	34	50	43	50
10	Südtirol	34	34	38	44
11	Renate	34	26	38	43
12	Giana	34	33	36	42
13	Lumezzane	34	37	42	42
14	Piacenza	34	30	35	39
15	Cuneo	34	31	41	34
16	Mantova	34	27	39	34
17	AlbinoLeffe	34	23	57	20
18	Pro Patria	34	15	61	10

TEMPORADA 2014/2015

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Novara	38	58	30	77
2	Bassano	38	57	37	74
3	Pavia	38	58	43	68
4	Como	38	48	33	67
5	Alessandria	38	51	31	65
6	Feralpisalò	38	43	41	56
7	Real Vicenza	38	44	38	52
8	Cremonese	38	45	44	50
9	Venezia	38	47	44	49
10	SS Arezzo	38	35	36	49
11	Südtirol	38	40	41	47
12	Sassari	38	35	38	47
13	Mantova	38	37	34	46
14	AC Monza	38	37	38	45
15	Giana	38	32	39	45
16	Renate	38	35	49	45
17	Pro Patria	38	45	65	38
18	Lumezzane	38	31	50	35
19	Pordenone	38	30	53	34
20	AlbinoLeffe	38	27	51	32

TEMPORADA 2013/2014

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Virtus	30	42	24	58
2	Vercelli	30	34	16	57
3	Vicenza	30	44	31	51
4	Südtirol	30	45	38	49
5	Cremonese	30	37	29	47
6	Savona	30	43	41	44
7	AlbinoLeffe	30	42	40	43
8	Como	30	37	32	42
9	Venezia	30	40	38	41
10	Feralpisalò	30	41	42	41
11	Carrarese	30	35	41	36
12	Pro Patria	30	25	33	33
13	Reggiana	30	30	36	32
14	Lumezzane	30	31	42	29
15	Marino	30	22	47	24
16	Pavia	30	23	41	23

TEMPORADA 2012/2013

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Trapani	32	60	31	64
2	Lecce	32	56	34	61
3	AC Carpi	32	38	30	51
4	Virtus	32	48	36	50
5	Südtirol	32	43	33	50
6	Cremonese	32	45	27	46
7	AlbinoLeffe	32	44	27	43
8	Lumezzane	32	39	38	43
9	Marino	32	41	43	43
10	Feralpisalò	32	36	44	43
11	Pavia	32	29	35	40
12	Como	32	44	50	38
13	Calcio	32	30	36	36
14	Cuneo	32	27	32	35
15	Reggiana	32	28	51	29
16	Treviso	32	28	54	20
17	Tritium	32	23	58	20

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 C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Gubbio 1910	34	48	31	66
2	Salernitana	34	49	39	59
3	Sorrento	34	61	43	58
4	Alessandria	34	40	28	57
5	Hellas	34	42	30	50
6	Spezia	34	38	33	48
7	Lumezzane	34	34	34	47
8	Como	34	41	40	45
9	Reggiana	34	36	37	45
10	SPAL	34	39	37	44
11	Cremonese	34	37	38	42
12	Bassano	34	26	29	42
13	Ravenna FC	34	34	41	42
14	Pavia	34	34	45	39
15	Pergocrema	34	30	35	36
16	AC Monza	34	35	50	32
17	Südtirol	34	28	43	32
18	Paganese	34	17	36	32

TEMPORADA 2009/2010

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Novara	34	52	24	67
2	Varese	34	53	34	62
3	SS Arezzo	34	54	35	61
4	Cremonese	34	62	47	61
5	Benevento	34	50	37	56
6	Lumezzane	34	45	38	52
7	AS Figline	34	45	44	46
8	Alessandria	34	35	46	43
9	Perugia	34	31	38	42
10	Sorrento	34	44	45	41
11	AC Monza	34	37	45	41
12	Como	34	27	34	40
13	Foligno	34	53	56	39
14	Viareggio	34	29	39	38
15	Pergocrema	34	35	44	36
16	Pro Patria	34	37	49	35
17	Paganese	34	33	48	33
18	Lecco	34	34	53	31

TEMPORADA 2008/2009

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cesena	34	41	25	60
2	Pro Patria	34	50	27	58
3	Ravenna FC	34	48	36	56
4	Padova	34	37	31	54
5	Reggiana	34	34	33	54
6	SPAL	34	38	30	53
7	Hellas	34	38	32	48
8	Novara	34	36	36	46
9	Lumezzane	34	37	35	45
10	Pergocrema	34	28	28	44
11	Cremonese	34	36	36	43
12	Calcio	34	33	39	43
13	AC Monza	34	41	48	38
14	Pro Sesto	34	34	47	38
15	Lecco	34	29	34	35
16	Venezia	34	35	41	35
17	Sambenedette	34	22	36	32
18	AC Legnano	34	31	54	30

TEMPORADA 2007/2008

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sassuolo	34	46	32	63
2	Cremonese	34	50	36	60
3	Cittadella	34	52	34	58
4	Foligno	34	38	30	57
5	Calcio	34	47	34	56
6	Padova	34	57	37	55
7	AC Legnano	34	42	34	48
8	AC Monza	34	38	35	46
9	Novara	34	44	52	46
10	Venezia	34	37	40	44
11	Pro Sesto	34	42	45	43
12	Cavese 1919	34	41	42	42
13	Ternana	34	33	39	41
14	Pro Patria	34	33	35	38
15	Lecco	34	28	45	33
16	Paganese	34	26	41	32
17	Hellas	34	24	41	31
18	Manfredonia	34	24	50	31

TEMPORADA 2006/2007

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Grosseto	34	46	27	62
2	Sassuolo	34	42	27	61
3	Pisa SC	34	32	20	58
4	Venezia	34	41	29	54
5	Cittadella	34	38	26	54
6	AC Monza	34	42	32	54
7	Padova	34	34	24	50
8	Lucchese	34	44	32	45
9	Pistoiese	34	33	29	43
10	Pro Sesto	34	24	28	41
11	Novara	34	32	37	41
12	Massese	34	32	39	41
13	Pro Patria	34	34	44	41
14	Cremonese	34	33	43	41
15	Sangiovannes	34	41	51	36
16	Pizzighetton	34	24	41	33
17	Ivrea Calcio	34	25	43	31
18	Pavia	34	29	54	26

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 C GRUPO 1
Equipo		PJ	GF	GC	Puntos

Competiciones que juega

Serie B

Pos	Equipos		Pts
1		Parma	73
2		Como	68
3		Venezia	67
4		Cremonese	60
5		Catanzaro	57
6		Palermo FC	52
7		Brescia	47
8		Sampdoria	46
9		Pisa SC	45
10		Cittadella	45
11		FC Südtirol	43
12		Modena	43
13		Reggiana	43
14		Cosenza	42
15		Ascoli	37
16		Ternana Calcio	37
17		Spezia	37
18		SSC Bari	36
19		Feralpisalò	32
20		Lecco	26

	Ascenso : Parma, Como
	Playoff Ascenso : Venezia, Cremonese, Catanzaro, Palermo FC, Brescia, Sampdoria
	Playoff Descenso : Ternana Calcio, Spezia
	Descenso : SSC Bari, Feralpisalò, Lecco

RIVALES EN Coppa Italia

RIVALES EN Serie B

USO DE MEMORIA

8,254,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1536
Total Execution Time	0.1549

CADENA URL

/historico/Us-Cremonese

GET DATOS

$_GET['/historico/Us-Cremonese']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2625 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2625 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (261391,281510,486088,678080,727786) ORDER BY n.cover_points DESC, update_date DESC
0.0032	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 = '2625' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027	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 = '2625' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72045 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029	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=2625 AND l.year in (2023,2024,2025) 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 (73270,72045,71432,67673) 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.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 67673 AND teamId = 2625
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 72045 AND teamId = 2625
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 73270 AND teamId = 2625
0.0038	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2625
0.0041	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 = 72045 AND t.round = 35 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 = '2625' 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 = '2625' 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 = '2625' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0042	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 = 72045 WHERE rp.league_id = 72045 AND rp.teamId = 2625 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.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 = 72045 WHERE rp.league_id = 72045 AND rp.teamId = 2625 AND (e.action = 4 or e.action = 5) 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 = 72045 WHERE rp.league_id = 72045 AND rp.teamId = 2625 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 2625 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72045 AND t.round = 35 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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 = 62741 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.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* `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 = 58563 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 = 49921 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.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 = 38719 AND t.round = 42 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* `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 = 33443 AND t.round = 38 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* `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 = 15397 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 4072 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* `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 = 2744 AND t.round = 30 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* `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 = 2083 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* `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.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* `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 = 1217 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 1043 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 = 445 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* `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 = 537 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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.0019	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 = 582 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Cremonese

Cremonese

Selecciona un equipo

Competiciones que juega

Serie B

RIVALES EN Coppa Italia

RIVALES EN Serie B