4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Union Saint-Gilloise - FC Lugano
Jornada 1
FINALIZADO
30
10
2373 Pts. Elo
42%

1661 Pts. Elo
57%

2-0
Jueves, 24 Agosto 2023, 20:30
D. Eckert 8'
1 - 0
C. Terho 71'
2 - 0
Union Saint-Gilloise
FC Lugano
Gol
Asistencia
T. Amarilla
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
T. Amarilla
Gol
Asistencia
T. Amarilla
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
T. Amarilla

Eventos del partido

Goles

Gol de
D. Eckert
minuto 8'
Gol de
C. Terho
minuto 71'

Tarjetas

T. Amarilla
D. Eckert
minuto 42'
T. Amarilla
K. Mac Allister
minuto 67'
minuto 76'T. Amarilla J. Sabbatini
T. Amarilla
Gustaf Nilsson
minuto 96'

Cambios

minuto 65'Entra en el partido J. Espinoza
minuto 65'Sale del partido Allan Arigoni
Entra en el partido
Gustaf Nilsson
minuto 66'
Sale del partido
D. Eckert
minuto 66'
Entra en el partido
Noah Sadiki
minuto 66'
Sale del partido
Mathias Rasmussen
minuto 66'
minuto 76'Entra en el partido Y. Cimignani
minuto 76'Sale del partido M. Bottani
minuto 76'Sale del partido J. Sabbatini
minuto 76'Entra en el partido H. Mahmoud
minuto 77'Sale del partido Uran Bislimi
minuto 77'Entra en el partido Roman Macek
minuto 84'Sale del partido Zan Celar
minuto 84'Entra en el partido S. Vladi
Sale del partido
L. Lapoussin
minuto 91'
Entra en el partido
Fedde Leysen
minuto 91'

Otros

Asistencia
Mathias Rasmussen
minuto 8'
Asistencia
Lazare Amani
minuto 71'

Estadísticas del partido

Union Saint-Gilloise Union FC Lugano FC Lugano
42%
Posesión del balón
 57%
2
Goles
 0
6
Tiros a puerta
 7
7
Tiros fuera
 4
15
Total tiros
 12
7
Paradas del portero
 4
4
Saques de esquina
 3
1
Fueras de juego
 1
0
Tarjetas Rojas
 0
2
Asistencias
 0
3
Sustituciones
 3
16
Faltas
 10
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,586,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.6938
Total Execution Time  0.6947
  CADENA URL  
/partido/Union-Saint-Gilloise/Lugano/2024
  GET DATOS  
$_GET['/partido/Union-Saint-Gilloise/Lugano/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 72104 AND teamId = 6583346 and type = 33
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 72104 AND teamId = 6583347 and type = 33
0.0108  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '476457' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 476457 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0107  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 476457 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='476457' AND `active` = 1 AND year = 2024
0.0152  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='72104' AND relp.team_id=6583346 WHERE relp.in_squad=1 and mp.`match_id` = '476457' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0176  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='72104' AND relp.team_id=6583347 WHERE relp.in_squad=1 and mp.`match_id` = '476457' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=476457 AND extraId = 72104 AND type_rel = 4
0.0117  SELECT /*115 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' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 476457 AND rel.extraId = 72104 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2023-06-25 20:30:00' AND n.creation_date<'2023-10-23 20:30:00' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0105  SELECT position FROM tables2024 WHERE team=6583346 AND league_id=72104 AND round=1
0.0105  SELECT position FROM tables2024 WHERE team=6583347 AND league_id=72104 AND round=1
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 476457 AND league_id = 72104 AND year = 2024