4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Unión Adarve B - DAV Santa Ana
Jornada 16
FINALIZADO
41
41
24 Pts. Elo
3º

72 Pts. Elo
5º

2-0
Domingo, 14 Enero 2024, 16:30
A. Rivas 50'
1 - 0
Marcos Gonzalez 76'
2 - 0

Eventos del partido

Goles

A. RivasGol de
A. Rivas
minuto 50'
Marcos GonzalezGol de
Marcos Gonzalez
minuto 76'

Tarjetas

minuto 22'A. GabanaT. Amarilla A. Gabana
M. MartinezT. Amarilla
M. Martinez
minuto 52'
P. MedinaT. Amarilla
P. Medina
minuto 66'
I. LizasoTarjeta Roja a
I. Lizaso
minuto 68'
minuto 68'M. GomezT. Amarilla M. Gomez
C. FernandezT. Amarilla
C. Fernandez
minuto 68'
C. EtcheverryT. Amarilla
C. Etcheverry
minuto 70'
minuto 72'C. DanielT. Amarilla C. Daniel
minuto 88'AngelT. Amarilla Angel
minuto 88'J. MontalbanTarjeta Roja a J. Montalban

Cambios

minuto 37'J. MontalbanSale del partido J. Montalban
minuto 37'C. DanielEntra en el partido C. Daniel
G. RodriguezSale del partido
G. Rodriguez
minuto 46'
Marcos GonzalezEntra en el partido
Marcos Gonzalez
minuto 46'
minuto 64'AngelEntra en el partido Angel
P. MironesSale del partido
P. Mirones
minuto 64'
minuto 64'J. San SegundoSale del partido J. San Segundo
minuto 64'M. MontalbanSale del partido M. Montalban
Marcos LlanosSale del partido
Marcos Llanos
minuto 64'
Emmanuel GomezEntra en el partido
Emmanuel Gomez
minuto 64'
minuto 64'F. GilSale del partido F. Gil
minuto 64'H. GalianoEntra en el partido H. Galiano
C. EtcheverryEntra en el partido
C. Etcheverry
minuto 64'
minuto 64'M. FornellsEntra en el partido M. Fornells
minuto 76'A. RamirezSale del partido A. Ramirez
minuto 76'N. GomezEntra en el partido N. Gomez
minuto 76'I. CorpasSale del partido I. Corpas
minuto 76'R. AbadEntra en el partido R. Abad
A. ValverdeEntra en el partido
A. Valverde
minuto 80'
SegoSale del partido
Sego
minuto 80'
S. MuñozSale del partido
S. Muñoz
minuto 85'
E. LozoyaEntra en el partido
E. Lozoya
minuto 85'

Alineaciones

Unión Adarve B

Unión Adarve B

4-4-2
Alineación Inicial
Suplentes
DAV Santa Ana

DAV Santa Ana

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,098,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.5340
Total Execution Time  0.5350
  CADENA URL  
/partido/Ad-Union-Adarve-B-Senior/Santa-Ana/2024?section=legal
  GET DATOS  
$_GET['/partido/Ad-Union-Adarve-B-Senior/Santa-Ana/2024']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73663 AND teamId = 6606370 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73663 AND teamId = 6606377 and type = 33
0.0024  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '518698' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 518698 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 518698 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0023  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='518698' AND `active` = 1 AND year = 2024
0.0082  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='73663' AND relp.team_id=6606370 WHERE relp.in_squad=1 and mp.`match_id` = '518698' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0028  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='73663' AND relp.team_id=6606377 WHERE relp.in_squad=1 and mp.`match_id` = '518698' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=518698 AND extraId = 73663 AND type_rel = 4
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=690 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 690 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (973908,950677,939069,907708,889402) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=518698 AND league_id=73663 AND year=2024
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 518698 AND league_id = 73663 AND year = 2024