Información
  • Nombre del equipo Spezia
  • Nombre completo AC Spezia Calcio
  • Nombre corto SPE
  • País Italia
  • Ciudad La Spezia
  • Entrenador Luca D'Angelo
  • URL del equipo en RF //m.resultados-futbol.com/Asd-Spezia
Otros Datos
  • Año de Fundación 1906
Internet
Información sobre el estadio
  • Nombre del estadio Stadio Alberto Picco
  • Capacidad 10336
  • Dirección Via Nicolò Fieschi, 18
  • Teléfono 0187711322
  • Fax 0187 709679
Stadio Alberto Picco
Partidos del Spezia Ir al LIVESCORE
10 May 24  en 1 mes Spezia
-
Venezia 1
04 May 24  en 1 mes Cosenza
-
Spezia 1
01 May 24  en 1 mes Spezia
15:00
Palermo FC 0
27 Abr 24  en 1 mes Brescia
14:00
Spezia 1
20 Abr 24  en 23 días Spezia
16:15
Sampdoria 1
13 Abr 24  en 16 días Parma
16:15
Spezia 1
06 Abr 24  en 9 días Spezia
14:00
Lecco 1
01 Abr 24  en 4 días Spezia
15:00
Ascoli 1
16 Mar 24  Finalizado Tarjeta RojaReggiana
0 - 0
Spezia 4
09 Mar 24  Finalizado Spezia
2 - 1
FC Südtirol 4
03 Mar 24  Finalizado SSC Bari
1 - 1
Spezia 7
28 Feb 24  Finalizado Spezia
0 - 2
Feralpisalò 89
25 Feb 24  Finalizado Modena
0 - 0
SpeziaTarjeta Roja 22
17 Feb 24  Finalizado Spezia
4 - 2
CittadellaTarjeta RojaTarjeta Roja 6
11 Feb 24  Finalizado Ternana Calcio
1 - 1
Spezia 11
03 Feb 24  Finalizado Spezia
1 - 1
Catanzaro 4
27 Ene 24  Finalizado Pisa SC
2 - 3
Spezia 6
20 Ene 24  Finalizado Spezia
0 - 1
Cremonese 29
13 Ene 24  Finalizado Como
4 - 0
Spezia 11
26 Dic 23  Finalizado Spezia
1 - 1
Modena 31
23 Dic 23  Finalizado Cittadella
4 - 1
Spezia 11
15 Dic 23  Finalizado Spezia
1 - 0
SSC Bari 50
09 Dic 23  Finalizado Ascoli
1 - 2
Spezia 3
02 Dic 23  Finalizado Spezia
0 - 1
Parma 83

Plantilla del Spezia Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
12 17 it - - - - -
28 22 it 189 75 - - -
1 33 nl 189 87 - - -
40 22 ba 192 - - - -
Defensa
13 28 pl 187 81 2 - 1
37 27 cz 185 79 1 - 7
26 19 al 187 - - - -
43 25 gr 188 78 - 1 8
5 24 ar 186 74 - - -
33 22 ge 191 - 1 1 3
23 27 de 189 83 1 - 4
14 28 it 186 75 - - 1
4 26 pt 183 70 - - -
77 21 it 192 - 1 1 6
2 25 pl 195 91 - - -
55 25 bg 191 79 1 - 3
3 23 hr 188 - - - 2
Centrocampista
8 28 hu 178 74 - 1 4
25 28 it 180 60 - - 4
29 26 it 183 75 - - 10
97 26 pl 180 75 1 - -
21 21 it 182 - - - -
15 20 it 189 85 - - 2
72 18 pl 180 67 - - -
36 19 it 178 - - - 1
80 21 it 188 - 2 - 7
10 23 it 178 70 1 - 7
11 20 si 184 65 - - -
Delantero
16 32 it 186 70 2 - 4
99 27 it 168 64 7 - 3
20 22 it 188 68 2 - -
24 23 it 189 64 4 - 3
9 18 it 189 - 2 - 3
7 24 it 183 65 - - 5
Noticias del Spezia
Ver últimas noticias

De las Cuevas será operado del corazón

El centrocampista español Miguel Ángel de las Cuevas Barberá, que milita en La Spezia, de la Serie B italiana de fútbol, deberá ser sometido a una "pequeña intervención quirúrgica" tras ser verificado que sufre una "anomalía cardíaca", según ha informado su club.

"Estoy contento, porque dejo el Eibar en Primera"

El futbolista Jon Errasti, que se marcha del Eibar con la carta de libertad para fichar por el Spezia Calcio, un equipo de la segunda división italiana. ha afirmado este lunes que está "contento", porque deja el club guipuzcoano "en Primera División y como líder".

Jon Errasti deja el Eibar y ficha por el Spezia italiano

Jon Errasti, uno de los capitanes del Eibar, deja el club guipuzcoano de la Liga BBVA para fichar por el Spezia Calcio, un equipo de la Segunda división italiana.

Nenê da el salto definitivo del Hellas Verona al Spezia

Tras fichar a Nenê hace un año, el Hellas Verona ha decidido ahora desprenderse del jugador. Así, el brasileño seguirá en las filas del Spezia, donde ya jugó en calidad de cedido la pasada campaña.

Sergio Postigo reforzará al Spezia y Chumbi, al Llagostera

Postigo competirá en la Serie B italiana, mientras que Chumbi continuará jugando en Segunda División.



Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,763,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.1620
Total Execution Time  0.1647
  CADENA URL  
/asd-spezia
  GET DATOS  
$_GET['/asd-spezia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0018  SELECT type FROM routes WHERE alias = 'asd-spezia'
0.0034  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 = 'asd-spezia' AND l.year = 2024 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.0019  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=2817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=2817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=2817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=2817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2817 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2817 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (3281,3523,9448,9569,14539) ORDER BY n.cover_points DESC, update_date DESC
0.0035  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 = '2817' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0039  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 = '2817' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0033  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 2817 or c.datateam2 = 2817) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0026  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 2817 or c.datateam2 = 2817) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0023  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 2817 or c.datateam2 = 2817) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0028  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=2817 AND l.year in (2023,2024,2025) 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 (73270,72045,71936,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 67673 AND teamId = 2817
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72045 AND teamId = 2817
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71936 AND teamId = 2817
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73270 AND teamId = 2817
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2817
0.0022  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 = '2817' 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 = '2817' 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 = '2817' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040  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 = 2817 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.0036  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 = 2817 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 2817 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 2817 AND rp.league_id = 72045 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0023  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6582474 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6582474
0.0027  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582474 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0026  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582474 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0024  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582474 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0024   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582474 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0027  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582474 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC