4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Siena

Siena

Entrenador: Guido Pagliuca

Información
  • Nombre del equipo Siena
  • Nombre completo Associazione Calcio Siena S.p.A
  • Nombre corto SIE
  • País Italia
  • Ciudad Siena
  • Entrenador Guido Pagliuca
  • URL del equipo en RF //m.resultados-futbol.com/Siena
Otros Datos
  • Año de Fundación 1904
Internet

Información sobre el estadio

  • Nombre del estadio Stadio Comunale Artemio Franchi
  • Capacidad 15373
  • Dirección Via Mille, 3
  • Teléfono 0577281084
  • Fax 0577281083
  • Año de construcción 1931
  • Tamaño 105x68 metros
Stadio Comunale Artemio Franchi

Partidos del Siena

Ir al LIVESCORE
27 Jul 17  Finalizado Siena Siena
0 - 0
Virtus Francavilla Virtus Francavilla 0
23 Jul 17  Finalizado Siena Siena
1 - 1
Follonica Gavorrano Follonica Gavorrano 0
16 Jun 18  Finalizado Siena Siena
1 - 3
Cosenza Cosenza 20
10 Jun 18  Finalizado Catania Catania
2 - 1
Siena SienaTarjeta RojaTarjeta Roja 23
06 Jun 18  Finalizado Siena Siena
1 - 0
Catania Catania 20
03 Jun 18  Finalizado Siena Siena
2 - 1
Reggiana ReggianaTarjeta RojaTarjeta Roja 5
30 May 18  Finalizado Reggiana Reggiana
2 - 1
Siena Siena 11
05 May 18  Finalizado Prato Prato
2 - 3
Siena Siena 1
28 Abr 18  Finalizado Siena Siena
0 - 2
Piacenza Piacenza 1
21 Abr 18  Finalizado Siena Siena
1 - 0
Cuneo CuneoTarjeta Roja 2
14 Abr 18  Finalizado SS Arezzo SS Arezzo
1 - 0
Siena Siena 5
03 Abr 18  Finalizado Pro Piacenza Pro Piacenza
0 - 1
Siena Siena 13
29 Mar 18  Finalizado Pontedera Pontedera
1 - 0
Siena SienaTarjeta Roja 8
24 Mar 18  Finalizado Siena Siena
2 - 0
Pistoiese PistoieseTarjeta Roja 3
20 Mar 18  Finalizado Livorno Livorno
1 - 0
Siena Siena 37
17 Mar 18  Finalizado AC Monza AC Monza
2 - 0
Siena Siena 1
10 Mar 18  Finalizado Siena Siena
1 - 0
Viterbese Viterbese 2
25 Feb 18  Finalizado Siena Siena
1 - 0
Olbia Calcio Olbia Calcio 3
18 Feb 18  Finalizado Giana Erminio Giana Erminio
0 - 1
Siena Siena 1
12 Feb 18  Finalizado Siena Siena
0 - 0
Carrarese Carrarese 6
04 Feb 18  Finalizado US Alessandria US Alessandria
1 - 1
Siena Siena 1
28 Ene 18  Finalizado Siena Siena
1 - 1
Follonica Gavorrano Follonica Gavorrano 0
24 Ene 18  Finalizado Piacenza Piacenza
1 - 2
Siena Siena 8
20 Ene 18  Finalizado Arzachena Arzachena
1 - 2
Siena Siena 0
30 Dic 17  Finalizado Siena Siena
0 - 0
Pisa SC Pisa SC 1
23 Dic 17  Finalizado Lucchese Libertas Tarjeta RojaLucchese Libertas
1 - 4
Siena Siena 0
20 Dic 17  Finalizado Cuneo Cuneo
2 - 0
Siena SienaTarjeta Roja 0
16 Dic 17  Finalizado Siena Siena
1 - 0
Prato Prato 0
26 Nov 17  Finalizado Siena Siena
1 - 0
SS Arezzo SS Arezzo 3
12 Nov 17  Finalizado Siena Siena
2 - 3
Pontedera Pontedera 3
08 Nov 17  Finalizado Pistoiese Pistoiese
1 - 2
Siena Siena 1
04 Nov 17  Finalizado Siena Siena
1 - 2
Livorno Livorno 2
29 Oct 17  Finalizado Siena Siena
0 - 3
AC Monza AC Monza 1
22 Oct 17  Finalizado Viterbese Viterbese
1 - 3
Siena SienaTarjeta RojaTarjeta Roja 0
13 Oct 17  Finalizado Siena Siena
1 - 0
Pro Piacenza Pro Piacenza 4
08 Oct 17  Finalizado Olbia Calcio Olbia Calcio
1 - 2
Siena Siena 0
04 Oct 17  Finalizado Siena Siena
0 - 0
Giana Erminio Giana Erminio 13
01 Oct 17  Finalizado Carrarese Carrarese
1 - 2
Siena SienaTarjeta Roja 0
24 Sep 17  Finalizado Siena Siena
0 - 0
US Alessandria US Alessandria 0
17 Sep 17  Finalizado Follonica Gavorrano Follonica Gavorrano
0 - 2
Siena Siena 0
10 Sep 17  Finalizado Siena Tarjeta RojaSiena
3 - 2
Arzachena Arzachena 0
03 Sep 17  Finalizado Pisa SC Pisa SC
0 - 0
Siena Siena 0
27 Ago 17  Finalizado Siena Siena
1 - 0
Lucchese Libertas Lucchese Libertas 0
13 Ago 17  Finalizado Prato Prato
1 - 1
Siena Siena 0
06 Ago 17  Finalizado Siena Siena
1 - 1
Follonica Gavorrano Follonica GavorranoTarjeta Roja 0

