¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CD Naval - Noja
Jornada 6
FINALIZADO
20
40
62 Pts. Elo
14º

96 Pts. Elo
5º

1-4
Sábado, 05 Octubre 2019, 18:00
0 - 1
 7' I. San Roman
J. Fernandez 35'
1 - 1
1 - 2
 44' Chori
1 - 3
 54' Chus
1 - 4
 73' D. Gutierrez

Eventos del partido

Goles

minuto 7'I. San RomanGol de I. San Roman
J. FernandezGol de
J. Fernandez
minuto 35'
minuto 44'ChoriGol de Chori
minuto 54'ChusGol de Chus
minuto 73'D. GutierrezGol de D. Gutierrez

Tarjetas

minuto 37'D. GutierrezT. Amarilla D. Gutierrez
JosemiT. Amarilla
Josemi
minuto 39'
minuto 63'ChusT. Amarilla Chus
minuto 84'VitoT. Amarilla Vito
minuto 89'D. OrtizT. Amarilla D. Ortiz
SufiT. Amarilla
Sufi
minuto 89'

Cambios

minuto 28'ÁlvaroSale del partido Álvaro
minuto 28'Jose AlbertoEntra en el partido Jose Alberto
minuto 51'Luis AngelEntra en el partido Luis Angel
minuto 51'G. RoselloSale del partido G. Rosello
SergioEntra en el partido
Sergio
minuto 57'
Diego CabezaSale del partido
Diego Cabeza
minuto 57'
R. GonzalezEntra en el partido
R. Gonzalez
minuto 60'
LaroSale del partido
Laro
minuto 60'
R. GutiérrezSale del partido
R. Gutiérrez
minuto 67'
M. GómezEntra en el partido
M. Gómez
minuto 67'
minuto 69'ChusSale del partido Chus
minuto 69'VitoEntra en el partido Vito
minuto 76'I. San RomanSale del partido I. San Roman
minuto 76'DavidEntra en el partido David

Alineaciones

CD Naval

CD Naval

4-4-2
Alineación Inicial
Suplentes
Noja

Noja

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,232,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  1.0179
Total Execution Time  1.0190
  CADENA URL  
/partido/Nava-Cd/Noja/2020
  GET DATOS  
$_GET['/partido/Nava-Cd/Noja/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0144   SELECT c.*, c.stadium as real_stadium, 2020 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2020 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Nava-Cd' AND dt2.basealias = 'Noja'
0.0111  SELECT c.*, 2020 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2020 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Nava-Cd' AND dt2.basealias = 'Noja'
0.0217  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 = 51274
0.0105  SELECT data1 FROM stats2020 t WHERE league_id = 51274 AND teamId = 6306001 and type = 33
0.0105  SELECT data1 FROM stats2020 t WHERE league_id = 51274 AND teamId = 6305991 and type = 33
0.0108  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '204828' and rp.type = 2020 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0108  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 204828 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0109  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 204828 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0106  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='204828' AND `active` = 1 AND year = 2020
0.0154  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='51274' AND relp.team_id=6306001 WHERE relp.in_squad=1 and mp.`match_id` = '204828' AND mp.year='2020' 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='51274' AND relp.team_id=6305991 WHERE relp.in_squad=1 and mp.`match_id` = '204828' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0108  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=204828 AND extraId = 51274 AND type_rel = 4
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=73 AND type_rel = 3
0.0109  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 73 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  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 (359051) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT rating1, rating2 FROM calendars_elo WHERE id=204828 AND league_id=51274 AND year=2020
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 204828 AND league_id = 51274 AND year = 2020