4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Cittadella - Ternana Calcio
Jornada 9
FINALIZADO
20
10
1140 Pts. Elo
47%
9º

870 Pts. Elo
52%
17º

2-2
Sábado, 07 Octubre 2023, 16:15
0 - 1
 8' C. Falletti
T. Maistrello 10'
1 - 1
Claudio Cassano 29'
2 - 1
2 - 2
 84' F. Sørensen
Cittadella
Ternana Calcio
Gol de penalti
Gol
Asistencia
Asistencia
Gol
Entra en el partido
Sale del partido
T. Amarilla
T. Amarilla
T. Amarilla
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Lesionado
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Gol

Eventos del partido

Goles

minuto 8'Gol de penalti C. Falletti
Gol de
T. Maistrello
minuto 10'
Gol de
Claudio Cassano
minuto 29'
minuto 84'Gol de F. Sørensen

Tarjetas

T. Amarilla
A. Vita
minuto 58'
T. Amarilla
Simone Branca
minuto 60'
minuto 62'T. Amarilla J. Labojko

Cambios

minuto 46'Entra en el partido N. Pyyhtia
minuto 46'Sale del partido N. Corrado
minuto 63'Sale del partido T. Casasola
minuto 63'Entra en el partido F. Sørensen
minuto 63'Sale del partido Filippo Di Stefano
minuto 63'Entra en el partido F. Dionisi
Entra en el partido
Francesco Amatucci
minuto 64'
Sale del partido
Filippo Pittarello
minuto 64'
Sale del partido
Claudio Cassano
minuto 64'
Entra en el partido
A. Magrassi
minuto 64'
minuto 69'Sale del partido J. Labojko
minuto 69'Entra en el partido Costantino Favasuli
Sale del partido
Simone Branca
minuto 73'
Entra en el partido
A. Danzi
minuto 73'
Sale del partido
T. Maistrello
minuto 74'
Entra en el partido
L. Pandolfi
minuto 74'
Entra en el partido
V. Mastrantonio
minuto 80'
Sale del partido
G. Carriero
minuto 80'
minuto 84'Entra en el partido V. Mantovani
minuto 84'Sale del partido Gregorio Luperini

Otros

Asistencia
A. Vita
minuto 10'
Asistencia
Simone Branca
minuto 29'
Lesionado
G. Carriero
minuto 79'

Estadísticas del partido

Cittadella Cittadella Ternana Calcio Ternana
47%
Posesión del balón
 52%
2
Goles
 2
4
Tiros a puerta
 5
6
Tiros fuera
 6
12
Total tiros
 17
3
Paradas del portero
 2
3
Saques de esquina
 4
0
Tarjetas Rojas
 0
2
Asistencias
 0
1
Lesiones
 0
3
Sustituciones
 3
14
Faltas
 11
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
7,036,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.4044
Total Execution Time  0.4055
  CADENA URL  
/partido/As-Cittadella/Ternana-Calcio
  GET DATOS  
$_GET['/partido/As-Cittadella/Ternana-Calcio']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0039  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 = 72045
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72045 AND teamId = 6582460 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72045 AND teamId = 6582476 and type = 33
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '145537' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 145537 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0024  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 145537 AND year = 2024 AND channel = 'Footters' LIMIT 1
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 `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.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='145537' AND `active` = 1 AND year = 2024
0.0094  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72045' AND relp.team_id=6582460 WHERE relp.in_squad=1 and mp.`match_id` = '145537' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0112  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72045' AND relp.team_id=6582476 WHERE relp.in_squad=1 and mp.`match_id` = '145537' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=145537 AND extraId = 72045 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89 AND type_rel = 3
0.0040  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 89 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 (1311583,1309107,1308896,1307681,1306185) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 145537 AND league_id = 72045 AND year = 2024