4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Empoli - Trabzonspor
Jornada 51
FINALIZADO
00
00
1961 Pts. Elo

2007 Pts. Elo

1-0
Lunes, 25 Julio 2022, 18:00
Mattia Destro 14'
1 - 0
Empoli

Empoli

4-4-2
Alineación Inicial
Suplentes
Trabzonspor

Trabzonspor

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

Mattia DestroGol de
Mattia Destro
minuto 14'

Cambios

T. BaldanziEntra en el partido
T. Baldanzi
minuto 46'
Mattia DestroSale del partido
Mattia Destro
minuto 46'
S. PerisanEntra en el partido
S. Perisan
minuto 46'
G. VicarioSale del partido
G. Vicario
minuto 46'
minuto 46'B. ÖzdemirEntra en el partido B. Özdemir
minuto 46'D. HaspolatSale del partido D. Haspolat
L. ŠtulacEntra en el partido
L. Štulac
minuto 62'
Răzvan MarinSale del partido
Răzvan Marin
minuto 62'
L. CacaceEntra en el partido
L. Cacace
minuto 62'
P. StojanovičSale del partido
P. Stojanovič
minuto 62'
minuto 64'Y. ErdoğanSale del partido Y. Erdoğan
minuto 64'A. CorneliusEntra en el partido A. Cornelius
minuto 64'A. BakasetasEntra en el partido A. Bakasetas
minuto 64'D. ToközSale del partido D. Toköz
minuto 65'J. StrygerEntra en el partido J. Stryger
minuto 65'DjaninySale del partido Djaniny
minuto 65'Edin VišćaEntra en el partido Edin Višća
minuto 65'Vitor HugoSale del partido Vitor Hugo
minuto 65'M. HamšíkEntra en el partido M. Hamšík
minuto 65'M. SiopisSale del partido M. Siopis
T. EbuehiEntra en el partido
T. Ebuehi
minuto 68'
F. ParisiSale del partido
F. Parisi
minuto 68'
J. FazziniEntra en el partido
J. Fazzini
minuto 69'
L. HendersonSale del partido
L. Henderson
minuto 69'
N. HaasEntra en el partido
N. Haas
minuto 69'
F. BandinelliSale del partido
F. Bandinelli
minuto 69'
Koni De WinterEntra en el partido
Koni De Winter
minuto 72'
S. LupertoSale del partido
S. Luperto
minuto 72'
E. EkongEntra en el partido
E. Ekong
minuto 72'
Martín SatrianoSale del partido
Martín Satriano
minuto 72'
G. CrociataEntra en el partido
G. Crociata
minuto 81'
N. BajramiSale del partido
N. Bajrami
minuto 81'
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
7,005,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3737
Total Execution Time  0.3747
  CADENA URL  
/partido/Empoli-Fc/Trabzonspor/2023
  GET DATOS  
$_GET['/partido/Empoli-Fc/Trabzonspor/2023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0068   SELECT c.*, c.stadium as real_stadium, 2023 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2023 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Empoli-Fc' AND dt2.basealias = 'Trabzonspor'
0.0028  SELECT c.*, 2023 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2023 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Empoli-Fc' AND dt2.basealias = 'Trabzonspor'
0.0017  SELECT data1 FROM stats2023 t WHERE league_id = 67320 AND teamId = 6525625 and type = 33
0.0018  SELECT data1 FROM stats2023 t WHERE league_id = 67320 AND teamId = 6522708 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '165092' and rp.type = 2023 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 = 165092 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 165092 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0185  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 67320 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='165092' AND `active` = 1 AND year = 2023
0.0200  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='67320' AND relp.team_id=6525625 WHERE relp.in_squad=1 and mp.`match_id` = '165092' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0182  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='67320' AND relp.team_id=6522708 WHERE relp.in_squad=1 and mp.`match_id` = '165092' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=165092 AND extraId = 67320 AND type_rel = 4
0.0018  SELECT avg_rating FROM elo_teams WHERE id=2527
0.0018  SELECT position FROM tables2023 WHERE team=6525625 AND league_id=67320 AND round=51
0.0018  SELECT position FROM tables2023 WHERE team=6522708 AND league_id=67320 AND round=51
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 165092 AND league_id = 67320 AND year = 2023