4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Granada - CD Linares
Jornada 10
FINALIZADO
10
50
589 Pts. Elo
14º

576 Pts. Elo
7º

1-2
Domingo, 29 Octubre 2006, 00:00
0 - 1
 13' Sierra
0 - 2
 20' Chico
Bordi 58'
1 - 2

Eventos del partido

Goles

minuto 13'SierraGol de Sierra
minuto 20'ChicoGol de Chico
BordiGol de
Bordi
minuto 58'

Tarjetas

minuto CastilloT. Amarilla Castillo
minuto ManuT. Amarilla Manu
RamónT. Amarilla
Ramón
minuto
minuto CidonchaT. Amarilla Cidoncha
minuto Dani BouzasT. Amarilla Dani Bouzas
minuto RomeritoT. Amarilla Romerito

Cambios

ZuritaEntra en el partido
Zurita
minuto 36'
RodriSale del partido
Rodri
minuto 36'
JosemiEntra en el partido
Josemi
minuto 36'
SaavedraSale del partido
Saavedra
minuto 36'
minuto 48'DomingoEntra en el partido Domingo
minuto 48'CastilloSale del partido Castillo
minuto 79'GalloSale del partido Gallo
minuto 79'CatanhaEntra en el partido Catanha
minuto 85'TroiteiroEntra en el partido Troiteiro
minuto 85'Dani BouzasSale del partido Dani Bouzas

Alineaciones

Granada

Granada

4-4-2
Alineación Inicial
Suplentes
CD Linares

CD Linares

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,804,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.0780
Total Execution Time  0.0790
  CADENA URL  
/partido/Granada/Cd-Linares/2007
  GET DATOS  
$_GET['/partido/Granada/Cd-Linares/2007']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0028  SELECT rdh.pos, rdh.playerId AS player_id, rdh.team, dp.alias, dp.role, dp.name, dp.nick, dp.last_name, '' AS num FROM rel_dreamteam_historical AS rdh INNER JOIN dataplayers AS dp ON rdh.playerId=dp.id WHERE rdh.match_id=3366 AND rdh.league_id=85 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '3366' and rp.type = 2007 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 = 3366 AND year = 2007 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 3366 AND year = 2007 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='3366' AND `active` = 1 AND year = 2007
0.0024  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='85' AND relp.team_id=2597 WHERE relp.in_squad=1 and mp.`match_id` = '3366' AND mp.year='2007' 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='85' AND relp.team_id=2585 WHERE relp.in_squad=1 and mp.`match_id` = '3366' AND mp.year='2007' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '85' AND id_match = '3366'
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3366 AND extraId = 85 AND type_rel = 4
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 3366 AND league_id = 85 AND year = 2007