4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
NC Magra - CS Constantine
Jornada 21
FINALIZADO
00
30
828 Pts. Elo
13º

1176 Pts. Elo
2º

2-3
Domingo, 24 Marzo 2024, 15:30
0 - 1
 16' M. Temine
0 - 2
 26' A. Khaldi
M. Bourahla 34'
1 - 2
1 - 3
 41' A. Khaldi
M. Bourahla 63'
2 - 3

Eventos del partido

Goles

minuto 16'M. TemineGol de M. Temine
minuto 26'A. KhaldiGol de A. Khaldi
M. BourahlaGol de
M. Bourahla
minuto 34'
minuto 41'A. KhaldiGol de A. Khaldi
M. BourahlaGol de
M. Bourahla
minuto 63'

Tarjetas

minuto Z. MessibahT. Amarilla Z. Messibah
minuto Zakaria BoukhalfayaT. Amarilla Zakaria Boukhalfaya
minuto M. TemineT. Amarilla M. Temine

Cambios

minuto 64'O. MeddahiSale del partido O. Meddahi
minuto 64'A. BouguerraEntra en el partido A. Bouguerra
minuto 64'A. KhaldiSale del partido A. Khaldi
minuto 64'A. BelhociniEntra en el partido A. Belhocini
minuto 78'Mohamed BenchairaSale del partido Mohamed Benchaira
minuto 78'C. DerradjiEntra en el partido C. Derradji
minuto 88'Z. MessibahEntra en el partido Z. Messibah
minuto 88'Bin Enow NasirEntra en el partido Bin Enow Nasir
minuto 88'M. TemineSale del partido M. Temine
minuto 88'Hadji AffariSale del partido Hadji Affari

Otros

minuto 16'I. DeebAsistencia I. Deeb
minuto 26'I. DeebAsistencia I. Deeb
minuto 41'I. DeebAsistencia I. Deeb

Alineaciones

NC Magra

NC Magra

4-4-2
Alineación Inicial
CS Constantine

CS Constantine

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

NC Magra NC Magra CS Constantine Constantine
2
Goles
 3
0
Tarjetas Amarillas
 3
0
Tarjetas Rojas
 0
0
Asistencias
 3
0
Sustituciones
 3


  USO DE MEMORIA  
6,560,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3959
Total Execution Time  0.3968
  CADENA URL  
/partido/Nc-Magra/Cs-Constantine/2022?section=legal
  GET DATOS  
$_GET['/partido/Nc-Magra/Cs-Constantine/2022']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73595 AND teamId = 6605173 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73595 AND teamId = 6605166 and type = 33
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '617230' and rp.type = 2024 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 = 617230 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 617230 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0020  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='617230' AND `active` = 1 AND year = 2024
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='73595' AND relp.team_id=6605173 WHERE relp.in_squad=1 and mp.`match_id` = '617230' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0049  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='73595' AND relp.team_id=6605166 WHERE relp.in_squad=1 and mp.`match_id` = '617230' 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=617230 AND extraId = 73595 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 617230 AND league_id = 73595 AND year = 2024