4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Novelda CF - CF Gandia
Jornada 31
FINALIZADO
40
71
513 Pts. Elo
4º

615 Pts. Elo
15º

2-1
Sábado, 24 Marzo 2001, 00:00
Borge 16'
1 - 0
Nacho Ramos 27'
2 - 0
2 - 1
 59' Orife

Eventos del partido

Goles

BorgeGol de
Borge
minuto 16'
Nacho RamosGol de
Nacho Ramos
minuto 27'
minuto 59'OrifeGol de Orife

Tarjetas

CuquiT. Amarilla
Cuqui
minuto
minuto OrifeT. Amarilla Orife
minuto WillyT. Amarilla Willy
Pepe DíazT. Amarilla
Pepe Díaz
minuto
minuto AlbeldaT. Amarilla Albelda
minuto SebasT. Amarilla Sebas
JuanjoT. Amarilla
Juanjo
minuto
EduardoT. Amarilla
Eduardo
minuto
minuto CurrásT. Amarilla Currás
minuto RajadoT. Amarilla Rajado
minuto 84'Willy2a Amarilla y Roja Willy

Cambios

minuto 45'NadalEntra en el partido Nadal
minuto 45'AusiàsSale del partido Ausiàs
minuto 45'DoménechEntra en el partido Doménech
minuto 45'SimónSale del partido Simón
SantoSale del partido
Santo
minuto 54'
PitiEntra en el partido
Piti
minuto 54'
minuto 56'BellidoSale del partido Bellido
minuto 56'OrifeEntra en el partido Orife
CarrascoSale del partido
Carrasco
minuto 65'
Álex PascualEntra en el partido
Álex Pascual
minuto 65'
CuquiEntra en el partido
Cuqui
minuto 86'
Pepe DíazSale del partido
Pepe Díaz
minuto 86'

Alineaciones

Novelda CF

Novelda CF

4-4-2
Alineación Inicial
Suplentes
CF Gandia

CF Gandia

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,875,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3378
Total Execution Time  0.3389
  CADENA URL  
/partido/Novelda-Cf/Gandia/2001
  GET DATOS  
$_GET['/partido/Novelda-Cf/Gandia/2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0148  SELECT data1 FROM stats2001 t WHERE league_id = 5513 AND teamId = 102439 and type = 33
0.0145  SELECT data1 FROM stats2001 t WHERE league_id = 5513 AND teamId = 102427 and type = 33
0.0151  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=12993 AND rdh.league_id=5513 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0152  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '12993' and rp.type = 2001 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 12993 AND year = 2001 AND channel = 'Footters' LIMIT 1
0.0149  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 12993 AND year = 2001 AND channel = 'Footters' LIMIT 1
0.0149  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='12993' AND `active` = 1 AND year = 2001
0.0153  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='5513' AND relp.team_id=102439 WHERE relp.in_squad=1 and mp.`match_id` = '12993' AND mp.year='2001' ORDER BY mp.`team` ASC, p.`role` ASC
0.0150  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='5513' AND relp.team_id=102427 WHERE relp.in_squad=1 and mp.`match_id` = '12993' AND mp.year='2001' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '5513' AND id_match = '12993'
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12993 AND extraId = 5513 AND type_rel = 4
0.0146  SELECT avg_rating FROM elo_teams WHERE id=1829
0.0147  SELECT * FROM futbol.calendars_lineups WHERE id = 12993 AND league_id = 5513 AND year = 2001