4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Écija Balompié - RC Portuense
Jornada 20
FINALIZADO
10
10
641 Pts. Elo
7º

526 Pts. Elo
4º

2-1
Domingo, 21 Enero 2007, 00:00
0 - 1
 11' Zurdo
Luna 46'
1 - 1
Pepe Díaz 56'
2 - 1

Eventos del partido

Goles

minuto 11'ZurdoGol de Zurdo
LunaGol de
Luna
minuto 46'
Pepe DíazGol de
Pepe Díaz
minuto 56'

Tarjetas

minuto OcañaT. Amarilla Ocaña
Pedro GarcíaT. Amarilla
Pedro García
minuto

Cambios

minuto 63'ChuchiSale del partido Chuchi
minuto 63'JitoEntra en el partido Jito
minuto 63'LimonesEntra en el partido Limones
minuto 63'ZúñigaSale del partido Zúñiga
CapaSale del partido
Capa
minuto 65'
ArgüelloEntra en el partido
Argüello
minuto 65'
SolanoEntra en el partido
Solano
minuto 83'
Jorge GarciaSale del partido
Jorge Garcia
minuto 83'

Alineaciones

Écija Balompié

Écija Balompié

4-4-2
Alineación Inicial
Suplentes
RC Portuense

RC Portuense

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,753,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.2960
Total Execution Time  0.2971
  CADENA URL  
/partido/Ecija/Racing-Club-Portuense/2007
  GET DATOS  
$_GET['/partido/Ecija/Racing-Club-Portuense/2007']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0149  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=3472 AND rdh.league_id=85 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0146  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '3472' and rp.type = 2007 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 = 3472 AND year = 2007 AND channel = 'Footters' LIMIT 1
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 3472 AND year = 2007 AND channel = 'Footters' LIMIT 1
0.0146  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='3472' AND `active` = 1 AND year = 2007
0.0155  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='85' AND relp.team_id=2601 WHERE relp.in_squad=1 and mp.`match_id` = '3472' AND mp.year='2007' ORDER BY mp.`team` ASC, p.`role` ASC
0.0169  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='85' AND relp.team_id=2600 WHERE relp.in_squad=1 and mp.`match_id` = '3472' AND mp.year='2007' ORDER BY mp.`team` ASC, p.`role` ASC
0.0148  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '85' AND id_match = '3472'
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3472 AND extraId = 85 AND type_rel = 4
0.0149  SELECT * FROM futbol.calendars_lineups WHERE id = 3472 AND league_id = 85 AND year = 2007