4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Las Palmas - Real Sporting
Jornada 17
FINALIZADO
10
00
2466 Pts. Elo
10º

2736 Pts. Elo
11º

1-1
Domingo, 27 Diciembre 1981, 00:00
0 - 1
 46' Ferrero
Pepe Juan 85'
1 - 1

Eventos del partido

Goles

minuto 46'FerreroGol de Ferrero
Pepe JuanGol de
Pepe Juan
minuto 85'

Tarjetas

FélixT. Amarilla
Félix
minuto

Cambios

PáezSale del partido
Páez
minuto 30'
VíctorEntra en el partido
Víctor
minuto 30'
RoqueSale del partido
Roque
minuto 70'
Sergio FortunatoEntra en el partido
Sergio Fortunato
minuto 70'
minuto 89'VallinaEntra en el partido Vallina
minuto 89'Andrés FernándezSale del partido Andrés Fernández

Alineaciones

Las Palmas

Las Palmas

4-4-2
Alineación Inicial
Suplentes
Real Sporting

Real Sporting

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,649,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3727
Total Execution Time  0.3737
  CADENA URL  
/partido/Ud-Palmas/Sporting-Gijon/1982
  GET DATOS  
$_GET['/partido/Ud-Palmas/Sporting-Gijon/1982']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0125  SELECT data1 FROM stats1982 t WHERE league_id = 5407 AND teamId = 94110 and type = 33
0.0125  SELECT data1 FROM stats1982 t WHERE league_id = 5407 AND teamId = 94120 and type = 33
0.0143  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=149 AND rdh.league_id=5407 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0127  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '149' and rp.type = 1982 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 149 AND year = 1982 AND channel = 'Footters' LIMIT 1
0.0126  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 149 AND year = 1982 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='149' AND `active` = 1 AND year = 1982
0.0145  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='5407' AND relp.team_id=94110 WHERE relp.in_squad=1 and mp.`match_id` = '149' AND mp.year='1982' ORDER BY mp.`team` ASC, p.`role` ASC
0.0147  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='5407' AND relp.team_id=94120 WHERE relp.in_squad=1 and mp.`match_id` = '149' AND mp.year='1982' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '5407' AND id_match = '149'
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=149 AND extraId = 5407 AND type_rel = 4
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 149 AND league_id = 5407 AND year = 1982