4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Strasbourg - Lille
Jornada 17
FINALIZADO
10
20
1427 Pts. Elo
31%
9º

2455 Pts. Elo
68%
5º

2-1
Miércoles, 20 Diciembre 2023, 21:00
0 - 1
 20' Abakar Sylla
Leny Yoro 41'
1 - 1
Junior Mwanga 76'
2 - 1

Eventos del partido

Goles

minuto 20' Abakar Sylla Gol de (p.p)
Abakar Sylla
Leny Yoro Gol de (p.p)
Leny Yoro
minuto41'
Junior MwangaGol de
Junior Mwanga
minuto 76'

Tarjetas

minuto 32'B. AndréT. Amarilla B. André
Abakar SyllaT. Amarilla
Abakar Sylla
minuto 45'
minuto 62'Edon ZhegrovaT. Amarilla Edon Zhegrova

Cambios

ÂngeloEntra en el partido
Ângelo
minuto 63'
Kévin GameiroSale del partido
Kévin Gameiro
minuto 63'
minuto 68'Yusuf YazıcıEntra en el partido Yusuf Yazıcı
minuto 68'Angel GomesSale del partido Angel Gomes
minuto 81'Jonathan DavidSale del partido Jonathan David
minuto 81'H. HaraldssonEntra en el partido H. Haraldsson
minuto 81'Edon ZhegrovaSale del partido Edon Zhegrova
minuto 81'Adam OunasEntra en el partido Adam Ounas
J. DeminguetEntra en el partido
J. Deminguet
minuto 86'
Jérémy SebasEntra en el partido
Jérémy Sebas
minuto 86'
E. EmeghaSale del partido
E. Emegha
minuto 86'
D. BakwaSale del partido
D. Bakwa
minuto 86'

Otros

ÂngeloAsistencia
Ângelo
minuto 76'

VAR

D. BakwaAnulado por var
D. Bakwa
minuto 86'

Alineaciones

Strasbourg

Strasbourg

4-5-1
Alineación Inicial
Suplentes
Lille

Lille

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

Strasbourg Strasbourg Lille Lille
31%
Posesión del balón
 68%
2
Goles
 1
2
Tiros a puerta
 2
3
Tiros fuera
 3
9
Total tiros
 9
2
Paradas del portero
 1
6
Saques de esquina
 5
3
Fueras de juego
 2
0
Tarjetas Rojas
 0
1
Asistencias
 0
3
Sustituciones
 3
19
Faltas
 10

Partido televisado en...
Canal Medio Idioma País
Eurosport PlayerEurosport Player TV Castellano es
Eurosport 2Eurosport 2 TV Castellano es
Star+Star+ TV Latino ar
Star+Star+ TV Latino bo
Star+Star+ TV Latino co
Star+Star+ TV - ec
Star+Star+ TV Latino mx
Star+Star+ TV - py
Star+Star+ TV - pe
Star+Star+ TV - uy
Star+Star+ TV - cr
Star+Star+ TV - sv
Star+Star+ TV Latino gt
Star+Star+ TV - hn
Star+Star+ TV - ni
Star+Star+ TV - pa
Star+Star+ TV - ve
Star+Star+ TV - do

  USO DE MEMORIA  
6,958,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.5448
Total Execution Time  0.5458
  CADENA URL  
/partido/Strasbourg/Lillestrom/1981?section=legal
  GET DATOS  
$_GET['/partido/Strasbourg/Lillestrom/1981']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0264   SELECT c.*, c.stadium as real_stadium, 2024 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 calendars2024 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 = 'Strasbourg' AND dt2.basealias = 'Lillestrom'
0.0184  SELECT c.*, 2024 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 calendars2024 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 = 'Strasbourg' AND dt2.basealias = 'Lillestrom'
0.0146  SELECT data1 FROM stats2024 t WHERE league_id = 72046 AND teamId = 6582493 and type = 33
0.0145  SELECT data1 FROM stats2024 t WHERE league_id = 72046 AND teamId = 6582482 and type = 33
0.0147  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '70669' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 70669 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 70669 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0144  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='70669' AND `active` = 1 AND year = 2024
0.0193  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='72046' AND relp.team_id=6582493 WHERE relp.in_squad=1 and mp.`match_id` = '70669' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0208  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='72046' AND relp.team_id=6582482 WHERE relp.in_squad=1 and mp.`match_id` = '70669' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=70669 AND extraId = 72046 AND type_rel = 4
0.0144  SELECT * FROM futbol.calendars_lineups WHERE id = 70669 AND league_id = 72046 AND year = 2024