4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Curicó Unido - Concepción
Jornada 7
FINALIZADO
10
30
995 Pts. Elo
3º

826 Pts. Elo
12º

2-0
Sábado, 08 Noviembre 2014, 00:30
  • Asistencia: 1.373 espectadores
F. Araya 9'
1 - 0
A. Camargo 26'
2 - 0
Curicó Unido

Curicó Unido

4-4-2
Alineación Inicial
Suplentes
Concepción

Concepción

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

F. ArayaGol de
F. Araya
minuto 9'
A. CamargoGol de
A. Camargo
minuto 26'

Tarjetas

minuto 37'G. ValleT. Amarilla G. Valle
minuto 39'N. RojasT. Amarilla N. Rojas
S. LeytonT. Amarilla
S. Leyton
minuto 61'
minuto 63'L. AlegríaT. Amarilla L. Alegría

Cambios

minuto 46'N. RojasSale del partido N. Rojas
minuto 46'J. BustosEntra en el partido J. Bustos
minuto 46'G. ValleSale del partido G. Valle
minuto 46'L. PachecoEntra en el partido L. Pacheco
minuto 64'M. FernándezSale del partido M. Fernández
minuto 64'P. SanhuezaEntra en el partido P. Sanhueza
C. GainzaEntra en el partido
C. Gainza
minuto 67'
S. LeytonSale del partido
S. Leyton
minuto 67'
M. CanalesEntra en el partido
M. Canales
minuto 74'
D. OpazoSale del partido
D. Opazo
minuto 74'
F. BechtholdtEntra en el partido
F. Bechtholdt
minuto 83'
M. GrandisSale del partido
M. Grandis
minuto 83'
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
5,904,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Match / Index )  0.2926
Total Execution Time  0.2940
  CADENA URL  
/partido_4914/Curico-Unido/Concepcion/2015/estadisticas?section=legal
  GET DATOS  
$_GET['/partido_4914/Curico-Unido/Concepcion/2015/estadisticas']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0267  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 = 4914
0.0136  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '1400210' and rp.type = 2015 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 1400210 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0126  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 1400210 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='1400210' AND `active` = 1 AND year = 2015
0.0139  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='4914' AND relp.team_id=88170 WHERE relp.in_squad=1 and mp.`match_id` = '1400210' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0134  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='4914' AND relp.team_id=88167 WHERE relp.in_squad=1 and mp.`match_id` = '1400210' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1400210 AND extraId = 4914 AND type_rel = 4
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=291 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 291 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (240925,148587,61846,61224,53563) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 1400210 AND league_id = 4914 AND year = 2015