4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Betis Deportivo - Jerez
Jornada 9
FINALIZADO
20
40
559 Pts. Elo
10º

629 Pts. Elo
7º

1-1
Domingo, 28 Octubre 2001, 00:00
Marcos Terán 43'
1 - 0
1 - 1
 56' Copito

Eventos del partido

Goles

Marcos TeránGol de
Marcos Terán
minuto 43'
minuto 56'CopitoGol de Copito

Tarjetas

minuto César MonjeT. Amarilla César Monje
SalgueroT. Amarilla
Salguero
minuto
minuto MoiT. Amarilla Moi
minuto TiánT. Amarilla Tián
minuto MarioT. Amarilla Mario
VicenteT. Amarilla
Vicente
minuto

Cambios

BenítezSale del partido
Benítez
minuto 57'
DaniEntra en el partido
Dani
minuto 57'
minuto 61'OliEntra en el partido Oli
minuto 61'ÁvaloSale del partido Ávalo
Tati MaldonadoSale del partido
Tati Maldonado
minuto 63'
AntoñitoEntra en el partido
Antoñito
minuto 63'
VicenteSale del partido
Vicente
minuto 74'
MelliEntra en el partido
Melli
minuto 74'
minuto 88'EtxaburuEntra en el partido Etxaburu
minuto 88'Marco OrtegaSale del partido Marco Ortega
minuto 92'Jesus Rafael BermejoEntra en el partido Jesus Rafael Bermejo
minuto 92'CopitoSale del partido Copito

Alineaciones

Betis Deportivo

Betis Deportivo

4-4-2
Alineación Inicial
Suplentes
Jerez

Jerez

4-4-2
Alineación Inicial
Suplentes



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