Plantilla del Siena Temporada 2017/2018

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
1 24 it 186 - - - -
28 23 it - - - - -
32 - it - - - - -
12 26 it 180 75 1 - -
22 34 it 188 - - - 3
Defensa
3 25 it 195 77 - - 1
13 26 it 174 - - - -
2 35 it 184 - - - -
26 32 it 189 - 1 1 4
5 35 it 185 80 1 1 4
15 33 ch 182 72 1 - 2
18 25 it 191 - - - -
33 49 it 180 71 - - -
18 26 au 181 70 - - -
4 29 it 181 - 3 - 3
23 28 it 181 - - - -
19 31 it 186 78 - - -
30 23 it - - - - -
Centrocampista
17 34 it 164 62 2 - 2
9 32 it 178 73 4 - 3
27 29 it 176 70 1 - 3
21 28 it 181 - - 1 -
16 27 it 173 67 1 - -
25 30 it 172 - 4 - 4
14 37 it 170 - - - 2
19 26 it 184 - - - -
8 41 it 181 76 1 - 1
Delantero
10 37 it 178 72 11 - 4
7 26 it 181 - 2 1 1
6 39 it 180 68 5 - 2
20 32 it 164 57 1 - 1

Noticias de Serie C

Ver últimas noticias

La nueva regla en Italia que permitirá a un entrenador cambiar de club en cuestión de días

El fútbol italiano se prepara para dar la bienvenida a una novedad en el terreno de la contratación de entrenadores, permitiendo su fichaje por otro club después de su despido.

Ultras del Foggia incendiaron el estadio del Taranto

La Serie C protagonizó una de las imágenes más escalofriantes de lo que va de temporada. Los ultras del Calcio Foggia decidieron incendiar el estadio del Taranto después de perder por 2-0 ante los 'ionici'.

El Milan cierra la pretemporada con goleada y asterisco

El Milan cerró la pretemporada con victoria por 4-2 sobre el Novara, un equipo de Serie C que, a pesar de encajar 4 dianas, logró marcar 2, lo que no habrá sentado del todo bien en el seno del banquillo de Stefano Pioli. El técnico, para esta última prueba, confió en conocidos recientes del fútbol español como Luka Romero, Samu Chukwueze y Yunus Musah para su once inicial. El ex del Villarreal vio puerta.

El laberinto de un descenso en cadena para 10 clubes históricos

BeSoccer Pro se centra en analizar el declive reciente de 10 clubes que hace no mucho disfrutaban del lujo de las grandes ligas y que ahora han visto cómo su realidad ha cambiado hasta tener que salir del pozo de una tercera categoría. En España, dos casos claros: Deportivo de La Coruña y Málaga.

Rossi pone fin a su viaje en el fútbol tras 16 temporadas

Giuseppe Rossi anunció a través de sus redes sociales que pondrá punto y final a su carrera futbolística. A sus 36 años, el italiano pone fin a 16 temporadas como profesional, donde ha militado en el Manchester United, Newcastle, Parma, Villarreal, Fiorentina, Levante, Celta, Genoa, Real Salt Lake y SPAL.




  USO DE MEMORIA  
6,137,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.2653
Total Execution Time  0.2676
  CADENA URL  
/Siena/2018
  GET DATOS  
$_GET['/Siena/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0041  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 = 38929
0.0025  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 = 43410
0.0023  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 = 39414
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2333 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 90 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 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 (1288519,1278023,1273213,1269533,1269201) ORDER BY n.cover_points DESC, update_date DESC
0.0043  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 = '2333' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '2333' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 38929 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 39414 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  (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 calendars2018 as c ON c.league_id = l.id WHERE (c.datateam1 = 2333 or c.datateam2 = 2333) AND l.year = 2018 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0056  (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 calendars2018 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 = 2333 or c.datateam2 = 2333) AND l.year = 2018 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0031  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN events2018 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 = 2333 or c.datateam2 = 2333) AND l.year = 2018)
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=2333 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (49684,45441,44541,43475) 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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 49684 AND teamId = 2333
0.0043  SELECT count(id) as num_players from rel_players WHERE league_id = 44541 AND teamId = 2333
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 45441 AND teamId = 2333
0.0518  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 2333
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0055  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 events2018 e ON e.player_id = p.id AND e.league_id = 38929 WHERE rp.league_id = 38929 AND rp.teamId = 2333 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.0065  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 events2018 e ON e.player_id = p.id AND e.league_id = 38929 WHERE rp.league_id = 38929 AND rp.teamId = 2333 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 events2018 e ON e.player_id = p.id AND e.league_id = 38929 WHERE rp.league_id = 38929 AND rp.teamId = 2333 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 = 2333 AND rp.league_id = 38929 AND l.year= 2018 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0031  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=788886 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=788886
0.0035  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=788886 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.0044  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=788886 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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=788886 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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=788886 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0050  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=788886 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC