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

Pisa SC

Entrenador: Alberto Aquilani

Temporada 2020/2021

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 C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Piacenza	38	59	34	77
2	Virtus	37	58	26	75
3	Pisa SC	38	50	29	72
4	Vercelli	38	48	29	67
5	Siena	38	59	41	66
6	Carrarese	38	70	46	65
7	SS Arezzo	38	50	34	64
8	Pro Patria	38	44	38	57
9	Novara	37	44	36	50
10	Cuneo	38	30	36	47
11	Pontedera	37	33	39	45
12	Alessandria	38	36	43	45
13	Juventus	37	41	48	42
14	Arzachena	38	31	54	40
15	Olbia Calcio	38	40	50	38
16	Lucchese	38	46	40	37
17	Pistoiese	38	39	50	36
18	Gozzano	38	35	47	33
19	Albissola	38	34	59	31
20	Piacenza	34	17	85	15

TEMPORADA 2017/2018

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Livorno	36	64	38	68
2	Siena	36	41	30	67
3	Pisa SC	36	44	30	61
4	AC Monza	36	40	26	58
5	Viterbese	36	46	35	58
6	Alessandria	36	54	37	56
7	Carrarese	36	57	47	55
8	Piacenza	36	43	41	52
9	Pistoiese	36	44	47	46
10	Giana	36	59	56	46
11	Pontedera	36	38	49	46
12	Lucchese	36	35	42	44
13	SS Arezzo	36	39	35	43
14	Olbia Calcio	36	39	52	43
15	Piacenza	36	38	43	41
16	Arzachena	36	49	53	39
17	Follonica	36	35	51	36
18	Cuneo	36	24	47	32
19	Prato	36	32	62	26

TEMPORADA 2016/2017

SERIE B
Equipo		PJ	GF	GC	Puntos
1	SPAL	42	66	39	78
2	Hellas	42	64	40	74
3	Frosinone	42	57	42	74
4	Perugia	42	54	40	65
5	Benevento	42	56	42	65
6	Cittadella	42	60	54	63
7	AC Carpi	42	41	40	62
8	Spezia	42	38	34	60
9	Novara	42	48	50	56
10	Salernitana	42	44	44	54
11	Virtus	42	54	51	54
12	SSC Bari	42	39	44	53
13	Cesena	42	51	48	53
14	Avellino	42	40	55	50
15	Brescia	42	49	58	50
16	Ascoli	42	44	49	49
17	Vercelli	42	35	45	49
18	Ternana	42	42	53	49
19	Trapani	42	45	55	44
20	Vicenza	42	33	52	41
21	Pisa SC	42	23	36	35
22	Latina	42	38	50	32

TEMPORADA 2015/2016

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	SPAL	34	59	25	71
2	Pisa SC	34	42	26	63
3	Maceratese	34	47	31	58
4	Ancona	34	34	29	53
5	Carrarese	34	49	37	51
6	Teramo	34	42	40	46
7	Siena	34	34	38	46
8	Pontedera	34	43	38	45
9	Santarcangel	34	41	38	45
10	SS Arezzo	34	33	31	43
11	L'Aquila	34	34	41	40
12	Tuttocuoio	34	27	34	40
13	Lucchese	34	39	43	39
14	Pistoiese	34	29	35	39
15	Rimini	34	29	39	38
16	Prato	34	32	43	37
17	Savona	34	27	44	36
18	Lupa Roma	34	26	55	25

TEMPORADA 2014/2015

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Teramo	38	62	32	75
2	Ascoli	38	61	37	71
3	Reggiana	38	53	31	65
4	SPAL	38	46	31	62
5	Pisa SC	38	44	35	59
6	Ancona	38	46	38	57
7	L'Aquila	38	40	36	54
8	Tuttocuoio	38	45	58	50
9	Pontedera	38	41	41	48
10	Lucchese	38	43	45	48
11	Grosseto	38	43	41	46
12	Carrarese	38	47	46	44
13	Santarcangel	38	35	39	44
14	Prato	38	41	48	44
15	Pistoiese	38	45	62	44
16	Gubbio 1910	38	46	51	43
17	Forli	38	41	55	43
18	Savona	38	36	59	40
19	Piacenza	38	34	50	37
20	Marino	38	42	56	36

