4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Mallorca B - Jerez
Jornada 25
FINALIZADO
10
51
698 Pts. Elo
19º

637 Pts. Elo
4º

1-1
Domingo, 17 Febrero 2002, 00:00
0 - 1
 5' S. García
Quique Romero 60'
1 - 1

Eventos del partido

Goles

minuto 5'S. GarcíaGol de S. García
Quique RomeroGol de
Quique Romero
minuto 60'

Tarjetas

minuto S. GarcíaT. Amarilla S. García
minuto MoiT. Amarilla Moi
AmateT. Amarilla
Amate
minuto
minuto José MariT. Amarilla José Mari
minuto IzquierdoT. Amarilla Izquierdo
minuto 85'José Mari2a Amarilla y Roja José Mari

Cambios

minuto 29'ÁvaloEntra en el partido Ávalo
minuto 29'Diego BarreroSale del partido Diego Barrero
JuanluSale del partido
Juanlu
minuto 32'
R. MerinoEntra en el partido
R. Merino
minuto 32'
minuto 39'OliSale del partido Oli
minuto 39'José MariEntra en el partido José Mari
Iván ZarandonaSale del partido
Iván Zarandona
minuto 58'
Quique RomeroEntra en el partido
Quique Romero
minuto 58'
minuto 71'S. GarcíaSale del partido S. García
minuto 71'AlexEntra en el partido Alex
MorgadoSale del partido
Morgado
minuto 74'
Tomeu ReynésEntra en el partido
Tomeu Reynés
minuto 74'

Alineaciones

Mallorca B

Mallorca B

4-4-2
Alineación Inicial
Suplentes
Jerez

Jerez

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: comment/main_view.php

Line Number: 2065

Mallorca B Mallorca B Jerez Jerez
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
5,854,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Match / Index )  0.3225
Total Execution Time  0.3237
  CADENA URL  
/partido/Mallorca-B/Jerez/2002
  GET DATOS  
$_GET['/partido/Mallorca-B/Jerez/2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0145  SELECT data1 FROM stats2002 t WHERE league_id = 5522 AND teamId = 102585 and type = 33
0.0145  SELECT data1 FROM stats2002 t WHERE league_id = 5522 AND teamId = 102598 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=13575 AND rdh.league_id=5522 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0147  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '13575' and rp.type = 2002 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 = 13575 AND year = 2002 AND channel = 'Footters' LIMIT 1
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 13575 AND year = 2002 AND channel = 'Footters' LIMIT 1
0.0145  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='13575' AND `active` = 1 AND year = 2002
0.0192  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='5522' AND relp.team_id=102585 WHERE relp.in_squad=1 and mp.`match_id` = '13575' AND mp.year='2002' ORDER BY mp.`team` ASC, p.`role` ASC
0.0151  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='5522' AND relp.team_id=102598 WHERE relp.in_squad=1 and mp.`match_id` = '13575' AND mp.year='2002' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '5522' AND id_match = '13575'
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13575 AND extraId = 5522 AND type_rel = 4
0.0144  SELECT * FROM futbol.calendars_lineups WHERE id = 13575 AND league_id = 5522 AND year = 2002