4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Central Córdoba - JU Gualeguaychu
Jornada 31
FINALIZADO
10
30
900 Pts. Elo
8º

793 Pts. Elo
18º

1-0
Sábado, 06 Mayo 2017, 03:00
L. Sequeira 50'
1 - 0

Eventos del partido

Goles

L. SequeiraGol de
L. Sequeira
minuto 50'

Tarjetas

J. AguirreT. Amarilla
J. Aguirre
minuto 12'
minuto 53'E. NareseT. Amarilla E. Narese
minuto 83'N. EspindolaT. Amarilla N. Espindola
minuto 85'G. AdaT. Amarilla G. Ada

Cambios

O. MirandaEntra en el partido
O. Miranda
minuto 61'
J. AguirreSale del partido
J. Aguirre
minuto 61'
minuto 75'D. GalligoEntra en el partido D. Galligo
minuto 75'C. EscalanteSale del partido C. Escalante

Alineaciones

Central Córdoba

Central Córdoba

4-4-2
Alineación Inicial
Suplentes
JU Gualeguaychu

JU Gualeguaychu

4-4-2
Alineación Inicial
Suplentes


Partido televisado en...
Canal Medio Idioma País
TyC Sports PlayTyC Sports Play TV Latino ar

  USO DE MEMORIA  
5,930,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.4753
Total Execution Time  0.4763
  CADENA URL  
/partido/Central-Cordob/Juventud-Unida-Gualeguaychu/2017
  GET DATOS  
$_GET['/partido/Central-Cordob/Juventud-Unida-Gualeguaychu/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0303  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 = 33440
0.0148  SELECT data1 FROM stats2017 t WHERE league_id = 33440 AND teamId = 713280 and type = 33
0.0147  SELECT data1 FROM stats2017 t WHERE league_id = 33440 AND teamId = 713291 and type = 33
0.0147  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '240827' and rp.type = 2017 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 = 240827 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0146  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 240827 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0150  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 = 33440 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='240827' AND `active` = 1 AND year = 2017
0.0166  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='33440' AND relp.team_id=713280 WHERE relp.in_squad=1 and mp.`match_id` = '240827' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0172  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='33440' AND relp.team_id=713291 WHERE relp.in_squad=1 and mp.`match_id` = '240827' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=240827 AND extraId = 33440 AND type_rel = 4
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=192 AND type_rel = 3
0.0156  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 192 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  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 (1313516,1300740,1300585,1297543,1297675) ORDER BY n.cover_points DESC, update_date DESC
0.0146  SELECT * FROM futbol.calendars_lineups WHERE id = 240827 AND league_id = 33440 AND year = 2017