4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
RC Deportivo - Arenteiro
Jornada 34
FINALIZADO
20
30
1216 Pts. Elo
1º

695 Pts. Elo
7º

2-2
Domingo, 28 Abril 2024, 19:00
David Mella 14'
1 - 0
Diego Villares 64'
2 - 0
2 - 1
 67' Luis Chacón
2 - 2
 94' M. Romay
RC Deportivo

RC Deportivo

4-4-2
Alineación Inicial
Suplentes
Arenteiro

Arenteiro

4-5-1
Alineación Inicial
Suplentes
RC Deportivo
Arenteiro
T. Amarilla
Asistencia
Gol
T. Amarilla
T. Amarilla
T. Amarilla
Sale del partido
Entra en el partido
T. Amarilla
Asistencia
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido
Gol
Gol
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Sale del partido
Entra en el partido
Entra en el partido
Gol

Eventos del partido

Goles

David MellaGol de
David Mella
minuto 14'
Diego VillaresGol de
Diego Villares
minuto 64'
minuto 67'Luis ChacónGol de Luis Chacón
minuto 94'M. RomayGol de M. Romay

Tarjetas

minuto 10'Germán NovoaT. Amarilla Germán Novoa
minuto 16'Álvaro RamónT. Amarilla Álvaro Ramón
José ÁngelT. Amarilla
José Ángel
minuto 25'
minuto 42'V. EsquerdoT. Amarilla V. Esquerdo
P. MartínezT. Amarilla
P. Martínez
minuto 51'

Cambios

minuto 46'Iván RamosSale del partido Iván Ramos
minuto 46'Álex CarderoEntra en el partido Álex Cardero
Raúl AlcainaEntra en el partido
Raúl Alcaina
minuto 64'
minuto 64'ManínSale del partido Manín
Iván BarberoSale del partido
Iván Barbero
minuto 64'
minuto 64'C. SantosEntra en el partido C. Santos
minuto 79'MarinoSale del partido Marino
minuto 79'MarkitosEntra en el partido Markitos
minuto 79'JordánSale del partido Jordán
minuto 79'VitraEntra en el partido Vitra
minuto 84'M. RomayEntra en el partido M. Romay
minuto 84'PibeSale del partido Pibe
YeremaySale del partido
Yeremay
minuto 85'
David MellaSale del partido
David Mella
minuto 85'
Berto CayargaEntra en el partido
Berto Cayarga
minuto 85'
DavoEntra en el partido
Davo
minuto 85'

Otros

Lucas PérezAsistencia
Lucas Pérez
minuto 14'
YeremayAsistencia
Yeremay
minuto 64'
0 Comentarios

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
FEF TV TV Castellano
TVG2 TV Castellano

  USO DE MEMORIA  
7,194,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.4518
Total Execution Time  0.4528
  CADENA URL  
/partido/Deportivo/Arenteiro
  GET DATOS  
$_GET['/partido/Deportivo/Arenteiro']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0108  SELECT data1 FROM stats2024 t WHERE league_id = 72358 AND teamId = 6587554 and type = 33
0.0108  SELECT data1 FROM stats2024 t WHERE league_id = 72358 AND teamId = 6587543 and type = 33
0.0118  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '193274' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0113  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 193274 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0110  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 193274 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0234  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72358 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='193274' AND `active` = 1 AND year = 2024
0.0418  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='72358' AND relp.team_id=6587554 WHERE relp.in_squad=1 and mp.`match_id` = '193274' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0179  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='72358' AND relp.team_id=6587543 WHERE relp.in_squad=1 and mp.`match_id` = '193274' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=193274 AND extraId = 72358 AND type_rel = 4
0.0111  SELECT /*115 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' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 193274 AND rel.extraId = 72358 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2024-02-28 18:00:00' AND n.creation_date<'2024-04-30 11:58:07' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 193274 AND league_id = 72358 AND year = 2024