4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Aubervilliers - Guingamp II
Jornada 16
FINALIZADO
20
20
251 Pts. Elo
4º

160 Pts. Elo
13º

1-2
Sábado, 17 Febrero 2024, 16:00
0 - 1
 14' O. El Manssouri
B. Harragu 27'
1 - 1
1 - 2
 34' Rayan Touzghar

Eventos del partido

Goles

minuto 14'O. El ManssouriGol de O. El Manssouri
B. HarraguGol de
B. Harragu
minuto 27'
minuto 34'Rayan TouzgharGol de Rayan Touzghar

Tarjetas

B. HarraguT. Amarilla
B. Harragu
minuto 26'
minuto 43'Rayan TouzgharT. Amarilla Rayan Touzghar
P. AtanganaT. Amarilla
P. Atangana
minuto 62'
minuto 73'Ibrahim MandefuT. Amarilla Ibrahim Mandefu

Cambios

minuto 46'H. CamaraSale del partido H. Camara
minuto 46'Alain MimbeléEntra en el partido Alain Mimbelé
Y. BouaddiEntra en el partido
Y. Bouaddi
minuto 63'
K. MiriezoloSale del partido
K. Miriezolo
minuto 63'
J. ChéryEntra en el partido
J. Chéry
minuto 63'
D. KonteSale del partido
D. Konte
minuto 63'
B. HarraguSale del partido
B. Harragu
minuto 63'
A. KabaEntra en el partido
A. Kaba
minuto 63'
Y. MédardSale del partido
Y. Médard
minuto 72'
Frédéric MendyEntra en el partido
Frédéric Mendy
minuto 72'
minuto 79'N. FlorivalEntra en el partido N. Florival
minuto 79'Ibrahim MandefuSale del partido Ibrahim Mandefu

Alineaciones

Aubervilliers

Aubervilliers

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

Guingamp II

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,542,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3470
Total Execution Time  0.3480
  CADENA URL  
/partido/Aubervilliers/Guingamp-Ii/2024?section=legal
  GET DATOS  
$_GET['/partido/Aubervilliers/Guingamp-Ii/2024']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72964 AND teamId = 6595225 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72964 AND teamId = 6595231 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 = '196193' 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 = 196193 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 196193 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='196193' AND `active` = 1 AND year = 2024
0.0046  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='72964' AND relp.team_id=6595225 WHERE relp.in_squad=1 and mp.`match_id` = '196193' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
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='72964' AND relp.team_id=6595231 WHERE relp.in_squad=1 and mp.`match_id` = '196193' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=196193 AND extraId = 72964 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 196193 AND league_id = 72964 AND year = 2024