4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Amazonas FC - Nacional AM
Jornada 2
FINALIZADO
20
20

2-1
Sábado, 17 Febrero 2024, 01:00
Sassá 42'
1 - 0
D. Torres 58'
2 - 0
2 - 1
 77' Raimundinho
Amazonas FC

Amazonas FC

4-4-2
Alineación Inicial
Suplentes
Nacional AM

Nacional AM

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

SassáGol de
Sassá
minuto 42'
D. TorresGol de penalti
D. Torres
minuto 58'
minuto 77'RaimundinhoGol de Raimundinho

Tarjetas

minuto 20'QuadradoT. Amarilla Quadrado
Wendell FernandesT. Amarilla
Wendell Fernandes
minuto 21'
EzequielT. Amarilla
Ezequiel
minuto 75'
minuto 85'CassioT. Amarilla Cassio

Cambios

Wendell FernandesSale del partido
Wendell Fernandes
minuto 46'
minuto 46'R. De OliveiraSale del partido R. De Oliveira
minuto 46'RogerinhoEntra en el partido Rogerinho
minuto 46'Lucas RexSale del partido Lucas Rex
Fellipe BastosEntra en el partido
Fellipe Bastos
minuto 46'
minuto 46'EsdrasEntra en el partido Esdras
Rafael TavaresSale del partido
Rafael Tavares
minuto 66'
PhSale del partido
Ph
minuto 66'
PatricSale del partido
Patric
minuto 66'
JôEntra en el partido
Jô
minuto 66'
XavierEntra en el partido
Xavier
minuto 66'
EzequielEntra en el partido
Ezequiel
minuto 66'
William BarbioSale del partido
William Barbio
minuto 77'
minuto 77'PetersonSale del partido Peterson
Lucas SilvaEntra en el partido
Lucas Silva
minuto 77'
minuto 77'César JúlioEntra en el partido César Júlio
minuto 81'Denílson Da PazSale del partido Denílson Da Paz
minuto 81'CassioEntra en el partido Cassio
minuto 88'MarcosEntra en el partido Marcos
minuto 88'QuadradoSale del partido Quadrado

Otros

PatricAsistencia
Patric
minuto 42'
minuto 77'RogerinhoAsistencia Rogerinho
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,534,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.5919
Total Execution Time  0.5929
  CADENA URL  
/partido/Amazonas-Fc/Nacional-Am/2024
  GET DATOS  
$_GET['/partido/Amazonas-Fc/Nacional-Am/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0183   SELECT c.*, c.stadium as real_stadium, 2024 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 calendars2024 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 = 'Amazonas-Fc' AND dt2.basealias = 'Nacional-Am'
0.0151  SELECT c.*, 2024 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 calendars2024 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 = 'Amazonas-Fc' AND dt2.basealias = 'Nacional-Am'
0.0144  SELECT data1 FROM stats2024 t WHERE league_id = 75474 AND teamId = 6632817 and type = 33
0.0144  SELECT data1 FROM stats2024 t WHERE league_id = 75474 AND teamId = 6632813 and type = 33
0.0146  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '701196' and rp.type = 2024 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 = 701196 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0146  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 701196 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0145  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='701196' AND `active` = 1 AND year = 2024
0.0160  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='75474' AND relp.team_id=6632817 WHERE relp.in_squad=1 and mp.`match_id` = '701196' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0162  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='75474' AND relp.team_id=6632813 WHERE relp.in_squad=1 and mp.`match_id` = '701196' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=701196 AND extraId = 75474 AND type_rel = 4
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1513 AND type_rel = 3
0.0155  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1513 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0158  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 (957208,811722,585094,382243,328404) ORDER BY n.cover_points DESC, update_date DESC
0.0145  SELECT position FROM tables2024 WHERE team=6632817 AND league_id=75474 AND round=2
0.0145  SELECT position FROM tables2024 WHERE team=6632813 AND league_id=75474 AND round=2
0.0145  SELECT * FROM futbol.calendars_lineups WHERE id = 701196 AND league_id = 75474 AND year = 2024