4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Albacete - Mallorca
Jornada 33
FINALIZADO
30
10
1854 Pts. Elo
5º

2305 Pts. Elo
20º

1-0
Domingo, 03 Mayo 1992, 00:00
Zalazar 10'
1 - 0

Albacete

4-4-2
Alineación Inicial
Suplentes

Mallorca

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

Gol de
Zalazar
minuto 10'

Tarjetas

T. Amarilla
Julio Soler
minuto
T. Amarilla
Menéndez
minuto
minuto T. Amarilla Pedraza
T. Amarilla
Catali
minuto

Cambios

minuto 60'Entra en el partido Marina
minuto 60'Entra en el partido Gálvez
minuto 60'Sale del partido Vidal
minuto 60'Sale del partido Soler
Entra en el partido
Ismael Urzaiz
minuto 73'
Sale del partido
Menéndez
minuto 73'
Sale del partido
Aquino
minuto 85'
Entra en el partido
M. Etcheverry
minuto 85'
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
5,760,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Match / Index )  0.0985
Total Execution Time  0.1001
  CADENA URL  
/partido/Albacete/Mallorca/1992
  GET DATOS  
$_GET['/partido/Albacete/Mallorca/1992']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0039  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 5417
0.0018  SELECT data1 FROM stats1992 t WHERE league_id = 5417 AND teamId = 93918 and type = 33
0.0018  SELECT data1 FROM stats1992 t WHERE league_id = 5417 AND teamId = 93920 and type = 33
0.0050  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=702 AND rdh.league_id=5417 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0024  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '702' and rp.type = 1992 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 = 702 AND year = 1992 AND channel = 'Footters' LIMIT 1
0.0020  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 702 AND year = 1992 AND channel = 'Footters' LIMIT 1
0.0027  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 5417 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='702' AND `active` = 1 AND year = 1992
0.0045  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='5417' AND relp.team_id=93918 WHERE relp.in_squad=1 and mp.`match_id` = '702' AND mp.year='1992' ORDER BY mp.`team` ASC, p.`role` ASC
0.0057  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='5417' AND relp.team_id=93920 WHERE relp.in_squad=1 and mp.`match_id` = '702' AND mp.year='1992' ORDER BY mp.`team` ASC, p.`role` ASC
0.0024  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '5417' AND id_match = '702'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=702 AND extraId = 5417 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 702 AND league_id = 5417 AND year = 1992