4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
MSP Batna - Bordj Bou Arreridj
FINALIZADO
20
30
291 Pts. Elo
18º

566 Pts. Elo

0-1
Viernes, 30 Octubre 2009, 18:00
0 - 1
57' Samir Bentayeb

Eventos del partido

Goles

minuto 57'Samir BentayebGol de Samir Bentayeb

Tarjetas

Kamel DahouaneT. Amarilla
Kamel Dahouane
minuto
minuto A. AmmourT. Amarilla A. Ammour
Hamza YacefT. Amarilla
Hamza Yacef
minuto 84'
minuto 85'JaimeT. Amarilla Jaime
minuto 85'S. BelouahemT. Amarilla S. Belouahem

Cambios

O. HezilSale del partido
O. Hezil
minuto 38'
Samir DjilaniEntra en el partido
Samir Djilani
minuto 38'
T. ZeghidiSale del partido
T. Zeghidi
minuto 70'
H. ZiadSale del partido
H. Ziad
minuto 70'
Ali Abdelatif BourouagEntra en el partido
Ali Abdelatif Bourouag
minuto 70'
Ghouti LoukiliEntra en el partido
Ghouti Loukili
minuto 70'
minuto 75'Abdelmalek TouatiSale del partido Abdelmalek Touati
minuto 75'A. BitamEntra en el partido A. Bitam

Alineaciones




  USO DE MEMORIA  
5,707,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.0817
Total Execution Time  0.0827
  CADENA URL  
/partido/Msp-Batna/Bordj-Bou-Arreridj/2010
  GET DATOS  
$_GET['/partido/Msp-Batna/Bordj-Bou-Arreridj/2010']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0019  SELECT data1 FROM stats2010 t WHERE league_id = 8614 AND teamId = 139561 and type = 33
0.0018  SELECT data1 FROM stats2010 t WHERE league_id = 8614 AND teamId = 139553 and type = 33
0.0023  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '114979' and rp.type = 2010 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 114979 AND year = 2010 AND channel = 'Footters' LIMIT 1
0.0020  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 114979 AND year = 2010 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='114979' AND `active` = 1 AND year = 2010
0.0029  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='8614' AND relp.team_id=139561 WHERE relp.in_squad=1 and mp.`match_id` = '114979' AND mp.year='2010' ORDER BY mp.`team` ASC, p.`role` ASC
0.0032  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='8614' AND relp.team_id=139553 WHERE relp.in_squad=1 and mp.`match_id` = '114979' AND mp.year='2010' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=114979 AND extraId = 8614 AND type_rel = 4
0.0018  SELECT avg_rating FROM elo_teams WHERE id=13625
0.0018  SELECT avg_rating FROM elo_teams WHERE id=11514
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 114979 AND league_id = 8614 AND year = 2010