TEMPORADA 2013/2014

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Perugia	32	52	28	66
2	Frosinone	32	53	26	62
3	Lecce	32	51	30	61
4	Catanzaro	32	34	17	55
5	L'Aquila	32	43	28	53
6	Pisa SC	32	41	27	52
7	Benevento	32	58	36	51
8	Pontedera	32	53	46	49
9	Salernitana	32	44	33	46
10	Prato	32	38	40	43
11	Grosseto	32	34	36	42
12	Gubbio 1910	32	36	44	40
13	Ascoli	32	32	45	31
14	Viareggio	32	28	47	28
15	Barletta	32	22	51	25
16	Paganese	32	26	53	20
17	Nocerina	32	18	76	14

TEMPORADA 2012/2013

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Avellino	30	50	27	60
2	Perugia	30	48	29	58
3	Nocerina	30	48	32	53
4	Latina	30	41	28	53
5	Pisa SC	30	43	33	52
6	Benevento	30	35	28	43
7	Frosinone	30	36	30	40
8	Gubbio 1910	30	32	39	40
9	Paganese	30	29	30	39
10	Catanzaro	30	37	48	37
11	Viareggio	30	36	45	36
12	Prato	30	30	37	33
13	Andria	30	23	30	32
14	Barletta	30	27	39	27
15	Sorrento	30	24	44	23
16	Carrarese	30	31	51	21

TEMPORADA 2011/2012

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Taranto	34	41	16	70
2	Ternana	34	40	19	65
3	AC Carpi	34	46	26	61
4	Sorrento	34	43	26	60
5	Benevento	34	46	34	58
6	Vercelli	34	40	19	57
7	Pisa SC	34	37	35	46
8	Reggiana	34	36	42	43
9	Lumezzane	34	28	35	43
10	SPAL	34	32	36	42
11	Calcio	34	33	38	42
12	Avellino	34	39	46	40
13	Como	34	39	47	39
14	Tritium	34	26	40	37
15	Viareggio	34	31	47	36
16	Pavia	34	37	50	33
17	AC Monza	34	27	42	33
18	Foligno	34	24	47	25

TEMPORADA 2010/2011

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Nocerina	34	51	30	72
2	Benevento	34	53	40	61
3	Atlético	34	53	33	57
4	Juve Stabia	34	43	35	55
5	Taranto	34	36	28	55
6	Calcio	34	67	58	47
7	Lucchese	34	42	38	44
8	Cosenza	34	36	38	44
9	Virtus	34	28	31	44
10	Siracusa	34	32	38	44
11	Pisa SC	34	39	40	43
12	Barletta	34	32	38	40
13	Gela	34	31	42	40
14	Andria	34	31	37	39
15	Ternana	34	30	46	38
16	Foligno	34	36	45	35
17	Cavese 1919	34	31	41	35
18	Viareggio	34	30	43	31

TEMPORADA 2009/2010

SERIE D GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Pisa SC	38	66	24	82
2	AC Carpi	38	59	35	65
3	Fossombrone	38	49	32	65
4	AC Chioggia	38	63	40	61
5	Santarcangel	38	48	38	61
6	Rosignano	38	45	36	59
7	US Russi	38	53	38	57
8	Virtus	38	43	38	56
9	Rovigo	38	51	44	55
10	Borgo	38	39	45	50
11	ASD Cecina	38	33	37	48
12	Mezzolara	38	35	41	46
13	Pontedera	38	43	44	45
14	Castellana	38	42	49	45
15	Ponsacco	38	39	48	45
16	Riccione	38	46	56	42
17	Castel	38	34	50	36
18	Adriese	38	34	64	34
19	Dorando	38	38	66	29
20	Castellarano	38	36	71	24

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 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 C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Napoli	34	48	20	68
2	Frosinone	34	43	37	55
3	Sassari	34	44	32	53
4	Grosseto	34	43	32	51
5	Sangiovannes	34	37	34	51
6	Perugia	34	35	37	50
7	Lucchese	34	33	27	49
8	Martina	34	41	39	47
9	Gela	34	31	35	43
10	Pistoiese	34	28	24	42
11	Manfredonia	34	36	38	42
12	Virtus	34	36	35	41
13	Calcio	34	32	32	40
14	Acireale	34	29	34	39
15	Pisa SC	34	31	43	39
16	Massese	34	21	36	38
17	Juve Stabia	34	25	36	33
18	Chieti	34	24	46	28

