4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Alcoyano - Valencia Mestalla
Jornada 32
FINALIZADO
50
20
875 Pts. Elo
6º

564 Pts. Elo
13º

2-1
Sábado, 04 Abril 2015, 20:45
0 - 1
 28' Zahibo
Jaume Doménech 34'
1 - 1
Carles Salvador 88'
2 - 1

Eventos del partido

Goles

minuto 28'ZahiboGol de Zahibo
Jaume Doménech Gol de (p.p)
Jaume Doménech
minuto34'
Carles SalvadorGol de
Carles Salvador
minuto 88'

Tarjetas

MongilT. Amarilla
Mongil
minuto 5'
Óscar LópezT. Amarilla
Óscar López
minuto 25'
minuto 56'I. DialloT. Amarilla I. Diallo
Carles SalvadorT. Amarilla
Carles Salvador
minuto 61'
I. JerezT. Amarilla
I. Jerez
minuto 66'
minuto 67'Iban SalvadorT. Amarilla Iban Salvador
PeronaT. Amarilla
Perona
minuto 88'

Cambios

PituliSale del partido
Pituli
minuto 62'
N. MaturanaEntra en el partido
N. Maturana
minuto 62'
minuto 64'Iban SalvadorEntra en el partido Iban Salvador
minuto 64'Nacho GilSale del partido Nacho Gil
Francis FerrónEntra en el partido
Francis Ferrón
minuto 72'
I. JerezSale del partido
I. Jerez
minuto 72'
minuto 81'AlbertoEntra en el partido Alberto
minuto 81'Dani RamírezSale del partido Dani Ramírez
minuto 86'Borja DomingoEntra en el partido Borja Domingo
minuto 86'A. De GrootSale del partido A. De Groot
PeronaEntra en el partido
Perona
minuto 90'
Javi RubioSale del partido
Javi Rubio
minuto 90'

Alineaciones

Alcoyano

Alcoyano

4-4-2
Alineación Inicial
Suplentes
Valencia Mestalla

Valencia Mestalla

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,994,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3547
Total Execution Time  0.3558
  CADENA URL  
/partido/Alcoyano/Valencia-Mestalla/2015
  GET DATOS  
$_GET['/partido/Alcoyano/Valencia-Mestalla/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0146  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '26648' and rp.type = 2015 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 26648 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 26648 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0145  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='26648' AND `active` = 1 AND year = 2015
0.0161  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='3864' AND relp.team_id=71139 WHERE relp.in_squad=1 and mp.`match_id` = '26648' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0152  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='3864' AND relp.team_id=71149 WHERE relp.in_squad=1 and mp.`match_id` = '26648' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=26648 AND extraId = 3864 AND type_rel = 4
0.0144  SELECT * FROM futbol.calendars_lineups WHERE id = 26648 AND league_id = 3864 AND year = 2015