4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Andrézieux - Toulouse II
Jornada 23
FINALIZADO
01
41
254 Pts. Elo
9º

137 Pts. Elo
14º

0-0
Viernes, 19 Abril 2024, 19:30
Andrézieux

Andrézieux

4-4-2
Alineación Inicial
Suplentes
Toulouse II

Toulouse II

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Tarjetas

minuto 26'Kylian WatelT. Amarilla Kylian Watel
minuto 31'Yanis ZodehouganT. Amarilla Yanis Zodehougan
C. CabatonTarjeta Roja a
C. Cabaton
minuto 41'
minuto 77'Yanis Zodehougan2a Amarilla y Roja Yanis Zodehougan
minuto 84'Justin LacombeT. Amarilla Justin Lacombe

Cambios

M. DiabyEntra en el partido
M. Diaby
minuto 65'
J. MoustaidSale del partido
J. Moustaid
minuto 65'
H. KonéSale del partido
H. Koné
minuto 65'
A. VacheronEntra en el partido
A. Vacheron
minuto 65'
minuto 70'Warren NgakoEntra en el partido Warren Ngako
minuto 70'Alexis N'tamackSale del partido Alexis N'tamack
minuto 79'Yannick AgoraEntra en el partido Yannick Agora
R. Ech-CherguiSale del partido
R. Ech-Chergui
minuto 79'
minuto 79'N. EdjoumaSale del partido N. Edjouma
M. ToutouEntra en el partido
M. Toutou
minuto 79'
M. ChapuisSale del partido
M. Chapuis
minuto 79'
J. CottinEntra en el partido
J. Cottin
minuto 79'
minuto 86'M. KébéSale del partido M. Kébé
minuto 86'Clement PujosEntra en el partido Clement Pujos

Estadísticas del partido

Andrézieux Andrézieux Toulouse II Toulouse II
0
Goles
 0
0
Tarjetas Amarillas
 1
1
Tarjetas Rojas
 1
3
Sustituciones
 3
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,617,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Match / Index )  0.2271
Total Execution Time  0.2288
  CADENA URL  
/partido/Andrezieux/Toulouse-Ii
  GET DATOS  
$_GET['/partido/Andrezieux/Toulouse-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72962 AND teamId = 6595191 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72962 AND teamId = 6595200 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 = '195898' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 195898 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 195898 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0034  SELECT t.points,t.team,t.round 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 = 72962 AND t.round >= 9 AND t.round <= 24 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC, dt.nameShow ASC
0.0017  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='195898' AND `active` = 1 AND year = 2024
0.0041  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='72962' AND relp.team_id=6595191 WHERE relp.in_squad=1 and mp.`match_id` = '195898' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0037  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='72962' AND relp.team_id=6595200 WHERE relp.in_squad=1 and mp.`match_id` = '195898' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=195898 AND extraId = 72962 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=220 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 220 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1303338,1286561,1233296,1230274,1161224) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 195898 AND league_id = 72962 AND year = 2024