TEMPORADA 2004/2005

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2003/2004

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SS Arezzo	34	51	27	67
2	Lumezzane	34	42	33	59
3	Cesena	34	47	34	58
4	Rimini	34	42	33	53
5	Lucchese	34	39	34	52
6	Spezia	34	35	33	51
7	Pisa SC	34	44	37	49
8	Padova	34	36	27	48
9	SPAL	34	31	28	47
10	Pistoiese	34	35	36	44
11	Cittadella	34	34	35	42
12	Novara	34	37	41	40
13	Sassari	34	21	28	38
14	Pro Patria	34	28	38	38
15	Reggiana	34	32	45	37
16	Varese	34	29	43	35
17	Prato	34	33	46	34
18	Pavia	34	29	47	32

TEMPORADA 2002/2003

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Treviso	34	56	33	65
2	AlbinoLeffe	34	62	36	63
3	Cesena	34	49	29	59
4	Pisa SC	34	40	27	57
5	Padova	34	50	45	51
6	Spezia	34	37	32	48
7	Cittadella	34	39	39	47
8	Prato	34	39	42	46
9	Lumezzane	34	39	47	45
10	Pistoiese	34	30	37	44
11	Pro Patria	34	31	39	43
12	Reggiana	34	45	45	42
13	SPAL	34	34	35	42
14	Lucchese	34	28	30	42
15	Varese	34	35	48	30
16	Carrarese	34	31	45	30
17	AlzanoCene	34	33	52	29
18	SS Arezzo	34	33	50	24

TEMPORADA 2001/2002

SERIE C GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Livorno	34	62	21	73
2	Spezia	34	53	20	70
3	Treviso	34	36	24	56
4	Lucchese	34	40	29	56
5	Triestina	34	41	33	53
6	Varese	34	38	38	50
7	Lumezzane	34	45	40	49
8	Cesena	34	34	39	45
9	Padova	34	43	43	44
10	Lecco	34	46	40	42
11	Pisa SC	34	39	45	42
12	SPAL	34	44	46	41
13	AlbinoLeffe	34	33	35	41
14	Carrarese	34	33	50	37
15	Reggiana	34	36	55	37
16	SS Arezzo	34	37	58	30
17	Alzano	34	27	51	30
18	AC Monza	34	27	47	24

Competiciones que juega

Serie B

Pos	Equipos		Pts
1		Empoli	73
2		Salernitana	69
3		AC Monza	64
4		Lecce	62
5		Venezia	59
6		Cittadella	57
7		Brescia	56
8		Chievo	56
9		SPAL	56
10		Frosinone	50
11		Reggina	50
12		Vicenza	48
13		Cremonese	48
14		Pisa SC	48
15		Pordenone	45
16		Ascoli	44
17		Cosenza	35
18		Reggiana	34
19		Pescara	32
20		Virtus Entella	23

	Ascenso : Empoli, Salernitana
	Playoff Ascenso : AC Monza, Lecce, Venezia, Cittadella, Brescia, Chievo
	Descenso : Cosenza, Reggiana, Pescara, Virtus Entella

RIVALES EN Coppa Italia

RIVALES EN Serie B

USO DE MEMORIA

8,292,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.1757
Total Execution Time	0.1772

CADENA URL

/historico/Pisa-Calcio/2021

GET DATOS

$_GET['/historico/Pisa-Calcio/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0022	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1973 AND type_rel = 2
0.0029	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1973 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0033	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 (7569,57953,62782,79670,95593) ORDER BY n.cover_points DESC, update_date DESC
0.0072	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 = '1973' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0030	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 = 58676 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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 = 58563 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0043	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=1973 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (67494,63341,62807,62741) 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.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 62741 AND teamId = 1973
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 63341 AND teamId = 1973
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 67494 AND teamId = 1973
0.0162	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 1973
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* `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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024	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 = '1973' 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 = '1973' 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 = '1973' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0056	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 = 58563 WHERE rp.league_id = 58563 AND rp.teamId = 1973 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.0041	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 = 58563 WHERE rp.league_id = 58563 AND rp.teamId = 1973 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 events2021 e ON e.player_id = p.id AND e.league_id = 58563 WHERE rp.league_id = 58563 AND rp.teamId = 1973 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038	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 = 1973 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* `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.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 = 44231 AND t.round = 38 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* `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 = 38929 AND t.round = 38 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* `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 = 33799 AND t.round = 42 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* `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 = 15398 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* `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 = 4073 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* `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 = 2743 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* `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 = 2084 AND t.round = 30 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* `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 = 1565 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 = 1218 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* `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 = 24712 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* `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.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* `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 = 539 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* `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 = 542 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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
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* `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 = 584 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* `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 = 586 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* `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 = 588 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Pisa SC

Pisa SC

Selecciona un equipo

Competiciones que juega

Serie B

RIVALES EN Coppa Italia

RIVALES EN Serie B