4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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 14 días Spezia
20:30
Venezia 1
05 May 24  en 8 días Cosenza
15:00
Spezia 1
01 May 24  en 4 días Spezia
15:00
Palermo FC 0
27 Abr 24  en 22 h Brescia
14:00
Spezia 1
20 Abr 24  Finalizado Spezia
0 - 0
Sampdoria 32
13 Abr 24  Finalizado Parma
2 - 0
Spezia 5
06 Abr 24  Finalizado Spezia
1 - 1
LeccoTarjeta Roja 18
01 Abr 24  Finalizado Spezia
2 - 1
Ascoli 6
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

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 - 8
26 19 al 187 - - - -
43 25 gr 188 78 - 1 8
5 24 ar 186 74 - - 1
33 23 ge 191 - 1 1 3
23 27 de 189 83 1 - 4
14 28 it 186 75 1 - 1
4 26 pt 183 70 - - -
77 21 it 192 - 1 1 6
2 25 pl 195 91 - - -
55 25 bg 191 79 3 - 3
3 23 hr 188 - - - 2
Centrocampista
8 28 hu 178 74 - 1 5
25 29 it 180 60 - - 5
29 26 it 183 75 - - 11
97 26 pl 180 75 1 - -
21 21 it 182 - - - -
15 20 it 189 85 - - 2
72 19 pl 180 67 - - -
36 19 it 178 - - - 2
80 21 it 188 - 2 - 8
10 23 it 178 70 1 - 7
11 21 si 184 65 - - -
Delantero
16 32 it 186 70 2 - 5
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 MEMORIA  
5,739,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1129
Total Execution Time  0.1147
  CADENA URL  
/asd-spezia
  GET DATOS  
$_GET['/asd-spezia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0017  SELECT type FROM routes WHERE alias = 'asd-spezia'
0.0041  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.0018  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 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.0027  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.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 (3281,3523,9448,9569,14539) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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.0020  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.0022  (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.0024  (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.0021  (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.0020  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.0017  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.0045  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